Previous Topic Next Topic

To find a word in a sentence columnwise

Closed
Saaj - May 13, 2016 at 03:07 AM
 Blocked Profile - May 13, 2016 at 03:19 PM
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.

Related:

1 response

Answer 1 / 1
Blocked Profile
May 13, 2016 at 03:19 PM
I think Vlookup will do what you are asking. Take a look at this:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?ui=en-us&rs=en-us&ad=us