I admit I started thinking about the problem just as you phrased it, 'how do I get the corresponding location value to my maximum number value'; however, this is best managed by a pivot table.

1. (optional) select data on sheet 1 and turn it into a table
2. create a pivot table
3. organize with list of locations in the 'rows' and numbers in the 'values'; ensure that values are set to show maximum (as opposed to sum etc).
4. right click on one of your maximum values shown for a given location and select 'organize by' and choose 'highest to lowest'. Your highest value is now at the top, and immediately left of it is the corresponding location.

hope that helps - the vlookup would not have been transparent to you about duplicates, this way you know if there is a tie for the winner.

ian.