looking for a lookup function

Z

Zak

I am trying to find a function that looks for a value in a list and then
return the value 2 cells below in the same colum of a list. What function can
I use in order to do that ?

Thanks

Zak

[email protected]
 
D

Domenic

Try...

=INDEX(A2:A100,MATCH(B2,A2:A100,0)+2)

....where B2 contains the lookup value.

Hope this helps!
 
Top