(U.S. only)
=ZIPCodeWS returns the ZIP code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX). The function returns a -1 if the place name you entered is invalid. If you enter a city with multiple ZIP codes, PC*MILER will choose the ZIP code designated as the most centralized location in that city.
The ZIPCodeWS function can be also used to test if a given number is a valid ZIP code.
Syntax
=ZIPCodeWS(location)
Arguments
| Argument | Description | Required? | Values |
| location | The city/state or ZIP code for which you are trying to retrieve or confirm a ZIP code. | yes | A city and state (with or without the comma). Enter a ZIP code if you want to verify that the ZIP code is valid. Examples: Miami FL Boston MA Topeka, KS 13090 |