Excel Formula

  • Thread starter Thread starter Farid
  • Start date Start date
F

Farid

I Need a Formula which can tell me eg. on seperate wotksheet a report of
which product is chipset and from which suppliers.Thanks for any help I get.

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 2 £11.00
6 Product 3 Supplier 1 £7.00
 
We will use MIN to find the lowest value, MATCH to find the row, and INDEX to
get the approriate values:

=INDEX(Sheet1!A1:B10,MATCH(MIN(Sheet1!C1:C10),Sheet1!C1:C10,FALSE),1)
=INDEX(Sheet1!A1:B10,MATCH(MIN(Sheet1!C1:C10),Sheet1!C1:C10,FALSE),2)
 
Thank you Gary,but the value is comes as False

Gary''s Student said:
We will use MIN to find the lowest value, MATCH to find the row, and INDEX to
get the approriate values:

=INDEX(Sheet1!A1:B10,MATCH(MIN(Sheet1!C1:C10),Sheet1!C1:C10,FALSE),1)
=INDEX(Sheet1!A1:B10,MATCH(MIN(Sheet1!C1:C10),Sheet1!C1:C10,FALSE),2)
Click to expand...
 
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 each supplier to show which product is cheapest from each
supplier for all the product

A B C
1 Supplier 101 Supplier 2 Supplier 3
2 Product 100 Product 14 Product 16
3 Product 9 Product 25 Product 111
4 Product 590 Product 89 Product 2
5 Product 250 Product 56 Product 15
6 Product 1 Product 999 Product 8

Thanks for any help I get
 
Back
Top