Forum Discussion
Structured References Not at “This Row”
Is there a way to use structured references to refer to cells that exist outside of the row that the formula I am typing is in?
well yes and no. You can still use INDEX and OFFSET but that sort of takes away the from the structured reference thing:
=OFFSET([@ID], -1, 0)
=INDEX([ID], 4,1)
another thing you can do is reference the column up to this row:
=ROWS( [[#Headers],[ID]]:[@ID] )
=OFFSET([@ID], -1, 0)
=INDEX([ID], 4,1)
another thing you can do is reference the column up to this row:
=ROWS( [[#Headers],[ID]]:[@ID] )