cityzip(
CITY
,
STATE
)
The cityzip( function returns the lowest zip code associated with a city.
Parameters
This function has two parameters:
city – city to look up.
state – state the city is in, expressed as a case-insensitive two-letter code.
Description
This function returns the lowest zip code associated with a city. This is usually (but not always) the central zip code of the city.
cityzip("New York","NY") ☞ 10001
cityzip("Fairbanks","AK") ☞ 99701
cityzip("North Pole","ak") ☞ 99705
If the city doesn’t exist or if an invalid state code is entered, an empty string is returned.
cityzip("South Pole","AK") ☞
cityzip("Fairbanks","Alaska") ☞
Note: The cityzip( function is much slower than the city( function, in fact, it is thousands of times slower. So you may want to avoid using it in repetitive situations like with the formulafill or select statements.
See Also
- city( -- looks up the name of a city associated with a US zip code.
- cityzips( -- returns a list of zip codes associated with a city.
- county( -- returns the name of the county associated with a US zip code.
- mapurl( -- returns a URL to display a map location.
- openmapwindow -- opens a window displaying a map of a location.
- openwebmap -- opens a web browser window displaying a map of a location.
- selectzipdistancetool -- selects records near the current record, based on zip codes.
- state( -- returns the name of the state associated with a US zip code.
- stateabbreviations( -- returns a list of US state abbreviations.
- statelookup( -- converts a two letter abbreviation for a US state into the full state name.
- statename( -- converts a two letter abbreviation for a US state into the full state name.
- uspssecondaryunits( -- returns a list of USPS (United States Postal Service) secondary suffix designation abbreviations.
- uspsstreetsuffixes( -- returns a list of USPS street suffix abbreviations.
- zipdistance( -- calculates the distance between two zip codes.
- ziplatitude( -- returns the latitude of a US zip code.
- ziplongitude( -- returns the longitude of a US zip code.
History
| 10.0 | New | New in this version. |