Cross-referenced drop-down menu (nested drop-downs?)

Okay, I have 2 columns, Topic & Subtopic. The topic column cells are data
validated with a drop-down menu to a range of 30 values on another sheet
labelled "Topic". In the next column, Subtopic, I want the cells to also be
data validated with a drop-down menu, but dependent on the value in the Topic
column. So that each Topic has a unique set of Subtopics to choose from.

I figured out how to make a List Data Validation that has a nested if/then
function for the Source, which works, but you can only nest up to 7 if/then
functions, which limits me to 7 topics, when in fact there is about 30.

Any ideas? Thanks

See:

http://www.contextures.com/xlDataVal02.html

Regards
Rowan

creativeops wrote:
> Okay, I have 2 columns, Topic & Subtopic. The topic column cells are data
> validated with a drop-down menu to a range of 30 values on another sheet
> labelled "Topic". In the next column, Subtopic, I want the cells to also be
> data validated with a drop-down menu, but dependent on the value in the Topic
> column. So that each Topic has a unique set of Subtopics to choose from.
>
> I figured out how to make a List Data Validation that has a nested if/then
> function for the Source, which works, but you can only nest up to 7 if/then
> functions, which limits me to 7 topics, when in fact there is about 30.
>
> Any ideas? Thanks

See Debra Dalgleish's "dependent lists" page.

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


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 16:46:02 -0800, "creativeops"
<[email protected]> wrote:

>Okay, I have 2 columns, Topic & Subtopic. The topic column cells are data
>validated with a drop-down menu to a range of 30 values on another sheet
>labelled "Topic". In the next column, Subtopic, I want the cells to also be
>data validated with a drop-down menu, but dependent on the value in the Topic
>column. So that each Topic has a unique set of Subtopics to choose from.
>
>I figured out how to make a List Data Validation that has a nested if/then
>function for the Source, which works, but you can only nest up to 7 if/then
>functions, which limits me to 7 topics, when in fact there is about 30.
>
>Any ideas? Thanks

Very good, thank you!

"Rowan Drummond" wrote:

> See:
>
> http://www.contextures.com/xlDataVal02.html
>
> Regards
> Rowan
>
> creativeops wrote:
> > Okay, I have 2 columns, Topic & Subtopic. The topic column cells are data
> > validated with a drop-down menu to a range of 30 values on another sheet
> > labelled "Topic". In the next column, Subtopic, I want the cells to also be
> > data validated with a drop-down menu, but dependent on the value in the Topic
> > column. So that each Topic has a unique set of Subtopics to choose from.
> >
> > I figured out how to make a List Data Validation that has a nested if/then
> > function for the Source, which works, but you can only nest up to 7 if/then
> > functions, which limits me to 7 topics, when in fact there is about 30.
> >
> > Any ideas? Thanks
>

Excellent, thanks!

"Gord Dibben" wrote:

> See Debra Dalgleish's "dependent lists" page.
>
> http://www.contextures.on.ca/xlDataVal02.html
>
>
> Gord Dibben Excel MVP
>
> On Mon, 21 Nov 2005 16:46:02 -0800, "creativeops"
> <[email protected]> wrote:
>
> >Okay, I have 2 columns, Topic & Subtopic. The topic column cells are data
> >validated with a drop-down menu to a range of 30 values on another sheet
> >labelled "Topic". In the next column, Subtopic, I want the cells to also be
> >data validated with a drop-down menu, but dependent on the value in the Topic
> >column. So that each Topic has a unique set of Subtopics to choose from.
> >
> >I figured out how to make a List Data Validation that has a nested if/then
> >function for the Source, which works, but you can only nest up to 7 if/then
> >functions, which limits me to 7 topics, when in fact there is about 30.
> >
> >Any ideas? Thanks
>
>