Terima kasih Pak Hendrik atas jawabannya.
________________________________ From: hendrik karnadi <[email protected]> To: [email protected] Sent: Tue, July 6, 2010 9:02:10 PM Subject: Re: [belajar-excel] Problem VLOOKUP Untuk Excel 2007 bisa pakai : =IFERROR(VLOOKUP( $D13,'1-28 FEB'!$A$7:$G$ 143,7,FALSE) ,0) Salam, Hendrik Karnadi ________________________________ From: anton suryadi <summon...@yahoo. com> To: belajar-excel@ yahoogroups. com Sent: Tuesday, July 6, 2010 17:22:43 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)
