To evaluate multiple criteria we use the multiplication operation that works as the AND operator in array formulas. No matter whether you are using Excel or Google Sheets you can use the formula same way. The synergy between the functions are based on that.
The formulas will be.
The core of the formula is the VLOOKUP function configured for exact. If youre working with large data sets that would require thousands of lookups using the INDEX MATCH function will significantly decrease load time in Excel. The MATCH function is designed for one purpose. Normally an INDEX MATCH formula is configured with MATCH set to look through a one-column range and provide a match based on given criteria.