Spreadsheet: 551925d1513222662-vlookup-isnt-helping-me-with-zip-codes-microsoft-excel-2013-workbook-shell-part-a
Sheet: 114

ZONE CHART
UPS Ground/UPS 3 Day Select/UPS 2nd Day Air/UPS 2nd Day Air A.M./UPS Next Day Air Saver/UPS Next Day Air
For shipments originating in ZIP Codes 114-01 to 115-99. To determine zone
take the first three digits of the receiver's ZIP Code and refer to the chart below:
ZONES
Dest. ZIP | Ground | 3 Day Select | 2nd Day Air | 2nd Day Air A.M. | Next Day Air Saver | Next Day Air
004-005 | 002 | 302 | 202 | 242 | 132 | 102
006-007 | 045 | - | 225 | - | - | 125
009 | 045 | - | 225 | - | - | 125
010-013 | 002 | 302 | 202 | 242 | 132 | 102
014 | 003 | 303 | 203 | 243 | 133 | 103
015-018 | 002 | 302 | 202 | 242 | 132 | 102
019 | 003 | 303 | 203 | 243 | 133 | 103
020-024 | 002 | 302 | 202 | 242 | 132 | 102
025-026 | 003 | 303 | 203 | 243 | 133 | 103
027-029 | 002 | 302 | 202 | 242 | 132 | 102
030-033 | 003 | 303 | 203 | 243 | 133 | 103
034 | 002 | 302 | 202 | 242 | 132 | 102
035-043 | 003 | 303 | 203 | 243 | 133 | 103
044 | 004 | 304 | 204 | 244 | 134 | 104
045 | 003 | 303 | 203 | 243 | 133 | 103
046-049 | 004 | 304 | 204 | 244 | 134 | 104
050-051 | 003 | 303 | 203 | 243 | 133 | 103
052-053 | 002 | 302 | 202 | 242 | 132 | 102
054 | 003 | 303 | 203 | 243 | 133 | 103
055 | 002 | 302 | 202 | 242 | 132 | 102
056-059 | 003 | 303 | 203 | 243 | 133 | 103
060-089 | 002 | 302 | 202 | 242 | 132 | 102
100-127 | 002 | 302 | 202 | 242 | 132 | 102
128-136 | 003 | 303 | 203 | 243 | 133 | 103
137-139 | 002 | 302 | 202 | 242 | 132 | 102
140-142 | 003 | 303 | 203 | 243 | 133 | 103
143 | 004 | 304 | 204 | 244 | 134 | 104
144-149 | 003 | 303 | 203 | 243 | 133 | 103
150-154 | 004 | 304 | 204 | 244 | 134 | 104
155 | 003 | 303 | 203 | 243 | 133 | 103
156 | 004 | 304 | 204 | 244 | 134 | 104
157-159 | 003 | 303 | 203 | 243 | 133 | 103
160-162 | 004 | 304 | 204 | 244 | 134 | 104
163 | 003 | 303 | 203 | 243 | 133 | 103
164-165 | 004 | 304 | 204 | 244 | 134 | 104
166-169 | 003 | 303 | 203 | 243 | 133 | 103
170-172 | 002 | 302 | 202 | 242 | 132 | 102
173-174 | 003 | 303 | 203 | 243 | 133 | 103
175-176 | 002 | 302 | 202 | 242 | 132 | 102
177 | 003 | 303 | 203 | 243 | 133 | 103
178-199 | 002 | 302 | 202 | 242 | 132 | 102
200-218 | 003 | 303 | 203 | 243 | 133 | 103
219 | 002 | 302 | 202 | 242 | 132 | 102
220-238 | 003 | 303 | 203 | 243 | 133 | 103
239-253 | 004 | 304 | 204 | 244 | 134 | 104
254 | 003 | 303 | 203 | 243 | 133 | 103
255-266 | 004 | 304 | 204 | 244 | 134 | 104
267 | 003 | 303 | 203 | 243 | 133 | 103
268-288 | 004 | 304 | 204 | 244 | 134 | 104
289-292 | 005 | 305 | 205 | 245 | 135 | 105
293 | 004 | 304 | 204 | 244 | 134 | 104
294 | 005 | 305 | 205 | 245 | 135 | 105
295-297 | 004 | 304 | 204 | 244 | 134 | 104
298-324 | 005 | 305 | 205 | 245 | 135 | 105
325 | 006 | 306 | 206 | 246 | 136 | 106
326-329 | 005 | 305 | 205 | 245 | 135 | 105
330-334 | 006 | 306 | 206 | 246 | 136 | 106
335-336 | 005 | 305 | 205 | 245 | 135 | 105
337 | 006 | 306 | 206 | 246 | 136 | 106
338 | 005 | 305 | 205 | 245 | 135 | 105
339 | 006 | 306 | 206 | 246 | 136 | 106
341 | 006 | 306 | 206 | 246 | 136 | 106
342-347 | 005 | 305 | 205 | 245 | 135 | 105
349 | 006 | 306 | 206 | 246 | 136 | 106
350-364 | 005 | 305 | 205 | 245 | 135 | 105
365-366 | 006 | 306 | 206 | 246 | 136 | 106
367-375 | 005 | 305 | 205 | 245 | 135 | 105
376 | 004 | 304 | 204 | 244 | 134 | 104
377-386 | 005 | 305 | 205 | 245 | 135 | 105
387 | 006 | 306 | 206 | 246 | 136 | 106
388-389 | 005 | 305 | 205 | 245 | 135 | 105
390-392 | 006 | 306 | 206 | 246 | 136 | 106
393 | 005 | 305 | 205 | 245 | 135 | 105
394-396 | 006 | 306 | 206 | 246 | 136 | 106
397-402 | 005 | 305 | 205 | 245 | 135 | 105
403-406 | 004 | 304 | 204 | 244 | 134 | 104
407-409 | 005 | 305 | 205 | 245 | 135 | 105
410-418 | 004 | 304 | 204 | 244 | 134 | 104
420-427 | 005 | 305 | 205 | 245 | 135 | 105
430-459 | 004 | 304 | 204 | 244 | 134 | 104
460-466 | 005 | 305 | 205 | 245 | 135 | 105
467-468 | 004 | 304 | 204 | 244 | 134 | 104
469 | 005 | 305 | 205 | 245 | 135 | 105
470 | 004 | 304 | 204 | 244 | 134 | 104
471-472 | 005 | 305 | 205 | 245 | 135 | 105
473 | 004 | 304 | 204 | 244 | 134 | 104
474-479 | 005 | 305 | 205 | 245 | 135 | 105
480-489 | 004 | 304 | 204 | 244 | 134 | 104
490-491 | 005 | 305 | 205 | 245 | 135 | 105
492 | 004 | 304 | 204 | 244 | 134 | 104
493-499 | 005 | 305 | 205 | 245 | 135 | 105
500-503 | 006 | 306 | 206 | 246 | 136 | 106
504 | 005 | 305 | 205 | 245 | 135 | 105
505 | 006 | 306 | 206 | 246 | 136 | 106
506-507 | 005 | 305 | 205 | 245 | 135 | 105
508-516 | 006 | 306 | 206 | 246 | 136 | 106
520-539 | 005 | 305 | 205 | 245 | 135 | 105
540 | 006 | 306 | 206 | 246 | 136 | 106
541-549 | 005 | 305 | 205 | 245 | 135 | 105
550-555 | 006 | 306 | 206 | 246 | 136 | 106
556-559 | 005 | 305 | 205 | 245 | 135 | 105
560-576 | 006 | 306 | 206 | 246 | 136 | 106
577 | 007 | 307 | 207 | 247 | 137 | 107
580-585 | 006 | 306 | 206 | 246 | 136 | 106
586-593 | 007 | 307 | 207 | 247 | 137 | 107
594-599 | 008 | 308 | 208 | 248 | 138 | 108
600-639 | 005 | 305 | 205 | 245 | 135 | 105
640-649 | 006 | 306 | 206 | 246 | 136 | 106
650-652 | 005 | 305 | 205 | 245 | 135 | 105
653 | 006 | 306 | 206 | 246 | 136 | 106
654-655 | 005 | 305 | 205 | 245 | 135 | 105
656-676 | 006 | 306 | 206 | 246 | 136 | 106
677-679 | 007 | 307 | 207 | 247 | 137 | 107
680-689 | 006 | 306 | 206 | 246 | 136 | 106
690 | 007 | 307 | 207 | 247 | 137 | 107
691-692 | 006 | 306 | 206 | 246 | 136 | 106
693 | 007 | 307 | 207 | 247 | 137 | 107
700-722 | 006 | 306 | 206 | 246 | 136 | 106
723-724 | 005 | 305 | 205 | 245 | 135 | 105
725-732 | 006 | 306 | 206 | 246 | 136 | 106
733 | 007 | 307 | 207 | 247 | 137 | 107
734-738 | 006 | 306 | 206 | 246 | 136 | 106
739 | 007 | 307 | 207 | 247 | 137 | 107
740-762 | 006 | 306 | 206 | 246 | 136 | 106
763 | 007 | 307 | 207 | 247 | 137 | 107
764 | 006 | 306 | 206 | 246 | 136 | 106
765-772 | 007 | 307 | 207 | 247 | 137 | 107
773 | 006 | 306 | 206 | 246 | 136 | 106
774-775 | 007 | 307 | 207 | 247 | 137 | 107
776-777 | 006 | 306 | 206 | 246 | 136 | 106
778-797 | 007 | 307 | 207 | 247 | 137 | 107
798-799 | 008 | 308 | 208 | 248 | 138 | 108
800-812 | 007 | 307 | 207 | 247 | 137 | 107
813 | 008 | 308 | 208 | 248 | 138 | 108
814 | 007 | 307 | 207 | 247 | 137 | 107
815 | 008 | 308 | 208 | 248 | 138 | 108
816-820 | 007 | 307 | 207 | 247 | 137 | 107
821 | 008 | 308 | 208 | 248 | 138 | 108
822-828 | 007 | 307 | 207 | 247 | 137 | 107
829-874 | 008 | 308 | 208 | 248 | 138 | 108
875-877 | 007 | 307 | 207 | 247 | 137 | 107
878-880 | 008 | 308 | 208 | 248 | 138 | 108
881-884 | 007 | 307 | 207 | 247 | 137 | 107
885-961 | 008 | 308 | 208 | 248 | 138 | 108
970-986 | 008 | 308 | 208 | 248 | 138 | 108
988-994 | 008 | 308 | 208 | 248 | 138 | 108
[1] For Virgin Islands, Guam, Marshall Islands, etc., please refer to the Worldwide Rate and Zone information.
[2] For Hawaii, the following Postal Codes are Zone 44 for Ground, Zone 124 for Next Day Air and Zone 224 for 2nd Day Air:
96701 | 96706 | 96707 | 96709 | 96712 | 96717 | 96730 | 96731 | 96734
96744 | 96759 | 96762 | 96782 | 96786 | 96789 | 96791 | 96792 | 96795
96797 | 96801 | 96802 | 96803 | 96804 | 96805 | 96806 | 96807 | 96808
96809 | 96810 | 96811 | 96812 | 96813 | 96814 | 96815 | 96816 | 96817
96818 | 96819 | 96820 | 96821 | 96822 | 96823 | 96824 | 96825 | 96826
96827 | 96828 | 96830 | 96835 | 96836 | 96837 | 96838 | 96839 | 96840
96841 | 96842 | 96843 | 96844 | 96845 | 96846 | 96847 | 96848 | 96849
96850 | 96853 | 96854 | 96857 | 96858 | 96859 | 96860 | 96861 | 96862
96863 | 96898
For Hawaii, the following Postal Codes are Zone 46 for Ground, Zone 126 for Next Day Air and Zone 226 for 2nd Day Air:
96703 | 96704 | 96705 | 96708 | 96710 | 96713 | 96714 | 96715 | 96716
96718 | 96719 | 96720 | 96721 | 96722 | 96725 | 96726 | 96727 | 96728
96729 | 96732 | 96733 | 96737 | 96738 | 96739 | 96740 | 96741 | 96742
96743 | 96745 | 96746 | 96747 | 96748 | 96749 | 96750 | 96751 | 96752
96753 | 96754 | 96755 | 96756 | 96757 | 96760 | 96761 | 96763 | 96764
96765 | 96766 | 96767 | 96768 | 96769 | 96770 | 96771 | 96772 | 96773
96774 | 96775 | 96776 | 96777 | 96778 | 96779 | 96780 | 96781 | 96783
96784 | 96785 | 96788 | 96790 | 96793 | 96796
[3] For Alaska, the following Postal Codes are Zone 44 for Ground, Zone 124 for Next Day Air and Zone 224 for 2nd Day Air:
99501 | 99502 | 99503 | 99504 | 99505 | 99506 | 99507 | 99508 | 99509
99510 | 99511 | 99512 | 99513 | 99514 | 99515 | 99516 | 99517 | 99518
99519 | 99520 | 99521 | 99522 | 99523 | 99524 | 99540 | 99556 | 99567
99568 | 99572 | 99577 | 99587 | 99603 | 99605 | 99610 | 99611 | 99631
99635 | 99639 | 99645 | 99654 | 99664 | 99669 | 99672 | 99687 | 99701
99702 | 99703 | 99705 | 99706 | 99707 | 99708 | 99709 | 99710 | 99711
99712 | 99775
For Alaska, the following Postal Codes are Zone 46 for Ground, Zone 126 for Next Day Air and Zone 226 for 2nd Day Air.
99529 | 99530 | 99545 | 99546 | 99547 | 99548 | 99549 | 99550 | 99551
99552 | 99553 | 99554 | 99555 | 99557 | 99558 | 99559 | 99561 | 99563
99564 | 99565 | 99566 | 99569 | 99571 | 99573 | 99574 | 99575 | 99576
99578 | 99579 | 99580 | 99581 | 99583 | 99584 | 99585 | 99586 | 99588
99589 | 99590 | 99591 | 99599 | 99602 | 99604 | 99606 | 99607 | 99608
99609 | 99612 | 99613 | 99614 | 99615 | 99619 | 99620 | 99621 | 99622
99623 | 99624 | 99625 | 99626 | 99627 | 99628 | 99629 | 99630 | 99632
99633 | 99634 | 99636 | 99637 | 99638 | 99640 | 99641 | 99643 | 99644
99647 | 99648 | 99649 | 99650 | 99651 | 99652 | 99653 | 99655 | 99656
99657 | 99658 | 99659 | 99660 | 99661 | 99662 | 99663 | 99665 | 99666
99667 | 99668 | 99670 | 99671 | 99674 | 99675 | 99676 | 99677 | 99678
99679 | 99680 | 99681 | 99682 | 99683 | 99684 | 99685 | 99686 | 99688
99689 | 99690 | 99691 | 99692 | 99693 | 99694 | 99695 | 99697 | 99704
99714 | 99716 | 99720 | 99721 | 99722 | 99723 | 99724 | 99725 | 99726
99727 | 99729 | 99730 | 99731 | 99732 | 99733 | 99734 | 99736 | 99737
99738 | 99739 | 99740 | 99741 | 99742 | 99743 | 99744 | 99745 | 99746
99747 | 99748 | 99749 | 99750 | 99751 | 99752 | 99753 | 99754 | 99755
99756 | 99757 | 99758 | 99759 | 99760 | 99761 | 99762 | 99763 | 99764
99765 | 99766 | 99767 | 99768 | 99769 | 99770 | 99771 | 99772 | 99773
99774 | 99776 | 99777 | 99778 | 99779 | 99780 | 99781 | 99782 | 99783
99784 | 99785 | 99786 | 99788 | 99789 | 99790 | 99791 | 99801 | 99802
99803 | 99811 | 99812 | 99820 | 99821 | 99824 | 99825 | 99826 | 99827
99829 | 99830 | 99832 | 99833 | 99835 | 99836 | 99840 | 99841 | 99850
99901 | 99903 | 99918 | 99919 | 99921 | 99922 | 99923 | 99925 | 99926
99927 | 99928 | 99929 | 99950