{"id":325,"date":"2020-07-12T22:10:04","date_gmt":"2020-07-12T15:10:04","guid":{"rendered":"https:\/\/hoctin.vn\/?p=325"},"modified":"2020-07-16T15:00:03","modified_gmt":"2020-07-16T08:00:03","slug":"cach-sua-loi-n-a-cua-ham-vlookup","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-sua-loi-n-a-cua-ham-vlookup\/","title":{"rendered":"C\u00e1ch S\u1eeda L\u1ed7i #N\/A C\u1ee7a H\u00e0m VLOOKUP Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"325\" class=\"elementor elementor-325\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7a79b2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a79b2f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-759b73a\" data-id=\"759b73a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-45ce189 elementor-widget elementor-widget-text-editor\" data-id=\"45ce189\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m VLOOKUP b\u1ea1n th\u01b0\u1eddng xuy\u00ean g\u1eb7p c\u00e1c l\u1ed7i trong excel, trong \u0111\u00f3 ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 l\u1ed7i N\/A. V\u1eady l\u1ed7i N\/A l\u00e0 g\u00ec, nguy\u00ean nh\u00e2n, c\u00e1ch kh\u1eafc ph\u1ee5c v\u00e0 s\u1eeda l\u1ed7i n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c hoctin.vn chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n trong b\u00e0i vi\u1ebft n\u00e0y.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64ccb8a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64ccb8a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9cb19b7\" data-id=\"9cb19b7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e9313e2 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"e9313e2\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h3 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h3>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cd1a0f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd1a0f4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-66dea67\" data-id=\"66dea67\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5f1a3be elementor-widget elementor-widget-heading\" data-id=\"5f1a3be\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1. L\u1ed7i #N\/A Trong Excel L\u00e0 G\u00ec?<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-461a3ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"461a3ef\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9efd570\" data-id=\"9efd570\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78bb674 elementor-widget elementor-widget-text-editor\" data-id=\"78bb674\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u1ed7i N\/A cho bi\u1ebft r\u1eb1ng m\u1ed9t c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tham chi\u1ebfu m\u00e0 c\u00f4ng th\u1ee9c \u0111\u00f3 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u t\u00ecm. L\u1ed7i n\u00e0y kh\u00f4ng do l\u1ed7i sai h\u00e0m, sai c\u00f4ng th\u1ee9c. V\u1eady N\/A ngh\u0129a l\u00e0 g\u00ec?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">N\/A trong ti\u1ebfng anh l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Not Available\/ Kh\u00f4ng t\u1ed3n t\u1ea1i, kh\u00f4ng c\u00f3 s\u1eb5n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">C\u00e1c l\u00ed do h\u00e0m VLOOKUP kh\u00f4ng ch\u1ea1y do l\u1ed7i N\/A c\u00f3 th\u1ec3 li\u1ec7t k\u00ea nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a077534 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a077534\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e991c6a\" data-id=\"e991c6a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9c36c3a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9c36c3a\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">Gi\u00e1 tr\u1ecb tra c\u1ee9u kh\u00f4ng n\u1eb1m trong c\u1ed9t \u0111\u1ea7u ti\u00ean trong \u0111\u1ed1i s\u1ed1 table_array<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">L\u1ed7i NA trong t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang b\u1eb1ng h\u00e0m VLOOKUP<\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">L\u1ed7i NA trong t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c h\u00e0m VLOOKUP<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">Gi\u00e1 tr\u1ecb tra c\u1ee9u c\u1ee7a b\u1ea1n kh\u00f4ng t\u1ed3n t\u1ea1i trong d\u1eef li\u1ec7u ngu\u1ed3n<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">G\u1eb7p l\u1ed7i khi vi\u1ebft h\u00e0m, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm tr\u01b0\u1edbc khi copy c\u00f4ng th\u1ee9c h\u00e0ng lo\u1ea1t.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-54950f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54950f6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-50e338f\" data-id=\"50e338f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-551a74a elementor-widget elementor-widget-heading\" data-id=\"551a74a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. L\u1ed7i #N\/A Trong H\u00e0m VLOOKUP Do Gi\u00e1 Tr\u1ecb Tra C\u1ee9u Kh\u00f4ng N\u1eb1m Trong C\u1ed9t \u0110\u1ea7u Ti\u00ean Trong \u0110\u1ed1i S\u1ed1 Table_array<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a5506b4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a5506b4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3f16f59\" data-id=\"3f16f59\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93b9461 elementor-widget elementor-widget-text-editor\" data-id=\"93b9461\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP ta th\u01b0\u1eddng qu\u00ean \u0111i l\u01b0u \u00fd 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. Nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b462aa4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b462aa4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31e9efa\" data-id=\"31e9efa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e2c75cc elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"e2c75cc\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">T\u1ea1i \u00f4 C19, c\u00f4ng th\u1ee9c l\u00e0 =VLOOKUP(B10,$A$3:$E$7,4,0) nh\u1eb1m t\u00ecm ki\u1ebfm H\u1ecd t\u00ean c\u1ee7a ID V00038.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">\u0110\u1ec3 tra c\u1ee9u V00038, c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a table_array (v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm) ph\u1ea3i l\u00e0 c\u1ed9t ID t\u1ee9c c\u1ed9t C, nh\u01b0ng c\u00f4ng th\u1ee9c l\u1ea1i \u0111\u1eb7t v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm t\u1eeb c\u1ed9t A \u0111\u1ebfn c\u1ed9t E.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-311f753 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"311f753\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a538540\" data-id=\"a538540\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d9ab849 elementor-widget elementor-widget-image\" data-id=\"d9ab849\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Loi-NA-do-cot-dau-tien-khong-chua-gia-tri-tra-cuu.png\" title=\"Loi-NA-do-cot-dau-tien-khong-chua-gia-tri-tra-cuu\" alt=\"L\u1ed7i #N\/A trong h\u00e0m vlookup do gi\u00e1 tr\u1ecb tra c\u1ee9u kh\u00f4ng n\u1eb1m trong c\u1ed9t \u0111\u1ea7u ti\u00ean trong \u0111\u1ed1i s\u1ed1 table_array\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9135734 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9135734\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63fbe01\" data-id=\"63fbe01\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-20c923a elementor-widget elementor-widget-text-editor\" data-id=\"20c923a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-a28b55d7-7fff-f6d2-d79d-82fffe5ea9be\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch s\u1eeda l\u1ed7i n\u00e0y \u0111\u01a1n gi\u1ea3n l\u00e0 thay \u0111\u1ed5i Table_array v\u00e0 \u0111\u1ed5i s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t Col_index_num th\u00e0nh =VLOOKUP(B10,$C$3:$E$7,2,0). Khi \u0111\u00f3 h\u00e0m VLOOKUP ch\u1ea1y ra k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-297d734 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"297d734\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-87bc18c\" data-id=\"87bc18c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2d80ff0 elementor-widget elementor-widget-image\" data-id=\"2d80ff0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/sua-loi-NA-khi-dung-ham-VLOOKUP.png\" title=\"sua-loi-NA-khi-dung-ham-VLOOKUP\" alt=\"S\u1eeda l\u1ed7i h\u00e0m VLOOKUP kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00ec l\u1ed7i #N\/A\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef4146d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef4146d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-45ef320\" data-id=\"45ef320\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-30e4f53 elementor-widget elementor-widget-heading\" data-id=\"30e4f53\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>3, L\u1ed7i #N\/A Trong T\u00ecm Ki\u1ebfm G\u1ea7n \u0110\u00fang B\u1eb1ng H\u00e0m VLOOKUP<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63d8222 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63d8222\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5767160\" data-id=\"5767160\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b74a07 elementor-widget elementor-widget-text-editor\" data-id=\"0b74a07\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang (\u0111\u1ed1i s\u1ed1 range_lookup l\u00e0 TRUE ho\u1eb7c b\u1ecf qua), c\u00f4ng th\u1ee9c Vlookup c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 l\u1ed7i # N\/A trong hai tr\u01b0\u1eddng h\u1ee3p:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fa4785c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa4785c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-232d938\" data-id=\"232d938\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b32736d elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b32736d\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">N\u1ebfu gi\u00e1 tr\u1ecb tra c\u1ee9u nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ea3ng tra c\u1ee9u.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">N\u1ebfu c\u1ed9t tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a58b33e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a58b33e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-17b04fa\" data-id=\"17b04fa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3741c70 elementor-widget elementor-widget-heading\" data-id=\"3741c70\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); vertical-align: baseline;\">Tr\u01b0\u1eddng H\u1ee3p 1<\/span><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: 400; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); vertical-align: baseline;\">: L\u1ed7i N\/A N\u1ebfu Gi\u00e1 Tr\u1ecb Tra C\u1ee9u Nh\u1ecf H\u01a1n Gi\u00e1 Tr\u1ecb Nh\u1ecf Nh\u1ea5t Trong M\u1ea3ng Tra C\u1ee9u<\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c59746 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c59746\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-35c07b3\" data-id=\"35c07b3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6434603 elementor-widget elementor-widget-text-editor\" data-id=\"6434603\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap; background-color: #ffffff;\">V\u00ed d\u1ee5 \u0110i\u1ec3m t\u1ed5ng k\u1ebft m\u00f4n c\u1ee7a sinh vi\u00ean Tr\u1ea7n M\u1ea1nh Th\u1eafng v\u00e0 Nguy\u1ec5n Th\u1ecb Vi\u1ec7t H\u1ed3ng l\u1ea7n l\u01b0\u1ee3t t\u1ea1i \u00f4 B5 v\u00e0 B9 l\u00e0 3.0 v\u00e0 4.6 nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm l\u00e0 5 th\u00ec h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i N\/A nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a02bf5f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a02bf5f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-330d9d3\" data-id=\"330d9d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-512e778 elementor-widget elementor-widget-image\" data-id=\"512e778\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Loi-NA-trong-tim-kiem-gan-dung-bang-ham-vlookup.png\" title=\"Loi-NA-trong-tim-kiem-gan-dung-bang-ham-vlookup\" alt=\"L\u1ed7i #N\/A trong t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang b\u1eb1ng h\u00e0m VLOOKUP do gi\u00e1 tr\u1ecb tra c\u1ee9u nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ea3ng tra c\u1ee9u\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9200a68 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9200a68\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c8f52e3\" data-id=\"c8f52e3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e86cf36 elementor-widget elementor-widget-text-editor\" data-id=\"e86cf36\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ea7n \u0111\u1eb7t th\u00eam h\u00e0m IF \u0111\u1ec3 so s\u00e1nh v\u1edbi gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a v\u00f9ng t\u00ecm ki\u1ebfm: n\u1ebfu \u0110i\u1ec3m t\u1ed5ng k\u1ebft m\u00f4n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t n\u00e0y (\u00f4 G4) th\u00ec tr\u1ea3 v\u1ec1 h\u00e0m VLOOKUP, n\u1ebfu kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 c\u1ee5m \u201cKh\u00f4ng \u0111\u1ea1t \u0111i\u1ec1u ki\u1ec7n\u201d<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1ea1i \u00f4 C5: <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-indent: 36pt;\">=IF($B5&gt;=$G4,VLOOKUP($B5,$G$4:$J$10,3,TRUE),\u201cKh\u00f4ng \u0111\u1ea1t \u0111i\u1ec1u ki\u1ec7n\u201d)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-indent: 36pt; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70a48de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70a48de\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9fd5eb6\" data-id=\"9fd5eb6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e75d7c1 elementor-widget elementor-widget-heading\" data-id=\"e75d7c1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); vertical-align: baseline;\">Tr\u01b0\u1eddng H\u1ee3p 2<\/span><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: 400; text-align: justify; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); vertical-align: baseline;\">: L\u1ed7i #N\/A N\u1ebfu C\u1ed9t Tra C\u1ee9u Kh\u00f4ng \u0110\u01b0\u1ee3c S\u1eafp X\u1ebfp Theo Th\u1ee9 T\u1ef1 T\u0103ng D\u1ea7n.<\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-94a69f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94a69f6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6806962\" data-id=\"6806962\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-77c6f11 elementor-widget elementor-widget-text-editor\" data-id=\"77c6f11\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang 1\/TRUE, ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i \u0111\u1ea3m b\u1ea3o th\u00f4ng tin trong b\u1ea3ng Table_array (v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm) ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y khi Table_array kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n th\u00ec h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb \u0110i\u1ec3m t\u1ed5ng k\u1ebft m\u00f4n c\u1ee7a v\u00f9ng \u0111i\u1ec3m ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i N\/A:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-012d843 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"012d843\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b435838\" data-id=\"b435838\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bb524a1 elementor-widget elementor-widget-image\" data-id=\"bb524a1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Loi-NA-trong-tim-kiem-gan-dung-bang-ham-vlookup-chua-sap-xep-cot-tra-cuu.png\" title=\"Loi-NA-trong-tim-kiem-gan-dung-bang-ham-vlookup-chua-sap-xep-cot-tra-cuu\" alt=\"L\u1ed7i #N\/A trong t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang b\u1eb1ng h\u00e0m VLOOKUP do c\u1ed9t tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0946b57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0946b57\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a2ca281\" data-id=\"a2ca281\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d93c76 elementor-widget elementor-widget-text-editor\" data-id=\"1d93c76\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">L\u1ed7i #N\/A n\u00e0y c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch s\u1eafp x\u1ebfp l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7180e19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7180e19\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da74ab6\" data-id=\"da74ab6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5b386fe elementor-widget elementor-widget-heading\" data-id=\"5b386fe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4. L\u1ed7i N\/A Trong T\u00ecm Ki\u1ebfm Ch\u00ednh X\u00e1c H\u00e0m VLOOKUP<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-28d48a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28d48a1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dc1a958\" data-id=\"dc1a958\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6c72433 elementor-widget elementor-widget-text-editor\" data-id=\"6c72433\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">M\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ec3n nh\u1ea5t l\u00e0m\u00a0c\u00f4ng th\u1ee9c Excel kh\u00f4ng ra k\u1ebft qu\u1ea3 khi t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c b\u1eb1ng h\u00e0m VLOOKUP l\u00e0 do v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm kh\u00f4ng ch\u1eefa d\u1eef li\u1ec7u c\u1ea7n t\u00ecm.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, t\u1ea1i \u00f4 B15 v\u00e0 B16, h\u00e0m VLOOKUP c\u00f3 c\u00f9ng c\u00f4ng th\u1ee9c, ch\u1ec9 kh\u00e1c gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm l\u1ea7n l\u01b0\u1ee3t l\u00e0 A15 v\u00e0 A16 nh\u01b0ng \u00f4 B15 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u00ecm t\u00ean trong excel c\u00f2n \u00f4 B16 tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Nguy\u00ean nh\u00e2n do c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm $A$2:$C$10 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb V00039 n\u00ean h\u00e0m VLOOKUP kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm \u0111\u01b0\u1ee3c.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3df0111 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3df0111\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-093fb8b\" data-id=\"093fb8b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-481f6af elementor-widget elementor-widget-image\" data-id=\"481f6af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Loi-NA-trong-tim-kiem-chinh-xac-bang-ham-vlookup.png\" title=\"Loi-NA-trong-tim-kiem-chinh-xac-bang-ham-vlookup\" alt=\"L\u1ed7i N\/A trong t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c h\u00e0m VLOOKUP\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86d1865 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86d1865\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c6ae2a9\" data-id=\"c6ae2a9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8b63031 elementor-widget elementor-widget-text-editor\" data-id=\"8b63031\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IFERROR ho\u1eb7c IFNA \u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u0103n b\u1ea3n th\u00f4ng b\u00e1o kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=IFNA(=VLOOKUP($A16,$A$2:$C$10,2,0),&#8221;Not available&#8221;)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">=IFERROR(VLOOKUP($A15,$A$2:$C$10,2,0),&#8221;Not available&#8221;)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2261ea7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2261ea7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-05edef5\" data-id=\"05edef5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b9bcdb3 elementor-widget elementor-widget-text-editor\" data-id=\"b9bcdb3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: rgb(0, 0, 0);\"><em><br><\/em><\/span><\/p><p><span style=\"color: rgb(0, 0, 0);\"><em>\u0110\u1ecdc th\u00eam v\u1ec1: <\/em><\/span><span style=\"color: rgb(0, 0, 0);\"><em>C\u00e1ch s\u1eed d\u1ee5ng <span style=\"color: #3366ff;\"><strong>h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP <\/strong><\/span>trong Excel<\/em><\/span><br><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b02ac22 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b02ac22\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c280dbc\" data-id=\"c280dbc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a09389 elementor-widget elementor-widget-heading\" data-id=\"3a09389\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">5,&nbsp;L\u1ed7i N\/A Trong VLOOKUP Do Gi\u00e1 Tr\u1ecb Tra C\u1ee9u Kh\u00f4ng T\u1ed3n T\u1ea1i Trong D\u1eef Li\u1ec7u Ngu\u1ed3n<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-55e1c35 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"55e1c35\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-35ef7ab\" data-id=\"35ef7ab\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ceacf55 elementor-widget elementor-widget-text-editor\" data-id=\"ceacf55\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i vi\u1ec7c l\u1ed7i N\/A kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi do d\u1eef li\u1ec7u c\u1ea7n t\u00ecm kh\u00f4ng n\u1eb1m trong khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array th\u00ec l\u1ed7i n\u00e0y c\u00f2n c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n do gi\u00e1 tr\u1ecb tra c\u1ee9u ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm g\u1eb7p l\u1ed7i \u0111\u1ecbnh d\u1ea1ng nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c3a5c16 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3a5c16\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3c54f0a\" data-id=\"3c54f0a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2e3b27a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"2e3b27a\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\">S\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\">C\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i \u00f4 c\u1ea7n d\u00f2 t\u00ecm<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\">C\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i \u00f4 trong c\u1ed9t tra c\u1ee9u<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e3b8383 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3b8383\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fea75da\" data-id=\"fea75da\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9c68050 elementor-widget elementor-widget-heading\" data-id=\"9c68050\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-cfdc4a73-7fff-c380-e454-d224ae1d92e0\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Tr\u01b0\u1eddng H\u1ee3p 1<\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: L\u1ed7i #NA Do S\u1ed1 \u0110\u01b0\u1ee3c \u0110\u1ecbnh D\u1ea1ng D\u01b0\u1edbi D\u1ea1ng V\u0103n B\u1ea3n<\/span><span style=\"font-style: inherit; font-weight: 600;\"><\/span><\/p><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89d0df6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89d0df6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0c61c0c\" data-id=\"0c61c0c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fc88011 elementor-widget elementor-widget-text-editor\" data-id=\"fc88011\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi s\u1ed1 b\u1ecb \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n (d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh c\u0103n l\u1ec1 tr\u00e1i ho\u1eb7c xu\u1ea5t hi\u1ec7n tam gi\u00e1c m\u00e0u xanh l\u00e1 c\u00e2y \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i \u00f4) th\u00ec h\u00e0m VLOOKUP kh\u00f4ng tr\u1ea3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 d\u00f2 t\u00ecm n\u1ebfu c\u00f9ng m\u1ed9t gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n v\u00e0 s\u1ed1 \u1edf lookup_value v\u00e0 table_array v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Tr\u01b0\u1eddng h\u1ee3p hay x\u1ea3y ra nh\u1ea5t l\u00e0 khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb data b\u00ean ngo\u00e0i ho\u1eb7c do g\u00f5 d\u1ea5u nh\u00e1y \u0111\u01a1n [ <b>\u2018 <\/b>] tr\u01b0\u1edbc s\u1ed1 nh\u01b0 \u00f4 A12 d\u01b0\u1edbi \u0111\u00e2y. C\u00e1ch kh\u1eafc ph\u1ee5c: chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 b\u1eb1ng c\u00e1ch \u1ea5n v\u00e0o d\u1ea5u ch\u1ea5m than &gt;&gt; Convert To Number.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5b58315 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b58315\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8d79145\" data-id=\"8d79145\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4c42953 elementor-widget elementor-widget-image\" data-id=\"4c42953\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/loi-NA-do-so-dang-van-ban.jpg\" title=\"loi NA do so dang van ban\" alt=\"L\u1ed7i N\/A trong vlookup do S\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3107b31 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3107b31\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e1ed4ba\" data-id=\"e1ed4ba\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-28f397f elementor-widget elementor-widget-heading\" data-id=\"28f397f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a5a1fdde-7fff-9bcc-fb31-381e8faedc0b\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>Tr\u01b0\u1eddng H\u1ee3p 2<\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: L\u1ed7i N\/A Do C\u00f3 Kho\u1ea3ng Tr\u1ed1ng Th\u1eeba \u1ede \u0110\u1ea7u Ho\u1eb7c Cu\u1ed1i \u00d4 C\u1ea7n D\u00f2 T\u00ecm<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c624a6f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c624a6f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fe37771\" data-id=\"fe37771\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8dd26d6 elementor-widget elementor-widget-text-editor\" data-id=\"8dd26d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-6627631f-7fff-ff2d-8298-af4313b11447\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch kh\u1eafc ph\u1ee5c: c\u1ea7n lo\u1ea1i t\u1ea5t c\u1ea3 kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u v\u00e0 cu\u1ed1i kh\u1ecfi v\u0103n b\u1ea3n, v\u00ed d\u1ee5 \u2018 \u00a0 V00003\u00a0 \u00a0 \u2019 c\u1ea7n x\u1eed l\u00fd th\u00e0nh \u2018V00003\u2019, ch\u1ec9 \u0111\u1ec3 l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb, v\u00ed d\u1ee5 \u2018 \u00a0 Nguy\u1ec5n Anh Tu\u1ea5n\u2019 c\u1ea7n x\u1eed l\u00fd th\u00e0nh \u2018Nguy\u1ec5n Anh Tu\u1ea5n\u2019 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TRIM:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c3fbad6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3fbad6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c3aef71\" data-id=\"c3aef71\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14a8c22 elementor-widget elementor-widget-image\" data-id=\"14a8c22\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/loi-NA-do-khoang-trang.png\" title=\"L\u1ed7i N\/A trong vlookup do c\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i \u00f4 c\u1ea7n d\u00f2 t\u00ecm\" alt=\"L\u1ed7i N\/A trong vlookup do c\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i \u00f4 c\u1ea7n d\u00f2 t\u00ecm\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-613f707 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"613f707\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6f75965\" data-id=\"6f75965\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dee055a elementor-widget elementor-widget-heading\" data-id=\"dee055a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><br><br><span style=\"font-weight:normal;\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Tr\u01b0\u1eddng H\u1ee3p 3<\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: C\u00f3 Kho\u1ea3ng Tr\u1ed1ng Th\u1eeba \u1ede \u0110\u1ea7u Ho\u1eb7c Cu\u1ed1i \u00d4 Trong C\u1ed9t Tra C\u1ee9u<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5829512 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5829512\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e77b4f1\" data-id=\"e77b4f1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-37a62d1 elementor-widget elementor-widget-text-editor\" data-id=\"37a62d1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1 tr\u01b0\u1eddng h\u1ee3p 2 \u1edf tr\u00ean, c\u00e1ch x\u1eed l\u00fd \u0111\u01a1n gi\u1ea3n nh\u1ea5t m\u00e0 kh\u00f4ng ph\u1ea3i d\u00f9ng c\u00e1c h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 INDEX v\u00e0 MATCH l\u00e0 th\u00eam m\u1ed9t c\u1ed9t tra c\u1ee9u \u0111\u00e3 qua x\u1eed l\u00fd lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng b\u1eb1ng h\u00e0m\u00a0 TRIM r\u1ed3i t\u00ecm ki\u1ebfm VLOOKUP d\u1ef1a tr\u00ean d\u1eef li\u1ec7u m\u1edbi n\u00e0y nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f828225 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f828225\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d340c63\" data-id=\"d340c63\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fce855a elementor-widget elementor-widget-image\" data-id=\"fce855a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/loi-NA-do-truong-du-lieu-trang.png\" title=\"loi NA do truong du lieu trang\" alt=\"L\u1ed7i N\/A trong vlookup do c\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i \u00f4 trong c\u1ed9t tra c\u1ee9u\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a3cd37f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3cd37f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-95d73d3\" data-id=\"95d73d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e8dd47b elementor-widget elementor-widget-heading\" data-id=\"e8dd47b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">6,&nbsp;L\u1ed7i N\/A H\u00e0m VLOOKUP Do G\u1eb7p L\u1ed7i Khi Vi\u1ebft H\u00e0m, Kh\u00f4ng C\u1ed1 \u0110\u1ecbnh V\u00f9ng D\u1eef Li\u1ec7u D\u00f2 T\u00ecm Tr\u01b0\u1edbc Khi Copy C\u00f4ng Th\u1ee9c H\u00e0ng Lo\u1ea1t<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-51f13a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"51f13a5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7241b79\" data-id=\"7241b79\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a0c409 elementor-widget elementor-widget-text-editor\" data-id=\"6a0c409\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-16667fc8-7fff-5abd-1f43-98015b321da1\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">L\u1ed7i n\u00e0y kh\u00e1 l\u00e0 ph\u1ed5 bi\u1ebfn do ng\u01b0\u1eddi d\u00f9ng qu\u00ean c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb tra c\u1ee9u Lookup_Value v\u00e0 v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array, l\u1ed7i excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c \u0111\u00fang d\u1eabn \u0111\u1ebfn kh\u00f4ng t\u00ecm ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ea7n tra c\u1ee9u:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8235b73 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8235b73\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-64f7031\" data-id=\"64f7031\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9c06bef elementor-widget elementor-widget-image\" data-id=\"9c06bef\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/loi-NA-do-khong-co-dinh-bang.png\" title=\"loi NA do khong co dinh bang\" alt=\"L\u1ed7i N\/A h\u00e0m vlookup do g\u1eb7p l\u1ed7i khi vi\u1ebft h\u00e0m, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm tr\u01b0\u1edbc khi copy c\u00f4ng th\u1ee9c h\u00e0ng lo\u1ea1t\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9203d28 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9203d28\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-416dc66\" data-id=\"416dc66\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5708f70 elementor-widget elementor-widget-text-editor\" data-id=\"5708f70\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A c\u1ef1c k\u00ec \u0111\u01a1n gi\u1ea3n, ch\u1ec9 c\u1ea7n F4 v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u1ea3i \u00f4 nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7e9440d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e9440d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d00c59f\" data-id=\"d00c59f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-716153b elementor-widget elementor-widget-image\" data-id=\"716153b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/sua-loi-NA-ham-vlookup-do-khong-F4-co-dinh-bang.png\" title=\"sua-loi-NA-ham-vlookup-do-khong-F4-co-dinh-bang\" alt=\"S\u1eeda L\u1ed7i N\/A h\u00e0m vlookup do g\u1eb7p l\u1ed7i khi vi\u1ebft h\u00e0m, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm tr\u01b0\u1edbc khi copy c\u00f4ng th\u1ee9c h\u00e0ng lo\u1ea1t\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8fd3a80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8fd3a80\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a6ef898\" data-id=\"a6ef898\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5f0a22e elementor-widget elementor-widget-text-editor\" data-id=\"5f0a22e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">nguy\u00ean nh\u00e2n, c\u00e1ch kh\u1eafc ph\u1ee5c v\u00e0 s\u1eeda l\u1ed7i N\/A th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"color: #333333; font-size: 11.5pt; white-space: pre-wrap; text-align: justify;\">Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng v\u00e0 v\u1eadn d\u1ee5ng t\u1ed1t trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel\/\" target=\"_blank\">H\u00e0m VLOOKUP<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m HLOOKUP<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\">H\u00e0m IF<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m AND<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m OR<\/span><\/p>\n<div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m VLOOKUP b\u1ea1n th\u01b0\u1eddng xuy\u00ean g\u1eb7p c\u00e1c l\u1ed7i trong excel, trong \u0111\u00f3 ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 l\u1ed7i N\/A. V\u1eady l\u1ed7i N\/A l\u00e0 g\u00ec, nguy\u00ean nh\u00e2n, c\u00e1ch kh\u1eafc ph\u1ee5c v\u00e0 s\u1eeda l\u1ed7i n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c hoctin.vn chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n trong b\u00e0i vi\u1ebft n\u00e0y. M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft 1. L\u1ed7i #N\/A &#8230; <a title=\"C\u00e1ch S\u1eeda L\u1ed7i #N\/A C\u1ee7a H\u00e0m VLOOKUP Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/cach-sua-loi-n-a-cua-ham-vlookup\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eeda L\u1ed7i #N\/A C\u1ee7a H\u00e0m VLOOKUP Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[11,18],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/325"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/465"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}