{"id":4234,"date":"2024-12-04T17:00:31","date_gmt":"2024-12-04T17:00:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/su-dung-xlookup-khi-khong-su-dung-office-365\/"},"modified":"2024-12-04T17:00:31","modified_gmt":"2024-12-04T17:00:31","slug":"su-dung-xlookup-khi-khong-su-dung-office-365","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/su-dung-xlookup-khi-khong-su-dung-office-365\/","title":{"rendered":"S\u1eed d\u1ee5ng XLOOKUP khi kh\u00f4ng s\u1eed d\u1ee5ng Office 365"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>B\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng Office 365 nh\u01b0ng l\u1ea1i mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m m\u1edbi c\u1ee7a Office 365 v\u1eady ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o nh\u1ec9? \u0110\u1eebng lo l\u1eafng v\u1ec1 v\u1ea5n \u0111\u1ec1 \u0111\u00f3<strong> <a href=\"http:\/\/blog.ezworkapp.com\/\">Hoc Excel Online<\/a><\/strong> s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 khi c\u00e0i \u0111\u1eb7t Add ins HocExcel Online v\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/mot-diem-thu-vi-ve-ham-xlookup.html\"><strong>h\u00e0m Xlookup<\/strong><\/a> nh\u00e9.\u00a0<\/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-67508aae5ce9f\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#Cau_truc_cua_ham\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#_Ham_XLOOKUP_trong_Office_365\" title=\"\u00a0 \u00a0H\u00e0m XLOOKUP trong Office 365\">\u00a0 \u00a0H\u00e0m XLOOKUP trong Office 365<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#_Ham_Heoxlookup_trong_Add_Ins_HocExcel_Online\" title=\"\u00a0 \u00a0H\u00e0m Heoxlookup trong Add Ins HocExcel Online\">\u00a0 \u00a0H\u00e0m Heoxlookup trong Add Ins HocExcel Online<\/a><\/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-5\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#Cach_su_dung\" title=\"C\u00e1ch s\u1eed d\u1ee5ng\">C\u00e1ch s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ti\u1ec7n \u00edch t\u1eeb Add ins HocExcel Online b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t Add ins HocExcel Online b\u1ea1n n\u00e0o ch\u01b0a c\u00f3 th\u00ec t\u1ea3i Add ins ngay.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"_Ham_XLOOKUP_trong_Office_365\"><\/span><strong>\u00a0 \u00a0H\u00e0m XLOOKUP trong Office 365<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p>XLOOKUP(lookup_value,lookup_array,return_array,match_mode,search_mode)<\/p>\n<\/blockquote>\n<ul>\n<li><strong>lookup_value:<\/strong>\u00a0L\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/li>\n<li><strong>lookup_array:<\/strong>\u00a0L\u00e0 v\u00f9ng (m\u1ea3ng) t\u00ecm ki\u1ebfm<\/li>\n<li><strong>return_array:<\/strong>\u00a0L\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>\u00a0L\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>\u00a0L\u00e0 l\u1ef1a ch\u1ecdn ch\u1ebf \u0111\u1ed9 t\u00ecm ki\u1ebfm<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"_Ham_Heoxlookup_trong_Add_Ins_HocExcel_Online\"><\/span>\u00a0 \u00a0H\u00e0m Heoxlookup trong Add Ins HocExcel Online<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>HeoXlookup(Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm *,M\u1ea3ng t\u00ecm ki\u1ebfm *,M\u1ea3ng k\u1ebft qu\u1ea3 *,[Ch\u1ebf \u0111\u1ed9],[T\u00ecm ki\u1ebfm],[T\u00f9y ch\u1ecdn])<\/strong><\/p>\n<\/blockquote>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm: 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>M\u1ea3ng t\u00ecm ki\u1ebfm: C\u1ea7n kh\u1edbp nhau v\u1ec1 k\u00edch th\u01b0\u1edbc<\/li>\n<li>M\u1ea3ng k\u1ebft qu\u1ea3 : Gi\u00e1 tr\u1ecb hay m\u1ed9t m\u1ea3ng mu\u1ed1n tr\u1ea3 v\u1ec1<\/li>\n<li>[Ch\u1ebf \u0111\u1ed9]: M\u1eb7c \u0111\u1ecbnh l\u00e0 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c (0 \u2013 Exact match)<\/li>\n<li>[T\u00ecm ki\u1ebfm]:\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<li>[T\u00f9y ch\u1ecdn]: xoay =y, chen = y, ten = ? , xoaname = ?, tudong = y<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29997 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xlookup.png\" alt=\"su-dung-ham-xlookup-1\" width=\"972\" height=\"551\" title=\"xlookup\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 XLOOKUP; \u00a0h\u00e0m HeoXlookup s\u1eed d\u1ee5ng c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30012 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/asdflkasdfj.gif\" alt=\"su-dung-ham-xlookup-2\" width=\"1906\" height=\"878\" title=\"asdflkasdfj\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a\u00a0<strong>H\u1ecdc Excel Online\u00a0<\/strong>b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/khong-su-dung-office-365-ban-co-su-dung-xlookup-va-xmatch-duoc-khong.html\"><strong>S\u1eed d\u1ee5ng XLOOKUP khi kh\u00f4ng s\u1eed d\u1ee5ng Office 365<\/strong><\/a> h\u00e0m xu\u1ea5t hi\u1ec7n tr\u00ean Add ins HocExcel Online<\/p>\n<hr>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/mot-diem-thu-vi-ve-ham-xlookup.html\">M\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 Xlookup<\/a><\/strong><\/em><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-146.gif\" title=\"vba101_92019-nho-146\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-339.gif\" title=\"ex101_92019-nho-339\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><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><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><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><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">H\u00e0m vlookup trong excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/a>.<\/strong><\/em><\/p>\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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-146.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4234","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\/4234","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=4234"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4234\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4235"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}