INDEX MATCH Function with Multiple Criteria In Excel
The INDEX MATCH function is used to perform a two-way lookup to extract values from a data table. It is used as a substitute to vlookup multiple criteria in Excel before the introduction of the xlookup function.