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

K

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

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)
 
L

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
 
B

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

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
 
B

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
 
Top