Dependant Lists

[Guest]

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]

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

 

[Guest]

Fantastic works a treat thanks Debra
--
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")