View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thanks thanks is offline
external usenet poster
 
Posts: 48
Default Next highest Value

I have a list of values...
B1 0
B2 238
B3 263
B4 510
B5 585
B6 774
B7 931

=INDEX(R22:R28,MATCH(R21,R21:R28,1)) works except when there is an exact
match (i.e., 238)

I would like a formula that will, when I enter a value in A1 that if not in
the list will look up the next highest value.

A1=238 Formula returns 238 A1=24 Formula returns 263

Help I cant see the forest for the trees....