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

PLAYER 1 |  |  |  |  |  |  |  |  | PLAYER 2 |  |  |  |  |  |  |  |  | Carpet | Name | Age | Wins | Matches Total | Lost | Surf Win% | Best Surface | [NAME] win % | Prize Money
Name: [NAME] |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  |  |  |  |  |  | Player1 |  |  |  |  |  | 0.4 | I. Hard | 0.6398 | 14579007
Country: France |  |  |  |  |  |  |  |  | Country: Canada |  |  |  |  |  |  |  |  | Player2 |  |  |  |  |  | 0 | Clay | 0.6786 | 3464561
Birthdate: 27.12.84, 34 years |  |  |  |  |  |  |  |  | Birthdate: 15.04.99, 20 years
Height: 180 cm |  |  |  |  |  |  |  |  | ATP ranking: 28
Weight: 65 kg |  |  |  |  |  |  |  |  | TOP ranking's position: 20 (06.05.19, 1820 points)
Profi since: 2002 |  |  |  |  |  |  |  |  | Points: 1460
Right-handed |  |  |  |  |  |  |  |  | Prize money: 3.464.561 $
ATP ranking: 53 |  |  |  |  |  |  |  |  | Matches total: 302
TOP ranking's position: 6 (05.01.09, 3960 points) |  |  |  |  |  |  |  |  | Win: 192
Points: 990 |  |  |  |  |  |  |  |  | %: 63.58 %
Prize money: 14.579.007 $ |  |  |  |  |  |  |  |  | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
Matches total: 1066 |  |  |  |  |  |  |  |  | 2019 | 31/25 | 20/11 | 2019-04-06 00:00:00 | 2019-07-05 00:00:00 | 0/0 | 0/3 | 0/0
Win: 632 |  |  |  |  |  |  |  |  | 2018 | 35/28 | 18/13 | 2019-08-06 00:00:00 | 2019-07-05 00:00:00 | 0/0 | 2019-02-04 00:00:00 | 0/0
%: 59.29 % |  |  |  |  |  |  |  |  | 2017 | 47/27 | 24/9 | 0/4 | 17/10 | 0/0 | 2019-06-04 00:00:00 | 0/0
year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic |  | 2016 | 57/18 | 14/8 | 32/7 | 2019-05-03 00:00:00 | 0/0 | 2000-06-01 00:00:00 | 0/0
2019 | 28/27 | 2019-08-11 00:00:00 | 2019-05-06 00:00:00 | 2019-07-06 00:00:00 | 0/0 | 2019-08-04 00:00:00 | 0/0 |  | 2015 | 20/9 | 2019-04-05 00:00:00 | 2019-11-02 00:00:00 | 2019-03-01 00:00:00 | 0/0 | 2019-02-01 00:00:00 | 0/0
2018 | 35/27 | 2019-08-08 00:00:00 | 2019-10-08 00:00:00 | 13/7 | 0/0 | 2019-04-04 00:00:00 | 0/0 |  | 2014 | 0/2 | 0/0 | 0/1 | 0/1 | 0/0 | 0/0 | 0/0
2017 | 17/26 | 2019-05-09 00:00:00 | 2019-05-09 00:00:00 | 2019-06-05 00:00:00 | 0/0 | 2019-01-03 00:00:00 | 0/0 |  | 2013 | 2019-02-01 00:00:00 | 0/0 | 2019-02-01 00:00:00 | 0/0 | 0/0 | 0/0 | 0/0
2016 | 33/28 | 15/12 | 2019-09-06 00:00:00 | 2019-07-07 00:00:00 | 0/0 | 2019-02-03 00:00:00 | 0/0 |  | TOTAL | 192/110 | 80/46 | 57/27 | 39/25 | 0/0 | 16/12 | 0/0
2015 | 43/24 | 2019-11-10 00:00:00 | 2019-07-04 00:00:00 | 15/6 | 0/0 | 2019-10-04 00:00:00 | 0/0 |  | perc. % | 0.6358 | 0.6349 | 0.6786 | 0.6094 | 0 | 0.5714 | 0
2014 | 32/26 | 18/12 | 2019-11-09 00:00:00 | 0/3 | 0/0 | 2019-03-02 00:00:00 | 0/0
2013 | 36/24 | 2019-09-08 00:00:00 | 2019-10-08 00:00:00 | 14/6 | 0/0 | 2019-03-02 00:00:00 | 0/0
2012 | 44/25 | 2019-12-08 00:00:00 | 19/10 | 2019-10-04 00:00:00 | 0/0 | 2019-03-03 00:00:00 | 0/0
2011 | 39/27 | 19/10 | 15/9 | 2019-03-06 00:00:00 | 0/0 | 2019-02-02 00:00:00 | 0/0
2010 | 28/19 | 2019-10-10 00:00:00 | 2019-01-02 00:00:00 | 13/5 | 0/0 | 2019-04-02 00:00:00 | 0/0
2009 | 47/30 | 20/10 | 2019-07-10 00:00:00 | 16/6 | 0/2 | 2019-04-02 00:00:00 | 0/0
2008 | 2 | 2 | 2.5 | 1.625 | 2 | 2 | 0/0
2007 | 35/27 | 2019-08-09 00:00:00 | 18/10 | 2019-05-02 00:00:00 | 2019-02-03 00:00:00 | 2019-02-03 00:00:00 | 0/0
2006 | 41/29 | 13/8 | 17/10 | 2019-09-06 00:00:00 | 0/2 | 2019-02-03 00:00:00 | 0/0
2005 | 49/36 | 19/8 | 15/14 | 2019-12-09 00:00:00 | 2019-01-02 00:00:00 | 2019-02-02 00:00:00 | 0/1
2004 | 70/31 | 19/13 | 27/10 | 23/7 | 2019-01-01 00:00:00 | 0/0 | 0/0
2003 | 2019-01-01 00:00:00 | 0/0 | 0/0 | 2019-01-01 00:00:00 | 0/0 | 0/0 | 0/0
TOTAL | 632/434 | 212/155 | 191/131 | 167/94 | 2019-08-12 00:00:00 | 54/41 | 0/1
perc. % | 0.5929 | 0.5777 | 0.5932 | 0.6398 | 0.4 | 0.5684 | 0