title: Table reference for VLOOKUP VBA
body: <p>I'm trying to use a table as reference for my VLOOKUP function using VBA, but it doesn't seem to work. Could somebody help me? My guess is that I'm not calling the tables properly.</p>
  
  <p>Some info:</p>
  
  <ol>
  <li>Table_3 and Table1 are set tables</li>
  <li>Both of them are not fixed (data is added to it)</li>
  </ol>
  
  <pre><code>Range("Table_3[Status]") = Application.WorksheetFunction.VLookup(Range("Table_3[Part_Number]"), Range("Table1[[#All];[Part Number]:[Status]]"), 3, False)
  </code></pre>