{"id":3374,"date":"2023-07-17T20:11:42","date_gmt":"2023-07-17T20:11:42","guid":{"rendered":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/"},"modified":"2023-07-17T20:11:42","modified_gmt":"2023-07-17T20:11:42","slug":"vlookup-dengan-dua-nilai-pencarian","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/","title":{"rendered":"Bagaimana melakukan vlookup dengan dua nilai pencarian"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk melakukan VLOOKUP dengan dua nilai pencarian di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">F1<\/span> &amp; <span style=\"color: #ff0000;\">F2<\/span> ,CHOOSE({1,2}, <span style=\"color: #800080;\">A2:A10<\/span> &amp; <span style=\"color: #008000;\">B2:B10<\/span> , <span style=\"color: #993300;\">C2:C10<\/span> ),2,FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mencari nilai <strong>F1<\/strong> dan <strong>F2<\/strong> masing-masing dalam rentang <strong>A2:A10<\/strong> dan <strong>B2:B10<\/strong> , dan mengembalikan nilai yang sesuai dalam rentang <strong>C2:C10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <strong>Contoh: Melakukan VLOOKUP dengan dua nilai pencarian<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28318 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdeux.jpg\" alt=\"\" width=\"491\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menggunakan fungsi <strong>VLOOKUP<\/strong> untuk menemukan nilai points yang sesuai dengan nilai Team dari <strong>Mavs<\/strong> <em>dan<\/em> nilai Position dari <strong>Center<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel F3:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">F1<\/span> &amp; <span style=\"color: #ff0000;\">F2<\/span> ,CHOOSE({1,2}, <span style=\"color: #800080;\">A2:A10<\/span> &amp; <span style=\"color: #008000;\">B2:B10<\/span> , <span style=\"color: #993300;\">C2:C10<\/span> ),2,FALSE)<\/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-28319\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookuptwo1.jpg\" alt=\"VLOOKUP dengan dua nilai pencarian di Excel\" width=\"663\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>31<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini adalah nilai poin yang tepat untuk pemain <strong>Mavs<\/strong> yang menempati posisi <strong>Center<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa kita dapat mengubah nilai di kolom F untuk mencari nilai poin pemain lain.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika kita mengubah tim menjadi <strong>Spurs<\/strong> dan posisinya menjadi <strong>Guard<\/strong> , fungsi <strong>VLOOKUP<\/strong> akan otomatis terupdate untuk mencari nilai poin pemain tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28320 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookuptwo2.jpg\" alt=\"\" width=\"527\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai yang benar dalam poin <strong>40<\/strong> .<\/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 tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Peringkat Persentil di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut untuk melakukan VLOOKUP dengan dua nilai pencarian di Excel: =VLOOKUP( F1 &amp; F2 ,CHOOSE({1,2}, A2:A10 &amp; B2:B10 , C2:C10 ),2,FALSE) Rumus khusus ini mencari nilai F1 dan F2 masing-masing dalam rentang A2:A10 dan B2:B10 , dan mengembalikan nilai yang sesuai dalam rentang C2:C10 . Contoh berikut menunjukkan cara menggunakan [&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>Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, 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\/vlookup-dengan-dua-nilai-pencarian\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T20:11:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdeux.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\/vlookup-dengan-dua-nilai-pencarian\/\",\"url\":\"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/\",\"name\":\"Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T20:11:42+00:00\",\"dateModified\":\"2023-07-17T20:11:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana melakukan vlookup dengan dua nilai pencarian\"}]},{\"@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":"Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials","description":"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, 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\/vlookup-dengan-dua-nilai-pencarian\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/","og_site_name":"Statorials","article_published_time":"2023-07-17T20:11:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdeux.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\/vlookup-dengan-dua-nilai-pencarian\/","url":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/","name":"Cara melakukan VLOOKUP dengan dua nilai pencarian - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T20:11:42+00:00","dateModified":"2023-07-17T20:11:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan VLOOKUP dengan dua nilai pencarian di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vlookup-dengan-dua-nilai-pencarian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana melakukan vlookup dengan dua nilai pencarian"}]},{"@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\/3374"}],"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=3374"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3374\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}