Search within a cell for multiple defined terms

[fstone33]

Hi all,

I have quite a large spreadsheet with one column (A) of values. I have a second column (B) with pre-defined terms which could appear in the column A.
Ideally I would like to run a macro/VBA which would search within each cell of column A for each of the pre-defined terms in B and if a value occurs, return it or return some kind of indicator (True/Yes etc.)

I've been trauling through old threads and google but unfortunately I've had no luck! I turn to you excel wizards in the hope that someone can help me .

I've attached a basic example of what I mean. Any help would be greatly appreciated!

Many thanks,

Fred