Grocery List with Price comparison

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.

one of the workaround, copy this formula on H3 and drag it down:

Please Login or Register  to view this content.

Grocery List.xlsx

Thanks for the quick responses. I'm getting errors on both of these formulas and I don't fully understand how they work so it's hard to correct the errors.

I'm attaching the file for you to look at.

Thanks again

i pasted my formula in cell h3 in your file and it worked properly
however, it will throw an error at cell h5 since there is no data available and to avoid this use an error trapping formula mentioned below:

Please Login or Register  to view this content.

Thanks Roshan10043

I found where my problem was, my Excel 2010 does not like commas so I replaced all commas with semi-colons and it worked.

Thanks for your help!

Thanks to everyone for the quick responses!

Appreciate all the help.