Tetap pakai “vlookup”, namun untuk penentuan column indexnya dengan “if” (jika putih maka column 4, jika coklat maka column 5, dst…) Sebagaimana terlampir..
Salam, Yazid -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sugiharto Sent: 08 Maret 2009 5:22 To: XL-mania Subject: ]] XL-mania [[ Rumus untuk ambil data dari 2 acuan Dear Pakar-pakar XL Saya ada punya problem mengenai pengambilan data lebih dari dua variabel. Data terlampir. Mohon bantuannya . terima kasih sebelumnya Sugiek ________________________________ "This e-mail (including any attachments) is intended solely for the addressee and could contain information that is confidential; If you are not the intended recipient, you are hereby notified that any use, disclosure, copying or dissemination of this e-mail and any attachment is strictly prohibited and you should immediately delete it. This message does not necessarily reflect the views of Bank Indonesia. Although this e-mail has been checked for computer viruses, Bank Indonesia accepts no liability for any damage caused by any virus and any malicious code transmitted by this e-mail. Therefore, the recipient should check again for the risk of viruses, malicious codes, etc as a result of e-mail transmission through Internet.”
Ambil data dari 2 acuan.xls
Description: Ambil data dari 2 acuan.xls
