{"id":1772,"date":"2023-11-06T00:02:41","date_gmt":"2023-11-06T00:02:41","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/"},"modified":"2023-12-06T06:19:54","modified_gmt":"2023-12-06T06:19:54","slug":"bandingkan-dua-kolom-vlookup","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/","title":{"rendered":"Cocokkan\/bandingkan dua kolom dengan vlookup"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3395774496\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>VLOOKUP adalah cara termudah untuk mencocokkan dua kolom dan mendapatkan hasil yang nilainya cocok. Pada contoh di bawah ini kita memiliki dua daftar nama. Yang pertama kita punya 20 kata benda dan yang kedua kita punya 10 kata benda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85920\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-dua-kolom-dengan-vlookup\" width=\"505\" height=\"483\"><\/figure><\/div><p> Anda sekarang perlu membandingkan dua kolom satu sama lain menggunakan VLOOKUP.<\/p><h2 class=\"wp-block-heading\"> Membandingkan kolom pertama dengan kolom kedua<\/h2><p> Anda perlu mengikuti langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Di kolom B, di samping kolom A. Di sel B2, masukkan VLOOKUP.<\/li><li> Di lookup_value, lihat sel A2.<\/li><li> Untuk table_array, lihat rentang D1:D11; Untuk membekukan kisaran, Anda dapat menggunakan tanda dolar ($D$1:$D11).<\/li><li> Ketik 1 di kolom_index_num.<\/li><li> Dan di range_index masukkan 0 dan tutup fungsinya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85921\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-comparer-la-premiere-colonne-avec-la-seconde.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-kolom-pertama-dengan-kedua\" width=\"600\" height=\"415\"><\/figure><\/div><p> Sekarang tekan Enter untuk mendapatkan hasilnya, lalu gulir ke bawah rumus ke nama belakang. Seperti yang Anda lihat, empat nilai di kolom sesuai dengan nama di kolom kedua. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">= VLOOKUP(A2,$D$1:$D$11,1,0))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85922\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultat-de-la-comparaison-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil perbandingan vlookup\" width=\"573\" height=\"576\"><\/figure><\/div><p> Dan jika Anda ingin membandingkan kolom kedua dengan kolom pertama, Anda bisa menggunakan rumus yang sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85923\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-comparer-la-deuxieme-colonne-avec-la-premiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-kolom-kedua-dengan-yang-pertama\" width=\"503\" height=\"556\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=VLOOKUP(C2,$A$1:$A$21,1,0)<\/code><\/pre><p class=\"alert-box\"> Anda perlu membekukan rentang menggunakan tanda dolar ($) di table_array sehingga ketika Anda menyeret rumus ke bawah, table_array tidak ikut berpindah.<\/p><h2 class=\"wp-block-heading\"> Dapatkan respons yang berarti terhadap hasilnya<\/h2><p> Seperti yang Anda lihat, kami memiliki kesalahan #N\/A untuk nilai yang tidak ada di kolom kedua. Nah, untuk mengubah kesalahan ini menjadi sesuatu yang berarti, Anda bisa menggunakan rumus di bawah ini: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(ISERROR(VLOOKUP(A2,$D$1:$D$11,1,0)),\"Not Available\",\"Available\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85924\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-geler-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang beku\" width=\"638\" height=\"464\"><\/figure><\/div><p> Rumus ini menggunakan ISERROR untuk memeriksa kesalahannya dan kemudian menggunakan IF. Jika ada kesalahan, ia mengembalikan nilai yang Anda tentukan; jika tidak, nilai lain yang Anda tetapkan.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/faire-correspondre-les-colonnes.xlsx\">Unduh<\/a><\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1772","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cocokkan\/bandingkan dua kolom dengan VLOOKUP<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cocokkan\/bandingkan dua kolom dengan VLOOKUP\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/\",\"name\":\"Cocokkan\/bandingkan dua kolom dengan VLOOKUP\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png\",\"datePublished\":\"2023-11-06T00:02:41+00:00\",\"dateModified\":\"2023-12-06T06:19:54+00:00\",\"description\":\"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cocokkan\/bandingkan dua kolom dengan vlookup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cocokkan\/bandingkan dua kolom dengan VLOOKUP","description":"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.","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:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/","og_locale":"id_ID","og_type":"article","og_title":"Cocokkan\/bandingkan dua kolom dengan VLOOKUP","og_description":"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.","og_url":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/","url":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/","name":"Cocokkan\/bandingkan dua kolom dengan VLOOKUP","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png","datePublished":"2023-11-06T00:02:41+00:00","dateModified":"2023-12-06T06:19:54+00:00","description":"Tutorial ini akan mengajari Anda cara menulis rumus Excel menggunakan VLOOKUP untuk membandingkan atau mencocokkan dua kolom.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-colonnes-avec-vlookup.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bandingkan-dua-kolom-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cocokkan\/bandingkan dua kolom dengan vlookup"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1772"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1772\/revisions"}],"predecessor-version":[{"id":2885,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1772\/revisions\/2885"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}