- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Conditional drop down in Excel with only 2 column datasource
Posted on 6/30/16 at 10:45 am
Posted on 6/30/16 at 10:45 am
I need to create a spreadsheet that will allow my coworkers to map records (basically selecting the source table.column and mapping it to a destination table.column).
My source recordset looks like this in two columns:
Table1 Field1
Table1 Field2
Table1 Field3
Table2 Field1
etc
I want to create two dropdowns. One for the table name and one for the field name. The thing I can't figure out is how to make the available selections in the "field" dropdown dependent on what is selected in the "table" dropdown. Essentially, if they select Table1 from the first dropdown, I only want the fields associated with that table to be available in the second dropdown.
My source recordset looks like this in two columns:
Table1 Field1
Table1 Field2
Table1 Field3
Table2 Field1
etc
I want to create two dropdowns. One for the table name and one for the field name. The thing I can't figure out is how to make the available selections in the "field" dropdown dependent on what is selected in the "table" dropdown. Essentially, if they select Table1 from the first dropdown, I only want the fields associated with that table to be available in the second dropdown.
Posted on 6/30/16 at 11:19 am to MyNameIsInigoMontoya
You may have to use the INDIRECT function for the second dropdown and define the ranges for each scenario. Here is a simple example of what I think you are trying to achieve.
Dependent Drop-Down
Dependent Drop-Down
Posted on 6/30/16 at 11:53 am to LSU_Richoux
My issue with that is that I can't define all of the named ranges. It's literally a dump of over 1000 tables and 7000 fields.
Posted on 6/30/16 at 12:08 pm to MyNameIsInigoMontoya
Yep that certainly complicates things a bit. I might have to think about this. I'm sure it is possible just don't know how yet LOL
Posted on 6/30/16 at 1:35 pm to MyNameIsInigoMontoya
Can you use a macro with On_Change that updated the 2nd field based on the selection in the first?
Not sure if you want to incorporate a macro worksheet, but it would make it possible.
Not sure if you want to incorporate a macro worksheet, but it would make it possible.
Posted on 6/30/16 at 4:20 pm to MyNameIsInigoMontoya
My first thought would be a 1 solution answer, so it wouldn't work for multiple entries. How about a three dimensional lookup? Use a vlookup with match formula. If you need to go deeper than that, then you create a vlookup/match table on one tab the the result goes to another vlookup to another tab. You could use data verification to help. Some examples would help.
Posted on 6/30/16 at 11:15 pm to CubsFanBudMan
I was thinking if something similar.
I think you need the second drop down to be dynamic based on the selection of the first. This is tricky though... Will have to think about it some more.
I think you need the second drop down to be dynamic based on the selection of the first. This is tricky though... Will have to think about it some more.
Popular
Back to top
Follow TigerDroppings for LSU Football News