title: Use Cell Value as reference for VLOOKUP table array?
body: <p>I would like to be able to allow a user to change the file being used as a reference in a VLOOKUP. All the files being used will have the same array, just different files paths.</p>
  
  <p>This is how i think it should operate. </p>
  
  <ol>
  <li>Click macro button that opens file browser.</li>
  <li>Allow user to choose file.</li>
  <li>Paste file path in cell (A1)</li>
  <li>Convert path to include array.</li>
  <li>In VLOOKUP formula, reference the cell A1 as the 'table array'.</li>
  </ol>
  
  <p>I am already able to complete up to step 3. Any idea on how to add the defined array and reference the cell in a VLOOKUP?</p>