Need help with formula - partial lookup from table array

[FlashDota]

Hello everyone,

Attached pictures below for you to see the task as well.
At sheet 1 I have column C filled with multiple tags like "Showname,Jimmy O. Yang,comedy".
At sheet 2 I have column A with multiple names.
I want to see if the tag at column C contains text that is found at my second sheet in the names column (A).
Thanks for your time

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need help with formula - partial lookup from table array
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.