Validation function that created from another drop down list

G

Guest

I am looking at having a validation cell which will access 10
classifications, I then want the classification to provide a second drop down
list containing names based on what was chosen in the first validation?
 
G

Guest

I have done this once , but t required a lot of forula's and data entry ,
especially if the first dropdown list id very long. If you send me an email
([email protected]) I can mail you an example sheet. But if there is a
standard functionality for this I am curious to know.

The solution I created was to populate the second validation list with the
desired values , using a horizontal lookup, de[pending on the value of the
first cell with drop down. ( I hope I make any sense here )

Hans
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Size of drop down in validation list 2
Creating drop downs in a cell contingent on another drop down 1
Data Validation List (Drop Down) Not Showing 2
Data Validation drop-down 5
Customise drop down list validation 3
Drop Down List Contains the List Header Row 1
Filtered drop down list 2

Top