how to convert the vlookup function to vba code

**funtastic** · 07-04-2012, 06:32 PM

=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

**oeldere** · 07-04-2012, 06:49 PM

I DONT MEAN

Why is the give code not working for you?

I can't help you enough with VBA, but i'm currios to the reason.

**jeffreybrown** · 07-04-2012, 06:50 PM

Maybe this sample will help...

Re: how to convert the vlookup function to vba code