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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nigel Toates" wrote in message
...
Whoever you are - Thanks you so much it worked great - Nigel

"RagDyer" wrote:

Try this in B1:

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

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nigel Toates" <Nigel wrote in message
...
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