Excel drop down lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column which is dependent on the choice from the first list.

For example from a choice of "A, B, C, D" in the first list, if i choose "A" I would like to have a drop down list choice of "9, 8, 7" in the second column. But if i choose "C" in the first list, then I would like to have a drop down list choice of "6, 5, 4" in the second column.

Is this possible? And if so, could you please tell me how to go about doing this?

Thanks
Sinead
 
Hi
see: http://www.contextures.com/xlDataVal02.html
-----Original Message-----
Hi,

I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column
Click to expand...
which is dependent on the choice from the first list.
For example from a choice of "A, B, C, D" in the first
Click to expand...
list, if i choose "A" I would like to have a drop down
list choice of "9, 8, 7" in the second column. But if i
choose "C" in the first list, then I would like to have a
drop down list choice of "6, 5, 4" in the second column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking drop down lists to another list 4
Drop Down Lists 2
produce list automatically from choice of drop down list 1
Drop down list ???? 1
Drop Down choice needs to lead to another drop down menu 1
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
Filtered drop down list 2
Customise drop down list validation 3

Back
Top