vlookup backwards

J

jtoy

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.
 
J

jtoy

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.
 
Top