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

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 | 274 | 4014 | 729 | 5.5 | 16 | 8 | 248 | 291 | 456 | 2934 | 27 | 8 | 6.1 | 159 | 249 | 1080 | 4 | 4.3 | 60 | 70 | 587 | 29 | 118 | 43.2 | 12.7 | Own 27.3 | 02:56:00 | 6.67 | 34.1 | 2.35
Opp. Stats | 289 | 3859 | 654 | 5.9 | 11 | 3 | 215 | 236 | 363 | 2867 | 22 | 8 | 7.3 | 146 | 263 | 992 | 9 | 3.8 | 51 | 80 | 749 | 18 | 113 | 46 | 8.8 | Own 29.5 | 02:46:00 | 6.2 | 34.2 | 2.48
Lg Rank Offense | 11 | 11 |  |  | 18 | 25 | 6 |  | 3 | 7 | 2 | 13 | 21 |  | 29 | 22 | 29 | 11 |  |  |  |  |  | 5 | 11 | 22 | 4 | 2 | 7 | 6
Lg Rank Defense | 25 | 13 |  |  | 23 | 27 | 7 |  | 4 | 21 | 27 | 16 | 31 |  | 7 | 7 | 15 | 7 |  |  |  |  |  | 1 | 23 | 25 | 25 | 21 | 26 | 32
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:04PM ET | boxscore | W |  | 2000-01-01 00:00:00 | @ | [NAME] | 27 | 23 | 18 | 294 | 199 | 95 |  | 20 | 348 | 300 | 48 | 1 | 12.55 | -5.3 | -4
2 | Sun | 2016-09-18 00:00:00 | 8:32PM ET | boxscore | L |  | 2016-01-01 00:00:00 | @ | Minnesota Vikings | 14 | 17 | 20 | 263 | 180 | 83 | 3 | 15 | 284 | 254 | 30 | 1 | 0.44 | 2.14 | -2.85
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-01 00:00:00 |  | Detroit Lions | 34 | 27 | 17 | 324 | 201 | 123 |  | 22 | 418 | 368 | 50 | 1 | 17.93 | -14.19 | 2.24
4 |  |  |  |  |  |  |  |  | Bye Week
5 | Sun | 2016-10-09 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-03-01 00:00:00 |  | New York Giants | 23 | 16 | 23 | 406 | 259 | 147 | 2 | 14 | 221 | 178 | 43 | 1 | 3.45 | 9.52 | -6.36
6 | Sun | 2016-10-16 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-03-02 00:00:00 |  | Dallas Cowboys | 16 | 30 | 24 | 372 | 294 | 78 | 4 | 24 | 424 | 233 | 191 | 2 | -4.84 | -12.09 | 2.93
7 | Thu | 2016-10-20 00:00:00 | 8:26PM ET | boxscore | W |  | 2016-04-02 00:00:00 |  | Chicago Bears | 26 | 10 | 32 | 406 | 303 | 103 | 1 | 13 | 189 | 120 | 69 | 2 | 10.91 | 10.57 | -9.44
8 | Sun | 2016-10-30 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-03 00:00:00 | @ | Atlanta Falcons | 32 | 33 | 24 | 331 | 223 | 108 |  | 25 | 367 | 277 | 90 |  | 18.3 | -21.53 | -0.6
9 | Sun | 2016-11-06 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-04 00:00:00 |  | Indianapolis Colts | 26 | 31 | 25 | 405 | 289 | 116 | 1 | 22 | 355 | 270 | 85 | 2 | 10.86 | -6.72 | -11.14
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-04-05 00:00:00 | @ | Tennessee Titans | 25 | 47 | 21 | 402 | 333 | 69 | 3 | 19 | 446 | 292 | 154 |  | 0.96 | -20.29 | -4.86
11 | Sun | 2016-11-20 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-04-06 00:00:00 | @ | Washington Redskins | 24 | 42 | 19 | 424 | 340 | 84 | 2 | 21 | 515 | 364 | 151 |  | 10.04 | -30.26 | -1.17
12 | Mon | 2016-11-28 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-05-06 00:00:00 | @ | Philadelphia Eagles | 27 | 13 | 25 | 387 | 313 | 74 |  | 20 | 292 | 211 | 81 | 1 | 22.27 | -4.55 | -2.5
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | Houston Texans
14 | Sun | 2016-12-11 00:00:00 | 4:25PM ET | preview |  |  |  |  | [NAME]
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Chicago Bears
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | Minnesota Vikings
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Detroit Lions