Spreadsheet: 782728d1654209260-vlookup-with-potentially-two-different-lookup-values-past-results
Sheet: 2018

PLAYER | POS | TO PAR | R1 | R2 | R3 | R4 | TOT | EARNINGS | FEDEX PTS
[NAME] | 1 | -8 | 70 | 72 | 65 | 69 | 276 | $1,890,000 | 600
[NAME] | T2 | -6 | 72 | 73 | 64 | 69 | 278 | $694,250 | 203
[NAME] | T2 | -6 | 69 | 69 | 70 | 70 | 278 | $694,250 | 203
[NAME] | T2 | -6 | 66 | 70 | 68 | 74 | 278 | $694,250 | 203
[NAME] | T2 | -6 | 71 | 66 | 67 | 74 | 278 | $694,250 | 203
[NAME] | T6 | -5 | 71 | 70 | 71 | 67 | 279 | $327,000 | 0
[NAME] | T6 | -5 | 71 | 71 | 66 | 71 | 279 | $327,000 | 101
[NAME] | T6 | -5 | 70 | 69 | 67 | 73 | 279 | $327,000 | 101
[NAME] | T9 | -4 | 67 | 71 | 71 | 71 | 280 | $219,000 | 82
[NAME] | T9 | -4 | 70 | 68 | 70 | 72 | 280 | $219,000 | 82
[NAME] | T9 | -4 | 72 | 67 | 65 | 76 | 280 | $219,000 | 82
[NAME] | T12 | -3 | 70 | 71 | 70 | 70 | 281 | $154,500 | 65
Thorbjorn Olesen | T12 | -3 | 70 | 70 | 70 | 71 | 281 | $154,500 | 0
[NAME] | T12 | -3 | 68 | 73 | 69 | 71 | 281 | $154,500 | 65
[NAME] | T12 | -3 | 72 | 65 | 71 | 73 | 281 | $154,500 | 65
[NAME] | T12 | -3 | 70 | 71 | 67 | 73 | 281 | $154,500 | 65
[NAME] | T17 | -2 | 71 | 71 | 72 | 68 | 282 | $109,714 | 51
[NAME] | T17 | -2 | 69 | 68 | 74 | 71 | 282 | $109,714 | 51
[NAME] | T17 | -2 | 67 | 71 | 71 | 73 | 282 | $109,714 | 0
[NAME] | T17 | -2 | 71 | 70 | 68 | 73 | 282 | $109,714 | 51
[NAME] | T17 | -2 | 71 | 70 | 68 | 73 | 282 | $109,714 | 51
[NAME] | T17 | -2 | 69 | 67 | 72 | 74 | 282 | $109,714 | 51
[NAME] | T17 | -2 | 70 | 71 | 67 | 74 | 282 | $109,714 | 51
[NAME] | T24 | -1 | 72 | 70 | 71 | 70 | 283 | $84,000 | 39
[NAME] | T24 | -1 | 73 | 69 | 70 | 71 | 283 | $84,000 | 39
Bernhard Langer | T24 | -1 | 73 | 71 | 68 | 71 | 283 | $84,000 | 39
[NAME] | T24 | -1 | 69 | 71 | 70 | 73 | 283 | $84,000 | 0
[NAME] | T28 | E | 70 | 73 | 70 | 71 | 284 | $67,143 | 30
[NAME] | T28 | E | 74 | 69 | 70 | 71 | 284 | $67,143 | 0
[NAME] | T28 | E | 70 | 69 | 73 | 72 | 284 | $67,143 | 30
[NAME] | T28 | E | 75 | 70 | 68 | 71 | 284 | $67,143 | 30
[NAME] | T28 | E | 72 | 70 | 69 | 73 | 284 | $67,143 | 30
[NAME] | T28 | E | 70 | 74 | 66 | 74 | 284 | $67,143 | 0
[NAME] | T28 | E | 72 | 70 | 67 | 75 | 284 | $67,143 | 30
[NAME] | T35 | +1 | 70 | 75 | 71 | 69 | 285 | $53,750 | 22
[NAME] | T35 | +1 | 73 | 70 | 71 | 71 | 285 | $53,750 | 22
[NAME] | T35 | +1 | 73 | 69 | 69 | 74 | 285 | $53,750 | 22
[NAME] Kodaira | T35 | +1 | 72 | 71 | 68 | 74 | 285 | $53,750 | 22
[NAME] | T39 | +2 | 70 | 70 | 77 | 69 | 286 | $41,375 | 15
[NAME] | T39 | +2 | 71 | 72 | 73 | 70 | 286 | $41,375 | 0
[NAME] | T39 | +2 | 72 | 69 | 75 | 70 | 286 | $41,375 | 15
[NAME] | T39 | +2 | 74 | 71 | 71 | 70 | 286 | $41,375 | 0
[NAME] | T39 | +2 | 77 | 67 | 71 | 71 | 286 | $41,375 | 0
[NAME] | T39 | +2 | 75 | 70 | 68 | 73 | 286 | $41,375 | 15
[NAME] | T39 | +2 | 71 | 72 | 67 | 76 | 286 | $41,375 | 0
[NAME] | T39 | +2 | 72 | 69 | 69 | 76 | 286 | $41,375 | 15
[NAME] | T47 | +3 | 68 | 76 | 73 | 70 | 287 | $31,000 | 10
[NAME] | T47 | +3 | 75 | 70 | 68 | 74 | 287 | $31,000 | 0
[NAME] | T47 | +3 | 71 | 71 | 69 | 76 | 287 | $31,000 | 0
[NAME] | T47 | +3 | 71 | 74 | 65 | 77 | 287 | $31,000 | 0
[NAME] | T51 | +4 | 75 | 70 | 73 | 70 | 288 | $27,161 | 7
[NAME] | T51 | +4 | 74 | 71 | 72 | 71 | 288 | $27,161 | 7
[NAME] | T51 | +4 | 70 | 73 | 73 | 72 | 288 | $27,161 | 7
[NAME] | T51 | +4 | 73 | 71 | 72 | 72 | 288 | $27,161 | 7
[NAME] | T51 | +4 | 73 | 71 | 71 | 73 | 288 | $27,161 | 0
Yuta Ikeda | T51 | +4 | 70 | 73 | 71 | 74 | 288 | $27,161 | 0
[NAME] | T51 | +4 | 75 | 70 | 68 | 75 | 288 | $27,161 | 7
[NAME] | T51 | +4 | 73 | 69 | 69 | 77 | 288 | $27,161 | 0
Byeong-Hun An | T51 | +4 | 73 | 71 | 66 | 78 | 288 | $27,161 | 7
[NAME] | 60 | +5 | 72 | 72 | 69 | 76 | 289 | $25,800 | 6
[NAME] | T61 | +6 | 74 | 70 | 72 | 74 | 290 | $25,317 | 0
[NAME] | T61 | +6 | 72 | 73 | 71 | 74 | 290 | $25,317 | 0
Marcus Kinhult | T61 | +6 | 74 | 69 | 71 | 76 | 290 | $25,317 | 0
[NAME] | T61 | +6 | 68 | 72 | 73 | 77 | 290 | $25,317 | 0
[NAME] | T61 | +6 | 72 | 72 | 69 | 77 | 290 | $25,317 | 0
[NAME] | T61 | +6 | 74 | 68 | 69 | 79 | 290 | $25,317 | 0
[NAME] | T67 | +7 | 71 | 72 | 75 | 73 | 291 | $24,250 | 3
[NAME] | T67 | +7 | 71 | 73 | 73 | 74 | 291 | $24,250 | 0
[NAME] | T67 | +7 | 71 | 72 | 72 | 76 | 291 | $24,250 | 3
[NAME] | T67 | +7 | 69 | 72 | 73 | 77 | 291 | $24,250 | 0
[NAME] | T67 | +7 | 74 | 71 | 70 | 76 | 291 | $24,250 | 0
[NAME] | T67 | +7 | 69 | 72 | 72 | 78 | 291 | $24,250 | 3
[NAME] | T67 | +7 | 67 | 71 | 71 | 82 | 291 | $24,250 | 0
[NAME] | 74 | +8 | 74 | 70 | 76 | 72 | 292 | $23,675 | 3
[NAME] | T75 | +9 | 73 | 70 | 77 | 73 | 293 | $23,488 | 3
[NAME] | T75 | +9 | 74 | 71 | 74 | 74 | 293 | $23,488 | 0
[NAME] | T75 | +9 | 72 | 73 | 70 | 78 | 293 | -- | 0
[NAME] | 78 | +10 | 73 | 71 | 73 | 77 | 294 | $23,300 | 2
[NAME] | 79 | +11 | 74 | 71 | 73 | 77 | 295 | $23,175 | 2
[NAME] | - | CUT | 71 | 75 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 69 | 77 | -- | -- | 146 | -- | 0
Branden Grace | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
Chez Reavie | - | CUT | 69 | 77 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 72 | 74 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 71 | 76 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
Shane Lowry | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 71 | 76 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 73 | 74 | -- | -- | 147 | -- | 0
Jon Rahm | - | CUT | 69 | 78 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 72 | 75 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 72 | 75 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 76 | 72 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 75 | 73 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 74 | 74 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
Sang-hyun Park | - | CUT | 76 | 73 | -- | -- | 149 | -- | 0
Marcus Armitage | - | CUT | 80 | 69 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 69 | 80 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 72 | 77 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 71 | 78 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
Hideto Tanihara | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
Jhonattan Vegas | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
Haraldur Magnus | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
Kodai Ichihara | - | CUT | 78 | 72 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 71 | 79 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
Jazz Janewattananond | - | CUT | 74 | 76 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 82 | 68 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
Retief Goosen | - | CUT | 74 | 77 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 77 | 74 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 73 | 78 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 77 | 74 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 78 | 74 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 77 | 76 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 79 | 74 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 80 | 73 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 79 | 74 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 79 | 75 | -- | -- | 154 | -- | 0
[NAME] (a) | - | CUT | 80 | 74 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 76 | 78 | -- | -- | 154 | -- | 0
[NAME] Poulter | - | CUT | 73 | 81 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 82 | 72 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 78 | 77 | -- | -- | 155 | -- | 0
[NAME] Senior | - | CUT | 79 | 76 | -- | -- | 155 | -- | 0
[NAME] | - | CUT | 75 | 81 | -- | -- | 156 | -- | 0
[NAME] | - | CUT | 80 | 77 | -- | -- | 157 | -- | 0
[NAME] (a) | - | CUT | 79 | 79 | -- | -- | 158 | -- | 0
[NAME] | - | CUT | 76 | 82 | -- | -- | 158 | -- | 0
[NAME] | - | CUT | 82 | 83 | -- | -- | 165 | -- | 0
[NAME] | - | WD | 80 | -- | -- | -- | 80 | -- | 0