tanyaleblanc
Board Regular
- Joined
- Mar 16, 2019
- Messages
- 145
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?
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?