VLOOKUP vs XLOOKUP with Multiple Cell Criteria

Download the featured file here https://www.bluepecantraining.com/per...

This video looks at three ways to perform a lookup using multiple cell criteria.  The methods are:

XLOOKUP (Office 365 or Excel Online)
VLOOKUP with helper column in lookup table
VLOOKUP with CHOOSE array formula.
------------------------