Find Jobs
Hire Freelancers

Excel Macro VBA - assistance with VLookup in VBA

$10-30 USD

Cancelado
Publicado há mais de 5 anos

$10-30 USD

Pago na entrega
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running a excel macro. The workbook has 2 sheets Sheet 1 - contains the data that is being corrected Sheet 2 - contains the lookup table with the correct values Ie. Sheet 1 Sheet 2 Sheet 1 Correction Country Look up Correct to U.S.A U.S.A UA USA USA US U.S.A U.S.A US Keep getting the following msg Run-time error '1004' Unable to get the VLookup property of the WorksheetFunction class This is the offending line of code as far as I know NewValue = [login to view URL](LookupValue, LookupRange, 2, False) Timezone is EST Time requirement - on 12/7 or 2/8. The goal is to 1) Get this routine to work properly 2) If possible - have the lookuptable in a separate workbook, instead of the same workbook. Thanks
ID do Projeto: 18309488

Sobre o projeto

21 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
21 freelancers estão ofertando em média $37 USD for esse trabalho
Avatar do Usuário
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps. Please ping me for more discussion.
$100 USD em 1 dia
5,0 (289 avaliações)
7,6
7,6
Avatar do Usuário
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$30 USD em 1 dia
5,0 (215 avaliações)
6,9
6,9
Avatar do Usuário
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.
$30 USD em 1 dia
5,0 (74 avaliações)
5,9
5,9
Avatar do Usuário
Hi.. It's probably that the VLookUp is not finding a match and it's throwing that error. Let me check the worksheet to confirm that.
$30 USD em 1 dia
4,9 (47 avaliações)
6,0
6,0
Avatar do Usuário
Hello, I am Excel and VBA expert. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$30 USD em 3 dias
5,0 (70 avaliações)
5,7
5,7
Avatar do Usuário
Hi, I am an expert in excel, VBA, MySQL and power bi. Use excel power query and excel power pivot instead of VBA code. in power query, you can automate replacing, correcting and cleaning the data. and in power pivot, you can look up the values and can create the data model. I am ready to start your project immediately, please let me know more about the project details in chat. Thanks
$25 USD em 1 dia
4,8 (48 avaliações)
5,6
5,6
Avatar do Usuário
Hello, I am ready to discuss project with you. Being experienced in working on several Excel/VBA/Macro related projects, I can quickly help you in getting it done as per your mentioned details in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$25 USD em 2 dias
4,8 (94 avaliações)
5,8
5,8
Avatar do Usuário
hi I am an excel-vba Expert and I can help you with your project start the chat to discuss more ......................... ready to start now ....
$35 USD em 0 dia
5,0 (38 avaliações)
5,3
5,3
Avatar do Usuário
Hello, I am Luis and it will be my pleasure to assist you with your Excel/VBA project. I can realize that maybe will be a better way to do this you are needing because maybe VLOOKUP is not working properly because you have a lot of data or maybe you are missing something in your LOOP/FOR process. Please contact me by chat and then we could discuss further details about your project! Kind regards, Luis Romero
$30 USD em 1 dia
4,9 (101 avaliações)
5,3
5,3
Avatar do Usuário
Hi, I have read your instruction carefully. I suggest VBA code rather than Formula (VLookup). Because VBA code will provide you lot of things to customize your workbook as per your requirement. While Formula is used to only specific things. I can create macro to lookup specific value on Sheet2 and make correction on sheet1 according to your condition. Macro will give you single click solution and error free result. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$30 USD em 1 dia
4,7 (66 avaliações)
5,2
5,2
Avatar do Usuário
Hi, I am a professional VBA developer with 8 years of corporate experience. I have excel command on MS Access, MS Excel, MS SQL server database programming and developing. I can fix the issue right now. Please share the excel file or I can join you live to complete the task. Thank you
$50 USD em 1 dia
4,9 (9 avaliações)
4,2
4,2
Avatar do Usuário
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$20 USD em 1 dia
5,0 (13 avaliações)
4,0
4,0
Avatar do Usuário
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$25 USD em 1 dia
4,7 (9 avaliações)
3,7
3,7
Avatar do Usuário
I am VBA expert, please contact me and share demo file u have. I can check and give advise for you. Thanks.
$25 USD em 0 dia
5,0 (11 avaliações)
3,2
3,2
Avatar do Usuário
I'm confident to work on this with my similar experience. I'll take full responsibility to complete this work on time & quality. I will update you on the status of work timely until I finish the task. I'm available to start from now. Thanks
$70 USD em 2 dias
4,8 (7 avaliações)
3,2
3,2
Avatar do Usuário
Hi with over 4 years of experience in Excel VBA, macro I can surely fix this issue within a day or two. I have built several automated models for the clients previously. Let me know in case you are interested, we can discuss this over chat before finalizing. Thanks, Aditya Sarda
$25 USD em 1 dia
5,0 (2 avaliações)
2,7
2,7
Avatar do Usuário
BETTER IDEA! Using VLOOKUP is not very flexible. I can program a VBA code to search in any data matrix. I already have similar code for flexible searching where you can insert different option in the same search incluiding logical concatenators. ie: Must contain "abc"and "12" + must not contain "z" or "w" etc. I'm an engineer with advanced working knowledge and experience in Excel VBA and VBA interaction between different software (Word, excel, powerpoint, access, autocad etc.). Proficient coder in VB.Net, C#, Python, VB6. I value and honor customer service so I’m responsible for helping, small adjustments, unnoticed corrections or bug fixes even after the project has been paid for and closed.
$30 USD em 3 dias
5,0 (2 avaliações)
1,4
1,4
Avatar do Usuário
With over 5 years of experience, I am the PERFECT contractor for your project. I specialize in excel, tablue, sql, admin/clerical support, and transcription. My skills include (but not limited to) Microsoft Word, Microsoft Excel, Wordpress, Tablue, VBA and Internet savvy. I am well-rounded, reliable, hardworking, detail-oriented and a quick learner with good communication skills. All tasks are completed in a timely-manner with great efficiency and accuracy. I dedicate myself on providing the highest quality and 100% satisfaction of work
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
-Computer Engineer with 5 years of Excel VBA experience -I can do this within 1-2 hours -Continued free support even after project completion
$10 USD em 1 dia
5,0 (1 avaliação)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Hilliard, United States
0,0
0
Método de pagamento verificado
Membro desde jul. 20, 2018

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.