{"id":10783,"date":"2025-01-14T23:45:24","date_gmt":"2025-01-14T23:45:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-viet-ham-vlookup-ket-hop-ham-if\/"},"modified":"2025-01-14T23:45:24","modified_gmt":"2025-01-14T23:45:24","slug":"huong-dan-cach-viet-ham-vlookup-ket-hop-ham-if","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-viet-ham-vlookup-ket-hop-ham-if\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m IF"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m\u00a0IF v\u00e0 h\u00e0m VLOOKUP l\u00e0 hai h\u00e0m ph\u1ed5 bi\u1ebfn trong\u00a0Excel m\u00e0 h\u1ea7u nh\u01b0 ch\u00fang ta\u00a0\u0111\u1ec1u bi\u1ebft. V\u1eady b\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y trong c\u00f9ng 1 c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 kh\u00f4ng? H\u00e3y c\u00f9ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc\u00a0Excel Online<\/a><\/strong> t\u00ecm hi\u1ec3u c\u00e1ch\u00a0vi\u1ebft h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m VLOOKUP trong\u00a0Excel nh\u00e9:<\/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-6786f713dd179\" 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\/ham-vlookup-ket-hop-ham.html#Vi_du_1_Dung_IF_de_bay_loi_cho_ham_VLOOKUP\" title=\"V\u00ed d\u1ee5 1: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 b\u1eaby l\u1ed7i cho h\u00e0m VLOOKUP\">V\u00ed d\u1ee5 1: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 b\u1eaby l\u1ed7i cho 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\/ham-vlookup-ket-hop-ham.html#Vi_du_2_Dung_IF_de_tuy_bien_vi_tri_cot_tham_chieu_trong_ham_Vlookup\" title=\"V\u00ed d\u1ee5 2: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn v\u1ecb tr\u00ed c\u1ed9t tham chi\u1ebfu trong h\u00e0m Vlookup\">V\u00ed d\u1ee5 2: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn v\u1ecb tr\u00ed c\u1ed9t tham chi\u1ebfu trong 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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-ket-hop-ham.html#Vi_du_3_Xac_dinh_don_gia_san_pham_khi_don_gia_co_su_thay_doi_theo_thang\" title=\"V\u00ed d\u1ee5 3: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m khi \u0111\u01a1n gi\u00e1 c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i theo th\u00e1ng\">V\u00ed d\u1ee5 3: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m khi \u0111\u01a1n gi\u00e1 c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i theo th\u00e1ng<\/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\/ham-vlookup-ket-hop-ham.html#Vi_du_4_Ket_hop_VLOOKUP_va_ham_IF_de_tra_ve_gia_tri_TRUEFALSE_hoac_1_va_0\" title=\"V\u00ed d\u1ee5 4: K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0\">V\u00ed d\u1ee5 4: K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-ket-hop-ham.html#Su_dung_ket_hop_ham_VLOOKUP_va_ham_IF_de_tinh_toan_theo_dieu_kien\" title=\"S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-ket-hop-ham.html#Xu_ly_loi_NA_khi_VLOOKUP_khong_tim_thay_gia_tri_trong_bang\" title=\"X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng\">X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_1_Dung_IF_de_bay_loi_cho_ham_VLOOKUP\"><\/span>V\u00ed d\u1ee5 1: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 b\u1eaby l\u1ed7i cho h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12427 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic01-4.png\" width=\"708\" height=\"304\" title=\"pic01-4\"><\/p>\n<p>\u1ede h\u00ecnh tr\u00ean, ch\u00fang ta th\u1ea5y c\u00f4ng th\u1ee9c\u00a0\u1edf\u00a0\u00f4 E2 cho k\u1ebft qu\u1ea3 l\u1ed7i. B\u1edfi v\u00ec n\u1ed9i dung\u00a0\u1edf\u00a0\u00f4 D2 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb, t\u1ee9c l\u00e0 Lookup_Value kh\u00f4ng c\u00f3 n\u1ed9i dung n\u00ean s\u1ebd b\u00e1o l\u1ed7i #N\/A<\/p>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m\u00a0IF nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=<strong>IF(D2=\u201d\u201d,\u201d\u201d,<\/strong>VLOOKUP(D2,$A$2:$B$7,2,0))<\/p>\n<\/blockquote>\n<ul>\n<li>N\u1ebfu\u00a0\u00f4 D2 (lookup_value c\u1ee7a h\u00e0m vlookup) l\u00e0 r\u1ed7ng th\u00ec s\u1ebd r\u1ed7ng<\/li>\n<li>N\u1ebfu\u00a0\u00f4 D2 kh\u00f4ng r\u1ed7ng th\u00ec s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_2_Dung_IF_de_tuy_bien_vi_tri_cot_tham_chieu_trong_ham_Vlookup\"><\/span>V\u00ed d\u1ee5 2: D\u00f9ng\u00a0IF\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn v\u1ecb tr\u00ed c\u1ed9t tham chi\u1ebfu trong h\u00e0m Vlookup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12430 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic04-4.png\" width=\"552\" height=\"294\" title=\"pic04-4\"><\/p>\n<p>\u1ede v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta mu\u1ed1n khi thay\u00a0\u0111\u1ed5i\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u1edf\u00a0\u00f4 E1\u00a0\u0111\u1ec3 x\u00e9t k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Vlookup t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0y.<\/p>\n<p>N\u1ebfu E1 l\u00e0 S\u1ed1 ti\u1ec1n th\u00ec s\u1ebd<\/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\/2025\/01\/vba101_92019-nho-21.gif\" title=\"vba101_92019-nho-21\"><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\/2025\/01\/ex101_92019-nho-222.gif\" title=\"ex101_92019-nho-222\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u1ed9t Gi\u1edbi t\u00ednh: C\u1ed9t 3<\/p>\n<p>Ch\u00fang ta k\u1ebft h\u1ee3p h\u00e0m\u00a0IF nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=<em>IF(D2=\u201d\u201d,\u201d\u201d,<\/em>VLOOKUP(D2,$A$2:$C$7,<strong>IF(E1=\u201dS\u1ed1 ti\u1ec1n\u201d,2,3)<\/strong>,0))<\/p>\n<\/blockquote>\n<p>Kh\u00e1c v\u1edbi v\u00ed d\u1ee5 1,\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta c\u1ea7n m\u1edf r\u1ed9ng b\u1ea3ng tham chi\u1ebfu bao g\u1ed3m c\u1ea3 c\u1ed9t C<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_3_Xac_dinh_don_gia_san_pham_khi_don_gia_co_su_thay_doi_theo_thang\"><\/span>V\u00ed d\u1ee5 3: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m khi \u0111\u01a1n gi\u00e1 c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i theo th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23717\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-long-if-1.png\" width=\"1109\" height=\"222\" title=\"vlookup-long-if-1\"><\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y ch\u00fang ta th\u1ea5y th\u1eddi gian ph\u00e1t sinh g\u1ed3m 2 th\u00e1ng 4 v\u00e0 5.\u00a0V\u00e0 trong th\u00e1ng 4, c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 1\u00a0\u0111\u01a1n gi\u00e1. Sang th\u00e1ng 5\u00a0\u0111\u01a1n gi\u00e1\u00a0\u0111\u00f3 thay\u00a0\u0111\u1ed5i theo b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 5. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00fang\u00a0\u0111\u01a1n gi\u00e1 theo t\u1eebng th\u1eddi\u00a0\u0111i\u1ec3m ph\u00e1t sinh?<\/p>\n<p>C\u00e1ch l\u00e0m l\u00e0 ch\u00fang ta ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c th\u00e1ng c\u1ee7a t\u1eebng l\u1ea7n ph\u00e1t sinh, r\u1ed3i d\u1ef1a v\u00e0o\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 bi\u1ec7n lu\u1eadn xem l\u1ea7n ph\u00e1t sinh\u00a0\u0111\u00f3 l\u00e0 th\u00e1ng m\u1ea5y.<\/p>\n<p><strong>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh th\u00e1ng v\u1edbi h\u00e0m MONTH<\/strong><\/p>\n<p>H\u00e0m MONTH l\u00e0 h\u00e0m gi\u00fap x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 th\u00e1ng trong 1\u00a0\u00f4 ch\u1ee9a d\u1eef li\u1ec7u th\u1eddi gian.<\/p>\n<p>Khi x\u00e9t MONTH(A2) ta thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 b\u1eb1ng 4, MONTH(A5) cho k\u1ebft qu\u1ea3 b\u1eb1ng 5<\/p>\n<div class=\"code-block code-block-1\">\n<div class=\"ad-inserterpro\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-222.gif\" title=\"ex101_92019-nho-222\"><\/a><\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 2: Bi\u1ec7n lu\u1eadn b\u1eb1ng h\u00e0m\u00a0IF<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m MONTH ch\u00ednh l\u00e0\u00a0c\u0103n c\u1ee9 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh b\u1ea3ng tham chi\u1ebfu\u00a0c\u1ee7a h\u00e0m VLOOKUP.\u00a0N\u1ebfu k\u1ebft qu\u1ea3 b\u1eb1ng 4 th\u00ec tham chi\u1ebfu trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 4, k\u1ebft qu\u1ea3 b\u1eb1ng 5 th\u00ec tham chi\u1ebfu trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 5.<\/p>\n<p>V\u1eady n\u00ean ta c\u00f3 th\u1ec3 vi\u1ebft:<\/p>\n<p>D2=IF(MONTH(A2)=4,s\u1eed d\u1ee5ng vlookup tham chi\u1ebfu t\u1edbi b\u1ea3ng th\u00e1ng 4, s\u1eed d\u1ee5ng tham chi\u1ebfu t\u1edbi b\u1ea3ng th\u00e1ng 5)<\/p>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u1ec9 c\u00f3 th\u00e1ng 4 ho\u1eb7c th\u00e1ng 5, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 bi\u1ec7n lu\u1eadn theo h\u01b0\u1edbng kh\u00f4ng ph\u1ea3i th\u00e1ng 4 th\u00ec l\u00e0 th\u00e1ng 5.<\/p>\n<p><strong>B\u01b0\u1edbc 3: Tham chi\u1ebfu b\u1eb1ng h\u00e0m VLOOKUP<\/strong><\/p>\n<p>V\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng b\u1ea3ng th\u00e1ng 4\u00a0\u0111\u1ec3 tham chi\u1ebfu, ta c\u00f3 h\u00e0m vlookup nh\u01b0 sau:<\/p>\n<p>=VLOOKUP(B2,G3:H7,2,0)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>B2 l\u00e0 t\u00ean s\u1ea3n ph\u1ea9m l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n tham chi\u1ebfu<\/li>\n<li>G3:H7 l\u00e0 v\u00f9ng b\u1ea3ng tham chi\u1ebfu\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 4 (\u1edf\u00a0\u0111\u00e2y c\u00f3 th\u1ec3 t\u00ednh c\u1ea3 d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 l\u00e0 G2:H7 v\u1eabn kh\u00f4ng sai)<\/li>\n<li>2 l\u00e0 c\u1ed9t k\u1ebft qu\u1ea3 c\u1ea7n tham chi\u1ebfu, ch\u00ednh l\u00e0\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m t\u01b0\u01a1ng\u00a0\u1ee9ng<\/li>\n<li>0 l\u00e0 ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu ch\u00ednh x\u00e1c theo t\u00ean s\u1ea3n ph\u1ea9m.<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 n\u1ebfu tham chi\u1ebfu b\u1ea3ng \u0111\u01a1n gi\u00e1 th\u00e1ng 5 ch\u00fang ta c\u00f3:<\/p>\n<p>=VLOOKUP(B2,J3:K7,2,0)<\/p>\n<p><strong>B\u01b0\u1edbc 4: K\u1ebft h\u1ee3p c\u00e1c h\u00e0m trong c\u00f9ng 1 c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p>Khi x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c t\u1eebng h\u00e0m ri\u00eang l\u1ebb, ch\u00fang ta c\u00f3 th\u1ec3 gh\u00e9p c\u00e1c h\u00e0m v\u00e0o trong c\u00f4ng th\u1ee9c theo th\u1ee9 t\u1ef1:<\/p>\n<p>D2=IF(MONTH(A2)=4,=VLOOKUP(B2,G3:H7,2,0),VLOOKUP(B2,J3:K7,2,0))<\/p>\n<p>Tuy nhi\u00ean ch\u00fang ta c\u1ea7n l\u01b0u\u00a0\u00fd l\u00e0 c\u00e1c b\u1ea3ng tham chi\u1ebfu\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 4, th\u00e1ng 5 l\u00e0 nh\u1eefng b\u1ea3ng c\u00f3 ph\u1ea1m vi x\u00e1c\u00a0\u0111\u1ecbnh. N\u1ebfu tham chi\u1ebfu t\u1edbi c\u00e1c v\u00f9ng b\u1ea3ng n\u00e0y ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh t\u1ecda\u00a0\u0111\u1ed9 l\u1ea1i\u00a0\u0111\u1ec3 tr\u00e1nh v\u00f9ng tham chi\u1ebfu b\u1ecb thay\u00a0\u0111\u1ed5i<\/p>\n<p>(xem th\u00eam b\u00e0i:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-giu-o-tham-chieu-co-dinh-trong-excel.html\">C\u00e1ch gi\u1eef \u00f4 tham chi\u1ebfu c\u1ed1 \u0111\u1ecbnh trong Excel<\/a>)<\/p>\n<p>Khi\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c s\u1ebd\u00a0\u0111\u01b0\u1ee3c s\u1eeda l\u1ea1i l\u00e0:<\/p>\n<p>=IF(MONTH(A2)=4,VLOOKUP(B2,$G$3:$H$7,2,0),VLOOKUP(B2,$J$3:$K$7,2,0))<\/p>\n<p>Filldown c\u00f4ng th\u1ee9c t\u1eeb D2 t\u1edbi D8 ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23718\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-long-if-ket-qua-1.png\" width=\"1107\" height=\"270\" title=\"vlookup-long-if-ket-qua-1\"><\/p>\n<p>K\u1ebft qu\u1ea3\u00a0\u0111\u00e3 t\u1ea1o ra\u00a0\u0111\u01b0\u1ee3c s\u1ef1 kh\u00e1c bi\u1ec7t trong\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a th\u00e1ng 4 v\u1edbi th\u00e1ng 5 r\u1ed3i.<\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi b\u1ea5t k\u1ef3 c\u00e1ch t\u1ed5\u00a0ch\u1ee9c d\u1eef li\u1ec7u n\u00e0o ch\u00fang ta c\u0169ng\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 t\u00f9y bi\u1ebfn c\u00f4ng th\u1ee9c cho ph\u00f9 h\u1ee3p\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a ra\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/p>\n<p><em><strong>L\u01b0u\u00a0\u00fd:<\/strong><\/em><\/p>\n<p>Tr\u01b0\u1edbc khi x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c, ch\u00fang ta c\u1ea7n ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh t\u1eebng b\u01b0\u1edbc, chia nh\u1ecf v\u1ea5n\u00a0\u0111\u1ec1 cho r\u00f5 r\u00e0ng. Sau khi\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 c\u00e1c h\u00e0m c\u1ea7n d\u00f9ng, v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t c\u00e1c h\u00e0m v\u00e0 l\u00e0m r\u00f5 n\u1ed9i dung t\u1eebng h\u00e0m, ch\u00fang ta m\u1edbi gh\u00e9p l\u1ea1i v\u00e0o 1 c\u00f4ng th\u1ee9c. Nh\u01b0 v\u1eady d\u00f9 c\u00f4ng th\u1ee9c c\u00f3 d\u00e0i, c\u00f3 ph\u1ee9c t\u1ea1p nh\u01b0ng ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 v\u00e0 ho\u00e0n to\u00e0n hi\u1ec3u, t\u1ef1 vi\u1ebft l\u1ea1i\u00a0\u0111\u01b0\u1ee3c<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_4_Ket_hop_VLOOKUP_va_ham_IF_de_tra_ve_gia_tri_TRUEFALSE_hoac_1_va_0\"><\/span>V\u00ed d\u1ee5 4: K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>V\u00ed d\u1ee5 4.1:<\/strong><em> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 1 danh s\u00e1ch h\u00e0ng ho\u00e1 trong kho v\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c lo\u1ea1i h\u00e0ng ho\u00e1 n\u00e0y, n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t ph\u00e2n t\u00edch \u0111\u01a1n gi\u1ea3n b\u1eb1ng vi\u1ec7c \u0111i\u1ec1n v\u00e0o d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng b\u1eb1ng 0 l\u00e0 \u201ch\u1ebft h\u00e0ng\u201d, \u0111i\u1ec1n v\u00e0o d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 0 l\u00e0 \u201cc\u00f2n h\u00e0ng\u201d th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF nh\u01b0 sau:<\/em><\/p>\n<figure id=\"attachment_31548\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-31548\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-ham-if-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-hop-vlookup-va-ham-if-trong-excel.png\" alt=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF trong Excel\" width=\"1702\" height=\"550\" title=\"ket-hop-vlookup-va-ham-if-trong-excel\"><\/a><figcaption id=\"caption-attachment-31548\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF trong Excel<\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c tr\u00ean tra c\u1ee9u s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a s\u1ea3n ph\u1ea9m Nho, sau \u0111\u00f3 so s\u00e1nh k\u1ebft qu\u1ea3 n\u00e0y n\u1ebfu l\u1edbn h\u01a1n 0 th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u201cC\u00f2n h\u00e0ng\u201d, n\u1ebfu kh\u00f4ng k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 \u201cH\u1ebft h\u00e0ng\u201d<\/p>\n<p>Xem th\u00eam:\u00a0<strong>S\u1eed d\u1ee5ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/vlookup-nhieu-cot-nhieu-dieu-kien.html\">h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a>\u00a0trong Excel<\/strong><\/p>\n<p><strong>V\u00ed d\u1ee5 4.2:<\/strong> <em>Trong t\u00ecnh h\u00ecnh th\u1ecb tr\u01b0\u1eddng c\u00f3 bi\u1ebfn \u0111\u1ed9ng, ch\u00fang ta s\u1ebd c\u1ea7n c\u00f3 m\u1ee9c thi\u1ebft l\u1eadp t\u1ed3n kho an to\u00e0n kh\u00e1c nhau tu\u1ef3 theo t\u1eebng th\u1eddi \u0111i\u1ec3m, gi\u1ea3 s\u1eed trong th\u1eddi \u0111i\u1ec3m \u0111\u1ea7u n\u0103m, m\u1ee9c t\u1ed3n kho an to\u00e0n c\u1ee7a ch\u00fang ta \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 G1 l\u00e0 15 \u0111\u01a1n v\u1ecb s\u1ea3n ph\u1ea9m. Ch\u00fang ta mu\u1ed1n ki\u1ec3m tra s\u1ea3n ph\u1ea9m \u201cT\u00e1o\u201d c\u1ee7a ch\u00fang ta c\u00f3 tr\u1ea1ng th\u00e1i t\u1ed3n kho nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 trong h\u00ecnh minh ho\u1ea1.<\/em><\/p>\n<figure id=\"attachment_31549\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31549\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-if-kiem-tra-ton-kho.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-hop-vlookup-va-if-kiem-tra-ton-kho.png\" alt=\"Ki\u1ec3m tra t\u1ed3n kho an to\u00e0n v\u1edbi VLOOKUP v\u00e0 h\u00e0m IF\" width=\"1810\" height=\"548\" title=\"ket-hop-vlookup-va-if-kiem-tra-ton-kho\"><\/a><figcaption id=\"caption-attachment-31549\" class=\"wp-caption-text\">Ki\u1ec3m tra t\u1ed3n kho an to\u00e0n v\u1edbi VLOOKUP v\u00e0 h\u00e0m IF<\/figcaption><\/figure>\n<p><strong>V\u00ed d\u1ee5 4.3:<\/strong> <em>Ch\u00fang ta c\u00f3 2 danh s\u00e1ch: danh s\u00e1ch h\u00e0ng ho\u00e1 trong kho v\u00e0 danh s\u00e1ch h\u00e0ng \u0111\u1ee7 ti\u00eau chu\u1ea9n xu\u1ea5t kh\u1ea9u, v\u1eady l\u00e0m sao \u0111\u1ec3 so s\u00e1nh 2 danh s\u00e1ch n\u00e0y v\u1edbi nhau v\u00e0 \u0111\u00e1nh d\u1ea5u m\u1eb7t h\u00e0ng n\u00e0o trong kho \u0111\u1ee7 ti\u00eau chu\u1ea9n xu\u1ea5t kh\u1ea9u? Ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m IF v\u00e0 h\u00e0m ISNA nh\u01b0 trong h\u00ecnh minh ho\u1ea1 nh\u01b0 sau<\/em><\/p>\n<div class=\"code-block code-block-1\">\n<div class=\"ad-inserterpro\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-222.gif\" title=\"ex101_92019-nho-222\"><\/a><\/div>\n<\/div>\n<figure id=\"attachment_31551\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31551\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-ham-if-isna-vlookup-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31551\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-hop-ham-if-isna-vlookup-trong-excel.png\" alt=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP, IF, ISNA\" width=\"1876\" height=\"548\" title=\"ket-hop-ham-if-isna-vlookup-trong-excel\"><\/a><figcaption id=\"caption-attachment-31551\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP, IF, ISNA<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_ham_VLOOKUP_va_ham_IF_de_tinh_toan_theo_dieu_kien\"><\/span><span id=\"Su_dung_ket_hop_ham_VLOOKUP_va_ham_IF_de_tinh_toan_theo_dieu_kien\" class=\"ez-toc-section\"><\/span>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>V\u00ed d\u1ee5 4:<\/strong> <em>Gi\u1ea3 s\u1eed b\u1ea1n qu\u1ea3n l\u00fd 1 \u0111\u1ed9i nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng, c\u01a1 c\u1ea5u hoa h\u1ed3ng cho nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng c\u1ee7a b\u1ea1n r\u1ea5t \u0111\u01a1n gi\u1ea3n: n\u1ebfu doanh thu \u0111\u1ea1t \u0111\u01b0\u1ee3c &gt; 200 th\u00ec hoa h\u1ed3ng l\u00e0 10% c\u1ee7a doanh thu, n\u1ebfu doanh thu \u0111\u1ea1t \u0111\u01b0\u1ee3c &lt;= 200 th\u00ec hoa h\u1ed3ng l\u00e0 5% c\u1ee7a doanh thu \u0111\u00f3. B\u00e0i to\u00e1n n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 h\u00e0m VLOOKUP nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/em><\/p>\n<figure id=\"attachment_31553\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31553\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/long-ghep-ham-if-va-ham-vlookup.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31553\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/long-ghep-ham-if-va-ham-vlookup.png\" alt=\"L\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 VLOOKUP \u0111\u1ec3 t\u00ednh hoa h\u1ed3ng\" width=\"1308\" height=\"792\" title=\"long-ghep-ham-if-va-ham-vlookup\"><\/a><figcaption id=\"caption-attachment-31553\" class=\"wp-caption-text\">L\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 VLOOKUP \u0111\u1ec3 t\u00ednh hoa h\u1ed3ng<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Xu_ly_loi_NA_khi_VLOOKUP_khong_tim_thay_gia_tri_trong_bang\"><\/span><span id=\"Xu_ly_loi_NA_khi_VLOOKUP_khong_tim_thay_gia_tri_trong_bang\" class=\"ez-toc-section\"><\/span>X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP th\u00ec ch\u00fang ta s\u1ebd nh\u1eadn l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i #N\/A. \u0110\u1ec3 \u0111\u01b0a ra m\u1ed9t th\u00f4ng b\u00e1o c\u00f3 \u00fd ngh\u0129a h\u01a1n cho ng\u01b0\u1eddi d\u00f9ng, ch\u00fang ta c\u00f3 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IFNA th\u1ec3 x\u1eed l\u00fd l\u1ed7i #N\/A b\u1eb1ng c\u00e1ch \u0111\u01b0a ra gi\u00e1 tr\u1ecb thay th\u1ebf nh\u01b0 sau.<\/p>\n<p><code class=\"excel-formula\">=IFNA(value, value_if_na)<\/code><\/p>\n<ul>\n<li>tham s\u1ed1\u00a0<em>value<\/em>\u00a0c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c, m\u1ed9t s\u1ed1, m\u1ed9t \u0111\u1ecba ch\u1ec9 \u00f4 trong Excel<\/li>\n<li>tham s\u1ed1\u00a0<em>value_if_na\u00a0<\/em>l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 l\u1ed7i #N\/A<\/li>\n<\/ul>\n<figure id=\"attachment_31555\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31555\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-ifna-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31555\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-hop-vlookup-va-ifna-1.png\" alt=\"C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m vlookup v\u00e0 ifna\" width=\"1310\" height=\"736\" title=\"ket-hop-vlookup-va-ifna-1\"><\/a><figcaption id=\"caption-attachment-31555\" class=\"wp-caption-text\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m vlookup v\u00e0 ifna<\/figcaption><\/figure>\n<p><strong>* K\u1ebft lu\u1eadn<\/strong><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 4 v\u00ed d\u1ee5 th\u01b0\u1eddng g\u1eb7p nh\u1ea5t trong vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m VLOOKUP. C\u00e1c b\u1ea1n h\u00e3y ghi nh\u1edb \u0111\u1ec3 s\u1eed d\u1ee5ng ph\u00f9 h\u1ee3p trong t\u1eebng ho\u00e0n c\u1ea3nh.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1t vi\u1ec7c\u00a0k\u1ebft h\u1ee3p c\u00e1c h\u00e0m v\u1edbi nhau, ch\u00fang ta c\u1ea7n n\u1eafm r\u00f5\u00a0\u0111\u01b0\u1ee3c logic c\u1ee7a v\u1ea5n\u00a0\u0111\u1ec1 tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 m\u1edbi x\u00e1c\u00a0\u0111\u1ecbnh s\u1eed d\u1ee5ng h\u00e0m n\u00e0o,\u00a0\u0111\u1eb7t th\u1ee9 t\u1ef1 c\u00e1c h\u00e0m t\u1ea1i v\u1ecb tr\u00ed n\u00e0o.<\/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\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<\/p>\n<p><strong>Xem th\u00eam: C\u00c1CH K\u1ebeT H\u1ee2P <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html\">H\u00c0M VLOOKUP V\u1edaI C\u00c2U L\u1ec6NH IF<\/a> \u2013 IF ISNA VLOOKUP<\/strong><\/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\/2025\/01\/vba101_92019-nho-21.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10783","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\/10783","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=10783"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10784"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}