Domenic wrote...
"Harlan Grove" wrote:
Richard Buttrey's formula,
=INDEX(B5:B13,MATCH(C16,B5:B13)+1)
would be more efficient, and it wouldn't need array entry.
But the formula would return #N/A if the lookup value was 10. Shouldn't
the correct answer be 14?
Boundary conditions. I'll grant that when C16 = 10, the smallest value
in the list greater than C16 should be 14 rather than #N/A. However, if
C16 were 300, what should the formula return? 0 (which your formula
does) or #N/A (which provides symmetry with the LOOKUP call when C16 =
10)? If it should return #N/A, then perhaps it should resemble
=IF(C16<B5,B5,INDEX(B5:B13,MATCH(C16,B5:B13)+1))
|