Use ISERROR

=IF(ISERROR(VLOOKUP(A18,'Week 1
Totals'!A18:J94,10,FALSE)),0,VLOOKUP(A18,'Week 1
Totals'!A18:J94,10,FALSE))

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=568541