In I125 put

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

copy throughout column I as needed.

"cynichromantique" wrote:

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!