Difficult Excel Formula - Populating Data from Drop Down Menu

[DataValidator]

Hi All,

I am trying to create a formula to have data populated from a drop down menu but I am unable to get it to work correctly.

[TABLE="width: 488"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Depending on which department you select, the data should automatically populate, but I am not sure what kind of formula to use given how my data is currently displayed.

I am currently using the below formula that pulls in any data that has a value associated with it.

=IFERROR(INDEX(Dash!E$9:E$43,SMALL(IF(Dash!E$9:E$43>0,ROW(Dash!B$9:B$43)-ROW(Dash!B$9)+1),ROWS(Dash!B$9:B9))),"")

My issue is, how do I use this formula as well as another formula to pull in the data I need depending on which Department is selected?

Drop Down Tab:
[TABLE="width: 360"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Department[/TD]
[TD]Atlanta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department #[/TD]
[TD]500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MTD[/TD]
[TD]3/31/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Revenue IN from:[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD]Amount[/TD]
[TD]Region[/TD]
[/TR]
[TR]
[TD]Arizona[/TD]
[TD="align: right"]100[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Corporate Communications[/TD]
[TD="align: right"]200[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Washington DC[/TD]
[TD="align: right"]300[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Silicon Valley[/TD]
[TD="align: right"]400[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Santa Monica[/TD]
[TD="align: right"]500[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]New York[/TD]
[TD="align: right"]600[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Boston[/TD]
[TD="align: right"]700[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]San Diego[/TD]
[TD="align: right"]800[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]San Francisco[/TD]
[TD="align: right"]900[/TD]
[TD]Domestic[/TD]
[/TR]
</tbody>[/TABLE]


Data Tab:
[TABLE="width: 596"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]500[/TD]
[TD]225[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Domestic[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Atlanta[/TD]
[TD]B2B Tech[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rev share in[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rev share out[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Net[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]350[/TD]
[TD]Arizona[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]100[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]550[/TD]
[TD]Corporate Communications[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]200[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD]Washington DC[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]300[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]225[/TD]
[TD]Silicon Valley[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]400[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]Santa Monica[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]500[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]450[/TD]
[TD]New York[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]600[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]325[/TD]
[TD]Boston[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]700[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]San Diego[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]800[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]150[/TD]
[TD]San Francisco[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]900[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]Atlanta[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,000[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]600[/TD]
[TD]Media[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,100[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]850[/TD]
[TD]Digital[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,200[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]475[/TD]
[TD]Content[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,300[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]275[/TD]
[TD]Research & Measurement[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,400[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]Seattle[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,500[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]375[/TD]
[TD]Portland[/TD]
[TD]Domestic[/TD]
[TD]Rev share in[/TD]
[TD]1,600[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]London[/TD]
[TD]International[/TD]
[TD]Rev share in[/TD]
[TD]1,700[/TD]
[TD]1,000[/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] I am not sure how to upload an excel file or how to share one through DropBox. Any help would be greatly appreciated!

Thank You![/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]