title: INDEX(INDIRECT("DefinedName"),1)=#REF while INDEX(DefinedName,1) works
body: <p>In an excel workbook, I'm referencing a defined name from another tab (to get dependent data validation). Accessing the defined name directly works, but accessing it through <code>INDIRECT</code> doesn't. </p>
  
  <p><code>=INDEX(DefinedName,1)</code> returns the first value of the range</p>
  
  <p><code>=INDEX(INDIRECT("DefinedName"),1)</code> returns #REF!</p>
  
  <p>I have also tried</p>
  
  <p><code>=INDEX(INDIRECT("SheetName!DefinedName"),1)</code>, but it also returns #REF!</p>
  
  <p>Sample file can be downloaded <a href="https://docs.google.com/open?id=0B04VM-tmdCnIekJZTEthRXVyVzA" rel="nofollow">here</a>.</p>