Another way of doing it:

=IF(isblank(VLOOKUP(...))=true,"",VLOOKUP(...))


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=536430