Lookup distances in table and display them

[hansa]

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:

[TABLE="width: 0"]
<tbody>[TR]
[TD][/TD]
[TD]T[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]63[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 0"]
<tbody>[TR]
[TD]from[/TD]
[TD]to[/TD]
[TD]distance[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]a[/TD]
[TD]FORMULA WHICH LOOKS UP THE DISTANCE BETWEEN T AND A AND DISPLAYS IT HERE
[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]b[/TD]
[TD]FORMULA WHICH LOOKS UP THE DISTANCE BETWEEN T AND B AND DISPLAYS IT HERE
[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]c[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]d[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]e[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]t[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]c[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]d[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]e[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]t[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]a[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]c[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]d[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]e[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]t[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]a[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]b[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]d[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]e[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]t[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]a[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]b[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]c[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]e[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]t[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]a[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]b[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]c[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]d[/TD]
[TD]etc[/TD]
[/TR]
</tbody>[/TABLE]


Thanks for all input and help!

 

[AhoyNC]

You could use INDEX / MATCH.

Copy formula down as needed.

Excel Workbook
	A	B	C	D	E	F	G
1		T	A	B	C	D	E
2	T	0	22	20	51	59	63
3	A	22	0	10	30	36	50
4	B	20	10	0	32	40	45
5	C	51	30	32	0	11	32
6	D	59	36	40	11	0	40
7	E	63	50	45	32	40	0
8
9
10	t	a	22
11	t	b	20
12	t	c	51
13	t	d	59
14	t	e	63
15	a	t	22
16	a	b	10
17	a	c	30
18	a	d	36
19	c	e	32
Sheet