To find a word in a sentence columnwise
Closed
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.
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:
- To find a word in a sentence columnwise
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
- How to insert a checkmark in word - Guide
- How to search a word in a website - Guide
- Number to word in excel - Guide
1 response
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
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?ui=en-us&rs=en-us&ad=us