Data validation

[stee]

Parameter
LegL 25
Thk 3
Length 30

The LegL is validated to 25, 30, 40 etc

When LegL=25
i want Thk to validate to 3,4 or 5
When Leg =30
thk to validate to 5,6,or 7

how is this done, its drving me crazy????

 

[Roger Govier]

Hi

Set up a named range of LegL having values of 25,30,40 etc.
Set up other named ranges for the values associated with the 25, 30 etc.
values of LegL, except that these cannot be just called 25 or 30.
I named mine as L_25 with values of 3,4 and 5 and L_30 with values of
5,6,and 7.
In cell A1, Data>Validation>List> =LegL
In cell A2, Data>Validation>List> =INDIRECT("L_"&A1)