I tried using vlookup in the attached workbook to give me the numbers you see in cells F4 and F5.
Can someone tell me what I'm doing wrong? (I've manually put the correct (desired) values in cells G4 and G5).
Thank you.
I tried using vlookup in the attached workbook to give me the numbers you see in cells F4 and F5.
Can someone tell me what I'm doing wrong? (I've manually put the correct (desired) values in cells G4 and G5).
Thank you.
Try this...
=INDEX($A$4:$A$34,MATCH(E4,$B$4:$B$34,0))
HTH
Regards, Jeff
as an explanation, vlookups return values to their right, not left (it can be done but it is more convoluted to use it to the left). So what you need is to use index/match, what Jeff gave you.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Or this
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
Thanks Sam for adding the explanation.
@jrtaylor,
As Sam pointed out about the traditional Left-to-Right syntax with the VLOOKUP, you can try this =VLOOKUP(E4,CHOOSE({1,2},B4:B34,A4:A34),2,0) as another option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks