Matching name with minimum corresponding number in other column

[mmkay]

Version: 2008
Processor: Intel

I have two columns of data, one with names, the other with values they correspond to. The numbers in the second column change so I want to be able to have a cell that tells me the name from the first column that corresponds to the lowest number in the second column. So, for example, if this was my data:

Apples 4
Oranges 8
Pears 3
Bananas 5

I would want the cell to just say Pears. But if the value changes (e.g. B3 changes to 6), then I want the cell to say Apples, since it is now the lowest.

Thanks!!

 

[Bob Greenblatt]

Version: 2008
Processor: Intel

I have two columns of data, one with names, the other with values they
correspond to. The numbers in the second column change so I want to be able to
have a cell that tells me the name from the first column that corresponds to
the lowest number in the second column. So, for example, if this was my data:

Apples 4
Oranges 8
Pears 3
Bananas 5

I would want the cell to just say Pears. But if the value changes (e.g. B3
changes to 6), then I want the cell to say Apples, since it is now the lowest.

Thanks!!

If the fruit is in column A, and the values are in column B, and both start
in row 1, then:
=index(A:A,match(B:B,min(b:b),0))

should work.