XLOOKUP with Multiple Conditions

XLOOKUP is one of the most useful formulas in Excel, and in this video, we explore how to use it with multiple conditions. You would use an XLOOKUP with multiple conditions if you want to satisfy more than one condition, and in this case, there are two, the month and the year. If the formula finds a match for both the month and the year, it will pull the corresponding data.

The XLOOKUP function is only available in Excel 365.

I also have a video exploring a single condition XLOOKUP scenario.

#xlookup #excel #formulas #office365 #excel365 #multiple #conditions

~-~~-~~~-~~-~
Please watch: "Excel Top 5 Flash Fill Excel"
   • Excel Top 5 Flash Fill Excel  
~-~~-~~~-~~-~