SOLVED

# Calculation of Differences Between Table

Copper Contributor

# Calculation of Differences Between Table

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.

4 Replies
best response confirmed by Batu12 (Copper Contributor)
Solution

# Re: Calculation of Differences Between Table

Use the INDIRECT function (INDIREKT in German):

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

# Re: Calculation of Differences Between Table

@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).

# Re: Calculation of Differences Between Table

Thank you, it worked!

# Re: Calculation of Differences Between Table

Thank you, I also have the approach!
1 best response

Accepted Solutions
best response confirmed by Batu12 (Copper Contributor)
Solution

# Re: Calculation of Differences Between Table

Use the INDIRECT function (INDIREKT in German):

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