FIND(13;L73:L78)?

Question

Google Sheets

In order to select all rows in the filter that have the number 13 in column L, it is
enough to write like this

FILTER(
{Wonderful array};
FIND(13;PartNumber)
)

But if I want to select all rows that contain not only 13, but and 17 and 27, then this formula doesn't work anymore:

FILTER(
{Wonderful array};
OR(FIND(13;PartNumber);FIND(17;PartNumber);FIND(27;PartNumber))
)

And this one doesn't filter either :

FILTER(
{Fantastic array};
FIND(13;BatchNumber)+FIND(17;BatchNumber)+FIND(27;BatchNumber)
)

Question:

But which one still works?

Answer 1

OR() doesn't usually work very well in such cases
. Try this:

{ FILTER({Замечательный массив};FIND(13;НомерПартии));
FILTER({Замечательный массив};FIND(17;НомерПартии));
FILTER({Замечательный массив};FIND(27;НомерПартии)) }

In general, it is better to use QUERY () here