You can consider these zones to lower the costs of shipping. Understanding shipping zones clearly will enable you to achieve the fulfillment of your e-commerce business. It is because zones will affect your costs of fulfillment and the time of delivery. While initiating the order fulfillment for your e-commerce business, you need to keep in mind different shipping zones. Across the US, there are seven different FedEx/UPS shipping zones (in numerical order from 2-8), and these carriers operate by including them. Zone specifications closely relate to the distance covered. Shipping contracts are drawn based on weight and the zones to which packages are shipped. THEN you can do an easy INDEX/MATCH/IF to find which ZONE matches both the Origin Zip and Destination Zip.Global shipping carriers like FedEx and UPS have specific shipping zones. index/match to find the zones for 19700-19899 and the same for 9100-91899. So copy all the zip codes to a new table. Maybe go to Free ZIP code map, zip code lookup, and shipping comparisons and download their zip code database. It might be easier to make a new table where you just include all zip codes. That's kind of confusing and is going to make for a formula I really don't want to try to put together.

First, the table has some destination zips like '#' and some like '#-#' - so you'd have to have a little IF function to say if column B is '#' then look it up that way, but if it's '#-#' then look up in between those two numbers.

What would be the best way to go about doing this? At this point it is something we are looking to do ONLY for ground shipping, but in theory, would be wanting to do for express as well (possibly have each service on a different tab?)įirst I would ask why the only options for Origin Zip are 91000-9180-19899?īut anyway if what you want to do is find the ZONE that matches the first three digits in the Origin Zip AND the first three digits in the Destination Zip, it's going to be a bit of a process.

Obviously, i realize that 708 charts at 211 (+/-) lines each chart, is A LOT of data. On the spreadsheet, I have added what two of the 708 different possible zone charts would be (tab 91000-91899) and samples of what we would want the final calculations to look like (tab zone calc) Everything is based on the first 3 digits of a the Origin zip code and the first 3 digits of the destination zip codeĪ link to the spreadsheet can be found at What I want to create is the ability to type in two random zip codes in excel, and have there be a calculation done through to tell me what zone the shipment would be considered. UPS and Fedex both have zone calculators available where I can type in my starting zip code, and the website will tell us based off of that initial zip what shipping 'zone' other parts of the country are in.

Fedex zone charts