VLoopUp

Does anybody know the equivalent code for "vlookup" in excel?

thanks,

TK

What is the datasource?

It is an MS Excel Worksheet. So, I might use the build-in function, like

range("A1").select
activecell.formulaR1C1="=Vlookup(.....)"

But, I 'd like to know the code for Vlookup.

thanks for your attention.

TK.