Spreadsheet: 97718d1296827348-lookup-formula-cell-not-showing-correct-value-copy-of-transfers
Sheet: main list

pos | no: | name | team | val | pts
GK | 4 | W Szczesny | Arsenal | 4
GK | 3 | L Fabianski | Arsenal | 4.5
GK | 2 | M Almunia | Arsenal | 5
GK | 13 | B Friedel | [NAME] | 4.5
GK | 51 | B [NAME] | Birmingham | 3
GK | 84 | P Robinson | [NAME] | 3
GK | 18 | R [NAME] | Blackpool | 1
GK | 15 | M Gilks | Blackpool | 1
GK | 20 | J Jaaskelainen | [NAME] | 1.5
GK | 24 | P Cech | Chelsea | 5.5
GK | 31 | T Howard | Everton | 3.5
GK | 35 | M Schwarzer | Fulham | 3
GK | 43 | J Reina | Liverpool | 5.5
GK | 65 | S Given | Man City | 4
GK | 47 | J Hart | Man City | 4
GK | 54 | [NAME] Sar | Man Utd | 5.5
GK | 68 | S Harper | Newcastle | 1.5
GK | 74 | T Sorensen | Stoke | 3
GK | 72 | A [NAME] | Stoke | 2.5
GK | 80 | C Gordon | Sunderland | 2.5
GK | 82 | H Gomes | Tottenham | 4.5
GK | 88 | S Carson | West Brom | 1.5
GK | 92 | R Green | West Ham | 2.5
GK | 97 | A Al-Habsi | [NAME] | 1.5
GK | 96 | C Kirkland | [NAME] | 2
GK | 98 | M Hahnemann | Wolves | 2
DEF | 463 | K Gibbs | Arsenal | 3
DEF | 462 | M Silvestre (N/A) | Arsenal | 3.5
DEF | 461 | J [NAME] | Arsenal | 3.5
DEF | 197 | S Squillaci | Arsenal | 4.5
DEF | 106 | B [NAME] | Arsenal | 5
DEF | 105 | T Vermaelen | Arsenal | 6
DEF | 103 | L Koscielny | Arsenal | 4.5
DEF | 102 | G Clichy | Arsenal | 5
DEF | 366 | J [NAME] | [NAME] | 4
DEF | 273 | L Young | [NAME] | 3.5
DEF | 236 | [NAME] | [NAME] | 5
DEF | 136 | S Warnock | [NAME] | 3.5
DEF | 135 | K Walker | [NAME] | 2
DEF | 116 | C Cuellar | [NAME] | 4
DEF | 410 | L Ridgewell | Birmingham | 2
DEF | 409 | S Dann | Birmingham | 2
DEF | 401 | S Carr | Birmingham | 2
DEF | 109 | R [NAME] | Birmingham | 2.5
DEF | 470 | P Jones | [NAME] | 1.5
DEF | 469 | P Chimbonda (N/A) | [NAME] | 2
DEF | 468 | M Salgado | [NAME] | 2
DEF | 134 | C Samba | [NAME] | 3
DEF | 130 | R Nelsen | [NAME] | 2.5
DEF | 129 | G Givet | [NAME] | 2.5
DEF | 474 | S Crainey | Blackpool | 1
DEF | 472 | I Evatt | Blackpool | 1
DEF | 471 | A Baptiste | Blackpool | 1
DEF | 464 | N Eardley | Blackpool | 1
DEF | 418 | C Cathcart | Blackpool | 1
DEF | 361 | P Robinson | [NAME] | 1.5
DEF | 207 | S Ricketts | [NAME] | 1.5
DEF | 155 | G Steinsson | [NAME] | 1.5
DEF | 153 | J [NAME] | [NAME] | 2
DEF | 141 | G Cahill | [NAME] | 2.5
DEF | 120 | M Alonso | [NAME] | 2
DEF | 119 | Z Knight | [NAME] | 1.5
DEF | 176 | D Luiz | Chelsea | 4
DEF | 174 | J Terry | Chelsea | 7.5
DEF | 173 | P Ferreira | Chelsea | 4
DEF | 172 | Y Zhirkov | Chelsea | 4
DEF | 171 | B [NAME] | Chelsea | 4.5
DEF | 170 | A Cole | Chelsea | 7
DEF | 168 | R Carvalho (N/A) | Chelsea | 5
DEF | 164 | J Bosingwa | Chelsea | 5.5
DEF | 160 | [NAME] | Chelsea | 5
DEF | 293 | S [NAME] | Everton | 3.5
DEF | 189 | J [NAME] (N/A) | Everton | 3
DEF | 183 | P Jagielka | Everton | 3.5
DEF | 182 | [NAME] | Everton | 2.5
DEF | 181 | T [NAME] | Everton | 2
DEF | 179 | L Baines | Everton | 4
DEF | 178 | P Neville | Everton | 2.5
DEF | 475 | P Senderos | Fulham | 3
DEF | 200 | C [NAME] | Fulham | 2
DEF | 199 | J Pantsil | Fulham | 2
DEF | 196 | A Hughes | Fulham | 3
DEF | 194 | B [NAME] | Fulham | 3.5
DEF | 192 | C Salcido | Fulham | 2.5
DEF | 476 | S Kyrgiakos | Liverpool | 3.5
DEF | 297 | G [NAME] | Liverpool | 5.5
DEF | 228 | M Skrtel | Liverpool | 4.5
DEF | 225 | E Insua (N/A) | Liverpool | 4.5
DEF | 221 | M Kelly | Liverpool | 2.5
DEF | 220 | J Carragher | Liverpool | 6
DEF | 217 | F Aurelio | Liverpool | 4.5
DEF | 214 | D Agger | Liverpool | 5
DEF | 198 | P Konchesky (N/A) | Liverpool | 2.5
DEF | 478 | M Richards | Man City | 4
DEF | 477 | J [NAME] | Man City | 4
DEF | 242 | A Kolarov | Man City | 4
DEF | 241 | V Kompany | Man City | 3
DEF | 240 | P Zabaleta | Man City | 3
DEF | 185 | J Lescott | Man City | 4.5
DEF | 110 | K Toure | Man City | 4.5
DEF | 258 | N Vidic | Man Utd | 6.5
DEF | 255 | Rafael | Man Utd | 3.5
DEF | 254 | J [NAME] | Man Utd | 3.5
DEF | 252 | G Neville | Man Utd | 3.5
DEF | 250 | R Ferdinand | Man Utd | 6
DEF | 248 | P Evra | Man Utd | 5.5
DEF | 247 | J Evans | Man Utd | 4
DEF | 246 | W Brown | Man Utd | 3.5
DEF | 499 | S Campbell | Newcastle | 1
DEF | 482 | S [NAME] | Newcastle | 1
DEF | 481 | D Simpson | Newcastle | 1
DEF | 480 | J Enrique | Newcastle | 1.5
DEF | 479 | F Coloccini | Newcastle | 1.5
DEF | 465 | M Williamson | Newcastle | 1
DEF | 483 | R Huth | Stoke | 2.5
DEF | 450 | A Faye | Stoke | 2.5
DEF | 325 | [NAME] | Stoke | 2.5
DEF | 323 | D Collins | Stoke | 1.5
DEF | 314 | A Wilkinson | Stoke | 1.5
DEF | 312 | R Shawcross | Stoke | 3
DEF | 486 | [NAME] (N/A) | Sunderland | 1.5
DEF | 485 | J [NAME] | Sunderland | 1.5
DEF | 484 | G [NAME] | Sunderland | 1.5
DEF | 383 | T Bramble | Sunderland | 2
DEF | 368 | A Ferdinand | Sunderland | 1.5
DEF | 321 | P Bardsley | Sunderland | 1.5
DEF | 239 | N Onuoha | Sunderland | 3
DEF | 209 | M Turner | Sunderland | 2
DEF | 346 | J Woodgate | Tottenham | 3.5
DEF | 345 | [NAME] | Tottenham | 3
DEF | 344 | L King | Tottenham | 3
DEF | 342 | A Hutton | Tottenham | 3.5
DEF | 338 | M Dawson | Tottenham | 4
DEF | 334 | G Bale | Tottenham | 5
DEF | 331 | B Assou-Ekotto | Tottenham | 3
DEF | 298 | Y Kaboul | Tottenham | 3
DEF | 235 | [NAME] | Tottenham | 4
DEF | 104 | [NAME] | Tottenham | 5
DEF | 492 | M Cech | West Brom | 1
DEF | 491 | J Mattock (N/A) | West Brom | 1
DEF | 490 | G Jara | West Brom | 1
DEF | 489 | G Zuiverloon | West Brom | 1
DEF | 488 | A Meite | West Brom | 1
DEF | 487 | J Olsson | West Brom | 1.5
DEF | 412 | G Tamas | West Brom | 1.5
DEF | 124 | N Shorey | West Brom | 3.5
DEF | 493 | J Tomkins | West Ham | 1.5
DEF | 414 | J Spector | West Ham | 1.5
DEF | 376 | M Upson | West Ham | 2.5
DEF | 374 | [NAME] (N/A) | West Ham | 1.5
DEF | 373 | M Da Costa | West Ham | 1.5
DEF | 371 | H Ilunga | West Ham | 1.5
DEF | 370 | D Gabbidon | West Ham | 1.5
DEF | 369 | J Faubert | West Ham | 1.5
DEF | 166 | W Bridge | West Ham | 4
DEF | 131 | L Jacobsen | West Ham | 2
DEF | 495 | G Caldwell | [NAME] | 2
DEF | 416 | E Boyce | [NAME] | 2
DEF | 387 | M Melchiot (N/A) | [NAME] | 1.5
DEF | 386 | M Figueroa | [NAME] | 1.5
DEF | 498 | S Ward | Wolves | 1.5
DEF | 497 | J [NAME] (N/A) | Wolves | 1.5
DEF | 496 | R Zubar | Wolves | 2
DEF | 438 | M Mancienne | Wolves | 1.5
DEF | 437 | S Mouyokolo | Wolves | 1.5
DEF | 436 | G Elokobi | Wolves | 1.5
DEF | 434 | J Craddock | Wolves | 2
DEF | 430 | C [NAME] | Wolves | 1.5
MID | 528 | J Wilshere | Arsenal | 2
MID | 514 | T [NAME] | Arsenal | 4
MID | 513 | A Song | Arsenal | 2.5
MID | 512 | T Rosicky | Arsenal | 4
MID | 510 | A Ramsey | Arsenal | 2
MID | 509 | S [NAME] | Arsenal | 4
MID | 508 | C Fabregas | Arsenal | 8
MID | 506 | E Eboue | Arsenal | 3
MID | 504 | A Diaby | Arsenal | 3
MID | 502 | Denilson | Arsenal | 3
MID | 501 | A Arshavin | Arsenal | 7
MID | 676 | S Downing | [NAME] | 4
MID | 527 | A Young | [NAME] | 5.5
MID | 525 | N Reo-Coker | [NAME] | 2.5
MID | 523 | S Petrov | [NAME] | 3
MID | 522 | J Makoun | [NAME] | 2
MID | 520 | M Albrighton | [NAME] | 1.5
MID | 518 | M Bradley | [NAME] | 2
MID | 731 | [NAME] (N/A) | Birmingham | 2
MID | 709 | A Hleb | Birmingham | 2.5
MID | 707 | J Beausejour | Birmingham | 2
MID | 705 | B [NAME] | Birmingham | 2.5
MID | 541 | C Gardner | Birmingham | 2
MID | 532 | D Bentley | Birmingham | 3
MID | 531 | J McFadden | Birmingham | 2
MID | 530 | S Larsson | Birmingham | 2.5
MID | 529 | K Fahey | Birmingham | 2
MID | 503 | L Bowyer | Birmingham | 2.5
MID | 726 | V Grella | [NAME] | 1
MID | 725 | E Hadji Diouf (N/A) | [NAME] | 2.5
MID | 586 | J Jones | [NAME] | 1
MID | 538 | M Olsson | [NAME] | 2
MID | 537 | S Nzonzi | [NAME] | 2
MID | 536 | M Gamst Pedersen | [NAME] | 3
MID | 535 | K Andrews | [NAME] | 1
MID | 534 | D Dunn | [NAME] | 3.5
MID | 533 | B Emerton | [NAME] | 2.5
MID | 730 | A Reid | Blackpool | 2.5
MID | 606 | K Southern | Blackpool | 1
MID | 604 | J Euell | Blackpool | 1
MID | 601 | C Adam | Blackpool | 2.5
MID | 727 | M Petrov | [NAME] | 2.5
MID | 559 | S Holden | [NAME] | 1.5
MID | 553 | M Taylor | [NAME] | 3
MID | 552 | R Gardner | [NAME] | 2
MID | 550 | F Muamba | [NAME] | 1
MID | 544 | C [NAME] | [NAME] | 2
MID | 539 | T [NAME] | [NAME] | 1
MID | 620 | Y [NAME] | Chelsea | 4.5
MID | 571 | Ramires | Chelsea | 3
MID | 570 | J Obi Mikel | Chelsea | 3
MID | 568 | F Malouda | Chelsea | 5.5
MID | 564 | F Lampard | Chelsea | 9
MID | 562 | M Essien | Chelsea | 5
MID | 561 | Deco (N/A) | Chelsea | 4
MID | 583 | L Osman | Everton | 3
MID | 582 | J Heitinga | Everton | 3
MID | 581 | D Bilyaletdinov | Everton | 3
MID | 580 | M Fellaini | Everton | 3.5
MID | 579 | T Cahill | Everton | 5
MID | 578 | J Rodwell | Everton | 2
MID | 577 | M Arteta | Everton | 5
MID | 761 | J Greening | Fulham | 2
MID | 724 | D Etuhu | Fulham | 1.5
MID | 687 | D Duff | Fulham | 3.5
MID | 598 | D Murphy | Fulham | 3.5
MID | 596 | Z [NAME] | Fulham | 2.5
MID | 594 | C Dempsey | Fulham | 4
MID | 592 | S Davies | Fulham | 1.5
MID | 526 | S Sidwell | Fulham | 2.5
MID | 711 | C Poulsen | Liverpool | 2.5
MID | 710 | R Meireles | Liverpool | 3.5
MID | 627 | M Rodriguez | Liverpool | 3
MID | 626 | J Mascherano (N/A) | Liverpool | 4.5
MID | 625 | R Babel (N/A) | Liverpool | 3
MID | 624 | Lucas | Liverpool | 3
MID | 623 | A Aquilani (N/A) | Liverpool | 3
MID | 622 | S Gerrard | Liverpool | 8
MID | 621 | D Kuyt | Liverpool | 5.5
MID | 560 | J Cole | Liverpool | 4
MID | 729 | Y Toure | Man City | 3
MID | 728 | D Silva | Man City | 4
MID | 691 | J Milner | Man City | 5.5
MID | 642 | C Bellamy (N/A) | Man City | 5.5
MID | 640 | A [NAME] | Man City | 4
MID | 638 | P Vieira | Man City | 2
MID | 633 | N de Jong | Man City | 2
MID | 572 | S Wright-Phillips | Man City | 3
MID | 519 | G Barry | Man City | 4.5
MID | 795 | L Valencia | Man Utd | 4.5
MID | 665 | P Scholes | Man Utd | 3.5
MID | 661 | J Park | Man Utd | 4
MID | 659 | Nani | Man Utd | 4.5
MID | 657 | O Hargreaves | Man Utd | 3
MID | 656 | D Gibson | Man Utd | 3
MID | 655 | R [NAME] | Man Utd | 3.5
MID | 653 | D Fletcher | Man Utd | 3
MID | 651 | M Carrick | Man Utd | 4.5
MID | 649 | [NAME] | Man Utd | 3
MID | 686 | A Smith | Newcastle | 1
MID | 685 | C Tiote | Newcastle | 2
MID | 684 | R Taylor | Newcastle | 1.5
MID | 683 | W Routledge (N/A) | Newcastle | 2
MID | 682 | J Gutierrez | Newcastle | 2
MID | 681 | H Ben Arfa | Newcastle | 2
MID | 680 | J Barton | Newcastle | 2
MID | 679 | D Guthrie | Newcastle | 2
MID | 678 | K Nolan | Newcastle | 2.5
MID | 641 | S Ireland | Newcastle | 2.5
MID | 773 | M Etherington | Stoke | 3
MID | 736 | D Whitehead | Stoke | 2
MID | 717 | G Whelan | Stoke | 2
MID | 716 | J Pennant | Stoke | 2
MID | 715 | L Lawrence (N/A) | Stoke | 2
MID | 713 | R Delap | Stoke | 2
MID | 751 | S Malbranque | Sunderland | 2.5
MID | 738 | S Sessegnon | Sunderland | 1.5
MID | 737 | S Muntari | Sunderland | 1.5
MID | 735 | A Elmohamady | Sunderland | 2
MID | 734 | C Riveros | Sunderland | 1.5
MID | 733 | B Zenden | Sunderland | 1.5
MID | 732 | K Richardson | Sunderland | 2
MID | 718 | J Henderson | Sunderland | 1.5
MID | 674 | L Cattermole | Sunderland | 2
MID | 793 | W Palacios | Tottenham | 2.5
MID | 753 | L Modric | Tottenham | 5
MID | 749 | A Lennon | Tottenham | 5
MID | 748 | R van der Vaart | Tottenham | 4.5
MID | 747 | J Jenas | Tottenham | 3
MID | 745 | T Huddlestone | Tottenham | 3
MID | 704 | N Kranjcar | Tottenham | 4
MID | 585 | S Pienaar | Tottenham | 4.5
MID | 720 | Y Mulumbu | West Brom | 1
MID | 719 | B [NAME] (N/A) | West Brom | 1.5
MID | 556 | J Thomas | West Brom | 1
MID | 555 | C [NAME] | West Brom | 2
MID | 554 | G Dorrans | West Brom | 2.5
MID | 540 | [NAME] | West Brom | 1
MID | 794 | R Kovac | West Ham | 1.5
MID | 789 | K Dyer | West Ham | 2
MID | 787 | P Barrera | West Ham | 2
MID | 785 | T Hitzlsperger | West Ham | 2.5
MID | 784 | J Stanislas | West Ham | 1.5
MID | 783 | S Parker | West Ham | 3.5
MID | 782 | J [NAME] | West Ham | 1.5
MID | 781 | M Noble | West Ham | 2.5
MID | 769 | L Boa Morte | West Ham | 1.5
MID | 768 | [NAME] (N/A) | West Ham | 2
MID | 796 | J [NAME] | [NAME] | 2
MID | 791 | J [NAME] | [NAME] | 1.5
MID | 786 | V Moses | [NAME] | 2
MID | 774 | T Cleverley | [NAME] | 1.5
MID | 763 | H Thomas | [NAME] | 1.5
MID | 721 | M Diame | [NAME] | 1.5
MID | 693 | C N'Zogbia | [NAME] | 3
MID | 799 | M Kightly | Wolves | 1.5
MID | 797 | M Jarvis | Wolves | 2.5
MID | 766 | N Milijas | Wolves | 1.5
MID | 765 | K Foley | Wolves | 2
MID | 764 | S Hunt | Wolves | 2.5
MID | 755 | J O'Hara | Wolves | 3
MID | 723 | [NAME] | Wolves | 1.5
STR | 808 | [NAME] | Arsenal | 7
STR | 807 | M Chamakh | Arsenal | 5
STR | 806 | Eduardo (N/A) | Arsenal | 3.5
STR | 804 | N Bendtner | Arsenal | 4.5
STR | 983 | E Heskey | [NAME] | 3
STR | 952 | D Bent | [NAME] | 5
STR | 815 | G Agbonlahor | [NAME] | 5.5
STR | 825 | K Phillips | Birmingham | 1.5
STR | 824 | O Martins | Birmingham | 1
STR | 822 | N Zigic | Birmingham | 2
STR | 820 | C [NAME] | Birmingham | 2
STR | 940 | N Kalinic | [NAME] | 2
STR | 921 | D Hoilett | [NAME] | 1.5
STR | 832 | M Diouf | [NAME] | 1.5
STR | 830 | R Santa Cruz | [NAME] | 3.5
STR | 828 | J [NAME] | [NAME] | 2
STR | 996 | M Harewood | Blackpool | 1.5
STR | 995 | L Varney | Blackpool | 1
STR | 985 | D Campbell | Blackpool | 1
STR | 935 | J Beattie | Blackpool | 1.5
STR | 888 | [NAME] | Blackpool | 1
STR | 886 | D Campbell (N/A) | Blackpool | 1
STR | 884 | B [NAME] | Blackpool | 1
STR | 838 | D Sturridge | [NAME] | 3
STR | 837 | J Elmander | [NAME] | 1.5
STR | 835 | K Davies | [NAME] | 4
STR | 829 | I Klasnic | [NAME] | 1.5
STR | 882 | F Torres | Chelsea | 8
STR | 844 | S [NAME] | Chelsea | 4
STR | 842 | D Drogba | Chelsea | 9
STR | 840 | N Anelka | Chelsea | 7.5
STR | 899 | J Beckford | Everton | 1.5
STR | 898 | L Saha | Everton | 5
STR | 855 | Yakubu (N/A) | Everton | 4
STR | 978 | [NAME] | Fulham | 4
STR | 938 | E Gudjohnsen | Fulham | 2
STR | 864 | E Nevland (N/A) | Fulham | 1.5
STR | 854 | M Dembele | Fulham | 2
STR | 853 | A [NAME] | Fulham | 3
STR | 979 | M Jovanovic | Liverpool | 4.5
STR | 961 | A Carroll | Liverpool | 2
STR | 959 | L Suarez | Liverpool | 3
STR | 883 | D Ngog | Liverpool | 4.5
STR | 900 | C [NAME] | Man City | 7
STR | 895 | E Dzeko | Man City | 3.5
STR | 894 | M Balotelli | Man City | 3.5
STR | 893 | Robinho (N/A) | Man City | 4
STR | 802 | E Adebayor (N/A) | Man City | 6.5
STR | 956 | J Hernandez | Man Utd | 3
STR | 954 | D Berbatov | Man Utd | 6
STR | 918 | M Owen | Man Utd | 3
STR | 896 | W Rooney | Man Utd | 8.5
STR | 965 | S Ameobi | Newcastle | 1
STR | 963 | P Lovenkrands | Newcastle | 1
STR | 943 | K Jones | Stoke | 3.5
STR | 939 | J Walters | Stoke | 1.5
STR | 937 | R Fuller | Stoke | 2
STR | 934 | D Kitson (N/A) | Stoke | 1.5
STR | 817 | J Carew | Stoke | 5
STR | 984 | F Campbell | Sunderland | 2
STR | 945 | D Welbeck | Sunderland | 2
STR | 922 | A [NAME] | Sunderland | 3
STR | 958 | R Pavlyuchenko | Tottenham | 4
STR | 927 | J Defoe | Tottenham | 6.5
STR | 878 | P Crouch | Tottenham | 5
STR | 990 | P Odemwingie | West Brom | 2
STR | 969 | S Cox | West Brom | 1
STR | 968 | R Bednar | West Brom | 2
STR | 928 | L Moore | West Brom | 1
STR | 920 | M Fortune | West Brom | 1
STR | 810 | C Vela | West Brom | 2.5
STR | 992 | V Obinna | West Ham | 1.5
STR | 980 | F Piquionne | West Ham | 2.5
STR | 977 | [NAME] | West Ham | 1.5
STR | 976 | C Cole | West Ham | 4
STR | 975 | A Diamanti (N/A) | West Ham | 2
STR | 966 | R Keane | West Ham | 5
STR | 826 | B [NAME] | West Ham | 2
STR | 986 | H Rodallega | [NAME] | 2.5
STR | 929 | M Boselli (N/A) | [NAME] | 1.5
STR | 803 | J Scotland (N/A) | [NAME] | 1
STR | 999 | K Doyle | Wolves | 2.5
STR | 998 | S Ebanks-Blake | Wolves | 2
STR | 994 | S Fletcher | Wolves | 2.5