UntitledDocument
New Member
- Joined
- Apr 22, 2019
- Messages
- 9
I've got three tables
TableA:
<tbody>
</tbody>
TableB:
<tbody>
</tbody>
TableC:
<tbody>
</tbody>
I ultimately required info from say TableB, ColumnA. I want to get this info via two data validation drop down lists.
the first drop down lets me choose different tables listed in TableA using =INDIRECT("TableA
[List of Tables]"). this I have achieved.
with the second drop down I want to choose an item from Column A in the table previously selected from the first dropdown. This is the one I need help on.
So if my two drop downs selects are shown on a sheet:
<tbody>
</tbody>
I first chose TableB from my two options (TableB,TableC) from TableA
[List of Tables]
I then chose otherstuff from my two options (stuff, otherstuff) from TableB[Column A]
How would I write the indirect formula for the second drop down? My guess was something like =INDIRECT(C2[Column A])
I'm not really looking for another route around this because in reality my "TableA" is an ever-changing list of table names with an ever-changing amount of information in each table.
Just a heads up in case you think I'm looking for a complicated solution to a simple problem.
Thank you.
TableA:
List of Tables | Other Info |
TableB | Info1 |
TableC | Info2 |
<tbody>
</tbody>
TableB:
Column A | Column B |
stuff | morestuff |
otherstuff | extrastuff |
<tbody>
</tbody>
TableC:
Column A | Column B |
onestuff | redstuff |
twostuffs | bluestuff |
<tbody>
</tbody>
I ultimately required info from say TableB, ColumnA. I want to get this info via two data validation drop down lists.
the first drop down lets me choose different tables listed in TableA using =INDIRECT("TableA
[List of Tables]"). this I have achieved.
with the second drop down I want to choose an item from Column A in the table previously selected from the first dropdown. This is the one I need help on.
So if my two drop downs selects are shown on a sheet:
A | B | C | D | E | |
1 | |||||
2 | DropDown1= | TableB | |||
3 | DropDown2= | otherstuff | |||
4 | |||||
5 |
<tbody>
</tbody>
I first chose TableB from my two options (TableB,TableC) from TableA
[List of Tables]
I then chose otherstuff from my two options (stuff, otherstuff) from TableB[Column A]
How would I write the indirect formula for the second drop down? My guess was something like =INDIRECT(C2[Column A])
I'm not really looking for another route around this because in reality my "TableA" is an ever-changing list of table names with an ever-changing amount of information in each table.
Just a heads up in case you think I'm looking for a complicated solution to a simple problem.
Thank you.