To find a word in a sentence columnwise

Saaj - May 13, 2016 at 03:07 AM
 Blocked Profile - May 13, 2016 at 03:19 PM

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.


1 response