Spreadsheet: 270990d1381776994-vlookup-index-match-test01
Sheet: Page 3

 |  | QB Y Rating | SCREEN | SHORT | MEDIUM | LONG | No
 | 11 | 0 + ? | -4 yds. E*I | 8 yds. A*B | 18 yds. A'B | 30 yds. A | deflected twice, into hands of A*B 13 yards upfield
 | 12 | 1 + ? | -6 yds. F*K | 4yds.C'D | 17 yds, B'C | 35 yds. B | incomplete, ball glances off defender's hands
 | 13 | 1 + ? | -3 yds. G'J | lOyds.E'H | 21 yds. C'D | 34 yds C | incomplete, ball underthrown |  | no
 | 14 | 1 + ? | -5 yds. H'l | 4 yds. ·* | 22 yds. D*A | 29 yds. D | receiver knocks ball from defender, incomplete
 | 15 | 2 + ? | -2 yds. A»K | 7 yds. A*C | 16 yds. A'C | 20 yds. A*E | ball thrown away by quarterback, incomplete |  | SCREEN
 | 16 | 2 + ? | 0 yds. E*G | 6 yds. B*D | 20 yds. ** | 32 yds. B | ball batted away by defender, incomplete
 | 21 | 2 + ? | -1 yd. G*I | 9 yds C*D | 19 yds. D'B | 44 yds. C | [NAME] and receiver struggle for ball, incomplete
 | 22 | 3 + ? | -2 yds. H'K | 5 yds A*D | 15 yds. B'A | 38 yds. D | [NAME] loose with forearm, incomplete
 | 23 | 3 + ? | -I yd. F»J | 7 yds. F'G | 16 yds. E'H | 37 yds. A | incomplete, ball glances off defender's hands
 | 24 | 3 + ? | 0 yds. [NAME] | 11yds. B'G | 19 yds. C'B | 19 yds. B'C | pass deflected by defense lineman, incomplete
 | 25 | 4 + ? | -I yd. E»H | 6 yds. A'B | 20 yds. D'C | 33 yds. D | ball deflected out of receiver's grasp, incomplete
 | 26 | 4 + ? | -lyd.F'E | 5 yds. OD | 23 yds. A'D | 41 yds. C | ball thrown away by quarterback, incomplete |  |  |  | yes
 | 31 | 5 + ? | -3 yds. G'K | 12 yds. D'A | 14 yds. B'D | 40 yds. A | QB dumps ball in front of coverage, incomplete |  |  |  | no
 | 32 | 5 + ? | -2 yds. H'l | 4 yds. A'C | 18 yds. A'B | 44 yds. B | ball batted away by defender, incomplete
 | 33 | 5 + ? | -6 yds. I*J | 9 yds. | 16 yds. B'C | 27 yds. C | incomplete, ball underthrown |  |  |  | SCREEN
 | 34 | 6 + ? | -7 yds. E'F | 13 yds. C'D | 19 yds. C'D | 45 yds. D | incomplete, ball glances off defender's hands |  |  |  | SHORT
 | 35 | 6 + ? | ■1yd. F'G | 8 yds. B'C | 21 yds. D'A | 22 yds A'G | [NAME] and receiver struggle for ball, incomplete |  |  |  | MEDIUM
 | 36 | 6 + ? | -2 yds. [NAME] | 7 yds. E*F | 25 yds. A'C | 47 yds. B | pass deflected by defense lineman, incomplete |  |  |  | LONG
 | 41 | 7 + ? | -8 yds. H'J | 12 yds. C*B | 12 yds. F'G | 30 yds. C | ball batted away by defender, incomplete
 | 42 | 7 + ? | -1 yd. K*E | 11 yds. A»B | 10 yds. D'B | 36 yds. D | ball thrown away by quarterback, incomplete
 | 43 | 7 + ? | -4 yds. E»J | 8 yds. H'G | 14 yds | 38 yds. A | receiver breaks up interception, incomplete
 | 44 | 8 + ? | -1yd. F'H | 10 yds. A'D | 13 yds. B'A | 33 yds. B | pass broken up, incomplete
 | 45 | 8 + ? | -1yd. G»D | 14 yds.B'D | 17 yds. D'C | 39 yds. C | incomplete, ball glances off defender's hands
 | 46 | 8 + ? | -2 yds. H«G | ISyds.E'G | 16 yds. A'D | 42 yds. D | incomplete, ball underthrown
 | 51 | 9 + ? | -2 yds. A*F | 6 yds ·* | 23 yds. D'B | 48 yds. A | poor throw into heavy coverage, but incomplete
 | 52 | 9 + ? | -1 yd. E'K | 4 yds EC | 13 yds. A'B | 29 yds. B | ball batted away by defender, incomplete
 | 53 | 9 + ? | -5 yds. F*I | 7 yds. F'H | 15 yds. B'C | -11 yds. I'K | ball thrown away by quarterback, incomplete
 | 54 | 10 + ? | -9 yds. G'E | 13 yds. A'C | 26 yds. C'D | 52 yds. C | [NAME] and receiver struggle for ball, incomplete
 | 55 | 10 + ?? | -2 yds. H»F | 5 yds. E'H | ■9 yds. I'K | 43 yds. D | pass deflected by defense lineman, incomplete
 | 56 | 10 + ? | -1 yd. D'G | 6 yds. D*B | 20 yds. C'B | 40 yds. A | incomplete, ball glances off defender's hands
 | 61 | 11 + ? | -9 yds. E*A | 17 yds.** | 19 yds. D'A | 35 yds, B | heavy coverage, receiver sandwiched, incomplete
 | 62 | 11 + ? | -1 yd. F'J | -8 yds. I'K | 8 yds. G'H | 37 yds. C | incomplete, ball underthrown
 | 63 | 12 + ? | 0 yds. G*I | 9 yds. A'D | 13 yds. A'C | 18 yds. D'H | pass knocked away by leaping defender
 | 64 | 12 + ? | -2 yds. H'K | 16 yds. F'G | 17 yds. D'B | 22 yds. E'H | QB lofts ball in direction of receiver, incomplete
 | 65 | 13 + ? | -3 yds. J | 10 yds. B'A | 22 yds. B«A | -10 yds. J | [NAME] and receiver struggle for ball, incomplete
 | 66 | 13 + ? | -9 yds. >H | -9 yds. J | ■7 yds. J | 33 yds *· | ball thrown away by quarterback, incomplete
NOTE: Defensive linemen cannot intercept passes beyond line of scrimmage. If Y chart indicates that a
lineman has intercepted a pass downfield, direct interception instead to choice defensive back.
** intercepted by choice defender