Try...

I2, copied down:

=IF(ISNUMBER(MATCH(A2,{"Coverage","Homeowners","An nuity","Blue
Cross","Group"},0)),"*","")

or

=IF(ISNUMBER(MATCH(A2,$J$2:$J$6,0)),"*","")

....where J2:J6 contains the list of 'specific words'.

Hope this helps!

In article ,
cynichromantique wrote:

I have a spreadsheet with over 30000 items listed in column A. I would like
to be able to find specific column "A" cells with specific words and place an
asterick in column "I" to designate that. So if column "A" contains any of
the words I have listed, I want to place an asterick in the corresponding "I"
cell.

Thanks!