Thanks Mr. Kid atas penjelasannya... Sudah berhasil, kmrn kesalahan saya di $A$6 yg tidak dirubah. Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT
-----Original Message----- From: "Mr. Kid" <[email protected]> Date: Mon, 11 Jul 2011 05:28:12 Hai Tia, File terlampir contoh jika dikumpulkan jadi satu file, agar mudah mempelajarinya. Cara menyesuaikan dengan keadaan yang beda file juga disertakan. Formula : =IF(COUNTIF('[Contoh 2.xls]Sheet1'!*$*A*$*2:*$*A*$*6,C2),VLOOKUP(C2,'[Contoh 2.xls]Sheet1'!*$*A*$*2:*$*C*$*6,3,*FALSE*),"") Hal yang diperhatikan : 1. Kedua file harus dalam keadaan terbuka. 3. Penggunaan karakter *$* (absolute references) harus sesuai kebutuhan 4. Opsi *FALSE *digunakan agar fungsi VLookUp melakukan pencarian yang *persis *sama *seluruh karakter* dan *datatype*-nya Regards. Kid. ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
