negative column offset in vlookup

  • Thread starter Thread starter Jon
  • Start date Start date
J

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.
 
I believe the following should work for you:

With table array in A1:D7, 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(A1:D7,MATCH(F1,C1:C7,0),1)

If you have any questions, please post back.
 
Back
Top