{"id":4824,"date":"2023-07-07T13:07:25","date_gmt":"2023-07-07T13:07:25","guid":{"rendered":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/"},"modified":"2023-07-07T13:07:25","modified_gmt":"2023-07-07T13:07:25","slug":"indeks-excel-cocok-jika-sel-berisi-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/","title":{"rendered":"Excel: cara menggunakan index match jika sel berisi teks"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>INDEX<\/strong> dan <strong>MATCH<\/strong> di Excel untuk menemukan nilai tertentu di satu kolom dan mengembalikan nilai yang cocok di kolom lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut dengan <strong>INDEX<\/strong> dan <strong>MATCH<\/strong> untuk menemukan sel yang berisi teks tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">A2:B11<\/span> ,MATCH(\"*Warr*\", <span style=\"color: #ff0000;\">A2:A11,0<\/span> ),2)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mencari nilai dalam rentang <strong>A2:A11<\/strong> yang berisi substring &#8220;Warr&#8221; dan mengembalikan nilai terkait di kolom <strong>2<\/strong> rentang <strong>A2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Tanda bintang ( <strong>*<\/strong> ) digunakan sebagai wildcard. Artinya, karakter apa pun bisa muncul sebelum atau sesudah &#8220;Warr&#8221; di dalam sel.<\/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: Cara menggunakan INDEX MATCH jika sel berisi teks di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37663 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip1.png\" alt=\"\" width=\"462\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mencari substring &#8220;Warr&#8221; di kolom <strong>Tim<\/strong> dan mengembalikan nilai yang sesuai di kolom <strong>Poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <b>G4<\/b> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">A2:B11<\/span> ,MATCH(\"*Warr*\", <span style=\"color: #ff0000;\">A2:A11,0<\/span> ),2)<\/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-37664\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip2.png\" alt=\"Excel INDEX MATCH jika sel berisi teks\" width=\"601\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan <strong>18<\/strong> , yang merupakan nilai di kolom <strong>Poin<\/strong> yang sesuai dengan tim dengan nama &#8220;Warr&#8221;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37665 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip3.png\" alt=\"\" width=\"602\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga bisa menggunakan rumus berikut untuk mencari nama lengkap tim, bukan hanya substring:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">A2:B11<\/span> ,MATCH(\"Warriors\", <span style=\"color: #ff0000;\">A2:A11,0<\/span> ),2)<\/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=\" wp-image-37667 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip4.png\" alt=\"\" width=\"549\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini juga mengembalikan <strong>18<\/strong> , yang merupakan nilai poin yang sesuai dengan Warriors.<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/unggul-jika-indeks-cocok\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan fungsi IF dengan INDEX MATCH<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kecocokan-indeks-jumlah-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan SUM dengan INDEX MATCH<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kecocokan-indeks-mengembalikan-beberapa-nilai-secara-vertikal\/\" target=\"_blank\" rel=\"noopener\">Excel: Gunakan INDEX dan MATCH untuk Mengembalikan Beberapa Nilai Secara Vertikal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi INDEX dan MATCH di Excel untuk menemukan nilai tertentu di satu kolom dan mengembalikan nilai yang cocok di kolom lain. Anda dapat menggunakan sintaks berikut dengan INDEX dan MATCH untuk menemukan sel yang berisi teks tertentu: =INDEX( A2:B11 ,MATCH(&#8220;*Warr*&#8221;, A2:A11,0 ),2) Rumus khusus ini mencari nilai dalam rentang A2:A11 yang berisi [&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>Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, 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\/indeks-excel-cocok-jika-sel-berisi-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T13:07:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip1.png\" \/>\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\/indeks-excel-cocok-jika-sel-berisi-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/\",\"name\":\"Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T13:07:25+00:00\",\"dateModified\":\"2023-07-07T13:07:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan index match jika sel berisi teks\"}]},{\"@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":"Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials","description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, 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\/indeks-excel-cocok-jika-sel-berisi-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-07T13:07:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ip1.png"}],"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\/indeks-excel-cocok-jika-sel-berisi-teks\/","url":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/","name":"Excel: Cara menggunakan INDEX MATCH jika sel berisi teks - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T13:07:25+00:00","dateModified":"2023-07-07T13:07:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH jika sel berisi teks di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/indeks-excel-cocok-jika-sel-berisi-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan index match jika sel berisi teks"}]},{"@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\/4824"}],"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=4824"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4824\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}