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