Dependant Lists
 

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
--
Steve B

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

Fantastic works a treat thanks Debra
--
Steve B


"Debra Dalgleish" wrote:

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