# Excel: Use VLOOKUP to Return Multiple Values Vertically

Often you may want to use the VLOOKUP function in Excel to return multiple values vertically.

Unfortunately, the VLOOKUP function can only look up some value in a range and return a corresponding value only for the first match.

However, you can use the following syntax to look up some value in a range and return multiple values vertically:

`=FILTER(B2:B12, D2=A2:A12)`

This particular formula returns all values from the range B2:B12 where the corresponding value in the range A2:A12 is equal to the value in cell D2.

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

## Example: Use VLOOKUP to Return Multiple Values Vertically

Suppose we have the following dataset in Excel that contains information about points scored by basketball players on various teams: Suppose we would like to look up “Mavs” in the team column and return each points value vertically.

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

```=FILTER(B2:B12, D2=A2:A12)
```

The following screenshot shows how to use this formula in practice: The formula correctly returns the values 22, 15, and 30.

Notice that each of these values represents a value in the points column that corresponds to the “Mavs” in the team column: Note: You can find the complete documentation for the FILTER function in Excel here.