Download the featured file here https://www.bluepecantraining.com/perform-vlookup-xlookup-with-multiple-criteria/

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.
------------------------