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.
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. Read More
![Value error when subtracting 2 times in dd [hh]:mm:ss format](https://techcommunity.microsoft.com/t5/image/serverpage/image-id/628790i4E16C5FE588E53C4/image-size/medium?v=v2&px=400){kind=small}
