Cara Lain : =INDEX($E$3:$H$8,B15,MATCH(C15,$E$2:$H$2,0))
Cheers, VD "A. Yazid Niam" <[email protected]> Sent by: [email protected] 03/09/2009 09:27 AM Please respond to [email protected] To <[email protected]> cc Subject RE: ]] XL-mania [[ Rumus untuk ambil data dari 2 acuan 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.” [attachment "Ambil data dari 2 acuan.xls" deleted by Vidi Ardyanto/TJ0987/JOC/ID]
<<image/gif>>
Ambil data dari 2 acuan_VD.xls
Description: MS-Excel spreadsheet
