=CityNameWS returns the city name and state or country abbreviation corresponding to the given ZIP or postal code. The country must be specified.
Syntax
=CityNameWS(ZIPcode)
Arguments
| Argument | Description | Required? | Values |
| location | The ZIP/Postal Code or SPLC for which you are trying to retrieve a city name. | yes | A ZIP/Postal Code or SPLC Examples: 80903 191690000 H3B 1A2 |
| countries | The country or countries where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | A two-letter country code |
| region | The region of the world where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | Region Codes are NA (North America), EU (Europe), AS (Asia), AF (Africa), SA (South America), OC (Oceania), MX (Mexico), ME (Middle East), and WW (Worldwide). |