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
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