how to convert the vlookup function to vba code


=VLOOKUP("TITE",Sheet2!A:D,5,FALSE)



I DONT MEAN
 ActiveCell.FormulaR1C1 = "=VLOOKUP(""TITE"",Sheet2!C:C[3],5,FALSE)"

I'm asking about a vba code works as a vlookup function

THANKS