2 criteria cells used to select which validation list to use

[Guest]

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)

 

[Bob Phillips]

Try this formula in the List Allow type in DV


=IF(D3=1,TruckLengths,IF(D4=1,TRailerLengths))


you might want another optione if neither are 1


--

HTH


RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Works Great!!
Can you explain why the "false" portion of the IF statement
is not required, in this case?

 

[Bob Phillips]

That is because we are using the List type, and the final False would return
a False which just doesn't equate to list.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks for the response.
I'm sure I'll run into other examples which will help
reinforce this idea.

"When is an if statement not a (normal) if statement"?
"When it is a list statement"
Cool!!
Kinda like: When is a door not a door? When it is ajar.
"Things are often not as they first appear"
Thanks again. Till next time.