Forum Discussion
Solved
Get specific cell data in Excel table
Hi Can someone please tell me the syntax for getting a specific cell value in a table in another sheet (but still the same workbook)? The reason I want to do this is to improve on existing excel wor...
If 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.
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.