=CityNameWS returns the city name and state or country abbreviation corresponding to the given postal code. Canadian Postal Codes, SPLC, and 3-digit U.S. ZIP codes representing centralized areas are valid with this function. (Applicable licensing applies for certain types of data.)
=CityNameWS returns -1 if the postal code you entered is invalid.
Syntax
=CityNameWS(ZIPcode)
Arguments
| Argument | Description | Required? | Values |
| ZIPCode | 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 |
