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.
|