Unable to get the Vlookup property of the worksheetfunction class

[arnelgp]

i think Vlookup returns a Range not a string.
so you need to test if the result Is Nothing.