Search range of text strings in array

Hi, pls see attached example.

Column E contains a range of search criteria.
For every instance where any of those strings is found in column B, the corresponding value in column F shall be output.

The list in column E may get quite long, so I need a variable/spilling approach.

Any help much appreciated.