vlookup

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

Domenic

Assuming A1:F10 contains your table...

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

...where A15 contains your lookup value.

Hope this helps
 
Top