title: Complex VLOOKUP with dynamic sheet name
body: <p>I'm trying to perform a vlookup across multiple sheets in an elegant way, rather than with a vlookup nested in an IF function.</p>
  
  <p>Column A has the account number and Column I has the manager responsible for that account. Each Manager has their own sheet. I was hoping to make vlookup look at a specific manager's sheet, find the account number in Column A, and return the info in Column K. I tried to use INDIRECT to make it do that:</p>
  
  <pre><code>=VLOOKUP($A2,INDIRECT($I2 &amp; "!$A:$P"),11,FALSE)
  </code></pre>
  
  <p>With this code, I keep getting #REF instead of what is in Column K in the manager's sheet. How can I fix this?</p>
  
  <p>Thanks!</p>