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
Siva and surya 2
Loop Through Text and Test for Scenarios Q 31
Sheet Cleanup Help Please 5
VBA If Statement 2
Loop thru xx No. of sheets until the four strValue combo's are found 6
Advanced transpose/grouping question 7
Calculate totals 3

Top