title: How to reference a table ignoring the offset
body: <p><strong>Excel 2013:</strong> I have several single-column tables on a Lookup's sheet which are used to validate various columns around my workbook.</p>
  
  <p>I now need to add a mapping table to map all values from one of these tables (<code>tbl_Validation</code>) to text values on a Settings sheet, so I'm creating a new table on Settings, I setup the table to be 2 columns and in the column formulae for the first:</p>
  
  <pre><code>tbl_Validation[ColumnA]
  </code></pre>
  
  <p>but since tbl_Validation starts in cell B23 where my new table is in B2 I'm getting <code>#VALUE!</code> errors on all rows. Swapping the formulae to <code>INDEX(tbl_Validation,1,1)</code> offsets the data correctly and finds a value but this doesn't work for a column formulae as it'll only select a single value for the whole column.</p>
  
  <p>I've tried various approaches to making this a static reference: <code>tbl_Validation[@ColumnA]</code>, <code>tbl_Validation[[ColumnA]:[ColumnA]]</code> and <code>tbl_Validation[@[ColumnA]:[ColumnA]]</code>, the column doesn't display any data unless I move the whole table to B23 like the source table.</p>