Thread: Lookup Hi / Lo
View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

Domenic wrote...
For the largest value less than or equal to the lookup value...

=LOOKUP(C16,B5:B13)


Since this would only work when B5:B13 were sorted in ascending order,

For the smallest value greater than or equal to the lookup value..

=MIN(IF(B5:B13=C16,B5:B13))

....

Richard Buttrey's formula,

=INDEX(B5:B13,MATCH(C16,B5:B13)+1)

would be more efficient, and it wouldn't need array entry.