Search for minimum price with dynamic range and return price and product ref

Good afternoon,

I would like some help with the following Excel problem:

There's a list of products. In the example worksheet attached there's 3 products: T-shirt 1, t-shirt 2 and t-shirt 3 (however, there could be other products such as Trouser 1). The products have different prices depending on small differences between them (e.g. T-shirt 1 may have the t-shirt logo in the inside either printed or stitched) and I would like to find the minimum price for each product (i.e. For t-shirt 1, for t-shirt 2 and for t-shirt 3).

The problem I find is that in reality there are many more products, so the range should be dynamic (there may be three t-shirt 1s and 15 t-shirt 4s).

Additionally, if the price is exactly the same, I would like the summary table to return the t-shirt reference with the lowest minimum purchase requirements.


Best,

gjrr4x1