{"id":3415,"date":"2023-07-17T14:49:22","date_gmt":"2023-07-17T14:49:22","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/"},"modified":"2023-07-17T14:49:22","modified_gmt":"2023-07-17T14:49:22","slug":"google-sheet-vlookup-mengembalikan-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/","title":{"rendered":"Google spreadsheet: gunakan vlookup untuk mengembalikan beberapa kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut dengan fungsi <strong>VLOOKUP<\/strong> di Google Spreadsheet untuk mencari nilai dalam suatu rentang dan mengembalikan nilai yang cocok dari beberapa kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ArrayFormula(VLOOKUP( <span style=\"color: #ff6600;\">A14<\/span> , <span style=\"color: #800080;\">A2:D11<\/span> , { <span style=\"color: #3366ff;\">2<\/span> , <span style=\"color: #3366ff;\">4<\/span> }, <span style=\"color: #3366ff;\">FALSE<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan nilai di sel <strong>A14<\/strong> dalam rentang <strong>A2:D11<\/strong> dan mengembalikan nilai yang sesuai di kolom <strong>2<\/strong> dan <strong>4<\/strong> rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Argumen <strong>FALSE<\/strong> memberitahu Google Sheets untuk mencari pencocokan tepat, bukan pencocokan fuzzy.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan VLOOKUP untuk mengembalikan beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menampilkan informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28628 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult1.jpg\" alt=\"\" width=\"579\" height=\"490\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut dengan <strong>VLOOKUP<\/strong> untuk menemukan tim &#8220;Blazer&#8221; di kolom A dan mengembalikan nilai poin dan rebound yang sesuai:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ArrayFormula(VLOOKUP( <span style=\"color: #ff6600;\">A14<\/span> , <span style=\"color: #800080;\">A2:D11<\/span> , { <span style=\"color: #3366ff;\">2<\/span> , <span style=\"color: #3366ff;\">4<\/span> }, <span style=\"color: #3366ff;\">FALSE<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28629\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult2.jpg\" alt=\"Google Sheets VLOOKUP mengembalikan beberapa kolom\" width=\"562\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus <strong>VLOOKUP<\/strong> mengembalikan nilai dalam kolom poin dan rebound untuk baris di mana tim memiliki nama &#8220;Blazer&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita mengubah nama tim di sel <strong>A14<\/strong> , rumusnya akan secara otomatis menemukan nilai poin dan rebound tim baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mengubah nama tim menjadi Warriors:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28630 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult3.jpg\" alt=\"\" width=\"573\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus <strong>VLOOKUP<\/strong> sekarang mengembalikan nilai dalam kolom poin dan rebound untuk baris di mana tim memiliki nama &#8220;Prajurit&#8221;.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-vlookup-dari-buku-kerja-lain\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menggunakan VLOOKUP dari buku kerja lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-semua-kecocokan\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan semua kecocokan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-vlookup-beberapa-kriteria\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Gunakan VLOOKUP dengan Banyak Kriteria<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut dengan fungsi VLOOKUP di Google Spreadsheet untuk mencari nilai dalam suatu rentang dan mengembalikan nilai yang cocok dari beberapa kolom: =ArrayFormula(VLOOKUP( A14 , A2:D11 , { 2 , 4 }, FALSE )) Rumus khusus ini menemukan nilai di sel A14 dalam rentang A2:D11 dan mengembalikan nilai yang sesuai di kolom [&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>Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk 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\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T14:49:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult1.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\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/\",\"name\":\"Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T14:49:22+00:00\",\"dateModified\":\"2023-07-17T14:49:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: gunakan vlookup untuk mengembalikan beberapa kolom\"}]},{\"@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":"Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk 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\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-17T14:49:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult1.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\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/","name":"Google Spreadsheet: Gunakan VLOOKUP untuk mengembalikan beberapa kolom \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T14:49:22+00:00","dateModified":"2023-07-17T14:49:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP untuk mengembalikan beberapa kolom di Google Sheets, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-vlookup-mengembalikan-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: gunakan vlookup untuk mengembalikan beberapa kolom"}]},{"@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\/3415"}],"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=3415"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3415\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}