Match type?

M

M.A.Tyler

I have an application for an Index, Match function, however the match type I
would like to use (match type,1) requires the array to be in assending order.
My data is random, is there any way to accomplish this short of "helper"
column(s)?

Thanks in advance!
 
T

T. Valko

You'd need to provide more detail but as a starting point you can use an
array formula like:

=INDEX(rng1, MATCH(MAX(IF(rng2<=lookup_value,rng2)),rng2,0))
 
Top