looking for a lookup function

[Guest]

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

(e-mail address removed)

 

[Domenic]

Try...

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

....where B2 contains the lookup value.

Hope this helps!

 

[Guest]

Thanks, it did work.

Zak

Try...

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

....where B2 contains the lookup value.

Hope this helps!