VBA: IfError and VLookup

[FunsizedNerd]

Trying to look up a value within a range using vlookup. If the value doesn't exist, then I want it to return either 0, nothing etc
Then I can use an if statement on the variable, so that if it IS nothing then I can do something (add the missing value to the end of a range)

test = Application.WorksheetFunction.IfError(Application.WorksheetFunction.VLookup(cl.Value, checkvalues, 1, 0), 0)

It works fine if the value can be found within the range, but the second I come across one that isn't there, I get
Run-time error '1004': Unable to get the Vlookup property of the WorksheetFunction class

I know you can't use VLookup, that's why I have the IfError

 

[Fluff]

How about

Dim Test As Variant
Test = Application.vlookup(cl.Value, checkValues, 1, 0)
If IsError(Test) Then
   'do somthing
End If

 

[FunsizedNerd]

@Fluff No luck, still same error, though no idea why

 

[Fluff]

Are you sure that you have used the code I suggested?
Because that wont give an "Unable to get the Vlookup property of the WorksheetFunction class" error.
Make sure that you do are not using "WorksheetFunction"

 

[FunsizedNerd]

@Fluff Ahh, that works perfectly, didn't notice the missing WorksheetFunction
Thanks
Any idea why that works, but WorksheetFunction doesn't?

 

[Fluff]

If you use Application.Vlookup then the variable test will contain an error number which can be tested for.
If you use the WorksheetFunction then it crashes if it cannot find a match