{"id":5413,"date":"2024-12-16T02:22:13","date_gmt":"2024-12-16T02:22:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/ham-vlookup-lai-loi-na-name-value-xu-ly-loi-vlookup\/"},"modified":"2024-12-16T02:22:13","modified_gmt":"2024-12-16T02:22:13","slug":"ham-vlookup-lai-loi-na-name-value-xu-ly-loi-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/ham-vlookup-lai-loi-na-name-value-xu-ly-loi-vlookup\/","title":{"rendered":"H\u00e0m VLOOKUP l\u1ea1i l\u1ed7i NA, Name, Value \u2013 x\u1eed l\u00fd l\u1ed7i VLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u00fap c\u00e1c b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn v\u1edbi VLOOKUP trong Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.<\/p>\n<p>B\u1ea1n vi\u1ebft VLOOKUP xong, h\u1ed3i h\u1ed9p b\u1ea5m Enter 1 c\u00e1i, mong ch\u1edd k\u1ebft qu\u1ea3 hi\u1ec7n ra, nh\u01b0ng kh\u00f4ng, b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i nh\u01b0 #N\/A, #NAME, #VALUE ho\u1eb7c 1 s\u1ed1 l\u1ed7i kh\u00e1c<\/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-675f8ed402587\" 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<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Nhac_lai_kien_thuc_ve_VLOOKUP_va_dong_bon\" title=\"Nh\u1eafc l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 VLOOKUP v\u00e0 \u0111\u1ed3ng b\u1ecdn\">Nh\u1eafc l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 VLOOKUP v\u00e0 \u0111\u1ed3ng b\u1ecdn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\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\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Xu_ly_loi_NA_khi_su_dung_VLOOKUP\" title=\"X\u1eed l\u00fd l\u1ed7i NA khi s\u1eed d\u1ee5ng VLOOKUP:\">X\u1eed l\u00fd l\u1ed7i NA khi s\u1eed d\u1ee5ng VLOOKUP:<\/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\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Loi_chinh_ta_trong_gia_tri_duoc_tim_kiem_Lookup_Value\" title=\"L\u1ed7i ch\u00ednh t\u1ea3 trong gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm (Lookup Value)\">L\u1ed7i ch\u00ednh t\u1ea3 trong gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm (Lookup Value)<\/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\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Loi_NA_khi_su_dung_VLOOKUP_de_do_tim_gan_dung\" title=\"L\u1ed7i #N\/A khi s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang\">L\u1ed7i #N\/A khi s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Loi_NA_khi_%E2%80%A6_thuc_su_khong_phai_loi\" title=\"L\u1ed7i #N\/A khi \u2026 th\u1ef1c s\u1ef1 kh\u00f4ng ph\u1ea3i l\u1ed7i\">L\u1ed7i #N\/A khi \u2026 th\u1ef1c s\u1ef1 kh\u00f4ng ph\u1ea3i l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Cot_tim_kiem_khong_o_vi_tri_dau_tien_khi_tra_cuu\" title=\"C\u1ed9t t\u00ecm ki\u1ebfm kh\u00f4ng \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean khi tra c\u1ee9u\">C\u1ed9t t\u00ecm ki\u1ebfm kh\u00f4ng \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean khi tra c\u1ee9u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#So_nhung_dinh_dang_kieu_chu\" title=\"S\u1ed1 nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u ch\u1eef:\">S\u1ed1 nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u ch\u1eef:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Thua_khoang_trang_o_dau_o_hoac_cuoi_o\" title=\"Th\u1eeba kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u \u00f4 ho\u1eb7c cu\u1ed1i \u00f4:\">Th\u1eeba kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u \u00f4 ho\u1eb7c cu\u1ed1i \u00f4:<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Truong_hop_1_Khoang_trang_trong_cot_do_tim_voi_cong_thuc_VLOOKUP\" title=\"Tr\u01b0\u1eddng h\u1ee3p 1: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t d\u00f2 t\u00ecm (v\u1edbi c\u00f4ng th\u1ee9c VLOOKUP)\">Tr\u01b0\u1eddng h\u1ee3p 1: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t d\u00f2 t\u00ecm (v\u1edbi c\u00f4ng th\u1ee9c VLOOKUP)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Truong_hop_2_Khoang_trang_trong_cot_tra_cuu\" title=\"Tr\u01b0\u1eddng h\u1ee3p 2: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t tra c\u1ee9u\">Tr\u01b0\u1eddng h\u1ee3p 2: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t tra c\u1ee9u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Loi_VALUE_khi_su_dung_VLOOKUP\" title=\"L\u1ed7i #VALUE khi s\u1eed d\u1ee5ng VLOOKUP:\">L\u1ed7i #VALUE khi s\u1eed d\u1ee5ng VLOOKUP:<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Gia_tri_tra_cuu_vuot_qua_255_ky_tu\" title=\"Gi\u00e1 tr\u1ecb tra c\u1ee9u v\u01b0\u1ee3t qu\u00e1 255 k\u00fd t\u1ef1\">Gi\u00e1 tr\u1ecb tra c\u1ee9u v\u01b0\u1ee3t qu\u00e1 255 k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Khong_co_duong_dan_day_du_toi_bang_tinh_tra_cuu\" title=\"Kh\u00f4ng c\u00f3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi b\u1ea3ng t\u00ednh tra c\u1ee9u\">Kh\u00f4ng c\u00f3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi b\u1ea3ng t\u00ednh tra c\u1ee9u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Doi_so_col_index_num_nho_hon_1\" title=\"\u0110\u1ed1i s\u1ed1 col_index_num nh\u1ecf h\u01a1n 1\">\u0110\u1ed1i s\u1ed1 col_index_num nh\u1ecf h\u01a1n 1<\/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-15\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Loi_NAME_khi_su_dung_VLOOKUP\" title=\"L\u1ed7i #NAME khi s\u1eed d\u1ee5ng VLOOKUP:\">L\u1ed7i #NAME khi s\u1eed d\u1ee5ng VLOOKUP:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#VLOOKUP_khong_hoat_dong_han_che_su_co_va_giai_phap\" title=\"VLOOKUP kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng (h\u1ea1n ch\u1ebf, s\u1ef1 c\u1ed1 v\u00e0 gi\u1ea3i ph\u00e1p)\">VLOOKUP kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng (h\u1ea1n ch\u1ebf, s\u1ef1 c\u1ed1 v\u00e0 gi\u1ea3i ph\u00e1p)<\/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-17\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Vlookup_khong_phan_biet_chu_hoa_chu_thuong\" title=\"Vlookup kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng\">Vlookup kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#VLOOKUP_tra_ve_gia_tri_tim_thay_dau_tien\" title=\"VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean\">VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Mot_cot_moi_duoc_chen_vao_hoac_go_bo_khoi_hang\" title=\"M\u1ed9t c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o ho\u1eb7c g\u1ee1 b\u1ecf kh\u1ecfi h\u00e0ng\">M\u1ed9t c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o ho\u1eb7c g\u1ee1 b\u1ecf kh\u1ecfi h\u00e0ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Cac_o_tham_chieu_thay_doi_khi_sao_chep_cong_thuc_den_o_khac\" title=\"C\u00e1c \u00f4 tham chi\u1ebfu thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 kh\u00e1c\">C\u00e1c \u00f4 tham chi\u1ebfu thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 kh\u00e1c<\/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-21\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Ham_VLOOKUP_voi_ham_IFERROR_ISERROR\" title=\"H\u00e0m VLOOKUP v\u1edbi h\u00e0m IFERROR \/ ISERROR\">H\u00e0m VLOOKUP v\u1edbi h\u00e0m IFERROR \/ ISERROR<\/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-22\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Su_dung_VLOOKUP_voi_IFERROR\" title=\"S\u1eed d\u1ee5ng VLOOKUP v\u1edbi IFERROR\">S\u1eed d\u1ee5ng VLOOKUP v\u1edbi IFERROR<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-xu-ly-loi-na-vlookup.html#Su_dung_ham_VLOOKUP_voi_ISERROR\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi ISERROR\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi ISERROR<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Nhac_lai_kien_thuc_ve_VLOOKUP_va_dong_bon\"><\/span>Nh\u1eafc l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 VLOOKUP v\u00e0 \u0111\u1ed3ng b\u1ecdn<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc khi \u0111i b\u1eaft l\u1ed7i c\u1ee7a VLOOKUP, b\u1ea1n c\u1ea7n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP nh\u01b0 th\u1ebf n\u00e0o \u0111\u00e3, n\u1ebfu b\u1ea1n quan t\u00e2m, \u0111\u00e2y l\u00e0 nh\u1eefng b\u00e0i vi\u1ebft v\u1ec1 VLOOKUP \u0111\u1ec3 c\u00e1c b\u1ea1n tham kh\u1ea3o:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">S\u1eed d\u1ee5ng VLOOKUP trong Excel<\/a><\/strong><\/p>\n<p>Sau khi \u0111\u00e3 luy\u1ec7n th\u00e0nh c\u00f4ng k\u0129 thu\u1eadt s\u1eed d\u1ee5ng VLOOKUP qua 4 b\u00e0i vi\u1ebft v\u1eeba r\u1ed3i, b\u00e2y gi\u1edd b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 g\u1eb7p nh\u1eefng l\u1ed7i sau \u0111\u00e2y<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xu_ly_loi_NA_khi_su_dung_VLOOKUP\"><\/span>X\u1eed l\u00fd l\u1ed7i NA khi s\u1eed d\u1ee5ng VLOOKUP:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>NA trong ti\u1ebfng anh ngh\u0129a l\u00e0 \u201cNot available\u201d, l\u1ed7i n\u00e0y l\u00e0 1 trong nh\u1eefng l\u1ed7i hay g\u1eb7p khi ch\u00fang ta s\u1eed d\u1ee5ng VLOOKUP. B\u1ea1n s\u1ebd c\u1ea7n ki\u1ec3m tra nh\u1eefng th\u1ee9 sau \u0111\u00e2y n\u1ebfu g\u1eb7p l\u1ed7i n\u00e0y trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng VLOOKUP:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_chinh_ta_trong_gia_tri_duoc_tim_kiem_Lookup_Value\"><\/span>L\u1ed7i ch\u00ednh t\u1ea3 trong gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm (Lookup Value)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c \u0111\u1ea7u ti\u00ean ch\u00fang ta c\u1ea7n xem khi g\u1eb7p l\u1ed7i NA khi s\u1eed d\u1ee5ng VLOOKUP l\u00e0 ki\u1ec3m tra l\u1ea1i l\u1ed7i ch\u00ednh t\u1ea3 c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u.<\/p>\n<p>M\u1ed9t tr\u01b0\u1eddng h\u1ee3p ph\u1ed5 bi\u1ebfn m\u00e0 nhi\u1ec1u b\u1ea1n g\u1eb7p ph\u1ea3i, \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u th\u1eeba d\u1ea5u c\u00e1ch \u1edf cu\u1ed1i, \u0111\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n kh\u00f4ng th\u1ec3 ki\u1ec3m tra b\u1eb1ng m\u1eaft th\u01b0\u1eddng. \u0110\u1ec3 ph\u00e1t hi\u1ec7n l\u1ed7i th\u1eeba d\u1ea5u c\u00e1ch, k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng trong m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_31528\" class=\"wp-caption aligncenter\" style=\"width: 276px\" aria-describedby=\"caption-attachment-31528\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-xu-ly-loi-na-vlookup-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31528\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-xu-ly-loi-na-vlookup-01.png\" alt=\"X\u1eed l\u00fd l\u1ed7i NA khi s\u1eed d\u1ee5ng VLOOKUP\" width=\"276\" height=\"154\" title=\"cach-xu-ly-loi-na-vlookup-01\"><\/a><figcaption id=\"caption-attachment-31528\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m LEN ph\u00e1t hi\u1ec7n kho\u1ea3ng tr\u1eafng trong gi\u00e1 tr\u1ecb tra c\u1ee9u<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, n\u1ebfu nh\u00ecn b\u1eb1ng m\u1eaft th\u01b0\u1eddng th\u00ec gi\u00e1 tr\u1ecb c\u1ee7a A2 v\u00e0 A3 \u0111\u1ec1u nh\u01b0 nhau. Nh\u01b0ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a A2 l\u00e0 5 v\u00e0 c\u1ee7a A3 l\u00e0 6. \u0110\u1ec3 kh\u1eafc ph\u1ee5c v\u1ea5n \u0111\u1ec1 n\u00e0y, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o l\u00e0 d\u00f9ng th\u00eam h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng trong gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u. C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 nh\u01b0 sau:<\/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-468.gif\" title=\"ex101_92019-nho-468\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><code class=\"excel-formula\">=VLOOKUP(TRIM(lookup_value), table_array, col_index_num, [range_lookup])<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NA_khi_su_dung_VLOOKUP_de_do_tim_gan_dung\"><\/span>L\u1ed7i #N\/A khi s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng VLOOKUP v\u1edbi tham s\u1ed1 tra c\u1ee9u l\u00e0 g\u1ea7n \u0111\u00fang ([range_lookup] l\u00e0 TRUE ho\u1eb7c b\u1ecf qua), th\u00ec vi\u1ec7c g\u1eb7p l\u1ed7i #N\/A c\u00f3 th\u1ec3 do m\u1ed9t trong 2 l\u00fd do sau \u0111\u00e2y<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u\u00a0<em>\u2013 lookup_value\u00a0<\/em>nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong v\u00f9ng tra c\u1ee9u nh\u01b0 trong v\u00ed d\u1ee5 sau \u0111\u00e2y,m\u1ee9c doanh thu l\u00e0 95,nh\u1ecf h\u01a1n s\u1ed1 nh\u1ecf nh\u1ea5t trong c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u tra c\u1ee9u l\u00e0 100.<br \/>\n<figure id=\"attachment_31530\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31530\"><\/figure>\n<\/li>\n<\/ul>\n<figure id=\"attachment_31530\" class=\"wp-caption aligncenter\" style=\"width: 228px\" aria-describedby=\"caption-attachment-31530\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/xu-ly-loi-na-trong-vlookup.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31530\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xu-ly-loi-na-trong-vlookup.png\" alt=\"X\u1eed l\u00fd l\u1ed7i NA trong VLOOKUP\" width=\"228\" height=\"283\" title=\"xu-ly-loi-na-trong-vlookup\"><\/a><figcaption id=\"caption-attachment-31530\" class=\"wp-caption-text\">X\u1eed l\u00fd l\u1ed7i NA trong VLOOKUP<\/figcaption><\/figure>\n<ul>\n<li>C\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n: c\u1ed9t doanh thu kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf t\u1edbi l\u1edbn.\u00a0 C\u00e1ch kh\u1eafc ph\u1ee5c l\u00e0 b\u1ea1n c\u1ea7n s\u1eafp x\u1ebfp c\u1ed9t doanh thu l\u1ea1i cho \u0111\u00fang th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<br \/>\n<figure id=\"attachment_31532\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-31532\"><\/figure>\n<\/li>\n<\/ul>\n<figure id=\"attachment_31532\" class=\"wp-caption aligncenter\" style=\"width: 231px\" aria-describedby=\"caption-attachment-31532\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/xu-ly-loi-NA-trong-cong-thuc-vlookup.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31532\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xu-ly-loi-na-trong-cong-thuc-vlookup.png\" alt=\"X\u1eed l\u00fd l\u1ed7i NA trong vlookup\" width=\"231\" height=\"288\" title=\"xu-ly-loi-na-trong-cong-thuc-vlookup\"><\/a><figcaption id=\"caption-attachment-31532\" class=\"wp-caption-text\">X\u1eed l\u00fd l\u1ed7i NA trong vlookup<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NA_khi_%E2%80%A6_thuc_su_khong_phai_loi\"><\/span>L\u1ed7i #N\/A khi \u2026 th\u1ef1c s\u1ef1 kh\u00f4ng ph\u1ea3i l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi gi\u00e1 tr\u1ecb ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm kh\u00f4ng c\u00f3 trong b\u1ea3ng t\u00ecm ki\u1ebfm th\u00ec l\u1ed7i #N\/A c\u0169ng c\u00f3 th\u1ec3 x\u1ea3y ra.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cot_tim_kiem_khong_o_vi_tri_dau_tien_khi_tra_cuu\"><\/span>C\u1ed9t t\u00ecm ki\u1ebfm kh\u00f4ng \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean khi tra c\u1ee9u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft, m\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 nh\u1ea5t c\u1ee7a h\u00e0m VLOOKUP l\u00e0 n\u00f3 kh\u00f4ng th\u1ec3 d\u00f2 t\u00ecm ph\u00eda b\u00ean tr\u00e1i c\u1ed9t tra c\u1ee9u, do \u0111\u00f3 c\u1ed9t tra c\u1ee9u lu\u00f4n lu\u00f4n l\u00e0 c\u1ed9t b\u00ean tr\u00e1i ngo\u00e0i c\u00f9ng trong b\u1ea3ng d\u00f2 t\u00ecm. Trong th\u1ef1c t\u1ebf, ch\u00fang ta th\u01b0\u1eddng qu\u00ean \u0111i \u0111i\u1ec1u n\u00e0y v\u00e0 d\u1eabn \u0111\u1ebfn vi\u1ec7c h\u00e0m VLOOKUP kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00ec l\u1ed7i N\/A.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-na-error-2.png\" alt=\"The lookup column should be the leftmost column of the table array, otherwise VLOOKUP displays the N\/A error.\" title=\"vlookup-na-error-2\"><\/p>\n<p><span lang=\"vi\"><strong>Gi\u1ea3i ph\u00e1p<\/strong>: N\u1ebfu kh\u00f4ng th\u1ec3 t\u00e1i c\u1ea5u tr\u00fac d\u1eef li\u1ec7u \u0111\u1ec3 c\u1ed9t tra c\u1ee9u l\u00e0 c\u1ed9t b\u00ean tr\u00e1i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m\u00a0<strong>INDEX<\/strong>\u00a0v\u00e0\u00a0<strong>MATCH\u00a0<\/strong>\u0111\u1ec3\u00a0thay th\u1ebf linh ho\u1ea1t cho h\u00e0m VLOOKUP. B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y th\u00f4ng tin chi ti\u1ebft v\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c trong h\u01b0\u1edbng d\u1eabn \u2013 C\u00e1ch d\u00f9ng h\u00e0m INDEX \/ MATCH \u0111\u1ec3 tra c\u1ee9u c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i.<\/span><\/p>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_nhung_dinh_dang_kieu_chu\"><\/span>S\u1ed1 nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u ch\u1eef:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span lang=\"vi\">M\u1ed9t l\u1ed7i N\/A kh\u00e1c c\u1ee7a h\u00e0m VLOOKUP l\u00e0 do c\u00e1c con s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n, trong c\u1ed9t d\u00f2 t\u00ecm ho\u1eb7c v\u00f9ng tra c\u1ee9u.<\/span><\/p>\n<p><span lang=\"vi\">\u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u00ean ngo\u00e0i ho\u1eb7c do b\u1ea1n \u0111\u00e3 g\u00f5 d\u1ea5u nh\u00e1y \u0111\u01a1n tr\u01b0\u1edbc s\u1ed1.<\/span><\/p>\n<p><span lang=\"vi\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/number-formatted-as-text-2.png\" alt=\"The indications of numbers being formatted as text in Excel\" title=\"number-formatted-as-text-2\"><\/span><\/p>\n<p><span lang=\"vi\">C\u00e1c s\u1ed1 n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef \u1edf \u0111\u1ecbnh d\u1ea1ng chung. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f3 m\u1ed9t d\u1ea5u hi\u1ec7u \u0111\u00e1ng ch\u00fa \u00fd \u2013 s\u1ed1 \u0111\u01b0\u1ee3c canh l\u1ec1 tr\u00e1i c\u1ee7a \u00f4.<\/span><\/p>\n<p><span lang=\"vi\"><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0N\u1ebfu \u0111\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t s\u1ed1 duy nh\u1ea5t, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng l\u1ed7i v\u00e0 ch\u1ecdn \u201c<strong>Convert To Number<\/strong>\u201d t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-number-to-text-2.png\" alt=\"Converting numbers formatted as text to the normal numbers format.\" title=\"convert-number-to-text-2\"><\/p>\n<p>N\u1ebfu nhi\u1ec1u s\u1ed1 b\u1ecb \u1ea3nh h\u01b0\u1edfng, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng ch\u1ecdn, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Format Cells&gt;Number tab&gt;Number<\/strong>\u00a0v\u00e0 nh\u1ea5p\u00a0<strong>OK<\/strong>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thua_khoang_trang_o_dau_o_hoac_cuoi_o\"><\/span>Th\u1eeba kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u \u00f4 ho\u1eb7c cu\u1ed1i \u00f4:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 nguy\u00ean nh\u00e2n r\u00f5 r\u00e0ng nh\u1ea5t c\u1ee7a l\u1ed7i Vlookup N\/A v\u00ec m\u1eaft ng\u01b0\u1eddi kh\u00f4ng th\u1ec3 nh\u00ecn th\u1ea5y nh\u1eefng kh\u00f4ng gian \u0111\u1eb7c bi\u1ec7t, nh\u1ea5t l\u00e0 khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng l\u1edbn, n\u01a1i h\u1ea7u h\u1ebft c\u00e1c m\u1ee5c n\u1eb1m d\u01b0\u1edbi thanh cu\u1ed9n.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Truong_hop_1_Khoang_trang_trong_cot_do_tim_voi_cong_thuc_VLOOKUP\"><\/span>Tr\u01b0\u1eddng h\u1ee3p 1: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t d\u00f2 t\u00ecm (v\u1edbi c\u00f4ng th\u1ee9c VLOOKUP)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu c\u00e1c kho\u1ea3ng tr\u1ed1ng d\u01b0 th\u1eeba xu\u1ea5t hi\u1ec7n trong b\u1ea3ng ch\u00ednh c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c Vlookup b\u1eb1ng c\u00e1ch g\u00f3i \u0111\u1ed1i s\u1ed1 lookup_value v\u1edbi\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\">h\u00e0m TRIM<\/a>:<\/p>\n<p><strong>= VLOOKUP (TRIM ($F2), $A$2: $C$10,3, FALSE)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5642\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-26-1.png\" width=\"600\" height=\"187\" title=\"excel-dialog-box-launcher-1-26-1\"><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Truong_hop_2_Khoang_trang_trong_cot_tra_cuu\"><\/span>Tr\u01b0\u1eddng h\u1ee3p 2: Kho\u1ea3ng tr\u1eafng trong c\u1ed9t tra c\u1ee9u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu c\u00f3 kho\u1ea3ng tr\u1eafng xu\u1ea5t hi\u1ec7n trong c\u1ed9t tra c\u1ee9u, kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 tr\u00e1nh \u0111\u01b0\u1ee3c l\u1ed7i VLOOKUP # N\/A. Thay v\u00ec d\u00f9ng h\u00e0m VLOOKUP, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m INDEX \/ MATCH v\u00e0 TRIM:<\/p>\n<p><strong>= INDEX ($C$2: $C$10, MATCH (TRUE, TRIM ($A$2: $A$10) = TRIM ($F$2), 0))<\/strong><\/p>\n<p>V\u00ec \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, \u0111\u1eebng qu\u00ean nh\u1ea5n\u00a0<strong>Ctrl + Shift + Enter<\/strong>\u00a0ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 ph\u00edm\u00a0<strong>Enter<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh n\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5648\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-27-1.png\" width=\"600\" height=\"271\" title=\"excel-dialog-box-launcher-1-27-1\"><\/p>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/xoa-bo-khoang-trang-lam-sach-du-lieu-trong-excel.html\">Xo\u00e1 b\u1ecf kho\u1ea3ng tr\u1eafng, l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u trong Excel<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Loi_VALUE_khi_su_dung_VLOOKUP\"><\/span>L\u1ed7i #VALUE khi s\u1eed d\u1ee5ng VLOOKUP:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u00f3i chung, Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #VALUE! n\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u sai. \u0110\u1ed1i v\u1edbi\u00a0h\u00e0m VLOOKUP, c\u00f3 hai tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng g\u1eb7p g\u00e2y l\u1ed7i VALUE!.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gia_tri_tra_cuu_vuot_qua_255_ky_tu\"><\/span>Gi\u00e1 tr\u1ecb tra c\u1ee9u v\u01b0\u1ee3t qu\u00e1 255 k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Xin l\u01b0u \u00fd r\u1eb1ng h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 t\u1eeb 256 k\u00fd t\u1ef1 tr\u1edf l\u00ean. N\u1ebfu gi\u00e1 tr\u1ecb tra c\u1ee9u c\u1ee7a b\u1ea1n v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n n\u00e0y, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c l\u1ed7i VALUE:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5656\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-28.png\" width=\"600\" height=\"192\" title=\"excel-dialog-box-launcher-1-28\"><\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0H\u00e3y s\u1eed d\u1ee5ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDEX \/ MATCH<\/a>\u00a0thay th\u1ebf. Trong v\u00ed d\u1ee5 tr\u00ean, h\u00e0m INDEX \/ MATCH ho\u1ea1t \u0111\u1ed9ng ho\u00e0n h\u1ea3o:<\/p>\n<p><strong>= INDEX (C2: C7, MATCH (TRUE, INDEX (B2: B7 = F$2,0), 0))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5657\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-29.png\" width=\"600\" height=\"202\" title=\"excel-dialog-box-launcher-1-29\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Khong_co_duong_dan_day_du_toi_bang_tinh_tra_cuu\"><\/span>Kh\u00f4ng c\u00f3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi b\u1ea3ng t\u00ednh tra c\u1ee9u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, b\u1ea1n ph\u1ea3i bao g\u1ed3m \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 \u0111\u1ebfn t\u1ec7p \u0111\u00f3. Ch\u00ednh x\u00e1c h\u01a1n, b\u1ea1n ph\u1ea3i k\u00e8m theo t\u00ean c\u1ee7a t\u1ec7p (bao g\u1ed3m c\u1ea3 ph\u1ea7n m\u1edf r\u1ed9ng) trong d\u1ea5u ngo\u1eb7c vu\u00f4ng [], v\u00e0 sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh t\u00ean c\u1ee7a trang t\u00ednh v\u00e0 d\u1ea5u ch\u1ea5m than. Ngo\u00e0i ra, b\u1ea1n n\u00ean \u0111\u1eb7t ch\u00fang trong d\u1ea5u nh\u00e1y trong tr\u01b0\u1eddng h\u1ee3p t\u1ec7p ho\u1eb7c t\u00ean trang t\u00ednh c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1ed1ng.<\/p>\n<p><span lang=\"vi\">\u0110\u00e2y l\u00e0 c\u1ea5u tr\u00fac c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh c\u1ee7a vlookup tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c:<\/span><\/p>\n<div class=\"code-block code-block-1\">\n<div class=\"ad-inserterpro\"><strong>= VLOOKUP (lookup_value, \u2018[t\u00ean t\u1ec7p] t\u00ean trang t\u00ednh\u2019! Table_array, col_index_num, FALSE)<\/strong><\/div>\n<\/div>\n<p><span lang=\"vi\">M\u1ed9t c\u00f4ng th\u1ee9c th\u1ef1c s\u1ef1 c\u00f3 th\u1ec3 tr\u00f4ng nh\u01b0 sau:<\/span><\/p>\n<p><span lang=\"vi\"><strong>= VLOOKUP ($A$2, \u2018[New Prices.xls] Sheet1\u2019! $B:$D, 3, FALSE)<\/strong><\/span><\/p>\n<p><span lang=\"vi\">C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u00f4 A2 trong c\u1ed9t B c\u1ee7a Sheet1 t\u1ec7p \u201c<strong>New Prices<\/strong>\u201d v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p t\u1ea1i c\u1ed9t D.<\/span><\/p>\n<p><span lang=\"vi\">N\u1ebfu b\u1ea5t k\u1ef3 ph\u1ea7n t\u1eed n\u00e0o c\u1ee7a \u0111\u01b0\u1eddng d\u1eabn b\u1ecb thi\u1ebfu, c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 tr\u1ea3 l\u1ea1i l\u1ed7i #VALUE (tr\u1eeb khi b\u1ea3ng t\u00ednh tra c\u1ee9u hi\u1ec7n \u0111ang m\u1edf).<\/span><\/p>\n<blockquote>\n<p>N\u00ean xem th\u00eam:\u00a0<a href=\"https:\/\/goo.gl\/fE09Ao\" target=\"_blank\" rel=\"noopener noreferrer\">Th\u00e0nh chuy\u00ean gia Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao trong 7 ng\u00e0y<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Doi_so_col_index_num_nho_hon_1\"><\/span>\u0110\u1ed1i s\u1ed1 col_index_num nh\u1ecf h\u01a1n 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span lang=\"vi\">Kh\u00f3 c\u00f3 t\u00ecnh hu\u1ed1ng nh\u1eadp m\u1ed9t s\u1ed1 nh\u1ecf h\u01a1n \u201c1\u201d \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u1ed9t gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. Tuy v\u1eady, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra n\u1ebfu \u0111\u1ed1i s\u1ed1 n\u00e0y l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t h\u00e0m Excel kh\u00e1c \u0111\u01b0\u1ee3c l\u1ed3ng v\u00e0o c\u00f4ng th\u1ee9c Vlookup c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span lang=\"vi\">V\u00ec v\u1eady, n\u1ebfu \u0111\u1ed1i s\u1ed1 col_index_num nh\u1ecf h\u01a1n 1, c\u00f4ng th\u1ee9c Vlookup c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/span><\/p>\n<p><span lang=\"vi\">N\u1ebfu \u0111\u1ed1i s\u1ed1 col_index_num l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn, c\u00f4ng th\u1ee9c Vlookup tr\u1ea3 v\u1ec1 l\u1ed7i #REF!<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loi_NAME_khi_su_dung_VLOOKUP\"><\/span>L\u1ed7i #NAME khi s\u1eed d\u1ee5ng VLOOKUP:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p d\u1ec5 nh\u1ea5t \u2013 l\u1ed7i NAME xu\u1ea5t hi\u1ec7n n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh vi\u1ebft sai ch\u00ednh t\u1ea3 t\u00ean c\u1ee7a h\u00e0m.<\/p>\n<p>Gi\u1ea3i ph\u00e1p l\u00e0 r\u00f5 r\u00e0ng \u2013 h\u00e3y ki\u1ec3m tra ch\u00ednh t\u1ea3:)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_khong_hoat_dong_han_che_su_co_va_giai_phap\"><\/span><span id=\"VLOOKUP_khong_hoat_dong_han_che_su_co_va_giai_phap\" class=\"ez-toc-section\"><\/span><b>VLOOKUP kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng (h\u1ea1n ch\u1ebf, s\u1ef1 c\u1ed1 v\u00e0 gi\u1ea3i ph\u00e1p)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i vi\u1ec7c c\u00f3 m\u1ed9t c\u00fa ph\u00e1p kh\u00e1 ph\u1ee9c t\u1ea1p, h\u00e0m\u00a0 VLOOKUP c\u00f3 nhi\u1ec1u h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 so v\u1edbi b\u1ea5t k\u1ef3 h\u00e0m Excel kh\u00e1c. Do nh\u1eefng h\u1ea1n ch\u1ebf n\u00e0y, c\u00f4ng th\u1ee9c Vlookup th\u01b0\u1eddng mang l\u1ea1i k\u1ebft qu\u1ea3 kh\u00f4ng nh\u01b0 mong \u0111\u1ee3i. D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00e1c gi\u1ea3i ph\u00e1p cho m\u1ed9t v\u00e0i t\u00ecnh hu\u1ed1ng ph\u1ed5 bi\u1ebfn khi VLOOKUP kh\u00f4ng th\u00e0nh c\u00f4ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vlookup_khong_phan_biet_chu_hoa_chu_thuong\"><\/span><span id=\"Vlookup_khong_phan_biet_chu_hoa_chu_thuong\" class=\"ez-toc-section\"><\/span><b>Vlookup kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m VLOOKUP kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng. V\u00ec v\u1eady, n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u m\u1ee5c t\u01b0\u01a1ng t\u1ef1 ch\u1ec9 kh\u00e1c nhau ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, c\u00f4ng th\u1ee9c Vlookup s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean b\u1ea5t k\u1ec3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o.<\/p>\n<p><b>Gi\u1ea3i ph\u00e1p :<\/b>\u00a0S\u1eed d\u1ee5ng m\u1ed9t h\u00e0m Excel kh\u00e1c c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u theo chi\u1ec1u d\u1ecdc (LOOKUP, SUMPRODUCT, INDEX \/ MATCH) k\u1ebft h\u1ee3p v\u1edbi h\u00e0m EXACT \u0111\u1ec3 c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n tra c\u1ee9u. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y c\u00e1c gi\u1ea3i th\u00edch chi ti\u1ebft v\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c trong h\u01b0\u1edbng d\u1eabn n\u00e0y \u2013 4 c\u00e1ch \u0111\u1ec3 t\u1ea1o vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel .<\/p>\n<h3><span class=\"ez-toc-section\" id=\"VLOOKUP_tra_ve_gia_tri_tim_thay_dau_tien\"><\/span><span id=\"VLOOKUP_tra_ve_gia_tri_tim_thay_dau_tien\" class=\"ez-toc-section\"><\/span><b>VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean n\u00f3 t\u00ecm th\u1ea5y trong c\u1ed9t tr\u1ea3 v\u1ec1 ph\u00f9 h\u1ee3p v\u1edbi gi\u00e1 tr\u1ecb tra c\u1ee9u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 bu\u1ed9c n\u00f3 tr\u1ea3 v\u1ec1 c\u00e1i th\u1ee9 2, 3, 4 ho\u1eb7c b\u1ea5t k\u1ef3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o m\u00e0 b\u1ea1n mu\u1ed1n. N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadn \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m INDEX, SMALL v\u00e0 ROW.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c c\u00f3 s\u1eb5n \u0111\u1ec3 t\u1ea3i v\u1ec1 t\u1ea1i \u0111\u00e2y:<\/p>\n<ul>\n<li>Nh\u1eadn bi\u1ebft c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 2, 3, 4, v.v \u2026<\/li>\n<li>Nh\u1eadn t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u00f9ng l\u1eb7p c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Mot_cot_moi_duoc_chen_vao_hoac_go_bo_khoi_hang\"><\/span><span id=\"Mot_cot_moi_duoc_chen_vao_hoac_go_bo_khoi_hang\" class=\"ez-toc-section\"><\/span><b>M\u1ed9t c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o ho\u1eb7c g\u1ee1 b\u1ecf kh\u1ecfi h\u00e0ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c c\u00f4ng th\u1ee9c VLOOKUP s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng khi m\u1ed9t c\u1ed9t m\u1edbi b\u1ecb x\u00f3a kh\u1ecfi ho\u1eb7c \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1ea3ng tra c\u1ee9u. \u0110i\u1ec1u n\u00e0y x\u1ea3y ra do c\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP y\u00eau c\u1ea7u b\u1ea1n cung c\u1ea5p to\u00e0n b\u1ed9 b\u1ea3ng c\u0169ng nh\u01b0 m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh cho bi\u1ebft b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb c\u1ed9t n\u00e0o. \u0110\u01b0\u01a1ng nhi\u00ean, c\u1ea3 b\u1ea3ng v\u00e0 s\u1ed1 c\u1ee7a c\u1ed9t tr\u1ea3 v\u1ec1 \u0111\u1ec1u thay \u0111\u1ed5i khi b\u1ea1n x\u00f3a m\u1ed9t c\u1ed9t hi\u1ec7n c\u00f3 ho\u1eb7c ch\u00e8n m\u1ed9t c\u1ed9t m\u1edbi.<\/p>\n<p><b><i>Gi\u1ea3i ph\u00e1p:<\/i><\/b>\u00a0INDEX \/ MATCH \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y. Trong h\u00e0m INDEX &amp; MATCH, b\u1ea1n ch\u1ec9 \u0111\u1ecbnh c\u00e1c c\u1ed9t tra c\u1ee9u v\u00e0 c\u1ed9t tr\u1ea3 k\u1ebft qu\u1ea3 ri\u00eang bi\u1ec7t, k\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a ho\u1eb7c ch\u00e8n nhi\u1ec1u c\u1ed9t t\u00f9y \u00fd m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i c\u1eadp nh\u1eadt m\u1ecdi c\u00f4ng th\u1ee9c vlookup li\u00ean quan .<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_o_tham_chieu_thay_doi_khi_sao_chep_cong_thuc_den_o_khac\"><\/span><span id=\"Cac_o_tham_chieu_thay_doi_khi_sao_chep_cong_thuc_den_o_khac\" class=\"ez-toc-section\"><\/span><b>C\u00e1c \u00f4 tham chi\u1ebfu thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Gi\u1ea3i ph\u00e1p:<\/b>\u00a0Lu\u00f4n s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i (v\u1edbi d\u1ea5u $) trong v\u00f9ng ch\u1ecdn, v\u00ed d\u1ee5: $A$2: $C$100 ho\u1eb7c $A:$C. Trong thanh c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c lo\u1ea1i tham chi\u1ebfu kh\u00e1c nhau b\u1eb1ng c\u00e1ch nh\u1ea5n F4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_voi_ham_IFERROR_ISERROR\"><\/span><span id=\"Ham_VLOOKUP_voi_ham_IFERROR_ISERROR\" class=\"ez-toc-section\"><\/span><b>H\u00e0m VLOOKUP v\u1edbi h\u00e0m IFERROR \/ ISERROR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng b\u00e1o l\u1ed7i N\/A, VALUE ho\u1eb7c NAME, b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i \u00f4 tr\u1ed1ng ho\u1eb7c hi\u1ec3n th\u1ecb n\u1ed9i dung c\u1ee7a ri\u00eang b\u1ea1n. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch l\u1ed3ng c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n trong h\u00e0m IFERROR trong Excel 2013, 2010 v\u00e0 2007 ho\u1eb7c h\u00e0m IF \/ ISERROR trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_VLOOKUP_voi_IFERROR\"><\/span><span id=\"Su_dung_VLOOKUP_voi_IFERROR\" class=\"ez-toc-section\"><\/span><b>S\u1eed d\u1ee5ng VLOOKUP v\u1edbi IFERROR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IFERROR r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<p><strong>IFERROR (gi\u00e1 tr\u1ecb, gi\u00e1 tr\u1ecb_if_error)<\/strong><\/p>\n<p>B\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u1ec3 ki\u1ec3m tra l\u1ed7i trong \u0111\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t, v\u00e0 trong \u0111\u1ed1i s\u1ed1 th\u1ee9 2 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu l\u1ed7i x\u1ea3y ra.<\/p>\n<p>V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c IFERROR \/ VLOOKUP tr\u1ea3 v\u1ec1 m\u1ed9t \u00f4 tr\u1ed1ng khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u:<\/p>\n<p><strong>=IFERROR(VLOOKUP($F$2,$B$2:$C$10,2,FALSE),\u201d\u201d)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-iferror-2.png\" alt=\"The IFERROR \/ VLOOKUP formula returns a blank cell instead of the error message.\" width=\"510\" height=\"265\" title=\"vlookup-iferror-2\"><\/p>\n<p>N\u1ebfu b\u1ea1n th\u00edch hi\u1ec3n th\u1ecb n\u1ed9i dung m\u00e0 m\u00ecnh mu\u1ed1n thay v\u00ec nh\u1eefng bi\u1ec3u hi\u1ec7n l\u1ed7i th\u00f4ng th\u01b0\u1eddng, h\u00e3y \u0111\u00e1nh ch\u00fang v\u00e0o d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><strong>=IFERROR(VLOOKUP($F$2,$B$2:$C$10,2,FALSE),\u201dOops, no match is found. Please try again!\u201d)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-iferror-message-2.png\" alt=\"Display your message instead of VLOOKUP error.\" width=\"602\" height=\"230\" title=\"vlookup-iferror-message-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP_voi_ISERROR\"><\/span><span id=\"Su_dung_ham_VLOOKUP_voi_ISERROR\" class=\"ez-toc-section\"><\/span><b>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi ISERROR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m IFERROR c\u00f3 \u1edf phi\u00ean b\u1ea3n Excel 2007, trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 ISERROR nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><strong>=IF(ISERROR(VLOOKUP formula), \u201cYour message if any\u201d, VLOOKUP formula)<\/strong><\/p>\n<p>V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c IF \/ ISERROR \/ VLOOKUP t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00f4ng th\u1ee9c IFERROR \/ VLOOKUP \u1edf tr\u00ean:<\/p>\n<p><strong>=IF(ISERROR(VLOOKUP($F$2,$B$2:$C$10,2,FALSE)), \u201c\u201d, VLOOKUP($F$2,$B$2:$C$10,2,FALSE))<\/strong><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng l\u1ed7i hay g\u1eb7p trong h\u00e0m Vlookup.\u00a0<strong>H\u1ecdc Excel Online<\/strong>\u00a0hy v\u1ecdng th\u00f4ng qua nh\u1eefng h\u01b0\u1edbng d\u1eabn tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra c\u1ee7a h\u00e0m Vlookup.<\/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-468.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5413","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\/5413","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=5413"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5414"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}