{"id":2861,"date":"2023-07-20T08:57:46","date_gmt":"2023-07-20T08:57:46","guid":{"rendered":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/"},"modified":"2023-07-20T08:57:46","modified_gmt":"2023-07-20T08:57:46","slug":"iferror-vlookup-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/","title":{"rendered":"Cara menggunakan iferror dengan vlookup di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut dengan IFERROR<\/strong> dan VLOOKUP<\/strong> di Google Spreadsheet untuk mengembalikan nilai selain #N\/A ketika fungsi VLOOKUP tidak menemukan nilai tertentu dalam suatu rentang:<\/span><\/p>\n

 =<\/span> IFERROR<\/span> (<\/span> VLOOKUP<\/span> (<\/span> \" string<\/span> \"<\/span> ,<\/span> A2:B11<\/span> ,<\/span> 2<\/span> ,<\/span> FALSE<\/span> )<\/span> ,<\/span> \" Does Not Exist<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini mencari “string” dalam rentang A2:B11 dan mencoba mengembalikan nilai yang sesuai di kolom kedua rentang tersebut.<\/span><\/p>\n
 Jika tidak menemukan “string”, ia hanya mengembalikan “Tidak ada” dan bukan nilai #N\/A.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Gunakan IFERROR dengan VLOOKUP di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki kumpulan data berikut yang menunjukkan jumlah poin yang dicetak oleh berbagai tim bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita menggunakan rumus VLOOKUP<\/strong> berikut untuk mencari jumlah poin yang terkait dengan tim “Raptors”:<\/span><\/p>\n
 =<\/span> VLOOKUP<\/span> (<\/span> \u201c Raptors<\/span> \u201d<\/span> ,<\/span> A2:B11<\/span> ,<\/span> 2<\/span> ,<\/span> FALSE<\/span> )<\/span>\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"\"<\/p>\n
 Rumus ini mengembalikan nilai #N\/A<\/strong> karena “Raptors” tidak ada di kolom Tim.<\/span><\/p>\n
 Namun, kita dapat menggunakan fungsi IFERROR<\/strong> berikut dengan fungsi VLOOKUP<\/strong> untuk mengembalikan nilai “Tidak Ada” dan bukan #N\/A<\/strong> :<\/span><\/p>\n
 =IFERROR(VLOOKUP(\" Raptors<\/span> \", A2:B11<\/span> , 2<\/span> , FALSE<\/span> ), \" Does Not Exist<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"VLOOKUP<\/p>\n
 Karena “Raptors” tidak ada di kolom Tim, rumusnya mengembalikan nilai “Tidak ada” dan bukan nilai #N\/A<\/strong> .<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a>
 Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut dengan IFERROR dan VLOOKUP di Google Spreadsheet untuk mengembalikan nilai selain #N\/A ketika fungsi VLOOKUP tidak menemukan nilai tertentu dalam suatu rentang: = IFERROR ( VLOOKUP ( ” string ” , A2:B11 , 2 , FALSE ) , ” Does Not Exist ” ) Rumus khusus ini mencari “string” dalam […]<\/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":"\nCara menggunakan IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta 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\/iferror-vlookup-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 IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T08:57:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sierreur1.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\/iferror-vlookup-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/\",\"name\":\"Cara menggunakan IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T08:57:46+00:00\",\"dateModified\":\"2023-07-20T08:57:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan iferror dengan 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 menggunakan IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta 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\/iferror-vlookup-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-20T08:57:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sierreur1.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\/iferror-vlookup-lembar-google\/","url":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/","name":"Cara menggunakan IFERROR dengan VLOOKUP di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T08:57:46+00:00","dateModified":"2023-07-20T08:57:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan IFERROR pada fungsi VLOOKUP di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/iferror-vlookup-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan iferror dengan 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\/2861"}],"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=2861"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2861\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}