Lookup Value

[Kevin]

Hi,

I hope someone can help me. I need to emulate in code the
vlookup worksheet command. I need to be able to assign the
returned value to a variable and use that value in code.

Thanks in advance.

Kevin

 

[Frank Kabel]

Hi
use application.worksheetfunction.vlookup(....)