How To Reference an Excel Table Cell by Row Number or Horizontal Header Using Table Notation? -
I want to reference a single cell in the table from the outside table class-bracket sheet- Formula formulation
Something like this: [MyTable [Myfield] 3] or [MyTable [Myfield] 3: 3]
- To reference the third line of the Mifield column, or [MyTable] MyRow]
- To reference the MyRow row (left-row-header) of MyField columns.
Need to work out of the table, i.e. can not use @ or #ThisRow
MATCH, INDEX, OFFSET, etc. Do not seek ways to find. Do not look for VBA methods. Just direct table-notation not to designate named categories manually
Why? Because, Tables :)
Pre-2013 Excel
(Pre-tables were not used in terms of cells by PS, line and column headers? I think that this is probably called "auto-naming", or Something like this.)
Hey, it works well:
= Table 1 [Column 2] 3: 3
So this is progress :)
Content will be just horrible to refer to the row Left-most column
Thx!
Comments
Post a Comment