Using excel to map or match addresses by zip code or miles

[DianaBanana]

I have different addresses on different worksheets within the same workbook. Each worksheet represents a different hotel flagship (so comfort inn, holiday inn, ect). I'd like a way to match different hotels that are located near each other within excel. The only logical thing I can think of is to match cities and zip codes. Is there another way to see who is located near each other by miles within excel? What formulas would you use to start matching up locations? Thank you.

 

[Rijnsent]

Hi Diana,

depending how complex you want to make it I guess the Google Maps API might be your best friend, maybe like this:
Google Maps distance function for Excel | oCoCarbon
or like this:
Distance between postcodes (Using Excel and Google Maps API) - Glen Gilchrist

Cheers,

Koen