Looking for the closest business (from a list) after inputting zipcode - Is this possible in excel?

[Mikelowrey]

Hello everyone,

Hope this messages finds you well and that you are keeping safe and healthy with this mess going on. I wanted to know if the following is possible to do in excel:

I am trying to see if they're something that when I input a zip code, it will load up the closest business to that zip code. I want to point out that I want the load up to come from a list of business I have.

So, for example, I have a list of 10 businesses

Business 1 Zipcode 00001
Business 2 Zipcode 00002
Business 3 Zipcode 00003
Business 4 Zipcode 00004
Business 5 Zipcode 00005
Business 6 Zipcode 00006
Business 7 Zipcode 00007
Business 8 Zipcode 00008
Business 9 Zipcode 00009
Business 10 Zipcode 00010

And when I input zip code 00015, then it will show me from the list of my businesses, what are the 5 closest ones.

Thank you.

 

[Mikelowrey]

Bump for exposure

 

[Worf]

This one should help:

Calculate Distance between Zip Codes

Dear Smartest Exclers In The World, I have a table with row headers as source zip code and column headers as destination zip codes and I would like to calculate the distance between the two zip codes. Does anyone know how to do that, maybe a User Defined function or something?

www.mrexcel.com