VBA

Hi Hiren

Thanks for your question

You can indeed code vlookups. They are included in the application object's worksheet functions collection. You type the keyword followed by the function's arguments

For example

application.worksheetfunction.vlookup("A1","C1:H5",3,False)