LOOKUP

XLOOKUP is one of the most useful tools in Excel, but doesn’t allow you to use multiple variables/criteria.

Here I show three ways to make this work:
– Use a SUMIFS
– Use a helper column
– Nest an XLOOKUP inside another XLOOKUP