Mileage lookup

[rlocher]

Hello,
I'm trying calculate the mileage between two zip codes in my spreadsheet. I guess I can use some kind of vlookup or index function but I need the actual database to seach against. Does anyone know where I could download something like this?

The sheet is large, so calculating by hand using a point to point feature is not an option.

Does anyone have any ideas how to do this?

Thanks!

 

[Trevor G]

Wouldn't the USA postal service have something that you can use.

Here is a link so you can place in 2 zip codes to work out the distance.

http://www.zip-codes.com/distance_calculator.asp

 

[GlennUK]

This is a long discussion about such things, which might have something useful for you:

http://www.blog.methodsinexcel.co.uk/2007/11/12/geocoding-in-excel-using-google-maps-api/

 

[West Man]

To compute distances between zip codes in the US, you will need a database that has the latitude and longitude of the center of each zipcode. There are several available, zip*data from melissadata.com is one. A good approximation without using spherical geometry can be obtained by DistLat = 69.1*(lat2-lat1) and Distlong= 69.1*(long2-long1)*(cos(lat1/57.3)) With the distance then being sqrt(Distlat^2+Distlong^2)