Get Mileage from Excel Lookup Table

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.

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads