negative column offset in vlookup

[Jon]

I don't seem to be able to have a negative column offset
with my vlookup (Office XP). I seem to remember doing
this in past excel versions. Is there a new function or
workaround? Thanks.

 

[Vasant Nanavati]

There is no built-in way of doing that. Chip Pearson shows how to work
around this limitation:

http://www.cpearson.com/excel/lookups.htm#LeftLookup

 

[Laura Cook]

I believe the following should work for you:

With table array in A17, lookup value in F1, column you are looking up the
value in is "C", and the column you want the value returned from is "A" (or
column 1 in your table array):

=INDEX(A17,MATCH(F1,C1:C7,0),1)

If you have any questions, please post back.

 

[Jon]

Thanks, I'll check it out.
Jon

-----Original Message-----
There is no built-in way of doing that. Chip Pearson shows how to work
around this limitation:

http://www.cpearson.com/excel/lookups.htm#LeftLookup

--

Vasant





.