Looking up Text as a result of a formula

  • Thread starter Thread starter Hammer
  • Start date Start date
H

Hammer

I have a work sheet with 2 columns, Column A = Company Names & column B =
prices.

In sheet 2 I have a formula which is selecting the lowest price from column
B in sheet 1 but I also need to see the company name, how do I do this?

I.E. if cell A1 contains company name XYZ and their price is the lowest then
i need cell A1 in sheet 2 to show this company name if cell B1 is showing
their price as being the minimum cost.
 
Put this in A1 of Sheet2:

=INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0))

Note that if you have two companies which have the same lowest price,
the formula will only find the first of these in your list.

Hope this helps.

Pete
 
Back
Top