Trying to create a custom search bar for Google Sheets but it's not woring

Viewed 9

The idea to is to create a filter/search that will return results if the first condition is met or is left blank, if the second second condition is met or is left blank, if the third condition is met or is left blank.

Essentially, if any or all conditions are left blank then it will return results. My code instead returns data based on how many conditions have been set but won't return any data if one of them are left blank.

=SORT(FILTER('Video List'!B2:P161,('Video List'!E2:E161=C2),('Video List'!F2:F161=C3),('Video List'!G2:G161=C4),(REGEXMATCH('Video List'!I2:I161,C5)=FALSE),ISBETWEEN('Video List'!D2:D,C6,C7)),3,FALSE)

0 Answers
Related