Hi,

I have this formula:

Formula: copy to clipboard

=FILTER(Movie_Data,(ISNUMBER(SEARCH(B2,Table1[Genre Group])))*
(IF(B3="",1,ISNUMBER(SEARCH(B3,Table1[Genre Group]))))*
(IF(B4="",1,ISNUMBER(SEARCH(B4,Table1[Top 5 Actors]))))*
(IF(B5="",1,Table1[Main Director]=B5)),"")


Can 2 more criteria be added to filter movies? This should be "AND" condition so that all criteria apply.

Thank you for your help