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...
Single dynamic array formula, with names derived from headers using 'create from selection'
= MAP(Posting_Date, Item_Number,
LAMBDA(d, item,
LET(
changeDates, IF(Item_Num=item, Date),
XLOOKUP(d, changeDates, Price, ,-1)
)
)
)