I'm trying to lookup a cell value from one worksheet into another one. If the value isn't in the worksheet, I want it to move on to the next nested statement. On the first Vlookup (underlined) function I'm getting an error when it tries to pass the value of L3 into Vlookup and search the sheet "ZBALEVEL3". I can't seem to find anything that will make this work. Any help would be greatly appreciated! THanks!
Please Login or Register to view this content.
Last edited by drinkmorewine; 05-05-2014 at 01:02 AM.
Instead of passing L3 in Vlookup use Range("L3").value so it would be like this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try something like this (not tested)
Please Login or Register to view this content.
Last edited by AlphaFrog; 05-05-2014 at 12:37 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Alpha,
With some minor adjustments (combined all 3 worksheets into 1 and added Step -1 to the for loop) this worked perfectly and condensed my code greatly. What is it about the .Value that worked in the VLookup function?
Thanks a million.
You're welcome.
I didn't notice the three worksheets. (It's late and I'm going to bed soon). Glad you adjusted for it.
What is the lookup value data type? (date, text, numbers). It may have been how you declared the L1, L2, L3 variables (type).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks