insert a drop down list if a certain cell value is true

[kd]

I use Windows XP.

What I need to acheive is, when a value is selected from a drop down list,
to return another dropdown list which matches the criteria, Ex. 1st list has
2 options, A&B and if A is selected return dropdown list which is related to
A. Hope this explains...

[Ron Coderre]

See if Debra Dalgleish's website helps:

Dependent Lists
http://www.contextures.com/xlDataVal02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"kd" wrote:

> I use Windows XP.
>
> What I need to acheive is, when a value is selected from a drop down list,
> to return another dropdown list which matches the criteria, Ex. 1st list has
> 2 options, A&B and if A is selected return dropdown list which is related to
> A. Hope this explains...
>
>

[Bob Phillips]

I wouldn't use the method Ron points to, it bis too complex for this
requirement IMO.

Instead, this is my suggestion. Assuming list i is in E1, and the other
lists are named ranges called numbers and letters, in the second dropdown,
use an allow value of List and a formula of

=IF(E1="A",letters,numbers)

just change all the usual suspects to suit your siutuation.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kd" <[email protected]> wrote in message
news:[email protected]...
> I use Windows XP.
>
> What I need to acheive is, when a value is selected from a drop down list,
> to return another dropdown list which matches the criteria, Ex. 1st list
has
> 2 options, A&B and if A is selected return dropdown list which is related
to
> A. Hope this explains...
>
>

[L. Howard Kittle]

Hi Bob,

Pretty slick. Is there a way to do more than two lists with this method? I
tried this and it did not work, validation would not accept it.

=IF(E1="A",letters,numbers),IF(E1="C",costs)

Regards,
Howard

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>I wouldn't use the method Ron points to, it bis too complex for this
> requirement IMO.
>
> Instead, this is my suggestion. Assuming list i is in E1, and the other
> lists are named ranges called numbers and letters, in the second dropdown,
> use an allow value of List and a formula of
>
> =IF(E1="A",letters,numbers)
>
> just change all the usual suspects to suit your siutuation.
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "kd" <[email protected]> wrote in message
> news:[email protected]...
>> I use Windows XP.
>>
>> What I need to acheive is, when a value is selected from a drop down
>> list,
>> to return another dropdown list which matches the criteria, Ex. 1st list
> has
>> 2 options, A&B and if A is selected return dropdown list which is
>> related
> to
>> A. Hope this explains...
>>
>>
>
>

[Bob Phillips]

Hi Howard,

Yes, just a different formula format

=IF(E1="A",letters,IF(E1="B",numbers,costs))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"L. Howard Kittle" <[email protected]> wrote in message
news:[email protected]...
> Hi Bob,
>
> Pretty slick. Is there a way to do more than two lists with this method?
I
> tried this and it did not work, validation would not accept it.
>
> =IF(E1="A",letters,numbers),IF(E1="C",costs)
>
> Regards,
> Howard
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >I wouldn't use the method Ron points to, it bis too complex for this
> > requirement IMO.
> >
> > Instead, this is my suggestion. Assuming list i is in E1, and the other
> > lists are named ranges called numbers and letters, in the second
dropdown,
> > use an allow value of List and a formula of
> >
> > =IF(E1="A",letters,numbers)
> >
> > just change all the usual suspects to suit your siutuation.
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "kd" <[email protected]> wrote in message
> > news:[email protected]...
> >> I use Windows XP.
> >>
> >> What I need to acheive is, when a value is selected from a drop down
> >> list,
> >> to return another dropdown list which matches the criteria, Ex. 1st
list
> > has
> >> 2 options, A&B and if A is selected return dropdown list which is
> >> related
> > to
> >> A. Hope this explains...
> >>
> >>
> >
> >
>
>

[L. Howard Kittle]

Thanks for the info. That was the format I was trying to remember, having
seen
it many times in other solutions. With two IF's you get three egg rolls.

I should have been more concise and asked how do you do, four, six, or
eight?

Thanks,
Howard

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Hi Howard,
>
> Yes, just a different formula format
>
> =IF(E1="A",letters,IF(E1="B",numbers,costs))
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "L. Howard Kittle" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Bob,
>>
>> Pretty slick. Is there a way to do more than two lists with this method?
> I
>> tried this and it did not work, validation would not accept it.
>>
>> =IF(E1="A",letters,numbers),IF(E1="C",costs)
>>
>> Regards,
>> Howard
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:[email protected]...
>> >I wouldn't use the method Ron points to, it bis too complex for this
>> > requirement IMO.
>> >
>> > Instead, this is my suggestion. Assuming list i is in E1, and the other
>> > lists are named ranges called numbers and letters, in the second
> dropdown,
>> > use an allow value of List and a formula of
>> >
>> > =IF(E1="A",letters,numbers)
>> >
>> > just change all the usual suspects to suit your siutuation.
>> >
>> > --
>> >
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (remove nothere from the email address if mailing direct)
>> >
>> > "kd" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> I use Windows XP.
>> >>
>> >> What I need to acheive is, when a value is selected from a drop down
>> >> list,
>> >> to return another dropdown list which matches the criteria, Ex. 1st
> list
>> > has
>> >> 2 options, A&B and if A is selected return dropdown list which is
>> >> related
>> > to
>> >> A. Hope this explains...
>> >>
>> >>
>> >
>> >
>>
>>
>
>

[Biff]

For more than 2 or 3 I like to use Choose. You can have up to 29 ranges. (29
reference arguments in Choose)

=CHOOSE(MATCH(A1,J1:L1,0),Letters,Numbers,Costs)

Choose can also handle dynamic ranges where Indirect can't and the
"standard" workaround is "unecessarily overly complex" (IMO)

Biff

"L. Howard Kittle" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the info. That was the format I was trying to remember, having
> seen
> it many times in other solutions. With two IF's you get three egg rolls.
>
> I should have been more concise and asked how do you do, four, six, or
> eight?
>
> Thanks,
> Howard
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Howard,
>>
>> Yes, just a different formula format
>>
>> =IF(E1="A",letters,IF(E1="B",numbers,costs))
>>
>> --
>>
>> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from the email address if mailing direct)
>>
>> "L. Howard Kittle" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hi Bob,
>>>
>>> Pretty slick. Is there a way to do more than two lists with this
>>> method?
>> I
>>> tried this and it did not work, validation would not accept it.
>>>
>>> =IF(E1="A",letters,numbers),IF(E1="C",costs)
>>>
>>> Regards,
>>> Howard
>>>
>>> "Bob Phillips" <[email protected]> wrote in message
>>> news:[email protected]...
>>> >I wouldn't use the method Ron points to, it bis too complex for this
>>> > requirement IMO.
>>> >
>>> > Instead, this is my suggestion. Assuming list i is in E1, and the
>>> > other
>>> > lists are named ranges called numbers and letters, in the second
>> dropdown,
>>> > use an allow value of List and a formula of
>>> >
>>> > =IF(E1="A",letters,numbers)
>>> >
>>> > just change all the usual suspects to suit your siutuation.
>>> >
>>> > --
>>> >
>>> > HTH
>>> >
>>> > Bob Phillips
>>> >
>>> > (remove nothere from the email address if mailing direct)
>>> >
>>> > "kd" <[email protected]> wrote in message
>>> > news:[email protected]...
>>> >> I use Windows XP.
>>> >>
>>> >> What I need to acheive is, when a value is selected from a drop down
>>> >> list,
>>> >> to return another dropdown list which matches the criteria, Ex. 1st
>> list
>>> > has
>>> >> 2 options, A&B and if A is selected return dropdown list which is
>>> >> related
>>> > to
>>> >> A. Hope this explains...
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>
>