Spreadsheet: 157394d1337714633-vlookup-based-on-a-column-using-a-number-range-337
Sheet: 337

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 337-01 to 337-99. To determine zone
take the first three digits of the receiver's ZIP Code and refer to the chart below:
 |  |  |  |  |  |  |  | 009 | <===== Zip code to lookup
ZONES
Dest. ZIP | Ground | 3 Day Select | 2nd Day Air | 2nd Day Air A.M. | Next Day Air Saver | Next Day Air
004-005 | 006 | 306 | 206 | 246 | 136 | 106
006-007 | 045 | - | 225 | - | - | 125
9 | 045 | - | 225 | - | - | 125
010-046 | 006 | 306 | 206 | 246 | 136 | 106
047 | 007 | 307 | 207 | 247 | 137 | 107
048-069 | 006 | 306 | 206 | 246 | 136 | 106
070-089 | 005 | 305 | 205 | 245 | 135 | 105 |  | #N/A | <====== Your formula and I want the data in the 2nd Day Air to show as result.
100-104 | 005 | 305 | 205 | 245 | 135 | 105
105-109 | 006 | 306 | 206 | 246 | 136 | 106
110-113 | 005 | 305 | 205 | 245 | 135 | 105
114-115 | 006 | 306 | 206 | 246 | 136 | 106
116 | 005 | 305 | 205 | 245 | 135 | 105
117-146 | 006 | 306 | 206 | 246 | 136 | 106 |  |  | 225
147 | 005 | 305 | 205 | 245 | 135 | 105
148-149 | 006 | 306 | 206 | 246 | 136 | 106
150-187 | 005 | 305 | 205 | 245 | 135 | 105
188 | 006 | 306 | 206 | 246 | 136 | 106
189-268 | 005 | 305 | 205 | 245 | 135 | 105
270-277 | 004 | 304 | 204 | 244 | 134 | 104
278-279 | 005 | 305 | 205 | 245 | 135 | 105
280-314 | 004 | 304 | 204 | 244 | 134 | 104
315-317 | 003 | 303 | 203 | 243 | 133 | 103
318-319 | 004 | 304 | 204 | 244 | 134 | 104
320-325 | 003 | 303 | 203 | 243 | 133 | 103
326-329 | 002 | 302 | 202 | 242 | 132 | 102
330-333 | 003 | 303 | 203 | 243 | 133 | 103
334-339 | 002 | 302 | 202 | 242 | 132 | 102
341 | 002 | 302 | 202 | 242 | 132 | 102
342-349 | 002 | 302 | 202 | 242 | 132 | 102
350-362 | 004 | 304 | 204 | 244 | 134 | 104
363 | 003 | 303 | 203 | 243 | 133 | 103
364-369 | 004 | 304 | 204 | 244 | 134 | 104
370-372 | 005 | 305 | 205 | 245 | 135 | 105
373-374 | 004 | 304 | 204 | 244 | 134 | 104
375 | 005 | 305 | 205 | 245 | 135 | 105
376-379 | 004 | 304 | 204 | 244 | 134 | 104
380-383 | 005 | 305 | 205 | 245 | 135 | 105
384-385 | 004 | 304 | 204 | 244 | 134 | 104
386-387 | 005 | 305 | 205 | 245 | 135 | 105
388-397 | 004 | 304 | 204 | 244 | 134 | 104
398 | 003 | 303 | 203 | 243 | 133 | 103
399 | 004 | 304 | 204 | 244 | 134 | 104
400-483 | 005 | 305 | 205 | 245 | 135 | 105
484-489 | 006 | 306 | 206 | 246 | 136 | 106
490-492 | 005 | 305 | 205 | 245 | 135 | 105
493-525 | 006 | 306 | 206 | 246 | 136 | 106
526 | 005 | 305 | 205 | 245 | 135 | 105
527-564 | 006 | 306 | 206 | 246 | 136 | 106
565-567 | 007 | 307 | 207 | 247 | 137 | 107
570-573 | 006 | 306 | 206 | 246 | 136 | 106
574-588 | 007 | 307 | 207 | 247 | 137 | 107
590-592 | 008 | 308 | 208 | 248 | 138 | 108
593 | 007 | 307 | 207 | 247 | 137 | 107
594-599 | 008 | 308 | 208 | 248 | 138 | 108
600-601 | 005 | 305 | 205 | 245 | 135 | 105
602 | 006 | 306 | 206 | 246 | 136 | 106
603-609 | 005 | 305 | 205 | 245 | 135 | 105
610-612 | 006 | 306 | 206 | 246 | 136 | 106
613-634 | 005 | 305 | 205 | 245 | 135 | 105
635 | 006 | 306 | 206 | 246 | 136 | 106
636-639 | 005 | 305 | 205 | 245 | 135 | 105
640-646 | 006 | 306 | 206 | 246 | 136 | 106
647-648 | 005 | 305 | 205 | 245 | 135 | 105
649 | 006 | 306 | 206 | 246 | 136 | 106
650-659 | 005 | 305 | 205 | 245 | 135 | 105
660-666 | 006 | 306 | 206 | 246 | 136 | 106
667 | 005 | 305 | 205 | 245 | 135 | 105
668-672 | 006 | 306 | 206 | 246 | 136 | 106
673 | 005 | 305 | 205 | 245 | 135 | 105
674-691 | 006 | 306 | 206 | 246 | 136 | 106
692-693 | 007 | 307 | 207 | 247 | 137 | 107
700-705 | 004 | 304 | 204 | 244 | 134 | 104
706 | 005 | 305 | 205 | 245 | 135 | 105
707-709 | 004 | 304 | 204 | 244 | 134 | 104
710-712 | 005 | 305 | 205 | 245 | 135 | 105
713-714 | 004 | 304 | 204 | 244 | 134 | 104
716-729 | 005 | 305 | 205 | 245 | 135 | 105
730-732 | 006 | 306 | 206 | 246 | 136 | 106
733-734 | 005 | 305 | 205 | 245 | 135 | 105
735-739 | 006 | 306 | 206 | 246 | 136 | 106
740-745 | 005 | 305 | 205 | 245 | 135 | 105
746 | 006 | 306 | 206 | 246 | 136 | 106
747-768 | 005 | 305 | 205 | 245 | 135 | 105
769 | 006 | 306 | 206 | 246 | 136 | 106
770-787 | 005 | 305 | 205 | 245 | 135 | 105
788 | 006 | 306 | 206 | 246 | 136 | 106
789 | 005 | 305 | 205 | 245 | 135 | 105
790-797 | 006 | 306 | 206 | 246 | 136 | 106
798-820 | 007 | 307 | 207 | 247 | 137 | 107
821 | 008 | 308 | 208 | 248 | 138 | 108
822-830 | 007 | 307 | 207 | 247 | 137 | 107
831-844 | 008 | 308 | 208 | 248 | 138 | 108
845 | 007 | 307 | 207 | 247 | 137 | 107
846-847 | 008 | 308 | 208 | 248 | 138 | 108
850-853 | 007 | 307 | 207 | 247 | 137 | 107
854 | 008 | 308 | 208 | 248 | 138 | 108
855-863 | 007 | 307 | 207 | 247 | 137 | 107
864 | 008 | 308 | 208 | 248 | 138 | 108
865-880 | 007 | 307 | 207 | 247 | 137 | 107
881-882 | 006 | 306 | 206 | 246 | 136 | 106
883 | 007 | 307 | 207 | 247 | 137 | 107
884 | 006 | 306 | 206 | 246 | 136 | 106
885 | 007 | 307 | 207 | 247 | 137 | 107
889-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