VLOOKUP with multiple match results in Google Sheets
In Google Sheets, 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):
Formula in F6
=FILTER(C3:C12,F3=B3:B12)
A
B
C
D
E
F
G
1
2
Category
Apps
Revenue
Lookup value
3
Utility
Accord
$17,760.00
Game
4
Productivity
Blend
$17,990.00
5
Game
Fightrr
$11,649.00
Result
6
Game
Hackrr
$18,701.00
Fightrr
7
Productivity
WenCaL
$14,432.00
Hackrr
8
Utility
Misty Wash
$30,400.00
Kryptis
9
Game
Kryptis
$7,718.00
Perino
10
Productivity
Sleops
$11,022.00
11
Utility
Twenty20
$20,400.00
12
Game
Perino
$15,033.00
13
Show arrows
Separator
Procedure
- 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).
Result
The final formula is: =FILTER(C3:C12, F3=B3:B6)
The list of Apps appears in column F. FILTER returns all the Apps that are listed in the "Game" Category.