Solved 2 Drop Down List for Single Dependent

Microsoft Office excel 2007 home & stude...
September 16, 2011 at 17:29:31
Specs: Windows XP
I need help...

Is there a way to create 2 seperate drop down lists for a single dependent? I have two columns that I need to have updated depending on what is selected in another cell.

For example...

In Cell A1 I have a drop down list (Asia, Europe, South America, North America, etc.)

In Cell B1 I have created a drop down list to reflect the different Languages spoken for what is selected in cell A1

In Cell C1 I would like to have the different types of currency for what is selected in A1.

Cell A1=Drop Down List (Select: Europe)
Cell B1=Selected Europe in Cell A1 (Drop Down list with choice of Czech, English, Greek, Hungarian, Polish, French, Spanish, etc)
Cell C1=Selected Europe in Cell A1 (Drop Down list with choice of US Dollars, Euro, Pounds, etc.)

For Cell B1 I created a list for every type and and named each list (name box) so it corelates to the selection. Spain, France, Italy, etc...and in the name box named the list Europe. Japan, China, Korea, etc...and in the name box named the list Asia...In the Data Validation in the Source code, I used the INDIRECT(A1) function...and that is as far as I got....need help setting up Cell C1 with a drop down dependent on what is selected in Cell A1.

I hope this makes sense. Any help is greatly appreciated.

Thanks in advance


See More: 2 Drop Down List for Single Dependent

Report •

#1
September 16, 2011 at 18:50:04
✔ Best Answer
You are missing the subtle beauty of the INDIRECT function.

I'll give you a hint and let you figure out the rest.

=INDIRECT(A1 & "_Currency")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 19, 2011 at 18:20:20
I got it! Thanks for the tip!

Report •
Related Solutions


Ask Question