You can use the following syntax with INDEX MATCH in Google Sheets to return multiple results:

=IFERROR(INDEX($B$2:$B$11,SMALL(IF($D$2=$A$2:$A$11,ROW($A$2:$A$11)-ROW($A$2)+1),ROW(1:1))),"")

This particular formula returns all of the values in the range **B2:B11** where the corresponding value in the range **A2:A11** is equal to the value in cell **D2**.

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

**Example: Use INDEX MATCH to Return Multiple Results in Google Sheets**

Suppose we have the following dataset in Google Sheets that shows the team and player name of various basketball players:

Suppose that we would like to return the names of each player on the Mavs team.

To do so, we can specify “Mavs” in cell **D2** and then type the following formula into cell **E2**:

=IFERROR(INDEX($B$2:$B$11,SMALL(IF($D$2=$A$2:$A$11,ROW($A$2:$A$11)-ROW($A$2)+1),ROW(1:1))),"")

Once we press **Enter**, the name of the first player on the Mavs team will be returned:

We can then drag and fill this formula down to the remaining cells in column E to display the names of each player on the Mavs team:

Notice that the names of each of the four players on the Mavs team are now shown.

Note that if you change the name of the team in cell **D2**, the names of the players shown in column E will change accordingly:

The names of each of the three players on the Heat team are now shown.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: Use IF Function with INDEX MATCH

Google Sheets: Use SUM with INDEX MATCH

Google Sheets: Use INDEX MATCH with Multiple Criteria