{"id":8464,"date":"2024-12-22T14:39:55","date_gmt":"2024-12-22T14:39:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-ham-hlookup-trong-excel\/"},"modified":"2024-12-22T14:39:55","modified_gmt":"2024-12-22T14:39:55","slug":"huong-dan-ham-hlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-ham-hlookup-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m HLOOKUP trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong>H\u00e0m HLOOKUP<\/strong> s\u1ebd gi\u00fap b\u1ea1n ti\u0300m ki\u00ea\u0301m m\u00f4\u0323t gia\u0301 tri\u0323 trong ha\u0300ng tr\u00ean cu\u0300ng cu\u0309a ba\u0309ng ho\u0103\u0323c ma\u0309ng gia\u0301 tri\u0323, sau \u0111o\u0301 tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 trong cu\u0300ng c\u00f4\u0323t t\u01b0\u0300 ha\u0300ng ma\u0300 ba\u0323n chi\u0309 \u0111i\u0323nh trong ba\u0309ng ho\u0103\u0323c ma\u0309ng. Ch\u01b0\u0303 H trong t\u00ean ha\u0300m HLOOKUP la\u0300 \u201cHorizontal \u2013 Ngang\u201d. C\u1ee5 th\u1ec3 trong b\u00e0i vi\u1ebft sau \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd c\u00f9ng b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng HLOOKUP c\u01a1 b\u1ea3n.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676824ba8d1ce\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-hlookup-trong-excel.html#Cong_thuc_ham_HLOOKUP\" title=\"C\u00f4ng th\u1ee9c h\u00e0m HLOOKUP\">C\u00f4ng th\u1ee9c h\u00e0m HLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-hlookup-trong-excel.html#Luu_y\" title=\"L\u01b0u \u00fd\">L\u01b0u \u00fd<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_HLOOKUP\"><\/span>C\u00f4ng th\u1ee9c h\u00e0m HLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html\">H\u00e0m HLOOKUP<\/a> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=HLOOKUP(lookup_value, table_array,row_index_num, [range_lookup])<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Lookup_value:<\/b>\u00a0Gia\u0301 tri\u0323 c\u00e2\u0300n ti\u0300m trong ha\u0300ng th\u01b0\u0301 nh\u00e2\u0301t cu\u0309a ba\u0309ng. Lookup_value co\u0301 th\u00ea\u0309 la\u0300 m\u00f4\u0323t gia\u0301 tri\u0323, tham chi\u00ea\u0301u ho\u0103\u0323c chu\u00f4\u0303i v\u0103n ba\u0309n.<\/li>\n<li><b class=\"ocpRunInHead\">Table_array:<\/b>\u00a0M\u00f4\u0323t ba\u0309ng th\u00f4ng tin \u0111\u00ea\u0309 ti\u0300m ki\u00ea\u0301m d\u01b0\u0303 li\u00ea\u0323u trong \u0111o\u0301.\n<ul>\n<li>Ca\u0301c gia\u0301 tri\u0323 trong ha\u0300ng th\u01b0\u0301 nh\u00e2\u0301t cu\u0309a table_array co\u0301 th\u00ea\u0309 la\u0300 v\u0103n ba\u0309n, s\u00f4\u0301 ho\u0103\u0323c gia\u0301 tri\u0323 l\u00f4-gic.<\/li>\n<li>N\u00ea\u0301u range_lookup la\u0300 TRUE, ca\u0301c gia\u0301 tri\u0323 trong ha\u0300ng th\u01b0\u0301 nh\u00e2\u0301t cu\u0309a table_array pha\u0309i \u0111\u01b0\u01a1\u0323c \u0111\u0103\u0323t theo th\u01b0\u0301 t\u01b0\u0323 t\u0103ng d\u00e2\u0300n: \u2026-2, -1, 0, 1, 2,\u2026 , A-Z, FALSE, TRUE; n\u00ea\u0301u kh\u00f4ng, ha\u0300m HLOOKUP co\u0301 th\u00ea\u0309 \u0111\u01b0a ra gia\u0301 tri\u0323 kh\u00f4ng \u0111u\u0301ng. N\u00ea\u0301u range_lookup la\u0300 FALSE, thi\u0300 kh\u00f4ng c\u00e2\u0300n pha\u0309i s\u0103\u0301p x\u00ea\u0301p table_array.<\/li>\n<\/ul>\n<\/li>\n<li><b class=\"ocpRunInHead\">Row_index_num:<\/b>\u00a0S\u1ed1 h\u00e0ng trong table_array m\u00e0 gi\u00e1 tr\u1ecb kh\u1edbp s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/li>\n<li><b class=\"ocpRunInHead\">Range_lookup:<\/b>\u00a0M\u1ed9t gi\u00e1 tr\u1ecb l\u00f4-gic cho bi\u00ea\u0301t b\u1ea1n c\u00f3 mu\u1ed1n HLOOKUP t\u00ecm th\u1ea5y m\u1ed9t k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c hay k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Luu_y\"><\/span>L\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li class=\"\">N\u00ea\u0301u ha\u0300m HLOOKUP kh\u00f4ng ti\u0300m th\u00e2\u0301y lookup_value, va\u0300 range_lookup la\u0300 TRUE, thi\u0300 no\u0301 du\u0300ng gia\u0301 tri\u0323 l\u01a1\u0301n nh\u00e2\u0301t nho\u0309 h\u01a1n lookup_value.<\/li>\n<li>N\u00ea\u0301u lookup_value nho\u0309 h\u01a1n gia\u0301 tri\u0323 nho\u0309 nh\u00e2\u0301t trong ha\u0300ng th\u01b0\u0301 nh\u00e2\u0301t cu\u0309a table_array, thi\u0300 ha\u0300m HLOOKUP tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 l\u00f4\u0303i #N\/A.<\/li>\n<li>N\u1ebfu range_lookup l\u00e0 FALSE v\u00e0 lookup_value l\u00e0 v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, d\u1ea5u ch\u1ea5m h\u1ecfi (?) v\u00e0 d\u1ea5u sao (*), trong lookup_value. \u0110\u1ec3 hi\u1ec3u t\u00e1c d\u1ee5ng c\u00e1c d\u1ea5u n\u00e0y, h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft sau:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html\"><strong>S\u1eed d\u1ee5ng Wildcard trong Excel<\/strong><\/a><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m HLOOKUP s\u1ebd gi\u00fap b\u1ea1n ti\u0300m ki\u00ea\u0301m m\u00f4\u0323t gia\u0301 tri\u0323 trong ha\u0300ng tr\u00ean cu\u0300ng cu\u0309a..<\/p>\n","protected":false},"author":1,"featured_media":8465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8464"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8465"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}