{"id":2847,"date":"2023-07-20T10:41:06","date_gmt":"2023-07-20T10:41:06","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/"},"modified":"2023-07-20T10:41:06","modified_gmt":"2023-07-20T10:41:06","slug":"google-sheet-mengindeks-beberapa-kriteria-kecocokan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/","title":{"rendered":"Google sheets: gunakan index match dengan beberapa kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk melakukan <strong>INDEX MATCH<\/strong> di Google Spreadsheet dengan beberapa kriteria:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=INDEX(reference,MATCH(1,(criteria1)*(criteria2)*(criteria3)*...,0))<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Emas:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>referensi<\/strong> : Rentang nilai yang akan dikembalikan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>MATCH<\/strong> : Memberikan posisi kunci pencarian Anda<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> : Menentukan kunci pencarian tetap<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kriteria1<\/strong> , <strong>kriteria2<\/strong> , <strong>kriteria3<\/strong> : Kriteria yang harus dihormati<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0<\/strong> : Spesies untuk mencari nilai pasti<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: INDEX MATCH dengan beberapa kriteria di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Katakanlah kita memiliki data berikut di Google Spreadsheet yang menampilkan informasi tentang berbagai pemain bola basket:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24942 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex1-1.jpg\" alt=\"\" width=\"552\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari nilai poin yang berhubungan dengan pemain yang ada di <strong>Mavs<\/strong> , yang mempunyai posisi <strong>forward<\/strong> dan status All Star <strong>Yes<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus <strong>INDEX MATCH<\/strong> berikut untuk mencari nilai poin ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=INDEX( <span dir=\"auto\" style=\"color: #ff6600;\">D:D<\/span> ,MATCH( <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> ,( <span dir=\"auto\" style=\"color: #800080;\">A:A<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #008080;\">A15<\/span> ) <span class=\"  default-formula-text-color\" dir=\"auto\">*<\/span> ( <span dir=\"auto\" style=\"color: #993300;\">B:B<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #0000ff;\">B15<\/span> ) <span class=\"  default-formula-text-color\" dir=\"auto\">*<\/span> ( <span dir=\"auto\" style=\"color: #ff9900;\">C:C<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #008000;\">C15<\/span> ), <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">0<\/span> ))\n<\/span><\/strong><\/span><\/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-24943\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex2-1.jpg\" alt=\"INDEX MATCH dengan beberapa kriteria di Google Sheets\" width=\"580\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengembalikan nilai poin <strong>11<\/strong> untuk pemain yang berada di tim <strong>Mavs<\/strong> , berposisi <strong>Forward<\/strong> , dan berstatus All Star <strong>Yes<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita mengubah nilai pada baris 15, rumus INDEX MATCH kita akan otomatis diperbarui.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai contoh, mari kita gunakan rumus ini untuk mencari nilai poin pemain yang berada di tim <strong>Spurs<\/strong> , memiliki posisi <strong>Guard<\/strong> , dan berstatus All Star <strong>Ya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24944 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex3-1.jpg\" alt=\"\" width=\"577\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengembalikan nilai poin <strong>22<\/strong> untuk pemain ini.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Melakukan Reverse VLOOKUP di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk melakukan INDEX MATCH di Google Spreadsheet dengan beberapa kriteria: =INDEX(reference,MATCH(1,(criteria1)*(criteria2)*(criteria3)*&#8230;,0)) Emas: referensi : Rentang nilai yang akan dikembalikan MATCH : Memberikan posisi kunci pencarian Anda 1 : Menentukan kunci pencarian tetap kriteria1 , kriteria2 , kriteria3 : Kriteria yang harus dihormati 0 : Spesies untuk mencari nilai pasti [&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>Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.\" \/>\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\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:41:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex1-1.jpg\" \/>\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\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/\",\"name\":\"Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:41:06+00:00\",\"dateModified\":\"2023-07-20T10:41:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: gunakan index match dengan beberapa 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":"Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial","description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.","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\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:41:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex1-1.jpg"}],"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\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/","name":"Google Spreadsheet: Gunakan INDEX MATCH dengan berbagai kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:41:06+00:00","dateModified":"2023-07-20T10:41:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengindeks-beberapa-kriteria-kecocokan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: gunakan index match dengan beberapa 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\/2847"}],"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=2847"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2847\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}