{"id":346,"date":"2020-07-13T11:07:23","date_gmt":"2020-07-13T04:07:23","guid":{"rendered":"https:\/\/hoctin.vn\/?p=346"},"modified":"2020-07-24T09:59:16","modified_gmt":"2020-07-24T02:59:16","slug":"ham-if-ket-hop-vlookup","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-if-ket-hop-vlookup\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF K\u1ebft H\u1ee3p VLOOKUP Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"346\" class=\"elementor elementor-346\">\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-631d8d7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"631d8d7\" 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-16a846a\" data-id=\"16a846a\" 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-0a0ad6f elementor-widget elementor-widget-text-editor\" data-id=\"0a0ad6f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m IF v\u00e0 h\u00e0m VLOOKUP l\u00e0 hai h\u00e0m c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng, vi\u1ec7c k\u1ebft h\u1ee3p hai h\u00e0m gi\u00fap c\u00e1c b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i t\u1eadp excel v\u00e0 \u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong th\u1ef1c t\u1ebf. B\u00e0i vi\u1ebft c\u1ee7a hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">h\u00e0m IF <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">k\u1ebft h\u1ee3p <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">VLOOKUP <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">trong Excel \u0111\u1ec3 so s\u00e1nh gi\u00e1 tr\u1ecb c\u00f3 \u0111i\u1ec1u ki\u1ec7n, t\u00f9y bi\u1ebfn, thay \u0111\u1ed5i c\u1ed9t tham chi\u1ebfu v\u00e0 tr\u00e1nh l\u1ed7i N\/A khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/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-a713b17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a713b17\" 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-c7c084d\" data-id=\"c7c084d\" 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-c5d5314 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"c5d5314\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h3 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h3>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-03ebc74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"03ebc74\" 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-2c95dcf\" data-id=\"2c95dcf\" 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-13bace7 elementor-widget elementor-widget-text-editor\" data-id=\"13bace7\" 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\u1edbc khi t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">h\u00e0m VLOOKUP k\u1ebft h\u1ee3p <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">h\u00e0m IF, h\u00e3y c\u00f9ng \u00f4n l\u1ea1i c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF v\u00e0 h\u00e0m VLOOKUP. Hoctin.vn \u0111\u00e3 c\u00f3 c\u00e1c b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 hai h\u00e0m n\u00e0y:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m IF tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb do ng\u01b0\u1eddi d\u00f9ng quy \u0111\u1ecbnh khi th\u1ef1c hi\u1ec7n m\u1ed9t so s\u00e1nh logic v\u1edbi c\u00fa ph\u00e1p:<\/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;\">=<\/span><span style=\"font-size: 10.5pt; font-family: Arial; color: #333333; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">IF(logical_test, [value_if_true], [value_if_false])<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #333333; font-family: Arial; font-size: 10.5pt; 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=\"color: #333333; font-family: Arial; font-size: 10.5pt; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-761eedc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"761eedc\" 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-8bcc14e\" data-id=\"8bcc14e\" 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-9a1e04c elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9a1e04c\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; font-weight: bold; vertical-align: baseline;\">Logical_test<\/span><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline;\">: \u0110i\u1ec1u ki\u1ec7n mu\u1ed1n ki\u1ec3m tra v\u1edbi 2 k\u1ebft qu\u1ea3 l\u00e0 TRUE (\u0111\u00fang) v\u00e0 FALSE (sai), v\u00ed d\u1ee5 10 &gt; 2 c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 TRUE v\u00e0 10 &lt; 2 c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 FALSE.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; font-weight: bold; vertical-align: baseline;\">Value_if_true<\/span><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline;\">: gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a logical_test l\u00e0 TRUE.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; font-weight: bold; vertical-align: baseline;\">Value_if_false<\/span><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 10.5pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; vertical-align: baseline;\">: gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a logical_test l\u00e0 FALSE.<\/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-45680c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45680c7\" 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-c99abad\" data-id=\"c99abad\" 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-65f529d elementor-widget elementor-widget-text-editor\" data-id=\"65f529d\" 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;\">T\u00ecm \u0111\u1ecdc th\u00eam v\u1ec1: <\/span><em><span style=\"color: #3366ff;\"><a style=\"background-color: #ffffff; color: #3366ff;\" href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b>H\u00e0m IF t\u1ea1o so s\u00e1nh logic trong Excel, h\u01b0\u1edbng d\u1eabn v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/b><\/a><\/span><\/em><\/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-441e151 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"441e151\" 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-26ca764\" data-id=\"26ca764\" 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-3656c8a elementor-widget elementor-widget-text-editor\" data-id=\"3656c8a\" 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=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38; text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m VLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm, t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong khu v\u1ef1c c\u00e1c c\u1ed9t (t\u1ea1m g\u1ecdi l\u00e0 khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm) v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t c\u1ed9t do ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn t\u1eeb khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm, khi ti\u00eau th\u1ee9c t\u00ecm ki\u1ebfm kh\u1edbp v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u d\u00f2 t\u00ecm.<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38; text-align: justify;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38; text-align: justify;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m VLOOKUP c\u00f3 ph\u1ea7n kh\u00f3 hi\u1ec3u h\u01a1n h\u00e0m IF v\u1edbi c\u1ea5u tr\u00fac:<\/span><\/p><p><span style=\"text-align: justify; 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;\">=<\/span><span style=\"text-align: justify; 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;\">VLOOKUP<\/span><span style=\"text-align: justify; 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;\">(<\/span><span style=\"text-align: justify; 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;\">Lookup_value, Table_array, Col_index_ num<\/span><span style=\"text-align: justify; 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;\">, [Range_lookup])<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38; text-align: justify;\"><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 \u0111\u00f3:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f7b0a77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f7b0a77\" 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-0026f66\" data-id=\"0026f66\" 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-b39c7f8 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b39c7f8\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-weight: bold; vertical-align: baseline;\">Lookup_value<\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; vertical-align: baseline;\">: gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm, tra c\u1ee9u.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-weight: bold; vertical-align: baseline;\">Table_array<\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; 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>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-weight: bold; vertical-align: baseline;\">Col_index_ num<\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; vertical-align: baseline;\">: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong d\u1ea3i \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1 trong k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VLOOKUP.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-weight: bold; vertical-align: baseline;\">[Range_lookup]<\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; font-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; vertical-align: baseline;\">: ph\u1ea1m vi t\u00ecm ki\u1ebfm<\/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-f228702d-7fff-4f35-67cf-0c6d15e7e019\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu Range_lookup = 1 ho\u1eb7c TRUE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p g\u1ea7n \u0111\u00fang<\/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-0c6e03c4-7fff-622a-db88-984b572325d1\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu Range_lookup =&nbsp; 0 ho\u1eb7c FALSE: d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd hi\u1ec7n l\u1ed7i N\/A.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fd0d041 elementor-widget elementor-widget-text-editor\" data-id=\"fd0d041\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u00ecm \u0111\u1ecdc th\u00eam v\u1ec1: <\/span><em><span style=\"color: #3366ff;\"><a style=\"background-color: #ffffff; color: #3366ff;\" href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel-va-vi-du-cu-the\/\" target=\"_blank\" rel=\"noopener\"><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong excel v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/b><\/a><\/span><\/em><\/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-c8dfbed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8dfbed\" 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-d2e7e57\" data-id=\"d2e7e57\" 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-2f0e846 elementor-widget elementor-widget-heading\" data-id=\"2f0e846\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, H\u00e0m IF K\u1ebft H\u1ee3p VLOOKUP Th\u1ef1c Hi\u1ec7n So S\u00e1nh V\u1edbi Ti\u00eau Th\u1ee9c So S\u00e1nh N\u1eb1m Trong M\u1ed9t B\u1ea3ng \u0110i\u1ec1u Ki\u1ec7n:<\/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-010005f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"010005f\" 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-d1a73bf\" data-id=\"d1a73bf\" 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-cc10de3 elementor-widget elementor-widget-text-editor\" data-id=\"cc10de3\" 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 khi l\u00e0m danh s\u00e1ch th\u00ed sinh \u0111\u1ed7 \u0111\u1ea1i h\u1ecdc t\u1eeb vi\u1ec7c so s\u00e1nh t\u1ed5ng \u0111i\u1ec3m c\u00e1c m\u00f4n thi c\u1ee7a th\u00ed sinh v\u1edbi \u0111i\u1ec3m s\u00e0n t\u1eebng ng\u00e0nh h\u1ecd \u0111\u0103ng k\u00fd (m\u1ed7i ng\u00e0nh c\u00f3 m\u1ed9t m\u1ee9c \u0111i\u1ec3m t\u1ed1i thi\u1ec3u kh\u00e1c nhau).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, khu v\u1ef1c d\u1eef li\u1ec7u $B$14:$C$18 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong excel l\u00e0 \u0111i\u1ec3m s\u00e0n c\u00e1c ng\u00e0nh \u0111\u01b0\u1ee3c tr\u01b0\u1eddng \u0111\u1ea1i h\u1ecdc c\u00f4ng b\u1ed1. B\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd l\u00e0 m\u1ed9t danh s\u00e1ch c\u00e1c th\u00ed sinh v\u1edbi ng\u00e0nh h\u1ecdc kh\u00e1c nhau, c\u00f3 th\u00f4ng tin v\u1ec1 t\u1ed5ng \u0111i\u1ec3m. Y\u00eau c\u1ea7u: ki\u1ec3m tra th\u00ed sinh c\u00f3 \u0111\u1ed7 ng\u00e0nh h\u1ecdc \u0111\u00e3 \u0111\u0103ng k\u00fd hay kh\u00f4ng?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 x\u1eed l\u00fd th\u00f4ng tin n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 so s\u00e1nh (T\u1ed5ng \u0111i\u1ec3m v\u00e0 \u0110i\u1ec3m chu\u1ea9n) <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">k\u1ebft h\u1ee3p <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">v\u1edbi VLOOKUP (t\u00ecm ki\u1ebfm \u0110i\u1ec3m chu\u1ea9n t\u1eeb th\u00f4ng tin Ng\u00e0nh h\u1ecdc th\u00ed sinh \u0111\u0103ng k\u00fd) nh\u01b0 \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-291f1e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"291f1e6\" 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-56989b6\" data-id=\"56989b6\" 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-dbe0434 elementor-widget elementor-widget-image\" data-id=\"dbe0434\" 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\/su-dung-ham-if-ket-hop-vlookup-de-so-sanh.png\" title=\"su-dung-ham-if-ket-hop-vlookup-de-so-sanh\" alt=\"S\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP \u0111\u1ec3 th\u1ef1c hi\u1ec7n so s\u00e1nh v\u1edbi ti\u00eau th\u1ee9c so s\u00e1nh n\u1eb1m trong m\u1ed9t b\u1ea3ng \u0111i\u1ec1u ki\u1ec7n\" \/>\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-8564c43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8564c43\" 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-604a3eb\" data-id=\"604a3eb\" 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-678afd0 elementor-widget elementor-widget-text-editor\" data-id=\"678afd0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">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\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-4436428 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4436428\" 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-71aa42a\" data-id=\"71aa42a\" 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-460ec0e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"460ec0e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u1ea1i \u00f4 D3, \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;\">K\u1ebft qu\u1ea3 (\u0110\u1ea1t\/kh\u00f4ng \u0111\u1ea1t) <\/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 th\u00ed 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;\">T\u1ed5ng \u0111i\u1ec3m <\/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 C3, g\u00f5 c\u00f4ng th\u1ee9c:<\/span><\/span><br><span><p dir=\"ltr\" style=\"line-height:1.38;margin-left: 72pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">=IF(C3&gt;=VLOOKUP(B3,$B$14:$C$18,2,0),\"\u0111\u1ea1t\",\"kh\u00f4ng \u0111\u1ea1t\")<\/span><\/p><\/span><span id=\"docs-internal-guid-54af54a3-7fff-de40-c58e-02c509cacd14\"><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-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu T\u1ed5ng \u0111i\u1ec3m C3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng \u0110i\u1ec3m chu\u1ea9n c\u1ee7a Ng\u00e0nh h\u1ecdc t\u01b0\u01a1ng \u1ee9ng VLOOKUP(B3,$B$14:$C$18,2,0) th\u00ec tr\u1ea3 v\u1ec1 \u201c\u0111\u1ea1t\u201d, n\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 \u201ckh\u00f4ng \u0111\u1ea1t\u201d.<\/span><\/p><\/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\">C<span id=\"docs-internal-guid-c959654a-7fff-3a8f-309e-07535ae68606\"><span style=\"font-size: 11.5pt; color: rgb(68, 68, 68); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">opy c\u00f4ng th\u1ee9c n\u00e0y cho to\u00e0n b\u1ed9 c\u1ed9t D, ta s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 x\u00e9t tuy\u1ec3n t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec3m c\u1ee7a t\u1eebng th\u00ed sinh.<\/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-a621f9a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a621f9a\" 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-0b27d0b\" data-id=\"0b27d0b\" 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-9d703a6 elementor-widget elementor-widget-heading\" data-id=\"9d703a6\" 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, S\u1eed D\u1ee5ng H\u00e0m VLOOKUP IF \u0110i\u1ec1u Ch\u1ec9nh C\u1ed9t Tr\u1ea3 V\u1ec1 K\u1ebft Qu\u1ea3 Trong H\u00e0m VLOOKUP<\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d5d7088 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d5d7088\" 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-f6f2fb7\" data-id=\"f6f2fb7\" 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-71c7aca elementor-widget elementor-widget-text-editor\" data-id=\"71c7aca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ti\u1ebfp t\u1ee5c v\u00ed d\u1ee5 v\u1ec1 danh s\u00e1ch th\u00ed sinh \u0111\u1ed7 \u0111\u1ea1i h\u1ecdc t\u1eeb vi\u1ec7c so s\u00e1nh t\u1ed5ng \u0111i\u1ec3m c\u00e1c m\u00f4n thi c\u1ee7a th\u00ed sinh v\u1edbi \u0111i\u1ec3m s\u00e0n t\u1eebng ng\u00e0nh h\u1ecd \u0111\u0103ng k\u00fd nh\u01b0 v\u00ed d\u1ee5 1 \u1edf tr\u00ean. B\u00e0i to\u00e1n tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p h\u01a1n khi c\u00e1c ng\u00e0nh c\u00f3 nhi\u1ec1u t\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n.<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">L\u00fac n\u00e0y, vi\u1ec7c x\u00e9t th\u00ed sinh c\u00f3 \u0111\u1ed7 hay kh\u00f4ng ph\u1ea3i d\u1ef1a tr\u00ean \u0110i\u1ec3m chu\u1ea9n s\u1ebd kh\u00f3 h\u01a1n v\u00ed d\u1ee5 1 \u1edf tr\u00ean v\u00ec \u0110i\u1ec3m chu\u1ea9n t\u00f9y thu\u1ed9c v\u00e0o c\u1ea3 Ng\u00e0nh h\u1ecdc v\u00e0 c\u1ea3 T\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n.<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u0110\u1ec3 c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m v\u1edbi nhau, c\u00e1c b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 \u0111\u01b0\u1ee3c h\u01b0\u1edbng gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 tr\u01b0\u1edbc, sau \u0111\u00f3 m\u1edbi x\u00e1c \u0111\u1ecbnh c\u00e1ch gi\u1ea3i quy\u1ebft chi ti\u1ebft: vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m n\u00e0o, th\u1ee9 t\u1ef1 c\u00e1c h\u00e0m ra sao.<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"text-align: start; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 x\u1eed l\u00fd th\u00f4ng tin n\u00e0y b\u1eb1ng c\u00e1ch t\u00ecm \u0110i\u1ec3m chu\u1ea9n c\u1ee7a Ng\u00e0nh h\u1ecdc v\u00e0 T\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n t\u1ea1i c\u1ed9t E b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm \u0110i\u1ec3m chu\u1ea9n v\u1edbi h\u00e0m IF (\u0111\u1ec3 quy \u0111\u1ecbnh Col_index_num t\u01b0\u01a1ng \u1ee9ng c\u1ed9t t\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n n\u00e0o) nh\u01b0 \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-167ed52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"167ed52\" 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-118408e\" data-id=\"118408e\" 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-8927111 elementor-widget elementor-widget-image\" data-id=\"8927111\" 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\/su-dung-ham-if-ket-hop-vlookup.png\" title=\"su-dung-ham-if-ket-hop-vlookup\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m if k\u1ebft h\u1ee3p vlookup trong excel \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u1ed9t tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 trong h\u00e0m VLOOKUP\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-82a8895 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"82a8895\" 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-cc239dc\" data-id=\"cc239dc\" 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-30393cf elementor-widget elementor-widget-text-editor\" data-id=\"30393cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 tr\u00ean, v<\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">i\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau<\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"font-size: 11pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u1ea1i \u00f4 E4, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><span style=\"font-size: 11pt; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110i\u1ec3m chu\u1ea9n <\/span><span style=\"font-size: 11pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">c\u1ee7a <\/span><span style=\"font-size: 11pt; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Ng\u00e0nh h\u1ecdc<\/span><span style=\"font-size: 11pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> t\u1ea1i \u00f4 B4 v\u00e0 <\/span><span style=\"font-size: 11pt; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n <\/span><span style=\"font-size: 11pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">t\u1ea1i \u00f4 C4, g\u00f5 c\u00f4ng th\u1ee9c<\/span><br \/><\/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;\"><span style=\"font-size: 11pt; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">=VLOOKUP(B4,$B$15:$E$19,IF(C4=$C$14,2,(IF(C4=$D$14,3,4))),0)<\/span><span style=\"font-size: 11pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br \/><\/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-838cd6f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"838cd6f\" 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-404c11e\" data-id=\"404c11e\" 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-50f3352 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"50f3352\" 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-4b7d7b1d-7fff-9124-cc2a-9ffde26d35f6\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m VLOOKUP: D\u00f2 t\u00ecm \u0110i\u1ec3m chu\u1ea9n c\u1ee7a Ng\u00e0nh h\u1ecdc. V\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array l\u00e0 $B$15:$E$19, col_index_num (s\u1ed1 c\u1ee7a c\u1ed9t \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 h\u00e0m VLOOKUP) \u0111\u01b0\u1ee3c quy\u1ebft \u0111\u1ecbnh b\u1edfi h\u00e0m IF.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-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-01de31ab-7fff-1f9a-f1e4-ba5d7d27efc3\"><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-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m IF: N\u1ebfu T\u1ed5 h\u1ee3p x\u00e9t tuy\u1ec3n l\u00e0 A00 th\u00ec tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 2, l\u00e0 A01 tr\u1ea3 v\u1ec1 3, c\u00f2n l\u1ea1i tr\u1ea3 v\u1ec1 4 (ch\u1ec9 c\u00f3 3 t\u1ed5 h\u1ee3p, kh\u00f4ng ph\u1ea3i A00 v\u00e0 A01 th\u00ec l\u00e0 D01)<\/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-134e220 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"134e220\" 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-83e3459\" data-id=\"83e3459\" 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-945e660 elementor-widget elementor-widget-heading\" data-id=\"945e660\" 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;\">3, H\u00e0m IF K\u1ebft H\u1ee3p VLOOKUP Tra C\u1ee9u T\u1eeb Hai V\u00f9ng D\u1eef Li\u1ec7u<\/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-eced3ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eced3ad\" 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-2bfdd5e\" data-id=\"2bfdd5e\" 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-e342aa4 elementor-widget elementor-widget-text-editor\" data-id=\"e342aa4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u b\u1ea3ng tra c\u1ee9u. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 ki\u1ec3m tra xem m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng hay kh\u00f4ng r\u1ed3i tr\u1ea3 v\u1ec1 m\u1ed9t b\u1ea3ng tra c\u1ee9u n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng (TRUE) ho\u1eb7c m\u1ed9t b\u1ea3ng tra c\u1ee9u kh\u00e1c n\u1ebfu FALSE.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 t\u00ednh hoa h\u1ed3ng \u0111\u1ea1i l\u00fd b\u00e1n b\u1ea3o hi\u1ec3m cho t\u1eebng h\u1ee3p \u0111\u1ed3ng s\u1eed d\u1ee5ng h\u00e0m VLOOKUP c\u00f3 \u0111i\u1ec1u ki\u1ec7n IF.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\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;\">T\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i, m\u1ee9c % hoa h\u1ed3ng theo t\u1eebng s\u1ea3n ph\u1ea9m b\u1ea3o hi\u1ec3m th\u1ea5p h\u01a1n n\u0103m \u0111\u1ea7u ti\u00ean. Do \u0111\u00f3 v\u1edbi m\u1ed7i h\u1ee3p \u0111\u1ed3ng b\u1ea3o hi\u1ec3m, \u0111\u1ea1i l\u00fd ph\u1ea3i ki\u1ec3m tra xem h\u1ee3p \u0111\u1ed3ng l\u00e0 n\u0103m \u0111\u1ea7u ti\u00ean hay n\u0103m th\u1ee9 hai tr\u1edf \u0111i \u0111\u1ec3 t\u00ecm m\u1ee9c % hoa h\u1ed3ng ph\u00f9 h\u1ee3p theo s\u1ea3n ph\u1ea9m.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd g\u1ed3m c\u00e1c th\u00f4ng tin: T\u00ean kh\u00e1ch h\u00e0ng, t\u00ean s\u1ea3n ph\u1ea9m (d\u00f9ng \u0111\u1ec3 tra c\u1ee9u % hoa h\u1ed3ng), n\u0103m th\u1ee9 bao nhi\u00eau (\u0111\u1ec3 tra c\u1ee9u % hoa h\u1ed3ng c\u1ee7a s\u1ea3n ph\u1ea9m \u0111ang theo b\u1ea3ng N\u0103m \u0111\u1ea7u ti\u00ean hay T\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 x\u1eed l\u00fd th\u00f4ng tin n\u00e0y b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP (t\u00ecm ki\u1ebfm % hoa h\u1ed3ng c\u1ee7a s\u1ea3n ph\u1ea9m) v\u00e0 quy \u0111\u1ecbnh Table_array b\u1eb1ng h\u00e0m IF (n\u1ebfu H\u1ee3p \u0111\u1ed3ng k\u00fd n\u0103m th\u1ee9 nh\u1ea5t th\u00ec tr\u1ea3 v\u1ec1 b\u1ea3ng N\u0103m \u0111\u1ea7u ti\u00ean l\u00e0 v\u00f9ng d\u1eef li\u1ec7u $A$5:$B$8, n\u1ebfu kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 b\u1ea3ng T\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i l\u00e0 v\u00f9ng d\u1eef li\u1ec7u $D$5:$E$8) nh\u01b0 \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-574a393 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"574a393\" 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-4d39d3f\" data-id=\"4d39d3f\" 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-069e1c3 elementor-widget elementor-widget-image\" data-id=\"069e1c3\" 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-ket-hop-ham-IF-de-tra-cuu-tu-hai-vung-du-lieu.png\" title=\"Ham-VLOOKUP-ket-hop-ham-IF-de-tra-cuu-tu-hai-vung-du-lieu\" alt=\"H\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m IF \u0111\u1ec3 tra c\u1ee9u t\u1eeb hai v\u00f9ng d\u1eef li\u1ec7u\" \/>\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-2234c28 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2234c28\" 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-1625a41\" data-id=\"1625a41\" 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-35d6ec0 elementor-widget elementor-widget-text-editor\" data-id=\"35d6ec0\" 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;\">Trong v\u00ed d\u1ee5 tr\u00ean vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/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;\">T\u1ea1i \u00f4 E12, \u0111\u1ec3 t\u00ecm ki\u1ebfm <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">% hoa h\u1ed3ng <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">c\u1ee7a h\u1ee3p \u0111\u1ed3ng c\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;\">S\u1ea3n ph\u1ea9m <\/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;\">t\u1ea1i \u00f4 B12, g\u00f5 c\u00f4ng th\u1ee9c<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=VLOOKUP(B12,IF(C12&lt;2,$A$5:$B$8,$D$5:$E$8),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-0aa62c5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0aa62c5\" 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-e08f45b\" data-id=\"e08f45b\" 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-1c8b6be elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"1c8b6be\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m IF: N\u1ebfu \u201cN\u0103m th\u1ee9\u201d C12 nh\u1ecf h\u01a1n 2 (t\u1ee9c l\u00e0 n\u0103m \u0111\u1ea7u) th\u00ec tr\u1ea3 v\u1ec1 b\u1ea3ng \u201cN\u0103m \u0111\u1ea7u ti\u00ean\u201d, n\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 b\u1ea3ng \u201cT\u1eeb n\u0103m th\u1ee9 hai tr\u1edf \u0111i\u201d.<\/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 style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m VLOOKUP: D\u00f2 t\u00ecm s\u1ea3n ph\u1ea9m c\u1ee7a h\u1ee3p \u0111\u1ed3ng c\u00f3 m\u1ee9c % hoa h\u1ed3ng l\u00e0 bao nhi\u00eau. V\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm Table_array l\u00e0 $A$5:$B$8 hay $D$5:$E$8 ph\u1ee5 thu\u1ed9c k\u1ebft qu\u1ea3 h\u00e0m IF \u1edf tr\u00ean.<\/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-6826456 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6826456\" 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-44eb827\" data-id=\"44eb827\" 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-0b13b84 elementor-widget elementor-widget-heading\" data-id=\"0b13b84\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4, K\u1ebft H\u1ee3p H\u00e0m IF V\u00e0 VLOOKUP \u0110\u1ec3 Tr\u00e1nh L\u1ed7i N\/A Khi S\u1eed D\u1ee5ng H\u00e0m VLOOKUP <\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-265b18e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"265b18e\" 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-5ac16e7\" data-id=\"5ac16e7\" 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-ef1bd72 elementor-widget elementor-widget-text-editor\" data-id=\"ef1bd72\" 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;\">\u1ede v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u1ea1i \u00f4 C10 cho k\u1ebft qu\u1ea3 l\u1ed7i. B\u1edfi v\u00ec \u00f4 C7 \u0111ang tr\u1ed1ng n\u00ean h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 d\u00f2 \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb n\u00e0o \u1edf v\u00f9ng d\u1eef li\u1ec7u d\u00f2 t\u00ecm kh\u1edbp C7. S\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP \u0111\u1ec3 tr\u00e1nh l\u1ed7i:<\/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;\">=IF(C7=\u201c\u201d,&#8221;Not available&#8221;,VLOOKUP(C7,$C$2:$E$5,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-b3e2f46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b3e2f46\" 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-7a9157a\" data-id=\"7a9157a\" 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-b16348f elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b16348f\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(68, 68, 68); font-size: 15.3333px; text-align: justify;\">N\u1ebfu \u00f4 C7 (lookup_value c\u1ee7a h\u00e0m vlookup) tr\u1ed1ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 text \u201cLookup_value tr\u1ed1ng\u201d<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(68, 68, 68); font-size: 15.3333px; text-align: justify;\">N\u1ebfu \u00f4 C7 kh\u00f4ng r\u1ed7ng th\u00ec s\u1ebd s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/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-c7f0a4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7f0a4f\" 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-63bf367\" data-id=\"63bf367\" 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-130cef6 elementor-widget elementor-widget-image\" data-id=\"130cef6\" 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-if-sua-loi-NA-khi-dung-ham-vlookup.png\" title=\"ham-if-sua-loi-NA-khi-dung-ham-vlookup\" alt=\"K\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 VLOOKUP \u0111\u1ec3 tr\u00e1nh l\u1ed7i N\/A khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4fc4ed7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4fc4ed7\" 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-e61479b\" data-id=\"e61479b\" 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-18c5b76 elementor-widget elementor-widget-text-editor\" data-id=\"18c5b76\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 thay h\u00e0m IF b\u1eb1ng h\u00e0m IFERROR ho\u1eb7c h\u00e0m IFNA v\u1edbi c\u00fa ph\u00e1p:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=IFERROR(Value,value_if_error)<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, c\u1ee5 th\u1ec3:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=IFERROR(VLOOKUP(C7,$C$2:$E$5,2,0),&#8221;Not available&#8221;)<\/span><\/p><p><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=IFNA(Value,value_if_na)<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, c\u1ee5 th\u1ec3:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">=IFNA(VLOOKUP(C7,$C$2:$E$5,2,0),&#8221;Not available&#8221;)<\/span><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-edb7562 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"edb7562\" 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-d8c6905\" data-id=\"d8c6905\" 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-22c91e2 elementor-widget elementor-widget-image\" data-id=\"22c91e2\" 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-iferror-va-ifna-sua-loi-NA-khi-dung-ham-vlookup.png\" title=\"ham-iferror-va-ifna-sua-loi-NA-khi-dung-ham-vlookup\" alt=\"K\u1ebft h\u1ee3p h\u00e0m IF\/IFERROR\/IFNA v\u00e0 VLOOKUP \u0111\u1ec3 tr\u00e1nh l\u1ed7i N\/A khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e59ccc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e59ccc6\" 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-c8ccf8b\" data-id=\"c8ccf8b\" 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-1597367 elementor-widget elementor-widget-text-editor\" data-id=\"1597367\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m IF, VLOOKUP c\u0169ng nh\u01b0 \u1ee9ng d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP trong th\u1ef1c t\u1ebf.<\/span><\/p>\n<p><span style=\"color: #333333; font-size: 11.5pt; white-space: pre-wrap; text-align: justify;\">Ch\u00fac c\u00e1c \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng v\u00e0 v\u1eadn d\u1ee5ng t\u1ed1t trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel-va-vi-du-cu-the\/\"><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<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m HLOOKUP<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m IF<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m AND<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 72pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m OR<\/span><\/p>\n<div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0 H\u00e0m IF v\u00e0 h\u00e0m VLOOKUP l\u00e0 hai h\u00e0m c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng, vi\u1ec7c k\u1ebft h\u1ee3p hai h\u00e0m gi\u00fap c\u00e1c b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i t\u1eadp excel v\u00e0 \u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong th\u1ef1c t\u1ebf. B\u00e0i vi\u1ebft c\u1ee7a hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP trong Excel &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF K\u1ebft H\u1ee3p VLOOKUP Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-if-ket-hop-vlookup\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF K\u1ebft H\u1ee3p VLOOKUP Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":463,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[27,11,18],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/346"}],"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=346"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/463"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}