{"id":23,"date":"2020-07-09T14:56:52","date_gmt":"2020-07-09T07:56:52","guid":{"rendered":"https:\/\/hoctin.vn\/?p=23"},"modified":"2020-09-24T13:52:23","modified_gmt":"2020-09-24T06:52:23","slug":"cach-su-dung-ham-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m VLOOKUP Trong Excel v\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"23\" class=\"elementor elementor-23\">\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-d69a35e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d69a35e\" 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-1725b4a\" data-id=\"1725b4a\" 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-285d5fd elementor-widget elementor-widget-text-editor\" data-id=\"285d5fd\" 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 style=\"text-align: justify;\"><span style=\"color: #000000;\">H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong excel nh\u01b0ng nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f2n th\u1ea5y kh\u00f3 hi\u1ec3u v\u1ec1 n\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ecm ki\u1ebfm VLOOKUP trong excel, c\u00e1ch ph\u00e2n bi\u1ec7t \u0111\u01a1n gi\u1ea3n khi n\u00e0o d\u00f9ng h\u00e0m VLOOKUP khi n\u00e0o d\u00f9ng h\u00e0m hlookup c\u00f9ng c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m VLOOKUP.<\/span><\/p><p style=\"text-align: justify;\"><span style=\"color: rgb(0, 0, 0);\">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><\/p><p style=\"text-align: justify;\"><span style=\"color: rgb(0, 0, 0);\">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, c\u1ea7n ph\u00e2n bi\u1ec7t v\u1edbi h\u00e0m HLOOKUP l\u00e0 \u201cHorizontal\u201d- t\u00ecm ki\u1ebfm theo chi\u1ec1u ngang, 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-3fb0020 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3fb0020\" 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-06d9942\" data-id=\"06d9942\" 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-802fa97 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"802fa97\" 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<h2 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h2>\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-5c29168 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c29168\" 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-b0ffaa3\" data-id=\"b0ffaa3\" 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-9653b0f elementor-widget elementor-widget-heading\" data-id=\"9653b0f\" 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\"><h2 data-elementor-setting-key=\"title\" data-pen-placeholder=\"G\u00f5 v\u00e0o \u0111\u00e2y...\" style=\"font-style: normal;\"><b><span><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00fa Ph\u00e1p H\u00e0m VLOOKUP Trong Excel<\/span><\/span><\/b><\/h2><\/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-45afc87 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45afc87\" 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-acb3a04\" data-id=\"acb3a04\" 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-49b2fd4 elementor-widget elementor-widget-text-editor\" data-id=\"49b2fd4\" 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-weight: 400; color: #000000;\">L\u1ec7nh VLOOKUP c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">=<\/span><b>VLOOKUP<\/b><span style=\"font-weight: 400;\">(<\/span><b>Lookup_value, Table_array, Col_index_ num<\/b><span style=\"font-weight: 400;\">, [Range_lookup])<\/span><\/span><\/p>\n<p><span style=\"font-weight: 400; color: #000000;\">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<div class=\"elementor-element elementor-element-34611c5 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"34611c5\" 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><br><span id=\"docs-internal-guid-fa0405e0-7fff-9f57-a407-4da4f03574ac\"><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 c\u1ea7n copy c\u00f4ng th\u1ee9c vlookup cho nhi\u1ec1u c\u1ed9t m\u00e0 kh\u00f4ng c\u1ea7n g\u00f5 \u0111i g\u00f5 l\u1ea1i c\u00f4ng th\u1ee9c, c\u1ea7n \u1ea5n F4 ba l\u1ea7n \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel (A1 &gt; $A1) nh\u1eb1m copy c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng, khi \u0111\u00f3 b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eeda col_index_num.<\/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;\">: 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><br><span style=\"background-color: transparent; font-size: 11pt; text-align: justify; color: rgb(0, 0, 0); font-family: Arial;\">Gi\u00e1 tr\u1ecb tra c\u1ee9u ph\u1ea3i lu\u00f4n n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i \u0111\u1ec3 h\u00e0m VLOOKUP c\u00f3 th\u1ec3 ra k\u1ebft qu\u1ea3 m\u00e0 kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i N\/A.<\/span><br><span style=\"background-color: transparent; font-size: 11pt; text-align: justify; color: rgb(0, 0, 0); font-family: Arial;\">C\u1ea7n \u1ea5n F4 m\u1ed9t l\u1ea7n \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm trong excel nh\u1eb1m copy c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng (A1:E10 &gt; $A$1:$E$10)<\/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\"><div style=\"text-align: left;\"><span style=\"background-color: transparent; text-align: justify; font-size: 14.6667px;\"><font color=\"#000000\" face=\"Arial\"><b>Col_index_ num:<\/b> 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.<\/font><\/span><\/div><span style=\"background-color: transparent; text-align: justify;\"><div style=\"text-align: left;\"><span style=\"background-color: transparent; font-size: 14.6667px;\"><font color=\"#000000\" face=\"Arial\">Khi s\u1eed d\u1ee5ng h\u00e0m 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: V\u00ed d\u1ee5 n\u1ebfu ph\u1ea1m vi khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm l\u00e0 A2:C10 v\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u1edbp c\u1ed9t A th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u00f4 t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t C, th\u00ec th\u1ee9 t\u1ef1 \u0111\u1ebfm c\u1ed9t A l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean, B l\u00e0 th\u1ee9 hai, C l\u00e0 th\u1ee9 ba n\u00ean Col_index_num b\u1eb1ng 3.<\/font><\/span><\/div><\/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\"><div style=\"text-align: left;\"><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;\">[Range_lookup]: ph\u1ea1m vi t\u00ecm ki\u1ebfm<\/span><br><span style=\"background-color: transparent; font-size: 11pt; text-align: justify; color: rgb(0, 0, 0); font-family: Arial;\">N\u1ebfu Range_lookup = 1 ho\u1eb7c TRUE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p g\u1ea7n \u0111\u00fang<\/span><br><span style=\"background-color: transparent; font-size: 11pt; text-align: justify; color: rgb(0, 0, 0); font-family: Arial;\">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><\/div><\/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\"><div style=\"text-align: left;\"><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;\">C\u00e1c tham s\u1ed1 in \u0111\u1eadm l\u00e0 b\u1eaft bu\u1ed9c<\/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;\">, [Range_lookup] n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp s\u1ebd \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh l\u00e0 1 ho\u1eb7c TRUE l\u00e0 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><br><\/div><\/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-a3a3461 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3a3461\" 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-0c3330f\" data-id=\"0c3330f\" 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-e300d69 elementor-widget elementor-widget-heading\" data-id=\"e300d69\" 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, V\u00ed D\u1ee5 Minh H\u1ecda \u0110\u01a1n Gi\u1ea3n C\u00e1ch D\u00f9ng H\u00e0m VLOOKUP 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-97399cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"97399cf\" 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-d85aed5\" data-id=\"d85aed5\" 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-785f106 elementor-widget elementor-widget-heading\" data-id=\"785f106\" 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, V\u00ed D\u1ee5 C\u00f4ng Th\u1ee9c VLOOKUP K\u1ebft Qu\u1ea3 Kh\u1edbp Ch\u00ednh X\u00e1c (0\/FALSE)<\/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-d8c8def elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8c8def\" 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-b01d082\" data-id=\"b01d082\" 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-e2b7031 elementor-widget elementor-widget-text-editor\" data-id=\"e2b7031\" 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 c\u00e1ch t\u00ecm t\u00ean trong excel\u00a0 th\u00f4ng qua h\u00e0m VLOOKUP d\u1ef1a tr\u00ean ID c\u1ee7a nh\u00e2n vi\u00ean.\u00a0<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-771d9272-7fff-e0bf-1d2d-2111a50dc31c\" style=\"font-weight: normal;\">\u00a0<\/b><\/p>\n<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;\">Nh\u01b0 b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m vlookup ch\u1ec9 c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n t\u00ecm H\u1ecd t\u00ean v\u00e0 Ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean th\u00f4ng qua ID c\u1ee7a h\u1ecd, b\u1ea1n lu\u00f4n ph\u1ea3i s\u1eafp x\u1ebfp d\u1eef li\u1ec7u sao cho gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tra c\u1ee9u (ID) n\u1eb1m \u1edf <\/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;\">b\u00ean tr\u00e1i<\/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;\"> gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 (H\u1ecd t\u00ean, ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c).<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p>\n<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;\">H\u00e0m VLOOKUP c\u00f3 h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 khi s\u1eed d\u1ee5ng l\u00e0 n\u00f3 <\/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;\">kh\u00f4ng th\u1ec3 d\u00f2 t\u00ecm ph\u00eda b\u00ean tr\u00e1i c\u1ed9t tra c\u1ee9u<\/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;\">. Do \u0111\u00f3, c\u1ea7n di chuy\u1ec3n d\u1eef li\u1ec7u B\u1ed9 ph\u1eadn v\u00e0 V\u1ecb tr\u00ed sang c\u1ed9t F, G \u0111\u1ec3 c\u00f3 th\u1ec3 tra c\u1ee9u th\u00f4ng qua ID ho\u1eb7c d\u00f9ng h\u00e0m t\u00ecm ki\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel qua vi\u1ec7c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Index v\u00e0 Match.<\/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-c3a6486 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3a6486\" 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-6a2e988\" data-id=\"6a2e988\" 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-e830188 elementor-widget elementor-widget-image\" data-id=\"e830188\" 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-5-oscpm8x0logyq6mbfd3ilmuf6gjdgaw00pbjv8zm12.png\" title=\"vi-du-ham-VLOOKUP\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong excel v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3\" \/>\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-a729d92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a729d92\" 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-3ae4b84\" data-id=\"3ae4b84\" 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-6bd6dbe elementor-widget elementor-widget-text-editor\" data-id=\"6bd6dbe\" 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><\/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<div class=\"elementor-element elementor-element-949ddf5 elementor-icon-list--layout-inline elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"949ddf5\" 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 elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-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 D16, \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;\">H\u1ecd t\u00ean<\/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 ID t\u1ea1i \u00f4 D15, 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(D15,C2:E10,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 elementor-inline-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 D17, \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;\">Ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c<\/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 ID t\u1ea1i \u00f4 D15, 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(D15,C2:E10,3,0)<\/span><\/span><br><br><span style=\"color: rgb(68, 68, 68); font-size: 15.3333px;\">Trong \u0111\u00f3:<\/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 elementor-inline-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;\">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 nh\u00e2n vi\u00ean t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u theo ID c\u1ee7a h\u1ecd<\/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 elementor-inline-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;\">D15:<\/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 ID c\u1ee7a nh\u00e2n vi\u00ean V00038<\/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 elementor-inline-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-5a13bcc6-7fff-a597-054e-1f5a4fc52b30\"><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;\">C2:E10<\/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<\/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 elementor-inline-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 H\u1ecd t\u00ean v\u00e0 Ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c<\/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 elementor-inline-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-ee669922-7fff-07c8-6b6a-64381cac84e9\"><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 V00038 trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm (c\u1ed9t ID), 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-fb13cff elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb13cff\" 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-6c0bdf8\" data-id=\"6c0bdf8\" 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-d06fc08 elementor-widget elementor-widget-heading\" data-id=\"d06fc08\" 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=\"\" id=\"docs-internal-guid-3bad64ff-7fff-5ef1-e713-b7b9594eb846\"><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 C\u00f4ng Th\u1ee9c VLOOKUP K\u1ebft Qu\u1ea3 Kh\u1edbp T\u01b0\u01a1ng \u0110\u1ed1i (1\/TRUE)<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f76cf1a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f76cf1a\" 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-b4ed4d1\" data-id=\"b4ed4d1\" 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-9ab6b5b elementor-widget elementor-widget-text-editor\" data-id=\"9ab6b5b\" 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 c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm x\u1ebfp lo\u1ea1i h\u1ecdc sinh, sinh vi\u00ean v\u00e0 nh\u1eadp d\u1eef li\u1ec7u x\u1ebfp lo\u1ea1i n\u00e0y v\u00e0o c\u1ed9t C khi \u0111\u00e3 c\u00f3 c\u00e1c th\u00f4ng tin sau:<\/span><\/p>\n<p><\/p>\n<ul style=\"margin-top: 0; margin-bottom: 0;\">\n<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; margin-left: 36pt;\"><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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft \u1edf c\u1ed9t B;<\/span><\/p>\n<\/li>\n<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; margin-left: 36pt;\"><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;\">H\u01b0\u1edbng d\u1eabn quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i c\u1ee7a tr\u01b0\u1eddng \u1edf c\u1ed9t E v\u00e0 F<\/span><\/p>\n<\/li>\n<\/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-cb00c5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb00c5c\" 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-254966e\" data-id=\"254966e\" 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-543e6f7 elementor-widget elementor-widget-image\" data-id=\"543e6f7\" 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-VLOOKUP-ket-qua-khop-tuong-doi-3.png\" title=\"vi-du-ham-VLOOKUP-ket-qua-khop-tuong-doi\" alt=\"V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c VLOOKUP k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i (1\/TRUE)\" \/>\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-58b435b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58b435b\" 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-314c9f3\" data-id=\"314c9f3\" 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-ef25cee elementor-widget elementor-widget-text-editor\" data-id=\"ef25cee\" 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-343d679e-7fff-fccc-6072-2441ff64d290\"><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; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 tr\u00ean:<\/span><\/span><br><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f252f6 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"2f252f6\" 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-9a089b4d-7fff-85dc-f269-0c5437b538a7\"><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 C4, \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;\">X\u1ebfp lo\u1ea1i<\/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\u1ecdc sinh c\u00f3 <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft <\/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 B4, g\u00f5 c\u00f4ng th\u1ee9c<\/span><\/span><br><span id=\"docs-internal-guid-b7d58d8e-7fff-bd90-6a7c-dae586b417c4\"><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(B4,$E$2:$F$7,2,1) <\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">ho\u1eb7c <\/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(B4,$E$2:$F$7,2,TRUE)<\/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-4affbc92-7fff-e7a8-eaac-9ed9960dca97\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Copy c\u00f4ng th\u1ee9c n\u00e0y cho to\u00e0n b\u1ed9 c\u1ed9t C, ta s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec3m c\u1ee7a t\u1eebng h\u1ecdc sinh.<\/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-2417ff3d-7fff-fd57-f67d-bcb51e9a6972\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m VLOOKUP t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh n\u1ebfu kh\u00f4ng nh\u1eadp <\/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;\">[Range_lookup]&nbsp; n\u00ean c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C4 c\u00f3 th\u1ec3 nh\u1eadp l\u00e0 <\/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(B4,$E$2:$F$7,2)<\/span><\/span><br><br><span id=\"docs-internal-guid-1ba780f6-7fff-2a28-9969-eba6378baef0\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">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 id=\"docs-internal-guid-dcd22738-7fff-6972-d7a6-207a1a9045d5\"><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 <\/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;\">X\u1ebfp lo\u1ea1i <\/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\u1ecdc sinh d\u1ef1a tr\u00ean <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft <\/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\u1ecdc sinh \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><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;\">B4:<\/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 l\u00e0 <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft <\/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\u1ecdc sinh (7.5)<\/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-b853c214-7fff-e307-ffdd-f0f72721b510\"><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;\">$E$2:$F$7<\/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\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb th\u1ea5p \u0111\u1ebfn cao (t\u1eeb h\u1ecdc l\u1ea1i \u0111\u1ebfn xu\u1ea5t s\u1eafc).<\/span><\/span><br><span id=\"docs-internal-guid-54647383-7fff-f80c-3ecd-4a5bb6030151\"><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 n\u00e0y \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong excel \u0111\u1ec3 khi th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm x\u1ebfp lo\u1ea1i c\u1ee7a c\u00e1c h\u1ecdc sinh kh\u00e1c: ta copy c\u00f4ng th\u1ee9c t\u1eeb \u00f4 C4 \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t C th\u00ec gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm kh\u00f4ng thay \u0111\u1ed5i.<\/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-ff3e5232-7fff-0c70-27ee-3a4ef23bc40c\"><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<\/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\u00e0 <\/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;\">Quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i<\/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;\">1<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: \u0110\u1ed1i s\u1ed1 range_lookup l\u00e0 1 (TRUE), trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3 th\u1ec3 d\u00f9ng d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u1ec3 d\u1ec5 d\u00e0ng d\u00f2 t\u00ecm theo kho\u1ea3ng v\u00e0 th\u1ed1ng k\u00ea trong excel.<\/span><\/span><br><span style=\"text-align: justify; text-indent: 36pt; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>L\u01b0u \u00fd:<\/span><span style=\"text-align: justify; text-indent: 36pt; background-color: transparent; font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> H\u00e0m VLOOKUP d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i (1\/TRUE) t\u01b0\u01a1ng t\u1ef1 nh\u01b0 d\u00f9ng h\u00e0m IF v\u00f4 h\u1ea1n. H\u00e0m VLOOKUP n\u00e0y ch\u1ec9 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng khi gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm trong khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm (table_array) \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 (t\u0103ng d\u1ea7n ho\u1eb7c theo b\u1ea3ng ch\u1eef c\u00e1i).&nbsp;<br><span style=\"background-color: transparent; font-size: 11pt; text-indent: 36pt;\">N\u1ebfu kh\u00f4ng th\u1ec3 ho\u1eb7c ch\u01b0a s\u1eafp x\u1ebfp \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm th\u00ec h\u00e0m VLOOKUP d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/span><br><\/span><span><br><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: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u00ecm hi\u1ec3u th\u00eam v\u1ec1: c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m if trong excel<\/span><\/p><\/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-fc851c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fc851c4\" 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-36c54c6\" data-id=\"36c54c6\" 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-85cb9c9 elementor-widget elementor-widget-heading\" data-id=\"85cb9c9\" 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=\"\" id=\"docs-internal-guid-5137dbf0-7fff-bee3-0c27-1c8c6f4bd7bb\"><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.3, Copy v\u00e0 S\u1eed D\u1ee5ng Nhanh H\u00e0m VLOOKUP B\u1eb1ng C\u00e1ch C\u1ed1 \u0110\u1ecbnh \u00d4 Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-33636f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"33636f0\" 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-2d76fb3\" data-id=\"2d76fb3\" 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-3e547c4 elementor-widget elementor-widget-text-editor\" data-id=\"3e547c4\" 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;\">Ti\u1ebfp t\u1ee5c v\u1edbi v\u00ed d\u1ee5 2.2 \u1edf tr\u00ean, tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i quy \u0111\u1ed5i \u0111i\u1ec3m h\u1ec7 10 c\u1ee7a sinh vi\u00ean sang h\u1ec7 4 v\u00e0 h\u1ec7 ch\u1eef \u1edf tr\u01b0\u1eddng \u0111\u1ea1i h\u1ecdc. C\u00e1c th\u00f4ng tin \u0111\u00e3 c\u00f3:<\/span><\/p>\n<ul style=\"margin-top: 0; margin-bottom: 0;\">\n<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; margin-left: 36pt;\"><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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft \u1edf c\u1ed9t B;<\/span><\/p>\n<\/li>\n<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; margin-left: 36pt;\"><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;\">H\u01b0\u1edbng d\u1eabn quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i c\u1ee7a tr\u01b0\u1eddng \u1edf c\u1ed9t G:J<\/span><\/p>\n<\/li>\n<\/ul>\n<p><span id=\"docs-internal-guid-69dda4f5-7fff-4b8f-ab81-9d8199c00118\"><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;\">Nh\u01b0 v\u1eady, c\u1ea7n nh\u1eadp h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm theo <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft m\u00f4n<\/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;\"> \u0111\u1ec3 k\u1ebft xu\u1ea5t d\u1eef li\u1ec7u l\u1ea7n l\u01b0\u1ee3t l\u00e0 <\/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;\">\u0110i\u1ec3m h\u1ec7 4 quy \u0111\u1ed5i, \u0110i\u1ec3m ch\u1eef quy \u0111\u1ed5i, X\u1ebfp lo\u1ea1i<\/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;\"> \u1edf c\u1ed9t C &gt; E. Hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch copy nhanh c\u00f4ng th\u1ee9c VLOOKUP m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i g\u00f5 l\u1ea1i trong t\u1eebng \u00f4 t\u1eeb c\u1ed9t C \u0111\u1ebfn c\u1ed9t E:<\/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-dd384f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd384f9\" 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-8ebbbad\" data-id=\"8ebbbad\" 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-ee5abb7 elementor-widget elementor-widget-image\" data-id=\"ee5abb7\" 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\/copy-va-co-dinh-cong-thuc-vlookup-3.png\" title=\"copy-va-co-dinh-cong-thuc-vlookup\" alt=\"Copy v\u00e0 s\u1eed d\u1ee5ng nhanh h\u00e0m VLOOKUP b\u1eb1ng c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel\" \/>\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-bddc600 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bddc600\" 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-c8a3dc9\" data-id=\"c8a3dc9\" 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-94bf2dc elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"94bf2dc\" 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\">T\u1ea1i \u00f4 C5, nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP($B5,$G$5:$J$13,3,TRUE), 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><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 <\/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;\">\u0110i\u1ec3m h\u1ec7 4 quy \u0111\u1ed5i <\/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\u1ecdc sinh d\u1ef1a tr\u00ean <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft <\/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\u1ecdc sinh \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 id=\"docs-internal-guid-8545c4c2-7fff-5b22-0cd5-7b49c698676a\"><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;\">B5:<\/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 l\u00e0 <\/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;\">\u0110i\u1ec3m t\u1ed5ng k\u1ebft <\/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\u1ecdc sinh (9.1). Sau khi nh\u1eadp B5, \u1ea5n F4 ba l\u1ea7n \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel: B5 s\u1ebd hi\u1ec3n th\u1ecb th\u00e0nh <\/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;\">$B5<\/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-36b2cac2-7fff-a68b-17fd-a24c29d39ce3\"><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;\">$E$2:$F$7<\/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\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb th\u1ea5p \u0111\u1ebfn cao (t\u1eeb h\u1ecdc l\u1ea1i \u0111\u1ebfn xu\u1ea5t s\u1eafc).<\/span><\/span><br><span id=\"docs-internal-guid-53fa3e30-7fff-c395-b68d-6f45d9f606e0\"><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 n\u00e0y \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong excel b\u1eb1ng c\u00e1ch \u1ea5n F4 m\u1ed9t l\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-099004ee-7fff-d8ca-7784-52da6ae327cc\"><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;\">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\u00e0 <\/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;\">Quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i<\/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-73e45dfe-7fff-ff81-dc8e-af46c8d948c1\"><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;\">TRUE<\/span><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: \u0110\u1ed1i s\u1ed1 range_lookup l\u00e0 1 (TRUE), t\u01b0\u01a1ng t\u1ef1 v\u00ed d\u1ee5 2.2<\/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-d4d623d4-7fff-199b-8189-2e7661fc6def\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u1ea1i c\u00e1c \u00f4 c\u00f2n l\u1ea1i c\u1ee7a c\u1ed9t C, copy c\u00f4ng th\u1ee9c \u00f4 C5 v\u00e0 d\u00e1n (Ctrl C Ctrl V)<\/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;\">T\u1ea1i \u00f4 D5, copy c\u00f4ng th\u1ee9c t\u1eeb \u00f4 C5 sang, s\u1eeda <\/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;\">t\u1eeb 3 th\u00e0nh 2 do <\/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;\">Thang \u0111i\u1ec3m ch\u1eef <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">l\u00e0 c\u1ed9t th\u1ee9 2 trong khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm<\/span><\/span><br><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; text-align: justify;\">=VLOOKUP($B5,$G$5:$J$13,2,TRUE)<\/span><br><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; text-align: justify;\">Copy c\u00f4ng th\u1ee9c t\u1eeb D5 cho c\u00e1c \u00f4 c\u1ed9t D<\/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-5130792e-7fff-9de0-11ad-427526bc7766\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">L\u1eb7p l\u1ea1i t\u01b0\u01a1ng t\u1ef1 v\u1edbi \u00f4 E5 v\u00e0 c\u1ed9t E: =VLOOKUP($B5,$G$5:$J$13,4,TRUE)<\/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-d3fd512 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d3fd512\" 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-cc7f7fd\" data-id=\"cc7f7fd\" 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-ec38c3e elementor-widget elementor-widget-heading\" data-id=\"ec38c3e\" 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-4a356ae5-7fff-40b4-b5a2-00839c5e689e\"><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;\">3, L\u01b0u \u00dd Khi S\u1eed D\u1ee5ng H\u00e0m VLOOKUP<\/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-bb0f113 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb0f113\" 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-93759d8\" data-id=\"93759d8\" 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-aaaa5b0 elementor-widget elementor-widget-heading\" data-id=\"aaaa5b0\" 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;\">3.1, D\u00f9ng H\u00e0m VLOOKUP T\u00ecm D\u1eef Li\u1ec7u Trong Nhi\u1ec1u Sheet, Tr\u00edch Xu\u1ea5t D\u1eef Li\u1ec7u T\u1eeb Sheet N\u00e0y Sang Sheet Kh\u00e1c<\/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-06d6247 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"06d6247\" 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-6a10c66\" data-id=\"6a10c66\" 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-c46f908 elementor-widget elementor-widget-text-editor\" data-id=\"c46f908\" 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;\">\u1ee8ng d\u1ee5ng l\u1ea5y d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng n\u00e0y sang b\u1ea3ng kh\u00e1c trong excel: V\u00ed d\u1ee5 c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP gi\u1eefa 2 sheet \u0111\u1ec3 t\u00ednh \u0111\u01a1n gi\u00e1 trong excel: \u0110\u1ec3 tra c\u1ee9u \u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m v\u1edbi m\u00e3 HT003 tr\u00ean sheet <\/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;\">Sale th\u00e1ng 6<\/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;\">, ta s\u1ebd b\u1eaft \u0111\u1ea7u vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP trong \u00f4 C10, sheet Sale th\u00e1ng 6 nh\u01b0 khi d\u00f2 t\u00ecm d\u1eef li\u1ec7u trong 1 sheet gi\u1ed1ng c\u00e1c v\u00ed d\u1ee5 \u1edf tr\u00ean.<\/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; 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 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm, b\u1ea5m sang sheet <\/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;\">\u0110\u01a1n gi\u00e1<\/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;\">, sau \u0111\u00f3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u nh\u01b0 A3:B22 trong sheet \u0110\u01a1n gi\u00e1, Excel s\u1ebd hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c VLOOKUP t\u1ef1 \u0111\u1ed9ng \u0111\u00fang nh\u01b0 tr\u00ean h\u00ecnh minh ho\u1ea1: =VLOOKUP(A10,&#8217;\u0110\u01a1n gi\u00e1&#8217;!$A$3:B$22,2,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-5d9e13e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d9e13e\" 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-81ebc63\" data-id=\"81ebc63\" 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-2f97abe elementor-widget elementor-widget-image\" data-id=\"2f97abe\" 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-vlookup-trich-xuat-du-lieu-giua-cac-sheet-2.jpg\" title=\"ham-vlookup-trich-xuat-du-lieu-giua-cac-sheet\" alt=\"D\u00f9ng h\u00e0m VLOOKUP t\u00ecm d\u1eef li\u1ec7u trong nhi\u1ec1u sheet, tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet 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-8fceb5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8fceb5d\" 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-dc680be\" data-id=\"dc680be\" 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-53be980 elementor-widget elementor-widget-heading\" data-id=\"53be980\" 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;\">3.2, S\u1eed D\u1ee5ng H\u00e0m VLOOKUP Tra C\u1ee9u \u1ede M\u1ed9t File Excel Kh\u00e1c<\/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-35727ec elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"35727ec\" 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-d061837\" data-id=\"d061837\" 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-0037e3c elementor-widget elementor-widget-text-editor\" data-id=\"0037e3c\" 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\u1eabn l\u00e0 v\u00ed d\u1ee5 t\u00ednh \u0111\u01a1n gi\u00e1 trong excel nh\u01b0 tr\u00ean: tr\u01b0\u1eddng h\u1ee3p sheet \u0110\u01a1n gi\u00e1 kh\u00f4ng n\u1eb1m c\u00f9ng 1 file v\u1edbi B\u1ea3ng k\u00ea b\u00e1n h\u00e0ng th\u00e1ng 06\/2020 (sheet Sale th\u00e1ng 6) m\u00e0 n\u1eb1m trong 1 file excel ri\u00eang bi\u1ec7t: \u0111\u01a1n gi\u00e1 T6.xlsx, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP gi\u1eefa 2 file excel kh\u00e1c nhau:<\/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;\">\u0110\u1ec3 tra c\u1ee9u \u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m v\u1edbi m\u00e3 HT002 tr\u00ean sheet <\/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;\">Sale th\u00e1ng 6<\/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;\">, ta c\u1ea7n m\u1edf c\u1ea3 2 file excel, g\u1ed3m file c\u1ea7n vi\u1ebft c\u00f4ng th\u1ee9c v\u00e0 file ngu\u1ed3n d\u1eef li\u1ec7u tra c\u1ee9u. Ta s\u1ebd b\u1eaft \u0111\u1ea7u vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP trong \u00f4 C9, sheet Sale th\u00e1ng 6 nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/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; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm, khi g\u00f5 xong <\/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 <\/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;\">l\u00e0 B9, g\u00f5 d\u1ea5u ph\u1ea9y \u201c,\u201d sau \u0111\u00f3 chuy\u1ec3n sang file <\/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;\">\u0111\u01a1n gi\u00e1 T6.xlsx, <\/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;\">sheet <\/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;\">DG<\/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;\">, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u nh\u01b0 B3:C22 trong sheet n\u00e0y, Excel s\u1ebd hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c VLOOKUP t\u1ef1 \u0111\u1ed9ng \u0111\u00fang nh\u01b0 tr\u00ean h\u00ecnh minh ho\u1ea1: =VLOOKUP(B9,'[\u0111\u01a1n gi\u00e1 T6.xlsx]DG&#8217;!B$3:C$22,2,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-2d25e14 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2d25e14\" 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-8c053c0\" data-id=\"8c053c0\" 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-61620d8 elementor-widget elementor-widget-image\" data-id=\"61620d8\" 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\/v\u00ed-d\u1ee5-t\u00ecm-t\u1eeb-file-kh\u00e1c-1.png\" title=\"v\u00ed d\u1ee5 t\u00ecm t\u1eeb file kh\u00e1c\" alt=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u \u1edf 1 file 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-3577997 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3577997\" 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-669240f\" data-id=\"669240f\" 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-899f47b elementor-widget elementor-widget-text-editor\" data-id=\"899f47b\" 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;\">Tr\u01b0\u1eddng h\u1ee3p file \u0111\u01a1n gi\u00e1 T6.xlsx \u0111\u00f3ng th\u00ec c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a ch\u00fang ta v\u1eabn s\u1ebd ho\u1ea1t \u0111\u1ed9ng, nh\u01b0ng t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c \u201cvi\u1ebft l\u1ea1i\u201d v\u1edbi \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file Excel, bao g\u1ed3m th\u01b0 m\u1ee5c ch\u1ee9a file d\u1eef li\u1ec7u nh\u01b0 sau:<\/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;\">=VLOOKUP(<\/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;\"><u>B<\/u><\/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;\">9,&#8217;C:\\Users\\LENOVO\\Desktop\\[\u0111\u01a1n gi\u00e1 T6.xlsx]DG&#8217;!B$3:C$22,2,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-da68664 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da68664\" 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-af2f222\" data-id=\"af2f222\" 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-5908685 elementor-widget elementor-widget-image\" data-id=\"5908685\" 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\/vlookup-tim-tu-file-khac-hien-thi-cong-thuc-1.png\" title=\"vlookup-tim-tu-file-khac-hien-thi-cong-thuc\" alt=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u \u1edf 1 file 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-7cc4bb5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7cc4bb5\" 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-ceee732\" data-id=\"ceee732\" 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-86fcf46 elementor-widget elementor-widget-heading\" data-id=\"86fcf46\" 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;\">3.3, Vi\u1ebft H\u00e0m VLOOKUP S\u1eed D\u1ee5ng K\u00fd T\u1ef1 Thay Th\u1ebf<\/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-4ea1266 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ea1266\" 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-3eb4caa\" data-id=\"3eb4caa\" 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-a0173fe elementor-widget elementor-widget-text-editor\" data-id=\"a0173fe\" 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-5809c3ec-7fff-d3d6-f9cb-ba4d02f51093\"><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 tra c\u1ee9u kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng. Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, h\u00e0m VLOOKUP h\u1ed7 tr\u1ee3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 sao \u201c*\u201d \u0111\u1ec3 thay th\u1ebf m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 v\u00e0 k\u00fd t\u1ef1 \u201c?\u201d \u0111\u1ec3 thay th\u1ebf cho m\u1ed9t v\u00e0 ch\u1ec9 m\u1ed9t k\u00fd t\u1ef1 trong tham s\u1ed1 lookup_value. V\u00ed d\u1ee5:<\/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-9a2080c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a2080c\" 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-4a00d4e\" data-id=\"4a00d4e\" 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-c2ce762 elementor-widget elementor-widget-image\" data-id=\"c2ce762\" 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\/vlookup-tra-cuu-thay-the-ky-tu-1.png\" title=\"vlookup-tra-cuu-thay-the-ky-tu\" alt=\"H\u00e0m VLOOKUP tra c\u1ee9u kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, h\u1ed7 tr\u1ee3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 sao \u201c*\u201d \u0111\u1ec3 thay th\u1ebf m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 v\u00e0 k\u00fd t\u1ef1 \u201c?\u201d \u0111\u1ec3 thay th\u1ebf cho m\u1ed9t v\u00e0 ch\u1ec9 m\u1ed9t k\u00fd t\u1ef1 trong tham s\u1ed1 lookup_value\" \/>\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-06d20f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"06d20f9\" 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-ca1559b\" data-id=\"ca1559b\" 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-ab9338c elementor-widget elementor-widget-heading\" data-id=\"ab9338c\" 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;\">3.4, C\u00e1c L\u1ed7i Khi D\u00f9ng 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-598cfe7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"598cfe7\" 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-8f40eef\" data-id=\"8f40eef\" 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-68252b7 elementor-widget elementor-widget-text-editor\" data-id=\"68252b7\" 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: #434343; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m VLOOKUP kh\u00f4ng ch\u1ea1y, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb sai th\u01b0\u1eddng g\u00e2y kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. M\u1ed9t s\u1ed1 l\u1ed7i x\u1ea3y ra khi d\u00f9ng h\u00e0m VLOOKUP:<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #434343; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">&#8211; L\u1ed7i #NAME: khi g\u00f5 sai c\u00fa ph\u00e1p h\u00e0m.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #434343; font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline; white-space: pre-wrap;\">&#8211; L\u1ed7i #NA: kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm. Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft c\u1ee5 th\u1ec3 v\u1ec1 <\/span><a href=\"https:\/\/hoctin.vn\/cach-sua-loi-n-a-cua-ham-vlookup\/\"><span style=\"color: #7a7a7a; text-align: justify; font-family: Arial;\"><span style=\"font-size: 14.6667px; white-space: pre-wrap;\"><u style=\"color: #1155cc;\">c\u00e1ch s\u1eeda l\u1ed7i #N\/A trong Excel<\/u><\/span><\/span><\/a> <span style=\"background-color: transparent; color: #434343; font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline; white-space: pre-wrap;\">h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1c l\u1ed7i N\/A th\u01b0\u1eddng g\u1eb7p \u1edf c\u00e1c h\u00e0m, \u0111\u1eb7c bi\u1ec7t l\u00e0 h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #434343; font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline; white-space: pre-wrap;\">&#8211; L\u1ed7i #REF: c\u1ed9t d\u00f2 t\u00ecm kh\u00f4ng c\u00f3 trong b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm, <\/span><span style=\"background-color: transparent; font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; color: #000000; vertical-align: baseline; white-space: pre-wrap;\">col_index_num l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong table_array.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-size: 11pt; text-align: justify; white-space: pre-wrap; font-family: Arial;\">&#8211; L\u1ed7i #VALUE!: col_index_num c\u1ee7a b\u1ea1n nh\u1ecf h\u01a1n 1.<\/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-4739994 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4739994\" 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-da6c41e\" data-id=\"da6c41e\" 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-ca4418a elementor-widget elementor-widget-text-editor\" data-id=\"ca4418a\" 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;\">\u0110\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 c\u00e1c l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u00e0 \u1ee9ng d\u1ee5ng h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong c\u00e1c b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n: h\u00e0m VLOOKUP nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e0m VLOOKUP 2 \u0111i\u1ec1u ki\u1ec7n, c\u00e1ch k\u1ebft h\u1ee3p VLOOKUP v\u00e0 HLOOKUP, \u2026 c\u00e1c b\u1ea1n \u0111\u00f3n \u0111\u1ecdc<\/span>&nbsp;<a href=\"https:\/\/hoctin.vn\/vlookup-va-hlookup-ham-tim-kiem-trong-excel\/\" target=\"_blank\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m t\u00ecm ki\u1ebfm trong excel<\/a><u style=\"font-size: 14.6667px; white-space: pre-wrap; color: #1155cc; font-family: Arial;\"><a href=\"https:\/\/hoctin.vn\/vlookup-va-hlookup-ham-tim-kiem-trong-excel\/\">.<\/a><\/u><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<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;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 h\u00e0m VLOOKUP trong excel. Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\">H\u00e0m IF<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-ket-hop-vlookup\/\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255);\">H\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-sua-loi-n-a-cua-ham-vlookup\/\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255);\">C\u00e1ch s\u1eeda l\u1ed7i #N\/A c\u1ee7a h\u00e0m VLOOKUP<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-index-match-trong-excel\/\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255);\">H\u00e0m INDEX MATCH<\/a><br><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\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>=VLOOKUP(Lookup_value, Table_array, Col_index_ num, [Range_lookup])<br \/>\nTrong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/p>\n","protected":false},"author":3,"featured_media":474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[23,11,18],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/23"}],"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=23"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/474"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}