Please Help Guys!

[ivanov_nv]

Hi guys! I need some help with the following:

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

example:
AFTER BENDING AND MOVING COMPUTERS, FELT KNEE PAIN SPRAIN TO RIGHT KNE
is in cell H47. The formula will be written in H48. How do I search H4
if it contains computer, mouse, keyboard and in this case since i
does, to return 1 in H4

 

[Govind]

Hi,

Try

=IF(OR(ISNUMBER(SEARCH("*computers*",H47)),ISNUMBER(SEARCH("*mouse*",H47)),ISNUMBER(SEARCH("*keyboard*",H47))),1,0)

Regards

Govind.

 

[JE McGimpsey]

One way:

H48: =--(SUM(COUNTIF(H47,{"*computer*","*keyboard*","*mouse*"}))>0)