VLOOKUP with multiple match results in Excel
In Excel, VLOOKUP cannot natively return multiple values from multiple matches.
Use FILTER to look up all the matches and return the corresponding values.
In this example, you'll find Apps that are listed in the same category (Game):
- Enter =FILTER in cell F6, where you want the Apps to appear.
- Enter the search range C3:C12, which is the data range containing the Apps values.
- Enter the Condition F3=B3:B6, which filters rows of the search range where the value in column B (Category) equals the lookup value in F3 (Game).
The final formula is:
The list of Apps appears in column F. FILTER returns all the Apps that are listed in the "Game" Category.