Summary
The Excel INDEX and MATCH formula will helps you to look through a more than one columns range and provide a result based on the mentioned criteria.
Purpose
To lookup values with INDEX and MATCH, using multiple criteria.
Syntax
{ = INDEX( range 1, MATCH ( 1, ( Criteria 1 = range 2) * ( Criteria 2 = range 3) , 0) )}
Example Explanation
In the above mentioned example we are looking up the values with INDEX and MATCH, using multiple criteria. The formula used in Cell G7 is:
Note: this is an array formula, and you must be entered with CTRL + SHIFT + ENTER.
Learn more Excel Formulas here
