Yes, you can created named ranges for the selections. For example, if
cell A2 contained "Honda", and cell B2 contained "Civic", you could have
a range named Honda_Civic_List.
Then, in cell C2, use the following formula for the data validation list
source:
=INDIRECT(A2&"_"&B2&"_List")
Steve Bladon wrote:
I am having difficulty associating my dependant lists. I have list 1,
(master) working fine and linking to dependant list 2 pretty well, Can i add
a 3rd and 4th dependant list that reacts to the selections chosen from lists
1 and 2
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html