Forum Discussion
Batu12
Dec 18, 2023Copper 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...
- Dec 18, 2023
djclements
Dec 18, 2023Silver Contributor
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).
Batu12
Dec 18, 2023Copper Contributor
Thank you, I also have the approach!