=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

ArgumentDescription    Required?Values
locationThe city/state or ZIP code for which you are trying to retrieve or confirm a ZIP code. yesA 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