I have two excel sheets,

the first one is a parts list with two columns: column A equipment description and column B subcategory

the second sheet has two columns: column A keywords and column B subcategory

I want a function that will apply a subcategory to sheet 1 column B if the keywords in sheet 2 column A are found in Sheet 1 column A BUT the key words are mixed in with other words.

examples of the part descriptions are as follows:
wicket gate bolt
screw for wicket gate
8" wicket gate pipe

my keyword in this case would be "wicket gate"

I've tried using INDEX, LOOKUP, VLOOKUP but I've had no luck because the keywords are seldom by themselves.