A1:A6 has some names
B1:B6 has some numbers
=INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0))
returns the name from A associated with the minimum number in B
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
No, this is in three colums. Column 1 has the text, column 2 has a single
digit and Column three has the values.

"Bernard Liengme" wrote:

Is all this data in a single column? If so it will be hard to fulfill
your
request
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
Hi,

Question: I need to take a number (minimum value) from one cell and
find
the cell it came from, then return the text of the correspondeing cell
to
the
right but return the text that is 3 cells above. The Net Score of -4
would
be
the value in say C30. I would want to show in C31 the text in Name1
(A1)

EX.

Name1
Hdcp 22 9
Score 5
Net Score -4

Name2
Hdcp 7 3
Score 2
Net Score -1