vlookup_surya_siva

S

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".
 
M

Mike H

Hi,
Try this

=IF(COUNTIF(B2:D100,G1)>0,"OK","Not OK")

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Siva and surya 2
Siva and surya 2
Compare multiple columns-----siva and surya 0
Triple IF? 2
Nested IF conditions 3
Lookup Formula 4
Copy Cell in other sheet 1
Counting unique values in multiple columns 4

Top