excel formula return dynamic list of names based on two criteria

Hi all,

Hoping someone can help.

I have the attached file with a list of movies i am trying to categorize.

In the backend tab I have hard coded the list of movies with their associated groupings, but have yet to find a formula that can automate this. From time to time, movies will be included and or excluded meaning it needs to be dynamic.

In Backend, Column 07 I wold like to to search for all movies from the Listings tab that meet the criteria Production A. In Backend P7 a similar formula to return a list of movies that meet Production B. Then I have sub sets, to group them by how many tapes exist. Production A has 300 tapes, again I have input them manually, but would like to search based on the Listing tab rows B & C to return the corresponding titles in column F.

Thanks for looking at my query.

Thank you so much, this is perfect

maybe something like this, 2 array formulas in 2 different set of colors......