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

PLAYER | POS | TO PAR | R1 | R2 | R3 | R4 | TOT | EARNINGS | FEDEX PTS
Shane Lowry | 1 | -15 | 67 | 67 | 63 | 72 | 269 | $1,935,000 | 600
[NAME] | 2 | -9 | 68 | 67 | 66 | 74 | 275 | $1,120,000 | 330
[NAME] | 3 | -7 | 68 | 70 | 68 | 71 | 277 | $718,000 | 210
[NAME] | T4 | -6 | 68 | 67 | 70 | 73 | 278 | $503,500 | 0
[NAME] | T4 | -6 | 68 | 69 | 67 | 74 | 278 | $503,500 | 135
[NAME] | T6 | -5 | 68 | 72 | 71 | 68 | 279 | $313,000 | 0
[NAME] | T6 | -5 | 68 | 71 | 71 | 69 | 279 | $313,000 | 98
[NAME] | T6 | -5 | 74 | 67 | 65 | 73 | 279 | $313,000 | 98
[NAME] | T6 | -5 | 70 | 69 | 66 | 74 | 279 | $313,000 | 98
[NAME] | 10 | -4 | 71 | 67 | 71 | 71 | 280 | $223,000 | 82
[NAME] | T11 | -3 | 74 | 69 | 72 | 66 | 281 | $171,700 | 68
[NAME] | T11 | -3 | 75 | 68 | 68 | 70 | 281 | $171,700 | 0
[NAME] | T11 | -3 | 71 | 70 | 68 | 72 | 281 | $171,700 | 68
[NAME] | T11 | -3 | 68 | 71 | 68 | 74 | 281 | $171,700 | 68
Jon Rahm | T11 | -3 | 68 | 70 | 68 | 75 | 281 | $171,700 | 68
[NAME] | T16 | -2 | 68 | 75 | 70 | 69 | 282 | $126,313 | 0
Lucas Bjerregaard | T16 | -2 | 70 | 68 | 74 | 70 | 282 | $126,313 | 0
[NAME] | T16 | -2 | 70 | 70 | 71 | 71 | 282 | $126,313 | 56
Sang-hyun Park | T16 | -2 | 69 | 72 | 68 | 73 | 282 | $126,313 | 0
[NAME] | T20 | -1 | 70 | 72 | 72 | 69 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 74 | 68 | 71 | 70 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 71 | 71 | 71 | 70 | 283 | $91,350 | 0
Lucas Glover | T20 | -1 | 72 | 69 | 71 | 71 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 70 | 68 | 72 | 73 | 283 | $91,350 | 0
[NAME] | T20 | -1 | 71 | 69 | 70 | 73 | 283 | $91,350 | 0
[NAME] | T20 | -1 | 70 | 66 | 71 | 76 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 70 | 69 | 68 | 76 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 70 | 67 | 69 | 77 | 283 | $91,350 | 42
[NAME] | T20 | -1 | 69 | 67 | 68 | 79 | 283 | $91,350 | 42
[NAME] | T30 | E | 70 | 71 | 70 | 73 | 284 | $69,875 | 31
[NAME] | T30 | E | 68 | 71 | 71 | 74 | 284 | $69,875 | 31
[NAME] | T32 | +1 | 68 | 73 | 77 | 67 | 285 | $56,278 | 23
[NAME] | T32 | +1 | 74 | 69 | 74 | 68 | 285 | $56,278 | 23
[NAME] | T32 | +1 | 70 | 71 | 74 | 70 | 285 | $56,278 | 0
[NAME] | T32 | +1 | 76 | 67 | 71 | 71 | 285 | $56,278 | 0
Joost Luiten | T32 | +1 | 73 | 69 | 71 | 72 | 285 | $56,278 | 0
[NAME] | T32 | +1 | 71 | 69 | 72 | 73 | 285 | $56,278 | 23
Byeong-Hun An | T32 | +1 | 73 | 67 | 70 | 75 | 285 | $56,278 | 23
[NAME] | T32 | +1 | 70 | 67 | 70 | 78 | 285 | $56,278 | 23
[NAME] | T32 | +1 | 68 | 69 | 70 | 78 | 285 | $56,278 | 23
[NAME] | T41 | +2 | 70 | 71 | 75 | 70 | 286 | $36,925 | 0
[NAME] | T41 | +2 | 75 | 67 | 73 | 71 | 286 | $36,925 | 13
[NAME] | T41 | +2 | 73 | 69 | 73 | 71 | 286 | $36,925 | 0
Inn-choon Hwang | T41 | +2 | 72 | 71 | 70 | 73 | 286 | $36,925 | 0
[NAME] | T41 | +2 | 72 | 69 | 71 | 74 | 286 | $36,925 | 13
[NAME] | T41 | +2 | 70 | 71 | 71 | 74 | 286 | $36,925 | 13
[NAME] | T41 | +2 | 71 | 65 | 74 | 76 | 286 | $36,925 | 0
[NAME] | T41 | +2 | 70 | 71 | 68 | 77 | 286 | $36,925 | 13
[NAME] | T41 | +2 | 74 | 65 | 69 | 78 | 286 | $36,925 | 13
[NAME] | T41 | +2 | 70 | 68 | 69 | 79 | 286 | $36,925 | 13
[NAME] | T51 | +3 | 70 | 72 | 77 | 68 | 287 | $28,317 | 0
Branden Grace | T51 | +3 | 70 | 71 | 75 | 71 | 287 | $28,317 | 8
[NAME] | T51 | +3 | 72 | 71 | 73 | 71 | 287 | $28,317 | 8
[NAME] | T51 | +3 | 73 | 70 | 72 | 72 | 287 | $28,317 | 0
[NAME] | T51 | +3 | 70 | 73 | 70 | 74 | 287 | $28,317 | 8
[NAME] | T51 | +3 | 72 | 67 | 72 | 76 | 287 | $28,317 | 8
[NAME] | T57 | +4 | 69 | 74 | 77 | 68 | 288 | $26,467 | 0
Thorbjorn Olesen | T57 | +4 | 72 | 68 | 77 | 71 | 288 | $26,467 | 0
[NAME] | T57 | +4 | 77 | 65 | 74 | 72 | 288 | $26,467 | 6
[NAME] | T57 | +4 | 72 | 70 | 73 | 73 | 288 | $26,467 | 6
[NAME] | T57 | +4 | 74 | 69 | 72 | 73 | 288 | $26,467 | 6
[NAME] | T57 | +4 | 73 | 70 | 68 | 77 | 288 | $26,467 | 6
[NAME] | T63 | +5 | 75 | 68 | 75 | 71 | 289 | $25,800 | 0
[NAME] | T63 | +5 | 73 | 68 | 75 | 73 | 289 | $25,800 | 5
[NAME] | T63 | +5 | 72 | 69 | 71 | 77 | 289 | $25,800 | 0
Romain Langasque | T63 | +5 | 69 | 72 | 70 | 78 | 289 | $25,800 | 0
[NAME] | T67 | +6 | 72 | 68 | 74 | 76 | 290 | $25,088 | 0
[NAME] | T67 | +6 | 72 | 71 | 71 | 76 | 290 | $25,088 | 0
[NAME] | T67 | +6 | 68 | 73 | 71 | 78 | 290 | $25,088 | 4
[NAME] | T67 | +6 | 66 | 68 | 69 | 87 | 290 | $25,088 | 4
[NAME] | 71 | +8 | 70 | 72 | 76 | 74 | 292 | $24,625 | 0
Nino Bertasio | T72 | +9 | 72 | 71 | 75 | 75 | 293 | $24,438 | 0
[NAME] | T72 | +9 | 70 | 73 | 70 | 80 | 293 | $24,438 | 0
[NAME] (a) | - | CUT | 71 | 73 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 73 | 71 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 73 | 71 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 72 | 72 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 79 | 65 | -- | -- | 144 | -- | 0
Nate Lashley | - | CUT | 75 | 69 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 75 | 69 | -- | -- | 144 | -- | 0
[NAME] (a) | - | CUT | 73 | 71 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 72 | 72 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 74 | 70 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 72 | 72 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 73 | 71 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 70 | 74 | -- | -- | 144 | -- | 0
[NAME] | - | CUT | 71 | 74 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 74 | 71 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 75 | 70 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 74 | 71 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 71 | 74 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 70 | 75 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 73 | 72 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 74 | 71 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 76 | 69 | -- | -- | 145 | -- | 0
Chez Reavie | - | CUT | 73 | 72 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 73 | 72 | -- | -- | 145 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] Senior | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 78 | 68 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 73 | 73 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 75 | 71 | -- | -- | 146 | -- | 0
[NAME] | - | CUT | 74 | 72 | -- | -- | 146 | -- | 0
[NAME] (a) | - | CUT | 76 | 71 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 77 | 70 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 71 | 76 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 76 | 71 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 76 | 71 | -- | -- | 147 | -- | 0
Jazz Janewattananond | - | CUT | 74 | 73 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 76 | 71 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 72 | 75 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 76 | 71 | -- | -- | 147 | -- | 0
Isidro Benitez | - | CUT | 75 | 72 | -- | -- | 147 | -- | 0
[NAME] | - | CUT | 71 | 77 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 73 | 75 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 74 | 74 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 76 | 72 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 78 | 70 | -- | -- | 148 | -- | 0
Gunn Charoenkul | - | CUT | 72 | 76 | -- | -- | 148 | -- | 0
[NAME] | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 74 | 75 | -- | -- | 149 | -- | 0
[NAME] Poulter | - | CUT | 75 | 74 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 76 | 73 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 73 | 76 | -- | -- | 149 | -- | 0
[NAME] | - | CUT | 76 | 74 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 77 | 73 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 75 | 75 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 78 | 72 | -- | -- | 150 | -- | 0
[NAME] | - | CUT | 76 | 75 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 78 | 73 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 77 | 74 | -- | -- | 151 | -- | 0
Curtis Knipes (a) | - | CUT | 72 | 79 | -- | -- | 151 | -- | 0
[NAME] Im | - | CUT | 71 | 80 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 78 | 73 | -- | -- | 151 | -- | 0
Yuta Ikeda | - | CUT | 76 | 75 | -- | -- | 151 | -- | 0
[NAME] | - | CUT | 73 | 79 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 75 | 77 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 83 | 69 | -- | -- | 152 | -- | 0
[NAME] | - | CUT | 79 | 73 | -- | -- | 152 | -- | 0
[NAME] Connelly | - | CUT | 75 | 79 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 73 | 81 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 78 | 76 | -- | -- | 154 | -- | 0
[NAME] | - | CUT | 82 | 73 | -- | -- | 155 | -- | 0
Dimitrios Papadatos | - | CUT | 83 | 72 | -- | -- | 155 | -- | 0
[NAME] (a) | - | CUT | 83 | 73 | -- | -- | 156 | -- | 0
[NAME] | - | CUT | 91 | 78 | -- | -- | 169 | -- | 0