coba juga,
=LOOKUP(9^9,CHOOSE({1,2},0,VLOOKUP($D13,'1-28 FEB'!$A$7:$G$143,7,0)))
>semoga bermanfaat
________________________________
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)
