Hi all

I'm quite out of touch with excel and need some advice.

I want to create a simple grocery list with different ITEMS listed in column A. B2 though F2 must contain five different STORE NAMES. Prices will be filled in in B3:F20 for example. In G column I want to display the lowest price for a certain ITEM. This I can do with the MIN function. My problem is the next phase where I want to retrieve the STORE NAME with the lowest price. After that has been done I want to filter the list and basically print 5 different shopping lists to see what has to be bought from where.

Any idea of how to retrieve the STORE NAME from the item with the lowest price? I'm stuck on that and cannot continue.

Thanks in advance.