How can I reference the cell of
Color
column,from a cell of the same table? Without relying on the absolute row / column numbers of the worksheet if possible.
Like [[Color],-1]
something...
If you want to use the structured reference format, try
=OFFSET([@Colour],-1,0)
You can also do this without using structured references. For example, in row 2 of the table (the first data row), enter
=D1
... if "Colour" is in column D. (Adjust to your situation). The latter will be much faster in large datasets, since Offset() is volatile and will recalculate whenever ANY cell in the workbook changes. That can greatly impact performance.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments