{"id":3406,"date":"2023-07-17T15:59:16","date_gmt":"2023-07-17T15:59:16","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/"},"modified":"2023-07-17T15:59:16","modified_gmt":"2023-07-17T15:59:16","slug":"google-sheet-vlookup-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/","title":{"rendered":"Google spreadsheet: gunakan vlookup dengan banyak kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menggunakan VLOOKUP di Google Spreadsheet untuk menemukan nilai berdasarkan beberapa kriteria.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mempunyai dua himpunan data berikut dan Anda ingin menggunakan VLOOKUP di himpunan data kanan untuk mengembalikan nilai di kolom <strong>Poin<\/strong> yang cocok dengan nilai di kolom <strong>Tim<\/strong> dan kolom <strong>Posisi<\/strong> Himpunan Data Kiri:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28569 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev1.jpg\" alt=\"\" width=\"669\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat Kolom Dukungan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Sebelum kita bisa melakukan VLOOKUP, terlebih dahulu kita perlu membuat kolom pembantu pada dataset pertama yang menyatukan nilai dari kolom <strong>Team<\/strong> dan <strong>Points<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita akan mengetikkan rumus berikut di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">B2<\/span> &amp; <span style=\"color: #800080;\">C2<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28570 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev2.jpg\" alt=\"\" width=\"470\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom A sekarang berisi gabungan nilai <strong>Tim<\/strong> dan <strong>Posisi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita akan menggunakan kolom baru ini dalam rumus VLOOKUP kita pada langkah berikutnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Gunakan VLOOKUP dengan Banyak Kriteria<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa mengetikkan rumus berikut pada sel <strong>I2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=VLOOKUP( <span style=\"color: #ff6600;\">F2<\/span> &amp; <span style=\"color: #800080;\">G2<\/span> , <span style=\"color: #33cccc;\">$A$2:$D$13<\/span> , 4, FALSE)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom I:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28572\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookup3.jpg\" alt=\"VLOOKUP Google Sheets dengan berbagai kriteria\" width=\"673\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini menemukan rangkaian nilai teks di kolom <strong>F<\/strong> dan <strong>G<\/strong> di kolom <strong>A<\/strong> dan mengembalikan nilai yang sesuai di kolom <strong>D.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai poin setiap pemain di kumpulan data kanan cocok dengan nilai poin pemain terkait di kumpulan data kiri.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita telah berhasil menggunakan VLOOKUP dengan beberapa kriteria.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\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\/iferror-vlookup-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan IFERROR dengan VLOOKUP di Google Sheets<\/a><br \/><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>Seringkali, Anda mungkin ingin menggunakan VLOOKUP di Google Spreadsheet untuk menemukan nilai berdasarkan beberapa kriteria. Misalnya, kita mempunyai dua himpunan data berikut dan Anda ingin menggunakan VLOOKUP di himpunan data kanan untuk mengembalikan nilai di kolom Poin yang cocok dengan nilai di kolom Tim dan kolom Posisi Himpunan Data Kiri: Contoh langkah demi langkah berikut [&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 VLOOKUP dengan Berbagai Kriteria \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP 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-vlookup-beberapa-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Gunakan VLOOKUP dengan Berbagai Kriteria \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T15:59:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev1.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-vlookup-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/\",\"name\":\"Google Spreadsheet: Gunakan VLOOKUP dengan Berbagai Kriteria \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T15:59:16+00:00\",\"dateModified\":\"2023-07-17T15:59:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VLOOKUP dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: gunakan vlookup 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":"Google Spreadsheet: Gunakan VLOOKUP dengan Berbagai Kriteria \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP 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-vlookup-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Gunakan VLOOKUP dengan Berbagai Kriteria \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-17T15:59:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev1.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-vlookup-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/","name":"Google Spreadsheet: Gunakan VLOOKUP dengan Berbagai Kriteria \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T15:59:16+00:00","dateModified":"2023-07-17T15:59:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP dengan beberapa kriteria di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: gunakan vlookup 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\/3406"}],"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=3406"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3406\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}