By default, the **VLOOKUP** function in Google Sheets looks up some value in a range and returns a corresponding value *only for the first match*.

However, you can use the following syntax with to look up some value in a range and return corresponding values for *all matches*:

=FILTER(C2:C11, E2=A2:A11)

This particular formula looks in the range **C2:C11** and returns the corresponding values in the range **A2:A11** for *all rows* where the value in **C2:C11** is equal to **E2**.

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

**Example: Use VLOOKUP to Return All Matches**

Suppose we have the following dataset in Google Sheets that shows information about various basketball teams:

Suppose we use the following formula with **VLOOKUP** to look up the team “Rockets” in column A and return the corresponding points value in column C:

**=VLOOKUP(E2, A2:C11, 3, FALSE)
**

The following screenshot shows how to use this formula in practice:

The **VLOOKUP** function returns the value in the “Points” column for the first occurrence of Rockets in the “Team” column, but it fails to return the points values for the other two rows that also contain Rockets in the “Team” column.

To return the points values for all rows that contain Rockets in the “Team” column, we can use the **FILTER** function instead.

Here’s the exact formula we can use:

=FILTER(C2:C11, E2=A2:A11)

The following screenshot shows how to use this formula in practice:

Notice that the **FILTER** function returns all three points values for the three rows where the “Team” column contains Rockets.

**Additional Resources**

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

Google Sheets: Use VLOOKUP with Multiple Criteria

Google Sheets: How to Perform a Reverse VLOOKUP

Google Sheets: How to Filter with Multiple Conditions