{"id":3123,"date":"2024-12-02T19:47:42","date_gmt":"2024-12-02T19:47:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel\/"},"modified":"2024-12-02T19:47:42","modified_gmt":"2024-12-02T19:47:42","slug":"vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel\/","title":{"rendered":"V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-index-match\" cite=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html?ham-index-match\">\n<p><em>INDEX v\u00e0 MATCH k\u1ebft h\u1ee3p v\u1edbi nhau s\u1ebd t\u1ed1t h\u01a1n s\u1eed d\u1ee5ng VLOOKUP trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p! Trong b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c v\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p INDEX v\u00e0 MATCH s\u1ebd gi\u00fap c\u00e1c b\u1ea1n x\u1eed l\u00fd nh\u1eefng tr\u01b0\u1eddng h\u1ee3p m\u00e0 VLOOKUP kh\u00f4ng x\u1eed l\u00fd \u0111\u01b0\u1ee3c.<\/em><\/p>\n<\/blockquote>\n<p>\u201cT\u1ea1i sao l\u1ea1i h\u1ecdc th\u00eam 2 h\u00e0m n\u1eefa?\u201d. B\u1edfi v\u00ec <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><em><strong>h\u00e0m VLOOKUP<\/strong><\/em><\/a> kh\u00f4ng ph\u1ea3i l\u00e0 c\u00f4ng c\u1ee5 duy nh\u1ea5t c\u1ee7a b\u1ea1n, <strong>INDEX v\u00e0 MATCH<\/strong> s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n, nhanh h\u01a1n, \u00edt l\u1ed7i h\u01a1n. Ngo\u00e0i ra, <a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\"><em><strong>h\u00e0m INDEX MATCH<\/strong><\/em><\/a> r\u1ea5t linh ho\u1ea1t v\u00e0 c\u00f3 th\u1ec3 tu\u1ef3 bi\u1ebfn cho nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c.<\/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-674e0edd53354\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Cach_su_dung_ham_INDEX_va_MATCH_trong_Excel_co_ban\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX v\u00e0 MATCH trong Excel c\u01a1 b\u1ea3n\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX v\u00e0 MATCH trong Excel c\u01a1 b\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Ham_INDEX\" title=\"H\u00e0m INDEX\">H\u00e0m INDEX<\/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\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Ham_MATCH\" title=\"H\u00e0m MATCH\">H\u00e0m MATCH<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Su_dung_ket_hop_INDEX_va_MATCH_trong_Excel\" title=\"S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p INDEX v\u00e0 MATCH trong Excel\">S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p INDEX v\u00e0 MATCH trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Vi_sao_INDEX_va_MATCH_tot_hon_VLOOKUP\" title=\"V\u00ec sao INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n VLOOKUP\">V\u00ec sao INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n VLOOKUP<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#VLOOKUP_la_cong_thuc_1_chieu\" title=\"VLOOKUP l\u00e0 c\u00f4ng th\u1ee9c 1 chi\u1ec1u\">VLOOKUP l\u00e0 c\u00f4ng th\u1ee9c 1 chi\u1ec1u<\/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\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#VLOOKUP_se_bi_sai_neu_chung_ta_them_hoac_bot_cot_o_trong_bang_tinh\" title=\"VLOOKUP s\u1ebd b\u1ecb sai n\u1ebfu ch\u00fang ta th\u00eam ho\u1eb7c b\u1edbt c\u1ed9t \u1edf trong b\u1ea3ng t\u00ednh.\">VLOOKUP s\u1ebd b\u1ecb sai n\u1ebfu ch\u00fang ta th\u00eam ho\u1eb7c b\u1edbt c\u1ed9t \u1edf trong b\u1ea3ng t\u00ednh.<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#VLOOKUP_se_gap_kho_khan_khi_tra_cuu_2_chieu_nhu_trong_VD_sau_day\" title=\"VLOOKUP s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi tra c\u1ee9u 2 chi\u1ec1u nh\u01b0 trong VD sau \u0111\u00e2y\">VLOOKUP s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi tra c\u1ee9u 2 chi\u1ec1u nh\u01b0 trong VD sau \u0111\u00e2y<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/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\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#HAM_INDEX_VA_HAM_MATCH_TRONG_EXCEL_%E2%80%93_VI_DU_CONG_THUC\" title=\"H\u00c0M INDEX V\u00c0 H\u00c0M MATCH TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C\">H\u00c0M INDEX V\u00c0 H\u00c0M MATCH TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#CACH_TIM_KIEM_GIA_TRI_SANG_TRAI_VOI_HAM_INDEX_VA_HAM_MATCH\" title=\"C\u00c1CH T\u00ccM KI\u1ebeM GI\u00c1 TR\u1eca SANG TR\u00c1I V\u1edaI H\u00c0M INDEX V\u00c0 H\u00c0M MATCH\">C\u00c1CH T\u00ccM KI\u1ebeM GI\u00c1 TR\u1eca SANG TR\u00c1I V\u1edaI H\u00c0M INDEX V\u00c0 H\u00c0M MATCH<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Ung_dung_INDEX_va_MATCH_nang_cao\" title=\"\u1ee8ng d\u1ee5ng INDEX v\u00e0 MATCH n\u00e2ng cao\">\u1ee8ng d\u1ee5ng INDEX v\u00e0 MATCH n\u00e2ng cao<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Do_tim_du_lieu_dua_tren_nhieu_cot_dieu_kien\" title=\"D\u00f2 t\u00ecm d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u c\u1ed9t \u0111i\u1ec1u ki\u1ec7n\">D\u00f2 t\u00ecm d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u c\u1ed9t \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Con_gi_nua_sau_bai_viet_nay\" title=\"C\u00f2n g\u00ec n\u1eefa sau b\u00e0i vi\u1ebft n\u00e0y\">C\u00f2n g\u00ec n\u1eefa sau b\u00e0i vi\u1ebft n\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Tai_lieu_Excel_di_kem\" title=\"T\u00e0i li\u1ec7u Excel \u0111i k\u00e8m:\">T\u00e0i li\u1ec7u Excel \u0111i k\u00e8m:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\">\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html#Cac_kien_thuc_lien_quan\" title=\"C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 id=\"cch-s-dng-hm-index-v-match-trong-excel-c-bn\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_INDEX_va_MATCH_trong_Excel_co_ban\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX v\u00e0 MATCH trong Excel c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>V\u00ec b\u00e0i vi\u1ebft n\u00e0y t\u1eadp trung v\u00e0o nh\u1eefng tr\u01b0\u1eddng h\u1ee3p d\u00f9ng <strong>INDEX v\u00e0 MATCH<\/strong> s\u1ebd thu\u1eadn l\u1ee3i h\u01a1n vi\u1ec7c d\u00f9ng <strong>VLOOKUP<\/strong> n\u00ean \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n c\u1ee7a <strong>INDEX v\u00e0 MATCH<\/strong> m\u1eddi c\u00e1c b\u1ea1n xem video sau \u0111\u00e2y. File Excel \u0111i k\u00e8m video c\u00e1c b\u1ea1n download \u1edf cu\u1ed1i b\u00e0i.<\/p>\n<div class=\"videowrapper\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/la4n6Mox3Ts?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<h2 id=\"hm-index\"><span class=\"ez-toc-section\" id=\"Ham_INDEX\"><\/span>H\u00e0m INDEX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m <strong>INDEX<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t \u00f4 trong 1 v\u00f9ng d\u1ef1a tr\u00ean ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 ch\u1ec9 s\u1ed1 c\u1ed9t c\u1ee7a v\u00f9ng \u0111\u00f3. V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m <strong>INDEX<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\">=INDEX(v\u00f9ng_d\u1eef_li\u1ec7u, h\u00e0ng_th\u1ee9_m\u1ea5y, [c\u1ed9t_th\u1ee9_m\u1ea5y])<\/code><\/p>\n<ul>\n<li><strong><code class=\"highlighter-rouge\">v\u00f9ng_d\u1eef_li\u1ec7u<\/code><\/strong> \u2013 l\u00e0 \u0111\u1ecba ch\u1ec9 v\u00f9ng d\u1eef li\u1ec7u ch\u00fang ta mu\u1ed1n \u201cnh\u1eb7t\u201d ra 1 gi\u00e1 tr\u1ecb<\/li>\n<li><strong><code class=\"highlighter-rouge\">h\u00e0ng_th\u1ee9_m\u1ea5y<\/code><\/strong> \u2013 \u00f4 c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u n\u1eb1m \u1edf h\u00e0ng th\u1ee9 m\u1ea5y?<\/li>\n<li><strong><code class=\"highlighter-rouge\">c\u1ed9t_th\u1ee9_m\u1ea5y<\/code><\/strong> \u2013 \u00f4 c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u n\u1eb1m \u1edf c\u1ed9t th\u1ee9 m\u1ea5y?<\/li>\n<\/ul>\n<p>\u0110\u1ec3 th\u1eed d\u00f9ng h\u00e0m <strong>INDEX<\/strong> ch\u00fang ta c\u00f3 th\u1ec3 th\u1eed tr\u1ef1c ti\u1ebfp c\u00e2u l\u1ec7nh sau tr\u00ean b\u1ea3ng t\u00ednh ph\u00eda d\u01b0\u1edbi<\/p>\n<p><code class=\"highlighter-rouge\">=INDEX(A1:D10,6,3)<\/code><\/p>\n<p>H\u00e0m <strong>INDEX<\/strong> t\u00ecm d\u1eef li\u1ec7u trong v\u00f9ng <code class=\"highlighter-rouge\">A1:D10<\/code> v\u00e0 tr\u1ea3 l\u1ea1i d\u1eef li\u1ec7u trong d\u00f2ng th\u1ee9 6, c\u1ed9t th\u1ee9 3, t\u1ee9c l\u00e0 \u00f4 <code class=\"highlighter-rouge\">C6<\/code>. K\u1ebft qu\u1ea3 c\u1ee7a c\u00e2u l\u1ec7nh <strong>INDEX<\/strong> tr\u00ean s\u1ebd l\u00e0<code class=\"highlighter-rouge\">Seoul<\/code> nh\u01b0 trong \u00f4 <code class=\"highlighter-rouge\">B14<\/code><\/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-235.gif\" title=\"ex101_92019-nho-235\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n\n<h2 id=\"hm-match\"><span class=\"ez-toc-section\" id=\"Ham_MATCH\"><\/span>H\u00e0m MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m <strong>MATCH<\/strong> t\u00ecm ki\u1ebfm 1 gi\u00e1 tr\u1ecb trong 1 v\u00f9ng c\u1ee7a b\u1ea3ng t\u00ednh v\u00e0 \u0111\u01b0a l\u1ea1i <strong>v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> c\u1ee7a \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u00f3 trong v\u00f9ng t\u00ecm ki\u1ebfm. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m<strong>MATCH<\/strong> nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\">=MATCH(gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm, m\u1ea3ng_t\u00ecm_ki\u1ebfm, [ki\u1ec3u_t\u00ecm_ki\u1ebfm])<\/code><\/p>\n<ul>\n<li><strong><code class=\"highlighter-rouge\">gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm<\/code><\/strong> \u2013 gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed trong m\u1ea3ng<\/li>\n<li><strong><code class=\"highlighter-rouge\">m\u1ea3ng_t\u00ecm_ki\u1ebfm<\/code><\/strong> \u2013 m\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm<\/li>\n<li><strong><code class=\"highlighter-rouge\">ki\u1ec3u_t\u00ecm_ki\u1ebfm<\/code><\/strong> \u2013 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c hay t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t.\n<ul>\n<li><code class=\"highlighter-rouge\">1<\/code> \u2013 ho\u1eb7c b\u1ecf qua: t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t m\u00e0 gi\u00e1 tr\u1ecb \u0111\u00f3 b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n <strong>gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm<\/strong>. Gi\u00e1 tr\u1ecb trong m\u1ea3ng_t\u00ecm_ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n<\/li>\n<li><code class=\"highlighter-rouge\">0<\/code> \u2013 t\u00ecm gi\u00e1 tr\u1ecb <strong>\u0111\u1ea7u ti\u00ean<\/strong> trong m\u1ea3ng b\u1eb1ng v\u1edbi <strong>gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm<\/strong>. \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 ch\u00fang ta s\u1ebd r\u1ea5t hay d\u00f9ng khi s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p<strong>INDEX\/MATCH<\/strong><\/li>\n<li><code class=\"highlighter-rouge\">-1<\/code> \u2013 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t m\u00e0 gi\u00e1 tr\u1ecb \u0111\u00f3 l\u01a1n h\u01a1n ho\u1eb7c b\u1eb1ng <strong>gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Khi \u0111\u1ecdc \u0111\u1ebfn \u0111\u00e2y, ch\u1eafc c\u00e1c b\u1ea1n s\u1ebd t\u1ef1 h\u1ecfi l\u00e0 <strong>C\u00e1i h\u00e0m MATCH n\u00e0y h\u00ecnh nh\u01b0 kh\u00f4ng t\u00e1c d\u1ee5ng l\u1eafm th\u00ec ph\u1ea3i<\/strong>. \u0110\u00fang th\u1ebf, n\u1ebfu ch\u1ec9 nh\u01b0 v\u1eady th\u00ec <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\"><em><strong>h\u00e0m MATCH<\/strong><\/em><\/a> kh\u00f4ng c\u00f3 nhi\u1ec1u t\u00e1c d\u1ee5ng l\u1eafm. Nh\u01b0ng \u1edf ph\u1ea7n ti\u1ebfp theo, khi k\u1ebft h\u1ee3p c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\"><em><strong>h\u00e0m INDEX<\/strong><\/em><\/a> th\u00ec ch\u00fang ta h\u00e3y xem xem c\u1eb7p \u0111\u00f4i n\u00e0y l\u00e0m g\u00ec \u0111\u01b0\u1ee3c cho c\u00e1c b\u1ea1n.<\/p>\n<h2><\/h2>\n<h1 id=\"s-dng-kt-hp-index-v-match-trong-excel\"><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_INDEX_va_MATCH_trong_Excel\"><\/span>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p INDEX v\u00e0 MATCH trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Ch\u00fang ta s\u1ebd \u0111i l\u00e0m ngay m\u1ed9t v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m <strong>INDEX v\u00e0 MATCH<\/strong> trong Excel nh\u01b0 th\u1ebf n\u00e0o. Ch\u00fang ta c\u00f3 b\u1ea3ng Excel sau \u0111\u00e2y:<\/p>\n\n<p>Ch\u00fang ta mu\u1ed1n \u0111i t\u00ecm ki\u1ebfm xem <strong>n\u01b0\u1edbc n\u00e0o c\u00f3 th\u1ee7 \u0111\u00f4 l\u00e0 Seoul<\/strong> trong b\u1ea3ng n\u00e0y. C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm ra \u0111i\u1ec1u \u0111\u00f3 nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\">=INDEX(B1:B10,MATCH(\"Seoul\",C1:C10,0)<\/code><\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li><code class=\"highlighter-rouge\">B1:B10<\/code> l\u00e0 c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta mu\u1ed1n tra c\u1ee9u, t\u00ecm ki\u1ebfm ho\u1eb7c tr\u00edch l\u1ecdc<\/li>\n<li><code class=\"highlighter-rouge\">MATCH(\"Seoul\",C1:C10,0)<\/code> s\u1ebd cho ch\u00fang ta bi\u1ebft <strong>Seoul<\/strong> \u1edf v\u1ecb tr\u00ed h\u00e0ng th\u1ee9 m\u1ea5y \u1edf trong b\u1ea3ng t\u00ednh tr\u00ean. K\u1ebft qu\u1ea3 <strong>Seoul<\/strong> \u1edf v\u1ecb tr\u00ed h\u00e0ng th\u1ee9 6 trong b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c v\u1edbi INDEX tr\u1edf th\u00e0nh: <code class=\"highlighter-rouge\">INDEX(B1:B10,6)<\/code><\/li>\n<li>Khi k\u1ebft h\u1ee3p 2 c\u00f4ng th\u1ee9c n\u00e0y l\u1ea1i v\u00e0 do t\u00ednh ch\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh, <strong>Seoul<\/strong> s\u1ebd ph\u1ea3i n\u1eb1m c\u00f9ng d\u00f2ng v\u1edbi <strong>n\u01b0\u1edbc c\u00f3 th\u1ee7 \u0111\u00f4 l\u00e0 Seoul<\/strong> n\u00ean ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 t\u00ecm ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 <strong>H\u00e0n Qu\u1ed1c<\/strong><\/li>\n<\/ul>\n<p>T\u1ed5ng qu\u00e1t l\u1ea1i th\u00ec ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p><code class=\"highlighter-rouge\">=INDEX( c\u1ed9t c\u1ea7n tra c\u1ee9u gi\u00e1 tr\u1ecb, (MATCH ( gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 tra c\u1ee9u, c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0y, 0 ))<\/code><\/p>\n<p>V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh <strong>INDEX v\u00e0 MATCH<\/strong> trong b\u1ea3ng t\u00ednh Excel online ph\u00eda tr\u00ean. Khi c\u00e1c b\u1ea1n \u0111\u00e3 <em>ch\u1eafc tay<\/em> v\u1edbi <strong>INDEX v\u00e0 MATCH* ch\u00fang ta s\u1ebd xem ph\u1ea7n ti\u1ebfp theo t\u1ea1i sao **INDEX v\u00e0 MATCH<\/strong> l\u1ea1i t\u1ed1t h\u01a1n <strong>VLOOKUP<\/strong> \u1edf nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p>\u00a0<\/p>\n<h1 id=\"v-sao-index-v-match-tt-hn-vlookup\"><span class=\"ez-toc-section\" id=\"Vi_sao_INDEX_va_MATCH_tot_hon_VLOOKUP\"><\/span>V\u00ec sao INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2 id=\"vlookup-l-cng-thc-1-chiu\"><span class=\"ez-toc-section\" id=\"VLOOKUP_la_cong_thuc_1_chieu\"><\/span>VLOOKUP l\u00e0 c\u00f4ng th\u1ee9c 1 chi\u1ec1u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi <strong>VLOOKUP<\/strong>, ch\u00fang ta ch\u1ec9 c\u00f3 th\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb tr\u00e1i qua ph\u1ea3i. Trong v\u00ed d\u1ee5 t\u00ecm n\u01b0\u1edbc c\u00f3 th\u1ee7 \u0111\u00f4 l\u00e0 Seoul \u1edf tr\u00ean, ch\u00fang ta s\u1ebd kh\u00f4ng d\u00f9ng<strong>VLOOKUP<\/strong> \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ra H\u00e0n Qu\u1ed1c \u0111\u01b0\u1ee3c. Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 th\u1ea5y, <strong>INDEX v\u00e0 MATCH<\/strong> l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y.<\/p>\n<h2 id=\"vlookup-s-b-sai-nu-chng-ta-thm-hoc-bt-ct--trong-bng-tnh\"><span class=\"ez-toc-section\" id=\"VLOOKUP_se_bi_sai_neu_chung_ta_them_hoac_bot_cot_o_trong_bang_tinh\"><\/span>VLOOKUP s\u1ebd b\u1ecb sai n\u1ebfu ch\u00fang ta th\u00eam ho\u1eb7c b\u1edbt c\u1ed9t \u1edf trong b\u1ea3ng t\u00ednh.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1i n\u00e0y th\u00ec r\u00f5 r\u00e0ng r\u1ed3i, b\u1edfi v\u00ec khi d\u00f9ng <strong>VLOOKUP<\/strong> c\u00e1c b\u1ea1n ph\u1ea3i ch\u1ec9 ra c\u1ed9t n\u00e0o ch\u00fang ta mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb v\u1ec1. Khi th\u00eam ho\u1eb7c b\u1edbt 1 c\u1ed9t \u1edf gi\u1eefa c\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 c\u1ed9t c\u1ea7n l\u1ea5y gi\u00e1 tr\u1ecb v\u1ec1 th\u00ec c\u1ed9t c\u1ea7n l\u1ea5y gi\u00e1 tr\u1ecb b\u1ecb x\u00ea d\u1ecbch \u0111i, d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m <strong>VLOOKUP<\/strong> kh\u00f4ng \u0111\u00fang n\u1eefa. V\u1edbi <strong>INDEX v\u00e0 MATCH<\/strong> th\u00ec \u0111i\u1ec1u n\u00e0y kh\u00f4ng x\u1ea3y ra v\u00ec khi th\u00eam\/b\u1edbt c\u1ed9t th\u00ec c\u00f4ng th\u1ee9c trong h\u00e0m <strong>INDEX v\u00e0 MATCH<\/strong> s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh theo.<\/p>\n<h4 id=\"vlookup-s-gp-kh-khn-khi-tra-cu-2-chiu-nh-trong-vd-sau-y\"><span class=\"ez-toc-section\" id=\"VLOOKUP_se_gap_kho_khan_khi_tra_cuu_2_chieu_nhu_trong_VD_sau_day\"><\/span>VLOOKUP s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi tra c\u1ee9u 2 chi\u1ec1u nh\u01b0 trong VD sau \u0111\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 m\u1edf <code class=\"highlighter-rouge\">Sheet2<\/code> trong b\u1ea3ng t\u00ednh ph\u00eda tr\u00ean ra. N\u1ebfu ch\u00fang ta mu\u1ed1n tra c\u1ee9u d\u00e2n s\u1ed1 c\u1ee7a Seoul v\u00e0o n\u0103m 2001 th\u00ec trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng <strong>VLOOKUP<\/strong> \u2013 m\u1ed9t c\u00e1ch kh\u00f3 kh\u0103n, nh\u01b0ng d\u00f9ng <strong>INDEX v\u00e0 MATCH<\/strong> s\u1ebd nhanh g\u1ecdn h\u01a1n nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\">=INDEX(A1:F10,MATCH(\"Seoul\",C1:C10,0),MATCH(\"N\u0103m 2001\",A1:F1,0))<\/code><\/p>\n<ul>\n<li><strong>H\u00e0m Match<\/strong> \u0111\u1ea7u ti\u00ean s\u1ebd cho ch\u00fang ta bi\u1ebft th\u1ee7 \u0111\u00f4 <strong>Seoul<\/strong> c\u1ee7a H\u00e0n Qu\u1ed1c n\u1eb1m \u1edf d\u00f2ng th\u1ee9 m\u1ea5y<\/li>\n<li><strong>H\u00e0m Match<\/strong> th\u1ee9 hai s\u1ebd cho ch\u00fang ta bi\u1ebft d\u1eef li\u1ec7u d\u00e2n s\u1ed1 c\u1ee7a <strong>N\u0103m 2001<\/strong> n\u1eb1m \u1edf c\u1ed9t n\u00e0o<\/li>\n<li><strong>H\u00e0m Index<\/strong> s\u1ebd s\u1eed d\u1ee5ng 2 th\u00f4ng tin tr\u00ean v\u00e0 t\u00ecm ra d\u1eef li\u1ec7u ch\u00ednh x\u00e1c cho ch\u00fang ta.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_INDEX_VA_HAM_MATCH_TRONG_EXCEL_%E2%80%93_VI_DU_CONG_THUC\"><\/span>H\u00c0M INDEX V\u00c0 H\u00c0M MATCH TRONG EXCEL \u2013 V\u00cd D\u1ee4 C\u00d4NG TH\u1ee8C<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n \u0111\u00e3 bi\u1ebft l\u00fd do n\u00ean h\u1ecdc h\u00e0m MATCH\/INDEX, n\u00ean h\u00e3y \u0111i v\u00e0o ph\u1ea7n th\u00fa v\u1ecb nh\u1ea5t v\u00e0 xem xem b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nguy\u00ean l\u00fd hay kh\u00f4ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_TIM_KIEM_GIA_TRI_SANG_TRAI_VOI_HAM_INDEX_VA_HAM_MATCH\"><\/span>C\u00c1CH T\u00ccM KI\u1ebeM GI\u00c1 TR\u1eca SANG TR\u00c1I V\u1edaI H\u00c0M INDEX V\u00c0 H\u00c0M MATCH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eafc \u0111\u1ebfn trong b\u1ea5t k\u1ef3 b\u00e0i h\u01b0\u1edbng d\u1eabn VLOOKUP n\u00e0o, h\u00e0m Excel n\u00e0y kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm b\u00ean tr\u00e1i c\u1ee7a n\u00f3. V\u00ec v\u1eady, n\u1ebfu c\u1ed9t c\u1ea7n t\u00ecm c\u1ee7a b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0 c\u1ed9t c\u1eadn tr\u00e1i trong d\u1ea3i \u00f4 c\u1ea7n t\u00ecm, th\u00ec kh\u00f4ng bao gi\u1edd c\u00f4ng th\u1ee9c VLOOKUP tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">H\u00e0m INDEX MATCH trong Excel th\u00ec linh ho\u1ea1t h\u01a1n v\u00e0 th\u1eadt s\u1ef1 kh\u00f4ng quan t\u00e2m vi\u1ec7c c\u1ed9t tr\u1ea3 v\u1ec1 n\u1eb1m \u1edf \u0111\u00e2u. V\u00ed d\u1ee5, ch\u00fang ta s\u1ebd d\u00f9ng m\u1ed9t b\u1ea3ng \u2013 b\u1ea3ng n\u00e0y li\u1ec7t k\u00ea th\u1ee7 \u0111\u00f4 v\u00e0 d\u00e2n s\u1ed1. L\u1ea7n n\u00e0y, h\u00e3y l\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c INDEX MATCH t\u00ecm xem th\u1ee7 \u0111\u00f4 c\u1ee7a Nga, Matxc\u01a1va, x\u1ebfp th\u1ee9 m\u1ea5y d\u1ef1a theo d\u00e2n s\u1ed1.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u1eeb \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u00f4ng th\u1ee9c sau \u0111\u00e2y ho\u1ea1t \u0111\u1ed9ng m\u1ed9t c\u00e1ch tr\u00f4i ch\u1ea3y:<\/p>\n<p style=\"text-align: justify\">=INDEX($A$2:$A$10,MATCH(\u201cRussia\u201d,$B$2:$B$10,0))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6268 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/103-300x129-2.png\" width=\"300\" height=\"129\" title=\"103-300x129-2\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, c\u00f3 l\u1ebd b\u1ea1n ch\u1eb3ng g\u1eb7p ch\u00fat kh\u00f3 kh\u0103n n\u00e0o trong vi\u1ec7c hi\u1ec3u c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, b\u1ea1n l\u1eadp c\u00f4ng th\u1ee9c MATCH \u0111\u01a1n gi\u1ea3n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a Nga:<\/p>\n<p style=\"text-align: justify\">=MATCH(\u201cRussia\u201d,$B$2:$B$10,0))<\/p>\n<p style=\"text-align: justify\">R\u1ed3i, b\u1ea1n x\u00e1c \u0111\u1ecbnh th\u00f4ng s\u1ed1 m\u1ea3ng cho h\u00e0m INDEX, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u1ed9t A (A2:A10).<\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n k\u1ebft h\u1ee3p hai ph\u1ea7n l\u1ea1i v\u00e0 c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\">=INDEX($A$2:$A$10,MATCH(\u201cRussia\u201d,$B$2:$B$10,0))<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. Vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i lu\u00f4n l\u00e0 m\u1ed9t \u00fd t\u01b0\u1edfng hay trong c\u00f4ng th\u1ee9c INDEX v\u00e0 MATCH \u0111\u1ec3 d\u1ea3i \u00f4 c\u1ea7n t\u00ecm c\u1ee7a b\u1ea1n kh\u00f4ng b\u1ecb ph\u00e1 h\u1ecfng khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c sang \u00f4 kh\u00e1c.<\/p>\n<h1 id=\"ng-dng-index-v-match-nng-cao\"><span class=\"ez-toc-section\" id=\"Ung_dung_INDEX_va_MATCH_nang_cao\"><\/span>\u1ee8ng d\u1ee5ng INDEX v\u00e0 MATCH n\u00e2ng cao<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2 id=\"d-tm-d-liu-da-trn-nhiu-ct-iu-kin\"><span class=\"ez-toc-section\" id=\"Do_tim_du_lieu_dua_tren_nhieu_cot_dieu_kien\"><\/span>D\u00f2 t\u00ecm d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u c\u1ed9t \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n h\u00e3y m\u1edf <code class=\"highlighter-rouge\">Sheet3<\/code> trong b\u1ea3ng t\u00ednh sau \u0111\u00e2y:<\/p>\n\n<p>Y\u00eau c\u1ea7u b\u00e0i n\u00e0y l\u00e0 ch\u00fang ta ph\u1ea3i \u0111i\u1ec1n v\u00e0o <code class=\"highlighter-rouge\">D5:D16<\/code> d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u1edf <code class=\"highlighter-rouge\">b\u1ea3ng tra c\u1ee9u<\/code>. C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\"><span class=\"p\">{<\/span><span class=\"err\">=INDEX($F$5:$H$16,MATCH(1,(A5=$F$5:$F$16)*(B5=$G$5:$G$16),0),3)<\/span><span class=\"p\">}<\/span><\/code><\/p>\n<ul>\n<li>D\u1ea5u <code class=\"highlighter-rouge\"><span class=\"p\">{}<\/span><\/code> \u2013 th\u1ec3 hi\u1ec7n r\u1eb1ng \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, c\u00e1c b\u1ea1n khi nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng c\u1ea7n s\u1eed d\u1ee5ng ph\u00edm \u0111\u1eb7c bi\u1ec7t c\u1ee7a Excel l\u00e0 <strong><code class=\"highlighter-rouge\">CTRL + SHIFT + ENTER<\/code><\/strong>. Khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o Excel, c\u00e1c b\u1ea1n nh\u1eadp b\u00ecnh th\u01b0\u1eddng, kh\u00f4ng c\u1ea7n d\u1ea5u <code class=\"highlighter-rouge\"><span class=\"p\">{}<\/span><\/code> v\u00e0 s\u1eed d\u1ee5ng ph\u00edm <strong><code class=\"highlighter-rouge\">CTRL + SHIFT + ENTER<\/code><\/strong>.<\/li>\n<li>C\u00f4ng th\u1ee9c tr\u00ean ch\u01b0a \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 tr\u1ef1c ti\u1ebfp trong phi\u00ean b\u1ea3n hi\u1ec7n t\u1ea1i c\u1ee7a Excel Online, n\u1ebfu b\u1ea1n mu\u1ed1n th\u1eed, c\u00f3 th\u1ec3 copy b\u1ea3ng t\u00ednh n\u00e0y v\u1ec1 Excel c\u1ee7a b\u1ea1n v\u00e0 th\u1eed c\u00f4ng th\u1ee9c \u0111\u00f3.<\/li>\n<\/ul>\n<ul>\n<li>Trong c\u00f4ng th\u1ee9c tr\u00ean, ph\u1ea7n kh\u00f3 nh\u1ea5t l\u00e0 ph\u1ea7n c\u00f3 <strong>h\u00e0m Match<\/strong> \u2013 <code class=\"highlighter-rouge\">MATCH(1,(A5=$F$5:$F$16)*(B5=$G$5:$G$16),0)<\/code>:\n<ul>\n<li><code class=\"highlighter-rouge\">(A5=$F$5:$F$16)<\/code> : Ch\u00fang ta \u0111i so s\u00e1nh gi\u00e1 tr\u1ecb c\u1ee7a <code class=\"highlighter-rouge\">A5<\/code> v\u1edbi v\u00f9ng <code class=\"highlighter-rouge\">$F$5:$F$16<\/code>. K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0<code class=\"highlighter-rouge\"><span class=\"p\">{<\/span><span class=\"err\">FALSE;TRUE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE<\/span><span class=\"p\">}<\/span><\/code><\/li>\n<li><code class=\"highlighter-rouge\">(B5=$G$5:$G$16)<\/code> : Ch\u00fang ta \u0111i so s\u00e1nh gi\u00e1 tr\u1ecb c\u1ee7a <code class=\"highlighter-rouge\">B5<\/code> v\u1edbi v\u00f9ng <code class=\"highlighter-rouge\">$G$5:$G$16<\/code>. K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0<code class=\"highlighter-rouge\"><span class=\"p\">{<\/span><span class=\"err\">FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;TRUE;FALSE<\/span><span class=\"p\">}<\/span><\/code><\/li>\n<li>(A5=$F$5:$F$16)*(B5=$G$5:$G$16) : K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh n\u00e0y l\u00e0<code class=\"highlighter-rouge\"><span class=\"p\">{<\/span><span class=\"err\">0;1;0;0;0;0;0;0;0;0;0;0<\/span><span class=\"p\">}<\/span><\/code><\/li>\n<li>Do \u0111\u00f3 <strong>H\u00e0m Match<\/strong> c\u1ee7a ch\u00fang ta t\u1eeb <code class=\"highlighter-rouge\">MATCH(1,(A5=$F$5:$F$16)*(B5=$G$5:$G$16),0)<\/code> tr\u1edf th\u00e0nh:<code class=\"highlighter-rouge\">MATCH(1,{0;1;0;0;0;0;0;0;0;0;0;0},0)<\/code>k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m match n\u00e0y l\u00e0 2, d\u00f2ng th\u1ee9 2 trong b\u1ea3ng tra c\u1ee9u s\u1ebd tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n <strong>Dan Brown<\/strong> v\u00e0 <strong>T\u00e1o<\/strong>, <strong>T\u1ed5ng<\/strong> ph\u1ea3i t\u00ecm l\u00e0 <strong>271<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1 id=\"cn-g-na-sau-bi-vit-ny\"><span class=\"ez-toc-section\" id=\"Con_gi_nua_sau_bai_viet_nay\"><\/span>C\u00f2n g\u00ec n\u1eefa sau b\u00e0i vi\u1ebft n\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, ch\u1eafc c\u00e1c b\u1ea1n c\u0169ng \u0111\u00e3 bi\u1ebft l\u00e0 ngo\u00e0i <strong>VLOOKUP<\/strong> ra th\u00ec c\u00f2n m\u1ed9t c\u00f4ng th\u1ee9c <em>kh\u00f3 d\u00f9ng<\/em> kh\u00e1c n\u1eefa l\u00e0 <strong>INDEX v\u00e0 MATCH<\/strong> c\u0169ng kh\u00e1 l\u00e0 c\u00f3 \u00edch khi m\u00e0 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p VLOOKUP kh\u00f4ng x\u1eed l\u00fd \u0111\u01b0\u1ee3c. Mong \u0111\u00e2y l\u00e0 b\u01b0\u1edbc kh\u1edfi \u0111\u1ea7u t\u1ed1t cho c\u00e1c b\u1ea1n. N\u1ebfu b\u1ea1n \u0111\u00e3 \u0111\u1ecdc \u0111\u1ebfn \u0111\u00e2y, c\u1ea3m \u01a1n b\u1ea1n r\u1ea5t nhi\u1ec1u.<\/p>\n<p>\u00a0<\/p>\n<h1 id=\"ti-liu-excel-i-km\"><span class=\"ez-toc-section\" id=\"Tai_lieu_Excel_di_kem\"><\/span>T\u00e0i li\u1ec7u Excel \u0111i k\u00e8m:<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u2022 <a href=\"https:\/\/www.dropbox.com\/s\/epubmroybn097g4\/52%20Match_index.xlsx?dl=0\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m Index v\u00e0 Match trong Excel \u2013 1<\/a><\/p>\n<p>\u2022 <a href=\"https:\/\/www.dropbox.com\/s\/kkybpadxyypnb9f\/53%20su%20dung%20index%20va%20match%20de%20filter%20bang%20tinh.xlsx?dl=0\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m Index v\u00e0 Match trong Excel \u2013 2<\/a><\/p>\n<h3 id=\"cc-kin-thc-lin-quan\"><span class=\"ez-toc-section\" id=\"Cac_kien_thuc_lien_quan\"><\/span>C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u2022 <a href=\"https:\/\/blog.hocexcel.online\/2015\/01\/18\/b52-cach-su-dung-index-va-match-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m Index v\u00e0 Match c\u01a1 b\u1ea3n<\/a><\/p>\n<p>\u2022 <a href=\"https:\/\/blog.hocexcel.online\/2015\/03\/04\/b53-su-dung-ham-index-va-match-de-loc-du-lieu-nang-cao-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m Index v\u00e0 Match n\u00e2ng cao<\/a><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c <strong><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\"><em>kh\u00f3a h\u1ecdc\u00a0Excel<\/em><\/a> t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/strong> c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><em><strong>H\u1ecdc Excel Online<\/strong><\/em><\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng: v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y.<\/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-235.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3123","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=3123"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3124"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}