Older versions of Excel, array-enter (use Ctrl+Shift+Enter instead of plain Enter to commit the following formula to the sheet) into cells F5:F8 at once:
I like it. It is such a relief [for me] seeing movement away from the traditional spreadsheet. I tried a variation which carries the test against the criterion as a 2D array formula and only then breaks it down for the Lambda function equivalent of OR, using BYROW.
Code:
= FILTER(Name,
BYROW(Products=Criteria, ORλ))
where ORλ is given by:
= LAMBDA(x,OR(x))
Another option, using traditional Excel array formulas: [F5] : =IFERROR(INDEX(A$2:A$5,AGGREGATE(15,6,ROW(A$2:A$5)-ROW(A$1)/MMULT(COUNTIF(F$2,B$2:D$5),{1;1;1}),ROWS(F$5:F5))),"")
Drag it down. Blessings!