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
10 Lookup
11 A1 Red, Blue, Green


multiple answers exist here, please follow below link to find one answer

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How can I have text autocomplete based on values previously entered in Column?

2) How can I clear cell after activating a routine when there is a change in value of a cell?

3) How can I set the fill color, font color and set number format of cell to date?

4) How can I avoid updates to cell values during macro execution?

5) Generate a list of unique values in Excel

6) How do I restrict user entry in ActiveX Text Box to just numeric values?

7) how do you enter multiple line in a cell in Excel

8) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

9) How to find the cell address from the column number in VBA

10) How to rename multiple sheets easily with VBA


Here the previous and next chapter