comparing text against a text table for yes no result

[Nigel Toates]

I have a Column "A" containing 7 company names.
I have Column "C" of 3 words
I need in Column "B" to know the following formula.

Does "A1:A7" contain any of the words in C1:C3, and return the result "Yes"
or "NO" in "B1:B7"

The contain function means "that the words in C1:C3 can be found in any
(case) and anywhere in the string of Cell.

Example
A1 B1 C1
Al's Video Yes Video
Guitar shop No Audio
LA Video Yes AV
NYC elec No
Miami Audio Yes
AV Audio Yes
LA Audio CA Yes

Thanks in advance - Nigel

 

[RagDyer]

Try this in B1:

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($C$1:$C$3,A1)))),"Yes","No")

And copy down as needed.

 

[Nigel Toates]

Whoever you are - Thanks you so much it worked great - Nigel

 

[RagDyer]

Since I sign my posts as RD, I guess I'm RD.<bg>

You're welcome, and appreciate the feed-back.