I could use some assistance on this as I've not been able to come up with a solution. I've attached file as it's easier to view and understand what I am trying to accomplish. What I need to do is come up with a formula that displays data based on three criteria selected. When the criteria range changes, the results will filter and change based on what I've selected. I want the city Results to populate with the cities based on the criteria ranges I've selected. For example if population range is 90K-100K and Avg. Income range is 90K-110K and % of Pop w/ Bachelors Degree is 67%-82% I want all cities in my data set that meet the specified criteria to display. If there are changes to the search criteria, say you change the Population to be 80K-120K or decrease the Avg. Income, then the city results would change and filter based on what you've selected. Thank you thank you for any help on this.

Attached Files

Sample.xls (30.0 KB, 12 views)