Hello,

I am trying to do a vlookup on current worksheet compared to a range in another file.

I get a "Run Time Error 1004: Unable to get the vlookup property of the worksheet function class".

After some investigation, I found out that if there are some values that dont match up this could be a problem. In my case I will run into that situiation. But for testing purposes, I tried manipulating the data so that this doesnt happen. With no luck.

Here is my code:

 
Dim lastrow as Long

lastrow = Sheets("Master List").Range("A1").End(xlDown).Row

For i = 2 To lastrow
Sheets("Master List").Cells(i, "B").Value = Application.WorksheetFunction.VLookup(Sheets("Master List").Cells(i, "A"), "'T:\Operations+Technology\NOC\Abuse Emails\[Customer Data for Abuse Emails.xls]Report'!$E$4:$G$60000", 2, False)
Next i
Thanks in Advance