title: Excel - pass an array into a function
body: <p>On one sheet in my file I have a number of arrays defined as named ranges. One another sheet I'd like to use a drop down, or something similar to select the name of one of the named range and have the data/contents of that named range populate a range on the second sheet. Is this possible <strong>WITHOUT</strong> VBA? Is there an array formula that will do this?</p>
  
  <p>One, not entirely elegant, method that I've thought of is using the <code>index</code> function and copy this within a range of cells equivalent in size to the size of the largest named range. Something like:</p>
  
  <pre><code>=INDEX(range_1,ROW(),COLUMN())
  </code></pre>
  
  <p>This requires me to be able to pass the name of a named range into a function though. Is this possible?</p>
  
  <p>Answers to either or both of these questions would be greatly appreciated.</p>
  
  <p>Without that, the only other way I can think to do this is using a brute force, <code>offset</code> look up, which I'd prefer not to do.</p>
  
  <p>Thanks for your help.</p>