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.
Bookmarks