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.