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 Nam...
Absolute and relative references
Part One: • How to Use Relative an...
Part Two: • Mixed relative and abs...
Excel For Accounting course on LinkedIn Learning: / excel-for-accounting
Rockstar Excel website: rockstarexcel....
Newsletter for free tips on using Excel to make your life easier: rockstarexcel....
Book a free consultation: rockstarexcel....
Theme music by Michael Gordon Shapiro: mikemusic.com/