vlookup_surya_siva

[surya and siva]

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


Hi can anyone let me 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 contains Hypothyroidism, and i want this hypothyroidsm
to be checked in B,C,D and if it matches with any of these collumns column E
should show "ok", other wise it should be as " check".

 

[Mike H]

Hi,
Try this

=IF(COUNTIF(B2100,G1)>0,"OK","Not OK")

Where G1 contains the value your looking for in columns B.C or D.

Mike

 

[Teethless mama]

=IF(COUNTIF($B$2:$D$100,A2),"OK","Check")