Thread: Lookup Hi / Lo
View Single Post
  #6   Report Post  
Domenic
 
Posts: n/a
Default

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?