How to match multiple values from multiple look up values

Hello dear all,

I'm trying to find a formula which allows me to create look up between my 2 tables. Table1 contains a list of movies (single values) + for each movie the list of actors playing in it. Table2 is a list of single values of all actors contained in ListOfActors in table1.

table1                                                table2

My goal is to find a formula which allows me to match the values from table2 with the ListOfActors in table1. I have not been able to to achieve this with different kinds of formulas like CONTAIN, FIND, etc., since there are several actors playing in a single movie and most actors are playing in several movies.

And in a next step, in the reporting/dashboard view, I need to be able to slice/filter the list of movies with the single actor text values from table2.

I hope I explained my case in a clear matter!?

Thanks in advance to the community for any help! :)  ... I've been stuck here for hours and hours....

Cheers