Dear Ballerina , Coba dengan memasukkan Formula sbb : =INDEX(Sheet1!$D$2:$D$26;MATCH(Sheet2!$G3;Sheet1!$N$2:$N$26;0);1) Kemudian di COPAS ke bawah pada kolom Sheet2. Thanks
Regards Alwi Abdurrahman Noodle Division Head Office PT. Indofood CBP Sukses Makmur Tbk MFG System Development Specialist Jl. Ancol I No. 4 - 5, Ancol Barat, Jakarta Utara 14430 Telp : 021 - 6907141 - 5 , Ext. 564 Direct : 021 - 6917978 Fax : 021 - 6907331 E-mail : [email protected] Web-site : www.indofood.com Please don't print this e-mail unless you really need to From: "Lefthanded Ballerina [email protected] [belajar-excel]" <[email protected]> To: [email protected] Date: 20/10/2014 05:34 Subject: [belajar-excel] memunculkan hasil dari sheet yang berbeda (mods : lookup tengok ke kiri) [1 Attachment] Sent by: [email protected] Selamat malam para master be-excel, mohon bantuan para master sekalian buat merampungkan tugas ini, saya ingin memunculkan nilai yang terdapat di sheet1 dengan kategori yang seperti contoh yang terlampir thanks All. caax _____________________________________________________ Disclaimer : This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Excel 01 caax.xlsx
Description: Binary data
