How to do vlookup Using VBA?

If you want to use any Excel function in VBA all that you need to is to use "worksheetfunction" statement follwed with the name of the function. However please note that not all Excel default functions are available in VBA.  But you can always check which all functions are available (as soon as you put a "." after worksheetfunction a list of available functions would appear)

The answer to the question how you go about using vlookup function or any other function for that matter in VBA would be the "worksheetfunction" statement.

Attached herewith is an VBA vLookup example that you can refer to.

Hope this helps.