Index table and return minimum between set # of periods

[KJYates]

I have a table with five columns. The first column is dates(months) and then there are four columns of product prices. I want to index the table by date and product and bring back the optimal (minimum) price in the 3 month period including the current month and the previous two months.

Therefore, I want to be able to set a formula that will match the date and the product in the table then return the minimum price looking at the matched date and the prior two periods.

Is there a way to do this or are there too many variables?

 

[Aladin Akyurek]

I have a table with five columns. The first column is dates(months) and then there are four columns of product prices. I want to index the table by date and product and bring back the optimal (minimum) price in the 3 month period including the current month and the previous two months.

Therefore, I want to be able to set a formula that will match the date and the product in the table then return the minimum price looking at the matched date and the prior two periods.

Is there a way to do this or are there too many variables?

A small sample along with desired results would help...