Terima kasih atas jawabannya, Pak Anton.
________________________________ From: anton suryadi <[email protected]> To: [email protected] Sent: Tue, July 6, 2010 5:22:43 PM Subject: Re: [belajar-excel] Problem VLOOKUP 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]" <zainul_ulum@ yahoo.com> To: belajar-excel@ yahoogroups. com 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)
