=ZIPCodeWS

=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 also be 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

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