min value with text

**Syphoner** · 08-24-2009, 01:06 PM

A1=John,A2=Mike,A3=Fred
B1=1221,B2=4321,B3=9087

What I would like to end up with is something like this....
Person who has the fewest : "John"
Instead of "Person who has the fewest : "1221" .

I know how to do the min "=min(b1:b3)" , but how do i link the text with the number in the above statement?

**NBVC** · 08-24-2009, 01:12 PM

Try

=Index(a1:A3,Match(Min(B1:B3),B1:B3,0))

**Paul** · 08-24-2009, 01:13 PM

Hi Syphoner, welcome to the forum.

You can use a formula like this to lookup the name of the person with the MIN from B1:B3:

=INDEX($A$1:$A$3,MATCH(MIN($B$1:$B$3),$B$1:$B$3,0))

**Syphoner** · 08-24-2009, 06:38 PM

Originally Posted by Syphoner

A1=John,A2=Mike,A3=Fred
B1=1221,B2=4321,B3=9087

What I would like to end up with is something like this....
Person who has the fewest : "John"
Instead of "Person who has the fewest : "1221" .

I know how to do the min "=min(b1:b3)" , but how do i link the text with the number in the above statement?

Thanks for the responses! I got it to work great on my computer!

Now for the next question..... Does anyone know how to do this using quicksheet for the iphone? ("Match" is not a command for that program, so i cannot get the above formulas to work.....)