Look up a value

[Guest]

Hello
I would like to look up for a specified value from a different position in the rows
Per exemple if we have
5
8
2
1

If I am looking for the value 5 in the first column, I would like Excel to give the value 2 rows after (c)

Please help me fast

Thanks a lot

 

[Frank Kabel]

Hi
try
=INDEX(B1:B100,MATCH(5,A1:A100,0)+2)

--
Regards
Frank Kabel
Frankfurt, Germany

Hello.
I would like to look up for a specified value from a different position in the rows.
Per exemple if we have:
5 a
8 b
2 c
1 d

If I am looking for the value 5 in the first column, I would like

Excel to give the value 2 rows after (c).

 

[A.W.J. Ales]

Ruzgar,

Assume : Your data range is in A1:B4 and the lookup value (5) is in cell E1
:

Then put =INDEX(B1:B4,MATCH(E1,A1:A4,0)+2,1) in the cell where you want
the result.

NB1 : If you use an European setting : replace , with ;
NB2 : This won't work with the last two cells in column A. You get #REF! if
cell E1 contains 2 or 1

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Hello.
I would like to look up for a specified value from a different position in the rows.
Per exemple if we have:
5 a
8 b
2 c
1 d

If I am looking for the value 5 in the first column, I would like Excel to

give the value 2 rows after (c).