# Excel: How to Use INDEX MATCH with 3 Criteria

You can use the INDEX and MATCH functions in Excel to look up a specific value in one column and return a corresponding value in another column.

You can use the following syntax with INDEX and MATCH to look up a value in one column where specific criteria are met in 3 other columns:

`=INDEX(D2:D10,MATCH(1,(G1=A2:A10)*(G2=B2:B10)*(G3=C2:C10),0))`

This particular formula looks up the value in the range D2:D10 where the following three criteria are met:

• A2:A10 is equal to the value in cell G1
• B2:B10 is equal to the value in cell G2
• C2:C10 is equal to the value in cell G3

The following example shows how to use this syntax in practice.

## Example: How to Use INDEX MATCH with 3 Criteria in Excel

Suppose we have the following dataset in Excel that contains information about various basketball players: Suppose we would like to look up the points value of the player that meets the following three criteria:

• Team = Mavs
• Position = Guard
• All-Star = No

We can type the following formula into cell G4 to do so:

`=INDEX(D2:D10,MATCH(1,(G1=A2:A10)*(G2=B2:B10)*(G3=C2:C10),0))`

The following screenshot shows how to use this formula in practice: We can see that the value in the points column that corresponds to Mavs in the team column, Forward in the Position column and No in the All-Star column is 18.

We can manually verify this is correct by identifying the player that meets these three criteria: We can see that the player on the Spurs team with a position of Forward and an all-star status of No does indeed have 18 points.

Feel free to change the criteria in cells G1, G2 and G3 to look up the points value of a player who meets three different criteria.