how to do a vlookup in vba?

Hi guys,

how do you execute a vlookup in vba? What i normally do is turn on the macro recorder and type the vlookup function then that's it. But my concern is that i dont want the formula to be seen when the macro is executed and people can see a glimpse of the formula if i use the macro recorder to perform a vlookup function. so for example:

Please Login or Register  to view this content.

how do you change that Activecell.formulaR1C1 line and make it into a legitimate vba code that when the user performs the macro it will be smooth and they wont catch a glimpse of the formula?

No way, that simple???? will try it out and give you a star if it works.