software

Parameter
LegL25
Thk3
Length30

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?????--
stee
------------------------------------------------------------------------
stee's Profile: www.excelforum.com/member.php...oamp;userid=31963
View this thread: www.excelforum.com/showthread...hreadid=516858Hi

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, Datagt;Validationgt;Listgt; =LegL
In cell A2, Datagt;Validationgt;Listgt; =INDIRECT(quot;L_quot;amp;A1)

--
Regards

Roger Govierquot;steequot; gt; wrote in
message ...
gt;
gt; Parameter
gt; LegL 25
gt; Thk 3
gt; Length 30
gt;
gt; The LegL is validated to 25, 30, 40 etc
gt;
gt; When LegL=25
gt; i want Thk to validate to 3,4 or 5
gt; When Leg =30
gt; thk to validate to 5,6,or 7
gt;
gt; how is this done, its drving me crazy?????
gt;
gt;
gt; --
gt; stee
gt; ------------------------------------------------------------------------
gt; stee's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31963
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=516858
gt;