=if(isnumber(search( for multiple cells

I have seen many questions and answers similar to this, but can't seem to make it work for my particular situation. I need a formula (Not and Array) that will search through column B for specific terms and indicate those in columns C, D & E. I have attached an example of what I am trying to accomplish:
example.JPG

This is a very basic representation. I actually have about 30 different products in many combinations. The only outliers are the two terms in parentheses which can appear with any product. I figure the best way to go about this would be to first identify all of the cells without either of these terms and go from there. Any help would be appreciated. Thanks.

This will get you a start on what to look for.
Place this in C2, and drag down, adjust for the other columns

Formula:

Please Login or Register  to view this content.

Ultimately, if you create a chart and then us vlookup to search for the parameters, the formulas would not get to complicated.

Try this in C2, filled right and down.

=IF(ISNUMBER(SEARCH(C$1,$B2)),IFERROR(LOOKUP(2,1/((SEARCH($A$13:$A$14,$B2,SEARCH(C$1,$B2))-(SEARCH(C$1,$B2)+LEN(C$1)))=2),$B$13:$B$14),"X"),"")

You might run into problems with partial product names, for example, Apple will incorrectly return a match for Pineapple.

There are ways to fix that if needed.

edit:-

Formula with a fix for the Apple / Pineapple problem, if needed.

=IF(ISNUMBER(SEARCH(" "&C$1&" "," "&SUBSTITUTE($B2,";"," ")&" ")),IFERROR(LOOKUP(2,1/((SEARCH($A$13:$A$14,$B2,SEARCH(" "&C$1&" "," "&SUBSTITUTE($B2,";"," ")&" "))-(SEARCH(" "&C$1&" "," "&SUBSTITUTE($B2,";"," ")&" ")+LEN(C$1)))=2),$B$13:$B$14),"X"),"")