In article . com,
"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?
|