I am trying to determine whether text in a cell matches any text within an array.

Ex:

Cell A2 contains marketing copy that reads, "Get Product A and save big!".
Column B contains a list of the names of 200 different products; each product in the list is in its own cell.

I want to look at the marketing copy in cell A2 and if any of the products found in Column B are mentioned, return a tagging identifier (#prod, for example).

Note: It is possible that the marketing copy will not mention a product by name, and the match does not have to be case-sensitive.

Thanks for your help!