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.

	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: Department Atlanta Department # 500 MTD 3/31/2019 Revenue IN from: Department Amount Region Arizona 100 Domestic Corporate Communications 200 Domestic Washington DC 300 Domestic Silicon Valley 400 Domestic Santa Monica 500 Domestic New York 600 Domestic Boston 700 Domestic San Diego 800 Domestic San Francisco 900 Domestic <colgroup><col><col><col></colgroup><tbody> </tbody> Data Tab: 500 225 Domestic Domestic Atlanta B2B Tech Rev share in 0 0 Rev share out 0 0 Net 0 0 350 Arizona Domestic Rev share in 100 0 550 Corporate Communications Domestic Rev share in 200 0 400 Washington DC Domestic Rev share in 300 0 225 Silicon Valley Domestic Rev share in 400 0 200 Santa Monica Domestic Rev share in 500 0 450 New York Domestic Rev share in 600 0 325 Boston Domestic Rev share in 700 0 250 San Diego Domestic Rev share in 800 100 150 San Francisco Domestic Rev share in 900 200 500 Atlanta Domestic Rev share in 1,000 300 600 Media Domestic Rev share in 1,100 400 850 Digital Domestic Rev share in 1,200 500 475 Content Domestic Rev share in 1,300 600 275 Research & Measurement Domestic Rev share in 1,400 700 300 Seattle Domestic Rev share in 1,500 800 375 Portland Domestic Rev share in 1,600 900 UK London International Rev share in 1,700 1,000 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>
	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!

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>