=AddressToLatLongWS takes an address and returns the latitude/longitude.
Syntax
=AddressToLatLongWS (Address)
Arguments
Argument | Description | Required? | Values |
address | An address for which you want to retrieve a latitude/longitude. | yes | A ZIP/Postal Code or city/state, followed by a street address. Separate the two with a comma or a semicolon. Examples: 08540, 20 Nassau Street Liverpool NY,305 Oswego Street Industriestraße 7, 67346 Speyer |
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). |