{"id":207,"date":"2025-02-06T09:54:32","date_gmt":"2025-02-06T17:54:32","guid":{"rendered":"https:\/\/idealwebid.com\/artikel\/?p=207"},"modified":"2025-02-06T09:55:26","modified_gmt":"2025-02-06T17:55:26","slug":"rumus-vlookup-dan-hlookup-mudah-di-excel","status":"publish","type":"post","link":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/","title":{"rendered":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel"},"content":{"rendered":"\n

VLOOKUP (Vertical Lookup) dan HLOOKUP (Horizontal Lookup) adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom (untuk VLOOKUP) atau baris (untuk HLOOKUP). Kedua fungsi ini sangat berguna ketika kita ingin mengambil informasi terkait dari tabel yang lebih besar berdasarkan nilai tertentu.<\/p>\n\n\n\n

VLOOKUP<\/h3>\n\n\n\n

Fungsi VLOOKUP<\/strong> digunakan untuk mencari data di kolom pertama dari tabel dan mengembalikan nilai dari kolom lain pada baris yang sama. Sintaksnya adalah sebagai berikut:<\/p>\n\n\n\n

excelSalinEdit=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\n<\/code><\/pre>\n\n\n\n
    \n
  • lookup_value<\/code>: Nilai yang akan dicari (misalnya jabatan atau nama).<\/li>\n\n\n\n
  • table_array<\/code>: Tabel data di mana pencarian dilakukan.<\/li>\n\n\n\n
  • col_index_num<\/code>: Nomor kolom dalam table_array<\/code> dari mana nilai akan diambil.<\/li>\n\n\n\n
  • [range_lookup]<\/code>: Opsi pencarian pasti atau perkiraan (TRUE\/FALSE).<\/li>\n<\/ul>\n\n\n\n
    HLOOKUP<\/h3>\n\n\n\n
    Fungsi HLOOKUP<\/strong> digunakan untuk mencari data di baris pertama dari tabel dan mengembalikan nilai dari baris lain pada kolom yang sama. Sintaksnya adalah:<\/p>\n\n\n\n
    excelSalinEdit=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])\n<\/code><\/pre>\n\n\n\n
      \n
    • lookup_value<\/code>: Nilai yang akan dicari di baris pertama.<\/li>\n\n\n\n
    • table_array<\/code>: Tabel data di mana pencarian dilakukan.<\/li>\n\n\n\n
    • row_index_num<\/code>: Nomor baris dalam table_array<\/code> dari mana nilai akan diambil.<\/li>\n\n\n\n
    • [range_lookup]<\/code>: Opsi pencarian pasti atau perkiraan (TRUE\/FALSE).<\/li>\n<\/ul>\n\n\n\n
      Contoh Penggunaan VLOOKUP & HLOOKUP<\/h3>\n\n\n\n
      Misalkan kita memiliki tabel gaji karyawan sebagai berikut:<\/p>\n\n\n\n
      Jabatan<\/th>Gaji Pokok<\/th>Tunjangan<\/th>Uang Transport<\/th>Uang Pulsa<\/th><\/tr><\/thead>
      Manager<\/td>10,000,000<\/td>2,500,000<\/td>1,000,000<\/td>500,000<\/td><\/tr>
      Supervisor<\/td>7,500,000<\/td>2,000,000<\/td>800,000<\/td>400,000<\/td><\/tr>
      Staff<\/td>5,000,000<\/td>1,500,000<\/td>600,000<\/td>300,000<\/td><\/tr>
      Office Boy<\/td>3,000,000<\/td>1,000,000<\/td>400,000<\/td>200,000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Contoh 1: VLOOKUP<\/h4>\n\n\n\n
      Anda ingin mencari total kompensasi untuk jabatan “Supervisor”, yaitu kombinasi dari Gaji Pokok, Tunjangan, Uang Transport, dan Uang Pulsa. Langkah-langkahnya sebagai berikut:<\/p>\n\n\n\n
        \n
      1. Gunakan VLOOKUP untuk mencari masing-masing komponen kompensasi.
        • Gaji Pokok<\/strong>:<\/li><\/ul>excelSalinEdit=VLOOKUP(\"Supervisor\", A2:E5, 2, FALSE) <\/code>Hasilnya: 7,500,000
          • Tunjangan<\/strong>:<\/li><\/ul>excelSalinEdit=VLOOKUP(\"Supervisor\", A2:E5, 3, FALSE) <\/code>Hasilnya: 2,000,000
            • Uang Transport<\/strong>:<\/li><\/ul>excelSalinEdit=VLOOKUP(\"Supervisor\", A2:E5, 4, FALSE) <\/code>Hasilnya: 800,000
              • Uang Pulsa<\/strong>:<\/li><\/ul>excelSalinEdit=VLOOKUP(\"Supervisor\", A2:E5, 5, FALSE) <\/code>Hasilnya: 400,000<\/li>\n\n\n\n
              • Jumlahkan seluruh komponen untuk mendapatkan total kompensasi:excelSalinEdit=7,500,000 + 2,000,000 + 800,000 + 400,000 <\/code>Hasil akhirnya adalah: 10,700,000<\/li>\n<\/ol>\n\n\n\n
                Contoh 2: HLOOKUP<\/h4>\n\n\n\n
                Misalkan kita ingin menggunakan HLOOKUP<\/strong> untuk mencari uang transport untuk jabatan “Manager”. Pertama-tama, kita ubah tabelnya menjadi bentuk horizontal sebagai berikut:<\/p>\n\n\n\n
                Jabatan<\/th>Manager<\/th>Supervisor<\/th>Staff<\/th>Office Boy<\/th><\/tr><\/thead>
                Gaji Pokok<\/strong><\/td>10,000,000<\/td>7,500,000<\/td>5,000,000<\/td>3,000,000<\/td><\/tr>
                Tunjangan<\/strong><\/td>2,500,000<\/td>2,000,000<\/td>1,500,000<\/td>1,000,000<\/td><\/tr>
                Uang Transport<\/strong><\/td>1,000,000<\/td>800,000<\/td>600,000<\/td>400,000<\/td><\/tr>
                Uang Pulsa<\/strong><\/td>500,000<\/td>400,000<\/td>300,000<\/td>200,000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                Untuk mendapatkan Uang Transport<\/strong> jabatan “Manager”, kita bisa menggunakan HLOOKUP:<\/p>\n\n\n\n
                excelSalinEdit=HLOOKUP(\"Uang Transport\", A1:E5, 2, FALSE)\n<\/code><\/pre>\n\n\n\n
                Hasilnya adalah 1,000,000.<\/p>\n\n\n\n
                Kesimpulan<\/h3>\n\n\n\n
                  \n
                • VLOOKUP<\/strong> cocok digunakan ketika tabel memiliki data yang diatur secara vertikal dan kita ingin mencari berdasarkan kolom pertama.<\/li>\n\n\n\n
                • HLOOKUP<\/strong> digunakan ketika tabel diatur secara horizontal dan pencarian dilakukan di baris pertama.<\/li>\n<\/ul>\n\n\n\n
                  Kedua fungsi ini sangat bermanfaat dalam pengolahan data di Excel, terutama saat bekerja dengan dataset besar yang membutuhkan pencarian cepat, seperti data gaji karyawan.<\/p>\n","protected":false},"excerpt":{"rendered":"
                  VLOOKUP (Vertical Lookup) dan HLOOKUP (Horizontal Lookup) adalah fungsi Excel yang sering digunakan untuk mencari…<\/p>\n","protected":false},"author":1,"featured_media":209,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[1,33],"tags":[34],"class_list":["post-207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ilmu-lengkap-dunia-komputer-dan-digital","category-microsoft-office","tag-ms-excel"],"yoast_head":"\nMemahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID<\/title>\n<meta name=\"description\" content=\"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID\" \/>\n<meta property=\"og:description\" content=\"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Ideal Web ID\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-06T17:54:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-06T17:55:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"idealwebid\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"idealwebid\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/\"},\"author\":{\"name\":\"idealwebid\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#\\\/schema\\\/person\\\/8351678724536bb2d510c963932c444a\"},\"headline\":\"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel\",\"datePublished\":\"2025-02-06T17:54:32+00:00\",\"dateModified\":\"2025-02-06T17:55:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/\"},\"wordCount\":342,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/rumus-vlookup-dan-hlookup.webp\",\"keywords\":[\"MS Excel\"],\"articleSection\":[\"Artikel\",\"Microsoft Office\"],\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/\",\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/\",\"name\":\"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/rumus-vlookup-dan-hlookup.webp\",\"datePublished\":\"2025-02-06T17:54:32+00:00\",\"dateModified\":\"2025-02-06T17:55:26+00:00\",\"description\":\"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/rumus-vlookup-dan-hlookup.webp\",\"contentUrl\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/rumus-vlookup-dan-hlookup.webp\",\"width\":1024,\"height\":1024,\"caption\":\"VLOOKUP dan HLOOKUP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/rumus-vlookup-dan-hlookup-mudah-di-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#website\",\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/\",\"name\":\"Ideal Web ID\",\"description\":\"Jasa Pembuatan Website Profesional\",\"publisher\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#organization\",\"name\":\"Ideal Web ID\",\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-logo.png\",\"contentUrl\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-logo.png\",\"width\":213,\"height\":249,\"caption\":\"Ideal Web ID\"},\"image\":{\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/#\\\/schema\\\/person\\\/8351678724536bb2d510c963932c444a\",\"name\":\"idealwebid\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g\",\"caption\":\"idealwebid\"},\"sameAs\":[\"https:\\\/\\\/idealwebid.com\\\/artikel\"],\"url\":\"https:\\\/\\\/idealwebid.com\\\/artikel\\\/author\\\/idealwebid\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID","description":"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.","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:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID","og_description":"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.","og_url":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/","og_site_name":"Ideal Web ID","article_published_time":"2025-02-06T17:54:32+00:00","article_modified_time":"2025-02-06T17:55:26+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp","type":"image\/webp"}],"author":"idealwebid","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"idealwebid","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#article","isPartOf":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/"},"author":{"name":"idealwebid","@id":"https:\/\/idealwebid.com\/artikel\/#\/schema\/person\/8351678724536bb2d510c963932c444a"},"headline":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel","datePublished":"2025-02-06T17:54:32+00:00","dateModified":"2025-02-06T17:55:26+00:00","mainEntityOfPage":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/"},"wordCount":342,"commentCount":0,"publisher":{"@id":"https:\/\/idealwebid.com\/artikel\/#organization"},"image":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp","keywords":["MS Excel"],"articleSection":["Artikel","Microsoft Office"],"inLanguage":"id","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/","url":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/","name":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel - Ideal Web ID","isPartOf":{"@id":"https:\/\/idealwebid.com\/artikel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#primaryimage"},"image":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp","datePublished":"2025-02-06T17:54:32+00:00","dateModified":"2025-02-06T17:55:26+00:00","description":"VLOOKUP dan HLOOKUP adalah fungsi Excel yang sering digunakan untuk mencari nilai dalam tabel berdasarkan kolom atau baris pada excel.","breadcrumb":{"@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#primaryimage","url":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp","contentUrl":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/02\/rumus-vlookup-dan-hlookup.webp","width":1024,"height":1024,"caption":"VLOOKUP dan HLOOKUP"},{"@type":"BreadcrumbList","@id":"https:\/\/idealwebid.com\/artikel\/rumus-vlookup-dan-hlookup-mudah-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/idealwebid.com\/artikel\/"},{"@type":"ListItem","position":2,"name":"Memahami Rumus VLOOKUP dan HLOOKUP Mudah di Excel"}]},{"@type":"WebSite","@id":"https:\/\/idealwebid.com\/artikel\/#website","url":"https:\/\/idealwebid.com\/artikel\/","name":"Ideal Web ID","description":"Jasa Pembuatan Website Profesional","publisher":{"@id":"https:\/\/idealwebid.com\/artikel\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/idealwebid.com\/artikel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/idealwebid.com\/artikel\/#organization","name":"Ideal Web ID","url":"https:\/\/idealwebid.com\/artikel\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/idealwebid.com\/artikel\/#\/schema\/logo\/image\/","url":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/01\/cropped-logo.png","contentUrl":"https:\/\/idealwebid.com\/artikel\/wp-content\/uploads\/2025\/01\/cropped-logo.png","width":213,"height":249,"caption":"Ideal Web ID"},"image":{"@id":"https:\/\/idealwebid.com\/artikel\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/idealwebid.com\/artikel\/#\/schema\/person\/8351678724536bb2d510c963932c444a","name":"idealwebid","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/secure.gravatar.com\/avatar\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95d2310c2b1f22d29615ac88d262e70febb55bd616ed97d8cc1deda0912badac?s=96&d=mm&r=g","caption":"idealwebid"},"sameAs":["https:\/\/idealwebid.com\/artikel"],"url":"https:\/\/idealwebid.com\/artikel\/author\/idealwebid\/"}]}},"_links":{"self":[{"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":1,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":208,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/posts\/207\/revisions\/208"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/media\/209"}],"wp:attachment":[{"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idealwebid.com\/artikel\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}