vlookup backwards
 

vlookup looks for the lookup value in the left most column of the table
array. Is it possible for it to look for the value in the right most column
of the table and return a value from a column to the left?

This is backwards from the vlookup statement - I realize. I can't tranpose
the columns in the table array because they needed to stay formatted in this
particular way.

Look for examples with INDEX combined with MATCH.

jtoy wrote:
vlookup looks for the lookup value in the left most column of the table
array. Is it possible for it to look for the value in the right most column
of the table and return a value from a column to the left?

This is backwards from the vlookup statement - I realize. I can't tranpose
the columns in the table array because they needed to stay formatted in this
particular way.

See the section on "Left Lookups" at
http://www.cpearson.com/excel/lookups.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jtoy" wrote in message
...
vlookup looks for the lookup value in the left most column of
the table
array. Is it possible for it to look for the value in the right
most column
of the table and return a value from a column to the left?

This is backwards from the vlookup statement - I realize. I
can't tranpose
the columns in the table array because they needed to stay
formatted in this
particular way.

Thanks for the link Chip - this was the first option I tried and the
suggestion seemed very easy to follow, but for some reason I couldn't get it
to work. It suggested using the OFFSET and MATCH functions. I did however get
it to finally work with the INDEX and MATCH function.

"Chip Pearson" wrote:

See the section on "Left Lookups" at
http://www.cpearson.com/excel/lookups.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jtoy" wrote in message
...
vlookup looks for the lookup value in the left most column of
the table
array. Is it possible for it to look for the value in the right
most column
of the table and return a value from a column to the left?

This is backwards from the vlookup statement - I realize. I
can't tranpose
the columns in the table array because they needed to stay
formatted in this
particular way.