Dynamic Dashboard Formula Assistance

excel6067

New member
Joined
May 4, 2017
Messages
1
Reaction score
0
Points
0
I'm attempting to have MSA data (referenced in column C of the 'Lookup Sheet' tab) auto populate based on the criteria selected in the drop-downs i have created in rows 36-56 in the template tab. The MSA data would display on the template tab starting in cell D60. Example.) I want all MSA's to display that have population between 108,245-132,300 and have % HH Income $100K-$149K between 7.9%-9.7% and have % of White Population between 65.6%-80.2% and have % of age 20-34 between 16.7%-20.4% and have % of Bachelor Degrees between 11.7%-14.3%


The problem i have is when i click and change a drop down. My list has to react to whatever the criteria is. Example) if I change my population criteria from 'total population' to '% of female population' I need my list to dynamically change and fit to the parameters I outlined in each of the search criteria(s). All data is located on the 'lookup sheet' tab.
 
Back
Top