I have to design a spreadsheet that will return a dollar amount based in large part on the distance between two zip codes.
I know I need a table or array of some sort that will include the distances between these zip codes, but am unsure how to go about looking that up. There are only a dozen or so zip codes to manage, so that's not the biggest part.
Basically, this is a shipping question. I have a number of fixed costs (that I would like to be able to change to test different conditions, but will remain unchanged 99% of the time) and the one variable of distance. I want to be able to plug in three-digit zip codes in a to-from sort of way, and have Excel calculate a dollar amount.
What is the best way to attack this?