Spreadsheet: 21177d1208361107-need-vlookup-to-miss-blanks-test2
Sheet: PL(Arsenal)

Number | Name | Pos | Height | Weight | Date of Birth | [NAME] | Previous Club |  | Pos | REF | POS | Number | Name | Position | Height | Weight | DOB | [NAME] | Previous Club
1 | [NAME] | G | 6'02" | 12 06 | 1969-11-10 00:00:00 | Essen | Borussia Dortmund |  | G0 | 1 | 1 | 1 | [NAME] | G | 6'02" | 12 06 | 1969-11-10 00:00:00 | Essen | Borussia Dortmund
2 | [NAME] | M | 6'02" | 11 11 | 1986-05-11 00:00:00 | Paris | Auxerre |  | M0 | 31 | 20 | 2 | [NAME] | M | 6'02" | 11 11 | 1986-05-11 00:00:00 | Paris | Auxerre
3 | [NAME] | D | 5'09" | 11 05 | 1983-02-14 00:00:00 | Sens | Auxerre |  | D0 | 11 | 5 | 3 | [NAME] | D | 5'09" | 11 05 | 1983-02-14 00:00:00 | Sens | Auxerre
4 | Cesc Fábregas | M | 5'11" | 10 12 | 1987-05-04 00:00:00 | [NAME] | Barcelona |  | M1 | 32 | 21 | 4 | Cesc Fábregas | M | 5'11" | 10 12 | 1987-05-04 00:00:00 | [NAME] | Barcelona
5 | [NAME] | D | 5'10'' | 11 09 | 1981-03-19 00:00:00 | Sokoura Bouaké | ASEC Mimosas |  | D1 | 12 | 6 | 5 | [NAME] | D | 5'10'' | 11 09 | 1981-03-19 00:00:00 | Sokoura Bouaké | ASEC Mimosas
6 | [NAME] | D | 6'03'' | 13 03 | 1985-02-14 00:00:00 | Geneva | Servette |  | D2 | 13 | 7 | 6 | [NAME] | D | 6'03'' | 13 03 | 1985-02-14 00:00:00 | Geneva | Servette
7 | Tomáš Rosický | M | 5'10'' | 10 03 | 1980-10-04 00:00:00 | Prague | Borussia Dortmund |  | M2 | 33 | 22 | 7 | Tomáš Rosický | M | 5'10'' | 10 03 | 1980-10-04 00:00:00 | Prague | Borussia Dortmund
8
9 | Eduardo | F | 5'10" | 10 03 | 1983-02-25 00:00:00 | Rio de Janeiro | [NAME] |  | F0 | 51 | 34 | 9 | Eduardo | F | 5'10" | 10 03 | 1983-02-25 00:00:00 | Rio de Janeiro | [NAME]
10 | [NAME] | D | 6'01" | 11 13 | 1977-08-17 00:00:00 | Asnieres | Chelsea |  | D3 | 14 | 8 | 10 | [NAME] | D | 6'01" | 11 13 | 1977-08-17 00:00:00 | Asnieres | Chelsea
11 | [NAME] | M | 6'00" | 11 02 | 1983-08-06 00:00:00 | [NAME] | Feyenoord |  | M3 | 34 | 23 | 11 | [NAME] | M | 6'00" | 11 02 | 1983-08-06 00:00:00 | [NAME] | Feyenoord
12
13 | Aliaksandr Hleb | M | 5'10'' | 10 12 | 1981-05-01 00:00:00 | Minsk | Stuttgart |  | M4 | 35 | 24 | 13 | Aliaksandr Hleb | M | 5'10'' | 10 12 | 1981-05-01 00:00:00 | Minsk | Stuttgart
14
15 | [NAME] | M | 5'10" | 10 10 | 1988-02-16 00:00:00 | São Paulo | São Paulo |  | M5 | 36 | 25 | 15 | [NAME] | M | 5'10" | 10 10 | 1988-02-16 00:00:00 | São Paulo | São Paulo
16 | Mathieu Flamini | M | 5'10" | 10 07 | 1984-03-07 00:00:00 | Marseille | Marseille |  | M6 | 37 | 26 | 16 | Mathieu Flamini | M | 5'10" | 10 07 | 1984-03-07 00:00:00 | Marseille | Marseille
17 | [NAME] | M | 6'00" | 12 00 | 1987-04-09 00:00:00 | Douala | Bastia |  | M7 | 38 | 27 | 17 | [NAME] | M | 6'00" | 12 00 | 1987-04-09 00:00:00 | Douala | Bastia
18
19 | [NAME] | M | 6'03'' | 12 02 | 1976-10-07 00:00:00 | Lagoa da Prata | [NAME] |  | M8 | 39 | 28 | 19 | [NAME] | M | 6'03'' | 12 02 | 1976-10-07 00:00:00 | Lagoa da Prata | [NAME]
20 | [NAME] | D | 6'03" | 13 01 | 1987-01-18 00:00:00 | Abidjan | Etoile-Carouge |  | D4 | 15 | 9 | 20 | [NAME] | D | 6'03" | 13 01 | 1987-01-18 00:00:00 | Abidjan | Etoile-Carouge
21 | Łukasz Fabiański | G | 6'03" | 13 03 | 1985-04-18 00:00:00 | Kostrzyn nad Odrą | [NAME] |  | [NAME] | 2 | 2 | 21 | Łukasz Fabiański | G | 6'03" | 13 03 | 1985-04-18 00:00:00 | Kostrzyn nad Odrą | [NAME]
22 | [NAME] | D | 6'00" | 11 02 | 1985-07-26 00:00:00 | Toulouse | Cannes |  | D5 | 16 | 10 | 22 | [NAME] | D | 6'00" | 11 02 | 1985-07-26 00:00:00 | Toulouse | Cannes
23
24 | [NAME] | G | 6'03'' | 13 08 | 1977-05-16 00:00:00 | Pamplona | Celta Vigo |  | G2 | 3 | 3 | 24 | [NAME] | G | 6'03'' | 13 08 | 1977-05-16 00:00:00 | Pamplona | Celta Vigo
25 | [NAME] | F | 6'02" | 11 11 | 1984-02-26 00:00:00 | Lomé | Monaco |  | F1 | 52 | 35 | 25 | [NAME] | F | 6'02" | 11 11 | 1984-02-26 00:00:00 | Lomé | Monaco
26 | [NAME] | F | 6'03" | 12 04 | 1988-01-16 00:00:00 | Copenhagen | FC København |  | F2 | 53 | 36 | 26 | [NAME] | F | 6'03" | 12 04 | 1988-01-16 00:00:00 | Copenhagen | FC København
27 | Emmanuel Eboué | D | 5'10" | 11 05 | 1983-06-04 00:00:00 | Abidjan | [NAME] |  | D6 | 17 | 11 | 27 | Emmanuel Eboué | D | 5'10" | 11 05 | 1983-06-04 00:00:00 | Abidjan | [NAME]
28
29
30 | [NAME] | D | 6'01" | 12 13 | 1989-10-08 00:00:00 | Paris | Monaco |  | D7 | 18 | 12 | 30 | [NAME] | D | 6'01" | 12 13 | 1989-10-08 00:00:00 | Paris | Monaco
31 | [NAME] | D | 5'11" | 10 09 | 1984-11-20 00:00:00 | Waltham Forest | None |  | D8 | 19 | 13 | 31 | [NAME] | D | 5'11" | 10 09 | 1984-11-20 00:00:00 | Waltham Forest | None
32 | [NAME] | F | 5'07" | 10 10 | 1989-03-16 00:00:00 | Newbury | Southampton |  | F3 | 54 | 37 | 32 | [NAME] | F | 5'07" | 10 10 | 1989-03-16 00:00:00 | Newbury | Southampton
33
34 | [NAME] | M | 5'10" | 10 01 | 1989-09-26 00:00:00 | [NAME] | None |  | M9 | 40 | 29 | 34 | [NAME] | M | 5'10" | 10 01 | 1989-09-26 00:00:00 | [NAME] | None
35 | [NAME] | D | 6'01" | 11 05 | 1990-06-21 00:00:00 | Vats | Haugesund |  | D9 | 20 | 14 | 35 | [NAME] | D | 6'01" | 11 05 | 1990-06-21 00:00:00 | Vats | Haugesund
36
37 | [NAME] | D |  |  | 1989-10-06 00:00:00 | Edmonton | None |  | D10 | 21 | 15 | 37 | [NAME] | D | 0 | 0 | 1989-10-06 00:00:00 | Edmonton | None
38 | [NAME] | M | 5'11" | 13 04 | 1988-12-01 00:00:00 | London | None |  | M10 | 41 | 30 | 38 | [NAME] | M | 5'11" | 13 04 | 1988-12-01 00:00:00 | London | None
39 | [NAME] | M |  |  | 1990-10-12 00:00:00 | Enfield | None |  | M11 | 42 | 31 | 39 | [NAME] | M | 0 | 0 | 1990-10-12 00:00:00 | Enfield | None
40 | Vito Mannone | G | 6'00" | 11 08 | 1988-03-02 00:00:00 | Desio | Atalanta |  | G3 | 4 | 4 | 40 | Vito Mannone | G | 6'00" | 11 08 | 1988-03-02 00:00:00 | Desio | Atalanta
41 | [NAME] | D |  |  | 1990-06-06 00:00:00 | Waltham Forest | None |  | D11 | 22 | 16 | 41 | [NAME] | D | 0 | 0 | 1990-06-06 00:00:00 | Waltham Forest | None
43 | [NAME] | M |  |  | 1990-05-27 00:00:00 | Arnhem | NEC Nijmegen |  | M12 | 43 | 32 | 43 | [NAME] | M | 0 | 0 | 1990-05-27 00:00:00 | Arnhem | NEC Nijmegen
44 | Abu Ogogo | D |  |  | 1989-11-03 00:00:00 | [NAME] | Wimbledon |  | D12 | 23 | 17 | 44 | Abu Ogogo | D | 0 | 0 | 1989-11-03 00:00:00 | [NAME] | Wimbledon
45 | [NAME] | M |  |  | 1989-09-18 00:00:00 | Farnborough | Wimbledon |  | [NAME] | 44 | 33 | 45 | [NAME] | M | 0 | 0 | 1989-09-18 00:00:00 | Farnborough | Wimbledon
46 | Kerrea Gilbert | D | 5'09" | 11 03 | 1987-02-28 00:00:00 | Hammersmith | None |  | D13 | 24 | 18 | 46 | Kerrea Gilbert | D | 5'09" | 11 03 | 1987-02-28 00:00:00 | Hammersmith | None
47 | [NAME] | D |  |  | 1990-01-31 00:00:00 | Luton | None |  | D14 | 25 | 19 | 47 | [NAME] | D | 0 | 0 | 1990-01-31 00:00:00 | Luton | None
Players no longer at this club
Number | Name | Pos | Height | Weight | Date of Birth | [NAME] | New Club
33 | [NAME] | D | 6'01" | 11 03 | 1987-09-24 00:00:00 | Barnet | QPR
42 | [NAME] | M | 5'11" | 13 00 | 1990-03-04 00:00:00 | Barcelona | Real Sociedad (On Loan)
8 | [NAME] | M | 5'08" | 10 10 | 1985-03-10 00:00:00 | Paris | Portsmouth
36 | [NAME] | M |  |  | 1989-09-28 00:00:00 | [NAME] | Burnley (On Loan)