=CityNameWS returns the city name and state or country abbreviation corresponding to the given postal code. U.S. ZIP codes, Canadian Postal Codes, and SPLCs 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 |