How can I see if a cell contains a keyword from a list?
 

I want to determine if a keyword from a defined list can be found in a cell.
Let the following be my key words:

Keyword List

Excel
Access
Word
Water
Air
Fire
Earth

My cells are

Column A

MS Excel
Microsoft Acess
Access97
Excel2000
JDE
SAP
Earth, Wind, & Fire
etc...

In this example, I would want a function that returns a value "x" in
adjacent cells to column A if it can find a word from the keyword list in the
A cell. How can I do this?

Any help is greatly appreciated!

How can I see if a cell contains a keyword from a list?
 

Where your keywords are in A1:A7 and F1 is the text to search, try:

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(A$1:A$7,F1)))),"X","")

"HenryIV" wrote:

I want to determine if a keyword from a defined list can be found in a cell.
Let the following be my key words:

Keyword List

Excel
Access
Word
Water
Air
Fire
Earth

My cells are

Column A

MS Excel
Microsoft Acess
Access97
Excel2000
JDE
SAP
Earth, Wind, & Fire
etc...

In this example, I would want a function that returns a value "x" in
adjacent cells to column A if it can find a word from the keyword list in the
A cell. How can I do this?

Any help is greatly appreciated!

How can I see if a cell contains a keyword from a list?
 

Try something like this:

With
A1:A7 containing your posted list of value to test
And
F1:F7 containing the list of keywords

This formula returns "X" if A1 contains any of the keywords
B1: =IF(SUMPRODUCT(COUNTIF(A1,"*"&$F$1:$F$7&"*")),"X", "")

Copy that formula down as far as you need.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HenryIV" wrote:

I want to determine if a keyword from a defined list can be found in a cell.
Let the following be my key words:

Keyword List

Excel
Access
Word
Water
Air
Fire
Earth

My cells are

Column A

MS Excel
Microsoft Acess
Access97
Excel2000
JDE
SAP
Earth, Wind, & Fire
etc...

In this example, I would want a function that returns a value "x" in
adjacent cells to column A if it can find a word from the keyword list in the
A cell. How can I do this?

Any help is greatly appreciated!