klo memakai excel 2007 bisa memakai perintah iferror I10=IFERROR((VLOOKUP($D10,'1-28FEB'!$A$7:$G$143,7,FALSE)),0)
________________________________ From: "zainul ulum [@ yahoo]" <[email protected]> To: [email protected] Sent: Tue, July 6, 2010 4:45:17 PM Subject: RE: [belajar-excel] Problem VLOOKUP I10=IF(ISNA(VLOOKUP($D10,'1-28 FEB'!$A$7:$G$143,7,FALSE)),0,VLOOKUP($D10,'1-28 FEB'!$A$7:$G$143,7,FALSE)) Atau =IF(ISNA(MATCH($D10,'1-28 FEB'!$A$7:$A$143,0)),0,VLOOKUP($D10,'1-28 FEB'!$A$7:$G$143,7,FALSE)) Atau =SUMPRODUCT(('1-28 FEB'!$A$7:$A$143=rekap!$D10)*'1-28 FEB'!$G$7:$G$143)
