Is it possible to source two separate Tables for a dependent drop down list?

[rangeralex]

I understand the basic idea of using Indirect to create dependent drop down lists. However, I'm aiming for a more user friendly interface. I am trying to create a budget workbook that includes a summary income table and summary expense table.

Income Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Account[/TD]
[TD]Account Name[/TD]
[TD]Budget[/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]0001[/TD]
[TD]Fees[/TD]
[TD]1000[/TD]
[TD]1100[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]0002[/TD]
[TD]Investment[/TD]
[TD]2000[/TD]
[TD]1500[/TD]
[TD]200[/TD]
[/TR]
</tbody>[/TABLE]

Expense Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Account[/TD]
[TD]Account Name[/TD]
[TD]Budget[/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]5001[/TD]
[TD]Supplies[/TD]
[TD]3000[/TD]
[TD]2000[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]6001[/TD]
[TD]Technology[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

Detailed Second Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Event[/TD]
[TD]BFA[/TD]
[TD]IE[/TD]
[TD]Item[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]EventA[/TD]
[TD]Budget[/TD]
[TD]Income[/TD]
[TD]Participant Fees[/TD]
[TD]Fees[/TD]
[/TR]
</tbody>[/TABLE]


Both of these tables are on a summary sheet. I would like to keep them separated for sake of formatting. It most resembles an existing template within my organization in this way. I also have a second sheet that contains the details of each category. What I’d like to do is to be able to select from a drop-down menu “expense” in the details sheet and create a second drop down menu under “category” that would only display the categories listed in column 2 of the summary expense table.

This would allow the sheet to be more user friend to those who don’t understand the structure and formatting as well if they needed to add an additional expense category. They could simply add it in the summary sheet and have it show up in the details section. Is this possible?

 

[rangeralex]

I just used an IF statement with the named ranges and to my surprise it worked (so far).