hehehe... +0.1 bukan +0 (kalau dalam bahasa indonesianya +0,1 bukan +0 Tujuannya, untuk memasktikan bahwa angka yang di-lookup sedikit lebih dari target yang ada dalam data, sehingga pasti mendapatkan nilai yang sesuai yang terakhir.
Wassalam, Kid. On Wed, Jun 26, 2013 at 8:03 AM, Ahmad Adriansyah < ahmad.adrians...@trac.astra.co.id> wrote: > ** > > > Om Kid,**** > > Kenapa formulasinya harus +0 ya?**** > > =LOOKUP($E3*+0*,1;B$3:B$32;$A$3:$A$32)**** > > ** ** > > Rgds,**** > > AA**** > > ** ** > > *From:* belajar-excel@yahoogroups.com [mailto: > belajar-excel@yahoogroups.com] *On Behalf Of *Mr. Kid > *Sent:* 26 Juni 2013 5:55 > *To:* BeExcel > *Subject:* Re: [belajar-excel] Laporan**** > > ** ** > > ** ** > > Andai saja ada contoh hasil kerja manual dan penjelasan sebab musabab > hasil manual itu diperoleh...**** > > File terlampir mencoba dengan LookUp.**** > > ** ** > > Wassalam,**** > > Kid.**** > > ** ** > > On Tue, Jun 25, 2013 at 12:13 AM, Cliff <cliff.su...@gmail.com> wrote:**** > > ** ** > > Dear Masters/B-excelers,**** > > ** ** > > Mohon bantuannya, seperti terlampir, saya sering buat laporan �Total > Produk > 1&2� dan laporan gabungan secara manual.**** > > Kira2 ada gk cara yang lebih mudah?**** > > ** ** > > Saya juga mau kaos b-excelers J, ada Bank mandiri kah?**** > > Materi KOPDAR#1 juga, CD-nya bisa dapat dimana? Mudah2an bisa ikut KOPDAR > edisi #2 ;)**** > > ** ** > > Makasih banyak. Sukses terus untuk para master.**** > > ** ** > > Salam,**** > > Cliff**** > > ** ** > > ** ** > > ------------------------------ > DISCLAIMER: This email and any files transmitted with it are confidential > and intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please let us know > by email reply and delete it from your system. Please note that any views > or opinions presented in this email are solely those of the author and do > not necessarily represent those of Konkola Copper Mines plc. Finally, the > recipient should check this email and any attachments for the presence of > viruses. Konkola Copper Mines plc accepts no liability for any damage > caused by any virus transmitted by this email.**** > > ** ** > > **** > > >