Tags: anothe, excel, exist, exists, keyword, keywords, microsoft, msdn, searching, software, specifically

Searching a list for keywords

On Microsoft » Microsoft Excel

2,160 words with 2 Comments; publish: Wed, 04 Jun 2008 12:00:00 GMT; (306187.50, « »)

Hello,

I have a list of keywords and I want to see if they exist in anothe

list of data. Specifically, I want to see if the keyword exists in an

of the fields in each row and return a TRUE/FALSE in a new column

eg.

Keyword-

Biotech

Project Title

Biotechnology in Canada

Global Warming in 2004

The first title would be TRUE and the second FALSE. All the function

I have found look for an exact match ((LIKE, EXACT) and cannot search

string of text for a particular word.

Is this possible?

Thank

--

Message posted from http://www.ExcelForum.com

All Comments

Leave a comment...

  • 2 Comments
    • On 5/4/04 3:46 PM, in article Rileydog.15qymq.excel.questionfor.info.excelforum-nospam.com,

      "Rileydog >" <<Rileydog.15qymq.excel.questionfor.info.excelforum-nospam.com> wrote:

      > Hello,

      > I have a list of keywords and I want to see if they exist in another

      > list of data. Specifically, I want to see if the keyword exists in any

      > of the fields in each row and return a TRUE/FALSE in a new column

      > eg.

      > Keyword-

      > Biotech

      > Project Title

      > Biotechnology in Canada

      > Global Warming in 2004

      > The first title would be TRUE and the second FALSE. All the functions

      > I have found look for an exact match ((LIKE, EXACT) and cannot search a

      > string of text for a particular word.

      > Is this possible?

      > Thanks

      > --

      > Message posted from http://www.ExcelForum.com/

      >

      Try,

      =IF(ISNUMBER(SEARCH("biotech",A1)),"True","False")

      If you want it to be case sensitive, use FIND instead of SEARCH,

      =IF(ISNUMBER(FIND("Biotech",A1)),"True","False")

      Hope this helps!

      #1; Wed, 04 Jun 2008 12:02:00 GMT
    • Thanks!

      I tried that and it works great for one keyword at a time. I have

      list of 80 keywords though that I want to be able to use all at once.

      Is it possible to edit the formula to have it read from a list o

      keywords?

      =IF(ISNUMBER(SEARCH(-READ FROM LIST- ,A1)),"True","False"

      --

      Message posted from http://www.ExcelForum.com

      #2; Wed, 04 Jun 2008 12:03:00 GMT