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

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...

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

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...

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

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" wrote in message
...
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...

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

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" wrote in message
...
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" wrote in message
...
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...

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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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...

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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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...

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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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...