| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keyword search | Excel Discussion (Misc queries) | |||
| Insert text in Cell A1 based on keyword criteria | Charts and Charting in Excel | |||
| Finding a Keyword in a Cell | Excel Discussion (Misc queries) | |||
| Sharing with Keyword | Excel Discussion (Misc queries) | |||
| search by keyword | Excel Discussion (Misc queries) | |||
Linear Mode
