Zip code to Zip code for total Mileage

[JASONW10]

I am trying to find away to have a spread sheet to where I can type in my zip code then a customers zip code that will populate another cell with the total mileage between the two. Does anyone know away to do this.
thanks,

 

[jeffreybrown]

Sounds like you want a Vlookup...

http://www.contextures.com/xlfunctions02.html

 

[Gerald Higgins]

Yes, but Jeff's suggestion implies that you already have some kind of database listing the distances, and I'm guessing that maybe you don't ?

 

[JD_GFI]

You could try looking at http://zips.sourceforge.net/ if it's just US zip codes you're using.

 

[JASONW10]

Your Correct I do not have any data for the distance between customers. All I have is a list of Zip codes and our Zip code. to make it simple I have column A is the customer zip codes and Cell B1 is my zip code. I need column C to populate the distance between each

 

[Gerald Higgins]

I'm not completely familiar with the zip code system - are they based on geographical co-ordinates, or are they more random ?

If they are based on co-ordinates, you might be able to work out the distances.
If they are not, then Excel is never going to work out the distances for you, but it might be able to look them up from some table that you supply.