However, some people are less familiar with a special type of reference that comes with these tables: structured references.

Using the IF function with absolute references forces the cell reference inside a formula to remain constant. Open an Excel worksheet and add data to two columns, where the first column has one ...

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.