Spreadsheet: 647202d1572332747-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-pq-reshaping-tennis-data-aligw
Sheet: Raw Data

Column1 | Column2 |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
PLAYER 1 | Name: Marin Cilic |  |  |  |  |  |  |  | PLAYER 1 | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
 | Country: Croatia |  |  |  |  |  |  |  |  | 2019 | 21/19 | 2019-12-10 00:00:00 | 2019-05-05 00:00:00 | 2019-02-02 00:00:00 | 0/0 | 2019-02-02 00:00:00 | 0/0
 | Birthdate: 28.09.88, 31 years |  |  |  |  |  |  |  |  | 2018 | 45/20 | 20/8 | 15/6 | 2019-04-05 00:00:00 | 0/0 | 2019-06-01 00:00:00 | 0/0
 | Height: 195 cm |  |  |  |  |  |  |  |  | 2017 | 46/22 | 2019-12-08 00:00:00 | 14/4 | 2019-08-07 00:00:00 | 0/0 | 2019-12-03 00:00:00 | 0/0
 | Weight: 79 kg |  |  |  |  |  |  |  |  | 2016 | 49/24 | 21/11 | 2019-04-03 00:00:00 | 17/7 | 0/0 | 2019-07-03 00:00:00 | 0/0
 | Profi since: 2005 |  |  |  |  |  |  |  |  | 2015 | 35/19 | 15/8 | 2019-07-06 00:00:00 | 2019-06-02 00:00:00 | 0/0 | 2019-07-03 00:00:00 | 0/0
 | Right-handed |  |  |  |  |  |  |  |  | 2014 | 54/21 | 24/9 | 2019-11-06 00:00:00 | 15/4 | 0/0 | 2019-04-02 00:00:00 | 0/0
 | ATP ranking: 23 |  |  |  |  |  |  |  |  | 2013 | 26/13 | 2019-07-04 00:00:00 | 2019-07-05 00:00:00 | 2019-07-02 00:00:00 | 0/0 | 2019-05-02 00:00:00 | 0/0
 | TOP ranking's position: 3 (16.04.18, 4985 points) |  |  |  |  |  |  |  |  | 2012 | 41/20 | 14/9 | 16/7 | 2019-02-02 00:00:00 | 0/0 | 2019-09-02 00:00:00 | 0/0
 | Points: 1545 |  |  |  |  |  |  |  |  | 2011 | 44/23 | 14/9 | 13/7 | 15/5 | 0/0 | 2019-02-02 00:00:00 | 0/0
 | Prize money: 27.022.364 $ |  |  |  |  |  |  |  |  | 2010 | 40/22 | 19/10 | 2019-09-05 00:00:00 | 2019-11-05 00:00:00 | 0/0 | 2019-01-02 00:00:00 | 0/0
 | Matches total: 931 |  |  |  |  |  |  |  |  | 2009 | 49/23 | 22/12 | 2019-11-06 00:00:00 | 14/3 | 0/0 | 2019-02-02 00:00:00 | 0/0
 | Win: 612 |  |  |  |  |  |  |  |  | 2008 | 38/26 | 20/10 | 2019-06-07 00:00:00 | 2019-04-05 00:00:00 | 2019-01-01 00:00:00 | 2019-07-03 00:00:00 | 0/0
 | %: 65.74 % |  |  |  |  |  |  |  |  | 2007 | 50/22 | 2019-08-06 00:00:00 | 22/7 | 2019-11-04 00:00:00 | 2019-05-02 00:00:00 | 2019-04-03 00:00:00 | 0/0
PLAYER 2 | Name: [NAME] |  |  |  |  |  |  |  |  | 2006 | 41/29 | 2019-05-03 00:00:00 | 15/15 | 2019-12-04 00:00:00 | 2019-04-05 00:00:00 | 2019-05-02 00:00:00 | 0/0
 | Country: Poland |  |  |  |  |  |  |  |  | 2005 | 30/13 | 2019-06-02 00:00:00 | 16/6 | 2019-05-03 00:00:00 | 0/1 | 2019-03-01 00:00:00 | 0/0
 | Birthdate: 11.02.97, 22 years |  |  |  |  |  |  |  |  | 2004 | 2019-03-03 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 0/0 | 0/0 | 0/0
 | ATP ranking: 35 |  |  |  |  |  |  |  |  | TOTAL | 612/319 | 220/120 | 172/96 | 134/61 | 2019-10-09 00:00:00 | 76/33 | 0/0
 | TOP ranking's position: 33 (14.10.19, 1298 points) |  |  |  |  |  |  |  |  | perc. % | 0.6574 | 0.6471 | 0.6418 | 0.6872 | 0.5263 | 0.6972 | 0
 | Points: 1298 |  |  |  |  |  |  |  | PLAYER 2 | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
 | Prize money: 1.517.157 $ |  |  |  |  |  |  |  |  | 2019 | 36/26 | 23/11 | 2019-07-07 00:00:00 | 2019-02-05 00:00:00 | 0/0 | 2019-04-03 00:00:00 | 0/0
 | Matches total: 356 |  |  |  |  |  |  |  |  | 2018 | 52/30 | 22/15 | 16/4 | 2019-09-06 00:00:00 | 2019-03-02 00:00:00 | 2019-02-03 00:00:00 | 0/0
 | Win: 217 |  |  |  |  |  |  |  |  | 2017 | 56/32 | 33/13 | 2019-12-12 00:00:00 | 2019-03-05 00:00:00 | 2019-08-02 00:00:00 | 0/0 | 0/0
 | %: 60.96 % |  |  |  |  |  |  |  |  | 2016 | 48/28 | 2019-09-05 00:00:00 | 29/14 | 2019-10-07 00:00:00 | 0/2 | 0/0 | 0/0
 |  |  |  |  |  |  |  |  |  | 2015 | 20/17 | 2019-10-02 00:00:00 | 2019-08-08 00:00:00 | 2019-01-04 00:00:00 | 2019-01-02 00:00:00 | 0/1 | 0/0
 |  |  |  |  |  |  |  |  |  | 2014 | 2019-05-05 00:00:00 | 2019-02-02 00:00:00 | 2019-03-02 00:00:00 | 0/0 | 0/0 | 0/1 | 0/0
 |  |  |  |  |  |  |  |  |  | 2012 | 0/1 | 0/0 | 0/1 | 0/0 | 0/0 | 0/0 | 0/0
 |  |  |  |  |  |  |  |  |  | TOTAL | 217/139 | 99/48 | 75/48 | 25/27 | 2019-12-08 00:00:00 | 2019-06-08 00:00:00 | 0/0
 |  |  |  |  |  |  |  |  |  | perc. % | 0.6096 | 0.6735 | 0.6098 | 0.4808 | 0.6 | 0.4286 | 0