{"id":3845,"date":"2023-07-15T05:15:45","date_gmt":"2023-07-15T05:15:45","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/"},"modified":"2023-07-15T05:15:45","modified_gmt":"2023-07-15T05:15:45","slug":"excel-xlookup-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/","title":{"rendered":"Excel: cara menggunakan xlookup dengan banyak kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus XLOOKUP berikut di Excel untuk menemukan sel yang memenuhi beberapa kriteria:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=XLOOKUP( <span style=\"color: #3366ff;\">F2<\/span> &amp; <span style=\"color: #ff0000;\">G2<\/span> &amp; <span style=\"color: #800080;\">H2<\/span> , <span style=\"color: #008000;\">A2:A13<\/span> &amp; <span style=\"color: #800000;\">B2:B13<\/span> &amp; <span style=\"color: #ff6600;\">C2:C13<\/span> , <span style=\"color: #008080;\">D2:D13<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menemukan sel dalam rentang <strong>D2:D13<\/strong> yang memenuhi semua kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai dalam rentang sel <strong>A2:A13<\/strong> sama dengan nilai dalam sel <strong>F2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai dalam rentang sel <strong>B2:B13<\/strong> sama dengan nilai dalam sel <strong>G2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai dalam rentang sel <strong>C2:C13<\/strong> sama dengan nilai dalam sel <strong>H2<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: XLOOKUP dengan beberapa kriteria di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31090 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlook1.jpg\" alt=\"\" width=\"498\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari nilai poin pemain yang memenuhi semua kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tim = Cav<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pos = Penjaga<\/span><\/li>\n<li> <span style=\"color: #000000;\">Mulai = Ya<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=XLOOKUP( <span style=\"color: #3366ff;\">F2<\/span> &amp; <span style=\"color: #ff0000;\">G2<\/span> &amp; <span style=\"color: #800080;\">H2<\/span> , <span style=\"color: #008000;\">A2:A13<\/span> &amp; <span style=\"color: #800000;\">B2:B13<\/span> &amp; <span style=\"color: #ff6600;\">C2:C13<\/span> , <span style=\"color: #008080;\">D2:D13<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>I2<\/strong> lalu tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31092\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlook2.jpg\" alt=\"Excel XLOOKUP dengan beberapa kriteria\" width=\"642\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus XLOOKUP ini mampu mencari \u201cCavs\u201d pada kolom Team, \u201cGuard\u201d pada kolom Position, \u201cYes\u201d pada kolom Starter dan mengembalikan nilai point sebesar <strong>30<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kami dapat memeriksa kumpulan data asli dan mengonfirmasi bahwa ini adalah nilai poin yang benar untuk pemain yang memenuhi semua kriteria berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31093 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlook3.jpg\" alt=\"\" width=\"663\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami menggunakan tiga kriteria dalam rumus XLOOKUP khusus ini, namun Anda dapat menggunakan sintaksis serupa untuk memasukkan kriteria sebanyak yang Anda inginkan.<\/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> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-menemukan-duplikat\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menemukan Duplikat Menggunakan VLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-semua-kecocokan\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP untuk Mengembalikan Semua Kecocokan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP untuk Mengembalikan Banyak Kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus XLOOKUP berikut di Excel untuk menemukan sel yang memenuhi beberapa kriteria: =XLOOKUP( F2 &amp; G2 &amp; H2 , A2:A13 &amp; B2:B13 &amp; C2:C13 , D2:D13 ) Rumus khusus ini akan menemukan sel dalam rentang D2:D13 yang memenuhi semua kriteria berikut: Nilai dalam rentang sel A2:A13 sama dengan nilai dalam sel F2 [&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 XLOOKUP dengan banyak kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk 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\/excel-xlookup-beberapa-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 XLOOKUP dengan banyak kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T05:15:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlook1.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\/excel-xlookup-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/\",\"name\":\"Excel: Cara menggunakan XLOOKUP dengan banyak kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T05:15:45+00:00\",\"dateModified\":\"2023-07-15T05:15:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan xlookup dengan banyak 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 XLOOKUP dengan banyak kriteria - Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk 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\/excel-xlookup-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan XLOOKUP dengan banyak kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-15T05:15:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlook1.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\/excel-xlookup-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/","name":"Excel: Cara menggunakan XLOOKUP dengan banyak kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T05:15:45+00:00","dateModified":"2023-07-15T05:15:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP di Excel dengan beberapa kriteria, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-xlookup-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan xlookup dengan banyak 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\/3845"}],"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=3845"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3845\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}