{"id":2305,"date":"2023-07-22T20:44:37","date_gmt":"2023-07-22T20:44:37","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/"},"modified":"2023-07-22T20:44:37","modified_gmt":"2023-07-22T20:44:37","slug":"excel-cocokkan-dua-kolom-kembalikan-ketiga","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/","title":{"rendered":"Cara mencocokkan dua kolom dan mengembalikan kolom ketiga di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mencocokkan nilai dua kolom dan menghasilkan kolom ketiga di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fungsi <strong>VLOOKUP()<\/strong> , yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>VLOOKUP (nilai_pencarian, array_tabel, col_index_num, [range_lookup])<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>lookup_value<\/strong> : Nilai yang ingin Anda cari.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>table_array<\/strong> : Rentang sel yang akan dicari.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>col_index_num<\/strong> : Nomor kolom dalam rentang yang berisi nilai kembalian.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>range_lookup<\/strong> : Apakah akan menemukan kecocokan perkiraan (default) atau kecocokan persis.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cocokkan Dua Kolom dan Kembalikan Kolom Ketiga di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20947 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/match1.png\" alt=\"\" width=\"561\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mencocokkan nilai tim di kolom A dan kolom D dan mengembalikan nilai poin dari kolom B ke kolom E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks VLOOKUP berikut untuk mencocokkan nilai pertama di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">D2<\/span> , <span style=\"color: #ff0000;\">$A$2:$B$16<\/span> , 2, FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20949 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/match2.png\" alt=\"\" width=\"541\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai &#8220;poin&#8221; di kolom B yang terkait dengan &#8220;Matahari&#8221; adalah <strong>96<\/strong> , itulah sebabnya nilai ini dikembalikan di kolom E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini ke setiap sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20950 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/match3.png\" alt=\"\" width=\"533\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi VLOOKUP <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/bandingkan-lembar-excel-untuk-mengetahui-perbedaannya\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Membandingkan Dua Lembar Excel untuk Perbedaan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vlookup-membandingkan-dua-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Dua Daftar di Excel Menggunakan VLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan berdasarkan beberapa kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mencocokkan nilai dua kolom dan menghasilkan kolom ketiga di Excel. Untungnya, hal ini mudah dilakukan menggunakan fungsi VLOOKUP() , yang menggunakan sintaks berikut: VLOOKUP (nilai_pencarian, array_tabel, col_index_num, [range_lookup]) Emas: lookup_value : Nilai yang ingin Anda cari. table_array : Rentang sel yang akan dicari. col_index_num : Nomor kolom dalam rentang yang berisi [&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 Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta 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-cocokkan-dua-kolom-kembalikan-ketiga\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:44:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/match1.png\" \/>\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-cocokkan-dua-kolom-kembalikan-ketiga\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\",\"name\":\"Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:44:37+00:00\",\"dateModified\":\"2023-07-22T20:44:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencocokkan dua kolom dan mengembalikan kolom ketiga di excel\"}]},{\"@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 Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta 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-cocokkan-dua-kolom-kembalikan-ketiga\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:44:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/match1.png"}],"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-cocokkan-dua-kolom-kembalikan-ketiga\/","url":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/","name":"Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:44:37+00:00","dateModified":"2023-07-22T20:44:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencocokkan dua kolom dan mengembalikan kolom ketiga di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencocokkan dua kolom dan mengembalikan kolom ketiga di excel"}]},{"@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\/2305"}],"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=2305"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2305\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}