I am having problem with coming up a formula to lookup the minimum value of a particular product at a particular date (Sheet 2, Column C), and returning the name of the shop in (Sheet 2, Column D).
Sheet2
The sample data set is shown below: Sheet1
I need a formula (for each of column C and D) that would allow me to copy down the row, and gives me the lowest value of a certain product at certain date.
My initial thought for Column D is an array formula with INDEX, MATCH and MINIFS. However, I am not sure the formula for Column C. I was thinking about VLOOKUP but not sure how I should go with selecting the appropriate array of price of a given product.
Thank you in advance