August 24, 2022
November 8, 2013
I suggest learning all native Excel tools before using VBA, because many things can be done with a proper excel setup, without vba.
You can record a macro while adding a formula in excel, that will give you the formula syntax.
Should look like:
Cells(1, "D").Formula = "=VLOOKUP(""Search Text"", A1:B10 , 2)"
October 18, 2018
Look at this link for tutorial