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: OfficeTutes.com

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