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

--
Message posted via http://www.officekb.com

Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP


On Wed, 27 Feb 2008 20:17:53 GMT, "michaelxhermes via OfficeKB.com" <u39868@uwe
wrote:

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

Gord Dibben wrote:
Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben MS Excel MVP

Customise drop down list validation

[quoted text clipped - 18 lines]

many thanks

Gord - thankyou very very much!!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1

Assuming you get the desired result.

Thanks for the feedback

On Wed, 27 Feb 2008 22:25:31 GMT, "michaelxhermes via OfficeKB.com" <u39868@uwe
wrote:

Gord Dibben wrote:
Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben MS Excel MVP

Customise drop down list validation

[quoted text clipped - 18 lines]

many thanks

Gord - thankyou very very much!!!