How to find lowest price for product and then pull through supplier name etc.

Hi everyone!

Hoping you can help me. I'm trying to build a pricing database for building supplies. I have prices from many suppliers for products and would like to have a page displaying only the lowest price for each product, along with relevant data such as product code and pack size.

I have structured the data with a new line for each price to allow me to have more information for each supplier, e.g. product code.


I have worked on a formula to return the lowest price for each product:

=MIN(IF(Sheet1!$A$1:$A$10000=A2,Sheet1!$F$2:$F$10000))


Do you have any ideas as to how I could then pull though the other data I need. I can do it with a VLOOKUP on the price value, but then if I had any items with exactly the same price in the data it would not work.

Hopefully the file is attached for you to have a look at.

Many thanks in advance for your help!