Vlookup
Hello,
I have a small VLOOKUP situation. I have a small table Column A has Product Name and Column B has Parts Number. I am trying to create a VLOOKUP by utilizing the Parts Numberto give me the Product Name and it is giving me an #NA instead of the Product Name. I have attached an image with my table and the formula. Could someone please help.
Thanks,
Rafa
vlookup only works left to right
you need to replace with an
index / match
=index(A:A, match(d2,B:B.0))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You can also use reversed VLOOKUP
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks