title: [@[COLUMN_NAME]] reference in Excel
body: <p>I've inherited a MS Excel workbook from a stalled project. I now need to reverse engineer and experiment to see how it all works. How does the formula know which value to fetch? I was expecting to see a cell reference.</p>
  
  <pre><code>=CONCATENATE([@[HAL '#]],"-",[@[Data Dimension]],"-",A3)
  </code></pre>
  
  <ul>
  <li>"HAL #" is a column header in worksheet (not the worksheet the formula is in) </li>
  <li>"Data Dimension" is a column in the same sheet as the formula</li>
  <li>"A3" is a column in the same sheet as the formula its a 3 digit number</li>
  </ul>
  
  <p><strong>Context</strong>
  This will eventually feed a Tableau work flow...that's all I know...for now</p>
  
  <p><strong>What I've tried</strong></p>
  
  <ul>
  <li>I've changed values in the HAL and Data Dimension column. Sometimes
  the value in the last parameter fetches the row of that column,
  sometimes not...</li>
  <li>There are no macro in this workbook</li>
  <li>THere are no named range that resemble HAL (and Data Dimension)</li>
  </ul>