Spreadsheet: 647378d1572421498-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-pq-tennis-data-from-website-olly
Sheet: Player List

ATP Ranking | Name | Country | Points
445 | [NAME] | CHE | 74
394 | [NAME] | CZE | 94
43 | [NAME] | FRA | 1111
240 | Adrian Menendez-Maceiras | ESP | 206
379 | [NAME] | ARG | 99
493 | [NAME] | GBR | 61
245 | [NAME] | AUS | 197
40 | [NAME] | ESP | 1130
487 | [NAME] | BIH | 62
82 | Alejandro Davidovich Fokina | ESP | 653
471 | Alejandro [NAME] | COL | 66
210 | Alejandro Tabilo | CHL | 244
269 | Aleksandar Vukic | AUS | 165
220 | Aleksandr Nedovesov | KAZ | 224
433 | [NAME] | RUS | 79
411 | Alessandro Bega | ITA | 85
149 | Alessandro Giannessi | ITA | 361
162 | [NAME] | AUS | 313
18 | [NAME] | AUS | 1695
335 | [NAME] | SVK | 121
48 | [NAME] | KAZ | 1030
388 | [NAME] | CHE | 95
460 | [NAME] | RUS | 69
6 | [NAME] | DEU | 4335
247 | [NAME] | FRA | 189
95 | Alexei Popyrin | AUS | 585
197 | [NAME] | RUS | 258
64 | [NAME] | SVN | 905
332 | [NAME] | TUR | 122
323 | [NAME] | ITA | 125
204 | [NAME] | ARG | 248
359 | [NAME] | ITA | 111
418 | [NAME] | ITA | 82
74 | [NAME] | ITA | 760
115 | [NAME] | SVK | 490
429 | [NAME] | ESP | 79
160 | [NAME] | AUS | 320
22 | [NAME] | RUS | 1606
128 | [NAME] | GBR | 442
382 | Antoine Escoffier | FRA | 97
107 | [NAME] | FRA | 529
401 | Artem Dubrivnyy | RUS | 91
258 | [NAME] | BEL | 174
360 | [NAME] | FRA | 110
271 | [NAME] | RUS | 163
135 | [NAME] | HUN | 411
439 | [NAME] | TUN | 77
312 | [NAME] | FRA | 132
448 | [NAME] | CHL | 72
365 | [NAME] | FRA | 108
306 | [NAME] | LBN | 135
442 | [NAME] | ZWE | 76
23 | [NAME] | FRA | 1528
205 | [NAME] | ESP | 248
188 | [NAME] | AUS | 273
165 | [NAME] | USA | 302
284 | [NAME] | SVN | 145
140 | [NAME] | SVN | 384
455 | [NAME] | RUS | 70
25 | [NAME] | HRV | 1495
292 | [NAME] | HRV | 140
211 | [NAME] | NLD | 243
100 | [NAME] | USA | 559
484 | [NAME] | USA | 62
99 | [NAME] | CAN | 560
410 | [NAME] Sant'Anna | BRA | 86
402 | Brydan Klein | GBR | 90
454 | [NAME] | FRA | 70
57 | [NAME] | GBR | 960
432 | [NAME] | ARG | 79
497 | [NAME] Garfia | ESP | 60
350 | [NAME] | ARG | 112
458 | [NAME] | ESP | 69
479 | [NAME] | ESP | 64
214 | [NAME] | ESP | 238
63 | Casper Ruud | NOR | 931
166 | Cedrik-Marcel Stebe | DEU | 302
274 | [NAME] | TUR | 159
42 | [NAME] | CHL | 1117
344 | [NAME] | SWE | 116
207 | [NAME] | USA | 246
358 | [NAME] | BEL | 111
139 | [NAME] | AUS | 385
340 | [NAME] | TAI | 118
399 | [NAME] | USA | 92
230 | [NAME] | FRA | 216
298 | [NAME] | FRA | 138
97 | [NAME] | FRA | 584
91 | [NAME] | BIH | 609
386 | [NAME] | FRA | 96
368 | [NAME] | DEU | 105
467 | Daniel Brands | DEU | 66
199 | [NAME] | COL | 256
41 | [NAME] | GBR | 1124
366 | [NAME] | ESP | 108
241 | [NAME] | DEU | 204
499 | [NAME] | POL | 60
355 | [NAME] | USA | 111
4 | [NAME] | RUS | 5740
172 | Danilo Petrovic | SRB | 294
169 | [NAME] | BAR | 298
226 | [NAME] | ESP | 220
14 | [NAME] | BEL | 2325
370 | [NAME] | AUS | 104
175 | [NAME] | UZB | 288
111 | [NAME] | USA | 500
28 | [NAME] | CAN | 1460
321 | [NAME] | KAZ | 128
124 | [NAME] | AUT | 454
322 | [NAME] | CHN | 126
391 | [NAME] | ECU | 95
15 | [NAME] | ARG | 2205
361 | [NAME] | BGR | 109
212 | Dmitry Popko | KAZ | 242
5 | Dominic Thiem | AUT | 5495
85 | [NAME] | DEU | 634
237 | [NAME] | USA | 210
257 | [NAME] | KOR | 177
142 | [NAME] | ISR | 373
34 | [NAME] | SRB | 1286
208 | [NAME] | DEU | 246
409 | [NAME] | ISR | 86
465 | [NAME] Lobato | ESP | 67
404 | Eduardo Struvay | COL | 89
104 | [NAME] | BLR | 545
123 | [NAME] | SWE | 455
206 | [NAME] | FRA | 247
148 | Emil Ruusuvuori | FIN | 363
144 | [NAME] | ECU | 367
434 | Enrico Dalla Valle | ITA | 79
186 | [NAME] | ESP | 276
191 | [NAME] | FRA | 271
233 | [NAME] | USA | 213
228 | Ernests Gulbis | LVA | 216
407 | [NAME] | FRA | 87
403 | [NAME] | GBR | 90
362 | [NAME] | USA | 109
441 | [NAME] | USA | 76
106 | Evgeny Donskoy | RUS | 530
263 | [NAME] | RUS | 173
415 | [NAME] | RUS | 84
12 | Fabio Fognini | ITA | 2370
437 | [NAME] | ITA | 78
250 | [NAME] | ARG | 184
138 | [NAME] | ARG | 389
200 | [NAME] | ARG | 253
385 | Fajing Sun | CHN | 96
121 | [NAME] | ARG | 470
79 | [NAME] | ARG | 694
154 | [NAME] | ITA | 350
58 | [NAME] | ESP | 958
383 | Felipe Meligeni Rodrigues Alves | BRA | 97
19 | [NAME] | CAN | 1681
49 | [NAME] | ESP | 1025
447 | [NAME] | [NAME] | 73
173 | [NAME] | SVK | 294
39 | [NAME] | SRB | 1148
300 | [NAME] | CAN | 137
213 | [NAME] | ITA | 239
46 | [NAME] | USA | 1085
476 | Francesco Forti | ITA | 65
251 | [NAME] | ARG | 184
202 | [NAME] | PRT | 250
428 | [NAME] | PRT | 80
13 | Gael Monfils | FRA | 2350
378 | Gastao Elias | PRT | 99
481 | Genaro Alberto Olivieri | ARG | 64
316 | [NAME] | FRA | 130
262 | [NAME] | ITA | 173
120 | [NAME] | ITA | 473
372 | [NAME] | ITA | 102
423 | [NAME] | NLD | 81
53 | [NAME] | FRA | 990
396 | [NAME] | ITA | 93
330 | [NAME] | FRA | 122
126 | Go Soeda | JPN | 448
265 | [NAME] | PRT | 172
338 | Gonzalo Escobar | ECU | 118
406 | [NAME] | ARG | 87
83 | Gregoire Barrere | FRA | 648
27 | [NAME] | BGR | 1477
113 | Guido Andreozzi | ARG | 495
20 | Guido Pella | ARG | 1620
328 | [NAME] | BRA | 124
143 | [NAME] | ESP | 372
293 | [NAME] | AUS | 140
105 | [NAME] | CHE | 541
390 | [NAME] | ARG | 95
224 | [NAME] | JPN | 221
37 | [NAME] | POL | 1198
76 | [NAME] | BOL | 698
266 | [NAME] | FRA | 170
302 | Hugo Grenier | FRA | 136
426 | Hugo Nys | FRA | 80
131 | [NAME] | KOR | 428
334 | Igor Sijsling | NLD | 121
256 | Illya Marchenko | UKR | 178
145 | Ilya Ivashka | BLR | 366
392 | [NAME] | RUS | 95
324 | [NAME] | RUS | 125
101 | [NAME] | HRV | 551
354 | [NAME] | GBR | 111
253 | [NAME] | USA | 180
416 | [NAME] | AUS | 83
489 | [NAME] | ITA | 62
130 | [NAME] | AUS | 430
289 | [NAME] | GBR | 143
288 | [NAME] | DEU | 143
473 | Jan Satral | CZE | 65
36 | Jan-Lennard Struff | DEU | 1200
218 | [NAME] | SRB | 225
93 | [NAME] | ITA | 596
133 | [NAME] | TAI | 417
264 | [NAME] | AUS | 172
98 | [NAME] | ESP | 568
317 | [NAME] | ESP | 130
190 | [NAME] | GBR | 272
294 | [NAME] | USA | 140
255 | [NAME] | USA | 178
353 | [NAME] | NLD | 112
275 | Jenson Brooksby | USA | 158
65 | [NAME] | FRA | 885
287 | [NAME] | DEU | 143
333 | [NAME] | BEL | 122
492 | [NAME] | NLD | 61
261 | [NAME] | KOR | 173
119 | [NAME] | CZE | 474
35 | Jo-Wilfried Tsonga | FRA | 1230
196 | [NAME] | PRT | 265
194 | [NAME] | BRA | 266
60 | [NAME] | PRT | 941
488 | [NAME] | CHE | 62
446 | Johan Sebastien Tatlot | FRA | 73
431 | [NAME] | DEU | 79
17 | [NAME] | USA | 1850
52 | [NAME] | AUS | 1016
304 | [NAME] | AUS | 135
61 | [NAME] | AUS | 938
453 | [NAME] | ARG | 71
281 | [NAME] | DOM | 148
180 | [NAME] | SVK | 285
51 | [NAME] | ARG | 1017
122 | [NAME] | ARG | 460
249 | [NAME] | ARG | 185
155 | [NAME] | PER | 346
377 | [NAME] | FRA | 100
238 | [NAME] | DEU | 210
397 | [NAME] | ITA | 93
462 | [NAME] | JPN | 68
450 | [NAME] | EST | 71
290 | [NAME] | AUT | 142
469 | [NAME] | POL | 66
283 | Kaichi Uchida | JPN | 147
90 | [NAME] | POL | 611
8 | [NAME] | RUS | 2830
373 | Karim-Mohamed Maamoun | EGY | 102
11 | [NAME] | JPN | 2560
45 | [NAME] | JAR | 1100
320 | [NAME] | USA | 128
477 | [NAME] | DEU | 64
351 | Khumoun Sultanov | UZB | 112
157 | [NAME] | BEL | 331
297 | [NAME] | RUS | 138
75 | [NAME] | GBR | 710
38 | Laslo Djere | SRB | 1161
356 | Laurent Lokoli | FRA | 111
420 | [NAME] | LTU | 81
94 | [NAME] | ARG | 588
259 | [NAME] | GBR | 174
422 | Lloyd Glasspool | GBR | 81
103 | [NAME] | JAR | 547
146 | [NAME] | ITA | 364
421 | [NAME] | ITA | 81
54 | [NAME] | ITA | 990
414 | [NAME] | DEU | 84
375 | Luca Vanni | ITA | 101
495 | Lucas Catarina | MCO | 61
456 | Lucas Gerch | DEU | 70
276 | Lucas Miedler | AUT | 158
21 | Lucas Pouille | FRA | 1610
331 | [NAME] | SVK | 122
193 | [NAME] | SVK | 269
153 | [NAME] | CZE | 350
352 | [NAME] | AUS | 112
132 | [NAME] | USA | 425
459 | [NAME] | JPN | 69
150 | [NAME] | TUN | 357
315 | [NAME] | FRA | 131
452 | [NAME] | ARG | 71
137 | [NAME] | AUS | 398
277 | [NAME] | CHE | 154
112 | Marcel Granollers | ESP | 497
364 | [NAME] | ESV | 108
326 | [NAME] | CHL | 124
71 | [NAME] | ITA | 790
215 | [NAME] | ARG | 236
171 | [NAME] | CYP | 294
125 | [NAME] | USA | 449
24 | [NAME] | HRV | 1500
179 | [NAME] | ESP | 286
156 | Marius Copil | [NAME] | 344
498 | [NAME] | SRB | 60
301 | [NAME] | SWE | 136
440 | [NAME] | URY | 76
141 | [NAME] | SVK | 373
443 | [NAME] | USA | 75
427 | Martins Podzus | LVA | 80
69 | [NAME] | HUN | 815
229 | [NAME] | FRA | 216
444 | [NAME] | FRA | 75
337 | [NAME] | ARG | 119
491 | Matija Pecotic | HRV | 61
177 | Mats Moraing | DEU | 288
9 | Matteo Berrettini | ITA | 2705
496 | Matteo Martineau | FRA | 61
227 | Matteo Viola | ITA | 217
223 | [NAME] | AUS | 221
189 | Matthias Bachinger | DEU | 273
348 | [NAME] | AUS | 114
222 | [NAME] | AUS | 223
384 | [NAME] | FRA | 97
182 | Maxime Cressy | FRA | 282
369 | [NAME] | FRA | 105
187 | [NAME] | FRA | 275
244 | [NAME] | DEU | 198
475 | [NAME] | ARG | 65
363 | [NAME] | BEL | 109
278 | [NAME] | USA | 152
327 | [NAME] | USA | 124
438 | [NAME] | CZE | 77
436 | Michail Pervolarakis | CYP | 78
168 | [NAME] | DEN | 299
73 | [NAME] | SWE | 765
67 | [NAME] | KAZ | 816
32 | [NAME] | CAN | 1350
55 | [NAME] | SRB | 975
299 | [NAME] | BIH | 137
291 | [NAME] | DEU | 141
201 | [NAME] | USA | 252
219 | [NAME] | EGY | 225
486 | [NAME] | VNM | 62
339 | [NAME] | BIH | 118
30 | [NAME] | AUS | 1395
178 | Nicola Kuhn | DEU | 287
357 | [NAME] | PER | 111
77 | [NAME] | CHL | 695
170 | [NAME] | FRA | 295
417 | [NAME] | COL | 83
449 | [NAME] | NLD | 72
151 | Nikola Milojevic | SRB | 356
419 | [NAME] | ESP | 82
26 | [NAME] | GEO | 1485
279 | Nino Serdarusic | HRV | 152
216 | [NAME] | USA | 236
109 | [NAME] | SVK | 507
1 | Novak Djokovic | SRB | 9545
303 | [NAME] | ESP | 136
295 | Orlando Luz | BRA | 140
371 | [NAME] | BRA | 104
161 | [NAME] | DEU | 315
59 | Pablo Andujar | ESP | 955
29 | [NAME] | ESP | 1420
44 | Pablo Cuevas | URY | 1102
461 | [NAME] | ESP | 68
117 | [NAME] | ITA | 476
252 | [NAME] | RUS | 183
483 | Pavel Nejedly | CZE | 63
231 | [NAME] | SRB | 215
273 | [NAME] | ARG | 160
167 | [NAME] [NAME] | ESP | 300
345 | [NAME] | BRA | 116
127 | [NAME] | PRT | 443
118 | [NAME] | DEU | 475
380 | [NAME] | DEU | 99
159 | [NAME] | CAN | 322
349 | [NAME] | DEU | 113
78 | [NAME] | DEU | 694
66 | [NAME] | FRA | 845
425 | [NAME] | ESP | 81
92 | Prajnesh [NAME] | IND | 601
184 | [NAME] | FRA | 279
50 | [NAME] | MDA | 1022
472 | [NAME] | BRA | 66
2 | [NAME] | ESP | 9225
195 | [NAME] | IND | 266
314 | [NAME] | ITA | 131
408 | [NAME] | FRA | 86
31 | Reilly Opelka | USA | 1363
470 | [NAME] | JPN | 66
270 | [NAME] | ARG | 165
494 | Ricardo Rodriguez-Pace | VEN | 61
480 | [NAME] | ITA | 64
376 | [NAME] | ITA | 101
70 | [NAME] | LTU | 809
62 | [NAME] | FRA | 935
398 | Rio Noguchi | JPN | 93
10 | [NAME] | ESP | 2575
81 | [NAME] | ESP | 664
280 | [NAME] | DOM | 150
192 | [NAME] | ITA | 270
248 | [NAME] | ESP | 189
268 | [NAME] | ECU | 167
152 | [NAME] | NLD | 351
3 | [NAME] | CHE | 6950
242 | [NAME] | BRA | 200
236 | [NAME] | RUS | 213
457 | [NAME] | RUS | 70
310 | [NAME] | USA | 132
217 | Ruben Bemelmans | BEL | 226
163 | [NAME] | DEU | 308
313 | [NAME] | USA | 131
381 | [NAME] | GBR | 97
400 | [NAME] | USA | 91
342 | [NAME] | FRA | 117
260 | [NAME] | IND | 173
96 | Salvatore Caruso | ITA | 585
47 | [NAME] | USA | 1065
343 | Sandro Ehrat | CHE | 116
393 | Sanjar Fayziev | UZB | 94
254 | [NAME] | COL | 180
235 | Sasi Kumar Mukund | IND | 213
474 | [NAME] | NLD | 65
430 | [NAME] | ARG | 79
405 | [NAME] | DEU | 89
305 | [NAME] | USA | 135
164 | [NAME] | AUT | 304
336 | [NAME] | USA | 121
482 | [NAME] | KOR | 63
147 | [NAME] | UKR | 363
374 | [NAME] | JPN | 102
478 | [NAME] | JPN | 64
272 | Shuichi Sekiguchi | JPN | 162
329 | [NAME] | ITA | 123
308 | Skander [NAME] | TUN | 134
87 | Soon-Woo Kwon | KOR | 627
16 | [NAME] | CHE | 1910
485 | [NAME] | USA | 62
232 | [NAME] | ITA | 214
88 | Stefano Travaglia | ITA | 627
7 | Stefanos Tsitsipas | GRC | 3830
181 | [NAME] | BEL | 284
84 | [NAME] | USA | 640
136 | [NAME] | CAN | 410
129 | Sumit Nagal | IND | 435
413 | [NAME] | FRA | 84
176 | [NAME] | NLD | 288
110 | [NAME] | JPN | 501
134 | [NAME] | JPN | 413
33 | [NAME] [NAME] | USA | 1315
282 | [NAME] | RUS | 148
68 | [NAME] | USA | 816
203 | [NAME] | USA | 250
198 | Thanasi Kokkinakis | AUS | 256
89 | Thiago [NAME] | BRA | 616
311 | Thiago Seyboth Wild | BRA | 132
114 | [NAME] | ITA | 490
319 | Thomaz Bellucci | BRA | 129
318 | [NAME] | USA | 129
387 | [NAME] | NLD | 95
239 | [NAME] | DEU | 207
490 | [NAME] | DEU | 62
102 | [NAME] | CZE | 550
307 | [NAME] | CZE | 135
395 | [NAME] | ARG | 94
80 | [NAME] | USA | 685
209 | [NAME] | ESP | 244
225 | [NAME] | FRA | 221
286 | [NAME] | TAI | 144
234 | [NAME] | TAI | 213
56 | [NAME] | FRA | 972
309 | [NAME] | BLR | 133
389 | Ulises Blanch | USA | 95
347 | [NAME] | CZE | 115
174 | Vasek Pospisil | CAN | 289
341 | [NAME] | NOR | 117
246 | [NAME] | HRV | 194
158 | [NAME] | SRB | 330
346 | [NAME] | CZE | 116
435 | Vladyslav Orlov | UKR | 79
463 | [NAME] | BRA | 68
221 | [NAME] | CHN | 223
183 | [NAME] | DEU | 279
116 | [NAME] | DEU | 480
424 | [NAME] | BEL | 81
86 | [NAME] | JPN | 632
72 | [NAME] | JPN | 787
285 | [NAME] | JPN | 145
464 | [NAME] | EGY | 67
468 | [NAME] | ISR | 66
466 | [NAME] | TAI | 67
108 | Yuichi Sugita | JPN | 518
296 | [NAME] | KOR | 139
451 | [NAME] | JPN | 71
367 | [NAME] | JPN | 106
267 | Zdenek Kolar | CZE | 170
325 | [NAME] | CHN | 124
243 | [NAME] | CHN | 199
185 | [NAME] | CHN | 278
412 | Zsombor Piros | HUN | 84