title: Excel - Table Header not working in formula
body: <p>I have a Table called "Table1" in Sheet1. This table has a first row where all the column names are
  In Sheet2 I am trying to match the headers against another sheet's headers but the formula </p>
  
  <pre><code>=IFERROR(CONCAT("&lt;p&gt;&lt;b&gt;Usage&lt;/b&gt; - ",PROPER(VLOOKUP(A2,Table1,MATCH(C2,Table1[#Headers],0),FALSE)),"&lt;br /&gt;"),"")
  </code></pre>
  
  <p>always returns the error "there is a problem with your formula" whenever I enter the
  <code>[#Headers]</code> part</p>
  
  <p>Is there a setting I am missing or something? I am using latest Excel</p>
  
  <p><a href="https://i.stack.imgur.com/WBIm2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WBIm2.png" alt="enter image description here"></a></p>