title: Using Filter Formula with Named Ranges across Sheets
body: <p>I have a dynamic named range that I use and I am looking into using the filter function to reduce that data down on another worksheet using references to criteria on that new worksheet.</p>
  
  <p><code>=FILTER(Loss_Run, ULGTACCT Code = $B$2,"")</code></p>
  
  <p><strong>ULGTACCT</strong> is the column name, </p>
  
  <p><strong>$B$2</strong> will have a number stored as text</p>
  
  <p><strong>Loss_Run</strong> is dynamic named range that is an indirect formula (This could be the cause of my headache)</p>
  
  <p>Online I found If its named I can just reference the name of the range and columns by name but since its a formula will that not work?</p>
  
  <p>Update
  <code>=FILTER('Loss Template'!A:M, 'Loss Template'!A:A = $B$2,"")</code></p>
  
  <p>The formula directly above references a "printout" of the named range that is used in workbook and if I hardcode the value for B2 it works but it does not work if i try to reference B2.</p>
  
  <p><strong>Note:</strong> It would be kinda difficult to mock up <strong>Loss_Run</strong> because of the nature of the range being a complicated indirect().</p>