title: VBA Insert function VLOOKUP into range,lookup range in other workbook
body: <p>VBA Insert function VLOOKUP into range,lookup range in other workbook. The file containing the lookup table is achieved using <code>filename_AcctMgr = Application.GetOpenFilename(, , "Select Acct Mgr File", "Select")</code>, then opening the file. Let's call this workbook2.</p>
  
  <p>In workbook1 I am adding the VLOOKUP formula into "F2" and looking up Column "A" values in workbook2, columns A:C. I Then copy the formula to all rows of column "F".</p>
  
  <p>I cannot find the syntax required to properly reference the workbook2 range in columns A:C.</p>
  
  <pre><code>ActiveCell.Formula = _
      "=VLOOKUP(activecell.offset(0,-5).address,'ws.name'!A:C,3,FALSE)"
  </code></pre>
  
  <p>Can anyone suggest the proper syntax?</p>