Question: In range J 2 0 :J 2 9 , calculate the distance between the cities ( paired in rows ) in ranges F 2 0
In range J:J calculate the distance between the cities paired in rows in ranges F:F and G:G
Place your calculation in cell J for the distance between the first city cell H and the second city cell I
Use the INDEX function.
Reference your row and column position calculations from the last two tasks as well as the table of distances range C:O
Reuse your formula to complete range J:J of the table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
