Lookup number above value in a list
 

try:

=INDEX(A1:A5,MATCH(A8,A1:A5,1)+1)

HOWVER, you need to cater for situation (if it can exist) that your number
is than last in list OR < first in list.

HTH

"Sloth" wrote:

I need two formulas to lookup the numbers above and below a certain value in
a list. I know how to get the one below, but can't figure out the higher
number.

Example:
A
1 97745
2 98913
3 100067
4 101248
5 102416
6
7 =VLOOKUP(A8,A1:A5,1)
8 100000
9 =???

A7 results in 98913
A9 results in 100067

Lookup number above value in a list
 

I need two formulas to lookup the numbers above and below a certain value in
a list. I know how to get the one below, but can't figure out the higher
number.

Example:
A
1 97745
2 98913
3 100067
4 101248
5 102416
6
7 =VLOOKUP(A8,A1:A5,1)
8 100000
9 =???

A7 results in 98913
A9 results in 100067

Lookup number above value in a list
 

thanks. I like that a whole lot better than the INDIRECT formula I was using.

"Toppers" wrote:

try:

=INDEX(A1:A5,MATCH(A8,A1:A5,1)+1)

HOWVER, you need to cater for situation (if it can exist) that your number
is than last in list OR < first in list.

HTH

"Sloth" wrote:

I need two formulas to lookup the numbers above and below a certain value in
a list. I know how to get the one below, but can't figure out the higher
number.

Example:
A
1 97745
2 98913
3 100067
4 101248
5 102416
6
7 =VLOOKUP(A8,A1:A5,1)
8 100000
9 =???

A7 results in 98913
A9 results in 100067