Excel: Formula Lookup Multiple Distance


Hi All Actually I need a formula which lookup multiple distance from given below table when I select origin and destination it gives me result as per given below result table. [CENTER] Destination Touch Points [/CENTER]

Origin
A B C D E
A 0 50 100 200 400
B 50 0 50 100 200
C 100 50 0 100 100
D 200 100 100 0 50
E 400 200 100 50 0
Required Result through formula If i select origin and destination from below than formula gives result as mentioned in below result table Selection Example
origin Destination
A E
Result By Formula
Area KM
B 50
C 100
D 200
E 400


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 30, 2015.


For more resources for Microsoft Excel