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

PLAYER | POS | TO PAR | R1 | R2 | R3 | R4 | TOT | EARNINGS | FEDEX PTS
[NAME] | 1 | -12 | 65 | 69 | 65 | 69 | 268 | $1,845,000 | 600
[NAME] | 2 | -9 | 65 | 71 | 66 | 69 | 271 | $1,067,000 | 330
[NAME] | 3 | -6 | 69 | 73 | 69 | 63 | 274 | $684,000 | 0
[NAME] | T4 | -5 | 71 | 68 | 69 | 67 | 275 | $480,000 | 135
[NAME] | T4 | -5 | 67 | 73 | 67 | 68 | 275 | $480,000 | 135
[NAME] | T6 | -4 | 72 | 72 | 67 | 65 | 276 | $281,000 | 0
[NAME] | T6 | -4 | 69 | 76 | 66 | 65 | 276 | $281,000 | 95
[NAME] | T6 | -4 | 68 | 72 | 69 | 67 | 276 | $281,000 | 0
Branden Grace | T6 | -4 | 70 | 74 | 62 | 70 | 276 | $281,000 | 95
[NAME] | T6 | -4 | 65 | 72 | 68 | 71 | 276 | $281,000 | 95
[NAME] | T11 | -3 | 66 | 77 | 67 | 67 | 277 | $175,333 | 72
[NAME] | T11 | -3 | 72 | 68 | 67 | 70 | 277 | $175,333 | 0
[NAME] | T11 | -3 | 69 | 73 | 65 | 70 | 277 | $175,333 | 72
[NAME] | T14 | -2 | 75 | 66 | 71 | 66 | 278 | $128,917 | 58
[NAME] | T14 | -2 | 71 | 72 | 68 | 67 | 278 | $128,917 | 0
[NAME] | T14 | -2 | 73 | 71 | 66 | 68 | 278 | $128,917 | 58
[NAME] Poulter | T14 | -2 | 67 | 70 | 71 | 70 | 278 | $128,917 | 58
[NAME] | T14 | -2 | 68 | 72 | 66 | 72 | 278 | $128,917 | 58
[NAME] Connelly | T14 | -2 | 67 | 72 | 66 | 73 | 278 | $128,917 | 0
[NAME] | T20 | -1 | 69 | 75 | 70 | 65 | 279 | $104,500 | 50
[NAME] | T20 | -1 | 67 | 73 | 72 | 67 | 279 | $104,500 | 50
[NAME] | T22 | E | 69 | 74 | 70 | 67 | 280 | $88,000 | 42
[NAME] | T22 | E | 71 | 69 | 70 | 70 | 280 | $88,000 | 42
[NAME] | T22 | E | 67 | 72 | 70 | 71 | 280 | $88,000 | 0
[NAME] | T22 | E | 71 | 71 | 67 | 71 | 280 | $88,000 | 42
Richie Ramsay | T22 | E | 68 | 70 | 70 | 72 | 280 | $88,000 | 0
[NAME] | T27 | +1 | 69 | 76 | 72 | 64 | 281 | $64,500 | 29
[NAME] | T27 | +1 | 68 | 76 | 70 | 67 | 281 | $64,500 | 29
[NAME] | T27 | +1 | 71 | 74 | 69 | 67 | 281 | $64,500 | 0
[NAME] | T27 | +1 | 68 | 72 | 71 | 70 | 281 | $64,500 | 29
[NAME] | T27 | +1 | 70 | 73 | 68 | 70 | 281 | $64,500 | 0
[NAME] | T27 | +1 | 72 | 73 | 66 | 70 | 281 | $64,500 | 0
[NAME] | T27 | +1 | 76 | 69 | 66 | 70 | 281 | $64,500 | 0
[NAME] | T27 | +1 | 69 | 74 | 67 | 71 | 281 | $64,500 | 29
[NAME] | T27 | +1 | 70 | 73 | 67 | 71 | 281 | $64,500 | 29
[NAME] | T27 | +1 | 69 | 76 | 65 | 71 | 281 | $64,500 | 29
[NAME] | T37 | +2 | 70 | 70 | 75 | 67 | 282 | $45,286 | 18
[NAME] | T37 | +2 | 71 | 74 | 70 | 67 | 282 | $45,286 | 18
[NAME] | T37 | +2 | 70 | 72 | 72 | 68 | 282 | $45,286 | 0
[NAME] | T37 | +2 | 71 | 71 | 72 | 68 | 282 | $45,286 | 18
[NAME] | T37 | +2 | 72 | 72 | 70 | 68 | 282 | $45,286 | 0
[NAME] | T37 | +2 | 70 | 72 | 69 | 71 | 282 | $45,286 | 18
[NAME] | T37 | +2 | 73 | 69 | 68 | 72 | 282 | $45,286 | 18
[NAME] | T44 | +3 | 68 | 73 | 76 | 66 | 283 | $31,070 | 11
[NAME] Chang | T44 | +3 | 71 | 71 | 71 | 70 | 283 | $31,070 | 0
Jon Rahm | T44 | +3 | 69 | 74 | 70 | 70 | 283 | $31,070 | 11
[NAME] | T44 | +3 | 69 | 75 | 69 | 70 | 283 | $31,070 | 0
[NAME] | T44 | +3 | 72 | 72 | 69 | 70 | 283 | $31,070 | 0
[NAME] | T44 | +3 | 69 | 75 | 68 | 71 | 283 | $31,070 | 0
[NAME] | T44 | +3 | 68 | 75 | 68 | 72 | 283 | $31,070 | 11
Joost Luiten | T44 | +3 | 68 | 72 | 70 | 73 | 283 | $31,070 | 0
[NAME] | T44 | +3 | 69 | 73 | 68 | 73 | 283 | $31,070 | 0
[NAME] | T44 | +3 | 70 | 72 | 66 | 75 | 283 | $31,070 | 0
[NAME] | T54 | +4 | 70 | 71 | 74 | 69 | 284 | $25,843 | 6
[NAME] | T54 | +4 | 71 | 72 | 71 | 70 | 284 | $25,843 | 6
[NAME] | T54 | +4 | 72 | 72 | 70 | 70 | 284 | $25,843 | 6
Toby Tree | T54 | +4 | 70 | 75 | 69 | 70 | 284 | $25,843 | 0
[NAME] | T54 | +4 | 71 | 74 | 69 | 70 | 284 | $25,843 | 6
[NAME] | T54 | +4 | 71 | 74 | 65 | 74 | 284 | $25,843 | 0
[NAME] | T54 | +4 | 71 | 72 | 64 | 77 | 284 | $25,843 | 6
[NAME] | 61 | +5 | 68 | 73 | 70 | 74 | 285 | $25,000 | 5
Thorbjorn Olesen | [NAME] | +6 | 70 | 72 | 74 | 70 | 286 | $24,500 | 0
[NAME] | [NAME] | +6 | 72 | 73 | 71 | 70 | 286 | $24,500 | 4
[NAME] | [NAME] | +6 | 66 | 78 | 71 | 71 | 286 | $24,500 | 4
[NAME] | [NAME] | +6 | 75 | 70 | 70 | 71 | 286 | $24,500 | 0
Young-han Song | [NAME] | +6 | 71 | 74 | 69 | 72 | 286 | $24,500 | 0
[NAME] | [NAME] | +6 | 73 | 71 | 69 | 73 | 286 | $24,500 | 0
Alfie Plant | [NAME] | +6 | 71 | 73 | 69 | 73 | 286 | -- | 0
[NAME] | [NAME] | +6 | 71 | 74 | 65 | 76 | 286 | $24,500 | 0
[NAME] | T70 | +7 | 72 | 72 | 70 | 73 | 287 | $23,556 | 0
[NAME] | T70 | +7 | 70 | 75 | 69 | 73 | 287 | $23,556 | 0
[NAME] | T70 | +7 | 70 | 69 | 74 | 74 | 287 | $23,556 | 3
[NAME] | T70 | +7 | 73 | 72 | 68 | 74 | 287 | $23,556 | 0
[NAME] | T74 | +8 | 69 | 75 | 71 | 73 | 288 | $23,163 | 0
[NAME] | T74 | +8 | 68 | 76 | 70 | 74 | 288 | $23,163 | 3
[NAME] | 76 | +9 | 71 | 74 | 73 | 71 | 289 | $22,975 | 3
[NAME] | 77 | +10 | 68 | 72 | 74 | 76 | 290 | $22,850 | 0
[NAME] | - | CUT | 76 | 70 | -- | -- | 146 | -- | 0
Shiv Kapur | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 71 | 75 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 70 | 76 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 68 | 78 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
Pablo Larrazabal | - | CUT | 72 | 74 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 77 | 70 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 67 | 80 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 69 | 78 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 70 | 77 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 68 | 79 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 73 | 74 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 74 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
Byeong-Hun An | - | CUT | 77 | 71 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 75 | 73 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 75 | 73 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 70 | 78 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 70 | 78 | -- | -- | 148 | -- | 0
Gi-Whan Kim | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME]' Kruger | - | CUT | 76 | 72 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 76 | 72 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 68 | 81 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 76 | 73 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 74 | 75 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 74 | 75 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 77 | 72 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 71 | 78 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 74 | 75 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 70 | 79 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 77 | 73 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 77 | 73 | -- | -- | 150 | -- | 0
Prayad [NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
Shane Lowry | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 73 | 77 | -- | -- | 150 | -- | 0
Yuta Ikeda | - | CUT | 71 | 79 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 73 | 77 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 81 | 70 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 79 | 72 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
Jhonattan Vegas | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 74 | 77 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 78 | 74 | -- | -- | 152 | -- | 0
Darren Fichardt | - | CUT | 71 | 81 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 76 | 76 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 77 | 75 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 78 | 74 | -- | -- | 152 | -- | 0
Matthieu Pavon | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
Hideto Tanihara | - | CUT | 77 | 75 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 70 | 82 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 77 | 76 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 76 | 77 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 76 | 77 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 71 | 82 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 74 | 79 | -- | -- | 153 | -- | 0
Phachara Khongwatmai | - | CUT | 74 | 80 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 77 | 79 | -- | -- | 156 | -- | 0
[NAME] | - | CUT | 80 | 76 | -- | -- | 156 | -- | 0
[NAME] | - | CUT | 79 | 79 | -- | -- | 158 | -- | 0