Forum Discussion
Solved
Strukturierter Verweis mit absolutem Spaltenbezug
Hallo Ich verwende bei einem Index mit Verweis die Spalte A als Zeilenbezug und die Kopfzeile 1 als Spaltenbezug. Wenn ich nun die Formel von Spalte B nach Spalte C kopiere, soll der Vergleich auf S...
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.
Thy, Riny, perfect solution!