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