Data Validation - dependant Lists

  • Thread starter Thread starter TonyK
  • Start date Start date
T

TonyK

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
 
Hi Tony

Not sure what you are asking here.
Could you explain with an example of the data?
 
Back
Top