title: Create Drop-Down List Using a Formula (Without Data Validation)
body: <p>One can create a list using the data validation tool. However is it possible to do the same using only a formula (not VBA)? </p>
  
  <p>If I have a named range consisting of several cells (<code>Names</code>), I can reference this in another cell (<code>=Names</code>). However only the contents of the first of these cells will appear, and no drop-down menu presenting all options will be created. </p>
  
  <p>Is there a way to do so without VBA and without data validation?</p>
  
  <p>Thanks</p>