Vlookup value to the right.

[Sinner]

Hi,


vlookup is used to calculates value based on value found in left most
column of a table.
How can we use it to find a vlaue if it's on the right side??

 

[Gary''s Student]

Use INDEX() and MATCH()

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble