Spreadsheet: 126505d1319727256-need-help-with-using-multiple-arrays-vlookup-to-project-nfl-weekly-stats-ppg-draftstreet-wk8-v3
Sheet: D-Pass

 | Rk | Team | G | Pts/G | TotPts | Comp | Att | Pct | Att/G | Yds | Avg | Yds/G | TD | Int | 1st | 1st% | Lng | 20+ | 40+ | Sck | Rate
 | 1 | [NAME] | 6 | 20 | 120 | 90 | 169 | 53.3 | 28.2 | 1029 | 6.6 | 171.5 | 8 | 4 | 50 | 29.6 | 80T | 17 | 3 | 17 | 80.1
 | 2 | Pittsburgh Steelers | 7 | 17.4 | 122 | 128 | 228 | 56.1 | 32.6 | 1203 | 5.8 | 171.9 | 8 | 2 | 68 | 29.8 | 73T | 14 | 1 | 17 | 81
 | 3 | San Diego Chargers | 6 | 22.7 | 136 | 103 | 165 | 62.4 | 27.5 | 1054 | 6.8 | 175.7 | 10 | 6 | 60 | 36.4 | 43 | 14 | 1 | 10 | 87.4
 | 4 | Baltimore Ravens | 6 | 13.8 | 83 | 109 | 207 | 52.7 | 34.5 | 1121 | 6 | 186.8 | 4 | 6 | 63 | 30.4 | 42 | 15 | 1 | 19 | 65.2
 | 5 | Cincinnati Bengals | 6 | 18.5 | 111 | 112 | 191 | 58.6 | 31.8 | 1134 | 6.4 | 189 | 6 | 2 | 51 | 26.7 | 74T | 14 | 4 | 14 | 83.6
 | 6 | [NAME] | 7 | 19.9 | 139 | 141 | 230 | 61.3 | 32.9 | 1374 | 6.4 | 196.3 | 10 | 7 | 76 | 33 | 80T | 15 | 3 | 14 | 81.6
 | 7 | New York Jets | 7 | 21.7 | 152 | 118 | 218 | 54.1 | 31.1 | 1377 | 6.8 | 196.7 | 4 | 11 | 76 | 34.9 | 73 | 18 | 5 | 18 | 60.5
 | 8 | Houston Texans | 7 | 18.7 | 131 | 125 | 234 | 53.4 | 33.4 | 1425 | 6.6 | 203.6 | 8 | 8 | 78 | 33.3 | 56 | 16 | 5 | 19 | 71.4
 | 9 | Detroit Lions | 7 | 19.6 | 137 | 165 | 257 | 64.2 | 36.7 | 1432 | 6 | 204.6 | 8 | 10 | 81 | 31.5 | 49 | 14 | 3 | 17 | 74.6
 | 10 | Philadelphia Eagles | 6 | 24.2 | 145 | 110 | 183 | 60.1 | 30.5 | 1304 | 7.7 | 217.3 | 11 | 7 | 64 | 35 | 74T | 19 | 5 | 18 | 88.2
 | 11 | Washington Redskins | 6 | 19.3 | 116 | 113 | 196 | 57.7 | 32.7 | 1310 | 7.3 | 218.3 | 5 | 5 | 62 | 31.6 | 73T | 22 | 4 | 21 | 78.4
 | 12 | Carolina Panthers | 7 | 26.1 | 183 | 126 | 199 | 63.3 | 28.4 | 1575 | 8.3 | 225 | 9 | 4 | 70 | 35.2 | 84T | 22 | 4 | 12 | 96.3
 | 13 | St. Louis Rams | 6 | 28.5 | 171 | 107 | 192 | 55.7 | 32 | 1359 | 7.4 | 226.5 | 13 | 4 | 68 | 35.4 | 93T | 20 | 4 | 11 | 93.3
 | 14 | Dallas Cowboys | 6 | 21.3 | 128 | 132 | 222 | 59.5 | 37 | 1385 | 6.7 | 230.8 | 9 | 7 | 81 | 36.5 | 45 | 18 | 1 | 17 | 80
 | 15 | Tennessee Titans | 6 | 22.5 | 135 | 139 | 214 | 65 | 35.7 | 1401 | 6.8 | 233.5 | 11 | 6 | 81 | 37.9 | 78T | 18 | 2 | 11 | 89.9
 | 16 | New Orleans Saints | 7 | 22.6 | 158 | 135 | 255 | 52.9 | 36.4 | 1635 | 6.9 | 233.6 | 12 | 4 | 76 | 29.8 | 65T | 19 | 5 | 15 | 84
 | 17 | Kansas City Chiefs | 6 | 25 | 150 | 113 | 196 | 57.7 | 32.7 | 1415 | 7.4 | 235.8 | 12 | 11 | 74 | 37.8 | 67T | 26 | 3 | 6 | 78
 | 18 | New York Giants | 6 | 24.5 | 147 | 130 | 215 | 60.5 | 35.8 | 1475 | 7.6 | 245.8 | 7 | 7 | 76 | 35.3 | 68 | 23 | 3 | 21 | 81.6
 | 19 | Denver Broncos | 6 | 25.8 | 155 | 136 | 200 | 68 | 33.3 | 1485 | 8 | 247.5 | 11 | 3 | 73 | 36.5 | 84 | 16 | 6 | 16 | 104.2
 | 20 | [NAME] | 6 | 21.3 | 128 | 135 | 206 | 65.5 | 34.3 | 1500 | 7.7 | 250 | 6 | 6 | 76 | 36.9 | 68T | 16 | 4 | 12 | 86.2
 | 21 | [NAME] | 6 | 24.3 | 146 | 120 | 199 | 60.3 | 33.2 | 1551 | 8.2 | 258.5 | 12 | 2 | 71 | 35.7 | 99T | 25 | 7 | 14 | 102.3
 | 22 | San Francisco 49ers | 6 | 16.2 | 97 | 140 | 243 | 57.6 | 40.5 | 1566 | 7 | 261 | 9 | 8 | 78 | 32.1 | 77 | 21 | 6 | 17 | 77.7
 | 23 | Indianapolis Colts | 7 | 32.1 | 225 | 166 | 228 | 72.8 | 32.6 | 1856 | 8.5 | 265.1 | 14 | 3 | 95 | 41.7 | 81T | 25 | 4 | 11 | 113
 | 24 | Atlanta Falcons | 7 | 23.3 | 163 | 157 | 245 | 64.1 | 35 | 1859 | 7.9 | 265.6 | 10 | 9 | 81 | 33.1 | 70T | 28 | 6 | 13 | 86.8
 | 25 | Oakland Raiders | 7 | 25.4 | 178 | 155 | 292 | 53.1 | 41.7 | 1862 | 6.7 | 266 | 12 | 7 | 101 | 34.6 | 74 | 20 | 4 | 16 | 77.9
 | 26 | Tampa Bay Buccaneers | 7 | 24.1 | 169 | 141 | 239 | 59 | 34.1 | 1874 | 8.2 | 267.7 | 11 | 7 | 90 | 37.7 | 87T | 25 | 6 | 12 | 88.5
 | 27 | Chicago Bears | 7 | 21.4 | 150 | 188 | 288 | 65.3 | 41.1 | 1903 | 7 | 271.9 | 11 | 8 | 90 | 31.3 | 79T | 23 | 3 | 15 | 86.8
 | 28 | Arizona Cardinals | 6 | 25.5 | 153 | 130 | 211 | 61.6 | 35.2 | 1645 | 8.2 | 274.2 | 9 | 4 | 78 | 37 | 95T | 30 | 5 | 13 | 94
 | 29 | Minnesota Vikings | 7 | 25.4 | 178 | 173 | 263 | 65.8 | 37.6 | 1924 | 7.9 | 274.9 | 11 | 6 | 100 | 38 | 79T | 23 | 7 | 21 | 94.2
 | 30 | Buffalo Bills | 6 | 24.5 | 147 | 140 | 222 | 63.1 | 37 | 1709 | 7.8 | 284.8 | 10 | 12 | 86 | 38.7 | 60 | 25 | 5 | 4 | 79.7
 | 31 | Green Bay Packers | 7 | 20.1 | 141 | 163 | 273 | 59.7 | 39 | 2022 | 7.8 | 288.9 | 12 | 13 | 99 | 36.3 | 72 | 31 | 5 | 17 | 79.3
 | 32 | New England Patriots | 6 | 22.5 | 135 | 154 | 235 | 65.5 | 39.2 | 1933 | 8.5 | 322.2 | 10 | 8 | 94 | 40 | 58 | 37 | 2 | 10 | 92