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
|