Excel Macro VBA - assistance with VLookup in VBA
$10-30 USD
Paid on delivery
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
Project ID: #18309488
About the project
21 freelancers are bidding on average $37 for this job
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 More
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 rega More
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.
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.
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
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 More
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 ....
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 becaus More
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 More
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 s More
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 sam More
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 S More
I am VBA expert, please contact me and share demo file u have. I can check and give advise for you. Thanks.
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 More
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 intereste More
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 inclui More
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, More
-Computer Engineer with 5 years of Excel VBA experience -I can do this within 1-2 hours -Continued free support even after project completion