{"id":2724,"date":"2024-12-02T08:31:33","date_gmt":"2024-12-02T08:31:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon\/"},"modified":"2024-12-02T08:31:33","modified_gmt":"2024-12-02T08:31:33","slug":"ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon\/","title":{"rendered":"H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match \u2013 H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span style=\"font-weight: 400\"><em>H\u00e0m VLOOKUP r\u1ea5t b\u1ed5 \u00edch. Tuy nhi\u00ean, n\u00f3 c\u00f3 m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf, \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao INDEX MATCH l\u00e0 c\u00f4ng c\u1ee5 thay th\u1ebf tuy\u1ec7t v\u1eddi. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd tr\u00ecnh b\u00e0y v\u1ec1 c\u00e1c h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m VLOOKUP v\u00e0 l\u00fd do t\u1ea1i sao <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html\"><strong>h\u00e0m INDEX MATCH l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t h\u01a1n<\/strong><\/a><\/em> <\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d706480c55\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Cong_thuc_cuoi_cung\" title=\"C\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng\u00a0\">C\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Thiet_lap_du_lieu_cua_chung_ta\" title=\"Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta\u00a0\">Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Han_che_cua_ham_VLOOKUP_1\" title=\"H\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m VLOOKUP 1\u00a0\">H\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m VLOOKUP 1\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Giai_thich_ham_INDEX\" title=\"Gi\u1ea3i th\u00edch h\u00e0m INDEX\u00a0\">Gi\u1ea3i th\u00edch h\u00e0m INDEX\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Giai_thich_ham_MATCH\" title=\"Gi\u1ea3i th\u00edch h\u00e0m MATCH\u00a0\">Gi\u1ea3i th\u00edch h\u00e0m MATCH\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Chen_cac_ham_INDEX_va_MATCH\" title=\"Ch\u00e8n c\u00e1c h\u00e0m INDEX v\u00e0 MATCH\u00a0\">Ch\u00e8n c\u00e1c h\u00e0m INDEX v\u00e0 MATCH\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Giai_phap_ngoai_cung_ben_trai_ham_INDEX_MATCH\" title=\"Gi\u1ea3i ph\u00e1p ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i h\u00e0m INDEX MATCH\">Gi\u1ea3i ph\u00e1p ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i h\u00e0m INDEX MATCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Han_che_VLOOKUP_2\" title=\"H\u1ea1n ch\u1ebf VLOOKUP 2\u00a0\">H\u1ea1n ch\u1ebf VLOOKUP 2\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Han_che_VLOOKUP_3\" title=\"H\u1ea1n ch\u1ebf VLOOKUP 3\u00a0\">H\u1ea1n ch\u1ebf VLOOKUP 3\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-va-ham-index-match-ham-nao-hieu-qua-hon.html#Giai_phap_da_chieu_ham_INDEX_MATCH\" title=\"Gi\u1ea3i ph\u00e1p \u0111a chi\u1ec1u h\u00e0m INDEX MATCH\u00a0\">Gi\u1ea3i ph\u00e1p \u0111a chi\u1ec1u h\u00e0m INDEX MATCH\u00a0<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_cuoi_cung\"><\/span><b>C\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">=INDEX(A3:B8,MATCH(E2,B3:B8,0),1)<\/span><\/p>\n<figure id=\"attachment_34744\" aria-describedby=\"caption-attachment-34744\" style=\"width: 775px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34744 size-full\" title=\"1- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-12.png\" alt=\"1- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"775\" height=\"477\"><figcaption id=\"caption-attachment-34744\" class=\"wp-caption-text\">H\u00ecnh 1 \u2013 K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>H\u00e0m VLOOKUP<\/strong><\/a> c\u00f3 ba h\u1ea1n ch\u1ebf ch\u00ednh c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng lo\u1ea1i b\u1ecf b\u1eb1ng c\u00e1ch thay th\u1ebf h\u00e0m VLOOKUP b\u1eb1ng <strong>h\u00e0m INDEX MATCH<\/strong><\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u1ea3ng tra c\u1ee9u ph\u1ea3i l\u00e0 d\u1eef li\u1ec7u ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i trong Table Array<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u1ea3ng tra c\u1ee9u ph\u1ea3i theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Y\u00eau c\u1ea7u tra c\u1ee9u ph\u1ea3i ch\u1ec9 l\u00e0 m\u1ed9t chi\u1ec1u\u00a0<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd xem qua m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 t\u1eebng gi\u1edbi h\u1ea1n trong s\u1ed1 ba h\u1ea1n ch\u1ebf v\u00e0 sau \u0111\u00f3 gi\u1ea3i th\u00edch c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m INDEX MATCH \u0111\u1ec3 gi\u1ea3i quy\u1ebft ch\u00fang, nh\u01b0ng tr\u01b0\u1edbc ti\u00ean h\u00e3y thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_du_lieu_cua_chung_ta\"><\/span><b>Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta \u0111\u1ec3 c\u1ed9t A s\u1ebd l\u00e0 Student Ranking (1- 20), Column B:E s\u1ebd l\u00e0 Student Name.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd trong h\u00e0ng 3 c\u00e1ch ch\u00fang ta \u0111\u00e3 th\u00eam m\u1ed9t Class Color. \u0110i\u1ec1u n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng sau n\u00e0y \u0111\u1ec3 gi\u1ea3i quy\u1ebft tra c\u1ee9u \u0111a chi\u1ec1u.<\/span><\/p>\n<figure id=\"attachment_34745\" aria-describedby=\"caption-attachment-34745\" style=\"width: 779px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34745 size-full\" title=\"2- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-11.png\" alt=\"2- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"779\" height=\"520\"><figcaption id=\"caption-attachment-34745\" class=\"wp-caption-text\">H\u00ecnh 2 \u2013 Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Han_che_cua_ham_VLOOKUP_1\"><\/span><b>H\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m VLOOKUP 1<\/b><span style=\"font-weight: 400\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec d\u1eef li\u1ec7u hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp, ch\u00fang ta kh\u00f4ng bao gi\u1edd c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean trong c\u00e1c column B:E \u0111\u1ec3 tra c\u1ee9u x\u1ebfp h\u1ea1ng c\u1ee7a ch\u00fang do th\u1ef1c t\u1ebf l\u00e0 c\u00e1c h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a Lookup Array. B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd l\u00e0m vi\u1ec7c th\u00f4ng qua m\u1ed9t v\u00ed d\u1ee5:\u00a0<\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-210.gif\" title=\"ex101_92019-nho-210\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p h\u00e0m VLOOKUP: VLOOKUP(Lookup Value, Table Array, Return Column, Approximate Match [TRUE\/FALSE])<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H3, nh\u1eadp \u201cSandra\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">=VLOOKUP(H3,A4:E23,1,FALSE)<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34746\" aria-describedby=\"caption-attachment-34746\" style=\"width: 773px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34746 size-full\" title=\"3- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-11.png\" alt=\"3- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"773\" height=\"519\"><figcaption id=\"caption-attachment-34746\" class=\"wp-caption-text\">H\u00ecnh 3 \u2013 L\u1ed7i ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i VLOOKUP<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta nh\u1eadn th\u1ea5y trong V\u00ed d\u1ee5 n\u00e0y r\u1eb1ng c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A nh\u01b0 ch\u00fang ta mong \u0111\u1ee3i. Ngay sau \u0111\u00f3, ch\u00fang ta s\u1ebd kh\u1eafc ph\u1ee5c l\u1ed7i b\u1eb1ng c\u00e1ch thay th\u1ebf h\u00e0m VLOOKUP b\u1eb1ng h\u00e0m INDEX MATCH, nh\u01b0ng tr\u01b0\u1edbc ti\u00ean, ch\u00fang ta ph\u1ea3i \u0111\u1ec1 c\u1eadp \u0111\u1ebfn s\u1ef1 kh\u00e1c bi\u1ec7t ch\u00ednh v\u1edbi h\u00e0m INDEX MATCH. N\u00f3 l\u00e0 m\u1ed9t si\u00eau h\u00e0m v\u1edbi hai h\u00e0m kh\u00e1c nhau \u0111\u01b0\u1ee3c l\u1ed3ng v\u00e0o nhau \u2013 h\u00e0m INDEX v\u00e0 h\u00e0m MATCH\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Giai_thich_ham_INDEX\"><\/span><b>Gi\u1ea3i th\u00edch h\u00e0m INDEX\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\"><strong>H\u00e0m INDEX<\/strong><\/a> c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch xem x\u00e9t m\u1ed9t table array v\u00e0 sau \u0111\u00f3 xem h\u00e0ng v\u00e0 c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh c\u1ee7a Table Array.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p INDEX:<\/span><span style=\"font-weight: 400\">=INDEX(Table Array, Row Position, Column Position)<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, x\u00f3a t\u1ea5t c\u1ea3 th\u00f4ng tin trong c\u00e1c \u00f4 H3:H5\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o H3 <\/span><span style=\"font-weight: 400\">=INDEX(A4:E23,3,3)<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34747\" aria-describedby=\"caption-attachment-34747\" style=\"width: 778px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34747 size-full\" title=\"4- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-12.png\" alt=\"4- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"778\" height=\"522\"><figcaption id=\"caption-attachment-34747\" class=\"wp-caption-text\">H\u00ecnh 4 \u2013 INDEX<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta nh\u1eadn th\u1ea5y trong v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cWhite\u201d v\u00ec \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb n\u1eb1m \u1edf h\u00e0ng 3 v\u00e0 c\u1ed9t 3 c\u1ee7a Table Array. Ti\u1ebfp theo ch\u00fang ta s\u1ebd tr\u00ecnh b\u00e0y v\u1ec1 h\u00e0m MATCH\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Giai_thich_ham_MATCH\"><\/span><b>Gi\u1ea3i th\u00edch h\u00e0m MATCH\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t m\u1ea3nh c\u00f2n l\u1ea1i c\u1ee7a h\u00e0m INDEX MATCH l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html\"><strong>H\u00e0m MATCH<\/strong><\/a> s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed (H\u00e0ng ho\u1eb7c C\u1ed9t) c\u1ee7a n\u01a1i t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ph\u00f9 h\u1ee3p\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p MATCH: <\/span><span style=\"font-weight: 400\">=MATCH(Lookup Value, Lookup Array, Approximate Match [TRUE\/FALSE])<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 G6, th\u00eam m\u1ed9t danh m\u1ee5c m\u1edbi c\u00f3 ti\u00eau \u0111\u1ec1 \u201cV\u1ecb tr\u00ed MATCH\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H6, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\">=MATCH(H3,C4:C23,FALSE)<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34748\" aria-describedby=\"caption-attachment-34748\" style=\"width: 774px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34748 size-full\" title=\"5- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-12.png\" alt=\"5- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"774\" height=\"521\"><figcaption id=\"caption-attachment-34748\" class=\"wp-caption-text\">H\u00ecnh 5 \u2013 MATCH<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y trong V\u00ed d\u1ee5 n\u00e0y c\u00e1ch c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201c3\u201d v\u00ec \u0111\u00f3 l\u00e0 v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p l\u00e0 \u201cWhite\u201d trong v\u00ed d\u1ee5 n\u00e0y.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chen_cac_ham_INDEX_va_MATCH\"><\/span><b>Ch\u00e8n c\u00e1c h\u00e0m INDEX v\u00e0 MATCH\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi ch\u00fang ta ch\u00e8n <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\"><strong>c\u00e1c h\u00e0m INDEX v\u00e0 MATCH<\/strong><\/a>, h\u00e0m INDEX ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng nh\u01b0 tr\u00ean. N\u00f3 xem x\u00e9t m\u1ed9t Table Array \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh cho d\u1eef li\u1ec7u, ngo\u1ea1i tr\u1eeb hi\u1ec7n t\u1ea1i, h\u00e0m MATCH s\u1ebd ch\u1ec9 \u0111\u1ecbnh V\u1ecb tr\u00ed h\u00e0ng so v\u1edbi khi n\u00f3 \u0111\u01b0\u1ee3c nh\u1eadp trong\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p MATCH INDEX: <\/span><span style=\"font-weight: 400\">=Index(Table Array, MATCH(Lookup Value, Lookup Array, Approximate Match [TRUE\/FALSE])<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\">=INDEX(A4:A23,MATCH(H3,C4:C23,FALSE))<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34750\" aria-describedby=\"caption-attachment-34750\" style=\"width: 783px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34750 size-full\" title=\"6- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-12.png\" alt=\"6- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"783\" height=\"516\"><figcaption id=\"caption-attachment-34750\" class=\"wp-caption-text\">H\u00ecnh 6 \u2013 Gi\u1ea3i th\u00edch h\u00e0m INDEX MATCH<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y trong v\u00ed d\u1ee5 n\u00e0y r\u1eb1ng c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 Student Raking l\u00e0 \u201c3\u201d v\u00ec \u201cWhite\u201d \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf H\u00e0ng 3 c\u1ee7a Lookup Array. B\u00e2y gi\u1edd, ch\u00fang ta \u0111\u00e3 bi\u1ebft c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m MATCH, ch\u00fang ta c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft h\u1ea1n ch\u1ebf VLOOKUP.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Giai_phap_ngoai_cung_ben_trai_ham_INDEX_MATCH\"><\/span><b>Gi\u1ea3i ph\u00e1p ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i h\u00e0m INDEX MATCH<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec h\u00e0m INDEX c\u00f3 kh\u1ea3 n\u0103ng ch\u1ec9 \u0111\u1ecbnh H\u00e0ng v\u00e0 C\u1ed9t, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 cho h\u00e0m bi\u1ebft ch\u00fang ta mu\u1ed1n n\u00f3 \u1edf \u0111\u00e2u \u2013 ngay c\u1ea3 \u1edf b\u00ean tr\u00e1i Gi\u00e1 tr\u1ecb tra c\u1ee9u c\u1ee7a ch\u00fang ta! \u0110\u1ec3 minh h\u1ecda, ch\u00fang ta s\u1ebd th\u1eed c\u00f9ng m\u1ed9t h\u00e0m VLOOKUP nh\u01b0 tr\u01b0\u1edbc (t\u00ecm Student Ranking b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Name)\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, x\u00f3a t\u1ea5t c\u1ea3 th\u00f4ng tin trong c\u00e1c \u00f4 H3:H6\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H3, g\u00f5 \u201cSandra\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">=INDEX(A4:A23,MATCH(H3,B4:B23,FALSE))<\/span><\/span>\n<p><figure id=\"attachment_34751\" aria-describedby=\"caption-attachment-34751\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34751 size-full\" title=\"7- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-11.png\" alt=\"7- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"512\" height=\"343\"><figcaption id=\"caption-attachment-34751\" class=\"wp-caption-text\">H\u00ecnh 7 \u2013 Ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i h\u00e0m INDEX MATCH<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta th\u1ea5y trong v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 Raking l\u00e0 \u201c4\u201d v\u00ec \u0111\u00f3 l\u00e0 v\u1ecb tr\u00ed H\u00e0ng n\u01a1i t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp v\u1edbi \u201cSandra\u201d. Ti\u1ebfp theo, ch\u00fang ta s\u1ebd xem x\u00e9t H\u1ea1n ch\u1ebf <\/span><span style=\"font-weight: 400\">th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/span><span style=\"font-weight: 400\"> c\u1ee7a VLOOKUP\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Han_che_VLOOKUP_2\"><\/span><b>H\u1ea1n ch\u1ebf VLOOKUP 2\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t t\u1eadp d\u1eef li\u1ec7u, nh\u01b0ng \u0111\u1ec3 minh h\u1ecda cho \u0111i\u1ec3m n\u00e0y, ch\u00fang ta s\u1ebd b\u1ecf s\u1eafp x\u1ebfp C\u1ed9t Student Ranking. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ch\u00fang ta s\u1ebd s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo C\u1ed9t B. Xem h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_34752\" aria-describedby=\"caption-attachment-34752\" style=\"width: 777px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34752 size-full\" title=\"8- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-11.png\" alt=\"8- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"777\" height=\"514\"><figcaption id=\"caption-attachment-34752\" class=\"wp-caption-text\">H\u00ecnh 8 \u2013 B\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta \u0111\u00e3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u kh\u00f4ng theo th\u1ee9 t\u1ef1, ch\u00fang ta s\u1ebd c\u1ed1 g\u1eafng tr\u1ea3 v\u1ec1 Student \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi Lookup Values (Student Ranking).\u00a0\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, x\u00f3a t\u1ea5t c\u1ea3 th\u00f4ng tin trong c\u00e1c \u00f4 H3: H6<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp \u201c3\u201d<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">=VLOOKUP(H5,A4:E23,2,FALSE)<\/span><\/span>\n<p><figure id=\"attachment_34753\" aria-describedby=\"caption-attachment-34753\" style=\"width: 774px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34753 size-full\" title=\"9- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-10.png\" alt=\"9- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"774\" height=\"517\"><figcaption id=\"caption-attachment-34753\" class=\"wp-caption-text\">H\u00ecnh 9 \u2013 B\u1ecf s\u1eafp x\u1ebfp VLOOKUP<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Nh\u01b0 ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y t\u1eeb v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 l\u1ed7i do d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang. M\u1ed9t v\u1ea5n \u0111\u1ec1 ti\u1ec1m \u1ea9n kh\u00e1c c\u00f3 th\u1ec3 x\u1ea3y ra l\u00e0 vi\u1ec7c tra c\u1ee9u tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb sai c\u00f3 th\u1ec3 r\u1ea5t m\u1ea5t th\u1eddi gian n\u1ebfu kh\u00f4ng n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c. B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gi\u1ea3i ph\u00e1p th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n h\u00e0m INDEX MATCH\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">=INDEX(B4:B23,MATCH(H5,A4:A23,FALSE))<\/span><\/span>\n<p><figure id=\"attachment_34754\" aria-describedby=\"caption-attachment-34754\" style=\"width: 780px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34754 size-full\" title=\"10- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-9.png\" alt=\"10- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"780\" height=\"515\"><figcaption id=\"caption-attachment-34754\" class=\"wp-caption-text\">H\u00ecnh 10 \u2013 Gi\u1ea3i ph\u00e1p th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n h\u00e0m INDEX MATCH<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta th\u1ea5y c\u00e1ch c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cClarence\u201d v\u00e0 gi\u1ea3i quy\u1ebft h\u1ea1n ch\u1ebf th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd gi\u1ea3i th\u00edch l\u00fd do ch\u00ednh h\u00e0m INDEX MATCH l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p thay \u0111\u1ed5i c\u00f4ng th\u1ee9c.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Han_che_VLOOKUP_3\"><\/span><b>H\u1ea1n ch\u1ebf VLOOKUP 3\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c VLOOKUP \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n trong m\u1ed9t c\u1ed9t tra c\u1ee9u. Do \u0111\u00f3, ch\u00fang ta kh\u00f4ng th\u1ec3 tra c\u1ee9u c\u1ed9t v\u00e0 h\u00e0ng \u0111\u1ec3 t\u1ea1o tra c\u1ee9u t\u1ef1 \u0111\u1ed9ng. H\u00e3y xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 m\u00e0 ch\u00fang ta mu\u1ed1n bi\u1ebft t\u00ean c\u1ee7a h\u1ecdc sinh c\u00f3 th\u1ee9 h\u1ea1ng l\u00e0 \u201c3\u201d trong l\u1edbp \u201cGreen\u201d. \u0110i\u1ec1u n\u00e0y l\u00e0 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Giai_phap_da_chieu_ham_INDEX_MATCH\"><\/span><b>Gi\u1ea3i ph\u00e1p \u0111a chi\u1ec1u h\u00e0m INDEX MATCH\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, x\u00f3a t\u1ea5t c\u1ea3 th\u00f4ng tin trong \u00f4 H3:H6\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H4, nh\u1eadp \u201cGreen\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H5, nh\u1eadp\u201d 3 \u201c<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 H3, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">=INDEX(B4:E23,MATCH(H5,A4:A23,FALSE),MATCH(H4,B3:E3,FALSE))<\/span><\/span>\n<p><figure id=\"attachment_34755\" aria-describedby=\"caption-attachment-34755\" style=\"width: 778px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34755 size-full\" title=\"11- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h11-8.png\" alt=\"11- H\u00e0m Vlookup v\u00e0 h\u00e0m Index Match - H\u00e0m n\u00e0o hi\u1ec7u qu\u1ea3 h\u01a1n?\" width=\"778\" height=\"476\"><figcaption id=\"caption-attachment-34755\" class=\"wp-caption-text\">H\u00ecnh 11 \u2013 Gi\u1ea3i ph\u00e1p \u0111a chi\u1ec1u INDEX MATCH<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cAnna\u201d v\u00ec h\u00e0ng ph\u00f9 h\u1ee3p cho Student Ranking c\u1ee7a \u201c3\u201d l\u00e0 3 v\u00e0 v\u1ecb tr\u00ed c\u1ed9t ph\u00f9 h\u1ee3p cho \u201cGreen\u201d l\u00e0 3. Do \u0111\u00f3, n\u1ebfu ch\u00fang ta t\u00ecm Index c\u1ee7a H\u00e0ng 3, C\u1ed9t 3 trong b\u1ea3ng d\u1eef li\u1ec7u, ch\u00fang ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 Anna. <\/span><\/p>\n<p><em><span style=\"font-weight: 400\">C\u00e1c b\u1ea1n \u0111\u00e3 th\u1ea5y r\u00f5 qua c\u00e1c v\u00ed d\u1ee5 r\u1eb1ng<strong> h\u00e0m INDEX MATCH<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u1ed9ng v\u00e0 h\u1eefu \u00edch nh\u1ea5t trong Excel. <strong>H\u1ecdc Excel Online<\/strong> mong r\u1eb1ng b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 gi\u00fap \u00edch b\u1ea1n cho c\u00f4ng vi\u1ec7c.\u00a0<\/span><\/em><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-210.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2725,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2724"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2725"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}