{"id":874,"date":"2023-08-26T00:59:07","date_gmt":"2023-08-25T17:59:07","guid":{"rendered":"https:\/\/trannghiait.com\/?p=874"},"modified":"2023-08-26T00:59:07","modified_gmt":"2023-08-25T17:59:07","slug":"cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup\/","title":{"rendered":"C\u00e1ch tr\u1edf n\u00ean th\u00e0nh th\u1ea1o khi s\u1eed d\u1ee5ng h\u00e0m HLOOKUP"},"content":{"rendered":"\n<p>H\u00e0m HLOOKUP trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh. Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m HLOOKUP, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t h\u00e0ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb h\u00e0ng kh\u00e1c trong b\u1ea3ng t\u00ednh \u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i s\u00e2u v\u00e0o c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u trong Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup\/#Cu_phap_cua_ham_HLOOKUP\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HLOOKUP\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup\/#Cach_su_dung_ham_HLOOKUP\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_HLOOKUP\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HLOOKUP nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=HLOOKUP(lookup_value, table_array, row_index_num, &#91;range_lookup])<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>lookup_value<\/code>: gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><code>table_array<\/code>: b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n truy xu\u1ea5t.<\/li>\n\n\n\n<li><code>row_index_num<\/code>: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1.<\/li>\n\n\n\n<li><code>range_lookup<\/code> (t\u00f9y ch\u1ecdn): ch\u1ec9 \u0111\u1ecbnh xem b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c ho\u1eb7c g\u1ea7n \u0111\u00fang. N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp gi\u00e1 tr\u1ecb n\u00e0y, Excel s\u1ebd gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_HLOOKUP\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP, ch\u00fang ta s\u1ebd xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n. H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 gi\u00e1 c\u1ee7a ch\u00fang nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>S\u1ea3n ph\u1ea9m<\/th><th>Gi\u00e1<\/th><th>S\u1ed1 l\u01b0\u1ee3ng<\/th><\/tr><\/thead><tbody><tr><td>S\u1ea3n ph\u1ea9m A<\/td><td>10<\/td><td>20<\/td><\/tr><tr><td>S\u1ea3n ph\u1ea9m B<\/td><td>15<\/td><td>15<\/td><\/tr><tr><td>S\u1ea3n ph\u1ea9m C<\/td><td>20<\/td><td>10<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m B. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m HLOOKUP nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=HLOOKUP(\"Gi\u00e1\", A1:C3, 2, FALSE)<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\"Gi\u00e1\"<\/code> l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><code>A1:C3<\/code> l\u00e0 b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n truy xu\u1ea5t.<\/li>\n\n\n\n<li><code>2<\/code> l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1.<\/li>\n\n\n\n<li><code>FALSE<\/code> cho bi\u1ebft b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m B, t\u1ee9c l\u00e0 15.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m HLOOKUP trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng trong vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel!<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u00e0m HLOOKUP trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh. Khi b\u1ea1n s\u1eed <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/cach-tro-nen-thanh-thao-khi-su-dung-ham-hlookup\/\" title=\"C\u00e1ch tr\u1edf n\u00ean th\u00e0nh th\u1ea1o khi s\u1eed d\u1ee5ng h\u00e0m HLOOKUP\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-874","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=874"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":875,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/874\/revisions\/875"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}