Spreadsheet: 775551d1649174502-dependent-drop-down-list-without-named-ranges-example-excel-spreadsheet
Sheet: Code Tables

 | Type |  | Project Number |  | Location Codes |  | _0 | _1 | _2 | _3 | _4 | _5 | _6 | _7 | _8 | _9
 | New |  | 123456 |  | AAA111 |  | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00
 | Change |  |  |  | BBB222 |  | 01 | 01 | 01 | 01 | 01 | 01 | 01 | 01 | 01 | 01
 | Cancellation |  |  |  | CCC333 |  | 02 | 02 | 02 | 02 | 02 | 02 | 02 | 02 | 02 | 02
 |  |  |  |  | DDD444 |  | 03 | 03 | 03 | 03 | 03 | 03 | 03 | 03 | 03 | 03
 |  |  |  |  |  |  | 04 | 04 | 04 | 04 | 04 | 04 | 04 | 04 | 04 | 04
 |  |  |  |  |  |  | 05 | 05 | 05 | 05 | 05 | 05 | 05 | 05 | 05 | 05
 |  |  |  |  |  |  | 06 | 06 | 06 | 06 | 06 | 06 | 06 | 06 | 06 | 06
 |  |  |  |  |  |  | 07 | 07 | 07 | 07 | 07 | 07 | 07 | 07 | 07 | 07
 |  |  |  |  |  |  | 08 | 08 | 08 | 08 | 08 | 08 | 08 | 08 | 08 | 08
 |  |  |  |  |  |  | 09 | 09 | 09 | 09 | 09 | 09 | 09 | 09 | 09 | 09
 |  |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 |  |  |  |  |  |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
 |  |  |  |  |  |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
 |  |  |  |  |  |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
 |  |  |  |  |  |  | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
 |  |  |  |  |  |  | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
 |  |  |  |  |  |  | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
 |  |  |  |  |  |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 |  |  |  |  |  |  | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21
 |  |  |  |  |  |  | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  |  | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23
 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
 |  |  |  |  |  |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  |  | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
 |  |  |  |  |  |  | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27
 |  |  |  |  |  |  | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
 |  |  |  |  |  |  | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  |  | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
 |  |  |  |  |  |  | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33
 |  |  |  |  |  |  | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 34
 |  |  |  |  |  |  | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
 |  |  |  |  |  |  | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36
 |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
 |  |  |  |  |  |  | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38
 |  |  |  |  |  |  | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39
 |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 |  |  |  |  |  |  | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41
 |  |  |  |  |  |  | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42
 |  |  |  |  |  |  | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
 |  |  |  |  |  |  | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44
 |  |  |  |  |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  |  |  |  |  |  | 46 | 46 | 46 | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | AA
 |  |  |  |  |  |  | 51 | 51 | 51 | 51 | 51 | 51 | 51 | 51 | 51 | AB
 |  |  |  |  |  |  | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | AC
 |  |  |  |  |  |  | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | AD
 |  |  |  |  |  |  | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | AE
 |  |  |  |  |  |  | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | AF
 |  |  |  |  |  |  | 56 | 56 | 56 | 56 | 56 | 57 | 56 | 56 | 56 | AG
 |  |  |  |  |  |  | 57 | 57 | 57 | 57 | 57 | 58 | 57 | 57 | 57 | AH
 |  |  |  |  |  |  | 58 | 58 | 58 | 58 | 58 | 59 | 58 | 58 | 58 | AI
 |  |  |  |  |  |  |  | 59 | 59 | 59 | 59 | 60 | 59 | 59 | 59 | AJ
 |  |  |  |  |  |  |  | 60 | 60 | 60 | 60 | 61 | 60 | 60 | 60 | AK
 |  |  |  |  |  |  |  | 61 | 61 | 61 | 61 | 62 |  | 61 | 61 | AL
 |  |  |  |  |  |  |  | 62 | 62 | 62 | 62 | 63 |  | 62 | 62 | AM
 |  |  |  |  |  |  |  | 63 | 63 | 63 | 63 | 64 |  | 63 | 63 | AN
 |  |  |  |  |  |  |  | 64 | 65 | 64 | 64 | 65 |  | 64 | 64 | AO
 |  |  |  |  |  |  |  | 65 | 66 | 65 | 65 | 66 |  | 65 | 65 | AZ
 |  |  |  |  |  |  |  | 66 | 67 | 66 | 66 | 67 |  | 66 | 66 | CA
 |  |  |  |  |  |  |  | 67 | 70 |  | 67 | 68 |  | 67 | 67 | CB
 |  |  |  |  |  |  |  | 68 | 71 |  | 69 | 69 |  | 68 | 68 | CC
 |  |  |  |  |  |  |  | 69 | 72 |  | 70 | 70 |  | 69 | 69 | CD
 |  |  |  |  |  |  |  | 70 | 74 |  | 71 | 71 |  | 70 | 70 | CE
 |  |  |  |  |  |  |  | 71 | 76 |  | 72 | 72 |  | 71 | 71 | CF
 |  |  |  |  |  |  |  | 72 | 77 |  | 73 | 73 |  | 72 | 72 | CG
 |  |  |  |  |  |  |  | 73 | 78 |  | 74 | 74 |  | 73 | 73 | CH
 |  |  |  |  |  |  |  | 74 | 79 |  | 75 | 75 |  | 74 | 74 | CI
 |  |  |  |  |  |  |  | 75 | 80 |  | 76 | 76 |  | 75 | 75 | CJ
 |  |  |  |  |  |  |  | 76 | 81 |  | 77 | 77 |  |  | 76 | DA
 |  |  |  |  |  |  |  | 77 | 82 |  | 78 | 78 |  |  | 77 | DB
 |  |  |  |  |  |  |  | 78 | 83 |  | 79 | 79 |  |  | 78 | DC
 |  |  |  |  |  |  |  | 79 |  |  | 80 | 80 |  |  | 79 | DD
 |  |  |  |  |  |  |  | 80 |  |  | 81 | 81 |  |  | 80 | DE
 |  |  |  |  |  |  |  | 81 |  |  | 82 | 82 |  |  | 81 | DF
 |  |  |  |  |  |  |  | 82 |  |  | 83 | 83 |  |  | 82 | DG
 |  |  |  |  |  |  |  | 83 |  |  | 84 | 84 |  |  | 83 | DH
 |  |  |  |  |  |  |  | 84 |  |  | 85 | 85 |  |  |  | EA
 |  |  |  |  |  |  |  | 85 |  |  |  |  |  |  |  | EB
 |  |  |  |  |  |  |  | 86 |  |  |  |  |  |  |  | EC
 |  |  |  |  |  |  |  | 87 |  |  |  |  |  |  |  | ED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TZ