Pak Ghozi,
Mohon pencerahan, dalam rumus di bawah apa artinya INDEX({2;10}, merujuk
kepada apa?
=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)))
Terima kasih.
Emi Lestari
________________________________
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
