Spreadsheet: 30666d1226340457-if-formula-ziptest
Sheet: Sheet2

TECH | ASMO4040 |  |  | zone | 1
21013 | 21057 | 21111 | 21156 | 21219 | 21236
21030 | 21082 | 21120 | 21161 | 21220 | 21237
21031 | 21085 | 21128 | 21162 | 21221 | 21239 |  |  | these are static zones with assigned zip codes
21051 | 21087 | 21131 | 21204 | 21222 | 21286
21052 | 21093 | 21152 | 21206 | 21234
TECH | ASMO4192 |  |  | zone | 2
21053 | 21102 | 21133 | 21155 | 21208 |  |  |  | <----------------------------
21074 | 21104 | 21136 | 21163 | 21244
21088 | 21117 | 21153 | 21207
 |  |  |  |  | this is zip code list that changes daily |  |  | this is assigned employee number
[NAME] | Cust First Name | Activity Number | Time Frame | Cust Acct Number | Service Zip5 | Service Region | Installation Tech | Tech
 | cust name 1 | 1-IMJ64O6 | PM | 51525104 | 21030 | MO16
 | cust name 2 | 1-IMYVREH | PM | 81896288 | 63052 | MO16 |  | ASMO004040 | Column I is the column that needs to be auto populated from the above zip clode lists
 | cust name 3 | 1-IN5U3CR | AM | 75766499 | 63020 | MO16 |  | ASMO004040
 | cust name 4 | 1-INJA4UZ | AM | 23803114 | 63020 | MO16 |  | ASMO004040
 | cust name 5 | 1-IOB5WDJ | PM | 26643719 | 63020 | MO16 |  | ASMO004040
 | cust name 6 | 1-IOCBOPB | AM | 15794760 | 63049 | MO16 |  | ASMO004040
 | cust name 7 | 1-IOEH34V | PM | 57289136 | 63049 | MO16 |  | ASMO004040
 | cust name 8 | 1-IOGT889 | AM | 9529337 | 63010 | MO16 |  | ASMO004040
 | cust name 9 | 1-IOHX3IA | AM | 25500111 | 63010 | MO16 |  | ASMO004040
 | cust name 10 | 1-IOMZHMB | AM | 27706754 | 63052 | MO16 |  | ASMO004040
 | cust name 11 | 1-IOONW8F | AM | 33461306 | 63005 | MO17 |  | ASMO004040 | <---------------
 | cust name 12 | 1-IOPFRH0 | PM | 28674472 | 63052 | MO16 |  | ASMO004040
 | cust name 13 | 1-IOVRNC2 | PM | 39724388 | 63010 | MO16 |  | ASMO004040
 | cust name 14 | 1-IOZR9U8 | AM | 4079228 | 63010 | MO16 |  | ASMO004040
 | cust name 15 | 1-IP1S9Y2 | PM | 57291423 | 63028 | MO16 |  | ASMO004040
 | cust name 16 | 1-IP25ZGV | PM | 16137042 | 63049 | MO16 |  | ASMO004040
 | cust name 17 | 1-IP3DO2U | PM | 7392687 | 63010 | MO16 |  | ASMO004040
 | cust name 18 | 1-IP3VRV5 | PM | 69430875 | 63020 | MO16 |  | ASMO004040
 | cust name 19 | 1-IPDC15J | AM | 5751502 | 63049 | MO16 |  | ASMO004040
 | cust name 20 | 1-IPDJFEM | AM | 32071802 | 63010 | MO16 |  | ASMO004040
 | cust name 21 | 1-IPEG671 | AM | 11417602 | 63028 | MO16 |  | ASMO004040
 | cust name 22 | 1-IPF66CB | PM | 63599026 | 63049 | MO16 |  | ASMO004040
 | cust name 23 | 1-IPM0DXB | PM | 50207797 | 63049 | MO16 |  | ASMO004040
 | cust name 24 | 1-IQDRTNT | AM | 75330710 | 63012 | MO16 |  | ASMO004040
 | cust name 25 | 1-IQXFV8J | PM | 14091152 | 63005 | MO17 |  | ASMO004040
 | cust name 27 | 1-IJSFB06 | PM | 39716036 | 63011 | MO17 |  | ASMO004192
 | cust name 28 | 1-IJVWOZT | AM | 81876316 | 63011 | MO17 |  | ASMO004192
 | cust name 29 | 1-IKFYIF3 | AM | 57276339 | 63130 | MO17 |  | ASMO004192
 | cust name 30 | 1-IKOIDAZ | PM | 45094031 | 63131 | MO17 |  | ASMO004192
 | cust name 31 | 1-IKYVD5R | AM | 81884615 | 63115 | MO17 |  | ASMO004192
 | cust name 32 | 1-IM8NGZG | AM | 24528785 | 63108 | MO17 |  | ASMO004192
 | cust name 33 | 1-INAZD8H | PM | 24685987 | 63141 | MO17 |  | ASMO004192
 | cust name 34 | 1-INKKQ66 | PM | 27580060 | 63130 | MO17 |  | ASMO004192
 | cust name 35 | 1-IO72Z25 | AM | 63594855 | 63011 | MO17 |  | ASMO004192
 | cust name 36 | 1-IOGFTKD | PM | 26102647 | 63114 | MO17 |  | ASMO004192
 | cust name 37 | 1-IOOJG94 | PM | 81908286 | 63131 | MO17 |  | ASMO004192
 | cust name 38 | 1-IOQM2TK | AM | 22253409 | 63141 | MO17 |  | ASMO004192
 | cust name 39 | 1-IOSGI13 | AM | 56002011 | 63112 | MO17 |  | ASMO004192
 | cust name 40 | 1-IOX57RE | AM | 50750846 | 63115 | MO17 |  | ASMO004192
 | cust name 41 | 1-IOZVZXH | AM | 39724599 | 63011 | MO17 |  | ASMO004192
 | cust name 42 | 1-IPXHF4G | AM | 74981683 | 63114 | MO17 |  | ASMO004192
 | cust name 43 | 1-IQ453A7 | AM | 69748977 | 63107 | MO17 |  | ASMO004192
 | cust name 44 | 1-IQ4OJZG | PM | 63601404 | 63104 | MO17 |  | ASMO004192