Data Validation - dependant Lists

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
 
R

Roger Govier

Hi Tony

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top