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 ...

Use Excel’s auto-generation: Let Excel auto-generate structured reference syntax by selecting ranges directly in your formulas. This minimizes manual input and reduces errors.

Now, let’s return to the function shown in Figure A, =UNIQUE (TableSales [Personnel]). In terms of structured referencing, that reference is short. But the reference =H3# is much shorter.