Siva and surya

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
 
S

Stefi

=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:
 
J

Jacob Skaria

Try the below formula in ColE cell E1

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

If this post helps click Yes
 

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

vlookup_surya_siva 2
Loop Through Text and Test for Scenarios Q 31
Siva and surya 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Compare multiple columns-----siva and surya 0
NFL spreadsheet 3
Loop thru xx No. of sheets until the four strValue combo's are found 6
Sheet Cleanup Help Please 5

Top