Combining conditions in a filter formula, google spreadsheets?

Question

excel

Good afternoon.

Google spreadsheets has the following formula:

=FILTER('Select '!A:AB;('Select '!H:H = 'Conditions'!BS2)+('Select '!H:H = 'Conditions'!BS3)+('Select '!H: H = 'Conditions'!BS4)+('Select '!H:H = 'Conditions'!BS5)+('Select '!H:H = 'Conditions'!BS6)+('Select '!H:H = 'Conditions'!BS7)+('Select '!H:H = 'Conditions'!BS8)+('Select '!H:H = 'Conditions'!BS9)+('Select '!H:H = 'Conditions '!BS10)+('Select '!H:H = 'Conditions'!BS11))

The point is to display from the general "Selection" table all rows that have at least one value from the BS column in the "Conditions" table in the range of cells H: H.

The BS column in the "Conditions" table is constantly updated, the formula works only when adding each cell manually (+('Select '!H:H = 'Conditions'!BS9)+...), which is extremely inconvenient, because according to some conditions, the number of cells is more than 300...

Is it possible to simplify the formula so that the filter would search for non-empty cells of the entire BS column and display all rows that have matches?

Answer 1

You can use an outer range to specify a filter list

Example here https://oshliaer.github.io/qna?target=post/google-... - look for the "Data that matches the list" section