{"id":972,"date":"2024-12-02T03:14:55","date_gmt":"2024-12-02T03:14:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu\/"},"modified":"2024-12-02T03:14:55","modified_gmt":"2024-12-02T03:14:55","slug":"tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu\/","title":{"rendered":"Tuy\u1ec3n t\u1eadp nh\u1eefng b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m Vlookup \u2013 chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span class=\"\">Microsoft Excel l\u00e0 m\u1ed9t ch\u01b0\u01a1ng tr\u00ecnh ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 b\u1ea3ng t\u00ednh m\u1ea1nh m\u1ebd v\u1edbi s\u1ef1 h\u1ed7 tr\u1ee3 m\u1ea1nh m\u1ebd c\u1ee7a c\u00e1c h\u00e0m. <\/span>Tham gia m\u1ed9t kh\u00f3a h\u1ecdc Excel Online kh\u00f4ng ch\u1ec9 l\u00e0 l\u00e0 m\u1ed9t c\u00e1ch t\u1ed1t \u0111\u1ec3 h\u1ecdc Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3, \u0111\u1eb7c bi\u1ec7t \u0111\u00e2y ch\u00ednh l\u00e0 xu h\u01b0\u1edbng m\u1edbi khi \u0111\u1ea1i d\u1ecbch Covid \u2013 19 b\u00f9ng ph\u00e1t. V\u1eeba ti\u1ebft ki\u1ec7m th\u1eddi gian di chuy\u1ec3n, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 h\u1ecdc m\u1ecdi l\u00fac, m\u1ecdi n\u01a1i b\u1ea5t c\u1ee9 n\u01a1i \u0111\u00e2u b\u1ea1n mu\u1ed1n.<\/p>\n<p>Microsoft Excel cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng c\u00e1c h\u00e0m \u0111\u1ec3 \u00a0x\u1eed l\u00fd th\u00f4ng tin d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng, th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u00e0 x\u00e2y d\u1ef1ng c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea tr\u1ef1c quan c\u00f3 trong b\u1ea3ng t\u1eeb Excel. \u00a0H\u00e3y c\u00f9ng Blog H\u1ecdc Excel b\u01b0\u1edbc v\u00e0o series \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i b\u00e0i h\u1ecdc v\u1ec1 c\u00e1c h\u00e0m quan tr\u1ecdng nh\u1ea5t c\u1ee7a Excel b\u1ea1n nh\u00e9!<\/p>\n<p>Trong ho\u00e0ng lo\u1ea1t c\u00e1c h\u00e0m c\u1ee7a Excel nh\u01b0 Vlookup, Hlookup, h\u00e0m Sumif, h\u00e0m If \u2026 th\u00ec h\u00e0m Vlookup c\u00f3 ch\u1ee9c n\u0103ng \u00a0tra c\u1ee9u v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u trong b\u1ea3ng. Ch\u1eef \u201cV\u201d trong h\u00e0m VLOOKUP l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a<strong> vertical<\/strong>, c\u00f3 ngh\u0129a l\u00e0 d\u1eef li\u1ec7u trong b\u1ea3ng ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u d\u1ecdc, d\u1eef li\u1ec7u theo h\u00e0ng.<\/p>\n<figure id=\"attachment_35849\" aria-describedby=\"caption-attachment-35849\" style=\"width: 869px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-35849\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-1.png\" alt=\"H\u00e0m vlookup v\u00e0 \u1ee9ng d\u1ee5ng\" width=\"869\" height=\"489\" title=\"vi-du-ham-vlookup-va-nhieu-ung-dung-1\"><figcaption id=\"caption-attachment-35849\" class=\"wp-caption-text\">C\u00e1c b\u00e0i vi\u1ebft quan tr\u1ecdng v\u1ec1 h\u00e0m Vlookup<\/figcaption><\/figure>\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-674d262e8e19c\" 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\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#1_Ham_vlookup_la_gi_Cach_su_dung_ham_Vlookup\" title=\"1. H\u00e0m vlookup l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup\">1. H\u00e0m vlookup l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/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\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#2_Bai_tap_excel_ham_vlookup_ket_hop_voi_Ham_MinuteSecond_Vlookup_Countif_phan_1\" title=\"2. B\u00e0i t\u1eadp excel h\u00e0m vlookup k\u1ebft h\u1ee3p v\u1edbi H\u00e0m Minute\/Second, Vlookup, Countif (ph\u1ea7n 1)\">2. B\u00e0i t\u1eadp excel h\u00e0m vlookup k\u1ebft h\u1ee3p v\u1edbi H\u00e0m Minute\/Second, Vlookup, Countif (ph\u1ea7n 1)<\/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\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#3_Ham_vlookup_nang_cao_va_cach_su_dung_chi_tiet\" title=\"3. H\u00e0m vlookup n\u00e2ng cao v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft\">3. H\u00e0m vlookup n\u00e2ng cao v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#4_Ham_vlookup_ket_hop_ham_left_right\" title=\"4. H\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m left, right\">4. H\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m left, right<\/a><\/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\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#5_Ham_sumif_ket_hop_vlookup\" title=\"5. H\u00e0m sumif k\u1ebft h\u1ee3p vlookup\">5. H\u00e0m sumif k\u1ebft h\u1ee3p vlookup<\/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\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#6_Ham_vlookup_if_ham_vlookup_co_dieu_kien_if\" title=\"6. H\u00e0m vlookup if\/ h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n if\">6. H\u00e0m vlookup if\/ h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n if<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#7_Ham_vlookup_2_dieu_kien\" title=\"7. H\u00e0m vlookup 2 \u0111i\u1ec1u ki\u1ec7n\">7. H\u00e0m vlookup 2 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#8_Cach_su_dung_ham_vlookup_va_hlookup\" title=\"8. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup v\u00e0 hlookup\">8. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup v\u00e0 hlookup<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tuyen-tap-nhung-bai-viet-ve-ham-vlookup-chi-tiet-de-hieu.html#9_Cach_khac_phuc_loi_ham_vlookup_khong_chay\" title=\"9. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i h\u00e0m vlookup kh\u00f4ng ch\u1ea1y\">9. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i h\u00e0m vlookup kh\u00f4ng ch\u1ea1y<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Ham_vlookup_la_gi_Cach_su_dung_ham_Vlookup\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><b>1. H\u00e0m vlookup l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vlookup l\u00e0 c\u1ee5m t\u1eeb vi\u1ebft t\u1eaft c\u1ee7a \u2018Vertical Lookup\u201d. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m quan tr\u1ecdng trong Excel gi\u00fap t\u00ecm<em> t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb theo c\u1ed9t v\u00e0 tr\u1ea3 v\u1ec1 ph\u01b0\u01a1ng th\u1ee9c h\u00e0ng d\u1ecdc (theo c\u1ed9t), n\u00f3 gi\u00fap ch\u00fang ta th\u1ed1ng k\u00ea, d\u00f2 t\u00ecm d\u1eef li\u1ec7u theo c\u1ed9t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i.<\/em><\/p>\n<p>C\u00f4ng vi\u1ec7c s\u1ebd tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n khi b\u1ea1n th\u00e0nh th\u1ea1o h\u00e0m \u0111a n\u0103ng Vlookup. \u0110\u1eebng ng\u1ea1i ng\u1ea7n nh\u1ea5p ngay v\u00e0o \u0111\u01b0\u1eddng link \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang nh\u00e9!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Bai_tap_excel_ham_vlookup_ket_hop_voi_Ham_MinuteSecond_Vlookup_Countif_phan_1\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-excel-voi-cac-ham-minutesecond-ham-vlookup-ham-countif.html\"><b>2. B\u00e0i t\u1eadp excel h\u00e0m vlookup k\u1ebft h\u1ee3p v\u1edbi H\u00e0m Minute\/Second, Vlookup, Countif<\/b><\/a><b> (ph\u1ea7n 1)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e0i vi\u1ebft n\u00e3y s\u1ebd cung c\u1ea5p cho b\u1ea1n nh\u1eefng v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u1ea5t c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup. B\u1ea1n ho\u00e0n to\u00e0n t\u1ea3i mi\u1ec5n ph\u00ed b\u1ed9 \u0111\u1ec1 thi, t\u1ef1 h\u1ecdc v\u00e0 t\u1ef1 ki\u1ec3m tra k\u1ef9 n\u0103ng c\u1ee7a m\u00ecnh m\u1ed7i ng\u00e0y. Nh\u1eefng v\u00ed d\u1ee5 c\u0169ng \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y chi ti\u1ebft, d\u1ec5 hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup k\u1ebft h\u1ee3p v\u1edbi c\u00e1c\u00a0 H\u00c0M MINUTE\/SECOND, H\u00c0M VLOOKUP, H\u00c0M COUNTIF<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Ham_vlookup_nang_cao_va_cach_su_dung_chi_tiet\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html\"><b>3. H\u00e0m vlookup n\u00e2ng cao v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Vlookup n\u00e2ng cao \u00a0s\u1ebd gi\u1ea3i quy\u1ebft nh\u1eefng t\u00ecnh hu\u1ed1ng n\u00e2ng cao m\u00e0 h\u00e0m Vlookup th\u00f4ng th\u01b0\u1eddng kh\u00f4ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c. rong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c Vlookup n\u00e2ng cao, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLookup l\u1ed3ng c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, c\u00e1ch tra c\u1ee9u hai chi\u1ec1u v\u1edbi h\u00e0m VLOOKUP. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u n\u00e0o!<\/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-63.gif\" title=\"ex101_92019-nho-63\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"4_Ham_vlookup_ket_hop_ham_left_right\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html\"><b>4. H\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m left, right<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e0i vi\u1ebft n\u00e3y s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m left, right m\u1ed9t c\u00e1ch linh ho\u1ea1t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Ham_sumif_ket_hop_vlookup\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html\"><b>5. H\u00e0m sumif k\u1ebft h\u1ee3p vlookup<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi nh\u1eefng b\u1ea1n th\u01b0\u1eddng xuy\u00ean ti\u1ebfp x\u00fac v\u1edbi s\u1ed1 li\u1ec7u, x\u1eed l\u00fd c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u Excel th\u00ec kh\u00f4ng qu\u00e1 xa l\u1ea1 v\u1edbi v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa 2 h\u00e0m sumif v\u00e0 vlookup. H\u00e0m Sumif d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 \u0111i\u1ec1u ki\u1ec7n, c\u00f2n h\u00e0m Vlookup \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong m\u1ea3ng. V\u00e0 vi\u1ec7c k\u1ebft h\u1ee3p 2 h\u00e0m Sumif v\u00e0 h\u00e0m Vlookup trong Excel c\u00f9ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng r\u1ea5t nhi\u1ec1u.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_Ham_vlookup_if_ham_vlookup_co_dieu_kien_if\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-ket-hop-ham.html\"><b>6. H\u00e0m vlookup if\/ h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n if<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p IF trong Excel. Ngo\u00e0i ra b\u1ea1n c\u0169ng t\u00ecm th\u1ea5y c\u00e1ch thay l\u1ed7i #N\/A b\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n t\u1ef1 \u0111\u1ecbnh ngh\u0129a.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"7_Ham_vlookup_2_dieu_kien\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html\"><b>7. H\u00e0m vlookup 2 \u0111i\u1ec1u ki\u1ec7n<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"8_Cach_su_dung_ham_vlookup_va_hlookup\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\"><b>8. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup v\u00e0 hlookup<\/b><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>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<h2><span class=\"ez-toc-section\" id=\"9_Cach_khac_phuc_loi_ham_vlookup_khong_chay\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-cac-loi-thuong-gap-nguyen-nhan-va-cach-khac-phuc.html\">9. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i h\u00e0m vlookup kh\u00f4ng ch\u1ea1y<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m\u00a0<strong>VLOOKUP\u00a0<\/strong>l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ee9c t\u1ea1p nh\u1ea5t m\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p ch\u00ednh l\u00e0\u00a0<strong><em>#N\/A.\u00a0<\/em><\/strong><em>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n<strong>\u00a0c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i h\u00e0m Vlookup\u00a0<\/strong><\/em><\/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-63.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-972","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\/972","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=972"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/972\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/973"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}