title: Why doesn't this vlookup formula using the indirect function work?
body: <p>I am using <code>VLOOKUP</code> but rather than hardcode a reference to the file's location I want to use the <code>INDIRECT</code> function to reference the file's location.  However, my attempt at it doesn't work.  What's wrong with this?</p>
  
  <pre><code>=VLOOKUP(A2, INDIRECT(A1)$A$2:$B$1000,2,FALSE)
  </code></pre>
  
  <p>Where cell A1 contains:</p>
  
  <pre><code>C:\Documents and Settings\User\Desktop\[ABC.xlsm]Sheet1
  </code></pre>
  
  <p>I get the error: The formula you typed contains an error.</p>
  
  <p>Am I missing something?</p>