Looking up Text as a result of a formula

[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.

 

[Pete_UK]

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