Coba di C3 ketik formula: =INDEX(IF(Sheet1!$A$3="doa",Sheet1!$G$4:$G$19,Sheet1!$D$4:$D$19),COLUMN(A:A))
kopi ke kanan. Jika menggunakan Regional setting Indonesia ganti karakter , menjadi ; On 8/25/15, [email protected] [belajar-excel] <[email protected]> wrote: > Mohon bantuan members sekalian. file terlampir >
