matt-gilbert
Member
Hi, I have 2 values (date and number) that I need to do an approximate (less than) lookup on 2 columns. I have attached relevant file with my current VLOOKUP formulas highlighted which only have 1 lookup value (number). I'm trying to add the date to this formula so that the lookup range will change depending on the date. I have tried INDEX MATCH MATCH and XLOOKUP but they only appear to work for exact matches.
Any help would be appreciated. Thanks in advance.
Matt
Any help would be appreciated. Thanks in advance.
Matt