Find Value Below Given Value in Range

[mucah!t]

Hi all,

I think this can't be that difficult, but can't find a solution for it.
In cell D2 in the example below the value 22 is given.

I'd like in cell D3 to find the value, 1 cell lower in the range of cell D2 [56]

Excel Workbook
	B	C	D
2			22
3
4	12
5	15
6	22
7	56
8	73
Sheet1

 

[VoG]

Try

=INDEX(B:B,MATCH(D2,B:B,0)+1)

 

[mucah!t]

Thanks VoG!