How do I create a dependent list, to a current list?

G

Guest

I am trying to create a dependent responing list to another drop down list in
excel.

I.e.
Drop down list 1:
1
2
3

Drop Down list 2:
A
B
C

If I selected 2 from the fist list I would want list two to automatically
register B.
 

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
Multi-level dependent data validation 3
produce list automatically from choice of drop down list 1
Dependent Data Validation 3
How to create 2 dependent drop down lists from 1 original drop dow 5
Multiple lists 2
Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top