Create List Based on Results

In excel2007, I track a listing of golf scores, by hole, by player and would like to build a separate listing of players and the hole number where they have scored the lowest score for a given hole. For example, consider the following list:
A B C D
1 Player Hole 1 Hole 2 Hole 3
2 John 4 4 4
3 Fred 4 3 3
4 Bob 5 4 2
5 Dave 6 4 3

After all scores are entered, is there a formula I may enter in another section of the worksheet that would generate a list of those players who score the lowest on any given hole? For example, the results (based upon above table) should look like this:
G H
1 John Hole 2
2 Bob Hole 3
3

Thanks!

Attached is something which should work for you. A VLOOKUP won't work unfortunately as it relies on being able to return a value to the right of the value that you're looking up, where the names are on the left in your example.

I have instead resorted to doing a MATCH to return the row of the lowest score, and an INDIRECT to point it to the name column.

I hope this helps.