Range of keywords in range A2:A10
Cell to search is B2

=SUMPRODUCT(ISNUMBER(SEARCH($A$2:$A$10,B2))*1)

will tell you how many key words are found within cell.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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...