Is there a way to make this code
Return the corresponding information? I'm just getting the word "FALSE" even though the value is found on the 'NY' tab. Is there something wrong with the code?
Please Login or Register to view this content.
Thank you!
Application.WorksheetFunction.Vlookup
and error trap it
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Try to do this (should not be the 3 column 2 as well?)Please Login or Register to view this content.
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
I have excel 2003, will that still work?
I essentially want the function to do a vlookup through 2 sheets instead of just one sheet
if(isna(vlookup(sheet1)),vlookup(sheet2),vlookup(sheet1))
like that.
Could you help me break down what that formula is saying so I can understand it? This is pretty much what i'm looking for I think, but I may need to modify it a bit
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks