This might be the formula that will help you ...

=IF(ISERROR(YOUR_VLOOKUP_FORMULA),0,YOUR_VLOOKUP_F ORMULA)


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=392718