{"id":4327,"date":"2023-07-11T23:37:39","date_gmt":"2023-07-11T23:37:39","guid":{"rendered":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/"},"modified":"2023-07-11T23:37:39","modified_gmt":"2023-07-11T23:37:39","slug":"pencocokan-indeks-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/","title":{"rendered":"Vba: cara menggunakan pencocokan indeks"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk melakukan INDEX MATCH di VBA:<\/span><\/p>\n

 SubIndexMatch<\/span> ()\n\n    Dim<\/span> i As<\/span> Integer\n    \n    ' Perform index match<\/span>\n    For<\/span> i = 2 To<\/span> 11\n    Cells(i, 5).Value = WorksheetFunction.Index(Range(\" A2:A11<\/span> \"), _\n    WorksheetFunction.Match(Cells(i, 4).Value, Range(\" B2:B11<\/span> \"), 0))\n    Next<\/span> i\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini mencari nilai dalam sel 2 hingga 11 kolom keempat lembar kerja dalam rentang B2:B11<\/strong> , lalu mengembalikan nilai terkait dalam rentang A2:A11<\/strong> di kolom kelima lembar kerja.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Lakukan INDEX MATCH menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk setiap pemain di kolom D, misalkan kita ingin mencari nama timnya di kolom A, maka tuliskan nama tim di kolom E.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubIndexMatch<\/span> ()\n\n    Dim<\/span> i As<\/span> Integer\n    \n    ' Perform index match<\/span>\n    For<\/span> i = 2 To<\/span> 11\n    Cells(i, 5).Value = WorksheetFunction.Index(Range(\" A2:A11<\/span> \"), _\n    WorksheetFunction.Match(Cells(i, 4).Value, Range(\" B2:B11<\/span> \"), 0))\n    Next<\/span> i\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa makro ini dapat mencari nama setiap pemain dan kemudian mengembalikan nama tim terkait di kolom E.<\/span><\/p>\n
 Perhatikan bahwa dalam perulangan For, sintaks Cells(i,5).value<\/strong> menetapkan bahwa kita ingin nama tim dikembalikan di kolom kelima spreadsheet, yaitu kolom E.<\/span><\/span><\/p>\n
 Jika kita mengubah sintaks ini menjadi Cells(i,6).value<\/strong> maka nama tim akan dikembalikan di kolom keenam spreadsheet:<\/span><\/p>\n
 SubIndexMatch<\/span> ()\n\n    Dim<\/span> i As<\/span> Integer\n    \n    ' Perform index match<\/span>\n    For<\/span> i = 2 To<\/span> 11\n    Cells(i, 6).Value = WorksheetFunction.Index(Range(\" A2:A11<\/span> \"), _\n    WorksheetFunction.Match(Cells(i, 4).Value, Range(\" B2:B11<\/span> \"), 0))\n    Next<\/span> i\nEnd<\/span> Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa nama tim kini dikembalikan ke kolom keenam spreadsheet (kolom F).<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: cara memeriksa apakah suatu string berisi string lain<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan INDEX MATCH di VBA: SubIndexMatch () Dim i As Integer ‘ Perform index match For i = 2 To 11 Cells(i, 5).Value = WorksheetFunction.Index(Range(” A2:A11 “), _ WorksheetFunction.Match(Cells(i, 4).Value, Range(” B2:B11 “), 0)) Next i End Sub Contoh khusus ini mencari nilai dalam sel 2 hingga 11 […]<\/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":"\nVBA: Cara menggunakan INDEX MATCH - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA 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\/pencocokan-indeks-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan INDEX MATCH - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T23:37:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_indexmatch1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/\",\"name\":\"VBA: Cara menggunakan INDEX MATCH - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T23:37:39+00:00\",\"dateModified\":\"2023-07-11T23:37:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan pencocokan indeks\"}]},{\"@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":"VBA: Cara menggunakan INDEX MATCH - Statologi","description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA 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\/pencocokan-indeks-vba\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan INDEX MATCH - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T23:37:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_indexmatch1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/","url":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/","name":"VBA: Cara menggunakan INDEX MATCH - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T23:37:39+00:00","dateModified":"2023-07-11T23:37:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan INDEX dan MATCH pada VBA di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan pencocokan indeks"}]},{"@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\/4327"}],"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=4327"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4327\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}