Forum Discussion

Batu12's avatar
Batu12
Copper Contributor
Dec 18, 2023

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...
  • HansVogelaar's avatar
    Dec 18, 2023

    Batu12 

    Use the INDIRECT function (INDIREKT in German):

     

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

Resources