Siva and surya

  • Thread starter Thread starter siva
  • Start date Start date
S

siva

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
 
=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:
 
Try the below formula in ColE cell E1

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

If this post helps click Yes
 
Back
Top