Forum Discussion
Solved
nested xlookup
Hello My input data is my desired output is how to achieve this result, basically, i need to get the values for whatever date i enter in the column header. it needs to pull t...
See the attached version.
KalyanPrasad Alternatively, you can try SUMIFS with XLOOKUP here as well:
=SUMIFS(XLOOKUP([@Report], Table1[#Headers], Table1), Table1[Date], B$1)
SUMIFS criteria is not type specific, so a text string that looks like a valid date will be interpreted as a date. Please see the attached workbook if needed, which also contains one possible dynamic array solution for MS365...