=ZIPCodeWS returns the ZIP or postal code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX). The ZIPCodeWS function can be also used to test if a given number is a valid ZIP code. If a city has multiple ZIP codes, the most central code is usually returned.
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 |