title: How To Reference an Excel Table Cell by Row Number or Horizontal Header Using Table Notation?
body: <p>I'd like to reference a single cell in a table, from <em>outside</em> the table, using square-bracket sheet-formula notation. </p>
  
  <p>Something like:
  [MyTable[MyField] 3]
  or
  [MyTable[MyField] 3:3]</p>
  
  <p>-to reference the 3rd row of the MyField column, or:</p>
  
  <p>[MyTable[MyField] MyRow]</p>
  
  <p>-to reference the MyRow row (leftmost row-header) of the MyField column. </p>
  
  <p>Needs to work from outside the table, ie can't use @ or #ThisRow. </p>
  
  <p>Not looking for methods involving MATCH, INDEX, OFFSET, etc. Not looking for VBA methods. Just straightforward table-notation. Not looking for manually creating named ranges.</p>
  
  <p>Why? Because, Tables  :)</p>
  
  <p>Pre-2013 Excel.</p>
  
  <p>(PS, didn't there used to be a way (pre-Tables) to reference cells by row and column headers? I think it was maybe called "auto-naming", or something like that.)</p>