Technology

Home » » Lookup banyak Kriteria

Lookup banyak Kriteria

Posted by CB Blogger

Bagaimana membuat lookup di excel dengan banyak kriteria, salah satu cara yaitu dengan menggunakan fungsi INDEX dan MATCH, Berikut contoh soalnya :

Dari contoh soal di atas diminta jawaban dengan formula yang di letakkan di cell (i3), berikut formulanya
{=INDEX($D$3:$D$5,MATCH(F3&G3&H3,$A$3:$A$5&$B$3:$B$5&$C$3:$C$5,0))
Keterangan :
  • INDEX($D$3:$D$5 Hasil yang ingin ditampilkan
  • MATCH fungsi yang akan mencocokkan
  • F3&G3&H3 Kriteria dari soal
  • $A$3:$A$5&$B$3:$B$5&$C$3:$C$5 kriteria dari tabel kriteria
  • 0 indikasi untuk kesalahan
Jika ada yang salah mohon di koreksi ,...


3 Komentar:

  1. Hi, I have just visited your site and the info you have covered has been of great interest to me.



    Study In UK

    ReplyDelete

  2. Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!! Thumbs up

    Surgical instruments
    Dental Instruments

    ReplyDelete
  3. I really admire you writing style and the articale which you had written is very intresting keep posting ..

    cheapest hotels in murree | cheap hotels in murree

    ReplyDelete

Sports

Find Us On Facebook

Advertisement

Featured Video

Featured Video

Looped Slider

Sponsor

Gagdet

Video Of Day

Fashion

BLOGGER

Gallery

Games

Popular Posts