Spreadsheet: 704267d1605470172-vlookup-avoiding-rows-with-specific-criteria-example-2
Sheet: ATLANTA

2 | Atlanta Falcons | 19.27 | 21 | O&D | OFFENSE |  |  |  |  | DEFENSE |  |  |  |  |  |  |  |  | ATS |  | OFFENSE |  |  |  |  |  | DEFENSE
RK | 19 | WINS | RUSH | RANK | PASS | RANK | OFF | RANK | RUSH | RANK | PASS | RANK | DEF | RANK | RATE | SOS | FOR | OPP | W/L | RUSH | RANK | PASS | RANK | OFF | RANK | RUSH | RANK | PASS | RANK | DEF | RANK | "+/-" | RATE | SOS | TOP 10
H | [NAME] | WIN | 84 | 26 | 299 | 5 | 383 | 9 | 72 | 4 | 434 | 32 | 404 | 31 | 21.49 | 21.46 | 25 | 38 | LOSS | 72 | 29 | 434 | 1 | 506 | 2 | 84 | 7 | 299 | 28 | 383 | 24 | 2 | 21.7 | 20.95 | 22.12
A | Dallas Cowboys | LOSS | 130.5 | 11 | 344.5 | 3 | 475 | 2 | 133 | 9 | 268 | 9 | 401 | 9 | 22.35 | 23.72 | 39 | 40 | WIN | 92.5 | 28 | 350.5 | 2 | 443 | 4 | 104.5 | 2 | 372 | 2 | 476.5 | 2 | 4.5 | 18.18 | 21.72 | 21.85
H | Chicago Bears | LOSS | 138 | 11 | 230 | 23 | 368 | 17 | 119 | 17 | 245 | 17 | 364 | 15 | 19.3 | 15.65 | 26 | 30 | LOSS | 109.7 | 18 | 309.3 | 3 | 419 | 7 | 113 | 13 | 350.3 | 31 | 463.3 | 31 | -3.5 | 18.42 | 23.48 | 22.24
A | Green Bay Packers | LOSS | 150.8 | 4 | 294.8 | 4 | 445.5 | 2 | 105.8 | 9 | 247.5 | 18 | 353.3 | 13 | 25.94 | 20.15 | 16 | 30 | LOSS | 101.8 | 23 | 294.3 | 5 | 396 | 8 | 106.8 | 10 | 341.5 | 31 | 448.3 | 31 | 7.5 | 17.29 | 22.33 | 22.37
H | Carolina Panthers | LOSS | 116 | 14 | 274.3 | 8 | 390.3 | 12 | 125.3 | 21 | 227 | 7 | 352.3 | 10 | 18.91 | 21.17 | 16 | 23 | LOSS | 101.8 | 23 | 294.3 | 5 | 396 | 8 | 106.8 | 10 | 341.5 | 31 | 448.3 | 31 | -2.5 | 16.73 | 22.62 | 22.29
A | Minnesota Vikings | LOSS | 160.6 | 3 | 215.4 | 25 | 376 | 17 | 123.7 | 17 | 227.7 | 14 | 351.3 | 11 | 19.66 | 23.3 | 40 | 23 | WIN | 114.6 | 17 | 276 | 8 | 390.6 | 11 | 106.5 | 11 | 380 | 32 | 486.5 | 32 | 3.5 | 16.05 | 21.92 | 23.12
H | Detroit Lions | LOSS | 117.4 | 15 | 230.4 | 22 | 347.8 | 24 | 145 | 29 | 234 | 15 | 379 | 21 | 18.4 | 20.71 | 22 | 23 | LOSS | 112 | 19 | 290.5 | 2 | 402.5 | 13 | 97.2 | 5 | 335.3 | 31 | 432.5 | 31 | -2.5 | 18.01 | 20.65 | 21.54
A | Carolina Panthers | LOSS | 105.3 | 21 | 263.9 | 11 | 369.1 | 16 | 124 | 18 | 226.6 | 10 | 350.6 | 12 | 18.55 | 21.48 | 25 | 17 | WIN | 105.4 | 20 | 295 | 3 | 400.4 | 13 | 92.4 | 6 | 333.4 | 31 | 425.9 | 31 | 2.5 | 17.41 | 19.44 | 22.35
H | Denver Broncos | LOSS | 112.9 | 17 | 214 | 25 | 326.9 | 27 | 123.4 | 18 | 236.6 | 16 | 360 | 17 | 18.89 | 21.27 | 34 | 27 | WIN | 108.6 | 19 | 291.9 | 2 | 400.5 | 13 | 99.3 | 6 | 311.4 | 31 | 410.6 | 28 | -3.5 | 18.4 | 18.99 | 21.9
BYE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.27 | 18.97 | 21.61
A | New Orleans Saints |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
H | Las Vegas Raiders
H | New Orleans Saints
A | Los Angeles Chargers
H | Tampa Bay Buccaneers
A | Kansas City Chiefs
A | Tampa Bay Buccaneers
 | ATLANTA | 1 | 123.9444444444444 |  | 262.9222222222222 |  | 386.8444444444445 |  | 119.0222222222222 |  | 260.7111111111111 |  | 368.3888888888889 |  | 20.38777777777778 | 20.99 | 27 | 27.88888888888889 | 4 | 102.0444444444444 |  | 315.0888888888888 |  | 417.1111111111111 |  | 101.1666666666667 |  | 340.4888888888889 |  | 441.6555555555556 |  | 0.8888888888888888 | 18.146 | 21.107 | 22.139
 | 3-6-0 |  | TOP TEN |  |  | TOP 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOP TEN |  |  | TOP 16
 |  |  | W | L | T | W | L | T |  |  |  |  |  |  |  |  |  |  |  | W | L | T | W | L | T
 | MINE
 | YOURS