Vlookup seems to be futile and an if statement does not seem to isolate the row I want the value from. International zones are hit and miss, as it seems some locations (such as Vancouver) don't return a zone. To determine the zone, take the first three digits of the receivers ZIP code and refer to the UPS chart. 06-06-2005 Location Minnesota, USA MS-Off Ver 2016 Posts 18 Fedex Zip zone Chart Help I have a Fedex Zip Zone chart and am looking to put in a zip code and have it feed back the appropriate zone based upon the minimum and maximum zip code. Here is the location table cell before the express zone: Express Zone: You can make a GET request to the following URL, after replacing the origPostalCd, destCountr圜d, and destPostalCd parameters with the needed data, then parsing the HTML out. state/province, ZIP/postal code, or simply draw a zone on a map. International on the other hand is a different story, and I don't know of a way to figure this out. A destination zone, or a shipping region, is a geographical area that you ship to. There are workarounds for this though:ĭownload the US rate/zone chart from UPS at the following link, after entering your origin zip: From what I can tell, there is no way to get this information from the APIs themselves. For example, FedEx has 16 zones if a shipper wants to use overnight. Just like you, I have been trying to find the answer for this as well, but it does not see that that information is easily available for us API users. By checking the zip codes, a shipping service can see how far a package needs to.

Printable fedex zone chart by zip code