To find a word in a sentence columnwise [Closed]

 Blocked Profile -

I am trying to find a particular word in a set of sentences columnwise. For example cells A1:A100 has the sentences and cell B1:B20 has the some keywords like "company', 'Ltd' etc....

I need a formula which would allow me to find these keywords in each of the cells from A1:A100.

I have tried Isnumber function but somehow its giving me all results as False.

Please help.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!