- How to find the closest zip code to a target location, in Microsoft Excel. Try a free, 30-day no risk trial.