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

--
Regards
Frank Kabel
Frankfurt, Germany


Kevin wrote:
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