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)

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)


"BEEJAY" <(E-Mail Removed)> wrote in message
news:B8355B43-F503-42E7-B7BC-(E-Mail Removed)...
> 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)
>

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


"Bob Phillips" wrote:

> 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)
>
>
> "BEEJAY" <(E-Mail Removed)> wrote in message
> news:B8355B43-F503-42E7-B7BC-(E-Mail Removed)...
> > 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)
> >
>
>
>

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)


"BEEJAY" <(E-Mail Removed)> wrote in message
news:FEBF8D76-179A-4C51-A4B9-(E-Mail Removed)...
> Works Great!!
> Can you explain why the "false" portion of the IF statement
> is not required, in this case?
>
>
> "Bob Phillips" wrote:
>
> > 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)
> >
> >
> > "BEEJAY" <(E-Mail Removed)> wrote in message
> > news:B8355B43-F503-42E7-B7BC-(E-Mail Removed)...
> > > 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)
> > >
> >
> >
> >

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.

"Bob Phillips" wrote:

> 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)
>
>
> "BEEJAY" <(E-Mail Removed)> wrote in message
> news:FEBF8D76-179A-4C51-A4B9-(E-Mail Removed)...
> > Works Great!!
> > Can you explain why the "false" portion of the IF statement
> > is not required, in this case?
> >
> >
> > "Bob Phillips" wrote:
> >
> > > 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)
> > >
> > >
> > > "BEEJAY" <(E-Mail Removed)> wrote in message
> > > news:B8355B43-F503-42E7-B7BC-(E-Mail Removed)...
> > > > 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)
> > > >
> > >
> > >
> > >
>
>
>