Greetings All:
(Excel 2003)
I'm trying to "clean up" various workbooks and consolidate into one workbook
(probably about 75 sheets, when done). I have come to the conclusion that,
for clarity of my formulas, I should have used range names.
I have the Name Manager, version 3.2 from Jan Karel, which hopefully will
prove to be more than a little useful.

My current problem relates to the use of validation, based on info
from two cells, (either/or), and requiring a result of 1 of 2 validation
lists.
I hope the following is clear.

Cell C3:  Truck    Cell D3 = 0 (not applicable) or 1 (applicable)
Cell C4:  Trailer  Cell D4 = is opposite of above.
                   ie: if D3 = 1, then D4 = 0 and vice-versa

Cell C5:  Length    Cell D5:  Actual length, to be selected from 1 of 2
possible lists

If D3 = 1, then the drop down list to have specific list of lengths
possible for a Truck, as listed in Range Name "TruckLengths"

If D4 = 1, then the drop down list is to reflect the list of lengths possible
for trailers, as listed in Range Name "TrailerLengths"

I need the references in D3 and D4, for many formulas, so I hope I
don't have to change my layout - although I will, if neccessary.
The correct validation list is to prevent the salesman from ordering,
for example, a 48 foot Truck, etc............

I hope there is a solution to my situation.
Thanks in advance for any response (preferably a helpful one)