on sheet1 Column A has text, which is a list of roles people are assigned. I want Column B to populate with the Name of the person, coming from sheet2.
on sheet 2 Column A has drop down menu where I can select what role each person will have (their names are in B Column).

in some cases there are multiple people that have the same role. I was thinking maybe the CONCATENATE function could help with that, some how gather up all the people with the same role, put them together in the same cell, separated by comas.


This is for a non profit, and will save us so much time! Thank you all very much in advance!