I have a spreadsheet where I have a date that I am using in conjunction with an ID to match data in an array. The location ID is a unique (unsorted variable length and text based ID) is for a specific location and the corresponding date field is when the location was last analyzed. The location may be analyzed once per day (no more than that). New analyses are appended to the bottom of my lookup array. So I am trying to use the MATCH function and it works for when my lookup date is older than anything I am looking up, but when I have a lookup date newer than my lookup array for the given location it works however I don't know how to make it pull the most recent date that is less than or equal to the lookup date. In my code below you can see the equation (it is a CTRL+SHIFT+ENTER) and it works as it will resolve to ERROR for the cell but it won't pull the value. Any help? Thank you in advance.