Forum Discussion
Solved
Get latest value from table based on multiple criteria
Hi all This one is driving me mad. Can anyone suggest a formula that will always get the latest value (and ignore blank values) from a table? Week -----Period ------Value 1 1...
Since I no longer use traditional spreadsheets, the Excel 365
=XLOOKUP(1, (Week=4)*(Period=1)*ISNUMBER(Value), Value,,,-1)
would be my preference, but
=LOOKUP(2, 1/(Week=4)/(Period=1)/ISNUMBER(Value),Value)
should still work.
Since I no longer use traditional spreadsheets, the Excel 365
=XLOOKUP(1, (Week=4)*(Period=1)*ISNUMBER(Value), Value,,,-1)
would be my preference, but
=LOOKUP(2, 1/(Week=4)/(Period=1)/ISNUMBER(Value),Value)
should still work.
Super thanks, this was what I was already using minus the isnumber check! thanks again