Match type?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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