Spreadsheet: 491988d1480738149-pulling-a-value-on-several-sheets-based-on-name-of-the-sheet-and-another-variable-book
Sheet: Tennessee

Team Stats and Rankings Table
 |  |  | Tot Yds & TO |  |  |  |  | Passing |  |  |  |  |  |  | Rushing |  |  |  |  | Penalties |  |  |  |  |  | Average Drive
Player | PF | Yds | Ply | Y/P | TO | FL | 1stD | Cmp | Att | Yds | TD | Int | NY/A | 1stD | Att | Yds | TD | Y/A | 1stD | Pen | Yds | 1stPy | #[NAME] | Sc% | TO% | Start | Time | Plays | Yds | Pts
Team Stats | 308 | 4587 | 754 | 6.1 | 13 | 5 | 250 | 245 | 380 | 2889 | 26 | 8 | 7.3 | 139 | 356 | 1698 | 12 | 4.8 | 83 | 90 | 833 | 28 | 138 | 39.1 | 9.4 | Own 27.6 | 02:40:00 | 5.87 | 33.1 | 2.28
Opp. Stats | 296 | 4352 | 767 | 5.7 | 13 | 2 | 247 | 284 | 468 | 3244 | 21 | 11 | 6.5 | 171 | 269 | 1108 | 6 | 4.1 | 54 | 113 | 984 | 22 | 132 | 35.6 | 8.3 | Own 26.9 | 02:40:00 | 6.3 | 32.8 | 1.89
Lg Rank Offense | 7 | 7 |  |  | 11 | 8 | 14 |  | 29 | 19 | 5 | 12 | 6 |  | 3 | 3 | 8 | 3 |  |  |  |  |  | 11 | 19 | 21 | 17 | 24 | 8 | 7
Lg Rank Defense | 22 | 22 |  |  | 22 | 32 | 17 |  | 28 | 25 | 19 | 7 | 16 |  | 3 | 8 | 5 | 15 |  |  |  |  |  | 17 | 25 | 7 | 15 | 23 | 22 | 15
Schedule & Game Results Table
 |  |  |  |  |  |  |  |  |  | Score |  | Offense |  |  |  |  | Defense |  |  |  |  | Expected Points
Week | Day | Date |  |  |  | OT | Rec |  | Opp | Tm | Opp | 1stD | TotYd | PassY | RushY | TO | 1stD | TotYd | PassY | RushY | TO | Offense | Defense | Sp. [NAME]
1 | Sun | 2016-09-11 00:00:00 | 1:05PM ET | boxscore | L |  | 0-1 |  | Minnesota Vikings | 16 | 25 | 19 | 316 | 252 | 64 | 3 | 15 | 301 | 236 | 65 |  | -12.46 | 0.81 | 3
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-01-01 00:00:00 | @ | Detroit Lions | 16 | 15 | 22 | 363 | 224 | 139 | 1 | 22 | 375 | 238 | 137 | 1 | 10.15 | -0.39 | -6.83
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-02 00:00:00 |  | Oakland Raiders | 10 | 17 | 19 | 393 | 212 | 181 | 3 | 17 | 368 | 245 | 123 | 1 | -8.38 | -1.85 | 0.77
4 | Sun | 2016-10-02 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-03 00:00:00 | @ | Houston Texans | 20 | 27 | 16 | 320 | 196 | 124 | 1 | 21 | 359 | 244 | 115 | 2 | -1.88 | -3.59 | 0.39
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-03 00:00:00 | @ | [NAME] | 30 | 17 | 23 | 398 | 163 | 235 |  | 8 | 200 | 149 | 51 | 2 | 12.48 | 9.64 | -10.75
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-03 00:00:00 |  | [NAME] | 28 | 26 | 19 | 407 | 270 | 137 | 1 | 16 | 341 | 301 | 40 |  | 14.1 | -6.06 | -6.45
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-03-04 00:00:00 |  | Indianapolis Colts | 26 | 34 | 26 | 331 | 207 | 124 | 1 | 26 | 422 | 341 | 81 |  | 9.56 | -16.76 | -2.64
8 | Thu | 2016-10-27 00:00:00 | 8:26PM ET | boxscore | W |  | 2016-04-04 00:00:00 |  | [NAME] | 36 | 22 | 25 | 494 | 280 | 214 |  | 27 | 370 | 322 | 48 | 1 | 24.07 | -10.26 | -2.07
9 | Sun | 2016-11-06 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-05 00:00:00 | @ | San Diego Chargers | 35 | 43 | 24 | 393 | 313 | 80 | 3 | 31 | 476 | 268 | 208 |  | 3.77 | -19.87 | 5.17
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-05 00:00:00 |  | Green Bay Packers | 47 | 25 | 19 | 446 | 292 | 154 |  | 21 | 402 | 333 | 69 | 3 | 20.29 | -0.96 | 4.86
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-05-06 00:00:00 | @ | Indianapolis Colts | 17 | 24 | 20 | 351 | 254 | 97 |  | 18 | 327 | 251 | 76 | 1 | 1.72 | -11.39 | 3.98
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-06-06 00:00:00 | @ | Chicago Bears | 27 | 21 | 18 | 375 | 226 | 149 |  | 25 | 411 | 316 | 95 | 2 | 12.63 | -4.46 | -3.88
13 |  |  |  |  |  |  |  |  | Bye Week
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Denver Broncos
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Kansas City Chiefs
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Houston Texans