Hi, question about using vlookups in vba. I know that accessing many Excel functions requires code such as

Code:
Application.WorksheetFunction.Count()
but when using vlookups it's

Code:
Application.VLookup()
as opposed to

Code:
Application.WorksheetFunction.VLookup()
When using the above code, with proper arguments within the lookup function, I get the following error:

Code:
Run-time error '1004':
Unable to get the VLookup property of the WorksheetFunction class
So VLookups aren't part of this class, whereas functions like Count, CountA, etc are? If they are, what mistake have I made? If not, how can I tell which functions aren't part of this class?

Thanks in advance