{"id":2715,"date":"2023-07-21T01:22:24","date_gmt":"2023-07-21T01:22:24","guid":{"rendered":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/"},"modified":"2023-07-21T01:22:24","modified_gmt":"2023-07-21T01:22:24","slug":"xlookup-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/","title":{"rendered":"Cara menggunakan xlookup di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <strong>XLOOKUP<\/strong> di Google Spreadsheet dapat digunakan untuk mencari nilai dalam suatu rentang dan mengembalikan nilai yang cocok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>=XLOOKUP(kunci_penelusuran, rentang_pencarian, rentang_hasil)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>search_key<\/strong> : Nilai yang akan dicari.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>lookup_range<\/strong> : Rentang pencarian.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>result_range<\/strong> : Rentang yang berisi nilai yang akan dikembalikan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan XLOOKUP di Google Sheets<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33906 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/x1.jpg\" alt=\"\" width=\"510\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>XLOOKUP<\/strong> berikut di Google Spreadsheet untuk mencari nilai di <strong>E2<\/strong> dalam rentang <strong>A2:A11<\/strong> dan mengembalikan nilai terkait dalam rentang <strong>C2:C11<\/strong> :<\/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\">XLOOKUP<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">E2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">C2:C11<\/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-33907\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/x2.jpg\" alt=\"Fungsi XLOOKUP dalam contoh Google Sheets\" width=\"647\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>XLOOKUP<\/strong> mencari nilai &#8220;Rockets&#8221; di kolom A dan mengembalikan nilai yang sesuai di kolom &#8220;Points&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat menggunakan argumen keempat dalam fungsi <strong>XLOOKUP<\/strong> untuk menentukan nilai apa yang harus dikembalikan jika tidak ditemukan kecocokan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Defaultnya adalah mengembalikan <strong>#N\/A<\/strong> jika tidak ditemukan kecocokan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan rumus berikut untuk mengembalikan &#8220;Tidak Ditemukan&#8221; jika tidak ditemukan kecocokan:<\/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\">XLOOKUP<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">E2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">C2:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \" <span style=\"color: #008000;\">Not Found<\/span> \")<\/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-33908\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/x3.jpg\" alt=\"Fungsi Google Sheets XLOOKUP dengan nilai yang hilang\" width=\"657\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena &#8220;Asisten&#8221; tidak ada di kolom A, &#8220;Tidak Ditemukan&#8221; dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>XLOOKUP<\/strong> <a href=\"https:\/\/support.google.com\/docs\/answer\/12405947?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara mengekstrak nilai N pertama dari rentang<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/filter-google-sheet-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara memfilter sel yang berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-nomor-saluran\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara mengekstrak angka dari string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi XLOOKUP di Google Spreadsheet dapat digunakan untuk mencari nilai dalam suatu rentang dan mengembalikan nilai yang cocok. Fungsi ini menggunakan sintaks dasar berikut: =XLOOKUP(kunci_penelusuran, rentang_pencarian, rentang_hasil) Emas: search_key : Nilai yang akan dicari. lookup_range : Rentang pencarian. result_range : Rentang yang berisi nilai yang akan dikembalikan. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam [&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 XLOOKUP di Google Sheets (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara 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\/xlookup-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 XLOOKUP di Google Sheets (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/xlookup-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T01:22:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/x1.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\/xlookup-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/xlookup-lembar-google\/\",\"name\":\"Cara Menggunakan XLOOKUP di Google Sheets (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T01:22:24+00:00\",\"dateModified\":\"2023-07-21T01:22:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/xlookup-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/xlookup-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/xlookup-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan xlookup di google sheets (dengan contoh)\"}]},{\"@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 XLOOKUP di Google Sheets (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara 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\/xlookup-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan XLOOKUP di Google Sheets (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-21T01:22:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/x1.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\/xlookup-lembar-google\/","url":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/","name":"Cara Menggunakan XLOOKUP di Google Sheets (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T01:22:24+00:00","dateModified":"2023-07-21T01:22:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi XLOOKUP yang setara di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/xlookup-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/xlookup-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan xlookup di google sheets (dengan contoh)"}]},{"@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\/2715"}],"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=2715"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2715\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}