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!

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))


--
Biff
Microsoft Excel MVP


"M.A.Tyler" <Great Lakes State wrote in message
...
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!