{"id":3456,"date":"2023-07-17T09:42:53","date_gmt":"2023-07-17T09:42:53","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/"},"modified":"2023-07-17T09:42:53","modified_gmt":"2023-07-17T09:42:53","slug":"tanggal-vlookup-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/","title":{"rendered":"Google spreadsheet: cara menggunakan vlookup berdasarkan tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menggunakan VLOOKUP berdasarkan tanggal di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">VLOOKUP<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">D2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">A2<\/span> <span dir=\"auto\" style=\"color: #800080;\">:<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">B9,2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">FALSE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan tanggal di sel <strong>D2<\/strong> dalam rentang <strong>A2:B9<\/strong> dan mengembalikan nilai yang sesuai di kolom <strong>2<\/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: Menggunakan VLOOKUP berdasarkan tanggal di Google Sheets<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan total penjualan suatu produk pada tanggal berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28874 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdate1.jpg\" alt=\"\" width=\"491\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut dengan <strong>VLOOKUP<\/strong> untuk menemukan nilai tanggal di sel D2 kolom A dan mengembalikan nilai penjualan terkait di kolom B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">VLOOKUP<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">D2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">A2<\/span> <span dir=\"auto\" style=\"color: #800080;\">:<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">B9,2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">FALSE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/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-28875\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdate2.jpg\" alt=\"VLOOKUP Google Spreadsheet berdasarkan tanggal\" width=\"559\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus <strong>VLOOKUP<\/strong> mengembalikan 12, yang merupakan nilai penjualan yang sesuai dengan tanggal 26\/05\/2022 di kumpulan data asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus ini mengasumsikan bahwa nilai di kolom A berada dalam format tanggal yang valid dan nilai yang kita berikan ke rumus <strong>VLOOKUP<\/strong> juga dalam format tanggal yang valid.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai yang kita berikan pada rumus <strong>VLOOKUP<\/strong> tidak valid, maka rumus tersebut hanya akan mengembalikan <strong>#N\/A<\/strong> sebagai hasilnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28876 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdate3.jpg\" alt=\"\" width=\"567\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena 26\/05\/2022 bukan format rumus tanggal yang valid, <strong>VLOOKUP<\/strong> akan mengembalikan <strong>#N\/A<\/strong> sesuai dengan itu.<\/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 untuk menggunakan VLOOKUP berdasarkan tanggal di Google Spreadsheet: = VLOOKUP ( D2 , A2 : B9,2 , FALSE ) Rumus khusus ini menemukan tanggal di sel D2 dalam rentang A2:B9 dan mengembalikan nilai yang sesuai di kolom 2 rentang tersebut. Catatan : Argumen FALSE memberitahu Google Sheets untuk mencari pencocokan [&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: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan 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\/tanggal-vlookup-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T09:42:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdate1.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\/tanggal-vlookup-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/\",\"name\":\"Google Spreadsheet: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T09:42:53+00:00\",\"dateModified\":\"2023-07-17T09:42:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menggunakan vlookup berdasarkan tanggal\"}]},{\"@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: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial","description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan 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\/tanggal-vlookup-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-17T09:42:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookupdate1.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\/tanggal-vlookup-google-sheet\/","url":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/","name":"Google Spreadsheet: Cara menggunakan VLOOKUP berdasarkan tanggal - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T09:42:53+00:00","dateModified":"2023-07-17T09:42:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VLOOKUP berdasarkan tanggal di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-vlookup-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menggunakan vlookup berdasarkan tanggal"}]},{"@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\/3456"}],"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=3456"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3456\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}