Help writing an IF statement

[Guest]

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!

 

[Guest]

In I125 put

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

copy throughout column I as needed.

 

[Guest]

JMB,

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

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique

 

[Guest]

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

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

 

[Peo Sjoblom]

Or use OR <g>

=IF(OR(ISNUMBER(SEARCH({"insurance","coverage","homeowners","annuity","blue
cross","group"},A125,1))),"*","")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[daddylonglegs]

Perhaps just

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

 

[Guest]

good call <g>