bisa juga dengan:
=SUMPRODUCT(($C$5:$C$7=B12)*($D$4:$F$4=C12)*$D$5:$F$7) atau =OFFSET($D$5:$F$7,MATCH(B12,$C$5:$C$7,0)-1,MATCH(C12,$D$4:$F$4,0)-1,1,1) -zam- <http://wongmbatu.blogspot.com/> http://wongmbatu.blogspot.com/ _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of siti Vi Sent: Sunday, November 09, 2008 8:32 PM To: [email protected] Subject: Re: [belajar-excel] TABEL SIMPLE ... =INDEX($D$5:$F$7,MATCH(B12,$C$5:$C$7,0),MATCH(C12,$D$4:$F$4,0)) sekedar menghimbau: bahwa tidak semua member berstatus menerima attachment yaitu member yg memilih "digest" dan/atau "nomail" Bagai member dengan status dellivery spt itu akan tidak dapat mengikuti diskusi yg bunyinya "pertanyaan / jawaban ada di attachment" 2008/11/7 kaizen1 <[EMAIL PROTECTED]> Pertanyaan ada di file TQ Kaizen1
