title: Find closest locations - 2 lists of latitude and longitude
body: <p>I have two data lists, one of airports, the other of major cities. both the lists have latitude and longitude data.</p>
  
  <p>How can I:</p>
  
  <ol>
  <li>match the airports to their closest city</li>
  <li>find the distance between the airports and their closest city</li>
  </ol>
  
  <p>Both lists are in Excel.</p>