{"id":4290,"date":"2024-12-04T17:28:58","date_gmt":"2024-12-04T17:28:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/mot-so-diem-thu-vi-ve-ham-xlookup\/"},"modified":"2024-12-04T17:28:58","modified_gmt":"2024-12-04T17:28:58","slug":"mot-so-diem-thu-vi-ve-ham-xlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/mot-so-diem-thu-vi-ve-ham-xlookup\/","title":{"rendered":"M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 h\u00e0m XLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong l\u1ea7n c\u1eadp nh\u1eadt m\u1edbi \u0111\u00e2y, Microsoft \u0111\u00e3\u00a0\u0111\u01b0a cho ng\u01b0\u1eddi d\u00f9ng th\u00eam m\u1ed9t s\u1ed1 h\u00e0m m\u1edbi, v\u1edbi m\u1ee5c \u0111\u00edch nh\u1eb1m kh\u1eafc ph\u1ee5c c\u0169ng nh\u01b0 b\u1ed5 sung th\u00eam c\u00e1c t\u00ednh n\u0103ng m\u1edbi cho Excel. V\u00e0 h\u00e0m XLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m xu\u1ea5t hi\u1ec7n trong l\u1ea7n c\u1eadp nh\u1eadt n\u00e0y. V\u1eady h\u00e0m n\u00e0y c\u00f3 nh\u1eefng \u0111i\u1ec3m g\u00ec n\u1ed5i b\u1eadt v\u00e0 th\u00fa v\u1ecb h\u01a1n c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm kh\u00e1c nh\u01b0 VLOOKUP, HLOOKUP,\u2026H\u00e3y c\u00f9ng <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft n\u00e0y.<\/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-6750915924e65\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Mot_so_diem_thu_vi_ve_ham_XLOOKUP\" title=\"M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 h\u00e0m XLOOKUP\">M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 h\u00e0m XLOOKUP<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Cu_phat_ham_XLOOKUP\" title=\"C\u00fa ph\u00e1t h\u00e0m XLOOKUP\">C\u00fa ph\u00e1t h\u00e0m XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Mot_so_diem_thu_vi_cua_ham_XLOOKUP\" title=\"M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb c\u1ee7a h\u00e0m XLOOKUP\">M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb c\u1ee7a h\u00e0m XLOOKUP<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Ham_Excel_co_the_tim_kiem_%E2%80%9Cben_TRAI%E2%80%9D\" title=\"H\u00e0m Excel c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u201cb\u00ean TR\u00c1I\u201d\">H\u00e0m Excel c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u201cb\u00ean TR\u00c1I\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Ham_XLOOKUP_co_the_tim_kiem_tu_cuoi_len_dau_Search_last_to_first\" title=\"H\u00e0m XLOOKUP c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb cu\u1ed1i l\u00ean \u0111\u1ea7u (Search last to first)\">H\u00e0m XLOOKUP c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb cu\u1ed1i l\u00ean \u0111\u1ea7u (Search last to first)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Ham_XLOOKUP_tra_ve_1_mang_gia_tri\" title=\"H\u00e0m XLOOKUP tr\u1ea3 v\u1ec1 1 m\u1ea3ng gi\u00e1 tr\u1ecb\">H\u00e0m XLOOKUP tr\u1ea3 v\u1ec1 1 m\u1ea3ng gi\u00e1 tr\u1ecb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Noi_cac_gia_tri_tim_kiem_trong_ham_XLOOKUP\" title=\"N\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong h\u00e0m XLOOKUP\">N\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong h\u00e0m XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Tim_kiem_mot_mang_gia_tri_voi_ham_XLOOKUP\" title=\"T\u00ecm ki\u1ebfm m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb v\u1edbi h\u00e0m XLOOKUP\">T\u00ecm ki\u1ebfm m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb v\u1edbi h\u00e0m XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Su_dung_cac_ham_khac_ket_hop_voi_XLOOKUP\" title=\"S\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c k\u1ebft h\u1ee3p v\u1edbi XLOOKUP\">S\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c k\u1ebft h\u1ee3p v\u1edbi XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Noi_chuoi_linh_hoat_trong_ket_qua_tra_ve_cua_ham_XLOOKUP\" title=\"N\u1ed1i chu\u1ed7i linh ho\u1ea1t trong k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m XLOOKUP\">N\u1ed1i chu\u1ed7i linh ho\u1ea1t trong k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Mot_so_diem_thu_vi_khac\" title=\"M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb kh\u00e1c\">M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb kh\u00e1c<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Su_dung_XLOOKUP_long_XLOOKUP\" title=\"S\u1eed d\u1ee5ng XLOOKUP l\u1ed3ng XLOOKUP\">S\u1eed d\u1ee5ng XLOOKUP l\u1ed3ng XLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Khac_phuc_duoc_loi_chen_dong_cot_trong_ham_VLOOKUP_va_HLOOKUP\" title=\"Kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i ch\u00e8n d\u00f2ng, c\u1ed9t trong h\u00e0m VLOOKUP v\u00e0 HLOOKUP\">Kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i ch\u00e8n d\u00f2ng, c\u1ed9t trong h\u00e0m VLOOKUP v\u00e0 HLOOKUP<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/mot-diem-thu-vi-ve-ham-xlookup.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_diem_thu_vi_ve_ham_XLOOKUP\"><\/span>M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Ch\u00fang ta \u0111\u00e3 bi\u1ebft \u0111\u1ebfn c\u00e1c h\u00e0m d\u00f2 t\u00ecm nh\u01b0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">VLOOKUP<\/a><\/strong>, <strong>HLOOKUP.<\/strong> Nh\u1eefng h\u00e0m n\u00e0y tr\u01b0\u1edbc gi\u1edd h\u1ea7u nh\u01b0 \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1c ph\u1ed5 bi\u1ebfn v\u00e0 n\u1ebfu nh\u01b0 b\u1ea1n \u0111ang c\u1ea7n th\u00ec c\u00f3 th\u1ec3 tham kh\u1ea3o ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\"><em><strong>H\u00e0m t\u00ecm ki\u1ebfm vlookup v\u00e0 hlookup trong excel<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">Th\u1ebf XLOOKUP n\u00f3 c\u00f3 g\u00ec hay ho h\u01a1n? H\u00e3y c\u00f9ng l\u01b0\u1edbt qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a H\u1ecdc Excel Online<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phat_ham_XLOOKUP\"><\/span>C\u00fa ph\u00e1t h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m XLOOKUP s\u1ebd c\u00f3 5 \u0111\u1ed1i s\u1ed1, tuy nhi\u00ean trong \u0111\u00f3 ch\u1ec9 c\u00f3 3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c c\u00f2n 2 \u0111\u1ed1i s\u1ed1 sau l\u00e0 tu\u1ef3 ch\u1ecdn, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29831 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-1-1024x215-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-1\" width=\"1024\" height=\"215\" title=\"1-1-1024x215-1\"><\/a><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>Trong \u0111\u00f3:<\/strong><\/span><\/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\/2024\/12\/ex101_92019-nho-343.gif\" title=\"ex101_92019-nho-343\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li><strong>lookup_value:<\/strong> L\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/li>\n<li><strong>lookup_array:<\/strong> L\u00e0 v\u00f9ng (m\u1ea3ng) t\u00ecm ki\u1ebfm<\/li>\n<li><strong>return_array:<\/strong> L\u00e0 v\u00f9ng (m\u1ea3ng) m\u00e0 \u1edf \u0111\u00f3 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3<\/li>\n<li><strong>[match_mode]:<\/strong> L\u00e0 l\u1ef1a ch\u1ecdn ch\u1ebf \u0111\u1ed9 kh\u1edbp gi\u00e1 tr\u1ecb khi t\u00ecm ki\u1ebfm<\/li>\n<li><strong>[search_mode]:<\/strong> L\u00e0 l\u1ef1a ch\u1ecdn ch\u1ebf \u0111\u1ed9 t\u00ecm ki\u1ebfm<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>L\u01b0u \u00fd:<\/strong><\/span><\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li>lookup_value: C\u00f3 th\u1ec3 l\u00e0 1 gi\u00e1 tr\u1ecb ho\u1eb7c 1 m\u1ea3ng gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm<\/li>\n<li>lookup_array v\u00e0\u00a0return_array: C\u1ea7n kh\u1edbp nhau v\u1ec1 k\u00edch th\u01b0\u1edbc<\/li>\n<li>[match_mode]: M\u1eb7c \u0111\u1ecbnh l\u00e0 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c (0 \u2013 Exact match)<\/li>\n<li>[search_mode]:\u00a0M\u1eb7c \u0111\u1ecbnh l\u00e0 t\u00ecm ki\u1ebfm\u00a0t\u1eeb \u0111\u1ea7u \u0111\u1ebfn cu\u1ed1i\u00a0(1 \u2013\u00a0Search first-to-last)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm <strong>VLOOKUP<\/strong> hay <strong>HLOOKUP<\/strong> th\u00ec m\u00ecnh ngh\u0129 s\u1ebd kh\u00f4ng kh\u00f3 kh\u0103n g\u00ec v\u1edbi vi\u1ec7c \u0111\u00f3n nh\u1eadn h\u00e0 m XLOOKUP n\u00e0y. C\u00e1c \u0111\u1ed1i s\u1ed1 g\u1ea7n nh\u01b0 tuong t\u1ef1. V\u1eady <strong>h\u00e0m XLOOKUP<\/strong> n\u00e0y n\u00f3 l\u00e0m \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_diem_thu_vi_cua_ham_XLOOKUP\"><\/span>M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb c\u1ee7a h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong ph\u1ea7n n\u00e0y <strong>H\u1ecdc Excel Online <\/strong>s\u1ebd gi\u1edbi thi\u1ec7u m\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb c\u1ee7a h\u00e0m XLOOKUP.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Excel_co_the_tim_kiem_%E2%80%9Cben_TRAI%E2%80%9D\"><\/span>H\u00e0m Excel c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u201cb\u00ean TR\u00c1I\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ta \u0111\u00e3 bi\u1ebft th\u00ec m\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf c\u1ee7a <strong>h\u00e0m VLOOKUP <\/strong>l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m ch\u1ec9 c\u00f3 th\u1ec3 l\u00e0 1 c\u1ed9t n\u00e0o \u0111\u00f3 n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u00f2, t\u01b0\u01a1ng t\u1ef1 v\u1edbi <strong>HLOOKUP<\/strong>, ta c\u0169ng ch\u1ec9 c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1 h\u00e0ng n\u00e0o \u0111\u00f3 n\u1eb1m d\u01b0\u1edbi h\u00e0ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u00f2. M\u1eb7c d\u00f9 c\u0169ng c\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y VD nh\u01b0 k\u1ebft h\u1ee3p th\u00eam<strong> h\u00e0m CHOOSE<\/strong>, tuy nhi\u00ean n\u00f3 kh\u00e1 ph\u1ee9c t\u1ea1p v\u00e0 s\u1ebd kh\u00f4ng t\u1ed1i \u01b0u trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ket-hop-vlookup-va-choose-tim-kiem-tu-phai-qua-trai.html\"><em><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p vlookup v\u00e0 choose: m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb ph\u1ea3i qua tr\u00e1i<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">hay n\u00e2ng cao h\u01a1n th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm t\u1edbi <strong>h\u00e0m INDEX <\/strong>k\u1ebft h\u1ee3p v\u1edbi <strong>h\u00e0m MATCH<\/strong>:<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-index-va-ham-match-trong-excel-su-thay-tot-hon-ca-ham-vlookup.html\">H\u00e0m index v\u00e0 h\u00e0m match trong excel \u2013 s\u1ef1 thay th\u1ebf t\u1ed1t h\u01a1n c\u1ea3 h\u00e0m vlookup<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Th\u00ec v\u1edbi h\u00e0m XLOOKUP \u0111\u00e3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n xem v\u00ed d\u1ee5 sau, c\u0103n c\u1ee9 v\u00e0o \u0111\u01a1n gi\u00e1 \u0111\u1ec3 t\u00ecm t\u00ean h\u00e0ng ho\u00e1:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/3-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29834 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1-1024x264-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-2\" width=\"1024\" height=\"264\" title=\"3-1-1024x264-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_XLOOKUP_co_the_tim_kiem_tu_cuoi_len_dau_Search_last_to_first\"><\/span>H\u00e0m XLOOKUP c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb cu\u1ed1i l\u00ean \u0111\u1ea7u (Search last to first)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, v\u00f3i h\u00e0m XLOOKUP ta c\u00f3 th\u1ec3 linh \u0111\u1ed9ng trong t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u, \u0111\u01a1n c\u1eed l\u00e0 ta c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb d\u01b0\u1edbi l\u00ean. \u0110i\u00eau n\u00e0y c\u0169ng kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c nh\u1eefng h\u1ea1n ch\u1ebf c\u1ee7a <strong>h\u00e0m VLOOKUP<\/strong> hay <strong>HLOOKUP.<\/strong><\/p>\n<p style=\"text-align: justify\">V\u1edbi \u0111\u1ed1i s\u1ed1 th\u1ee9 5 c\u1ee7a h\u00e0m l\u00e0 -1 (Search last-to-first).<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/2-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29835 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-1-1024x317-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-3\" width=\"1024\" height=\"317\" title=\"2-1-1024x317-1\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1edbi c\u00f9ng h\u00e0ng ho\u00e1 1, c\u00f4ng th\u1ee9c \u1edf \u00f4 <strong>E3<\/strong> c\u00f3 tham s\u1ed1 th\u1ee9 5 l\u00e0 1 (Search first-to-last) th\u00ec s\u1ebd t\u00ecm t\u1eeb \u0111\u1ea7u \u0111\u1ebfn cu\u1ed1i trong\u00a0lookup_array (t\u01b0\u01a1ng t\u1ef1 h\u00e0m VLOOKUP).<\/p>\n<p style=\"text-align: justify\">C\u00f2n c\u00f4ng th\u1ee9c \u1edf \u00f4 <strong>E5<\/strong> c\u00f3 tham s\u1ed1 th\u1ee9 5 l\u00e0 -1 (Search last-to-first) th\u00ec h\u00e0m s\u1ebd th\u1ef1c hi\u1ec7n b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1eeb cu\u1ed1i l\u00ean \u0111\u1ea7u c\u1ee7a\u00a0lookup_array (\u0110i\u1ec1u n\u00e0y h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 l\u00e0m theo m\u1ed9t c\u00e1ch th\u00f4ng th\u01b0\u1eddng).<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_XLOOKUP_tra_ve_1_mang_gia_tri\"><\/span>H\u00e0m XLOOKUP tr\u1ea3 v\u1ec1 1 m\u1ea3ng gi\u00e1 tr\u1ecb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m XLOOKUP c\u0169ng c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/4-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29836 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-1-1024x290-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-4\" width=\"1024\" height=\"290\" title=\"4-1-1024x290-1\"><\/a><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u1edf<strong> \u00f4 I4<\/strong> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=XLOOKUP(H2,A4:A7,A4:F7)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">H\u00e0m s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong \u00f4 <strong>H2<\/strong> trong v\u00f9ng <strong>A4:A7<\/strong> v\u00e0 v\u00f9ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u1edf \u0111\u00e2y l\u00e0 v\u00f9ng t\u1eeb<strong> A4:F7.\u00a0<\/strong>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c \u1edf \u00f4 <strong>I6<\/strong> v\u00e0 <strong>I8.<\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Noi_cac_gia_tri_tim_kiem_trong_ham_XLOOKUP\"><\/span>N\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ti\u1ebfp n\u1eefa, h\u00e0m XLOOKUP s\u1ebd cho ph\u00e9p b\u1ea1n n\u1ed1i chu\u1ed7i trong gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u00f9ng t\u00ecm ki\u1ebfm c\u0169ng nh\u01b0 v\u00f9ng k\u1ebft qu\u1ea3. Khi b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau b\u1ea1n c\u00f3 th\u1ec3 n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 l\u1ea1i \u0111\u1ec3 t\u00ecm ki\u1ebfm. C\u00f3 th\u1ec3 th\u1ea5y v\u1edbi h\u00e0m XLOOKUP b\u1ea1n ho\u00e0n to\u00e0n linh ho\u1ea1t trong vi\u1ec7c t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/5-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29837 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-1-1024x268-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-5\" width=\"1024\" height=\"268\" title=\"5-1-1024x268-1\"><\/a><\/p>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n ch\u01b0a k\u1ecbp c\u1eadp nh\u1eadt \u0111\u1ec3 c\u00f3 h\u00e0m n\u00e0y th\u00ec <strong>H\u1ecdc Excel Online<\/strong> g\u1ee3i \u00fd cho b\u1ea1n \u0111\u1ec3 c\u0169ng c\u00f3 th\u1ec3 ra k\u1ebft qu\u1ea3 v\u1edbi vi\u1ec7c t\u00ecm ki\u1ebfm khi n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 tr\u00ean b\u1eb1ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/tim-kiem-tu-mot-trong-nhieu-cot-dieu-kien.html\">INDEX + MATCH:<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tim_kiem_mot_mang_gia_tri_voi_ham_XLOOKUP\"><\/span>T\u00ecm ki\u1ebfm m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb v\u1edbi h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1eeba r\u1ed3i ta v\u1eeba th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau b\u1eb1ng c\u00e1ch n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 l\u1ea1i \u0111\u1ec3 t\u00ecm ki\u1ebfm. Kh\u00f4ng nh\u1eefng th\u1ebf h\u00e0m XLOOKUP c\u00f2n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u1ea3 m\u1ea3ng gi\u00e1 tr\u1ecb. B\u1ea1n tham kh\u1ea3o v\u00ed d\u1ee5 sau \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c r\u00f5 h\u01a1n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29842 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-2-1024x448-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-6\" width=\"1024\" height=\"448\" title=\"6-2-1024x448-1\"><\/a><\/p>\n<p style=\"text-align: justify\">M\u00ecnh c\u00f3 s\u1ef1 d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">UNIQUE \u2013 m\u1ed9t h\u00e0m \u0111\u1ec3 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 tr\u1ea3 v\u1ec1 danh s\u00e1ch duy nh\u1ea5t.<\/a><\/p>\n<p style=\"text-align: justify\">M\u1ed9t l\u01b0u \u00fd khi t\u00ecm ki\u1ebfm theo c\u1ea3 m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb l\u00e0: K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 1 m\u1ea3ng gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc (t\u1ee9c g\u1ed3m nhi\u1ec1u h\u00e0ng nh\u01b0ng ch\u1ec9 c\u00f3 1 c\u1ed9t).<\/p>\n<p style=\"text-align: justify\"><strong>T\u1eeb \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 r\u00fat ra l\u00e0: <\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m XLOOKUP c\u00f3 th\u1ec3 v\u1ec1 1 m\u1ea3ng gi\u00e1 tr\u1ecb theo chi\u1ec1u ngang (t\u1ee9c theo h\u00e0ng trong Excel, g\u1ed3m 1 h\u00e0ng v\u00e0 c\u00f3 nhi\u1ec1u c\u1ed9t).<\/li>\n<li>H\u00e0m c\u0169ng c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 1 m\u1ea3ng gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc (t\u1ee9c nhi\u1ec1u h\u00e0ng v\u00e0 1 c\u1ed9t).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u m\u1ea3ng tr\u1ea3 v\u1ec1 n\u00e0y l\u00e0 m\u1ea3ng 1 chi\u1ec1u, ho\u1eb7c 2 chi\u1ec1u nh\u01b0ng trong 2 chi\u1ec1u n\u00e0y ph\u1ea3i c\u00f3 1 chi\u1ec1u v\u1edbi k\u00edch th\u01b0\u1edbc b\u1eb1ng 1. H\u00e0m XLOOKUP s\u1ebd kh\u00f4ng tr\u1ea3 v\u1ec1 \u0111\u01b0\u1ee3c 1 m\u1ea3ng gi\u00e1 tr\u1ecb g\u1ed3m nhi\u1ec1u h\u00e0ng v\u00e0 nhi\u1ec1u c\u1ed9t (&gt;=2 h\u00e0ng v\u00e0 &gt;=2 c\u1ed9t), b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111i\u1ec1u \u0111\u00f3 qua v\u00ed d\u1ee5 tr\u00ean <strong>(\u00f4 I12).<\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_cac_ham_khac_ket_hop_voi_XLOOKUP\"><\/span>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c k\u1ebft h\u1ee3p v\u1edbi XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Excel cho ph\u00e9p b\u1ea1n k\u1ebft h\u1ee3p\u00a0c\u00e1c h\u00e0m l\u1ed3ng v\u00e0o nhau m\u1ed9t c\u00e1ch r\u1ea5t linh ho\u1ea1t, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 tu\u1ef3 bi\u1ebfn c\u00f4ng th\u1ee9c\u00a0 theo \u00fd c\u1ee7a m\u00ecnh \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n. H\u00e0m XLOOKUP c\u0169ng kh\u00f4ng ngo\u1ea1i l\u1ec7.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29844 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2-1024x481-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-7\" width=\"1024\" height=\"481\" title=\"7-2-1024x481-1\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1eadn d\u1ee5ng vi\u1ec7c h\u00e0m XLOOKUP c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 c\u1ea3 m\u1ea3ng gi\u00e1 tr\u1ecb tr\u00ean, ta c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a nh\u1eefng h\u00e0ng ho\u00e1 ph\u00e1t sinh v\u00e0o l\u1ea7n cu\u1ed1i c\u00f9ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Noi_chuoi_linh_hoat_trong_ket_qua_tra_ve_cua_ham_XLOOKUP\"><\/span>N\u1ed1i chu\u1ed7i linh ho\u1ea1t trong k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u1ede ph\u1ea7n n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n s\u1ef1 linh ho\u1ea1t c\u1ee7a h\u00e0m XLOOKUP n\u00e0y \u1edf k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a n\u00f3. V\u00ed d\u1ee5 sau s\u1ebd l\u00e0m \u0111i\u1ec1u \u0111\u00f3<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/8-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29845\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-1-1024x371-1.png\" width=\"1024\" height=\"371\" title=\"8-1-1024x371-1\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1edbi h\u00e0m tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng ch\u1ec9 l\u00e0 nh\u1eefng con s\u1ed1 kh\u00f4 khan n\u1eefa. V\u1eadn d\u1ee5ng vi\u1ec7c h\u00e0m tr\u1ea3 v\u1ec1 c\u1ea3 m\u1ea3ng gi\u00e1 tr\u1ecb ta k\u1ebft h\u1ee3p th\u00eam c\u00e1c chu\u1ed7i TEXT l\u1ed3ng v\u00e0o trong k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u0111\u1ec3 xem s\u1ed1 l\u01b0\u1ee3ng v\u00e0 th\u00e0nh ti\u1ec1n ph\u00e1t sinh l\u1ea7n \u0111\u1ea7u ti\u00ean c\u0169ng nh\u01b0 cu\u1ed1i c\u00f9ng c\u1ee7a c\u00e1c h\u00e0ng ho\u00e1 c\u00f3 ph\u00e1t sinh.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_diem_thu_vi_khac\"><\/span>M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_XLOOKUP_long_XLOOKUP\"><\/span>S\u1eed d\u1ee5ng XLOOKUP l\u1ed3ng XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 sau s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a h\u00e0ng ho\u00e1 t\u00ednh t\u1eeb l\u00fac h\u00e0ng ho\u00e1 C c\u00f3 ph\u00e1t sinh \u0111\u1ea7u ti\u00ean t\u1edbi l\u00fac h\u00e0ng ho\u00e1 C c\u00f3 ph\u00e1t sinh l\u1ea7n cu\u1ed1i c\u00f9ng.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/9-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29847 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-1-1024x534-1.png\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-8\" width=\"1024\" height=\"534\" title=\"9-1-1024x534-1\"><\/a><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Khac_phuc_duoc_loi_chen_dong_cot_trong_ham_VLOOKUP_va_HLOOKUP\"><\/span>Kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i ch\u00e8n d\u00f2ng, c\u1ed9t trong h\u00e0m VLOOKUP v\u00e0 HLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">M\u1ed9t \u0111i\u1ec3m h\u1ea1n ch\u1ebf n\u1eefa c\u1ee7a h\u00e0m VLOOKUP c\u0169ng nh\u01b0 HLOOKUP l\u00e0 khi ch\u00fang ta th\u1ef1c hi\u1ec7n ch\u00e8n th\u00eam 1 c\u1ed9t (v\u1edbi h\u00e0m VLOOKUP) hay ch\u00e8n th\u00eam 1 d\u00f2ng (v\u1edbi h\u00e0m HLOOKUP) th\u00ec l\u00fac n\u00e0y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m s\u1ebd b\u1ecb sai. H\u00e0m XLOOKUP \u0111\u00e3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi, khi m\u00ecnh th\u1ef1c hi\u1ec7n ch\u00e8n th\u00eam c\u1ed9t v\u00e0o gi\u1eefa c\u1ed9t A v\u00e0\u00a0B th\u00ec k\u1ebft qu\u1ea3 \u1edf \u00f4 D3 s\u1eed d\u1ee5ng h\u00e0m XLOOKUP kh\u00f4ng b\u1ecb thay \u0111\u1ed5i c\u00f2n v\u1edbi \u00f4 D2 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP th\u00ec k\u1ebft qu\u1ea3 \u0111\u00e3 b\u1ecb thay \u0111\u1ed5i (d\u1eabn t\u1edbi sai). T\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m HLOOKUP, khi m\u00ecnh ch\u00e8n th\u00eam 1 d\u00f2ng v\u00e0o gi\u1eefa d\u00f2ng 7 v\u00e0 8 th\u00ec k\u1ebft qu\u1ea3 \u1edf \u00f4 H6 s\u1eed d\u1ee5ng h\u00e0m XLOOKUP kh\u00f4ng b\u1ecb thay \u0111\u1ed5i c\u00f2n \u00f4 H5 s\u1eed d\u1ee5ng h\u00e0m HLOOKUP th\u00ec k\u1ebft qu\u1ea3 \u0111\u00e3 b\u1ecb thay \u0111\u1ed5i (d\u1eabn t\u1edbi sai).<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/A.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29937 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/a-1024x394-1.gif\" alt=\"mot-so-dieu-thu-vi-ve-ham-Xlookup-9\" width=\"1024\" height=\"394\" title=\"a-1024x394-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Ta c\u0169ng kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 v\u1edbi h\u00e0m INDEX + MATCH, VLOOKUP + MATCH, HLOOKUP + MATCH,\u2026.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html\">H\u00e0m hlookup, n\u00ean s\u1eed d\u1ee5ng hlookup hay index k\u1ebft h\u1ee3p match s\u1ebd hay h\u01a1n<\/a><\/strong><\/em><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch v\u1eadn d\u1ee5ng h\u00e0m XLOOKUP \u2013 m\u1ed9t h\u00e0m m\u1edbi \u0111\u01b0\u1ee3c Microsoft c\u1eadp nh\u1eadt cho Office 365 b\u1ea3n Insider. V\u1ec1 c\u01a1 b\u1ea3n c\u00f3 h\u00e0m s\u1ebd c\u00f3 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng \u0111\u1ed1i gi\u1ed1ng v\u1edbi c\u00e1c h\u00e0m d\u00f2 t\u00ecm m\u00e0 ta \u0111\u00e3 bi\u1ebft nh\u01b0 VLOOKUP, HLOOKUP,\u2026Tuy nhi\u00ean c\u0169ng c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t, m\u1ed9t s\u1ed1 \u0111i\u1ec3m m\u1edbi, th\u00fa v\u1ecb \u0111\u1eb7c bi\u1ec7t l\u00e0 linh ho\u1ea1t h\u01a1n trong gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u0169ng nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. \u0110i\u1ec1u n\u00e0y \u0111\u00e3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c nh\u1eefng h\u1ea1n ch\u1ebf c\u1ee7a nh\u1eefng h\u00e0m d\u00f2 t\u00ecm kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u1edbi ph\u1ea7n Comnent b\u00ean d\u01b0\u1edbi, ch\u00fang t\u00f4i\u00a0hy v\u1ecdng s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00eam nh\u1eefng g\u00f3p \u00fd cho b\u00e0i vi\u1ebft c\u0169ng nh\u01b0 n\u1ebfu nh\u01b0 b\u1ea1n ph\u00e1t hi\u1ec7n ra c\u00e1c \u0111i\u1ec1u th\u00fa v\u1ecb\u00a0kh\u00e1c n\u1eefa v\u1ec1 h\u00e0m n\u00e0y \ud83d\ude0a<\/p>\n<hr>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-xlookup-danh-cho-office-365-insiders.html\">Gi\u1edbi thi\u1ec7u h\u00e0m xlookup d\u00e0nh cho office 365 insiders<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch tham chi\u1ebfu ng\u01b0\u1ee3c t\u1eeb ph\u1ea3i qua tr\u00e1i trong excel<\/strong><\/em><\/a><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ket-hop-vlookup-va-choose-tim-kiem-tu-phai-qua-trai.html\"><em><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p vlookup v\u00e0 choose: m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb ph\u1ea3i qua tr\u00e1i<\/strong><\/em><\/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\/2024\/12\/ex101_92019-nho-343.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4291,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4290","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4290","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=4290"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4290\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4291"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}