Terima kasih Pak Ghozi.
________________________________ From: ghozi alkatiri <[email protected]> To: "[email protected]" <[email protected]> Sent: Saturday, June 29, 2013 9:32 AM Subject: Bls: [belajar-excel] Lookup mencari posisi meja tulis di D23 =INDEX($A$1:$G$17;INDEX({2;10};MATCH(SUMPRODUCT(($C$2:$G$17=C23)*ROW($C$2:$G$17));{2;10}));SUMPRODUCT(($C$2:$G$17=C23)*COLUMN($C$2:$G$17))) copy ke bawah wassalam Ghozi Alkatiri ________________________________ Dari: Emi <[email protected]> Kepada: "[email protected]" <[email protected]> Dikirim: Jumat, 28 Juni 2013 9:53 Judul: [belajar-excel] Lookup mencari posisi meja Dear Teman BeExcel, Gimanacara lookup untuk mencari di meja mana mereka berada. Apabila nama ditulis, otomatis bisa tau di mana mereka. Terima kasih. -Emi Lestari
