vlookup

  • Thread starter Thread starter tlee
  • Start date Start date
T

tlee

I have a list of numbers. I want to do a lookup on it. once i find it, the
one to that the information five cells ove and one cell down.

does anybody know how i can do that.

thanks in advance.
 
Assuming A1:F10 contains your table...

=INDEX(F1:F10,MATCH(A15,A1:A10,0)+1)

...where A15 contains your lookup value.

Hope this helps
 
Back
Top