{"id":2800,"date":"2023-07-20T15:45:30","date_gmt":"2023-07-20T15:45:30","guid":{"rendered":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/"},"modified":"2023-07-20T15:45:30","modified_gmt":"2023-07-20T15:45:30","slug":"pencarian-terbalik-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/","title":{"rendered":"Bagaimana melakukan reverse vlookup di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan VLOOKUP terbalik di Google Sheets.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Membalikkan VLOOKUP di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan jumlah poin yang dicetak oleh berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24588 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inversev1.jpg\" alt=\"\" width=\"485\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus <strong>VLOOKUP<\/strong> berikut untuk mencari jumlah poin yang terkait dengan tim &#8220;Knicks&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP(\u201c <span style=\"color: #008000;\">Knicks<\/span> \u201d, <span style=\"color: #ff6600;\">A1:B9<\/span> , <span style=\"color: #3366ff;\">2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Inilah yang dilakukan rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Dia mengidentifikasi <strong>Knicks<\/strong> sebagai nilai yang bisa ditemukan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini menentukan <strong>A1:B9<\/strong> sebagai rentang yang akan dianalisis.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini menentukan bahwa kita ingin mengembalikan nilai di kolom <strong>ke-2<\/strong> dari kiri.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24589 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inversev2.jpg\" alt=\"\" width=\"514\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini mengembalikan nilai <strong>99<\/strong> dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, katakanlah kita malah ingin mengetahui tim mana yang memiliki nilai poin <strong>99<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus <strong>VLOOKUP terbalik<\/strong> berikut ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=VLOOKUP( <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">99<\/span> , { <span dir=\"auto\" style=\"color: #ff6600;\">B2:B9<\/span> , <span dir=\"auto\" style=\"color: #800080;\">A2:A9<\/span> }, <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">2<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Inilah yang dilakukan rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ini mengidentifikasi <strong>99<\/strong> sebagai nilai yang akan dicari.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini menentukan <strong>B2:B9<\/strong> dan <strong>A2:A9<\/strong> sebagai rentang yang akan dianalisis.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ini menentukan bahwa kita ingin mengembalikan nilai di kolom <strong>ke-2<\/strong> dari kanan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Berikut cara menggunakan rumus ini dalam praktiknya:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24590\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inversev3.jpg\" alt=\"membalikkan VLOOKUP di Google Spreadsheet\" width=\"536\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus tersebut dengan tepat mengidentifikasi <strong>Knicks<\/strong> sebagai tim dengan nilai poin <strong>99<\/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\/lembar-google-vlookup-peka-huruf-besar-kecil\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a><br \/> <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>Tutorial ini menjelaskan cara melakukan VLOOKUP terbalik di Google Sheets. Contoh: Membalikkan VLOOKUP di Google Spreadsheet Misalkan kita memiliki kumpulan data berikut yang menunjukkan jumlah poin yang dicetak oleh berbagai tim bola basket: Kita dapat menggunakan rumus VLOOKUP berikut untuk mencari jumlah poin yang terkait dengan tim &#8220;Knicks&#8221;: =VLOOKUP(\u201c Knicks \u201d, A1:B9 , 2 ) [&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 Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membalikkan pencarian 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\/pencarian-terbalik-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membalikkan pencarian di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T15:45:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inversev1.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\/pencarian-terbalik-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/\",\"name\":\"Cara Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T15:45:30+00:00\",\"dateModified\":\"2023-07-20T15:45:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membalikkan pencarian di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana melakukan reverse 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 Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara membalikkan pencarian 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\/pencarian-terbalik-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membalikkan pencarian di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T15:45:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inversev1.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\/pencarian-terbalik-google-sheet\/","url":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/","name":"Cara Melakukan Reverse VLOOKUP di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T15:45:30+00:00","dateModified":"2023-07-20T15:45:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membalikkan pencarian di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencarian-terbalik-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana melakukan reverse 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\/2800"}],"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=2800"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2800\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}