{"id":4802,"date":"2023-07-07T19:08:48","date_gmt":"2023-07-07T19:08:48","guid":{"rendered":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/"},"modified":"2023-07-07T19:08:48","modified_gmt":"2023-07-07T19:08:48","slug":"indeks-excel-cocok-dengan-3-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/","title":{"rendered":"Excel: cara menggunakan index match dengan 3 kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>INDEX<\/strong> dan <strong>MATCH<\/strong> di Excel untuk menemukan nilai tertentu di satu kolom dan mengembalikan nilai yang cocok di kolom lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut dengan <strong>INDEX<\/strong> dan <strong>MATCH<\/strong> untuk menemukan nilai dalam kolom yang memenuhi kriteria tertentu di 3 kolom lainnya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">D2:D10<\/span> ,MATCH(1,( <span style=\"color: #ff0000;\">G1<\/span> = <span style=\"color: #800080;\">A2:A10<\/span> )*( <span style=\"color: #008000;\">G2<\/span> = <span style=\"color: #b34fa7;\">B2:B10<\/span> )*( <span style=\"color: #993300;\">G3<\/span> = <span style=\"color: #339966;\">C2:C10<\/span> ),0))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mencari nilai dalam rentang <strong>D2:D10<\/strong> yang memenuhi tiga kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>A2: A10<\/strong> sama dengan nilai sel <strong>G1<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>B2: B10<\/strong> sama dengan nilai sel <strong>G2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>C2: C10<\/strong> sama dengan nilai sel <strong>G3<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan INDEX MATCH dengan 3 kriteria di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37487 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/imatch1.png\" alt=\"\" width=\"520\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mencari nilai poin pemain yang memenuhi tiga kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tim = Mav<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pos = Penjaga<\/span><\/li>\n<li> <span style=\"color: #000000;\">All-Star = Tidak<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <b>G4<\/b> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">D2:D10<\/span> ,MATCH(1,( <span style=\"color: #ff0000;\">G1<\/span> = <span style=\"color: #800080;\">A2:A10<\/span> )*( <span style=\"color: #008000;\">G2<\/span> = <span style=\"color: #b34fa7;\">B2:B10<\/span> )*( <span style=\"color: #993300;\">G3<\/span> = <span style=\"color: #339966;\">C2:C10<\/span> ),0))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37488\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/imatch2.png\" alt=\"Excel INDEX MATCH dengan 3 kriteria\" width=\"674\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat bahwa nilai pada kolom poin yang sesuai dengan <strong>Mavs<\/strong> pada kolom tim, <strong>Forward<\/strong> pada kolom Position dan <strong>No<\/strong> pada kolom All-Star adalah <strong>18<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan mengidentifikasi pemain yang memenuhi tiga kriteria berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37489 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/imatch3.png\" alt=\"\" width=\"566\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita lihat pemain tim <strong>Spurs<\/strong> dengan posisi <strong>Forward<\/strong> dan berstatus bintang <strong>No ini<\/strong> memang memiliki <strong>18<\/strong> poin.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengubah kriteria di sel <strong>G1<\/strong> , <strong>G2<\/strong> dan <strong>G3<\/strong> untuk menemukan nilai poin pemain yang memenuhi tiga kriteria berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/unggul-jika-indeks-cocok\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan fungsi IF dengan INDEX MATCH<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kecocokan-indeks-jumlah-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan SUM dengan INDEX MATCH<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kecocokan-indeks-mengembalikan-beberapa-nilai-secara-vertikal\/\" target=\"_blank\" rel=\"noopener\">Excel: Gunakan INDEX dan MATCH untuk Mengembalikan Beberapa Nilai Secara Vertikal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi INDEX dan MATCH di Excel untuk menemukan nilai tertentu di satu kolom dan mengembalikan nilai yang cocok di kolom lain. Anda dapat menggunakan sintaks berikut dengan INDEX dan MATCH untuk menemukan nilai dalam kolom yang memenuhi kriteria tertentu di 3 kolom lainnya: =INDEX( D2:D10 ,MATCH(1,( G1 = A2:A10 )*( G2 = [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T19:08:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/imatch1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/\",\"name\":\"Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T19:08:48+00:00\",\"dateModified\":\"2023-07-07T19:08:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan index match dengan 3 kriteria\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial","description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-07T19:08:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/imatch1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/","url":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/","name":"Excel: Cara menggunakan INDEX MATCH dengan 3 kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T19:08:48+00:00","dateModified":"2023-07-07T19:08:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan 3 kriteria di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/indeks-excel-cocok-dengan-3-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan index match dengan 3 kriteria"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4802"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4802"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4802\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}