This may be very basic but, is there a way to first of all limit the possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.

See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Cerberus" wrote in message
...
This may be very basic but, is there a way to first of all limit the
possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way
to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.

Thank you for your help.

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Cerberus" wrote in message
...
This may be very basic but, is there a way to first of all limit the
possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way
to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.