Determine if a cell has a word in it from another list

[julee.stein]

I have a list of descriptions in column A:

ex:
BYOSD
SPP
SNGL

In column C I have another list:

EX:
BYOSD
SNGL

I am trying to figure out a formula in column B that will tell me if column A contains any of the words that are in column C.

[PaulM100]

One of the following:
=LOOKUP(2^15,SEARCH($C$2:$C$3,A2),$C$2:$C$3)
or
=IF(ISNA(LOOKUP(2^15,SEARCH($C$2:$C$3,A2),$C$2:$C$3)),"Not found","Found")

[AlKey]

Enter in B2 and copy down

Please Login or Register  to view this content.

[julee.stein]

Take this a step further...my column A has additional verbiage in it.
I have a list of descriptions in column A:

ex:
BYOSD xxx
SPP xxx
SNGL xxxl

In column C I have another list:

EX:
BYOSD
SNGL

I am trying to figure out a formula in column B that will tell me if column A contains any of the words that are in column C.

[PaulM100]

Post #2, second formula will do that. Change Not found and found to No and Yes. Or do you want to return all words found?

[AlKey]

You should always provide accurate requirements.
Try this

Please Login or Register  to view this content.

v	A	B	C
1	Descrip		List
2	BYOSD xxx	BYOSD	BYOSD
3	SPP xxxx	SNGL	SNGL
4	SNGL xxxl	NA

[julee.stein]

Thank you all so much for you help! I got it figured out. I really appreciate it