{"id":12220,"date":"2025-01-15T07:39:54","date_gmt":"2025-01-15T07:39:54","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-tim-kiem-vlookup-va-hlookup-trong-excel\/"},"modified":"2025-01-15T07:39:54","modified_gmt":"2025-01-15T07:39:54","slug":"ham-tim-kiem-vlookup-va-hlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-tim-kiem-vlookup-va-hlookup-trong-excel\/","title":{"rendered":"H\u00e0m t\u00ecm ki\u1ebfm VLOOKUP v\u00e0 HLOOKUP trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u th\u00ec vi\u1ec7c ph\u1ea3i n\u1eafm v\u1eefng c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm l\u00e0 b\u1eaft bu\u1ed9c. Trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n hai h\u00e0m t\u00ecm ki\u1ebfm th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0 h\u00e0m Vlookup v\u00e0 Hlookup.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong>H\u00e0m VLOOKUP<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><a href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>VLOOKUP<\/strong><\/a> l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng tr\u00ean \u00f4 c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng trong c\u1ed9t\u00a0 ch\u1ec9 \u0111\u1ecbnh<\/p>\n<p style=\"text-align: justify\">C\u00fa Ph\u00e1p:<\/p>\n<p style=\"text-align: justify\"><strong>VLOOKUP(Lookup_value,Table_ array,Col_index_Num,Range_lookup)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\"><strong>Lookup_value<\/strong>:\u00a0 gi\u00e1 tr\u1ecb \u0111\u1ed1i chi\u1ebfu v\u1edbi c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<li style=\"text-align: left\"><strong>Table_ array:<\/strong> \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu, kh\u00f4ng l\u1ea5y d\u00f2ng ti\u00eau \u0111\u1ec1.<\/li>\n<li style=\"text-align: left\"><strong>Col_index_Num<\/strong>: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y c\u1ee7a b\u1ea3ng tham chi\u1ebfu (t\u00ednh theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i qua ph\u1ea3i v\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb 1).<\/li>\n<li style=\"text-align: left\"><strong>Range_lookup<\/strong>: C\u00e1ch t\u00ecm ki\u1ebfm tr\u00ean b\u1ea3ng tham chi\u1ebfu. + 0: C\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu ch\u01b0a s\u1eafp x\u1ebfp. + 1: C\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n (ng\u1ea7m \u0111\u1ecbnh).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u00ecnh c\u00f3 v\u00ed d\u1ee5 nh\u01b0 sau cho c\u00e1c b\u1ea1n d\u1ec5 hi\u1ec3u nh\u00e9<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb m\u1ee9c th\u01b0\u1edfng c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho ra k\u1ebft qu\u1ea3 H\u1ecdc B\u1ed5ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ee9c th\u01b0\u1edfng \u0111\u00f3 ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3573\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-41.png\" width=\"600\" height=\"191\" title=\"1-41\">Ta c\u00f3: <strong>=VLOOKUP(K6;$A$12:$B$14;2;0)<\/strong> c\u00e1c b\u1ea1n ch\u00fa \u00fd v\u00ec m\u00ecnh s\u1eed d\u1ee5ng Excel 2013 n\u00ean kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 d\u1ea5u ; c\u00f2n v\u1edbi Excel 2007,2010 l\u00e0 d\u1ea5u (,) nh\u00e9.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-369.gif\" title=\"ex101_92019-nho-369\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\">K6: C\u1ed9t M\u1ee9c th\u01b0\u1edfng c\u1ea7n \u0111\u1ed1i chi\u1ebfu v\u1edbi c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li style=\"text-align: left\">$A$12:$B$14 : l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li style=\"text-align: left\">2: c\u1ed9t h\u1ecdc b\u1ed5ng l\u00e0 c\u1ed9t th\u1ee9 2 c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li style=\"text-align: left\">0: c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu ch\u01b0a s\u1eafp x\u1ebfp<\/li>\n<\/ul>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3576\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-1.png\" width=\"600\" height=\"146\" title=\"untitled-1\"><\/p>\n<p style=\"text-align: justify\"><strong>2. H\u00e0m HLOOKUP<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html\">HLOOKUP<\/a> l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb tr\u00ean d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng trong d\u00f2ng ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p :<br \/>\n<strong>HLOOKUP(Lookup_value,Table_ array,Row_index_Num,Range_lookup)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\"><strong>Lookup_value:\u00a0<\/strong> gi\u00e1 tr\u1ecb \u0111\u1ed1i chi\u1ebfu v\u1edbi d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<li style=\"text-align: left\"><strong>Table_ array<\/strong>: l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu, kh\u00f4ng l\u1ea5y c\u1ed9t ti\u00eau \u0111\u1ec1.<\/li>\n<li style=\"text-align: left\"><strong>Row_index_Num<\/strong>: S\u1ed1 th\u1ee9 t\u1ef1 d\u00f2ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y c\u1ee7a b\u1ea3ng tham chi\u1ebfu (t\u00ednh theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi v\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 1).<\/li>\n<li style=\"text-align: left\"><strong>Range_lookup<\/strong>: C\u00e1ch t\u00ecm ki\u1ebfm tr\u00ean b\u1ea3ng tham chi\u1ebfu. + 0: D\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu ch\u01b0a s\u1eafp x\u1ebfp. + 1: d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n (ng\u1ea7m \u0111\u1ecbnh).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb\u00a0M\u00e3\u00a0\u0111\u01a1n v\u1ecb\u00a0c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho ra k\u1ebft qu\u1ea3\u00a0\u0110\u01a1n v\u1ecb\u00a0t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ee9c th\u01b0\u1edfng \u0111\u00f3 ch\u00fang ta l\u00e0m nh\u01b0 sau:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3580\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/6-2.png\" width=\"600\" height=\"180\" title=\"6-2\"><\/p>\n<p style=\"text-align: justify\">Ta c\u00f3: <strong>=HLOOKUP(A2:A4;$A$6:$D$7;2;1)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\"><strong>A2:A4:<\/strong> l\u00e0 \u0111\u1ecba ch\u1ec9\u00a0M\u00e3\u00a0\u0111\u01a1n\u00a0v\u1ecb\u00a0\u0111\u1ed1i chi\u1ebfu v\u1edbi d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li style=\"text-align: left\"><strong>$A$6:$D$7:<\/strong> l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu (c\u00e1c b\u1ea1n ch\u00fa \u00fd kh\u00f4ng l\u1ea5y ti\u00eau \u0111\u1ec1 nh\u00e9)<\/li>\n<li style=\"text-align: left\"><strong>2:<\/strong> d\u00f2ng \u0111\u01a1n v\u1ecb l\u00e0 d\u00f2ng th\u1ee9 2 c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li style=\"text-align: left\"><strong>1:<\/strong> d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n (ng\u1ea7m \u0111\u1ecbnh)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3583 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/7-1.png\" width=\"408\" height=\"155\" title=\"7-1\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u00a0 \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-369.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12221,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12220","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\/12220","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=12220"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12220\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12221"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}