Assuming that A2 contains the text string, and G2:G6 contains the
keyword table, try...

=IF(A2<"",LOOKUP(9.99999999999999E+307,SEARCH(" "&$G$2:$G$6&" ","
"&A2&" "),$G$2:$G$6),"")

Or, if you prefer, try...

=IF(A2<"",IF(ISNUMBER(LOOKUP(9.99999999999999E+30 7,SEARCH("
"&$G$2:$G$6&" "," "&A2&" "))),1,""),"")

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions


In article ,
gpurdue wrote:

I have misplaced a formula that I had in the past to accomplish the
following: A cell contains a string of text and within that text are certain
keywords that I need to determine if exists within a table/array of critical
keywords. For example if I have a text field that contains the phrase
"property taxes are due Jan 1" and in have a keyword table/array that
contains the word "taxes" as one of the entries I would like to flag that
particular entry. I believe I had accomplished this with the use of the
search formula in the past but I have been unable to reproduce. Any
assistance would be appreciated as I have exhaused my knowledge...