{"id":9231,"date":"2025-01-01T22:42:46","date_gmt":"2025-01-01T22:42:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai\/"},"modified":"2025-01-01T22:42:46","modified_gmt":"2025-01-01T22:42:46","slug":"huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m INDEX v\u00e0 MATCH qua b\u00e0i t\u1eadp c\u00f3 l\u1eddi gi\u1ea3i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m Index v\u00e0 Match l\u00e0 hai h\u00e0m r\u1ea5t\u00a0\u0111\u1eb7c bi\u1ec7t\u00a0trong\u00a0Excel m\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 thay th\u1ebf\u00a0\u0111\u01b0\u1ee3c cho h\u00e0m VLOOKUP. \u0110\u1ec3 n\u1eafm r\u00f5 h\u01a1n c\u00e1ch s\u1eed d\u1ee5ng c\u0169ng nh\u01b0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a hai h\u00e0m n\u00e0y,\u00a0ch\u00fang ta s\u1ebd c\u00f9ng luy\u1ec7n t\u1eadp c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX v\u00e0 MATCH th\u00f4ng qua c\u00e1c b\u00e0i t\u1eadp k\u00e8m theo l\u1eddi gi\u1ea3i nh\u00e9.<\/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-6775c4e52e59d\" 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\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html#Bai_tap_1_Su_dung_ham_MATCH_tim_vi_tri_theo_dong_cot\" title=\"B\u00e0i t\u1eadp 1: S\u1eed d\u1ee5ng h\u00e0m MATCH t\u00ecm v\u1ecb tr\u00ed theo d\u00f2ng, c\u1ed9t\">B\u00e0i t\u1eadp 1: S\u1eed d\u1ee5ng h\u00e0m MATCH t\u00ecm v\u1ecb tr\u00ed theo d\u00f2ng, c\u1ed9t<\/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\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html#Bai_tap_2_Ket_hop_ham_INDEX_voi_MATCH_tim_Email_theo_ten\" title=\"B\u00e0i t\u1eadp 2:\u00a0K\u1ebft h\u1ee3p h\u00e0m INDEX v\u1edbi MATCH t\u00ecm Email theo t\u00ean\">B\u00e0i t\u1eadp 2:\u00a0K\u1ebft h\u1ee3p h\u00e0m INDEX v\u1edbi MATCH t\u00ecm Email theo t\u00ean<\/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\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html#Bai_tap_3_Do_tim_tu_phai_qua_trai_voi_ham_INDEX_ket_hop_MATCH\" title=\"B\u00e0i t\u1eadp 3: D\u00f2 t\u00ecm t\u1eeb ph\u1ea3i qua tr\u00e1i v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p MATCH\">B\u00e0i t\u1eadp 3: D\u00f2 t\u00ecm t\u1eeb ph\u1ea3i qua tr\u00e1i v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p MATCH<\/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\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html#Bai_tap_4_Xac_dinh_don_gia_cua_mat_hang_theo_nhieu_dieu_kien\" title=\"B\u00e0i t\u1eadp 4: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a m\u1eb7t h\u00e0ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\">B\u00e0i t\u1eadp 4: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a m\u1eb7t h\u00e0ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<\/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\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_tap_1_Su_dung_ham_MATCH_tim_vi_tri_theo_dong_cot\"><\/span>B\u00e0i t\u1eadp 1: S\u1eed d\u1ee5ng h\u00e0m MATCH t\u00ecm v\u1ecb tr\u00ed theo d\u00f2ng, c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng t\u00ednh sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25165\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bai-tap-dung-ham-index-match.png\" width=\"714\" height=\"236\" title=\"bai-tap-dung-ham-index-match\"><\/p>\n<p>N\u1ebfu mu\u1ed1n bi\u1ebft th\u00f4ng tin c\u1ee7a ng\u01b0\u1eddi c\u00f3 t\u00ean \u201cL\u00ea Th\u1ecb Th\u1ee7y\u201d\u00a0th\u00ec b\u1ea1n phai l\u00e0m th\u1ebf n\u00e0o? Ch\u1eafc h\u1eb3n vi\u1ec7c\u00a0\u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh xem ng\u01b0\u1eddi\u00a0\u0111\u00f3 n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y trong b\u1ea3ng t\u00ednh n\u00e0y.<\/p>\n<p>B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-match-trong-excel.html\">h\u00e0m MATCH<\/a>, b\u1ea1n s\u1ebd bi\u1ebft\u00a0\u0111\u01b0\u1ee3c 1 ng\u01b0\u1eddi\u00a0n\u00e0o\u00a0\u0111\u00f3 n\u1eb1m\u00a0\u1edf d\u00f2ng th\u1ee9 m\u1ea5y trong b\u1ea3ng.<\/p>\n<p>Ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"padding-left: 30px\">=MATCH(\u201cL\u00ea Th\u1ecb Th\u1ee7y\u201d, c\u1ed9t H\u1ecd t\u00ean, s\u1ed1 0)<\/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\/2025\/01\/ex101_92019-nho-25.gif\" title=\"ex101_92019-nho-25\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25167\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ung-dung-01-ham-match-tim-ten.png\" width=\"823\" height=\"434\" title=\"ung-dung-01-ham-match-tim-ten\"><\/p>\n<p>\u00a0<\/p>\n<ul>\n<li>T\u1ea1i\u00a0\u00f4 D12 nh\u1eadp t\u00ean L\u00ea Th\u1ecb Th\u1ee7y<\/li>\n<li>c\u1ed9t H\u1ecd t\u00ean l\u00e0 v\u00f9ng C3:C8<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady h\u00e0m MATCH cho k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 3, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi d\u00f2ng th\u1ee9 3 trong b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean.<\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-match-trong-excel.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH trong Excel<\/a><\/p>\n<p>V\u1eady vi\u1ec7c t\u00ecm ra\u00a0s\u1ed1 3 th\u00ec c\u00f3\u00a0\u00fd ngh\u0129a g\u00ec? Hay n\u00f3i c\u00e1ch kh\u00e1c bi\u1ebft ng\u01b0\u1eddi\u00a0\u0111\u00f3\u00a0\u1edf v\u1ecb tr\u00ed d\u00f2ng th\u1ee9 3 trong b\u1ea3ng th\u00ec c\u00f3 t\u00e1c d\u1ee5ng g\u00ec?<\/p>\n<p>\u0110\u1ec3 tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi n\u00e0y, ch\u00fang ta xem ti\u1ebfp y\u00eau c\u1ea7u d\u01b0\u1edbi\u00a0\u0111\u00e2y<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bai_tap_2_Ket_hop_ham_INDEX_voi_MATCH_tim_Email_theo_ten\"><\/span>B\u00e0i t\u1eadp 2:\u00a0K\u1ebft h\u1ee3p h\u00e0m INDEX v\u1edbi MATCH t\u00ecm Email theo t\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi nh\u00ecn v\u00e0o b\u1ea3ng tr\u00ean, ta th\u1ea5y t\u1ea1i v\u1ecb tr\u00ed d\u00f2ng 3, trong c\u1ed9t Email s\u1ebd xu\u1ea5t hi\u1ec7n Email c\u1ea7n t\u00ecm. Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 hi\u1ec3u: Ch\u1ec9 c\u1ea7n d\u00f3ng theo c\u1ed9t Email, t\u1ea1i v\u1ecb tr\u00ed d\u00f2ng 3 trong b\u1ea3ng l\u00e0 ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm.<\/p>\n<p>\u0110i\u1ec1u\u00a0\u0111\u00f3 ch\u00ednh l\u00e0 c\u00e1ch k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\">h\u00e0m INDEX<\/a> v\u1edbi MATCH:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25168\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ung-dung-02-ham-index-match-tim-email.png\" width=\"826\" height=\"460\" title=\"ung-dung-02-ham-index-match-tim-email\"><\/p>\n<p>Trong c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 D15 t\u00ecm Email, ch\u00fang ta th\u1ea5y:<\/p>\n<p style=\"padding-left: 30px\">=INDEX(E3:E8,MATCH(D12,C3:C8,0))<\/p>\n<p>C\u00f4ng th\u1ee9c n\u00e0y, h\u00e0m INDEX c\u00f3 nhi\u1ec7m v\u1ee5:<\/p>\n<ul>\n<li>Ch\u1ec9 ra c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm l\u00e0 c\u1ed9t E, v\u00f9ng E3:E8<\/li>\n<li>Ch\u1ec9 ra d\u00f2ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, d\u00f2ng n\u00e0y\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m MATCH\u00a0\u1edf tr\u00ean<\/li>\n<\/ul>\n<p>Giao\u00a0\u0111i\u1ec3m gi\u1eefa d\u00f2ng v\u00e0 c\u1ed9t trong h\u00e0m INDEX\u00a0t\u00ecm ch\u00ednh l\u00e0 k\u1ebft qu\u1ea3 email c\u1ea7n t\u00ecm.<\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\">6 t\u00ednh n\u0103ng hi\u1ec7u qu\u1ea3 nh\u1ea5t c\u1ee7a h\u00e0m INDEX trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bai_tap_3_Do_tim_tu_phai_qua_trai_voi_ham_INDEX_ket_hop_MATCH\"><\/span>B\u00e0i t\u1eadp 3: D\u00f2 t\u00ecm t\u1eeb ph\u1ea3i qua tr\u00e1i v\u1edbi h\u00e0m INDEX k\u1ebft h\u1ee3p MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta hay d\u00f2 t\u00ecm theo chi\u1ec1u t\u1eeb Tr\u00e1i qua Ph\u1ea3i. Nh\u01b0ng n\u1ebfu ph\u1ea3i t\u00ecm t\u1eeb Ph\u1ea3i qua Tr\u00e1i (ng\u01b0\u1ee3c l\u1ea1i v\u1edbi th\u00f4ng th\u01b0\u1eddng) th\u00ec l\u00e0m th\u1ebf n\u00e0o?<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau: T\u00ecm t\u00ean d\u1ef1a v\u00e0o th\u00f4ng tin Email?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25169\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ung-dung-03-ham-index-match-tim-ho-ten-theo-email.png\" width=\"847\" height=\"468\" title=\"ung-dung-03-ham-index-match-tim-ho-ten-theo-email\"><\/p>\n<p>C\u1ed9t Email l\u00e0 c\u1ed9t th\u1ee9 3, n\u1eb1m b\u00ean ph\u1ea3i c\u1ed9t H\u1ecd t\u00ean (c\u1ed9t th\u1ee9 1).<\/p>\n<p>Nh\u01b0 v\u1eady\u00a0\u0111\u1ec3 d\u00f2 t\u00ecm h\u1ecd t\u00ean d\u1ef1a v\u00e0o Email t\u1ee9c l\u00e0 ch\u00fang ta\u00a0\u0111ang t\u00ecm t\u1eeb Ph\u1ea3i qua tr\u00e1i.<\/p>\n<p>Qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>D\u00f9ng h\u00e0m MATCH\u00a0\u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed d\u00f2ng c\u1ee7a email trong\u00a0c\u1ed9t Email =MATCH(Email, v\u00f9ng ch\u1ee9a Email, 0)<\/li>\n<li>K\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDEX trong vi\u1ec7c ch\u1ec9 ra v\u1ecb tr\u00ed c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm, l\u00e0 c\u1ed9t H\u1ecd t\u00ean (c\u1ed9t\u00a0C), v\u00f9ng C3:C8<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">=INDEX(C3:C8,MATCH(D12,E3:E8,0))<\/p>\n<p>R\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bai_tap_4_Xac_dinh_don_gia_cua_mat_hang_theo_nhieu_dieu_kien\"><\/span>B\u00e0i t\u1eadp 4: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a m\u1eb7t h\u00e0ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ta c\u00f3 b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25170\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bai-tap-tim-don-gia-cua-mat-hang-theo-nhieu-dk.png\" width=\"796\" height=\"237\" title=\"bai-tap-tim-don-gia-cua-mat-hang-theo-nhieu-dk\"><\/p>\n<p>L\u00e0m c\u00e1ch n\u00e0o x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a 1 m\u00e3 h\u00e0ng b\u1ea5t k\u1ef3, trong 1 c\u00f4ng ty b\u1ea5t k\u1ef3?<\/p>\n<p>\u0110i\u1ec1u n\u00e0y t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng vi\u1ec7c ch\u00fang ta ph\u1ea3i x\u00e9t\u00a0\u0111\u1ed3ng th\u1eddi 2\u00a0\u0111i\u1ec1u ki\u1ec7n: M\u00e3 h\u00e0ng v\u00e0 M\u00e3 c\u00f4ng ty<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta s\u1ebd\u00a0s\u1eed d\u1ee5ng h\u00e0m Index k\u1ebft h\u1ee3p h\u00e0m Match nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed M\u00e3 h\u00e0ng n\u1eb1m tr\u00ean\u00a0c\u1ed9t th\u1ee9 m\u1ea5y trong b\u1ea3ng<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25171\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b1-dung-ham-match-xac-dinh-cot-ket-qua-1024x253-1.png\" width=\"1024\" height=\"253\" title=\"b1-dung-ham-match-xac-dinh-cot-ket-qua-1024x253-1\"><\/p>\n<ul>\n<li>Tham chi\u1ebfu gi\u00e1 tr\u1ecb M\u00e3 h\u00e0ng trong d\u00f2ng 3 (d\u00f2ng ch\u1ee9a th\u00f4ng tin m\u00e3 h\u00e0ng l\u00e0m c\u0103n c\u1ee9\u00a0\u0111\u1ed1i chi\u1ebfu)<\/li>\n<li>H\u00e0m MATCH tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u1ed9t th\u1ee9 2<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">=MATCH(H2,A3:E3,0)<\/p>\n<p><strong>B\u01b0\u1edbc 2: X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0M\u00e3 c\u00f4ng ty n\u1eb1m tr\u00ean d\u00f2ng th\u1ee9 m\u1ea5y trong b\u1ea3ng<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25172\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b2-dung-ham-match-xac-dinh-dong-ket-qua-1024x261-1.png\" width=\"1024\" height=\"261\" title=\"b2-dung-ham-match-xac-dinh-dong-ket-qua-1024x261-1\"><\/p>\n<ul>\n<li>Tham chi\u1ebfu gi\u00e1 tr\u1ecb M\u00e3 c\u00f4ng ty trong c\u1ed9t A (c\u1ed9t ch\u1ee9a th\u00f4ng tin m\u00e3 c\u00f4ng ty l\u00e0m c\u0103n c\u1ee9\u00a0\u0111\u1ed1i chi\u1ebfu)<\/li>\n<li>H\u00e0m MATCH tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi d\u00f2ng th\u1ee9 3<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">=MATCH(H3,A3:A7,0)<\/p>\n<p>Nh\u01b0 v\u1eady giao\u00a0\u0111i\u1ec3m c\u1ee7a d\u00f2ng 3, c\u1ed9t 2 ch\u00ednh l\u00e0\u00a0\u00f4 <strong>B5<\/strong> (b\u1edfi b\u1ea3ng b\u1eaft\u00a0\u0111\u1ea7u t\u00ednh t\u1eeb d\u00f2ng 3 tr\u1edf\u00a0\u0111i, n\u00ean d\u00f2ng 5 \u1ee9ng v\u1edbi v\u1ecb tr\u00ed d\u00f2ng th\u1ee9 3 c\u1ee7a b\u1ea3ng \u0111\u01a1n gi\u00e1)<\/p>\n<p><strong>B\u01b0\u1edbc 3: X\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3\u00a0\u0111\u01a1n gi\u00e1 c\u1ea7n t\u00ecm v\u1edbi h\u00e0m INDEX<\/strong><\/p>\n<p>Vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 d\u00f9ng h\u00e0m INDEX\u00a0\u0111\u1ec3 k\u1ebft n\u1ed1i gi\u1eefa D\u00f2ng v\u00e0 C\u1ed9t\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf tr\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25173\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b3-dung-ham-index-xac-dinh-ket-qua-don-gia-1024x255-1.png\" width=\"1024\" height=\"255\" title=\"b3-dung-ham-index-xac-dinh-ket-qua-don-gia-1024x255-1\"><\/p>\n<p>Trong h\u00e0m INDEX n\u00e0y ta c\u00f3:<\/p>\n<ul>\n<li>Thay v\u00ec tham chi\u1ebfu t\u1edbi 1 c\u1ed9t c\u1ed1\u00a0\u0111\u1ecbnh t\u1ea1i tham s\u1ed1\u00a0\u0111\u1ea7u ti\u00ean, ch\u00fang ta tham chi\u1ebfu cho c\u1ea3 v\u00f9ng b\u1ea3ng A3:E7.<\/li>\n<li>Trong b\u1ea3ng n\u00e0y, s\u1ed1 d\u00f2ng x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m MATCH t\u1ea1i\u00a0\u00f4 I3, s\u1ed1 c\u1ed9t x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m MATCH t\u1ea1i\u00a0\u00f4 I2.<\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m INDEX l\u00e0 giao\u00a0\u0111i\u1ec3m gi\u1eefa s\u1ed1 d\u00f2ng v\u00e0 s\u1ed1 c\u1ed9t\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">=INDEX(A3:E7,I3,I2)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady th\u00f4ng qua 4 b\u00e0i t\u1eadp v\u00ed d\u1ee5, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 h\u00ecnh dung\u00a0\u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c y\u00eau c\u1ea7u d\u00f2 t\u00ecm, tham chi\u1ebfu, t\u00ecm ki\u1ebfm trong\u00a0Excel.\u00a0Khi\u00a0\u1ee9ng d\u1ee5ng t\u1ed1t c\u00e1ch l\u00e0m n\u00e0y, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c nh\u1eefng y\u00eau c\u1ea7u t\u00ecm ki\u1ebfm ph\u1ee9c t\u1ea1p m\u00e0 h\u00e0m VLOOKUP kh\u00f3\u00a0\u0111\u00e1p\u00a0\u1ee9ng\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Thay v\u00ec ph\u1ea3i\u00a0\u0111\u1eafn\u00a0\u0111o s\u1eed d\u1ee5ng h\u00e0m VLOOKUP hay HLOOKUP, l\u00e0m c\u00f4ng th\u1ee9c d\u00e0i d\u00f2ng khi ph\u1ea3i k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-match.html\">VLOOKUP v\u1edbi h\u00e0m MATCH<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html\">HLOOKUP v\u1edbi h\u00e0m MATCH<\/a>, th\u00ec\u00a0ch\u00fang ta ch\u1ec9 c\u1ea7n d\u00f9ng INDEX k\u1ebft h\u1ee3p MATCH l\u00e0 xong.<\/p>\n<p><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\/2025\/01\/ex101_92019-nho-25.gif\" title=\"ex101_92019-nho-25\"><br \/>\n<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1ecdc th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/phan-biet-ham-vlookup-voi-hlookup-va-bi-quyet-su-dung-ham.html\">Ph\u00e2n bi\u1ec7t h\u00e0m VLOOKUP v\u1edbi HLOOKUP v\u00e0 b\u00ed quy\u1ebft s\u1eed d\u1ee5ng h\u00e0m<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">H\u00e0m vlookup trong Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng n\u00e2ng cao th\u01b0\u1eddng g\u1eb7p<\/a><\/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\/2025\/01\/ex101_92019-nho-25.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9232,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9231","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\/9231","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=9231"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9231\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9232"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}