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

Similar Threads

Data Validation - Dependant Lists 3
Data Validation-Dependent Lists 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
If formula and Data Validation parallely 1
Data Validation with dynamic ranges 2
Indirect function and data validation dropdown box 2
Filesize: embedded data validation lists all stored independently? 2
Indirect validation list with blank in list 3

Top