title: named range using an if statement with array formula for dependent dropdown
body: <p>Stumped after looking for a bit...</p>
  
  <p>I have a spreadsheet with items like so:</p>
  
  <pre><code>   A              B                  C
  +------+----------------------+--------------+
  | Code |         Desc         |     Type     | 1
  +------+----------------------+--------------+
  |    1 | Main item            | Activity     | 2
  |  1.1 | Sub item             | Sub-activity | 3
  |  1.2 | Another sub item     | Sub-activity | 4
  |    2 | Another main item    | Activity     | 5
  |  2.1 | Yet another sub item | Sub-activity | 6
  +------+----------------------+--------------+
  </code></pre>
  
  <p>I want to create a dropdown based on Activity. I can do this in a typical cell (with ctrl + shift + enter for array formula):</p>
  
  <pre><code>={if(c2:c6="Activity",a2:a6,"")}
  </code></pre>
  
  <p>But I can't figure out how to put that formula into a named range properly. When I hit ctrl + shift + enter, no braces appear. When it's without braces, it doesn't seem to work, either (it shows the value as {...}).</p>
  
  <p>Is there a way to make this work?</p>
  
  <p>Thanks in advance</p>