{"id":2957,"date":"2023-07-19T22:06:24","date_gmt":"2023-07-19T22:06:24","guid":{"rendered":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/"},"modified":"2023-07-19T22:06:24","modified_gmt":"2023-07-19T22:06:24","slug":"arrayformula-vlookup-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/","title":{"rendered":"Cara menggunakan arrayformula dengan vlookup di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi ARRAYFORMULA<\/strong> dengan fungsi VLOOKUP<\/strong> di Google Sheets:<\/span><\/p>\n

 =<\/span> ARRAYFORMULA<\/span> (<\/span> VLOOKUP<\/span> (<\/span> E2:E11<\/span> ,<\/span> A2:C11<\/span> ,<\/span> 3<\/span> ,<\/span> FALSE<\/span> )<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini mencari nilai E2:E11<\/strong> dalam rentang A2:C11<\/strong> dan mengembalikan nilai kolom ketiga dalam rentang tersebut.<\/span><\/p>\n
 Keuntungan menggunakan ARRAYFORMULA<\/strong> adalah kita dapat melakukan VLOOKUP<\/strong> untuk setiap nilai di E2:E11 tanpa menulis rumus VLOOKUP<\/strong> satu per satu untuk setiap sel di kolom E.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat menggunakan ARRAYFORMULA<\/strong> dengan VLOOKUP<\/strong> untuk menemukan setiap tim di kolom E dan mengembalikan nilai rebound yang sesuai di kolom F:<\/span><\/p>\n
 =<\/span> ARRAYFORMULA<\/span> (<\/span> VLOOKUP<\/span> (<\/span> E2:E11<\/span> ,<\/span> A2:C11<\/span> ,<\/span> 3<\/span> ,<\/span> FALSE<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Kita bisa mengetikkan rumus ini sekali di sel F2<\/strong> dan tekan ENTER<\/strong> , dan nilai rebound untuk setiap tim akan dikembalikan:<\/span><\/span> <\/p>\n
\"ARRAYFORMULA<\/p>\n
 Ini memberikan cara yang lebih cepat untuk mengembalikan nilai pentalan untuk setiap tim daripada mengetikkan fungsi VLOOKUP<\/strong> individual ke setiap sel di kolom F atau bahkan mengklik dan menyeret rumus dari sel F2<\/strong> ke setiap sel di kolom F.<\/span><\/p>\n
 Catatan:<\/b> Anda dapat menemukan dokumentasi lengkap untuk fungsi ARRAYFORMULA<\/strong> di Google Spreadsheet di sini<\/a> .<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan IFERROR dengan VLOOKUP di Google Sheets<\/a>
Bagaimana Melakukan Reverse VLOOKUP di Google Sheets<\/a>
 Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets: = ARRAYFORMULA ( VLOOKUP ( E2:E11 , A2:C11 , 3 , FALSE ) ) Rumus khusus ini mencari nilai E2:E11 dalam rentang A2:C11 dan mengembalikan nilai kolom ketiga dalam rentang tersebut. Keuntungan menggunakan ARRAYFORMULA adalah kita dapat melakukan VLOOKUP untuk […]<\/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":"\nCara menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, 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\/arrayformula-vlookup-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T22:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau1.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\/arrayformula-vlookup-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/\",\"name\":\"Cara menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T22:06:24+00:00\",\"dateModified\":\"2023-07-19T22:06:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan arrayformula dengan vlookup di google sheets\"}]},{\"@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 ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, 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\/arrayformula-vlookup-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-19T22:06:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau1.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\/arrayformula-vlookup-lembar-google\/","url":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/","name":"Cara menggunakan ARRAYFORMULA dengan VLOOKUP di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T22:06:24+00:00","dateModified":"2023-07-19T22:06:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan ARRAYFORMULA dengan fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/arrayformula-vlookup-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan arrayformula dengan vlookup di google sheets"}]},{"@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\/2957"}],"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=2957"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2957\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}