I currently stuck to create a template form for my clinic reception..
need Excel shifu for me to use proper formula..

There are plenty of Medical test type but need to use excel to specify which test for which patient.
for Eg:

Shell OME (Contractor)
1)Physical Examination
2)Blood Test/LAB
Complete Blood Count
Blood Group (Rhesus)
Fasting Blood Sugar
Urea
Creatinine
Sodium
Potassium
Chloride
Fasting Serum Lipid
Urine Feme
3) Urine Test
a)Amphetamine
b)Cannabis
c)MDMA
d)Morphine
e)Benzo
4)Chest X-Ray
5)Audiometry

Petronas Contractor
1)Physical Examination
2)Blood Test/LAB
Complete Blood Count
Blood Group (Rhesus)
Fasting Blood Sugar
Urea
Creatinine
Sodium
Potassium
Chloride
Fasting Serum Lipid
Uric Acid
Liver Function Test
Hepatitis B Screening
Urine Feme
3) Urine Test
a)Amphetamine
b)Cannabis
c)MDMA
d)Morphine
e)Benzo
4)Chest X-Ray
5)Audiometry

Lets say i select Shell OME Contractor from the drop down list..
I need the excel to display type of test need to be done

i tried this
=IF(ROWS(C$11:C11)>=COUNTA(INDIRECT(C$10)),INDIRECT(C$10),"")

What i get is #REF!


Tq Guys