title: vba Vlookup across workbooks
body: <p>I seem to have an error in the below syntax line.  I believe the issue lies with range parameter of workbook book1. I cannot figure out why. Basically I'm tring to vlookup across 2 workbooks.</p>
  
  <p>The code is invoked from workbook - book1. Just before this line of code workbook - book2 is activated. Both the workbooks are  open. I captured the error code 2015 by replacing the left side with a variant variable.</p>
  
  <p>I appreciate any help with this vlookup issue. Thanks.</p>
  
  <pre><code> Cells(j, c + 2).value = [VLookup(workbooks(book2).sheets(5).range(Cells(j, c + 1)), workbooks(book1).sheets(4).range(cells(row1+2,1),cells(row2,col1)), 3, false)]
  </code></pre>