title: nested indirect function in excel 2010
body: <p>in our office we have a shared excel, where everyone has their own page to work on.(Shared)
  also we have a form from which is fed by the shared file. (FORM)</p>
  
  <p>in the FORM, i had created the formulas with indirect so the user can simply write their name in Cell A5, and write the row number from his shared page (Cell A12), and the form would update with those data from shared. </p>
  
  <p>however, we have come to the realisation that often we will need to change the Shared excel's name. to shared1 or 2 or so on.</p>
  
  <p>i tried adding a second nested indirect where the name of the shard excel would be added in cell J2, instead of me going into all the formulas and changing the name of the excel manually. (got a ref error)</p>
  
  <p>here is the formula that currently works, without the second indirect.
  i am trying to make it with two indirects so in J2 will be added the name of the excel which will change often:</p>
  
  <pre><code>=VLOOKUP(A12,INDIRECT("'[_sharedpo1.xlsm]"&amp;$A$5&amp;"'!$A:$U"),3,FALSE)
  </code></pre>
  
  <p>logic: lookup (row index, in page of sharedpo1 User A5, from 3rd column, exactmatch)</p>
  
  <p><strong>_sharedpo1.xlsm</strong>      is the excel's name, which previously was _sharedpo.xlsm       and god knows when it might be _sharedpo2.xlsm - and must be indirected.</p>