Hi guys! I need some help with the following:

I have this excel file with many lines of customer date. every line has
a long description field. I need to identify if the description field
contains any of the following words: computer, mouse, keyboard and if
any of them appears to return 1 in another column. If let's say two of
the words appear in the same description, I still need to see 1. The
reason is for me to identify only individuals that have been hurt by
these. can you give me the formula that will do this?


--
ivanov_nv
------------------------------------------------------------------------
ivanov_nv's Profile: http://www.excelforum.com/member.php...o&userid=16229
View this thread: http://www.excelforum.com/showthread...hreadid=276398