Forum Discussion
Solved
XLOOKUP to compare "Last Updated" of Container vs "Last Updated" of each of it's Contents
I'm looking to compare the last time a container was updated against the last time each of the items within said container were updated. Each container can be filled with 1-10 items from a list of...
That could be like
=IF( [@[Last_Updated]] < MAX( IFNA( INDEX( Items[Last_Updated], XMATCH(Table1[@[Item_1]:[Item_3]], Items[Item_Name] ) ), 0 ) ), "Yes", "No" )
That could be like
=IF( [@[Last_Updated]] <
MAX(
IFNA(
INDEX( Items[Last_Updated],
XMATCH(Table1[@[Item_1]:[Item_3]], Items[Item_Name] )
),
0 )
),
"Yes", "No" )
SergeiBaklan That did it! And I think I can piece together how and why. Thank you very much, Sergei!
