I deal with many manufactures providing our products. Each of the products
contain a different keyword. I have been able to isolate the keywords from
each of the product descriptions and assign a unique manufacturing code. But
here is the issue a can not solve.

In column "A" I have the list of product descriptions from each of the
manufacturers
In column "B" I need to perform the search listed below
In column "C" I have the list of keywords; i.e. Delta, Galaxy, etc.
In column "D" I have the associated manufacture code to the keywords

Because the list of product descriptions and keywords number in the hundreds
I can not hardcode all of the keywords into the formulas. Plus, the keywords
can be anywhere within the text string. In cell B2 I would like to search
cell A2 for the keyword from the range of C2:C200, and then assign the
associated manufacture code from the range of D2:D200. And, I would need to
copy this formula down column "B" so it can perform the same process against
the range of entries in A2:A500.

I've tried nested if, countif, vlookup, and array formulas, but can not get
them to work.

Any help and guidance would be very much appreciated.