Feb 01 2022 10:07 AM
Feb 01 2022 11:53 AM - edited Feb 01 2022 11:54 AM
If that's another table the reference will be the same as for the cell in range, e.g. = Sheet2!B22.
It's always better to lookup or use INDEX() but it very depends on how your data is structured.
Feb 01 2022 08:26 PM
Feb 02 2022 01:25 AM
SolutionIf you enter formula =Table[@[field]] in some cell of row 15 in Sheet1 , and Table is in Sheet2, it returns field value from row 15 in Sheet2 if it is within the table, otherwise error.
Alternatively you may use something like
=INDEX(Table1[field], ROW() -ROW(title) )
to use relative position within the table.
Feb 02 2022 01:25 AM
SolutionIf you enter formula =Table[@[field]] in some cell of row 15 in Sheet1 , and Table is in Sheet2, it returns field value from row 15 in Sheet2 if it is within the table, otherwise error.
Alternatively you may use something like
=INDEX(Table1[field], ROW() -ROW(title) )
to use relative position within the table.