ExcelBanter - looking for a lookup function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - looking for a lookup function (https://www.excelbanter.com/excel-worksheet-functions/116333-looking-lookup-function.html)

Zak

looking for a lookup function

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

Domenic

looking for a lookup function

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

Zak

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

All times are GMT +1. The time now is 11:50 PM.