View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

=INDEX($B$14:$B$77,MATCH(MIN(IF($F$14:$F$7750,$F$ 14:$F$77)),$F$14:$F$77,0))

which must be confirmed with control+shift+enter, not just with enter.

Tim wrote:
Hi,

Is there any way that I can get lookup or an equivalent to use the next
value that is GREATER than the lookup value?
My data is not sorted and can not be sorted.

Other data is as follow:
Lookup value: 50
lookup_array:F14:F77
Resulting value: B14:B77

Tim