Hi Tony

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

--
Regards
Roger Govier

"TonyK" wrote in message
...
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