decent_boy
Board Regular
- Joined
- Dec 5, 2014
- Messages
- 130
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
Required Result through formula
If i select origin and destination from below than formula gives result as mentioned in below result table
Selection Example
<tbody>
</tbody>
Result By Formula
<tbody>
</tbody>
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.
Destination Touch Points
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 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
Result By Formula
Area | KM |
B | 50 |
C | 100 |
D | 200 |
E | 400 |
<tbody>
</tbody>