| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Siva and surya
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Siva and surya
=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: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Siva and surya
Try the below formula in ColE cell E1 =IF(COUNTIF(B:D,A1),"OK","Need to check") If this post helps click Yes --------------- Jacob Skaria "siva" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Siva and surya | Excel Worksheet Functions | |||
| Compare multiple columns-----siva and surya | Excel Worksheet Functions | |||
| surya and siva | Excel Worksheet Functions | |||
| comparing dates: surya | New Users to Excel | |||
Linear Mode
