Ben,

Welcome to the forum!
Its hard to give accurate information without knowing what your expected results are. Based on what you posted, it looks like you just want a 1 or 0 returned for each cell you're checking. If the cell contains any of the text strings you're looking for, the result would be a 1. If it doesn't contain any, the result would be a 0.

If that is the case, something like this should work:
=--(SUMPRODUCT(COUNTIF(range,"*"&$A$1:$A$3&"*"))>0)