Can anyone help plesae.
I have a spreadsheet with multiple named ranges contained therein.
In A2 I display the "Specialty Name" from a drop down list which is sourced
from a named range. In Cell B2 I display a list of associated Clinic Types
depending on the entry in A2. When I have one Clinic Type List it works fine
(formula is =INDIRECT(A2)). I now now want to add ranges that span from Col
C to Column AZ but I am struggling with the formula to populate the Data
Validation field with.
Any help would be appreciated.
Kind regards

TonyK