Spreadsheet: 647013d1572248690-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-tennis-data-problem
Sheet: Sheet1

PLAYER 1 |  |  |  |  |  |  |  |  | PLAYER 2 |  |  |  |  |  |  |  |  | Carpet | Player | Name | Age | Wins | Matches Total | Surface
Name: Marin Cilic |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  |  |  |  |  |  |  | Player1 |  |  |  |  | 0.5263
Country: Croatia |  |  |  |  |  |  |  |  | Country: Poland |  |  |  |  |  |  |  |  |  | Player2 |  |  |  |  | 0.6
Birthdate: 28.09.88, 31 years |  |  |  |  |  |  |  |  | Birthdate: 11.02.97, 22 years
Height: 195 cm |  |  |  |  |  |  |  |  | ATP ranking: 35
Weight: 79 kg |  |  |  |  |  |  |  |  | TOP ranking's position: 33 (14.10.19, 1298 points)
Profi since: 2005 |  |  |  |  |  |  |  |  | Points: 1298
Right-handed |  |  |  |  |  |  |  |  | Prize money: 1.517.157 $
ATP ranking: 23 |  |  |  |  |  |  |  |  | Matches total: 356
TOP ranking's position: 3 (16.04.18, 4985 points) |  |  |  |  |  |  |  |  | Win: 217
Points: 1545 |  |  |  |  |  |  |  |  | %: 60.96 %
Prize money: 27.022.364 $ |  |  |  |  |  |  |  |  | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
Matches total: 931 |  |  |  |  |  |  |  |  | 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
Win: 612 |  |  |  |  |  |  |  |  | 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
%: 65.74 % |  |  |  |  |  |  |  |  | 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
year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic |  | 2016 | 48/28 | 2019-09-05 00:00:00 | 29/14 | 2019-10-07 00:00:00 | 0/2 | 0/0 | 0/0
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 |  | 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
2018 | 45/20 | 20/8 | 15/6 | 2019-04-05 00:00:00 | 0/0 | 2019-06-01 00:00:00 | 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
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 |  | 2012 | 0/1 | 0/0 | 0/1 | 0/0 | 0/0 | 0/0 | 0/0
2016 | 49/24 | 21/11 | 2019-04-03 00:00:00 | 17/7 | 0/0 | 2019-07-03 00:00:00 | 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
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 |  | perc. % | 0.6096 | 0.6735 | 0.6098 | 0.4808 | 0.6 | 0.4286 | 0
2014 | 54/21 | 24/9 | 2019-11-06 00:00:00 | 15/4 | 0/0 | 2019-04-02 00:00:00 | 0/0
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
2012 | 41/20 | 14/9 | 16/7 | 2019-02-02 00:00:00 | 0/0 | 2019-09-02 00:00:00 | 0/0
2011 | 44/23 | 14/9 | 13/7 | 15/5 | 0/0 | 2019-02-02 00:00:00 | 0/0
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
2009 | 49/23 | 22/12 | 2019-11-06 00:00:00 | 14/3 | 0/0 | 2019-02-02 00:00:00 | 0/0
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
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
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
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
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
TOTAL | 612/319 | 220/120 | 172/96 | 134/61 | 2019-10-09 00:00:00 | 76/33 | 0/0
perc. % | 0.6574 | 0.6471 | 0.6418 | 0.6872 | 0.5263 | 0.6972 | 0