Use a drop down to pull in a data set to a dashboard

Hello,

I am working on creating dashboard and one of the features I need to add is to display a data table based on a date range and product category. The data table has 25 columns in it and could have any number of rows based on the input. The data will be pulled from a master data file.

I have found a few examples of using an Index Match formula that might work but they all seem to return only one piece of data instead of multiple rows and columns. I could use a vlookup but I think it would take too long to calculate.

This is an example of the inputs (Yellow) and the table that I need to have returned.

Table Example.JPG

Thanks in advance!

-AB

Can you please post a sample file with expected results.

Thanks for the response John.

I attached a file with the expected results. I have not added in the combo boxes yet but you can see where they go in yellow.

Hey ChemistB,

This works perfectly. Thank you so much for your help. Apologies for the late response I was out of the office on paternity leave and the dashboard fell to the wayside.

-AB