Vlookup Error

[rockybalboa]

Hi,

I get this error "unable to get vlookup property of worksheetfunction class" when i use the below code. Can somebody please help

recNum5 = 2
Do Until wb5.Sheets("Notes").Range("B" & recNum5) = ""
lookup_value = wb5.Sheets("Notes").Range("B" & recNum5).Value
path = wb4.Sheets("Report1").Range("E3:H2000")
On Error GoTo MyError:
x = WorksheetFunction.VLookup(lookup_value, path, 4, False) ---- Get error here
wb5.Sheets("Notes").Range("P" & recNum5).Value = x
MyError:
If Err.Number = 1004 Then wb5.Sheets("Notes").Range("P" & recNum5).Value = "NR"
recNum5 = recNum5 + 1
Loop

[Bob Phillips]

Can't see why. Can you post your workbook?

[rockybalboa]

It runs for the first lookup value but then gives error for second

[Bob Phillips]

Can't see why. Can you post your workbook?