Customise drop down list validation

  • Thread starter michaelxhermes via
  • Start date


michaelxhermes via

Customise drop down list validation

How would I go about entering a second data validation drop down cell where
the values to be selected depended on the selection made in the first drop
down list validation?

In other words the list or choices to select in the second cell are different
each time depending on the value selected in the first box


first cell drop down list is 1 2 3

entry cell
1 -> second cell allow A B C
2- -> second cell allow D F G
3 -> second cell allow Q A Z

Am I missing some simple lookup solution?

many thanks




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