Lookup and refer to smallest amount in a table of data

[JackBauer]

Hello Friends, I don't know exactly how to put this in simple terms but I need a solution for:

LETTER John Rick Jack Result
A 5 4 3 Jack
B 1 2 5 John
C 3 8 4 John
D 1 5 6 John

Lets imagine this table shows how many A's, B's, C's and D's John, Rick and Jack has.
I need to return person's name which has the smallest amount of each letter.
I know how to find smallest number in an array (row) but how to return the name of person?
Probably something to do with lookup and reference functions.

Thank You in advance

[Khalidngo]

Hi,

Try this:

=INDEX($B$1:$D$1,MATCH(MIN(B2:D2),B2:D2,0))

Assumed B1:D1 as headers, and data starts from row 2

Blessing

[NeedForExcel]

Here!

=INDEX($A$1:$C$1,MATCH(MIN(A2:C2),A2:C2,0))

Change the range as required.

[JackBauer]

Thank You!!! Works