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

A B
1 A1 Red
2 A1 Blue
3 A1 Green
4 A2 Purple
5 A2 Orange
6 A3 Yellow
7 A4 Black
8 A5 White
9
10 Lookup
11 A1 Red, Blue, Green

Answer:

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