Vlookup value to the right.
 

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??

Vlookup value to the right.
 

Use INDEX() and MATCH()
--
Gary''s Student - gsnu2007g

Vlookup value to the right.
 

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
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

Sinner wrote:

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??

--

Dave Peterson