Partial text in a cell as a lookup_value when using MATCH

Hi there! Do you know if it's possible to have a partial text in a cell as a lookup_value? Explaining:

The first table (red) is the reference and shows the names of the sellers and their places of work. Formulas were applied in the second table (green).
Formula for cell C12, for example, is =iferror(INDEX(C$1:C$8,MATCH(B12,$B$1:$B$8,0)),"XX"). What I'm trying to do: find if "John Smith" appears in the reference table and, if so, bring his places of work.

The issue: when a cell has two names (B14), the result is ERROR because the formula is looking for the employee "Richard Lopez,Mary Jane", not for "Richard Lopez" AND "Mary Jane". The expected result, in this case, should be the filling of cell J14 with "JP" (because of Richard Lopez) and cells P14, Q14, and R14 with "EG", "SA" and "AE" respectively (because of Mary Jane).

I already tried to include "*"&cell&"*", but it didn't work.

I would really appreciate it if someone could help me!

Hello! Thank you for your reply!

In your original dates are more situation of enumeration like "Richard Lopez,Mary Jane"? Yes
Is possible to have more than two in enumeration? Yes
It can be a situation where both have information different than XX for the same column in first table? No. All of them can have XX or the column title (ie: XX or US for US column, XX or CA for CA column, XX or GB for GB column, so on)

For context: I do not control the range B12:B15. This information comes from a huge database and it may have all names together in the same cell separated by commas (or a single name, which is most common.
So ideally, I would need a formula that works for all situations (with one, two, three, four, five, six names – or more, but this would be very rare).