Help writing an IF statement

C

cynichromantique

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!
 
J

JMB

In I125 put

=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")

copy throughout column I as needed.
 
C

cynichromantique

JMB,

Is it possible to add additional words to a statement of this nature?

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique
 
J

JMB

So if A125 contains any of those words, return an "*"?

IF(SUMPRODUCT(--ISNUMBER(SEARCH({"insurance","coverage","homeowners","annuity","blue cross","group"},A125,1))),"*","")
 
D

daddylonglegs

Perhaps just

=IF(COUNT(SEARCH({"insurance","coverage","homeowners","annuity","blu
cross","group"},A125)),"*",""
 
Top