If columnA is your header text and is in Excel Column C (as below); try the
below formula in G2
=IF(AND(C2<"",COUNTIF(D:F,C2)),"ok","")

ColA ColB ColC ColD ColE ColF
Subject site column A column B column C Columnd
E001 1 Hyperthyroidsm Astma
E001 1 Astma
E001 1 cold cough
E001 1 cough

If this post helps click Yes
---------------
Jacob Skaria


"siva" wrote:

Subject site column A column B column C Columnd
E001 1 Hyperthyroidsm Astma
E001 1 Astma
cold

E001 1 cold cough

E001 1 cough


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 a single subject. Like
many subjects and site will be present along with columns.
For example subject E001 at site 1 in Col A if Hypothyroidism is present and
exits in Col C, so COL E value will be ok else need to be as check in column D