Kalau seperti itu bukan lagi Vlookup , tapi Filtering Data. Coba dicari artikel di milis ini Ttg Filter, misal: http://tech.groups.yahoo.com/group/belajar-excel/message/15496
To: [email protected] From: [email protected] Date: Tue, 21 Feb 2012 20:57:11 +0800 Subject: RE: Bls: [belajar-excel] Bisakah Fungsi Vlookup mencari pada banyak Kolom Target ? Terima kasih rumus canggihnya Pak Sudarsono, sudah dicoba dan alhamdulillah keluar datanya, namun yang saya inginkan pak, dengan mengganti kolom bulan dan tahun di sheet prit per bulan, maka data2 yang berkaitan di bulan serta tahun itu masuk pak, keterangan lengkap dan file kasusnya saya lampirkan kembali. Salam,Miftahuddin Ahimy ------------------------------------------------------ Dari: jkssxls Sudarsono <[email protected]> Dikirim: Senin, 20 Februari 2012 13:08 untuk penerimaan :=SUMPRODUCT(('DATABASE (INPUT DATA)'!$A$4:$A$279=Sheet1!$B5)*('DATABASE (INPUT DATA)'!$D$3:$G$3=Sheet1!D$3),'DATABASE (INPUT DATA)'!$D$4:$G$279)untuk pengeluaran :=SUMPRODUCT(('DATABASE (INPUT DATA)'!$A$4:$A$279=Sheet1!$B5)*('DATABASE (INPUT DATA)'!$D$3:$G$3=Sheet1!D$3),'DATABASE (INPUT DATA)'!$H$4:$K$279)------------------------------------ ------------------------------------ --------------------------------------------------------------------- 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/
