I have a list of over 1000 Product in column A and in column B over 30
Supplies and in column C the price of each product from different Supplies.
Each Supplier may offer same product but with different prices ( e.g. Table
below ). All the information is in sheet 1.

A B C
1 Product 1 Supplier 2 £10.00
2 Product 2 Supplier 1 £8.00
3 Product 3 Supplier 2 £8.00
4 Product 2 Supplier 2 £6.00
5 Product 1 Supplier 3 £11.00
6 Product 3 Supplier 1 £7.00

I have created sheet 2 ( e.g. table below ) I need formula which updates
under heading of supplier to show cheapest product from each supplier for all
the product


A B
1 Product Supplier
2 Product 1 ?
3 Product 2 ?
4 Product 3 ?
5 Product 4 ?
6 Product 5 ?


Thanks for any help I get