Vlookup reversed

You can either use LOOKUP or INDEX/MATCH.


Regards, TMS

VLOOKUP can't do that...but, the standard approach is to use INDEX/MATCH
This regular formula finds the value of C1 in Col_B and returns the corresponding value from Col_A

Formula:

Please Login or Register  to view this content.

Does that head you in the right direction?

Originally Posted by telton

Hello Gurus and other Excel enthusiasts,

Can you use VLOOKUP to search for something in a column to the left of the reference.
As opposed to the right which is the norm.

Thanks

Yes, you can. This would require to a combination of VLOOKUP and CHOOSE functions.

=VLOOKUP(A8,CHOOSE({1,2},$B$2:$B$5,$A$2:$A$5),2,0)

	A	B
1
2	Apple	iPad
3	Microsft	Windows
4	Samsung	Galaxy 3
5	Amazon	Fire HD
6
7
8	iPad	Apple
9	Windows	Microsft
10	Galaxy 3	Samsung
11	Fire HD	Amazon

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

Thanks for the feedback!

Thanks for the rep