Retrieve the Distance between Any Two Cities from Distance Table
Range A1:G7 contains a table of the respective distances (miles) between 6 cities.
We want to use that table to retrieve the distance between each origin and destination pair shown in cells A10:B13.
Use the INDEX and MATCH functions as shown in the following formula:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1