{"id":7499,"date":"2024-12-21T17:43:53","date_gmt":"2024-12-21T17:43:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tranh-loi-n-a-vlookup\/"},"modified":"2024-12-21T17:43:53","modified_gmt":"2024-12-21T17:43:53","slug":"huong-dan-tranh-loi-n-a-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tranh-loi-n-a-vlookup\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn tr\u00e1nh l\u1ed7i #N\/A VLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel, khi s\u1eed d\u1ee5ng\u00a0<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> \u0111\u00f4i khi ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch tr\u00e1nh <a href=\"http:\/\/blog.ezworkapp.com\/tranh-loi-n-a-vlookup.html\"><strong>l\u1ed7i #N\/A VLOOKUP<\/strong><\/a> v\u1edbi b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/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-6766fe58ae9c1\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tranh-loi-n-a-vlookup.html#Tranh_loi_NA_VLOOKUP_voi_IFERROR\" title=\"Tr\u00e1nh l\u1ed7i #N\/A VLOOKUP v\u1edbi IFERROR\">Tr\u00e1nh l\u1ed7i #N\/A 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-2\" href=\"https:\/\/blog.hocexcel.online\/tranh-loi-n-a-vlookup.html#Tranh_loi_trong_nhung_phien_ban_cu_hon\" title=\"Tr\u00e1nh l\u1ed7i trong nh\u1eefng phi\u00ean b\u1ea3n c\u0169 h\u01a1n\">Tr\u00e1nh l\u1ed7i trong nh\u1eefng phi\u00ean b\u1ea3n c\u0169 h\u01a1n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tranh_loi_NA_VLOOKUP_voi_IFERROR\"><\/span>Tr\u00e1nh l\u1ed7i #N\/A VLOOKUP v\u1edbi IFERROR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta \u0111\u1ec1u bi\u1ebft c\u00f4ng th\u1ee9c c\u1ee7a VLOOKUP nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=VLOOKUP(gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea3ng t\u00ecm ki\u1ebfm, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm, ki\u1ec3u t\u00ecm ki\u1ebfm)<\/p>\n<\/blockquote>\n<p>Khi s\u1eed d\u1ee5ng IFERROR \u0111\u1ec3 tr\u00e1nh l\u1ed7i, ta l\u1ed3ng v\u00e0o nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=IFERROR(VLOOKUP(gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea3ng t\u00ecm ki\u1ebfm, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm, ki\u1ec3u t\u00ecm ki\u1ebfm),\u201dth\u00f4ng b\u00e1o n\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3\u201d)<\/p>\n<\/blockquote>\n<p>H\u00e0m IFERROR s\u1ebd thay k\u1ebft qu\u1ea3 #N\/A b\u1eb1ng m\u1ed9t th\u00f4ng b\u00e1o n\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm.\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31173 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tranh-loi-na-1-1024x294-1.png\" alt=\"tranh-loi-Vlookup-1\" width=\"1024\" height=\"294\" title=\"tranh-loi-na-1-1024x294-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tranh_loi_trong_nhung_phien_ban_cu_hon\"><\/span>Tr\u00e1nh l\u1ed7i trong nh\u1eefng phi\u00ean b\u1ea3n c\u0169 h\u01a1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu m\u00e1y b\u1ea1n thi\u1ebfu h\u00e0m IFERROR, m\u1ed9t gi\u1ea3i ph\u00e1p thay th\u1ebf l\u00e0 s\u1eed d\u1ee5ng ISERROR ho\u1eb7c ISNA k\u1ebft h\u1ee3p v\u1edbi IF theo c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p>=IF(ISERROR(VLOOKUP(gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea3ng t\u00ecm ki\u1ebfm, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm, ki\u1ec3u t\u00ecm ki\u1ebfm)), \u201cth\u00f4ng b\u00e1o n\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3\u201d, VLOOKUP(gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea3ng t\u00ecm ki\u1ebfm, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm, ki\u1ec3u t\u00ecm ki\u1ebfm))<\/p>\n<\/blockquote>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 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-671.gif\" title=\"ex101_92019-nho-671\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html\"><strong>K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ISNA<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\"><strong>Nh\u1eadn bi\u1ebft l\u1ed7i, b\u1eaby l\u1ed7i trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html\"><strong>H\u00e0m VLOOKUP c\u01a1 b\u1ea3n trong Excel<\/strong><\/a><\/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-671.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7499","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\/7499","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=7499"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7499\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7500"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}