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: https://www.seevid.ir/fa/w/OKxHcnJmTCw Absolute and relative references Part One: https://www.seevid.ir/fa/w/PrJF5cYKZhk Part Two: https://www.seevid.ir/fa/w/hotGj69Qd-w Excel For Accounting course on LinkedIn Learning: https://www.linkedin.com/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-discovery-session/ Theme music by Michael Gordon Shapiro: https://mikemusic.com/

• #education
• #excel
• #microsoft_excel
• #spreadsheet
• #xlookup
• #vlookup
• #lookup
• #sumifs
• #sumif
• #multiple_variables
• #variables
• #references
• #criteria
• #multiple_criteria
• #two_variables