{"id":141,"date":"2020-07-09T23:37:10","date_gmt":"2020-07-09T16:37:10","guid":{"rendered":"https:\/\/hoctin.vn\/?p=141"},"modified":"2020-07-16T15:24:39","modified_gmt":"2020-07-16T08:24:39","slug":"vlookup-va-hlookup-ham-tim-kiem-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/vlookup-va-hlookup-ham-tim-kiem-trong-excel\/","title":{"rendered":"C\u00e1c V\u00ed D\u1ee5 V\u1ec1 H\u00e0m T\u00ecm Ki\u1ebfm Trong Excel: H\u00e0m VLOOKUP V\u00e0 HLOOKUP"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"141\" class=\"elementor elementor-141\">\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-3760178 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3760178\" 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-d04de0b\" data-id=\"d04de0b\" 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-b829ceb elementor-widget elementor-widget-text-editor\" data-id=\"b829ceb\" 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\u00e1c h\u00e0m t\u00ecm ki\u1ebfm trong Excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 h\u00e0m HLOOKUP v\u00e0 VLOOKUP c\u00f3 \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong vi\u1ec7c t\u00ecm d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3 t\u1eeb c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u theo chi\u1ec1u d\u1ecdc v\u00e0 ngang.<\/span><\/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;\">\u00a0<\/span><\/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;\">Ch\u1eef &#8220;V&#8221; trong VLOOKUP l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a vertical ngh\u0129a l\u00e0 \u201ctheo chi\u1ec1u d\u1ecdc\u201d, c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 tra c\u1ee9u c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u d\u1ecdc. N\u1ebfu b\u1ea1n c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u ngang, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m HLOOKUP- \u201cHorizontal\u201d c\u00f3 ngh\u0129a l\u00e0 t\u00ecm ki\u1ebfm theo chi\u1ec1u ngang, theo h\u00e0ng.<\/span><\/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;\">\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;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n hai h\u00e0m t\u00ecm ki\u1ebfm <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">trong Excel <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u0111\u1ec3 \u1ee9ng d\u1ee5ng t\u00ecm ki\u1ebfm t\u00ean, t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.<\/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-fd2097f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd2097f\" 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-feeccbc\" data-id=\"feeccbc\" 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-43ffee8 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"43ffee8\" 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<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\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-88143fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"88143fc\" 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-d469d1c\" data-id=\"d469d1c\" 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-9dfae78 elementor-widget elementor-widget-heading\" data-id=\"9dfae78\" 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=\"\" id=\"docs-internal-guid-672f8748-7fff-5e26-9d08-0066d0306a85\"><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;\">&nbsp;1. H\u00e0m VLOOKUP L\u00e0 G\u00ec?<\/span><\/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-4c37380 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c37380\" 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-caee823\" data-id=\"caee823\" 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-8fdb2e1 elementor-widget elementor-widget-text-editor\" data-id=\"8fdb2e1\" 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-7f23e4f9-7fff-cb75-9a24-e76162b0adf8\"><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;\">H\u00e0m VLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm, t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong khu v\u1ef1c c\u00e1c c\u1ed9t (t\u1ea1m g\u1ecdi l\u00e0 khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm) v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t c\u1ed9t do ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn t\u1eeb khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm, khi ti\u00eau th\u1ee9c t\u00ecm ki\u1ebfm kh\u1edbp v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm.<\/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-59a9ae3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"59a9ae3\" 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-d933e81\" data-id=\"d933e81\" 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-6ecf8fd elementor-widget elementor-widget-heading\" data-id=\"6ecf8fd\" 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-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.1, C\u00fa Ph\u00e1p H\u00e0m VLOOKUP<\/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-4e4ef59 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e4ef59\" 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-210321b\" data-id=\"210321b\" 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-c9446f4 elementor-widget elementor-widget-text-editor\" data-id=\"c9446f4\" 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;\">=<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">VLOOKUP<\/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;\">(<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Lookup_value, Table_array, Col_index_ num<\/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;\">, [Range_lookup])<\/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;\">Trong \u0111\u00f3:<\/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-8e7782c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8e7782c\" 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-406a440\" data-id=\"406a440\" 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-ea85ec4 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"ea85ec4\" 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><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;\">Lookup_value<\/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;\">: gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm, tra c\u1ee9u.<\/span><\/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 id=\"docs-internal-guid-57502c00-7fff-60fd-0011-9a9670fd75eb\"><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;\">Table_array<\/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;\">: n\u01a1i b\u1ea1n mu\u1ed1n t\u00ecm Lookup_value, t\u1ea1m g\u1ecdi l\u00e0 khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm.<\/span><\/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 id=\"docs-internal-guid-8db8f315-7fff-847f-cadd-c47947c2ecc0\"><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;\">Col_index_ num<\/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;\">: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong d\u1ea3i \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1 trong k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VLOOKUP.<\/span><\/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 id=\"docs-internal-guid-e073c836-7fff-a659-7c9a-3845ed60926e\"><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;\">[Range_lookup]<\/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;\">: ph\u1ea1m vi t\u00ecm ki\u1ebfm<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-777c8061-7fff-2c1e-a583-b20abd8ff6cf\"><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;\">N\u1ebfu Range_lookup = 1 ho\u1eb7c TRUE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p g\u1ea7n \u0111\u00fang n\u1ebfu c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a Table_array \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-57ee4e2f-7fff-6650-b649-d0974c34912d\"><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;\">N\u1ebfu Range_lookup =&nbsp; 0 ho\u1eb7c FALSE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd hi\u1ec7n l\u1ed7i N\/A.<\/span><\/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-652e0e5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"652e0e5\" 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-d1e70e5\" data-id=\"d1e70e5\" 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-12c80f4 elementor-widget elementor-widget-heading\" data-id=\"12c80f4\" 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-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.2, V\u00ed D\u1ee5 Minh H\u1ecda \u0110\u01a1n Gi\u1ea3n H\u00e0m T\u00ecm Ki\u1ebfm Trong Excel Theo Chi\u1ec1u Ngang<\/span><br><\/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-beeacfe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"beeacfe\" 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-0e7fd87\" data-id=\"0e7fd87\" 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-0446936 elementor-widget elementor-widget-text-editor\" data-id=\"0446936\" 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;\">V\u00ed d\u1ee5 t\u00ecm ki\u1ebfm Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u v\u00e0 % hoa h\u1ed3ng theo b\u1ea3ng excel quy \u01b0\u1edbc c\u1ee7a h\u1ee3p \u0111\u1ed3ng b\u1ea3o hi\u1ec3m t\u1eeb t\u00ean h\u1ee3p \u0111\u1ed3ng ho\u1eb7c t\u00ean kh\u00e1ch h\u00e0ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng quy \u01b0\u1edbc n\u00e0y c\u00f3 c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u d\u1ea1ng c\u1ed9t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Khi s\u1eed d\u1ee5ng VLOOKUP, h\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng r\u1eb1ng m\u1ecdi c\u1ed9t trong b\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1, b\u1eaft \u0111\u1ea7u t\u1eeb b\u00ean tr\u00e1i. \u0110\u1ec3 nh\u1eadn gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3, h\u00e3y cung c\u1ea5p s\u1ed1 th\u00edch h\u1ee3p l\u00e0m <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Col_index_ num<\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">: \u201cs\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t&#8221;. V\u00ed d\u1ee5:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">\u0110\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u th\u00ec <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Col_index_ num<\/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;\"> d\u01b0\u1edbi \u0111\u00e2y l\u00e0 2<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"background-color: transparent; font-size: 11pt; white-space: pre-wrap; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 % hoa h\u1ed3ng th\u00ec <\/span><span style=\"background-color: transparent; font-size: 11pt; white-space: pre-wrap; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Col_index_ num<\/span><span style=\"background-color: transparent; font-size: 11pt; white-space: pre-wrap; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> d\u01b0\u1edbi \u0111\u00e2y l\u00e0 3 <\/span><\/p><\/li><\/ul>\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-ca5bf1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ca5bf1b\" 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-382dd38\" data-id=\"382dd38\" 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-b711508 elementor-widget elementor-widget-image\" data-id=\"b711508\" 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\/elementor\/thumbs\/Vi-du-ham-vlookup-7-oscx26ssqnrwl5kgttkk3amqijixzdlsqz39iig5ak.png\" title=\"Vi-du-ham-tim-kiem-trong-excel-vlookup\" alt=\"V\u00ed d\u1ee5 h\u00e0m t\u00ecm ki\u1ebfm trong Excel 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-4be3509 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4be3509\" 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-b5414d6\" data-id=\"b5414d6\" 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-2ec8a9a elementor-widget elementor-widget-text-editor\" data-id=\"2ec8a9a\" 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-a01aa016-7fff-37cc-112b-69e0c854433c\"><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;\">Trong v\u00ed d\u1ee5 tr\u00ean:<\/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-ae88e46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae88e46\" 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-28e1275\" data-id=\"28e1275\" 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-b819827 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b819827\" 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><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;\">T\u1ea1i \u00f4 D10, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><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;\">Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u<\/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\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 lo\u1ea1i <\/span><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;\">S\u1ea3n ph\u1ea9m<\/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;\"> t\u1ea1i \u00f4 B10, g\u00f5 c\u00f4ng th\u1ee9c <\/span><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;\">=VLOOKUP($B10,$B$3:$D$5,2,0)<\/span><\/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><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;\">T\u1ea1i \u00f4 E10, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><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;\">% hoa h\u1ed3ng <\/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\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 lo\u1ea1i <\/span><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;\">S\u1ea3n ph\u1ea9m<\/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;\"> t\u1ea1i \u00f4 B10, g\u00f5 c\u00f4ng th\u1ee9c <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">=VLOOKUP($B10,$B$3:$D$5,3,0)<\/span><\/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 id=\"docs-internal-guid-a9a385d2-7fff-7e10-d0a1-935f8c8f3398\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa 2 \u00f4 c\u00f9ng d\u00f2ng n\u00e0y l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t <\/span><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;\">Col_index_ num <\/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;\">\u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u1ea1i 2 c\u1ed9t kh\u00e1c nhau t\u1eeb v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm <\/span><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;\">Table_array<\/span><\/span><br><br>Trong \u0111\u00f3:<\/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-check\"><\/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 id=\"docs-internal-guid-1f57e76f-7fff-2be1-cc6c-1186b83e14fe\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">VLOOKUP<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c th\u00f4ng tin c\u1ee7a h\u1ee3p \u0111\u1ed3ng <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">theo S\u1ea3n ph\u1ea9m <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u d\u1ea1ng c\u1ed9t trong Excel<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-aee073b9-7fff-d07d-e81c-3e74d582f99f\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">B10:<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> C\u01a1 s\u1edf d\u00f2 t\u00ecm d\u1ef1a tr\u00ean lo\u1ea1i <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">S\u1ea3n ph\u1ea9m <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">c\u1ee7a h\u1ee3p \u0111\u1ed3ng l\u00e0 SP03, \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel b\u1eb1ng c\u00e1ch \u1ea5n 3 l\u1ea7n ph\u00edm F4.<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-85a43435-7fff-e877-c4fc-9f3af41c3cdd\"><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;\">$B$3:$D$5<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: B\u1ea3ng m\u00e0u xanh da tr\u1eddi nh\u1ea1t th\u1ec3 hi\u1ec7n gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm, \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong excel b\u1eb1ng 1 l\u1ea7n \u1ea5n F4<\/span><\/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-check\"><\/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><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, 3<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: Th\u1ee9 t\u1ef1 c\u1ed9t gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y, l\u1ea7n l\u01b0\u1ee3t l\u00e0 c\u1ed9t <\/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;\">Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> v\u00e0 % hoa h\u1ed3ng<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-ede57a6a-7fff-8fd8-a7b9-90b5c6a547f1\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">0<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: Khi \u0111\u1ed1i s\u1ed1 range_lookup l\u00e0 0 (FALSE), n\u1ebfu h\u00e0m vlookup kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb SP03 trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm (c\u1ed9t S\u1ea3n ph\u1ea9m), n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t l\u1ed7i #N\/A (Not available- Kh\u00f4ng c\u00f3 s\u1ed1 li\u1ec7u)<\/span><\/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-d668426 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d668426\" 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-fcbfbaa\" data-id=\"fcbfbaa\" 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-5d9eeae elementor-widget elementor-widget-text-editor\" data-id=\"5d9eeae\" 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-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000; font-family: Arial;\"><span style=\"font-size: 14.6667px; white-space: pre-wrap;\"><i>T\u00ecm \u0111\u1ecdc th\u00eam v\u1ec1:<\/i><\/span><\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel-va-vi-du-cu-the\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-family: Arial;\"><span style=\"font-size: 14.6667px; white-space: pre-wrap;\"><i>C\u00e1ch s\u1eed d\u1ee5ng <span style=\"color: #3366ff;\"><b>h\u00e0m VLOOKUP<\/b><\/span> trong Excel v\u00e0 <span style=\"color: #3366ff;\"><b>v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/b><\/span><\/i><\/span><\/span><\/a><\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000; font-family: Arial;\"><span style=\"font-size: 14.6667px; white-space: pre-wrap;\"><i>C\u00e1ch <\/i><a href=\"https:\/\/hoctin.vn\/cach-sua-loi-n-a-cua-ham-vlookup-trong-excel\/\"><span style=\"color: #3366ff;\"><em><strong>s\u1eeda l\u1ed7i #N\/A <\/strong><\/em><\/span><\/a><\/span><\/span><span style=\"color: #000000; font-family: Arial;\"><span style=\"font-size: 14.6667px; white-space: pre-wrap;\"><i>trong Excel<\/i><\/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-fc112ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fc112ab\" 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-58d0f3f\" data-id=\"58d0f3f\" 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-527d53e elementor-widget elementor-widget-heading\" data-id=\"527d53e\" 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. H\u00e0m HLOOKUP T\u00ecm Ki\u1ebfm Trong Excel<\/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-ed05e3c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ed05e3c\" 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-d236a4d\" data-id=\"d236a4d\" 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-c5fd2ff elementor-widget elementor-widget-text-editor\" data-id=\"c5fd2ff\" 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;\">T\u01b0\u01a1ng t\u1ef1 H\u00e0m VLOOKUP: HLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm theo h\u00e0ng, d\u00f2 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb tr\u00ean d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t \u00f4 trong m\u1ed9t h\u00e0ng c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm do ng\u01b0\u1eddi d\u00f9ng quy \u0111\u1ecbnh.<\/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;\">\u0110i\u1ec3m kh\u00e1c bi\u1ec7t duy nh\u1ea5t gi\u1eefa hai l\u00e0m v\u00e0 b\u1ea3ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm s\u1eafp x\u1ebfp tr\u01b0\u1eddng d\u1eef li\u1ec7u theo d\u1ea1ng c\u1ed9t hay h\u00e0ng.<\/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-fbdd27d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fbdd27d\" 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-9cd8e34\" data-id=\"9cd8e34\" 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-7fe5763 elementor-widget elementor-widget-heading\" data-id=\"7fe5763\" 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-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.1, C\u00fa Ph\u00e1p H\u00e0m HLOOKUP<\/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-a879a5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a879a5d\" 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-f84f33f\" data-id=\"f84f33f\" 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-59d6de1 elementor-widget elementor-widget-text-editor\" data-id=\"59d6de1\" 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: #444444; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=HLOOKUP(Lookup_value,Table_ array,Row_index_Num,Range_lookup)<\/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;\">Trong \u0111\u00f3:<\/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-532c2de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"532c2de\" 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-1d77a42\" data-id=\"1d77a42\" 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-501e203 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"501e203\" 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><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;\">Lookup_value<\/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;\">: gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm, tra c\u1ee9u<\/span><\/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><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;\">Table_array<\/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;\">: B\u1ea3ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u- n\u01a1i b\u1ea1n mu\u1ed1n t\u00ecm Lookup_value, t\u1ea1m g\u1ecdi l\u00e0 khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm<\/span><\/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><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;\">Row_index_ num<\/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;\">: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u<\/span><\/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 id=\"docs-internal-guid-929dd852-7fff-577b-95b8-f72830d9f5e3\"><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;\">[Range_lookup]<\/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;\">: ph\u1ea1m vi t\u00ecm ki\u1ebfm<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-dd2d4171-7fff-b2c0-6387-928210a6a905\"><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;\">N\u1ebfu Range_lookup = 1 ho\u1eb7c TRUE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p g\u1ea7n \u0111\u00fang n\u1ebfu d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a Table_array \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-58cef42b-7fff-dd55-864e-358146eff131\"><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;\">N\u1ebfu Range_lookup =&nbsp; 0 ho\u1eb7c FALSE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd hi\u1ec7n l\u1ed7i N\/A.<\/span><\/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-150d22e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"150d22e\" 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-1c35a75\" data-id=\"1c35a75\" 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-970a8d3 elementor-widget elementor-widget-heading\" data-id=\"970a8d3\" 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-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2, V\u00ed D\u1ee5 Minh H\u1ecda \u0110\u01a1n Gi\u1ea3n H\u00e0m HLOOKUP- H\u00e0m T\u00ecm Ki\u1ebfm Trong Excel Theo Chi\u1ec1u D\u1ecdc<\/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-5e763fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e763fa\" 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-fbab026\" data-id=\"fbab026\" 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-f3c24ca elementor-widget elementor-widget-heading\" data-id=\"f3c24ca\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(67, 67, 67); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2.1, V\u00ed D\u1ee5 H\u00e0m HLOOKUP Trong B\u00e0i T\u1eadp Excel C\u01a1 B\u1ea3n<\/span><h3 dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:16pt;margin-bottom:4pt;\"><\/h3><\/h4>\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-bf2e0e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf2e0e4\" 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-33c5084\" data-id=\"33c5084\" 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-aa7e424 elementor-widget elementor-widget-text-editor\" data-id=\"aa7e424\" 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;\">V\u00ed d\u1ee5 1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u v\u00e0 % hoa h\u1ed3ng theo b\u1ea3ng excel quy \u01b0\u1edbc c\u1ee7a h\u1ee3p \u0111\u1ed3ng b\u1ea3o hi\u1ec3m t\u1eeb t\u00ean h\u1ee3p \u0111\u1ed3ng ho\u1eb7c t\u00ean kh\u00e1ch h\u00e0ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng quy \u01b0\u1edbc n\u00e0y c\u00f3 c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u d\u1ea1ng h\u00e0ng.<\/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;\">D\u1eef li\u1ec7u n\u00e0y y h\u1ec7t d\u1eef li\u1ec7u cho v\u00ed d\u1ee5 h\u00e0m VLOOKUP \u1edf tr\u00ean, \u0111i\u1ec3m kh\u00e1c bi\u1ec7t l\u00e0 c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u quy \u01b0\u1edbc % hoa h\u1ed3ng v\u00e0 gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u c\u1ee7a s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo h\u00e0ng.<\/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-8baf102 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8baf102\" 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-6c0a5c9\" data-id=\"6c0a5c9\" 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-2497a18 elementor-widget elementor-widget-image\" data-id=\"2497a18\" 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\/vi-du-ham-hlookup-1.png\" title=\"vi-du-ham-hlookup\" alt=\"V\u00ed d\u1ee5 h\u00e0m t\u00ecm ki\u1ebfm trong Excel h\u00e0m HLOOKUP\" \/>\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-e6581e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e6581e0\" 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-d6fd674\" data-id=\"d6fd674\" 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-4b35faf elementor-widget elementor-widget-text-editor\" data-id=\"4b35faf\" 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-7f4ab692-7fff-e590-fdcb-10fd87c62b82\"><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;\">Trong v\u00ed d\u1ee5 tr\u00ean:<\/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-8ebfbe2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ebfbe2\" 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-8b9e6a9\" data-id=\"8b9e6a9\" 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-531878a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"531878a\" 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 id=\"docs-internal-guid-75ebaa16-7fff-aa01-0e2a-8ccb006124a6\"><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;\">T\u1ea1i \u00f4 D8, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><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;\">Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u<\/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\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 lo\u1ea1i <\/span><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;\">S\u1ea3n ph\u1ea9m<\/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;\"> t\u1ea1i \u00f4 B8, g\u00f5 c\u00f4ng th\u1ee9c <\/span><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;\">=HLOOKUP($B8,$B$2:$D$4,3,0)<\/span><\/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><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;\">T\u1ea1i \u00f4 E8, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><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;\">% hoa h\u1ed3ng <\/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\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 lo\u1ea1i <\/span><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;\">S\u1ea3n ph\u1ea9m<\/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;\"> t\u1ea1i \u00f4 B8, g\u00f5 c\u00f4ng th\u1ee9c =<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">HLOOKUP($B8,$B$2:$D$4,2,0)<\/span><\/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><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa 2 \u00f4 c\u00f9ng d\u00f2ng n\u00e0y l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng <\/span><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;\">Row_index_ num <\/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;\">\u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u1ea1i 2 c\u1ed9t kh\u00e1c nhau t\u1eeb v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm <\/span><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;\">Table_array.<\/span><\/span><br><span id=\"docs-internal-guid-f8dcc98e-7fff-9d28-3011-56bc39b89202\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>Trong \u0111\u00f3:<\/span><\/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-check\"><\/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=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; vertical-align: baseline;\">HLOOKUP<\/span><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-size: 11.5pt; color: rgb(68, 68, 68); vertical-align: baseline;\">: l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c th\u00f4ng tin c\u1ee7a h\u1ee3p \u0111\u1ed3ng <\/span><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; vertical-align: baseline;\">theo S\u1ea3n ph\u1ea9m <\/span><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-size: 11.5pt; color: rgb(68, 68, 68); vertical-align: baseline;\">t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u d\u1ea1ng h\u00e0ng trong Excel<\/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-check\"><\/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 id=\"docs-internal-guid-522668da-7fff-45a8-ee32-878c2c98d5c4\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">B8:<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> C\u01a1 s\u1edf d\u00f2 t\u00ecm d\u1ef1a tr\u00ean lo\u1ea1i <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">S\u1ea3n ph\u1ea9m <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">c\u1ee7a h\u1ee3p \u0111\u1ed3ng l\u00e0 SP03, \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel b\u1eb1ng c\u00e1ch \u1ea5n 3 l\u1ea7n ph\u00edm F4.<\/span><\/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-check\"><\/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><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;\">$B$2:$D$4<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: B\u1ea3ng m\u00e0u xanh da tr\u1eddi nh\u1ea1t th\u1ec3 hi\u1ec7n gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm, \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong excel b\u1eb1ng 1 l\u1ea7n \u1ea5n F4.<\/span><\/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-check\"><\/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><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, 3<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: Th\u1ee9 t\u1ef1 c\u1ed9t gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y, l\u1ea7n l\u01b0\u1ee3t l\u00e0 h\u00e0ng % hoa h\u1ed3ng v\u00e0 <\/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;\">Gi\u00e1 tr\u1ecb h\u1ee3p \u0111\u1ed3ng t\u1ed1i thi\u1ec3u<\/span><\/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-check\"><\/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 id=\"docs-internal-guid-e9b3a6aa-7fff-0d37-74e7-68cd8aca9adc\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">0<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: Khi \u0111\u1ed1i s\u1ed1 range_lookup l\u00e0 0 (FALSE), n\u1ebfu h\u00e0m vlookup kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb SP03 trong h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm (h\u00e0ng S\u1ea3n ph\u1ea9m), n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t l\u1ed7i #N\/A (Not available- Kh\u00f4ng c\u00f3 s\u1ed1 li\u1ec7u).<\/span><\/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-9dbfc4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9dbfc4f\" 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-e40e972\" data-id=\"e40e972\" 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-76ebb41 elementor-widget elementor-widget-heading\" data-id=\"76ebb41\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(67, 67, 67); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2.2, V\u00ed D\u1ee5 H\u00e0m HLOOKUP Khi K\u1ebft H\u1ee3p H\u00e0m Excel Kh\u00e1c<\/span><\/h4>\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-0963d33 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0963d33\" 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-e0b1fb3\" data-id=\"e0b1fb3\" 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-6249cf1 elementor-widget elementor-widget-text-editor\" data-id=\"6249cf1\" 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: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m HLOOKUP c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m if k\u1ebft h\u1ee3p vlookup<\/span><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><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: #444444; background-color: #ffffff; 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; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 c\u00e1ch d\u00f9ng h\u00e0m t\u00ecm ki\u1ebfm trong Excel HLOOKUP k\u1ebft h\u1ee3p h\u00e0m if: v\u1eabn l\u00e0 b\u1ed9 d\u1eef li\u1ec7u nh\u01b0 v\u00ed d\u1ee5 h\u00e0m HLOOKUP tr\u00ean, th\u00eam tr\u01b0\u1eddng d\u1eef li\u1ec7u N\u0103m c\u1ee7a h\u1ee3p \u0111\u1ed3ng: t\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i, m\u1ee9c % hoa h\u1ed3ng theo t\u1eebng s\u1ea3n ph\u1ea9m b\u1ea3o hi\u1ec3m th\u1ea5p h\u01a1n n\u0103m \u0111\u1ea7u ti\u00ean.\u00a0<\/span><\/p><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: #444444; background-color: #ffffff; 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; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Do \u0111\u00f3 v\u1edbi m\u1ed7i h\u1ee3p \u0111\u1ed3ng b\u1ea3o hi\u1ec3m, \u0111\u1ea1i l\u00fd ph\u1ea3i ki\u1ec3m tra xem h\u1ee3p \u0111\u1ed3ng l\u00e0 n\u0103m \u0111\u1ea7u ti\u00ean hay n\u0103m th\u1ee9 hai tr\u1edf \u0111i \u0111\u1ec3 t\u00ecm m\u1ee9c % hoa h\u1ed3ng ph\u00f9 h\u1ee3p theo s\u1ea3n ph\u1ea9m.<\/span><\/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;\">\u00a0<\/span><\/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;\">Hoctin.vn \u0111\u00e3 x\u1eed l\u00fd th\u00f4ng tin n\u00e0y b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m HLOOKUP (t\u00ecm ki\u1ebfm % hoa h\u1ed3ng c\u1ee7a s\u1ea3n ph\u1ea9m) v\u00e0 h\u00e0m IF:<\/span><\/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;\">&#8211; N\u1ebfu H\u1ee3p \u0111\u1ed3ng k\u00fd n\u0103m th\u1ee9 nh\u1ea5t th\u00ec h\u00e0m HLOOKUP tr\u1ea3 v\u1ec1 d\u00f2ng <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">% hoa h\u1ed3ng n\u0103m th\u1ee9 1<\/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;\"> c\u00f3 Row_index_ num (s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng) l\u00e0 2<\/span><\/p><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;\">&#8211; N\u1ebfu kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 d\u00f2ng <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">% hoa h\u1ed3ng t\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i<\/span><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;\"> th\u00ec s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng l\u00e0 3 nh\u01b0 \u1ea3nh 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-d093c2b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d093c2b\" 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-e27acc0\" data-id=\"e27acc0\" 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-c930f9f elementor-widget elementor-widget-image\" data-id=\"c930f9f\" 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\/ham-hlookup-ket-hop-if-1.png\" title=\"ham-tim-kiem-trong-excel-hlookup-ket-hop-if\" alt=\"V\u00ed d\u1ee5 h\u00e0m t\u00ecm ki\u1ebfm trong excel HLOOKUP khi k\u1ebft h\u1ee3p h\u00e0m excel kh\u00e1c\" \/>\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-8743d7a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8743d7a\" 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-538ed83\" data-id=\"538ed83\" 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-13d8138 elementor-widget elementor-widget-text-editor\" data-id=\"13d8138\" 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;\">Trong v\u00ed d\u1ee5 tr\u00ean: <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">T\u1ea1i \u00f4 E9, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">% hoa h\u1ed3ng <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">c\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1ea3n ph\u1ea9m <\/span><span style=\"background-color: transparent; font-size: 11pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">t\u1ea1i \u00f4 B9, g\u00f5 c\u00f4ng th\u1ee9c <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; font-weight: bold; text-align: justify; white-space: pre-wrap;\">=IF(B9=1,HLOOKUP($C9,$C$2:$E$5,2,0),HLOOKUP($C9,$C$2:$E$5,3,0))<\/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-6dc6ce5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6dc6ce5\" 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-0e4e18e\" data-id=\"0e4e18e\" 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-d9e151c elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d9e151c\" 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><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m IF:<\/span><\/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-check\"><\/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><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu \u201cH\u0110 n\u0103m th\u1ee9\u201d B9=1 th\u00ec tr\u1ea3 v\u1ec1 h\u00e0m HLOOKUP($C9,$C$2:$E$5,2,0) <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">- <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">k\u1ebft qu\u1ea3 h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 h\u00e0ng s\u1ed1 2 c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm l\u00e0 h\u00e0ng % hoa h\u1ed3ng n\u0103m th\u1ee9 1<\/span><\/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-check\"><\/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><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 h\u00e0m HLOOKUP($C9,$C$2:$E$5,3,0)- k\u1ebft qu\u1ea3 h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 h\u00e0ng s\u1ed1 3 c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm l\u00e0 h\u00e0ng % hoa h\u1ed3ng t\u1eeb n\u0103m th\u1ee9 2 tr\u1edf \u0111i<\/span><\/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 id=\"docs-internal-guid-6dc2dfc8-7fff-7659-35ca-14b22b9fe67f\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m HLOOKUP: D\u00f2 t\u00ecm % hoa h\u1ed3ng c\u1ee7a lo\u1ea1i s\u1ea3n ph\u1ea9m. V\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array l\u00e0 $C$2:$E$5, Row_index_ num ph\u1ee5 thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 h\u00e0m IF \u1edf tr\u00ean.<\/span><\/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-c963aea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c963aea\" 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-ef4993f\" data-id=\"ef4993f\" 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-13db9e6 elementor-widget elementor-widget-text-editor\" data-id=\"13db9e6\" 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 v\u00ed d\u1ee5 b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m t\u00ecm ki\u1ebfm trong Excel- h\u00e0m VLOOKUP<\/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;\"> v\u00e0 HLOOKUP.<\/span><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;\"> Ch\u00fac c\u00e1c \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><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><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 IF<\/span><\/p><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;\"><strong><em><span style=\"color: #3366ff;\"><a style=\"background-color: #ffffff; font-family: Roboto, sans-serif; font-size: 17px; text-align: start; white-space: normal; color: #3366ff;\" href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-if-ket-hop-vlookup-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP<\/a><\/span><\/em><\/strong><br \/><\/span><\/p><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><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><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;\">\u00a0<\/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>C\u00e1c h\u00e0m t\u00ecm ki\u1ebfm trong Excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 h\u00e0m HLOOKUP v\u00e0 VLOOKUP c\u00f3 \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong vi\u1ec7c t\u00ecm d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3 t\u1eeb c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u theo chi\u1ec1u d\u1ecdc v\u00e0 ngang. Ch\u1eef &#8220;V&#8221; trong VLOOKUP l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a vertical ngh\u0129a l\u00e0 \u201ctheo chi\u1ec1u d\u1ecdc\u201d, c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng &#8230; <a title=\"C\u00e1c V\u00ed D\u1ee5 V\u1ec1 H\u00e0m T\u00ecm Ki\u1ebfm Trong Excel: H\u00e0m VLOOKUP V\u00e0 HLOOKUP\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/vlookup-va-hlookup-ham-tim-kiem-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1c V\u00ed D\u1ee5 V\u1ec1 H\u00e0m T\u00ecm Ki\u1ebfm Trong Excel: H\u00e0m VLOOKUP V\u00e0 HLOOKUP<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[23,27,11],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/141"}],"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=141"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/472"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}