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