I have the following data:

I need to extract on a new column only the values (from the comma separated ones) which match one or more from the reference data.

I’ve tried Index and Match but doesn’t seem to work on ranges of reference data in combination with comma separated ones.