{"id":2736,"date":"2023-07-20T22:57:21","date_gmt":"2023-07-20T22:57:21","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/"},"modified":"2023-07-20T22:57:21","modified_gmt":"2023-07-20T22:57:21","slug":"lembar-google-vlookup-peka-huruf-besar-kecil","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/","title":{"rendered":"Cara menggunakan vlookup peka huruf besar-kecil di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus dasar berikut untuk melakukan VLOOKUP peka huruf besar-kecil 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\">INDEX<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">MATCH<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">TRUE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">EXACT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">G2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">A2:A10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">0<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus khusus ini menemukan nilai pasti di sel <strong>G2<\/strong> dalam rentang <strong>A2:A10<\/strong> dan mengembalikan nilai terkait dalam rentang <strong>B2:B10<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan jumlah penjualan yang dilakukan oleh tenaga penjualan berbeda di suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24093 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev11.jpg\" alt=\"\" width=\"477\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita mencoba menggunakan rumus VLOOKUP berikut untuk mencari &#8220;Andy&#8221; dan mengembalikan jumlah penjualannya:<\/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\">B10,2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini salah mengembalikan jumlah penjualan untuk <strong>ANDY<\/strong> dan bukan <strong>Andy<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24094 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev12.jpg\" alt=\"\" width=\"556\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Sebagai gantinya, kita perlu menggunakan rumus berikut yang dapat menjalankan VLOOKUP peka huruf besar-kecil:<\/span><\/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\">INDEX<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">MATCH<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">TRUE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">EXACT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">G2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">A2:A10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">0<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini dengan tepat mengembalikan jumlah penjualan <strong>Andy<\/strong> , yang ternyata adalah <strong>29<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24095\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev13.jpg\" alt=\"VLOOKUP peka huruf besar-kecil di Google Spreadsheet\" width=\"579\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengembalikan jumlah penjualan untuk <strong>Andy<\/strong> , bukan <strong>ANDY<\/strong> .<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-sel-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung sel dengan teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menggantikan-teks\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti teks di Google Sheets<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/filter-google-sheet-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter sel yang berisi teks di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus dasar berikut untuk melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet: = INDEX ( B2:B10 , MATCH ( TRUE , EXACT ( G2 , A2:A10 ) , 0 ) ) Rumus khusus ini menemukan nilai pasti di sel G2 dalam rentang A2:A10 dan mengembalikan nilai terkait dalam rentang B2:B10 . Contoh [&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 VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.\" \/>\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\/lembar-google-vlookup-peka-huruf-besar-kecil\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:57:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev11.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\/lembar-google-vlookup-peka-huruf-besar-kecil\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/\",\"name\":\"Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:57:21+00:00\",\"dateModified\":\"2023-07-20T22:57:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan vlookup peka huruf besar-kecil di google spreadsheet\"}]},{\"@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 VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.","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\/lembar-google-vlookup-peka-huruf-besar-kecil\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:57:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev11.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\/lembar-google-vlookup-peka-huruf-besar-kecil\/","url":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/","name":"Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:57:21+00:00","dateModified":"2023-07-20T22:57:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan VLOOKUP peka huruf besar-kecil di Google Spreadsheet, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-google-vlookup-peka-huruf-besar-kecil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan vlookup peka huruf besar-kecil di google spreadsheet"}]},{"@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\/2736"}],"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=2736"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2736\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}