To find a word in a sentence columnwise

Closed
Report
-
 Blocked Profile -
Hello,

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.