Siva and surya
 

COL A COl B COL C COL D
COL E
Hypothyroidism Leg pains ok
Birth Control Headache hysteroctmy
check
Asthma
Asthma
Birth Control
Asthma
Asthma
Hypothyroidism
Angina
Duodenitis


Hi can anyone let us know which formula will give me whether the value in
column A is present in Col B or Col C or Col D.
For example in Col A Hypothyroidism is present and exits in Col C, so COL E
value will be ok else need to be check

Siva and surya
 

=IF(OR(ISNUMBER(MATCH(A2,B:B,0)),ISNUMBER(MATCH(A2 ,C:C,0)),ISNUMBER(MATCH(A2,D:D,0))),"OK","CHECK")
Regards,
Stefi


€žsiva€� ezt Ã*rta:

COL A COl B COL C COL D
COL E
Hypothyroidism Leg pains ok
Birth Control Headache hysteroctmy
check
Asthma
Asthma
Birth Control
Asthma
Asthma
Hypothyroidism
Angina
Duodenitis


Hi can anyone let us know which formula will give me whether the value in
column A is present in Col B or Col C or Col D.
For example in Col A Hypothyroidism is present and exits in Col C, so COL E
value will be ok else need to be check

Siva and surya
 

Try the below formula in ColE cell E1

=IF(COUNTIF(B:D,A1),"OK","Need to check")

If this post helps click Yes
---------------
Jacob Skaria


"siva" wrote:

COL A COl B COL C COL D
COL E
Hypothyroidism Leg pains ok
Birth Control Headache hysteroctmy
check
Asthma
Asthma
Birth Control
Asthma
Asthma
Hypothyroidism
Angina
Duodenitis


Hi can anyone let us know which formula will give me whether the value in
column A is present in Col B or Col C or Col D.
For example in Col A Hypothyroidism is present and exits in Col C, so COL E
value will be ok else need to be check