Proper syntax for a VLOOKUP
What am I doing wrong here? Some of the selections look up correctly, while others do not. If you select Aviation, for example, cell A1 should read "01" but it reads "03". And, if you select Apartments 13R Concrete Construction, A1 reads "#N/A". Can anyone help?
Last edited by Ascott82; 07-02-2012 at 11:20 AM.
I have no idea, but this gives you the right result:
Formula:
Please Login or Register to view this content.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Hello and welcome to the forum,
You were missing the last piece of the puzzle:
Formula:Please Login or Register to view this content.
It tells vlookup that you only want exact matches (e.g. exact text in this case). Excel sometimes will get confused if it thinks this might be a number and try to get the closest one.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Awesome, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks