Spreadsheet: 218435d1362459645-data-validation-formula-based-on-adjacent-cell-manifest
Sheet: Sheet2

 |  |  |  |  |  |  | JUMP
 | TAN_I | AFF_I | VIDEO | COACH |  |  | TYPES |  |  |  | TAN_I |  | AFF_I |  | VIDEO |  | COACH |  |  |  | TAN_I |  | AFF_I |  | VIDEO |  | COACH
JOE | P | P | P | P |  |  | TAN_I |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
[NAME] | P | P | P | P |  |  | AFF_I |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2 |  | 2 |  | 2
JULIE | P | P |  | P |  |  | VIDEO |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 3 |  | 3
KAREN |  | P |  | P |  |  | COACH |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 4 |  | 4
ROB | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  | 5 |  | 5
[NAME] | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6 |  | 6 |  | 6
[NAME] | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 7 |  | 7 |  | 7
[NAME] | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  | 8 |  | 8
CRUZ | P |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 9 |  | 9 |  | 9
[NAME] |  |  | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10 |  | 10 |  | 10
BO |  |  | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 11 |  | 11 |  | 11
ANDRE |  |  | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12 |  | 12 |  | 12
SEAN |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 13 |  | 13 |  | 13
[NAME] | P |  | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 |  | 14 |  | 14
MARTIN | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 15 |  | 15 |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 |  | 16 |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 17 |  | 17 |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 |  | 18 |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 19 |  | 19 |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 21 |  | 21 |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 22 |  | 22 |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 23 |  | 23 |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 24 |  | 24 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 25 |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 26 |  | 26 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 27 |  | 27 |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 28 |  | 28 |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 29 |  | 29 |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 30 |  | 30 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 31 |  | 31 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 32 |  | 32 |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  | 33 |  | 33 |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 34 |  | 34 |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 35 |  | 35 |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  | 36 |  | 36 |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 37 |  | 37 |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  | 38 |  | 38 |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  | 39 |  | 39 |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 40 |  | 40 |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  | 41 |  | 41 |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  | 42 |  | 42 |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | 43 |  | 43 |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 44 |  | 44 |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 45 |  | 45 |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 46 |  | 46 |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  | 47 |  | 47 |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 48 |  | 48 |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  | 49 |  | 49 |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 50 |  | 50 |  | 50