Using min value to reference another cell

[Mr Ellis]

I've been looking around on this site and google for a while and had no luck

What we have is a List of names in one column and percents that go with each name in the next. I would like to be able to take the min percent and print out the name associated with it but I am not having any luck and was hoping you all might be able to help. Thanks in advance.

[NBVC]

Try:

=index(a:a,match(min(b:b),b:b,0))

where A:B is where the data is

[ChemistB]

With names in Col A and values in column B
=INDEX($A$1:$A$1000,MATCH(MIN($B$2:$B$1000), $B$2:$B$1000,0))
Does that work for you?

[tigertiger]

Assuming: Name and percent are enter in A2:B11 (cell A... contains Names, and B does Percents, respectively)

at the result cells are C2,D2 , plz, enter the formula:
C2:
=Index(A2:A11,Match(D2,B2:B11,0))
D2:
=Min(B2:B11)

Try do that for your sample

[Mr Ellis]

That works just great. Thanks guys