searching for text within a cell

I want to create a formula which says Yes when the keyword or keywords which are typed into a cell are to be found within thext contained within a range of cells.

The example is below

A1 Yes

(this cell responds Yes if the keyword contained in cell B1 can be found anywhere in the text contained within cells C1:C3)

B1 Apples

C1 Pears and Oranges
C2 Limes and Peaches
C3 Apples and Strawberries

Again as above but A1 will respond No this time

A1 No

B1 Bananas

C1 Pears and Oranges
C2 Limes and Peaches
C3 Apples and Strawberries

What would be really great if I could include multiple keywords, i.e. A1 would respond Yes if keywords in B1 and B2 were to be found within C1:C3.

I know this is tough but someone may have the answer.

Looking forward to hearing from you and thanks in advance as usual.

Rgds
Okanem

If you wish to return "Yes" when C1:C3 contains both B1 and B2...

=IF(SUMPRODUCT(--(ISNUMBER(MATCH("*"&B1:B2&"*",C1:C3,0))),--(1-ISBLANK(B1:B2)))=2,"Yes","No")

If you wish return "Yes" when C1:C3 contains either B1 or B2...

=IF(SUMPRODUCT(--(ISNUMBER(MATCH("*"&B1:B2&"*",C1:C3,0))),--(1-ISBLANK(B1:B2)))>0,"Yes","No")

Hope this helps!

This is brilliant

Thanks a million to both of you!!!!

Okanem