Forum Discussion
Solved
Refer to same Column in Table
I have a spreadsheet A where I entered a named table (table1). Now i have a Formula on spreadsheet B which refers to column of Name table1[uvw]. I want to copy the formula a column to the right but ...
ClaudioGiovanoli Use this in stead:
=Table1[[uvw]:[uvw]]
Absolute Structured References in Excel Tables | Excel Campus
tip
if you formalized the whole column, it might have particular name like: Table2[Column1]. f4 will not work out there.
if you formalized the whole column, it might have particular name like: Table2[Column1]. f4 will not work out there.