Hai Jack,
Formula =VLOOKUP(D68;DataAnggota!$B$3:$C$79;2) tambahkan 0 menjadi =VLOOKUP(D68;DataAnggota!$B$3:$C$79;2;0) Maksud 0 disitu apabila tidak ada data yang sama persis tidak akan ditampilkan dengan data yang mirip. Salam, DD From: Jack Carmelo [email protected] [belajar-excel] [mailto:[email protected]] Sent: 15 Januari 2015 15:07 To: [email protected] Subject: [belajar-excel] VLOOKUP [1 Attachment] Para Master sekalian Saya hanya mau tanya tentang vlookup. Saya punya masalah sedikit tapi karena ini data keuangan masalahnya bisa menjadi besar. Mohon bantuannya. Kenapa pada sheet DataBase cell E68 yang muncul Wilfridus Radho bukan Bonyfasius Kopa seperti yang ada pada sheet DataAnggota? Mohon penjelasan dan koreksinya. File terlampir. Terima kasih -- Salam Sehat Selalu Dari Papuap Timika Jack _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
