Formula to add multiple names to one cell
I need to create a lookup to select multiple names from 1 sheet and add those names to 1 cell in another sheet:
Sheet 1: (names in multiple cells)
Name - Type
Rick - A
Jane - B
Bob - A
Sheet 2: (put qualified names in 1 cell)
Lookup names = 'Type A' and copy them into 1 cell.
I know VLOOKUP or an INDES + MATCH can find a name and place it in a cell, but i want to place multiple names in the same cell. can that be done ?