Check and mark a text if it contains a name from the list

[Vnokhbeh]

Hi community,

I hope you can help to find a proper solution.

I want to mark teams from table 1 that have a member from table 2.

Table 1 contains in a column the list of team members together. Each new member is presented in a new line in the cell.

On the table 2, I have names that should be searched for in teams from table 1. (Tables are attached)

Thank you for your help in advance!

[Qiu · Accepted solution]

@Vnokhbeh 
I use the Text to Column tools to parse your table 1 by delimiter "\n", which means new line.

Then Join with table to find out there is a match or not.