lookup cells above or below a certain referenced number?

[tlapointe1970]

If I have a column of unique numbers and want to reference a cell that appears above or below a referenced number, is this possible?

A
132
11
100
90
75
60
190


I want to know what number appears 3 cells below 90? Is there a formula for that? Please advise. Thank you.

[JieJenn]

Assuming your list is in Column A and your lookup value is in C1, in D1 enter =IFERROR(INDEX($A$1:$A$7,MATCH($C$1,$A$1:$A$7,0)+ROW()),"") and drag it down to D3

[icestationzbra]

if A2 through A8 have the numbers, B2 is the reference cell, then the value in the 3rd cell below the value referenced by B2 can be found using:

C2: =IFERROR(INDEX(A2:A8,MATCH(B2,A2:A8,0)+3),"")