Excel VBA Vlookup using 2 workbooks

[tanyaleblanc]

Hi, I'm new to VBA and don't quite really understand much, I apologize, I'm trying to do a Vlookup from another workbook.

All I want to do is in cell b9 in my current workbook, search for values in another workbook (Finance Extract.xls) from cells d9 to last cell and return a value
Here is the code I used but it's returning a zero (0) in each row in column b

Range("b9:b" & lRow).Formula = "=iferror(VLOOKUP(d9,Finance Extract.xls!d:d,4,FALSE),0)"

What am I doing wrong?

 

[Fluff]

Re: VBA copy data range from worksheets into new workbook

To start a new thread have a look here
https://www.mrexcel.com/posting-to-mrexcel-message-board/#addpost