Spreadsheet: 120192d1315061104-i-need-to-look-over-a-column-of-zip-codes-and-delete-some-of-them-book1
Sheet: Sheet1

Big list | VLOOKUP | COUNTIF |  |  |  |  | Smaller list
Zip1 | #N/A | 0 |  |  |  |  | Zip230
Zip2 | #N/A | 0 |  |  |  |  | Zip106
Zip3 | #N/A | 0 |  |  |  |  | Zip456
Zip4 | #N/A | 0 |  |  |  |  | Zip55
Zip5 | #N/A | 0 |  |  |  |  | Zip319
Zip6 | Zip6 | 1 |  |  |  |  | Zip90
Zip7 | Zip7 | 1 |  |  |  |  | Zip337
Zip8 | #N/A | 0 |  |  |  |  | Zip57
Zip9 | #N/A | 0 |  |  |  |  | Zip112
Zip10 | Zip10 | 1 |  |  |  |  | Zip361
Zip11 | #N/A | 0 |  |  |  |  | Zip390
Zip12 | Zip12 | 1 |  |  |  |  | Zip320
[NAME] | #N/A | 0 |  |  |  |  | Zip69
Zip14 | #N/A | 0 |  |  |  |  | Zip308
Zip15 | Zip15 | 1 |  |  |  |  | Zip125
Zip16 | #N/A | 0 |  |  |  |  | Zip317
Zip17 | Zip17 | 1 |  |  |  |  | Zip311
Zip18 | Zip18 | 1 |  |  |  |  | Zip184
Zip19 | #N/A | 0 |  |  |  |  | Zip170
Zip20 | #N/A | 0 |  |  |  |  | Zip334
[NAME] | #N/A | 0 |  |  |  |  | Zip404
[NAME] | #N/A | 0 |  |  |  |  | Zip134
Zip23 | #N/A | 0 |  |  |  |  | Zip29
Zip24 | #N/A | 0 |  |  |  |  | Zip233
Zip25 | #N/A | 0 |  |  |  |  | Zip418
Zip26 | #N/A | 0 |  |  |  |  | Zip267
Zip27 | Zip27 | 1 |  |  |  |  | Zip103
Zip28 | Zip28 | 1 |  |  |  |  | Zip17
Zip29 | Zip29 | 1 |  |  |  |  | Zip138
[NAME] | #N/A | 0 |  |  |  |  | Zip223
Zip31 | Zip31 | 1 |  |  |  |  | Zip242
Zip32 | Zip32 | 1 |  |  |  |  | Zip270
Zip33 | Zip33 | 1 |  |  |  |  | Zip438
Zip34 | Zip34 | 1 |  |  |  |  | Zip115
[NAME] | #N/A | 0 |  |  |  |  | Zip220
Zip36 | #N/A | 0 |  |  |  |  | Zip403
Zip37 | #N/A | 0 |  |  |  |  | Zip430
Zip38 | Zip38 | 1 |  |  |  |  | Zip296
Zip39 | #N/A | 0 |  |  |  |  | Zip392
Zip40 | #N/A | 0 |  |  |  |  | Zip132
[NAME] | [NAME] | 1 |  |  |  |  | Zip346
Zip42 | Zip42 | 1 |  |  |  |  | [NAME]
Zip43 | #N/A | 0 |  |  |  |  | Zip435
Zip44 | #N/A | 0 |  |  |  |  | Zip92
Zip45 | #N/A | 0 |  |  |  |  | Zip262
Zip46 | Zip46 | 1 |  |  |  |  | Zip148
Zip47 | #N/A | 0 |  |  |  |  | [NAME]
Zip48 | Zip48 | 1 |  |  |  |  | Zip330
[NAME] | #N/A | 0 |  |  |  |  | Zip38
Zip50 | #N/A | 0 |  |  |  |  | Zip408
Zip51 | #N/A | 0 |  |  |  |  | Zip108
Zip52 | #N/A | 0 |  |  |  |  | Zip192
Zip53 | Zip53 | 1 |  |  |  |  | Zip381
Zip54 | #N/A | 0 |  |  |  |  | Zip6
Zip55 | Zip55 | 1 |  |  |  |  | Zip212
Zip56 | #N/A | 0 |  |  |  |  | Zip375
Zip57 | Zip57 | 1 |  |  |  |  | Zip234
[NAME] | #N/A | 0 |  |  |  |  | Zip32
Zip59 | #N/A | 0 |  |  |  |  | Zip15
[NAME] | [NAME] | 1 |  |  |  |  | Zip235
Zip61 | #N/A | 0 |  |  |  |  | Zip96
Zip62 | #N/A | 0 |  |  |  |  | Zip355
[NAME] | #N/A | 0 |  |  |  |  | Zip291
Zip64 | #N/A | 0 |  |  |  |  | Zip10
Zip65 | #N/A | 0 |  |  |  |  | Zip405
Zip66 | #N/A | 0 |  |  |  |  | Zip345
Zip67 | #N/A | 0 |  |  |  |  | Zip117
Zip68 | Zip68 | 1 |  |  |  |  | Zip114
Zip69 | Zip69 | 1 |  |  |  |  | [NAME]
[NAME] | [NAME] | 1 |  |  |  |  | [NAME]
Zip71 | Zip71 | 1 |  |  |  |  | Zip284
Zip72 | #N/A | 0 |  |  |  |  | Zip306
[NAME] | [NAME] | 1 |  |  |  |  | Zip143
Zip74 | #N/A | 0 |  |  |  |  | Zip121
Zip75 | #N/A | 0 |  |  |  |  | Zip374
Zip76 | #N/A | 0 |  |  |  |  | Zip154
Zip77 | #N/A | 0 |  |  |  |  | Zip282
Zip78 | #N/A | 0 |  |  |  |  | Zip312
Zip79 | #N/A | 0 |  |  |  |  | Zip101
Zip80 | #N/A | 0 |  |  |  |  | Zip48
[NAME] | #N/A | 0 |  |  |  |  | Zip42
Zip82 | #N/A | 0 |  |  |  |  | Zip318
Zip83 | #N/A | 0 |  |  |  |  | Zip260
Zip84 | #N/A | 0 |  |  |  |  | Zip225
Zip85 | #N/A | 0 |  |  |  |  | Zip12
Zip86 | Zip86 | 1 |  |  |  |  | Zip198
Zip87 | #N/A | 0 |  |  |  |  | Zip203
Zip88 | #N/A | 0 |  |  |  |  | Zip245
Zip89 | #N/A | 0 |  |  |  |  | Zip236
Zip90 | Zip90 | 1 |  |  |  |  | Zip7
Zip91 | #N/A | 0 |  |  |  |  | Zip332
Zip92 | Zip92 | 1 |  |  |  |  | Zip172
Zip93 | #N/A | 0 |  |  |  |  | Zip241
Zip94 | #N/A | 0 |  |  |  |  | Zip126
Zip95 | #N/A | 0 |  |  |  |  | Zip97
Zip96 | Zip96 | 1 |  |  |  |  | Zip261
Zip97 | Zip97 | 1 |  |  |  |  | Zip227
[NAME] | #N/A | 0 |  |  |  |  | Zip248
Zip99 | Zip99 | 1 |  |  |  |  | Zip200
Zip100 | #N/A | 0 |  |  |  |  | Zip409
Zip101 | Zip101 | 1 |  |  |  |  | Zip421
Zip102 | Zip102 | 1 |  |  |  |  | Zip400
Zip103 | Zip103 | 1 |  |  |  |  | Zip27
Zip104 | #N/A | 0 |  |  |  |  | [NAME]
Zip105 | Zip105 | 1 |  |  |  |  | Zip246
Zip106 | Zip106 | 1 |  |  |  |  | Zip353
Zip107 | #N/A | 0 |  |  |  |  | Zip402
Zip108 | Zip108 | 1 |  |  |  |  | Zip221
Zip109 | #N/A | 0 |  |  |  |  | Zip279
Zip110 | Zip110 | 1 |  |  |  |  | Zip290
Zip111 | #N/A | 0 |  |  |  |  | Zip140
Zip112 | Zip112 | 1 |  |  |  |  | Zip285
Zip113 | Zip113 | 1 |  |  |  |  | Zip18
Zip114 | Zip114 | 1 |  |  |  |  | Zip412
Zip115 | Zip115 | 1 |  |  |  |  | Zip33
Zip116 | Zip116 | 1 |  |  |  |  | Zip141
Zip117 | Zip117 | 1 |  |  |  |  | Zip369
Zip118 | #N/A | 0 |  |  |  |  | [NAME]
Zip119 | #N/A | 0 |  |  |  |  | Zip455
Zip120 | #N/A | 0 |  |  |  |  | Zip252
Zip121 | Zip121 | 1 |  |  |  |  | [NAME]
Zip122 | #N/A | 0 |  |  |  |  | Zip419
Zip123 | #N/A | 0 |  |  |  |  | Zip211
Zip124 | #N/A | 0 |  |  |  |  | Zip398
Zip125 | Zip125 | 1 |  |  |  |  | [NAME]
Zip126 | Zip126 | 1 |  |  |  |  | Zip425
[NAME] | #N/A | 0 |  |  |  |  | Zip388
Zip128 | #N/A | 0 |  |  |  |  | Zip450
Zip129 | #N/A | 0 |  |  |  |  | Zip434
Zip130 | Zip130 | 1 |  |  |  |  | Zip244
Zip131 | #N/A | 0 |  |  |  |  | Zip452
Zip132 | Zip132 | 1 |  |  |  |  | Zip238
Zip133 | #N/A | 0 |  |  |  |  | Zip289
Zip134 | Zip134 | 1 |  |  |  |  | Zip364
Zip135 | #N/A | 0 |  |  |  |  | Zip269
Zip136 | #N/A | 0 |  |  |  |  | Zip324
[NAME] | [NAME] | 1 |  |  |  |  | Zip351
Zip138 | Zip138 | 1 |  |  |  |  | Zip46
Zip139 | #N/A | 0 |  |  |  |  | Zip146
Zip140 | Zip140 | 1 |  |  |  |  | Zip336
Zip141 | Zip141 | 1 |  |  |  |  | Zip196
Zip142 | #N/A | 0 |  |  |  |  | Zip28
Zip143 | Zip143 | 1 |  |  |  |  | Zip432
Zip144 | #N/A | 0 |  |  |  |  | Zip185
Zip145 | #N/A | 0 |  |  |  |  | Zip250
Zip146 | Zip146 | 1 |  |  |  |  | Zip207
[NAME] | [NAME] | 1 |  |  |  |  | Zip348
Zip148 | Zip148 | 1 |  |  |  |  | Zip99
Zip149 | #N/A | 0 |  |  |  |  | Zip163
Zip150 | #N/A | 0 |  |  |  |  | Zip377
Zip151 | Zip151 | 1 |  |  |  |  | Zip386
[NAME] | [NAME] | 1 |  |  |  |  | Zip209
Zip153 | #N/A | 0 |  |  |  |  | Zip365
Zip154 | Zip154 | 1 |  |  |  |  | Zip394
Zip155 | #N/A | 0 |  |  |  |  | Zip31
Zip156 | #N/A | 0 |  |  |  |  | Zip164
Zip157 | #N/A | 0 |  |  |  |  | Zip278
Zip158 | #N/A | 0 |  |  |  |  | Zip151
Zip159 | #N/A | 0 |  |  |  |  | Zip116
Zip160 | #N/A | 0 |  |  |  |  | Zip71
Zip161 | #N/A | 0 |  |  |  |  | Zip380
Zip162 | Zip162 | 1 |  |  |  |  | Zip214
Zip163 | Zip163 | 1 |  |  |  |  | Zip113
Zip164 | Zip164 | 1 |  |  |  |  | Zip130
Zip165 | #N/A | 0 |  |  |  |  | Zip397
[NAME] | [NAME] | 1 |  |  |  |  | Zip299
Zip167 | #N/A | 0 |  |  |  |  | Zip197
Zip168 | #N/A | 0 |  |  |  |  | Zip186
Zip169 | #N/A | 0 |  |  |  |  | Zip219
Zip170 | Zip170 | 1 |  |  |  |  | Zip239
Zip171 | #N/A | 0 |  |  |  |  | Zip243
Zip172 | Zip172 | 1 |  |  |  |  | Zip389
Zip173 | #N/A | 0 |  |  |  |  | Zip105
Zip174 | #N/A | 0 |  |  |  |  | Zip459
Zip175 | #N/A | 0 |  |  |  |  | Zip326
Zip176 | #N/A | 0 |  |  |  |  | Zip179
Zip177 | #N/A | 0 |  |  |  |  | Zip370
Zip178 | #N/A | 0 |  |  |  |  | Zip384
Zip179 | Zip179 | 1 |  |  |  |  | Zip180
Zip180 | Zip180 | 1 |  |  |  |  | [NAME]
Zip181 | #N/A | 0 |  |  |  |  | Zip199
Zip182 | #N/A | 0 |  |  |  |  | Zip378
Zip183 | #N/A | 0 |  |  |  |  | Zip162
Zip184 | Zip184 | 1 |  |  |  |  | [NAME]
Zip185 | Zip185 | 1 |  |  |  |  | Zip102
Zip186 | Zip186 | 1 |  |  |  |  | Zip68
Zip187 | #N/A | 0 |  |  |  |  | Zip414
Zip188 | #N/A | 0 |  |  |  |  | Zip34
[NAME] | [NAME] | 1 |  |  |  |  | Zip428
Zip190 | #N/A | 0 |  |  |  |  | Zip315
Zip191 | #N/A | 0 |  |  |  |  | Zip86
Zip192 | Zip192 | 1 |  |  |  |  | Zip53
Zip193 | #N/A | 0 |  |  |  |  | Zip360
Zip194 | #N/A | 0 |  |  |  |  | Zip446
Zip195 | #N/A | 0 |  |  |  |  | Zip342
Zip196 | Zip196 | 1 |  |  |  |  | Zip273
Zip197 | Zip197 | 1 |  |  |  |  | Zip453
Zip198 | Zip198 | 1 |  |  |  |  | Zip293
Zip199 | Zip199 | 1 |  |  |  |  | Zip449
Zip200 | Zip200 | 1 |  |  |  |  | Zip110
Zip201 | #N/A | 0
Zip202 | #N/A | 0
Zip203 | Zip203 | 1
Zip204 | #N/A | 0
Zip205 | #N/A | 0
Zip206 | #N/A | 0
Zip207 | Zip207 | 1
Zip208 | #N/A | 0
Zip209 | Zip209 | 1
Zip210 | #N/A | 0
Zip211 | Zip211 | 1
Zip212 | Zip212 | 1
Zip213 | #N/A | 0
Zip214 | Zip214 | 1
Zip215 | #N/A | 0
Zip216 | #N/A | 0
Zip217 | #N/A | 0
Zip218 | #N/A | 0
Zip219 | Zip219 | 1
Zip220 | Zip220 | 1
Zip221 | Zip221 | 1
Zip222 | #N/A | 0
Zip223 | Zip223 | 1
Zip224 | #N/A | 0
Zip225 | Zip225 | 1
Zip226 | #N/A | 0
Zip227 | Zip227 | 1
Zip228 | #N/A | 0
Zip229 | #N/A | 0
Zip230 | Zip230 | 1
Zip231 | #N/A | 0
Zip232 | #N/A | 0
Zip233 | Zip233 | 1
Zip234 | Zip234 | 1
Zip235 | Zip235 | 1
Zip236 | Zip236 | 1
Zip237 | #N/A | 0
Zip238 | Zip238 | 1
Zip239 | Zip239 | 1
Zip240 | #N/A | 0
Zip241 | Zip241 | 1
Zip242 | Zip242 | 1
Zip243 | Zip243 | 1
Zip244 | Zip244 | 1
Zip245 | Zip245 | 1
Zip246 | Zip246 | 1
Zip247 | #N/A | 0
Zip248 | Zip248 | 1
Zip249 | #N/A | 0
Zip250 | Zip250 | 1
Zip251 | #N/A | 0
Zip252 | Zip252 | 1
Zip253 | #N/A | 0
Zip254 | #N/A | 0
Zip255 | #N/A | 0
Zip256 | #N/A | 0
Zip257 | #N/A | 0
Zip258 | #N/A | 0
Zip259 | #N/A | 0
Zip260 | Zip260 | 1
Zip261 | Zip261 | 1
Zip262 | Zip262 | 1
Zip263 | #N/A | 0
Zip264 | #N/A | 0
Zip265 | #N/A | 0
Zip266 | #N/A | 0
Zip267 | Zip267 | 1
Zip268 | #N/A | 0
Zip269 | Zip269 | 1
Zip270 | Zip270 | 1
Zip271 | #N/A | 0
Zip272 | #N/A | 0
Zip273 | Zip273 | 1
Zip274 | #N/A | 0
[NAME] | #N/A | 0
Zip276 | #N/A | 0
Zip277 | #N/A | 0
Zip278 | Zip278 | 1
Zip279 | Zip279 | 1
Zip280 | #N/A | 0
Zip281 | #N/A | 0
Zip282 | Zip282 | 1
Zip283 | #N/A | 0
Zip284 | Zip284 | 1
Zip285 | Zip285 | 1
Zip286 | #N/A | 0
Zip287 | #N/A | 0
Zip288 | #N/A | 0
Zip289 | Zip289 | 1
Zip290 | Zip290 | 1
Zip291 | Zip291 | 1
Zip292 | #N/A | 0
Zip293 | Zip293 | 1
Zip294 | #N/A | 0
Zip295 | #N/A | 0
Zip296 | Zip296 | 1
Zip297 | #N/A | 0
Zip298 | #N/A | 0
Zip299 | Zip299 | 1
Zip300 | #N/A | 0
Zip301 | #N/A | 0
Zip302 | #N/A | 0
Zip303 | #N/A | 0
Zip304 | #N/A | 0
Zip305 | #N/A | 0
Zip306 | Zip306 | 1
Zip307 | #N/A | 0
Zip308 | Zip308 | 1
Zip309 | #N/A | 0
[NAME] | #N/A | 0
Zip311 | Zip311 | 1
Zip312 | Zip312 | 1
Zip313 | #N/A | 0
Zip314 | #N/A | 0
Zip315 | Zip315 | 1
[NAME] | [NAME] | 1
Zip317 | Zip317 | 1
Zip318 | Zip318 | 1
Zip319 | Zip319 | 1
Zip320 | Zip320 | 1
Zip321 | #N/A | 0
Zip322 | #N/A | 0
Zip323 | #N/A | 0
Zip324 | Zip324 | 1
Zip325 | #N/A | 0
Zip326 | Zip326 | 1
Zip327 | #N/A | 0
Zip328 | #N/A | 0
Zip329 | #N/A | 0
Zip330 | Zip330 | 1
Zip331 | #N/A | 0
Zip332 | Zip332 | 1
Zip333 | #N/A | 0
Zip334 | Zip334 | 1
Zip335 | #N/A | 0
Zip336 | Zip336 | 1
Zip337 | Zip337 | 1
Zip338 | #N/A | 0
Zip339 | #N/A | 0
Zip340 | #N/A | 0
Zip341 | #N/A | 0
Zip342 | Zip342 | 1
Zip343 | #N/A | 0
[NAME] | #N/A | 0
Zip345 | Zip345 | 1
Zip346 | Zip346 | 1
Zip347 | #N/A | 0
Zip348 | Zip348 | 1
Zip349 | #N/A | 0
Zip350 | #N/A | 0
Zip351 | Zip351 | 1
Zip352 | #N/A | 0
Zip353 | Zip353 | 1
Zip354 | #N/A | 0
Zip355 | Zip355 | 1
Zip356 | #N/A | 0
Zip357 | #N/A | 0
Zip358 | #N/A | 0
Zip359 | #N/A | 0
Zip360 | Zip360 | 1
Zip361 | Zip361 | 1
Zip362 | #N/A | 0
Zip363 | #N/A | 0
Zip364 | Zip364 | 1
Zip365 | Zip365 | 1
[NAME] | #N/A | 0
Zip367 | #N/A | 0
Zip368 | #N/A | 0
Zip369 | Zip369 | 1
Zip370 | Zip370 | 1
[NAME] | #N/A | 0
Zip372 | #N/A | 0
Zip373 | #N/A | 0
Zip374 | Zip374 | 1
Zip375 | Zip375 | 1
Zip376 | #N/A | 0
Zip377 | Zip377 | 1
Zip378 | Zip378 | 1
Zip379 | #N/A | 0
Zip380 | Zip380 | 1
Zip381 | Zip381 | 1
Zip382 | #N/A | 0
Zip383 | #N/A | 0
Zip384 | Zip384 | 1
[NAME] | #N/A | 0
Zip386 | Zip386 | 1
Zip387 | #N/A | 0
Zip388 | Zip388 | 1
Zip389 | Zip389 | 1
Zip390 | Zip390 | 1
Zip391 | #N/A | 0
Zip392 | Zip392 | 1
Zip393 | #N/A | 0
Zip394 | Zip394 | 1
Zip395 | #N/A | 0
Zip396 | #N/A | 0
Zip397 | Zip397 | 1
Zip398 | Zip398 | 1
Zip399 | #N/A | 0
Zip400 | Zip400 | 1
Zip401 | #N/A | 0
Zip402 | Zip402 | 1
Zip403 | Zip403 | 1
Zip404 | Zip404 | 1
Zip405 | Zip405 | 1
Zip406 | #N/A | 0
Zip407 | #N/A | 0
Zip408 | Zip408 | 1
Zip409 | Zip409 | 1
Zip410 | #N/A | 0
Zip411 | #N/A | 0
Zip412 | Zip412 | 1
Zip413 | #N/A | 0
Zip414 | Zip414 | 1
Zip415 | #N/A | 0
[NAME] | #N/A | 0
Zip417 | #N/A | 0
Zip418 | Zip418 | 1
Zip419 | Zip419 | 1
Zip420 | #N/A | 0
Zip421 | Zip421 | 1
Zip422 | #N/A | 0
Zip423 | #N/A | 0
Zip424 | #N/A | 0
Zip425 | Zip425 | 1
Zip426 | #N/A | 0
Zip427 | #N/A | 0
Zip428 | Zip428 | 1
Zip429 | #N/A | 0
Zip430 | Zip430 | 1
Zip431 | #N/A | 0
Zip432 | Zip432 | 1
Zip433 | #N/A | 0
Zip434 | Zip434 | 1
Zip435 | Zip435 | 1
[NAME] | #N/A | 0
Zip437 | #N/A | 0
Zip438 | Zip438 | 1
Zip439 | #N/A | 0
Zip440 | #N/A | 0
Zip441 | #N/A | 0
Zip442 | #N/A | 0
Zip443 | #N/A | 0
Zip444 | #N/A | 0
[NAME] | #N/A | 0
Zip446 | Zip446 | 1
Zip447 | #N/A | 0
Zip448 | #N/A | 0
Zip449 | Zip449 | 1
Zip450 | Zip450 | 1
Zip451 | #N/A | 0
Zip452 | Zip452 | 1
Zip453 | Zip453 | 1
[NAME] | #N/A | 0
Zip455 | Zip455 | 1
Zip456 | Zip456 | 1
Zip457 | #N/A | 0
Zip458 | #N/A | 0
Zip459 | Zip459 | 1