Closest distance between 2 zipcodes

1. Closest distance between 2 zipcodes

Hi all

In the sample file I am looking for the best way to find the closest distance to each zipcode in column F.
Column A has the zipcodes of most US cities. Column F are all the zipcodes where we have a warehouse.
If I'm in a zipcode in column A How can I find the closest warehouse in Column F?

FYI:: There are 40000 rows in column A, B, C and 199 rows in column E, F.

Any help is appreciated.
Thank You

2. Re: Closest distance between 2 zipcodes

Never mind ... for some reason it just worked.

3. Re: Closest distance between 2 zipcodes

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

4. Re: Closest distance between 2 zipcodes

Thanks for the update.

Now without some kind of table of distances I don't know how this can be done.

5. Re: Closest distance between 2 zipcodes

https://www.excelforum.com/tips-and-...rivetimes.html

Whether its Google or Bing, they will require an API key which I don't have (there may also be a charge for commercial use)

Hope this is of use.

6. Re: Closest distance between 2 zipcodes

Is it are you looking for?

=LOOKUP(2,1/(ABS(\$F\$2:\$F\$199-A2)=AGGREGATE(15,6,ABS(\$F\$2:\$F\$199-A2),1)),\$F\$2:\$F\$199)

7. Re: Closest distance between 2 zipcodes

Thank you for all your help, that works.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1