{"id":4328,"date":"2023-07-11T23:21:43","date_gmt":"2023-07-11T23:21:43","guid":{"rendered":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/"},"modified":"2023-07-11T23:21:43","modified_gmt":"2023-07-11T23:21:43","slug":"indeks-vba-beberapa-kriteria-kecocokan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/","title":{"rendered":"Vba: cara menggunakan index match dengan berbagai kriteria"},"content":{"rendered":"

<\/p>\n

\n

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

 SubIndexMatchMultiple<\/span> ()\n    Range(\" F3<\/span> \").Value = WorksheetFunction.Index(Range(\" C2:C10<\/span> \"), _\n    WorksheetFunction.Match(Range(\" F1<\/span> \"), Range(\" A2:A10<\/span> \"), 0) + _\n    WorksheetFunction.Match(Range(\" F2<\/span> \"), Range(\" B2:B10<\/span> \"), 0) - 1)\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini mencari nilai dalam sel F1<\/strong> dalam rentang A2:A10<\/strong> dan nilai dalam sel F2<\/strong> dalam rentang B2:B10<\/strong> dan mengembalikan nilai terkait dalam rentang C2:C10<\/strong> dalam sel F3<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Lakukan INDEX MATCH dengan beberapa kriteria 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
 Misalkan kita ingin mencari pemain yang cocok dengan nama tim di sel F1<\/strong> dan posisinya di sel F2<\/strong> dan mengembalikan nama di sel F3<\/strong> .<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubIndexMatchMultiple<\/span> ()\n    Range(\" F3<\/span> \").Value = WorksheetFunction.Index(Range(\" C2:C10<\/span> \"), _\n    WorksheetFunction.Match(Range(\" F1<\/span> \"), Range(\" A2:A10<\/span> \"), 0) + _\n    WorksheetFunction.Match(Range(\" F2<\/span> \"), Range(\" B2:B10<\/span> \"), 0) - 1)\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Makro mencari “Spurs” di kolom Tim dan “Maju” di kolom Posisi dan mengembalikan nama “Eric” di sel F3<\/strong> dengan benar.<\/span><\/span><\/p>\n
 Jika kita mengubah nilai di sel F1<\/strong> dan F2<\/strong> dan menjalankan makro lagi, nama pemain akan dapat ditemukan berdasarkan nilai baru.<\/span><\/span><\/p>\n
 Misalnya, kita mengubah nama tim menjadi “Mavs” dan posisinya menjadi “Tengah” dan menjalankan makro lagi:<\/span> <\/p>\n
\"\"<\/p>\n
 Makro mencari “Mavs” di kolom Tim dan “Tengah” di kolom Posisi dan mengembalikan nama “Chad” di sel F3<\/strong> dengan benar.<\/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 menggunakan pencocokan indeks<\/a>
 VBA: cara memeriksa apakah suatu string berisi string lain<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan INDEX MATCH dengan beberapa kriteria di VBA: SubIndexMatchMultiple () Range(” F3 “).Value = WorksheetFunction.Index(Range(” C2:C10 “), _ WorksheetFunction.Match(Range(” F1 “), Range(” A2:A10 “), 0) + _ WorksheetFunction.Match(Range(” F2 “), Range(” B2:B10 “), 0) – 1) End Sub Contoh khusus ini mencari nilai dalam sel F1 dalam rentang […]<\/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 dengan berbagai kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.\" \/>\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-vba-beberapa-kriteria-kecocokan\/\" \/>\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 dengan berbagai kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T23:21:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_index1.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\/indeks-vba-beberapa-kriteria-kecocokan\/\",\"url\":\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/\",\"name\":\"VBA: Cara menggunakan INDEX MATCH dengan berbagai kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T23:21:43+00:00\",\"dateModified\":\"2023-07-11T23:21:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan index match dengan berbagai kriteria\"}]},{\"@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 dengan berbagai kriteria - Statorial","description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.","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-vba-beberapa-kriteria-kecocokan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan INDEX MATCH dengan berbagai kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T23:21:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_index1.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\/indeks-vba-beberapa-kriteria-kecocokan\/","url":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/","name":"VBA: Cara menggunakan INDEX MATCH dengan berbagai kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T23:21:43+00:00","dateModified":"2023-07-11T23:21:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan INDEX MATCH dengan beberapa kriteria di VBA, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan index match dengan berbagai kriteria"}]},{"@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\/4328"}],"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=4328"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4328\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}