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

PLAYER | POS | TO PAR | R1 | R2 | R3 | R4 | TOT | EARNINGS | FEDEX PTS
[NAME] | 1 | -20 | 68 | 65 | 68 | 63 | 264 | $1,549,590 | 600
[NAME] | 2 | -17 | 63 | 69 | 70 | 65 | 267 | $890,190 | 330
[NAME] | 3 | -6 | 70 | 70 | 69 | 69 | 278 | $571,040.4 | 210
[NAME] | 4 | -5 | 67 | 75 | 68 | 69 | 279 | $444,435.6 | 150
[NAME] | T5 | -4 | 69 | 71 | 73 | 67 | 280 | $310,797.62 | 110
[NAME] | T5 | -4 | 70 | 71 | 71 | 68 | 280 | $310,797.62 | 0
[NAME] | T5 | -4 | 68 | 70 | 73 | 69 | 280 | $310,797.62 | 110
[NAME] | 8 | -3 | 69 | 69 | 70 | 73 | 281 | $224,196 | 0
[NAME] | T9 | -2 | 71 | 69 | 72 | 70 | 282 | $178,477.16 | 82
[NAME] | T9 | -2 | 67 | 68 | 75 | 72 | 282 | $178,477.16 | 0
[NAME] | T9 | -2 | 68 | 70 | 69 | 75 | 282 | $178,477.16 | 82
[NAME] | T12 | -1 | 71 | 71 | 72 | 69 | 283 | $122,153.85 | 0
[NAME] | T12 | -1 | 67 | 76 | 71 | 69 | 283 | $122,153.85 | 0
[NAME] | T12 | -1 | 69 | 72 | 72 | 70 | 283 | $122,153.85 | 64
[NAME] | T12 | -1 | 69 | 73 | 71 | 70 | 283 | $122,153.85 | 64
[NAME] | T12 | -1 | 67 | 70 | 75 | 71 | 283 | $122,153.85 | 64
[NAME] | T12 | -1 | 66 | 74 | 71 | 72 | 283 | $122,153.85 | 64
[NAME] | T18 | E | 71 | 72 | 70 | 71 | 284 | $91,491.75 | 0
[NAME] | T18 | E | 72 | 66 | 73 | 73 | 284 | $91,491.75 | 52
[NAME] | T18 | E | 67 | 68 | 76 | 73 | 284 | $91,491.75 | 52
[NAME] | T18 | E | 67 | 71 | 72 | 74 | 284 | $91,491.75 | 52
[NAME] | T22 | +1 | 71 | 73 | 73 | 68 | 285 | $69,113.03 | 0
[NAME] | T22 | +1 | 71 | 71 | 74 | 69 | 285 | $69,113.03 | 46
[NAME] | T22 | +1 | 68 | 77 | 70 | 70 | 285 | $69,113.03 | 46
[NAME] | T22 | +1 | 74 | 70 | 71 | 70 | 285 | $69,113.03 | 0
[NAME] | T22 | +1 | 73 | 70 | 71 | 71 | 285 | $69,113.03 | 46
[NAME] | T22 | +1 | 71 | 74 | 69 | 71 | 285 | $69,113.03 | 0
[NAME] | T22 | +1 | 73 | 73 | 68 | 71 | 285 | $69,113.03 | 46
[NAME] | T22 | +1 | 70 | 69 | 73 | 73 | 285 | $69,113.03 | 46
[NAME] | T30 | +2 | 71 | 75 | 72 | 68 | 286 | $51,488.59 | 39
[NAME] | T30 | +2 | 72 | 70 | 75 | 69 | 286 | $51,488.59 | 39
[NAME] | T30 | +2 | 72 | 73 | 71 | 70 | 286 | $51,488.59 | 39
[NAME] | T30 | +2 | 71 | 72 | 73 | 70 | 286 | $51,488.59 | 39
[NAME] | T30 | +2 | 68 | 76 | 70 | 72 | 286 | $51,488.59 | 0
Haydn Porteous | T30 | +2 | 70 | 76 | 68 | 72 | 286 | $51,488.59 | 0
[NAME] | T36 | +3 | 70 | 72 | 73 | 72 | 287 | $42,861 | 34
[NAME] | T36 | +3 | 69 | 71 | 73 | 74 | 287 | $42,861 | 34
[NAME] | T36 | +3 | 66 | 73 | 74 | 74 | 287 | $42,861 | 0
[NAME] | T39 | +4 | 70 | 76 | 72 | 70 | 288 | $37,091.25 | 31
[NAME] | T39 | +4 | 69 | 73 | 75 | 71 | 288 | $37,091.25 | 31
[NAME] | T39 | +4 | 68 | 71 | 75 | 74 | 288 | $37,091.25 | 0
[NAME] | T39 | +4 | 70 | 72 | 71 | 75 | 288 | $37,091.25 | 31
[NAME] | T43 | +5 | 69 | 73 | 76 | 71 | 289 | $31,321.5 | 27
[NAME] | T43 | +5 | 73 | 72 | 72 | 72 | 289 | $31,321.5 | 27
[NAME] | T43 | +5 | 70 | 70 | 72 | 77 | 289 | $31,321.5 | 27
Harris English | T46 | +6 | 73 | 73 | 73 | 71 | 290 | $25,227.33 | 22
[NAME] | T46 | +6 | 68 | 74 | 76 | 72 | 290 | $25,227.33 | 0
[NAME] | T46 | +6 | 69 | 72 | 76 | 73 | 290 | $25,227.33 | 22
[NAME] | T46 | +6 | 70 | 73 | 74 | 73 | 290 | $25,227.33 | 22
[NAME] | T46 | +6 | 70 | 72 | 73 | 75 | 290 | $25,227.33 | 0
[NAME] | T46 | +6 | 72 | 73 | 70 | 75 | 290 | $25,227.33 | 0
[NAME] | T46 | +6 | 71 | 68 | 75 | 76 | 290 | $25,227.33 | 22
[NAME] | T53 | +7 | 71 | 75 | 74 | 71 | 291 | $22,103.09 | 16
[NAME] | T53 | +7 | 71 | 75 | 73 | 72 | 291 | $22,103.09 | 16
[NAME] | T53 | +7 | 70 | 71 | 77 | 73 | 291 | $22,103.09 | 0
[NAME] | T53 | +7 | 74 | 69 | 75 | 73 | 291 | $22,103.09 | 16
[NAME] | T53 | +7 | 67 | 77 | 74 | 73 | 291 | $22,103.09 | 16
[NAME] | 58 | +8 | 71 | 75 | 74 | 72 | 292 | $21,364.56 | 0
[NAME] | T59 | +9 | 71 | 73 | 77 | 72 | 293 | $21,034.86 | 11
Jon Rahm | T59 | +9 | 74 | 71 | 73 | 75 | 293 | $21,034.86 | 0
[NAME] | T59 | +9 | 74 | 72 | 72 | 75 | 293 | $21,034.86 | 11
Byeong-Hun An | T59 | +9 | 70 | 70 | 76 | 77 | 293 | $21,034.86 | 0
[NAME] | T63 | +10 | 71 | 72 | 78 | 73 | 294 | $20,573.28 | 7
[NAME] | T63 | +10 | 72 | 74 | 74 | 74 | 294 | $20,573.28 | 0
[NAME] | T63 | +10 | 75 | 71 | 72 | 76 | 294 | $20,573.28 | 7
[NAME] | T66 | +11 | 69 | 76 | 74 | 76 | 295 | $20,243.58 | 0
[NAME] | T66 | +11 | 71 | 72 | 75 | 77 | 295 | $20,243.58 | 5
[NAME] | T68 | +12 | 72 | 73 | 77 | 74 | 296 | $19,847.94 | 2
[NAME] | T68 | +12 | 76 | 70 | 75 | 75 | 296 | $19,847.94 | 2
[NAME] | T68 | +12 | 74 | 72 | 74 | 76 | 296 | $19,847.94 | 2
[NAME] | T68 | +12 | 69 | 72 | 76 | 79 | 296 | $19,847.94 | 2
[NAME] | T72 | +13 | 71 | 73 | 77 | 76 | 297 | $19,320.42 | 0
Yuta Ikeda | T72 | +13 | 68 | 74 | 78 | 77 | 297 | $19,320.42 | 0
Branden Grace | T72 | +13 | 70 | 74 | 76 | 77 | 297 | $19,320.42 | 1
[NAME] | T72 | +13 | 69 | 73 | 76 | 79 | 297 | $19,320.42 | 1
[NAME] | 76 | +14 | 70 | 72 | 80 | 76 | 298 | $18,990.72 | 1
[NAME] | 77 | +15 | 71 | 73 | 78 | 77 | 299 | $18,858.84 | 1
[NAME] | 78 | [NAME] | 71 | 75 | 79 | 76 | 301 | $18,726.96 | 0
Kodai Ichihara | T79 | +18 | 69 | 77 | 78 | 78 | 302 | $18,529.14 | 0
Soo-min [NAME] | T79 | +18 | 68 | 77 | 75 | 82 | 302 | $18,529.14 | 0
[NAME] | 81 | +21 | 72 | 71 | 77 | 85 | 305 | $18,331.32 | 1
[NAME] | - | CUT | 72 | 75 | -- | -- | 147 | -- | 0
Richie Ramsay | - | CUT | 73 | 74 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 72 | 75 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 71 | 76 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 69 | 79 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
Matteo Manassero | - | CUT | 70 | 78 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 68 | 80 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 75 | 73 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 70 | 78 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
Sang-hee [NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
Shane Lowry | - | CUT | 78 | 71 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 71 | 78 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
Joost Luiten | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 76 | 73 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 74 | 75 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 71 | 79 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 73 | 77 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 71 | 79 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 72 | 78 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 74 | 76 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 77 | 73 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 78 | 73 | -- | -- | 151 | -- | 0
Thorbjorn Olesen | - | CUT | 72 | 79 | -- | -- | 151 | -- | 0
Hideto Tanihara | - | CUT | 72 | 79 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 77 | 74 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 75 | 76 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 77 | 74 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 74 | 77 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 73 | 78 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 72 | 80 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 67 | 85 | -- | -- | 152 | -- | 0
Phachara Khongwatmai | - | CUT | 71 | 81 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 72 | 80 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 74 | 78 | -- | -- | 152 | -- | 0
[NAME] Senior | - | CUT | 79 | 73 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 75 | 77 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 73 | 80 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 75 | 78 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 78 | 75 | -- | -- | 153 | -- | 0
[NAME] Kodaira | - | CUT | 76 | 77 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 77 | 76 | -- | -- | 153 | -- | 0
[NAME] | - | CUT | 71 | 83 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 76 | 78 | -- | -- | 154 | -- | 0
Stefano Mazzoli | - | CUT | 76 | 78 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 73 | 81 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 78 | 77 | -- | -- | 155 | -- | 0
[NAME] | - | CUT | 77 | 78 | -- | -- | 155 | -- | 0
[NAME] | - | CUT | 74 | 81 | -- | -- | 155 | -- | 0
[NAME] | - | CUT | 79 | 78 | -- | -- | 157 | -- | 0
[NAME] | - | CUT | 77 | 81 | -- | -- | 158 | -- | 0
[NAME] | - | CUT | 75 | 84 | -- | -- | 159 | -- | 0
[NAME] | - | CUT | 77 | 83 | -- | -- | 160 | -- | 0
[NAME] | - | CUT | 85 | 78 | -- | -- | 163 | -- | 0
[NAME] | - | WD | 82 | -- | -- | -- | 82 | -- | 0
[NAME] | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
[NAME] | - | WD | -- | -- | -- | -- | -- | -- | 0