title: Excel Filter formula with named ranges
body: <p>I'm looking to use the filter formula on a named range but there hasn't been a resource that has explicitly showed how to reference columns within a named range. I might add that the whole named range includes the headers due to the nature of the original data. It has 13 Columns.</p>
  
  <p>The columns I want with their position is: "Injury Date" (6) and "INCURRED" (8)</p>
  
  <pre><code>=filter(Loss_Run,[Insert Chosen Columns Here])
  </code></pre>
  
  <p>This is the syntax I am trying to use but I cannot get it to work. I am not sure how to tell it to use the columns I want. Do I use the name of the columns or the number either way is fine to me.</p>
  
  <p>I am trying to filter by a specfic value of a row and that is where the main hiccup is.</p>
  
  <p>I got</p>
  
  <pre><code>=FILTER(Loss_Run,(Loss_Columns="Injury Date")+(Loss_Columns="INCURRED"))
  </code></pre>
  
  <p>to work.
  BUT,</p>
  
  <p>I want to first filter the first column, "ULGTACCT Code" (1) by a value (that is in cell A2 for our purposes). It is not allowing me to filter by the first column with or with out the other columns</p>
  
  <p>What I have found says:</p>
  
  <pre><code>=FILTER(Loss_Run,(ULGTACCT Code=$A$2),"")
  </code></pre>
  
  <p>should work but I get <code>#Name?</code> error.</p>