{"id":4049,"date":"2023-07-13T22:47:58","date_gmt":"2023-07-13T22:47:58","guid":{"rendered":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/"},"modified":"2023-07-13T22:47:58","modified_gmt":"2023-07-13T22:47:58","slug":"vlookup-rumus-tabel-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/","title":{"rendered":"Cara menggunakan rumus array dengan vlookup di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk melakukan VLOOKUP dengan rumus array di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">E2:E8<\/span> , <span style=\"color: #ff0000;\">A2:C8,3<\/span> ,FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan mengembalikan nilai kolom ketiga rentang <strong>A2:C8<\/strong> di mana nilai rentang <strong>E2:E8<\/strong> sesuai dengan nilai rentang <strong>A2:A8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggunakan Rumus Array dengan VLOOKUP di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data dalam rentang <strong>A2:C8<\/strong> yang berisi informasi tentang berbagai tim bola basket, dan misalkan kita ingin mencari nilai di kolom &#8220;Rebound&#8221; untuk setiap tim dalam rentang <strong>E2:E8<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32323 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlook11.png\" alt=\"\" width=\"567\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan VLOOKUP dengan sel, kita dapat menemukan nilai \u201cRebounds\u201d untuk Kings:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">E2<\/span> , <span style=\"color: #ff0000;\">A2:C8,3<\/span> ,FALSE)<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32324 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlook12.png\" alt=\"\" width=\"603\" height=\"498\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda harus mengetikkan rumus ini beberapa kali untuk menemukan nilai &#8220;Rebound&#8221; masing-masing tim di kolom E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daripada memberikan nilai sel ke fungsi VLOOKUP, kita bisa menyediakan seluruh rentang sel di kolom E untuk menemukan nilai &#8220;Rebound&#8221; masing-masing tim sekaligus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <strong>G2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">E2:E8<\/span> , <span style=\"color: #ff0000;\">A2:C8,3<\/span> ,FALSE)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>Enter<\/strong> , nilai \u201cRebound\u201d untuk setiap tim akan dikembalikan secara bersamaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32325 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlook13.png\" alt=\"\" width=\"586\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Keuntungan menggunakan pendekatan ini adalah kita tidak perlu mengetikkan rumus VLOOKUP berkali-kali atau mengklik dan menyeret rumus ke beberapa sel untuk menghasilkan beberapa nilai.<\/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\/excel-vlookup-dari-buku-kerja-lain\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP dari Buku Kerja Lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-semua-kecocokan\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP untuk Mengembalikan Semua Kecocokan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-mengembalikan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP untuk Mengembalikan Banyak Kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk melakukan VLOOKUP dengan rumus array di Excel: =VLOOKUP( E2:E8 , A2:C8,3 ,FALSE) Rumus khusus ini akan mengembalikan nilai kolom ketiga rentang A2:C8 di mana nilai rentang E2:E8 sesuai dengan nilai rentang A2:A8 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Menggunakan Rumus Array dengan VLOOKUP [&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 menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array 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\/vlookup-rumus-tabel-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T22:47:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlook11.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\/vlookup-rumus-tabel-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/\",\"name\":\"Cara menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T22:47:58+00:00\",\"dateModified\":\"2023-07-13T22:47:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rumus array dengan vlookup 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 menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array 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\/vlookup-rumus-tabel-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T22:47:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlook11.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\/vlookup-rumus-tabel-excel\/","url":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/","name":"Cara menggunakan rumus array dengan VLOOKUP di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T22:47:58+00:00","dateModified":"2023-07-13T22:47:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi VLOOKUP dengan rumus array di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vlookup-rumus-tabel-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rumus array dengan vlookup 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\/4049"}],"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=4049"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4049\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}