Data Validation - Drop down lists - if then?
 

I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve

There are instructions here for dependent data validation lists:

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


Steve R wrote:
I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Yes, see:


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


Regards,

Peo Sjoblom

"Steve R" wrote:

I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve