To find a word in a sentence columnwise [Closed]

Question

To find a word in a sentence columnwise [Closed]

Report

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.

To find a word in a sentence columnwise
What are the steps to insert photo in word for resume - How-To - Word
Word full screen - How-To - Word
Find word in vim - How-To - Linux
How to word search on chromebook - How-To - Google Chrome
We can keep multiple version of a word document in a single file by using - How-To - Word

1 reply

Ask a question

Blocked Profile · Answer 1 · 2016-05-13T15:19:53-0400

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

To find a word in a sentence columnwise [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!