Excel Masters Help! Database Build (Masters)

[rzsapp]

I've been stumped on this one for a while and need some help from the masters.

Here's an example of what I'm trying to do:

I have criteria listed down one column

C1 = Apple
C2 = Banana
C3 = Pear

Down another column in individual cells I have

A1 = (John Apple Smith),
A2 = (Banana joe punch)
A3 = (all kids pear)

I want to list in down column B if the sting of text contains any of the criteria (apple, banana, pear).

I'm trying to move files for a project and I need to match the files to a last name folder.