View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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