title: VLookup with multiple “col_index_num”s
body: <p>I'm stuck on the correct syntax for writing a VLookup in VBA where you want to return multiple columns.</p>
  
  <p>Usually the you use {2,3,4,5} however VBA does not accept this as valid. </p>
  
  <pre><code>Set Sheet1 = ActiveWorkbook.Sheets(1)
  Set Sheet2 = ActiveWorkbook.Sheets(2)
  Set Sheet3 = ActiveWorkbook.Sheets(2)
  
  result = Application.WorksheetFunction.VLookup(Sheet2.Range("A2"), Sheet1.Range("AA9:AF20"), {2,3,5,6,7,8,9}, False)
  </code></pre>
  
  <p>I have done numerous searches on the web for this solution, but there isn't a clear answer to how to properly syntax  <code>{2,3,5,6,7,8,9}</code></p>