{"id":2058,"date":"2023-10-22T04:56:33","date_gmt":"2023-10-22T04:56:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/"},"modified":"2023-12-06T06:19:07","modified_gmt":"2023-12-06T06:19:07","slug":"vlookup-dari-lembar-lain","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/","title":{"rendered":"Bagaimana cara menggunakan vlookup dari sheet lain?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3677942004\"><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>Saat Anda ingin mencari nilai dari data sheet lain, Anda bisa menggunakan VLOOKUP. Dan tutorial ini menjelaskannya dengan contoh yang mudah diikuti. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83718\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-dari-sheet lain\" width=\"785\" height=\"406\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah di bawah ini untuk menulis rumus ini:<\/p><ol><li> Pertama, masukkan VLOOKUP dalam sel, dan argumen lookup_value merujuk ke sel tempat Anda memiliki nilai pencarian. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-masukkan-vlookup-dalam-sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrez-vlookup-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-vlookup-in-cell\" width=\"523\" height=\"260\"><\/li><li> Setelah itu, masukkan perintah dan klik \u201cLembar 2\u201d untuk membukanya. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-masukkan-koma-dan-klik-di-lembar lain\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-une-virgule-et-cliquez-sur-une-autre-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-comma-and-click-another-sheet\" width=\"513\" height=\"197\"><\/li><li> Sekarang di \u201cLembar 2\u201d pilih tabel di mana Anda memiliki ID produk dan kuantitas. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-pilih-tabel-tempat-Anda-memiliki-data-untuk-dicari\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-la-table-dans-laquelle-vous-avez-des-donnees-a-rechercher.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-table-where-you-have-data-to-lookup\" width=\"475\" height=\"389\"><\/li><li> Kemudian masukkan koma lagi dan tentukan 2 pada argumen col_index_num. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-masukkan-koma-dan-tentukan-argumen-angka\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-entrez-une-virgule-et-specifiez-un-argument-numerique.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-comma-and-specify-number-argument\" width=\"463\" height=\"109\"><\/li><li> Dari sana, di [range_lookup], masukkan 0 atau FALSE untuk pencarian pencocokan tepat. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-masukkan-nol-atau-salah-untuk-pencocokan persis\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-zero-ou-faux-pour-une-correspondance-exacte.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-zero-or-false-for-exact-match\" width=\"464\" height=\"107\"><\/li><li> Pada akhirnya, tutup fungsi dan tekan Enter untuk mendapatkan hasil di sel lembar \u201c1\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-akhirnya-tutup-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-a-la-fin-fermer-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"in-the-end-close-the-function\" width=\"451\" height=\"227\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Catatan penting<\/h2><p> Jika Anda mengubah nama lembar tempat Anda menyimpan datanya, Excel juga cukup pintar untuk mengubahnya dalam rumus Anda. Jadi Anda tidak perlu khawatir sebelum mengganti nama sheetnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83726\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-changement-de-nom-de-feuille-est-mis-a-jour-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"perubahan-nama-sheet-diperbarui-dalam-rumus\" width=\"519\" height=\"262\"><\/figure><\/div><p> Namun Anda perlu memastikan bahwa setelah datasheet dihapus, rumus Anda akan menampilkan #REF! Kesalahan pada hasilnya. Dan tidak ada cara untuk membatalkan penghapusan sheet. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83727\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-supprimer-la-feuille-donne-une-erreur-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus-lembar-memberikan-ref-kesalahan\" width=\"516\" height=\"298\"><\/figure><\/div><p> Anda juga dapat mengubah data dari sheet lain menjadi rentang bernama dan mereferensikannya di VLOOKUP. Dengan ini, Anda tidak perlu membuka lembar kedua saat menulis rumus. Sebagai gantinya, Anda bisa memasukkan rentang bernama dan Excel akan merujuk ke datanya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83729\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-donnees-de-la-plage-de-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-dari-nama-rentang\" width=\"511\" height=\"295\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/id\/a\/\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/iferror-vlookup\/\">IFERROR dengan VLOOKUP di Excel untuk menggantikan #N\/A di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-dua-arah\/\">Lakukan pencarian dua arah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-terbalik\/\">Membalikkan VLOOKUP (mundur: kanan ke kiri) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pertandingan-vs-pencarian\/\">Menggabungkan VLOOKUP MATCH di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/vlookup-beberapa-kriteria\/\">VLOOKUP dengan beberapa kriteria di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","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-2058","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>Bagaimana cara menggunakan VLOOKUP dari sheet lain?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026\" \/>\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\/vlookup-dari-lembar-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan VLOOKUP dari sheet lain?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.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\/vlookup-dari-lembar-lain\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/\",\"name\":\"Bagaimana cara menggunakan VLOOKUP dari sheet lain?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\",\"datePublished\":\"2023-10-22T04:56:33+00:00\",\"dateModified\":\"2023-12-06T06:19:07+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan vlookup dari sheet lain?\"}]},{\"@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":"Bagaimana cara menggunakan VLOOKUP dari sheet lain?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026","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\/vlookup-dari-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan VLOOKUP dari sheet lain?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.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\/vlookup-dari-lembar-lain\/","url":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/","name":"Bagaimana cara menggunakan VLOOKUP dari sheet lain?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png","datePublished":"2023-10-22T04:56:33+00:00","dateModified":"2023-12-06T06:19:07+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk melakukan VLOOKUP dari sheet lain. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/vlookup-dari-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan vlookup dari sheet lain?"}]},{"@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\/2058","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=2058"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2058\/revisions"}],"predecessor-version":[{"id":2812,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2058\/revisions\/2812"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}