Referring diagonal

[Gerard on the internet]

Hi,

I want te reference the cells diagonally.

It want the output from Table 1, and was hoping to do it with Table 2.
But if i put the formula in b3 and copy the formula down, it obviously reference down like table 3.

Is there a formula that can reference diagonally so I can get the output that I want?

Greetings,

Gerard

Table 1

	1	2	3	4
1	-	2	2	1
2	0	-	0	1
3	0	2	-	2
4	1	1	0	-

<tbody>
</tbody>

Table 2

2	1	2	3	4
1	-	2	2	1
2	=2-c2	-	0	1
3	=2-d2	=2-d3	-	2
4	=2-e2	=2-e3	=2-e5	-

<tbody>
</tbody>

Table 3

	1	2	3	4
1	-	2	2	1
2	=2-c2	-	0	1
3	=2-c3		-	2
4	=2-c4			-

<tbody>
</tbody>

 

[Gerard on the internet]

I Got it!
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">=2-INDEX($A$1:$F$10,COLUMN()-COLUMN($A$1)+1,ROW()-ROW($A$1)+1)</code>