I have two accounting tables.

The first one ("Table1") has columns for the months. The headers are "Jan-26", "Feb-26", etc.

Then there are the expenses per item (inserted from the expense record tables).

And a totals row.

The second table ("Table2") also has 12 columns for the months, with the same headers as the first: "Jan-26", "Feb-26", etc.

I need to insert, in the second table ("Table2"), a value in row 2 that is the total of the first table ("Table1") [#Totals] of the column that has the same header.

I tried combining several formulas (INDIRECT, CONCATENATE, etc.), but I don't know enough about Excel to get something that works.

Could someone help me?

Thank you very much.