|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
looking for a lookup function
Thanks, it did work.
Zak
"Domenic" wrote:
Try...
=INDEX(A2:A100,MATCH(B2,A2:A100,0)+2)
....where B2 contains the lookup value.
Hope this helps!
In article ,
Zak <Zak @discussions.microsoft.com wrote:
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
|