Forum Discussion
Strukturierter Verweis mit absolutem Spaltenbezug
Gallus When you are working with structured table references you can't just copy and past or drag formulae across if you intend them to be absolute. More about that in the attached link.
https://exceloffthegrid.com/excel-tables-absolute-references/
The attached file took your data and now has working formulae. When you open it, all should be in German, automatically.
Gallus When you are working with structured table references you can't just copy and past or drag formulae across if you intend them to be absolute. More about that in the attached link.
https://exceloffthegrid.com/excel-tables-absolute-references/
The attached file took your data and now has working formulae. When you open it, all should be in German, automatically.
I have added tow further solutions to your workbook. I leave it to your judgement whether you would recommend either. The first continues to use a Table but replaces the first column Structured References by a defined Name (which, in turn, refers to the structured reference). This make the reference absolute.
The second uses tables only for data input an uses dynamic arrays for the formula.
"Table"
= INDEX(Table2[VA2021], MATCH(@Formel,Name,0))
"Dynamic Array"
= INDEX(VA, XMATCH(Formel,Name), {1,2})- Wonderful, even a more smart solution. Thx you very much!
PeterBartholomew1 I approve! :)))
