Customise drop down list validation

  • Thread starter michaelxhermes via OfficeKB.com
  • Start date

M

michaelxhermes via OfficeKB.com

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

Eg

first cell drop down list is 1 2 3

First
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
 
Ad

Advertisements

Ad

Advertisements


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

Top