About this tutorial:
Video duration: 4:5
Visit this page to download the sample file.
Set up a mileage table in Excel, and then use the INDEX and MATCH functions to find distance between two selected cities.
A drop down list of cities makes it easy to select a starting city and destination city.
Conditional formatting highlights the selected mileage in lookup table, so you can verify the result.