Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup_surya_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". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup_surya_siva
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 "surya and siva" wrote: 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". |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup_surya_siva
In cell L2 apply this formula and copy down as required
=IF(COUNTIF($B$2:$D$100,A2)0,"OK","Check") If this post helps click Yes --------------- Jacob Skaria "surya and siva" wrote: 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". |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup_surya_siva
=IF(COUNTIF($B$2:$D$100,A2),"OK","Check")
"surya and siva" wrote: 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|