if the vlookup always returns a number and you want it to be a strin
try

bmrp=cstr(vlookup ....)

if it can return either a string or a number then use a variant

dim v as variant
v=vlookup(....)
bmrp=v

hope this help

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=56763