View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HenryIV HenryIV is offline
external usenet poster
 
Posts: 1
Default 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!