{"id":4894,"date":"2024-12-08T12:13:57","date_gmt":"2024-12-08T12:13:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-if-isna-vlookup\/"},"modified":"2024-12-08T12:13:57","modified_gmt":"2024-12-08T12:13:57","slug":"cach-ket-hop-ham-vlookup-voi-cau-lenh-if-if-isna-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-if-isna-vlookup\/","title":{"rendered":"C\u00c1CH K\u1ebeT H\u1ee2P H\u00c0M VLOOKUP V\u1edaI C\u00c2U L\u1ec6NH IF \u2013 IF ISNA VLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m Vlookup v\u00e0 c\u00e2u l\u1ec7nh IF trong Excel \u0111\u1ec3 tra c\u1ee9u m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Ngo\u00e0i ra b\u00e0i vi\u1ebft c\u0169ng s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF ISNA VLOOKUP<\/strong><\/a> \u0111\u1ec3 thay th\u1ebf l\u1ed7i #N\/A b\u1eb1ng v\u0103n b\u1ea3n ri\u00eang ho\u1eb7c b\u1eb1ng s\u1ed1 0 hay \u00f4 tr\u1ed1ng.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb7c d\u00f9 h\u00e0m Vlookup v\u00e0 IF \u0111\u1ec1u c\u00f3 nh\u1eefng h\u1eefu \u00edch ri\u00eang nh\u01b0ng khi k\u1ebft h\u1ee3p ch\u00fang l\u1ea1i c\u00f3 nh\u1eefng t\u00ednh \u1ee9ng d\u1ee5ng h\u1eefu \u00edch h\u01a1n th\u1ebf.\u00a0<\/span><\/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-67558d8450c5f\" 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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Ham_Vlookup_voi_cau_lenh_If\" title=\"H\u00e0m Vlookup v\u1edbi c\u00e2u l\u1ec7nh If\">H\u00e0m Vlookup v\u1edbi c\u00e2u l\u1ec7nh If<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Vi_du_1_So_sanh_ket_qua_Vlookup_voi_mot_gia_tri_cu_the\" title=\"V\u00ed d\u1ee5 1: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3\">V\u00ed d\u1ee5 1: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Vi_du_2_So_sanh_ket_qua_Vlookup_voi_mot_o_khac\" title=\"V\u00ed d\u1ee5 2: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t \u00f4 kh\u00e1c\">V\u00ed d\u1ee5 2: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t \u00f4 kh\u00e1c<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Vi_du_3_Cac_gia_tri_Vlookup_trong_danh_sach_ngan_hon\" title=\"V\u00ed d\u1ee5 3: C\u00e1c gi\u00e1 tr\u1ecb Vlookup trong danh s\u00e1ch ng\u1eafn h\u01a1n\">V\u00ed d\u1ee5 3: C\u00e1c gi\u00e1 tr\u1ecb Vlookup trong danh s\u00e1ch ng\u1eafn h\u01a1n<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Cong_thuc_IF_VLOOKUP_de_thuc_hien_cac_phep_tinh_khac_nhau\" title=\"C\u00f4ng th\u1ee9c IF VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau\">C\u00f4ng th\u1ee9c IF VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Cong_thuc_IF_ISNA_VLOOKUP_de_an_loi_NA\" title=\"C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A\">C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#IFNA_VLOOKUP_trong_cac_phien_ban_Excel_moi_hon\" title=\"IFNA VLOOKUP trong c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi h\u01a1n\">IFNA VLOOKUP trong c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi h\u01a1n<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Excel_Vlookup_neu_khong_tim_thay_tra_ve_0\" title=\"Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y tr\u1ea3 v\u1ec1 0\">Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y tr\u1ea3 v\u1ec1 0<\/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\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#Excel_Vlookup_neu_khong_tim_thay_hay_tra_ve_o_trong\" title=\"Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e3y tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng\">Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e3y tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-ket-hop-ham-vlookup-voi-cau-lenh-if-trong-excel.html#If_voi_Index_Match_%E2%80%93_vlookup_trai_voi_dieu_kien_If\" title=\"If v\u1edbi Index Match \u2013 vlookup tr\u00e1i v\u1edbi \u0111i\u1ec1u ki\u1ec7n If\">If v\u1edbi Index Match \u2013 vlookup tr\u00e1i v\u1edbi \u0111i\u1ec1u ki\u1ec7n If<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Vlookup_voi_cau_lenh_If\"><\/span><b>H\u00e0m Vlookup v\u1edbi c\u00e2u l\u1ec7nh If<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng t\u00ecnh hu\u1ed1ng ph\u1ed5 bi\u1ebfn nh\u1ea5t khi k\u1ebft h\u1ee3p IF v\u00e0 Vlookup v\u1edbi nhau l\u00e0 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m Vlookup<\/strong><\/a> tr\u1ea3 v\u1ec1 v\u1edbi gi\u00e1 tr\u1ecb m\u1eabu v\u00e0 sau \u0111\u00f3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 <\/span><i><span style=\"font-weight: 400\">Yes\/No<\/span><\/i><span style=\"font-weight: 400\"> ho\u1eb7c <\/span><i><span style=\"font-weight: 400\">True\/False.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c chung nh\u01b0 sau:<\/span><\/p>\n<p><strong>IF (VLOOKUP (\u2026) = sample_value , TRUE, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 b\u1eb1ng gi\u00e1 tr\u1ecb m\u1eabu, FALSE n\u1ebfu kh\u00f4ng b\u1eb1ng gi\u00e1 tr\u1ecb m\u1eabu.<\/span><\/p>\n<p><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u1ec1 c\u00f4ng th\u1ee9c Vlookup k\u1ebft h\u1ee3p v\u1edbi IF.<\/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-403.gif\" title=\"ex101_92019-nho-403\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_1_So_sanh_ket_qua_Vlookup_voi_mot_gia_tri_cu_the\"><\/span><b>V\u00ed d\u1ee5 1: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng trong c\u1ed9t A v\u00e0 s\u1ed1 l\u01b0\u1ee3ng trong c\u1ed9t B. B\u1ea1n mu\u1ed1n ki\u1ec3m tra s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng trong E1 l\u00e0 c\u00f2n h\u00e0ng hay h\u1ebft h\u00e0ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n k\u00e9o s\u1ed1 l\u01b0\u1ee3ng b\u1eb1ng h\u00e0m Vlookup v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c nh\u01b0 sau:<\/span><\/p>\n<p><strong>=VLOOKUP(E1,$A$2:$B$10,2,FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3, vi\u1ebft m\u1ed9t c\u00e2u l\u1ec7nh IF so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a Vlookup v\u1edbi 0 v\u00e0 tr\u1ea3 v\u1ec1 \u201c NO\u201d n\u1ebfu n\u00f3 b\u1eb1ng 0, ho\u1eb7c l\u00e0 \u201c YES\u201d:<\/span><\/p>\n<p><strong>=IF(VLOOKUP(E1,$A$2:$B$10,2,FALSE)=0,\u201dNo\u201d,\u201dYes\u201d)<\/strong><\/p>\n<figure style=\"width: 361px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u1ec1 c\u00f4ng th\u1ee9c Vlookup k\u1ebft h\u1ee3p v\u1edbi IF\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-vlookup-excel.png\" alt=\"If Vlookup formula to return Yes or No based on vlookup result\" width=\"361\" height=\"260\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u1ec1 c\u00f4ng th\u1ee9c Vlookup k\u1ebft h\u1ee3p v\u1edbi IF<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Thay v\u00ec YES \/ NO , b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i TRUE \/ FALSE ho\u1eb7c\u00a0 SOLD OUT\/ IN STOCK (b\u00e1n h\u1ebft\/ c\u00f2n h\u00e0ng) ho\u1eb7c b\u1ea5t k\u1ef3 hai l\u1ef1a ch\u1ecdn n\u00e0o kh\u00e1c. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(VLOOKUP(E1,$A$2:$B$10,2)=0,\u201dSold out\u201d,\u201dIn stock\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 so s\u00e1nh gi\u00e1 tr\u1ecb m\u00e0 Vlookup tr\u1ea3 v\u1ec1 v\u1edbi v\u0103n b\u1ea3n m\u1eabu\u00a0 (sample text). Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o \u0111\u1eb7t m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p, nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(VLOOKUP(E1,$A$2:$B$10,2)=\u201dsample text\u201d,TRUE,FALSE)<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_2_So_sanh_ket_qua_Vlookup_voi_mot_o_khac\"><\/span><b>V\u00ed d\u1ee5 2: So s\u00e1nh k\u1ebft qu\u1ea3 Vlookup v\u1edbi m\u1ed9t \u00f4 kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c c\u1ee7a Vlookup k\u1ebft h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n IF l\u00e0 so s\u00e1nh k\u1ebft qu\u1ea3 \u0111\u1ea7u ra c\u1ee7a Vlookup v\u1edbi gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00e1c. Ch\u1eb3ng h\u1ea1n ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra xem n\u00f3 l\u1edbn h\u01a1n hay b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 G2:<\/span><\/p>\n<p><strong>=IF(VLOOKUP(E1,$A$2:$B$10,2)&gt;=G2,\u201dYes!\u201d,\u201dNo\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3:<\/span><\/p>\n<figure style=\"width: 621px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 2: H\u00e0m Vlookup k\u1ebft h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n IF\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-vlookup-true-false.png\" alt=\"If formula with Vlookup to compare vlookup's result with another cell\" width=\"621\" height=\"257\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 2: H\u00e0m Vlookup k\u1ebft h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n IF<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_3_Cac_gia_tri_Vlookup_trong_danh_sach_ngan_hon\"><\/span><b>V\u00ed d\u1ee5 3: C\u00e1c gi\u00e1 tr\u1ecb Vlookup trong danh s\u00e1ch ng\u1eafn h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c IF ISNA VLOOKUP d\u00f9ng \u0111\u1ec3 so s\u00e1nh t\u1eebng \u00f4 trong c\u1ed9t m\u1ee5c ti\u00eau v\u1edbi danh s\u00e1ch kh\u00e1c. N\u1ebfu t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c YES, n\u1ebfu k\u1ebft qu\u1ea3 kh\u00f4ng ph\u00f9 h\u1ee3p tr\u1ea3 v\u1ec1 FALSE ho\u1eb7c NO.<\/span><\/p>\n<p><strong>IF( ISNA( VLOOKUP(\u2026)),\u201dNo\u201d,\u201dYes\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu Vlookup d\u1eabn \u0111\u1ebfn l\u1ed7i # N \/ A, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cNO\u201d, ngh\u0129a l\u00e0 kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u trong danh s\u00e1ch tra c\u1ee9u. N\u1ebfu k\u1ebft qu\u1ea3 kh\u1edbp \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, \u201cYES\u201d s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(ISNA(VLOOKUP(A2,$D$2:$D$4,1,FALSE)),\u201dNo\u201d,\u201dYes\u201d)<\/strong><\/p>\n<figure style=\"width: 372px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1c gi\u00e1 tr\u1ecb Vlookup trong danh s\u00e1ch ng\u1eafn h\u01a1n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-list-yes-no.png\" alt=\"Vlookup values in a shorter list and return Yes or No.\" width=\"372\" height=\"259\"><figcaption class=\"wp-caption-text\">C\u00e1c gi\u00e1 tr\u1ecb Vlookup trong danh s\u00e1ch ng\u1eafn h\u01a1n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu nghi\u1ec7p v\u1ee5 c\u1ee7a b\u1ea1n y\u00eau c\u1ea7u k\u1ebft qu\u1ea3 ng\u01b0\u1ee3c l\u1ea1i, ch\u1ec9 c\u1ea7n ho\u00e1n \u0111\u1ed5i \u201cYES\u201d v\u00e0 \u201cNO\u201d \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c logic c\u1ee7a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>=IF(ISNA(VLOOKUP(A2,$D$2:$D$4,1,FALSE)),\u201dYes\u201d,\u201dNo\u201d)<\/strong><\/p>\n<figure style=\"width: 376px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 3: H\u00e0m Vlookup v\u00e0 c\u00e2u l\u1ec7nh IF\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-vlookup-list.png\" alt=\"IF ISNA VLOOKUP formula to look up values in a shorter list and return Yes or No.\" width=\"376\" height=\"257\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 3: H\u00e0m Vlookup v\u00e0 c\u00e2u l\u1ec7nh IF<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_IF_VLOOKUP_de_thuc_hien_cac_phep_tinh_khac_nhau\"><\/span><b>C\u00f4ng th\u1ee9c IF VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u00ean c\u1ea1nh ch\u1ee9c n\u0103ng tr\u00ean, <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\"><strong>h\u00e0m IF<\/strong><\/a> v\u1edbi c\u00e2u l\u1ec7nh Vlookup c\u00f2n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau d\u1ef1a tr\u00ean nh\u1eefng ti\u00eau ch\u00ed m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u1ea5y v\u00ed d\u1ee5 r\u00f5 h\u01a1n, t\u00ednh to\u00e1n hoa h\u1ed3ng c\u1ee7a m\u1ed9t ng\u01b0\u1eddi b\u00e1n c\u1ee5 th\u1ec3 (F1) t\u00f9y thu\u1ed9c v\u00e0o s\u1ef1 hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c: 20% hoa h\u1ed3ng cho nh\u1eefng ng\u01b0\u1eddi ki\u1ebfm \u0111\u01b0\u1ee3c 200 \u0111\u00f4 la tr\u1edf l\u00ean, 10% cho nh\u1eefng ng\u01b0\u1eddi kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y th\u00ec b\u1ea1n ki\u1ec3m tra xem gi\u00e1 tr\u1ecb m\u00e0 Vlookup tr\u1ea3 v\u1ec1 c\u00f3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 200 hay kh\u00f4ng v\u00e0 n\u1ebfu c\u00f3 th\u00ec nh\u00e2n n\u00f3 v\u1edbi 20%, n\u1ebfu kh\u00f4ng th\u00ec nh\u00e2n v\u1edbi 10%.<\/span><\/p>\n<p><strong>=IF(VLOOKUP(F1,$A$2:$C$10,3,FALSE)&gt;=200,\u00a0<\/strong><\/p>\n<p><strong>VLOOKUP(F1,$A$2:$C$10,3,FALSE)*20%,\u00a0<\/strong><\/p>\n<p><strong>VLOOKUP(F1,$A$2:$C$10,3,FALSE)*10%)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 A2: A10 l\u00e0 t\u00ean ng\u01b0\u1eddi b\u00e1n v\u00e0 C2: C10 l\u00e0 doanh s\u1ed1 b\u00e1n h\u00e0ng.<\/span><\/p>\n<figure style=\"width: 518px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c IF VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-vlookup-calculations.png\" alt=\"Excel If Vlookup formula to perform different calculations\" width=\"518\" height=\"279\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_IF_ISNA_VLOOKUP_de_an_loi_NA\"><\/span><b>C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu h\u00e0m VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n l\u1ed7i # N \/ A. \u0110\u1ec3 \u1ea9n l\u1ed7i \u0111\u00f3 v\u00e0 thay th\u1ebf n\u00f3 b\u1eb1ng v\u0103n b\u1ea3n c\u1ee7a ri\u00eang th\u00ec c\u00f3 th\u1ec3 l\u1ed3ng c\u00f4ng th\u1ee9c Vlookup v\u00e0o h\u00e0m IF:<\/span><\/p>\n<p><strong>IF (ISNA (VLOOKUP (\u2026)), \u201cNot found\u201d, VLOOKUP (\u2026))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp b\u1ea5t k\u1ef3 c\u00e1c k\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n kh\u00e1c thay v\u00ec <\/span><i><span style=\"font-weight: 400\">Not Found<\/span><\/i><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch t\u00ean ng\u01b0\u1eddi b\u00e1n trong m\u1ed9t c\u1ed9t v\u00e0 s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng trong c\u1ed9t kh\u00e1c. Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 k\u00e9o s\u1ed1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u00ean ng\u01b0\u1eddi d\u00f9ng nh\u1eadp v\u00e0o F1. N\u1ebfu t\u00ean kh\u00f4ng xu\u1ea5t hi\u1ec7n th\u00ec s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi c\u00e1c t\u00ean trong A2: A10 v\u00e0 s\u1ed1 l\u01b0\u1ee3ng C2: C10, c\u00f4ng vi\u1ec7c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c IF Vlookup nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(ISNA(VLOOKUP(F1,$A$2:$C$10,3,FALSE)),\u201dNotfound\u201d, VLOOKUP(F1,$A$2:$C$10,3,FALSE))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u00ean \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y th\u00ec s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng t\u01b0\u01a1ng \u1ee9ng s\u1ebd xu\u1ea5t hi\u1ec7n:<\/span><\/p>\n<figure style=\"width: 612px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-isna-vlookup-excel.png\" alt=\"IF ISNA VLOOKUP formula pulls a matching value\" width=\"612\" height=\"263\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u, th\u00f4ng b\u00e1o <\/span><i><span style=\"font-weight: 400\">Not Found<\/span><\/i><span style=\"font-weight: 400\"> (Kh\u00f4ng t\u00ecm th\u1ea5y) s\u1ebd xu\u1ea5t hi\u1ec7n thay v\u00ec l\u1ed7i # N \/ A:<\/span><\/p>\n<figure style=\"width: 604px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-vlookup-not-found.png\" alt=\"If the lookup value is not found, IF ISNA VLOOKUP returns custom text instead of the N\/A error.\" width=\"604\" height=\"259\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF ISNA VLOOKUP \u0111\u1ec3 \u1ea9n l\u1ed7i #N\/A<\/figcaption><\/figure>\n<p><b><i>C\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">Logic c\u1ee7a c\u00f4ng th\u1ee9c r\u1ea5t \u0111\u01a1n gi\u1ea3n: b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m ISNA \u0111\u1ec3 ki\u1ec3m tra l\u1ed7i # N \/ A tr\u00ean Vlookup. N\u1ebfu x\u1ea3y ra l\u1ed7i, ISNA tr\u1ea3 v\u1ec1 TRUE, c\u00f2n ng\u01b0\u1ee3c l\u1ea1i s\u1ebd tr\u1ea3 v\u1ec1 FALSE. C\u00e1c gi\u00e1 tr\u1ecb tr\u00ean s\u1ebd ki\u1ec3m tra logic c\u1ee7a h\u00e0m IF nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu ki\u1ec3m tra logic l\u00e0 TRUE (l\u1ed7i # N \/ A), th\u00f4ng b\u00e1o c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu ki\u1ec3m tra logic l\u00e0 FALSE (gi\u00e1 tr\u1ecb tra c\u1ee9u \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y), Vlookup tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp b\u00ecnh th\u01b0\u1eddng.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"IFNA_VLOOKUP_trong_cac_phien_ban_Excel_moi_hon\"><\/span><b>IFNA VLOOKUP trong c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong Excel for Office 365, Excel 2019, Excel 2016 v\u00e0 2013, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFNA thay v\u00ec IF ISNA \u0111\u1ec3 ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i # N \/ A:<\/span><\/p>\n<p><strong>IFNA (VLOOKUP (\u2026), \u201d NOT FOUND \u201c)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IFNA(VLOOKUP(F1,$A$2:$C$10,3, FALSE), \u201cNot found\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fa \u00fd: N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i l\u1ed7i, kh\u00f4ng ch\u1ec9 l\u1ed7i #N\/A th\u00ec s\u1eed d\u1ee5ng h\u00e0m Vlookup k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Vlookup_neu_khong_tim_thay_tra_ve_0\"><\/span><b>Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y tr\u1ea3 v\u1ec1 0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u v\u00e0 mu\u1ed1n tr\u1ea3 v\u1ec1 s\u1ed1 0 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF ISNA VLOOKUP nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean nh\u01b0ng c\u00f3 m\u1ed9t ch\u00fat thay \u0111\u1ed5i. Thay v\u00ec m\u1ed9t v\u0103n b\u1ea3n (text) th\u00ec b\u1ea1n \u0111i\u1ec1n s\u1ed1 0 v\u00e0o \u0111\u1ed1i s\u1ed1 <\/span><i><span style=\"font-weight: 400\">value_if_true <\/span><\/i><span style=\"font-weight: 400\">c\u1ee7a h\u00e0m IF.<\/span><\/p>\n<p><strong>IF (ISNA (VLOOKUP (\u2026)), 0, VLOOKUP (\u2026))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang t\u00f4i c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(ISNA(VLOOKUP(F2,$A$2:$C$10,3,FALSE)), 0, VLOOKUP(F2,$A$2:$C$10,3,FALSE))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong c\u00e1c phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y c\u1ee7a Excel 2016 v\u00e0 2013, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i k\u1ebft h\u1ee3p IFNA Vlookup:<\/span><\/p>\n<p><strong>=IFNA(VLOOKUP(I2,$A$2:$C$10,3, FALSE), 0)<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Vlookup_neu_khong_tim_thay_hay_tra_ve_o_trong\"><\/span><b>Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e3y tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t bi\u1ebfn th\u1ec3 kh\u00e1c c\u1ee7a c\u00e2u l\u1ec7nh \u201cVlookup if then\u201d. \u0110\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c chu\u1ed7i tr\u1ed1ng(\u201c\u201d) thay v\u00ec l\u1ed7i #N\/A.<\/span><\/p>\n<p><strong>IF (ISNA (VLOOKUP (\u2026)), \u201c\u201d, VLOOKUP (\u2026))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel:<\/span><\/p>\n<p><strong>=IF(ISNA(VLOOKUP(F2,$A$2:$C$10,3,FALSE)), \u201c\u201d, VLOOKUP(F2,$A$2:$C$10,3,FALSE))<\/strong><\/p>\n<figure style=\"width: 521px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e3y tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-not-found-zero.png\" alt=\"If Vlookup formula: if not found return 0\" width=\"521\" height=\"260\"><figcaption class=\"wp-caption-text\">Excel Vlookup: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e3y tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi Excel 2016 v\u00e0 Excel 2013:<\/span><\/p>\n<p><strong>=IFNA(VLOOKUP(F2,$A$2:$C$10,3, FALSE), \u201c\u201d)<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"If_voi_Index_Match_%E2%80%93_vlookup_trai_voi_dieu_kien_If\"><\/span><b>If v\u1edbi Index Match \u2013 vlookup tr\u00e1i v\u1edbi \u0111i\u1ec1u ki\u1ec7n If<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m Vlookup kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch duy nh\u1ea5t th\u1ef1c hi\u1ec7n tra c\u1ee9u theo chi\u1ec1u d\u1ecdc trong Excel. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH cho m\u1ee5c \u0111\u00edch n\u00e0y v\u00e0 th\u1eadm ch\u00ed c\u00f2n m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t h\u01a1n. C\u00e1c \u0111\u1ed1i s\u00e1nh ch\u1ec9 m\u1ee5c trong c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng v\u1edbi IF t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Vlookup.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 s\u1ed1 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng trong c\u1ed9t A v\u00e0 t\u00ean ng\u01b0\u1eddi b\u00e1n trong c\u1ed9t B. V\u1eady l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 k\u00e9o s\u1ed1 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng sang cho m\u1ed9t ng\u01b0\u1eddi b\u00e1n c\u1ee5 th\u1ec3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Vlookup kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y v\u00ec kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb ph\u1ea3i sang tr\u00e1i. \u0110\u1ed1i s\u00e1nh ch\u1ec9 m\u1ee5c s\u1ebd ho\u1ea1t \u0111\u1ed9ng mi\u1ec5n gi\u00e1 tr\u1ecb tra c\u1ee9u \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong c\u1ed9t tra c\u1ee9u n\u1ebfu kh\u00f4ng l\u1ed7i #N\/A s\u1ebd hi\u1ec3n th\u1ecb. \u0110\u1ec3 thay th\u1ebf k\u00fd l\u1ed7i b\u1eb1ng k\u00fd hi\u1ec7u ri\u00eang th\u00ec l\u1ed3ng INDEX v\u00e0o b\u00ean trong IF ISNA:<\/span><\/p>\n<p><strong>=IF(ISNA(INDEX(A2:A10, MATCH(F1, $B$2:$B$10, 0))), \u201cNot found\u201d, INDEX(A2:A10, MATCH(F1, $B$2:$B$10, 0)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong Excel 2016 v\u00e0 2016, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng IFNA thay v\u00ec IF ISNA \u0111\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c nh\u1ecf g\u1ecdn h\u01a1n:<\/span><\/p>\n<p><strong>=IFNA(INDEX(A2:A10, MATCH(F1, $B$2:$B$10, 0)), \u201cNot found\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0110\u1ed1i s\u00e1nh ch\u1ec9 m\u1ee5c (Index) trong c\u00e1c c\u00f4ng th\u1ee9c If kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng Vlookup k\u1ebft h\u1ee3p v\u1edbi c\u00e2u l\u1ec7nh IF trong Excel. \u0110\u1ec3 c\u00f3 hi\u1ec3u r\u00f5 h\u01a1n c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn trong h\u01b0\u1edbng d\u1eabn n\u00e0y th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng c\u00e1c bi\u1ec3u m\u1eabu l\u00e0m vi\u1ec7c tr\u00ean. Hy v\u1ecdng nh\u1eefng th\u00f4ng tin tr\u00ean s\u1ebd mang \u0111\u1ebfn cho c\u00e1c b\u1ea1n ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\">Excel<\/a><\/strong> v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i \u1edf b\u00e0i vi\u1ebft sau.<\/span><\/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-403.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4895,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4894","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\/4894","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=4894"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4894\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4895"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}