View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bgetson@gmail.com is offline
external usenet poster
 
Posts: 23
Default Less Than MATCH()

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.