=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

ArgumentDescriptionRequired?Values
ZIPCodeThe ZIP/Postal Code or SPLC for which you are trying to retrieve a city name.yesA ZIP/Postal Code or SPLC

Examples:
80903
191690000
H3B 1A2