Structured references are also used within formulas outside an Excel table that reference table data. In this example, I will use the XLOOKUP formula to generate a weekly profit in cell E4 based ...

The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

Using the `@` Symbol for Row References. Excel simplifies row references in tables with the `@` symbol, which refers to the current row of a specific column. ... even if the table structure changes.

Structure data using table references to ensure formulas always reference the correct range. Key dynamic formulas include Spill Reference Operators, BYROW, LAMBDA, and Array Boolean Logic.