Need Macro to match codes in excel 2007

[narendrabr]

Hi,

I have industry names,I need to match against keywords and put it in the next column corresponding to the industry.
If any common word matches between Industry and keyword I should write that keyword.

I have attached the sheet.

Thanks