Lookup using a single cell with concatenated values and return values to a single cell as concatenated values

[norwoodkd2001]

I have a situation where we are asking users to provide the name or names of groups that can be assigned to an underwriting condition. They are to enter all the names that apply separated by a comma into one cell. I have a another tab that has the names and the associated ID's. I need to provide the ID's that relate to all the names entered in the group name cell to a single field separated by commas. Also not every condition will have multiple group names. Below is an example of the source sheet where the users are populating column B and column C being the expected outcome of the lookup and the sheet that contains the the Group Names and associated Group ID's.

Any help would be greatly appreciated!

 

[automike356]

Can you show how this is done using text join?

 

[automike356]

Hi,
Can you please show how below is done using TEXTJOIN?

 

[Fluff]

Please start a thread of your own. Thanks