Calculation of Differences Between Table

[Batu12]

I have the problem that I want to use the following formula in Table 2, Column B, where I calculate the difference between Table 2, Column A, and Table 1, Column A, using the column reference entered in Table 2, Column C. My approach, which I am using in the picture, is obviously not correct, which is why I need a different approach.

[#2 · Accepted solution]

@Batu12 

Use the INDIRECT function (INDIREKT in German):

=A3-INDIREKT("Tabelle1!A"&C3)

[#3]

@Batu12 Another option is the INDEX function, which I believe is the same in German:

=A3-INDEX(Tabelle1!A:A, C3)

Note: replace the comma with a semi-colon if necessary (depending on your system separator settings).

[#4]

Thank you, it worked!

[#5]

Thank you, I also have the approach!