Less Than MATCH()

  • Thread starter Thread starter bgetson
  • Start date Start date
B

bgetson

Is there any way to use the MATCH() function to grab only values that
are less than the lookup value (instead of <=)? I've considered using
an IF() with ISNA(MATCH(**,**,0)) to setup separate conditions, but
I'm afraid of what it will to do my already long processing time.

Any help would be appreciated.
 
MATCH(**,**,1) returns the largest value that is less than **or equal
to** the lookup value. I'm trying to find the closest value that is
only less than my lookup. "-1" as the final parameter would probably
work instead, but I can't sort my data in descending order.
 
How about subtracting one from the lookup value?
e.g =MATCH(I2-1,G3:G12) assuming that the lookp array is sorted

Peter
 
Back
Top