Searching a list for keywords

[Rileydog]

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

 

[Domenic]

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

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!

 

[Rileydog]

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"