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

Account	Account Name	Budget	Forecast	Actual
0001	Fees	1000	1100	800
0002	Investment	2000	1500	200

<tbody>
</tbody>

Expense Table

Account	Account Name	Budget	Forecast	Actual
5001	Supplies	3000	2000	200
6001	Technology	100	50	25

<tbody>
</tbody>

Detailed Second Table

Event	BFA	IE	Item	Category
EventA	Budget	Income	Participant Fees	Fees

<tbody>
</tbody>

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).