Forum Discussion
Lookup help with non-exact dates
Hello, Hoping for some help on a lookup function to extract data using multiple conditions. I have a table like the one below showing item numbers with price changes in the left array (column c) at...
In G2:
=LET(d, MINIFS($B$2:$B$1000, $A$2:$A$1000, F2, $B$2:$B$1000, ">="&E2), IF(d=0, "", INDEX($C$2:$C$1000, MATCH(1, ($A$2:$A$1000=F2)*($B$2:$B$1000=d), 0))))
Fill down.