Forum Discussion
Solved
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.
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).
- Thank you, I also have the approach!
- Thank you, it worked!
