How to do an XLOOKUP with multiple variables / criteria

XLOOKUP is one of the most useful functions in Excel. But it doesn't work with multiple variables. Here I should you some workaround so that you're able to use multiple variables/criteria in your lookup.

Additional Resources:

How to standardize names in Excel:    • How to Standardize Names in Excel  

Absolute and relative references
Part One:    • How to Use Relative and Absolute Refe...  
Part Two:    • Mixed relative and absolute reference...  

Excel For Accounting course on LinkedIn Learning:   / excel-for-accounting  

Rockstar Excel website: https://rockstarexcel.com/

Newsletter for free tips on using Excel to make your life easier: https://rockstarexcel.com/newsletter/

Book a free consultation: https://rockstarexcel.com/book-a-free...

Theme music by Michael Gordon Shapiro: https://mikemusic.com/