Golf Score sheet

Seems like a simple solution, but for me it's not. I have a golf scoring card that figures out the players lowest net scores for the front 9, back 9 and game. I want to place the corresponding name for those scores in the box as shown in my attachement. (b19,b22, b26) Thanks in advance for your help

Kaono

i tried to download your sheet. it has a password on it, and I can't open it. I asked a similar question couple of weeks ago. Here's the link to help you get started. http://www.excelforum.com/showthread.php?t=607086

i tried to download your sheet. it has a password on it, and I can't open it. I asked a similar question couple of weeks ago. Here's the link to help you get started. http://www.excelforum.com/showthread.php?t=607086

Sorry about that doc. Here is the unprotected excel sheet. Ill check on the match function in the mean time.

Just figured it out with your reference. I used a match/index with a combination of Min. =INDEX($B$3:$B$6,MATCH(MIN($G$3:$G$14),$G$3:$G$14,0))

Thanks for your assistance