Excel Macro VBA - assistance with VLookup in VBA

Cancelled Posted 5 years ago Paid on delivery
Cancelled 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

Excel Excel Macros Excel VBA Visual Basic Visual Basic for Apps

Project ID: #18309488

About the project

21 proposals Remote project Active 5 years ago

21 freelancers are bidding on average $37 for this job

schoudhary1553

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

$100 USD in 1 day
(289 Reviews)
7.6
elqueabandona

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

$30 USD in 1 day
(215 Reviews)
6.9
periyannas

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 in 1 day
(74 Reviews)
5.9
diorisaguilar

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 in 1 day
(47 Reviews)
6.0
macroPOL

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 in 3 days
(70 Reviews)
5.7
aimefx

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 piv More

$25 USD in 1 day
(48 Reviews)
5.6
mail2vimalarora

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

$25 USD in 2 days
(94 Reviews)
5.8
abdolah2014

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 in 0 days
(38 Reviews)
5.3
beltran0404

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

$30 USD in 1 day
(101 Reviews)
5.3
vsprybhanu

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

$30 USD in 1 day
(66 Reviews)
5.2
VBAautomation

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

$50 USD in 1 day
(9 Reviews)
4.2
urielbaray

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

$20 USD in 1 day
(13 Reviews)
4.0
akritisood94

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

$25 USD in 1 day
(9 Reviews)
3.7
nvchien94

I am VBA expert, please contact me and share demo file u have. I can check and give advise for you. Thanks.

$25 USD in 0 days
(11 Reviews)
3.2
prakash1317

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

$70 USD in 2 days
(7 Reviews)
3.2
sardaaditya28

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

$25 USD in 1 day
(2 Reviews)
2.7
ielucerotrad1

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

$30 USD in 3 days
(2 Reviews)
1.4
MohitBansal93

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

$15 USD in 1 day
(0 Reviews)
0.0
mythtaker672

-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 in 1 day
(1 Review)
0.0