Spreadsheet: 94847d1294612531-vlookup-issue-nba
Sheet: Works if Remove Data Above 

 |  |  |  | Chicago Bulls |  |  | NBA 2010-2011 through games of 2010 January 6 Thursday
 |  |  |  |  |  |  | HOME ADVANTAGE=  3.33           RATING    W   L  SCHEDL(RANK) VS top 10 | VS top 16 |  ELO_CHESS   |  PREDICTOR
 |  |  |  |  |  |  | 1  San Antonio Spurs       =  97.87   29   6   89.53(  23)    8   3  |   15   5  |   98.56    1 |   97.30    3
 |  |  |  |  |  |  | 2  Boston Celtics          =  97.42   27   7   89.73(  20)    8   3  |   13   4  |   97.32    2 |   97.49    2
 |  |  |  |  |  |  | 3  Miami Heat              =  97.00   28   9   89.18(  27)    4   6  |    8   8  |   95.99    4 |   98.55    1
 |  |  |  |  |  |  | 4  Dallas Mavericks        =  95.40   26   9   90.02(  15)   10   3  |   16   6  |   96.56    3 |   94.49    6
 |  |  |  |  |  |  | 5  Chicago Bulls           =  94.11   23  11   88.99(  28)    3   6  |    7   9  |   93.59    7 |   94.66    5
 |  |  |  |  |  |  | 6  Los Angeles Lakers      =  94.04   25  11   88.83(  29)    1   4  |    5   8  |   93.32    9 |   94.86    4
 |  |  |  |  |  |  | 7  Orlando Magic           =  93.91   23  12   89.37(  26)    5   7  |    7   9  |   93.43    8 |   94.39    7
 |  |  |  |  |  |  | 8  Utah Jazz               =  92.94   24  12   89.85(  19)    6   6  |   10  10  |   94.12    5 |   91.92   10
 |  |  |  |  |  |  | 9  Oklahoma City Thunder   =  92.89   24  13   90.31(  12)    5   7  |   12  10  |   94.12    6 |   91.82   11
 |  |  |  |  |  |  | 10  Atlanta Hawks           =  92.44   24  14   89.47(  24)    3   8  |    6   9  |   92.72   10 |   92.13    8
 |  |  |  |  |  |  | NBA 2010-2011 through games of 2010 January 6 Thursday
 |  |  |  |  |  |  | HOME ADVANTAGE=  3.33           RATING    W   L  SCHEDL(RANK) VS top 10 | VS top 16 |  ELO_CHESS   |  PREDICTOR
 |  |  |  |  |  |  | 11  New Orleans Hornets     =  92.18   21  15   90.11(  14)    6   8  |   10   9  |   92.35   11 |   91.98    9
 |  |  |  |  |  |  | 12  Denver Nuggets          =  91.75   20  15   90.01(  16)    5   6  |   10   9  |   91.76   12 |   91.70   12
 |  |  |  |  |  |  | 13  Portland Trail Blazers  =  91.58   19  17   91.07(   3)    3   9  |    8  13  |   91.72   13 |   91.42   13
 |  |  |  |  |  |  | 14  New York Knicks         =  91.06   20  14   89.43(  25)    4   6  |    6   9  |   91.49   14 |   90.60   15
 |  |  |  |  |  |  | 15  Memphis Grizzlies       =  90.08   16  19   90.37(  11)    5   9  |    6  13  |   89.32   15 |   90.82   14
 |  |  |  |  |  |  | 16  Houston Rockets         =  89.69   16  19   89.91(  17)    2   8  |    5  13  |   88.85   17 |   90.49   16
 |  |  |  |  |  |  | 17  Milwaukee Bucks         =  89.09   13  20   91.62(   1)    5  11  |    7  16  |   89.06   16 |   89.10   18
 |  |  |  |  |  |  | 18  Philadelphia 76ers      =  88.97   14  21   90.56(   7)    1  12  |    5  13  |   87.91   21 |   89.95   17
 |  |  |  |  |  |  | 19  Phoenix Suns            =  88.93   14  19   90.87(   4)    4   9  |    7  15  |   88.81   19 |   89.03   19
 |  |  |  |  |  |  | 20  Indiana Pacers          =  88.47   14  18   89.68(  21)    2  10  |    4  13  |   88.05   20 |   88.85   20
 |  |  |  |  |  |  | NBA 2010-2011 through games of 2010 January 6 Thursday
 |  |  |  |  |  |  | HOME ADVANTAGE=  3.33           RATING    W   L  SCHEDL(RANK) VS top 10 | VS top 16 |  ELO_CHESS   |  PREDICTOR
 |  |  |  |  |  |  | 21  Golden State Warriors   =  88.02   14  21   91.49(   2)    1  12  |    6  18  |   88.82   18 |   87.11   21
 |  |  |  |  |  |  | 22  Toronto Raptors         =  86.32   12  23   90.28(  13)    4   9  |    5  16  |   86.27   22 |   86.33   23
 |  |  |  |  |  |  | 23  Los Angeles Clippers    =  85.96   11  24   89.85(  18)    3   9  |    5  17  |   85.46   25 |   86.38   22
 |  |  |  |  |  |  | 24  Detroit Pistons         =  85.56   11  24   90.53(   9)    2  12  |    3  17  |   85.84   24 |   85.22   24
 |  |  |  |  |  |  | 25  Charlotte Bobcats       =  85.44   12  21   89.53(  22)    0   9  |    2  13  |   86.21   23 |   84.46   27
 |  |  |  |  |  |  | 26  New Jersey Nets         =  85.12   10  25   90.82(   5)    3  14  |    5  17  |   85.19   26 |   85.01   26
 |  |  |  |  |  |  | 27  Minnesota Timberwolves  =  84.62    9  27   90.74(   6)    0  14  |    2  20  |   84.13   27 |   85.04   25
 |  |  |  |  |  |  | 28  Washington Wizards      =  84.03    8  25   90.55(   8)    0  12  |    3  16  |   83.61   28 |   84.37   28
 |  |  |  |  |  |  | 29  Cleveland Cavaliers     =  82.63    8  27   90.47(  10)    1  13  |    3  15  |   83.27   29 |   81.73   30
 |  |  |  |  |  |  | 30  Sacramento Kings        =  82.49    8  25   88.48(  30)    0   8  |    2  15  |   82.12   30 |   82.79   29