title: VBA reference to a table in different worksheet
body: <p>I'm trying to use vlookup in VBA.</p>
  
  <ol>
  <li>Filename = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls",    Title:="Please select a file")</li>
  <li>Table1 = Sheet1.Range("A3:A7000") ' SiteID </li>
  <li>Table2 = [Filename]Sheet1.Range("A3:I13")</li>
  <li>Roww = Sheet1.Range("E2").Row</li>
  <li>Coll = Sheet1.Range("E2").Column</li>
  <li>For Each cl In Table1</li>
  <li>Sheet1.Cells(Roww, Coll) = Application.WorksheetFunction.VLookup(cl, Table2, 1, False)</li>
  <li>Roww = Roww +1</li>
  <li>Next cl</li>
  </ol>
  
  <p>My question is how do I define the table located in different worksheet/file on line 3?</p>