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!

"Andy" wrote:

Yes!! What is it you want the formula to do? You'll have to use an AND or an
OR.
Post back with what you want.

Andy.

"cynichromantique" wrote in
message ...
Is it possible to add additional words to a statement of this nature?

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique