lookup finding the next value that is GREATER
 

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

=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

Thank You !

It functions. I try to do smth simmilar. but didn't confirm it with
ctrl+shift +enter so that's why I got confusing results.

"Aladin Akyurek" wrote:

=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