Oke Thx yaa,,


________________________________
 Dari: M. Ferdiansyah <[email protected]>
Kepada: [email protected] 
Dikirim: Jumat, 3 Agustus 2012 13:22
Judul: Re: [belajar-excel] Index or Lookup data dengan 3 kriteria
 

  
Ikut nimbrung ya..

coba dengan file terlampir..

regard,

Ferdy

> Salam All Master Excel,
>
> Saya ingin bertanya tentang fungsi untuk mengambil data dengan 3
> kriteria,,
> Sebenarnya tujuan sama seperti fungsi lookup,vlookup,hlookup dengan 3
> kriteria
>
> saya menggunakan fungsi berikut
>
> =INDEX($E$11:$E$15,IF($B$11:$B$15=$C$5,IF($C$11:$C$15=$C$6,IF($D$11:$D$15=$C$7,ROW(E11:E15)))))
>
> akan tetapi kenapa tidak keluar nilai yang seharusnya,,
>
> Mohon pencerahannya,
>
> Terima kasih
>

____________ _________ _________ _________ _________ _________ _________
Notice  : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________
 

Kirim email ke