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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

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

How do I create a drop down box within a drop down box? 1
Question about Access DB design and related fields 1
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Formatted cell column in drop down list 1
Remove blank cells from data validation drop down box 3
If main heading is selected, sub headings auto-selected 3
Nesting drop-down menus 1
Maxing out nesting levels limitation of IF function 3

Back
Top