Spreadsheet: 647029d1572254360-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-example-1-
Sheet: Sheet1

PLAYER 1 |  |  |  |  |  |  |  |  | PLAYER 2 |  |  |  |  |  |  |  |  | Carpet | Player | Name | Age | Wins | Matches Total | Surface
Name: [NAME] |  |  |  |  |  |  |  |  | Name: Marin Cilic |  |  |  |  |  |  |  |  |  | Player1 |  |  |  |  | 0.5263
Country: Poland |  |  |  |  |  |  |  |  | Country: Croatia |  |  |  |  |  |  |  |  |  | Player2 |  |  |  |  | 0.6
Birthdate: 11.02.97, 22 years |  |  |  |  |  |  |  |  | Birthdate: 28.09.88, 31 years
ATP ranking: 35 |  |  |  |  |  |  |  |  | Height: 195 cm
TOP ranking's position: 33 (14.10.19, 1298 points) |  |  |  |  |  |  |  |  | Weight: 79 kg
Points: 1298 |  |  |  |  |  |  |  |  | Profi since: 2005
Prize money: 1.517.157 $ |  |  |  |  |  |  |  |  | Right-handed
Matches total: 356 |  |  |  |  |  |  |  |  | ATP ranking: 23
Win: 217 |  |  |  |  |  |  |  |  | TOP ranking's position: 3 (16.04.18, 4985 points)
%: 60.96 % |  |  |  |  |  |  |  |  | Points: 1545
year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic |  | Prize money: 27.022.364 $
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: 931
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: 612
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 |  | %: 65.74 %
2016 | 48/28 | 2019-09-05 00:00:00 | 29/14 | 2019-10-07 00:00:00 | 0/2 | 0/0 | 0/0 |  | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
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 |  | 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
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 |  | 2018 | 45/20 | 20/8 | 15/6 | 2019-04-05 00:00:00 | 0/0 | 2019-06-01 00:00:00 | 0/0
2012 | 0/1 | 0/0 | 0/1 | 0/0 | 0/0 | 0/0 | 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
TOTAL | 217/139 | 99/48 | 75/48 | 25/27 | 2019-12-08 00:00:00 | 2019-06-08 00:00:00 | 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
perc. % | 0.6096 | 0.6735 | 0.6098 | 0.4808 | 0.6 | 0.4286 | 0 |  | 2015 | 1.842105263157895 | 1.875 | 1.166666666666667 | 3 | 0/0 | 2.333333333333333 | 0/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