# lookup cells above or below a certain referenced number?

1. ## lookup cells above or below a certain referenced number?

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.

2. ## Re: lookup cells above or below a certain referenced number?

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

3. ## Re: lookup cells above or below a certain referenced number?

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),"")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1