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.
Thanks Sergei, but I was hoping to address it the way you address tables if that is possible. I mean something in the line of = TABLE_NAME(…….. if that makes sense.
The reason for it is that I want to make the changes so that if I insert, or remove, a row it will automatically update and insert or remove a row the same way.
The reason for it is that I want to make the changes so that if I insert, or remove, a row it will automatically update and insert or remove a row the same way.
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.