Lookup distances in table and display them

hansa

New Member
Joined
Oct 14, 2017
Messages
1
This should be a straight-forward question, but I haven't done Excel in a while, so maybe there is a kind soul here that can point me in the right direction ;)

I have a table that displays distances between Points T, A, B, C, D, E, which looks like this:

TABCDE
T02220515963
A22010303650
B20100324045
C51303201132
D59364011040
E63504532400

<tbody>
</tbody>

I would now like to use a formula to display all these distances like this:

fromtodistance
taFORMULA WHICH LOOKS UP THE DISTANCE BETWEEN T AND A AND DISPLAYS IT HERE
tbFORMULA WHICH LOOKS UP THE DISTANCE BETWEEN T AND B AND DISPLAYS IT HERE
tcetc
tdetc
teetc
atetc
abetc
acetc
adetc
aeetc
btetc
baetc
bcetc
bdetc
beetc
ctetc
caetc
cbetc
cdetc
ceetc
dtetc
daetc
dbetc
dcetc
deetc
etetc
eaetc
ebetc
ecetc
edetc

<tbody>
</tbody>


Thanks for all input and help!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,515
Office Version
365
Platform
Windows
You could use INDEX / MATCH.

Copy formula down as needed.
Excel Workbook
ABCDEFG
1TABCDE
2T02220515963
3A22010303650
4B20100324045
5C51303201132
6D59364011040
7E63504532400
8
9
10ta
22
11tb20
12tc51
13td59
14te63
15at22
16ab10
17ac30
18ad36
19ce32
Sheet
 

Watch MrExcel Video

Forum statistics

Threads
1,098,989
Messages
5,465,849
Members
406,450
Latest member
gunner12

This Week's Hot Topics

Top