Matching multiple rows of industries with the tag given in different columns to return the name of the company that deals in.

[Pcubed]

Plz help

 

[Dermot]

I suggest you try explaining that again, it wasn't at all clear to me

 

[Pcubed]

Suppose there are 20 columns which contains a word or two about any industry. There is a separate list of industries in a column. My question is that if a word from the list of industries matches with a word placed in different columns. Then it should reflect the name of the industry.