Vlookup to return multiple values in same cell in Excel
Traditionally the vookup will return the first value it can
match. I can return multiple values on different lines using an array formula
but this is not useful.
In the example below I have table array A1:B8. Lookup criteria in cell A11 and want to return MULTIPLE values from column B in cell B11.
Any suggestions? I would prefer to not use VBA if possible
1 A1 Red
2 A1 Blue
3 A1 Green
4 A2 Purple
5 A2 Orange
6 A3 Yellow
7 A4 Black
8 A5 White
11 A1 Red, Blue, Green
multiple answers exist here, please follow below link to find one answer