User Profile
Paul00
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
vlookup
I downloaded some results from the Masters Golf Tournament and would like to use vlookup to populate a spreadsheet with only select golfers. I've reduced the leaderboard to save space. The formula in cell L2 is =VLOOKUP($K2,$B$1:$H$10,3,TRUE), formula in cell M2 is =VLOOKUP($K2,$B$1:$H$10,4,TRUE), etc. The result for the formula in cell L2 should lookup K2 (Scottie), find him in the range $B$1 and return column 3 which is 66. The results are coming from the last row for Cameron Young. I can't figure what I am doing wrong.
