{"id":299640,"date":"2024-01-10T19:41:48","date_gmt":"2024-01-10T12:41:48","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=299640"},"modified":"2024-01-10T19:41:48","modified_gmt":"2024-01-10T12:41:48","slug":"ham-match","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/","title":{"rendered":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Hi\u00ea\u0323n nay \u01b0\u0301ng du\u0323ng Excel \u0111a\u0303 tr\u01a1\u0309 tha\u0300nh m\u00f4\u0323t ph\u00e2\u0300n m\u00ea\u0300m qua\u0309n ly\u0301 d\u01b0\u0303 li\u00ea\u0323u \u0111\u01b0\u01a1\u0323c nhi\u00ea\u0300u ng\u01b0\u01a1\u0300i s\u01b0\u0309 du\u0323ng b\u01a1\u0309i ti\u0301nh ti\u00ea\u0323n l\u01a1\u0323i va\u0300 chi\u0301nh xa\u0301c ma\u0300 no\u0301 mang \u0111\u00ea\u0301n. \u0110\u0103\u0323c bi\u00ea\u0323t, ca\u0301c ha\u0300m Excel nga\u0300y ca\u0300ng tr\u01a1\u0309 tha\u0300nh tr\u01a1\u0323 thu\u0309 \u0111\u0103\u0301c l\u01b0\u0323c giu\u0301p ng\u01b0\u01a1\u0300i du\u0300ng ti\u00ea\u0301t ki\u00ea\u0323m th\u01a1\u0300i gian va\u0300 \u0111\u01a1n gia\u0309n ho\u0301a ca\u0301c thao ta\u0301c ph\u01b0\u0301c ta\u0323p \u0111\u00ea\u0309 gia\u0309i quy\u00ea\u0301t c\u00f4ng vi\u00ea\u0323c. Th\u00f4ng qua ba\u0300i vi\u00ea\u0301t d\u01b0\u01a1\u0301i \u0111\u00e2y, Hoa\u0300ng Ha\u0300 Mobile se\u0303 gi\u01a1\u0301i thi\u00ea\u0323u \u0111\u00ea\u0301n ba\u0323n \u0111o\u0323c ha\u0300m Match trong Excel cu\u0300ng ca\u0301ch s\u01b0\u0309 du\u0323ng va\u0300 vi\u0301 du\u0323 \u0111\u00ea\u0309 ba\u0323n tham kha\u0309o.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Ha\u0300m Match la\u0300 gi\u0300?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Ha\u0300m Match trong ba\u0309ng ti\u0301nh Excel la\u0300 m\u00f4\u0323t ha\u0300m ti\u0300m ki\u00ea\u0301m va\u0300 tra\u0309 v\u00ea\u0300 vi\u0323 tri\u0301 t\u01b0\u01a1ng \u0111\u00f4\u0301i cu\u0309a m\u00f4\u0323t gia\u0301 tri\u0323 trong m\u00f4\u0323t pha\u0323m vi \u00f4. <\/span><span style=\"font-weight: 400;\">V\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea1m vi. <\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, n\u1ebfu ph\u1ea1m vi A2:A4 ch\u1ee9a gi\u00e1 tr\u1ecb 5, 15 v\u00e0 38 th\u00ec c\u00f4ng th\u1ee9c =Match(15,A2:A4,0) s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 3, v\u00ec 15 l\u00e0 m\u1ee5c th\u1ee9 hai trong<\/span><span style=\"font-weight: 400;\"> ph\u1ea1m vi.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m ti\u0301nh Match l\u00e0 m\u1ed9t h\u00e0m h\u1eefu \u00edch c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau. B\u1eb1ng c\u00e1ch hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ti\u0301nh Match, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c Excel m\u1ea1nh m\u1ebd v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. Khi s\u01b0\u0309 du\u0323ng ha\u0300m ti\u0301nh Match ba\u0323n se\u0303 co\u0301 \u0111\u01b0\u01a1\u0323c m\u00f4\u0323t s\u00f4\u0301 l\u01a1\u0323i i\u0301ch nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00ea\u0303 s\u01b0\u0309 du\u0323ng va\u0300 ti\u0301nh linh hoa\u0323t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00ea\u0303 da\u0300ng k\u00ea\u0301t h\u01a1\u0323p v\u01a1\u0301i ca\u0301c ha\u0300m Index \u0111\u00ea\u0309 ta\u0323o ra ca\u0301c ha\u0300m ti\u0300m ki\u00ea\u0301m va\u0300 do\u0300 ti\u0300m ph\u01b0\u0301c ta\u0323p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng \u0111\u00ea\u0309 ti\u0300m ki\u00ea\u0301m gia\u0301 tri\u0323 trong danh sa\u0301ch co\u0301 th\u01b0\u0301 t\u01b0\u0323 ho\u0103\u0323c kh\u00f4ng co\u0301 th\u01b0\u0301 t\u01b0\u0323.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-303748 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-1.jpg\" alt=\"ham-match-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, n\u1ebfu ph\u1ea1m vi A1:A10 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 th\u00ec c\u00f4ng th\u1ee9c =Match(5, A1:A10, 0) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 5, v\u00ec 5 l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 5 trong ph\u1ea1m vi. <\/span><span style=\"font-weight: 400;\">M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c, n\u1ebfu ph\u1ea1m vi A1:A10 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb &#8220;A&#8221;, &#8220;B&#8221;, &#8220;C&#8221;, &#8220;D&#8221;, &#8220;E&#8221;, &#8220;F&#8221;, &#8220;G&#8221;, &#8220;H&#8221;, &#8220;I&#8221;, &#8220;J&#8221; th\u00ec c\u00f4ng th\u1ee9c =Match(&#8220;B&#8221;, A1:A10, 1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 2, v\u00ec &#8220;B&#8221; l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 2 trong ph\u1ea1m vi, t\u00ednh t\u1eeb b\u00ean tr\u00e1i sang ph\u1ea3i.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00f4ng th\u01b0\u0301c ha\u0300m Match la\u0300 gi\u0300?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Match nh\u01b0 sau:<\/span><\/p>\n<p><b>=Match(gi\u00e1 tr\u1ecb_t\u00ecm_ki\u1ebfm,ph\u1ea1m_vi_t\u00ecm_ki\u1ebfm,[ki\u1ec3u_kh\u1edbp])<\/b><\/p>\n<p><b>Trong \u0111o\u0301:\u00a0<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gia\u0301 tri\u0323 ti\u0300m ki\u00ea\u0301m (Lookup Value): Th\u00ea\u0309 hi\u00ea\u0323n gia\u0301 tri\u0323 co\u0301 y\u0301 \u0111i\u0323nh ti\u0300m ki\u00ea\u0301m va\u0300 tra c\u01b0\u0301u. \u0110\u00e2y la\u0300 gia\u0301 tri\u0323 quan tro\u0323ng c\u00e2\u0300n pha\u0309i co\u0301 \u0111\u00ea\u0309 ha\u0300m \u0111a\u0323t \u0111\u01b0\u01a1\u0323c \u0111i\u00ea\u0300u ki\u00ea\u0323n c\u00e2\u0300n va\u0300 thao ta\u0301c tha\u0300nh c\u00f4ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Pha\u0323m vi ti\u0300m ki\u00ea\u0301m (Look array): \u0110\u00e2y la\u0300 y\u00ea\u0301u t\u00f4\u0301 th\u00ea\u0309 hi\u00ea\u0323n \u0111\u01b0\u01a1\u0323c pha\u0323m vi ca\u0301c \u00f4 c\u00e2\u0300n ti\u0300m ki\u00ea\u0301m. \u0110\u00e2y cu\u0303ng la\u0300 gia\u0301 tri\u0323 c\u00e2\u0300n pha\u0309i co\u0301 \u0111\u00ea\u0309 th\u01b0\u0323c hi\u00ean jvieejc tra c\u01b0\u0301u.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ki\u00ea\u0309u kh\u01a1\u0301p (Match type): \u0110\u00e2y la\u0300 y\u00ea\u0301u t\u00f4\u0301 th\u00ea\u0309 hi\u00ea\u0323n ki\u00ea\u0309u c\u00e2\u0300n ti\u0300m ki\u00ea\u0301m. Tuy nhi\u00ean, gia\u0301 tri\u0323 na\u0300y kh\u00f4ng b\u0103\u0301t bu\u00f4\u0323c va\u0300 hoa\u0300n toa\u0300n co\u0301 th\u00ea\u0309 bo\u0309 qua.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-303749 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-2.jpg\" alt=\"ham-match-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Gia\u0301 tri\u0323 ki\u00ea\u0309u kh\u01a1\u0301p bao g\u00f4\u0300m ca\u0301c y\u00ea\u0301u t\u00f4\u0301:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u00f4\u0301 -1 (Greater than): \u0110\u00e2y la\u0300 ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m co\u0301 gia\u0301 tri\u0323 nho\u0309 nh\u00e2\u0301t nh\u01b0ng l\u01a1\u0301n h\u01a1n ho\u0103\u0323c b\u0103\u0300ng v\u01a1\u0301i gia\u0301 tri\u0323 ti\u0300m ki\u00ea\u0301m. Khi s\u01b0\u0309 du\u0323ng ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m 01 thi\u0300 gia\u0301 tri\u0323 trong pha\u0323m vi ti\u0300m ki\u00ea\u0301m c\u00e2\u0300n \u0111\u01b0\u01a1\u0323c s\u0103\u0301p x\u00ea\u0301p theo th\u01b0\u0301 t\u01b0\u0323 gia\u0309m d\u00e2\u0300n nh\u01b0 trong hi\u0300nh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u00f4\u0301 0 (Exact Match): \u0110\u00e2y la\u0300 ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m gia\u0301 tri\u0323 l\u01a1\u0301n nh\u00e2\u0301t nh\u01b0ng b\u0103\u0300ng so v\u01a1\u0301i gia\u0301 tri\u0323 ti\u0300m ki\u00ea\u0301m. Khi s\u01b0\u0309 du\u0323ng ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m Exact Match co\u0301 th\u00ea\u0309 hoa\u0300n toa\u0300n s\u0103\u0301p x\u00ea\u0301p gia\u0301 tri\u0323 pha\u0323m vi ti\u0300m ki\u00ea\u0301m theo b\u00e2\u0301t ky\u0300.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u00f4\u0301 1\/ bo\u0309 qua (Less than): \u0110\u00e2y la\u0300 ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m gia\u0301 tri\u0323 l\u01a1\u0301n nh\u00e2\u0301t nh\u01b0ng nho\u0309 h\u01a1n ho\u0103\u0323c b\u0103\u0300ng so v\u01a1\u0301i gia\u0301 tri\u0323 ti\u0300m ki\u00ea\u0301m. Khi s\u01b0\u0309 du\u0323ng ki\u00ea\u0309u ti\u0300m ki\u00ea\u0301m Less than na\u0300y thi\u0300 gia\u0301 tri\u0323 trong pha\u0323m vi ti\u0300m ki\u00ea\u0301m c\u00e2\u0300n \u0111\u01b0\u01a1\u0323c s\u0103\u0301p x\u00ea\u0301p theo th\u01b0\u0301 t\u01b0\u0323 t\u0103ng d\u00e2\u0300n.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00e1c ki\u1ec3u h\u00e0m Match trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m Match trong Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ecm ki\u1ebfm tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi. H\u00e0m ti\u0301nh Match c\u00f3 4 ki\u1ec3u t\u00ecm ki\u1ebfm, \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi tham s\u1ed1 Match_type. Nhi\u0300n chung, tu\u0300y thu\u00f4\u0323c va\u0300o gia\u0301 tri\u0323 cu\u0309a ca\u0301c tham s\u00f4\u0301 Match_type kha\u0301c nhau thi\u0300 ba\u0323n hoa\u0300n toa\u0300n co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng ca\u0301c loa\u0323i ha\u0300m ti\u0301nh Match trong ba\u0309ng ti\u0301nh Excel:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c (Match_type = 0): T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. V\u00ed d\u1ee5: n\u1ebfu ph\u1ea1m vi A1:A3 ch\u1ee9a gi\u00e1 tr\u1ecb 5, 25 v\u00e0 38 th\u00ec c\u00f4ng th\u1ee9c =Match(25,A1:A3,0) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 2.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (Match_type = 1): T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u1edbp \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. V\u00ed d\u1ee5: n\u1ebfu ph\u1ea1m vi A1:A3 ch\u1ee9a gi\u00e1 tr\u1ecb 5, 25 v\u00e0 38 th\u00ec c\u00f4ng th\u1ee9c =Match(25,A1:A3,1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 2.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (Match_type = -1): T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u1edbp \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n. V\u00ed d\u1ee5: n\u1ebfu ph\u1ea1m vi A1:A3 ch\u1ee9a gi\u00e1 tr\u1ecb 5, 25 v\u00e0 38 th\u00ec c\u00f4ng th\u1ee9c =Match(25,A1:A3,-1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm kh\u1edbp g\u1ea7n \u0111\u00fang (Match_type = 2): T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u1edbp g\u1ea7n nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. V\u00ed d\u1ee5: n\u1ebfu ph\u1ea1m vi A1:A3 ch\u1ee9a gi\u00e1 tr\u1ecb 5, 25 v\u00e0 38 th\u00ec c\u00f4ng th\u1ee9c =Match(24.5,A1:A3,2) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 1.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-303750 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-3.jpg\" alt=\"ham-match-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong ph\u1ea1m vi, h\u00e0m ti\u0301nh Match s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/span><\/p>\n<h2>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match trong \u1ee9ng d\u1ee5ng Excel<\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match trong Excel, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc c\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y c\u1ee5 th\u1ec3 nh\u01b0 nhau:<\/p>\n<h3>Tr\u01b0\u1eddng h\u1ee3p 1 &#8211; S\u1eed d\u1ee5ng h\u00e0m Match v\u1edbi ki\u1ec3u 1 ho\u1eb7c ki\u1ec3u b\u1ecf qua<\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 khi c\u1ea7n ph\u1ea3i t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 th\u1ee9 t\u1ef1 50 trong t\u1ed5ng s\u1ed1 c\u00f3 trong b\u1ea3ng ch\u1ee9a v\u00f9ng d\u1eef li\u1ec7u. Ngh\u0129a l\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb tham s\u1ed1 d\u1eef li\u1ec7u c\u1ea7n nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. \u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau: MATCH (50, C2:C7,1).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303740 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-4.jpg\" alt=\"ham-match-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Tuy nhi\u00ean, trong b\u1ea3ng t\u00ednh kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb 50 n\u00ean h\u00e0m t\u00ednh Match s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 g\u1ea7n nh\u1ea5t nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb 50 \u0111\u00f3 l\u00e0 tham s\u1ed1 49 \u1edf v\u1ecb tr\u00ed th\u1ee9 2.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303741 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-5.jpg\" alt=\"ham-match-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>Tr\u01b0\u1eddng h\u1ee3p 2 &#8211; S\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match v\u1edbi ki\u1ec3u t\u00ecm ki\u1ebfm 0<\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n s\u1ebd ph\u1ea3i t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 th\u1ee9 t\u1ef1 60 trong t\u1ed5ng s\u1ed1 c\u00f3 trong b\u1ea3ng ch\u1ee9a v\u00f9ng d\u1eef li\u1ec7u. Ngh\u0129a l\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb tham s\u1ed1 d\u1eef li\u1ec7u c\u1ea7n nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. \u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau: MATCH (60, C2:C7,0).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303742 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-6.jpg\" alt=\"ham-match-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>L\u00fac n\u00e0y, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 \u0111\u00fang v\u1ec1 gi\u00e1 tr\u1ecb tham s\u1ed1 60 b\u1edfi v\u00ec b\u1ea3ng t\u00ednh ch\u1ee9a s\u1ed1 60 v\u00e0 k\u1ebft qu\u1ea3 n\u1eb1m \u1edf \u00f4 v\u1ecb tr\u00ed th\u1ee9 3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303743 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-7.jpg\" alt=\"ham-match-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">Ha\u0300m Match khi k\u00ea\u0301t h\u01a1\u0323p cu\u0300ng v\u01a1\u0301i ca\u0301c ha\u0300m kha\u0301c trong Excel\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, h\u00e0m t\u00ednh Match \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c d\u1eef li\u1ec7u v\u00e0 tr\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i trong c\u00f9ng m\u1ed9t ph\u1ea1m vi \u00f4. Tuy nhi\u00ean nhi\u1ec1u ng\u01b0\u1eddi th\u1eafc li\u1ec7u h\u00e0m t\u00ednh Match c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c trong Excel kh\u00f4ng v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ed9c l\u1eadp, h\u00e0m ti\u0301nh Match c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb theo m\u1ee5c h\u00e0ng v\u00e0 c\u1ed9t. M\u1ed9t s\u1ed1 h\u00e0m ph\u1ed5 bi\u1ebfn k\u1ebft h\u1ee3p d\u00f9ng v\u1edbi h\u00e0m t\u00ednh \u0111\u00f3 l\u00e0 h\u00e0m HLOOKUP, h\u00e0m VLOOKUP, h\u00e0m INDEX, h\u00e0m ISNA.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m HLOOKUP\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m HLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm d\u1eef li\u1ec7u theo c\u1ed9t, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 n\u1eb1m \u1edf h\u00e0ng th\u1ee9 row_index_num c\u1ee7a c\u1ed9t column_index_num trong b\u1ea3ng d\u1eef li\u1ec7u, v\u1edbi \u0111i\u1ec1u ki\u1ec7n gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm lookup_value kh\u1edbp v\u1edbi gi\u00e1 tr\u1ecb n\u1eb1m \u1edf \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t column_index_num. <\/span><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh Match l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm lookup_value trong m\u1ed9t m\u1ea3ng. V\u1ecb tr\u00ed tr\u1ea3 v\u1ec1 l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean, b\u1eaft \u0111\u1ea7u t\u1eeb 1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-8-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-8-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-8-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305769 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-8-1.jpg\" alt=\"ham-match-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-8-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-8-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-8-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Khi k\u1ebft h\u1ee3p h\u00e0m t\u00ednh Match v\u00e0 h\u00e0m HLOOKUP, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong b\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 n\u1eb1m \u1edf h\u00e0ng \u0111\u00f3 v\u00e0 c\u1ed9t column_index_num. <\/span><span style=\"font-weight: 400;\">Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m ti\u0301nh Match v\u00e0 h\u00e0m HLOOKUP gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 d\u00f2 t\u00ecm d\u1eef li\u1ec7u theo chi\u1ec1u ngang m\u1ed9t c\u00e1ch linh ho\u1ea1t, kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi v\u1ecb tr\u00ed c\u1ee7a c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m ti\u0301nh Match v\u00e0 h\u00e0m HLOOKUP:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m ti\u0301nh Match tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean, b\u1eaft \u0111\u1ea7u t\u1eeb 1. Do \u0111\u00f3, n\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m ti\u0301nh Match \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed h\u00e0ng ch\u00ednh x\u00e1c tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m HLOOKUP.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u, h\u00e0m ti\u0301nh Match s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb #N\/A. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i trong b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i cho h\u00e0m ti\u0301nh Match.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m VLOOKUP<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP v\u00e0 h\u00e0m t\u00ednh Match l\u00e0 hai h\u00e0m t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn trong Excel. H\u00e0m VLOOKUP t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb m\u1ed9t c\u1ed9t kh\u00e1c trong b\u1ea3ng \u0111\u00f3. H\u00e0m t\u00ednh Match t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3 trong m\u1ea3ng. Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y v\u1edbi nhau, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra c\u00f4ng th\u1ee9c t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u linh ho\u1ea1t v\u00e0 m\u1ea1nh m\u1ebd h\u01a1n. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u00e0 h\u00e0m t\u00ednh Match.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm kh\u00f4ng c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #N\/A.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu s\u1ed1 ch\u1ec9 c\u1ed9t trong h\u00e0m VLOOKUP l\u1edbn h\u01a1n s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #REF!.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb range_lookup l\u00e0 TRUE, h\u00e0m VLOOKUP c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c n\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb tr\u00f9ng nhau.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-9-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-9-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-9-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305771 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-9-1.jpg\" alt=\"ham-match-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-9-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-9-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-9-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m INDEX\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh Match v\u00e0 h\u00e0m INDEX l\u00e0 hai h\u00e0m v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel, c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi nhau \u0111\u1ec3 t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, linh ho\u1ea1t. H\u00e0m t\u00ednh Match s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong ph\u1ea1m vi d\u00f2 t\u00ecm. H\u00e0m INDEX s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong m\u1ea3ng. Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y v\u1edbi nhau, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra c\u00f4ng th\u1ee9c \u0111\u1ec3 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb trong m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i v\u1ecb tr\u00ed \u0111\u00f3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-10-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-10-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-10-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305772 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-10-1.jpg\" alt=\"ham-match-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-10-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-10-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-10-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh Match khi k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Index s\u1ebd gi\u00fap d\u00f2 t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb trong b\u1ea3ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, tr\u1ea3 gi\u00e1 tr\u1ecb v\u1ec1 t\u1ea1i gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong m\u1ea3ng v\u00e0 t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n r\u1ea5t ph\u1ee9c t\u1ea1p. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match v\u1edbi h\u00e0m Index nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match, c\u1ea7n l\u01b0u \u00fd \u0111\u1ebfn ki\u1ec3u t\u00ecm ki\u1ebfm. N\u1ebfu ki\u1ec3u t\u00ecm ki\u1ebfm kh\u00f4ng ph\u00f9 h\u1ee3p, h\u00e0m ti\u0301nh Match s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match \u0111\u1ec3 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb trong m\u1ea3ng c\u00f3 nhi\u1ec1u c\u1ed9t, c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 [c\u1ed9t] c\u1ee7a h\u00e0m INDEX \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh c\u1ed9t c\u1ea7n tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m ISNA\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh Match v\u00e0 h\u00e0m ISNA l\u00e0 hai h\u00e0m trong ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh Python \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd chu\u1ed7i. H\u00e0m t\u00ednh Match \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t m\u1eabu trong chu\u1ed7i, trong khi h\u00e0m ISNA \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u00e8n m\u1ed9t chu\u1ed7i v\u00e0o m\u1ed9t chu\u1ed7i kh\u00e1c t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3. <\/span><span style=\"font-weight: 400;\">Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match \u0111\u1ec3 t\u00ecm m\u1ed9t m\u1eabu trong chu\u1ed7i, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m ISNA \u0111\u1ec3 ch\u00e8n m\u1ed9t chu\u1ed7i v\u00e0o chu\u1ed7i t\u1ea1i v\u1ecb tr\u00ed c\u1ee7a m\u1eabu \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y. Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ea3ng v\u00e0 ch\u00e8n m\u1ed9t gi\u00e1 tr\u1ecb m\u1edbi v\u00e0o v\u1ecb tr\u00ed \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ea3ng v\u00e0 x\u00f3a gi\u00e1 tr\u1ecb \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ea3ng v\u00e0 thay th\u1ebf gi\u00e1 tr\u1ecb \u0111\u00f3 b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb m\u1edbi.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-11-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-11-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-match-11-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305773 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-11-1.jpg\" alt=\"ham-match-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-11-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-11-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-11-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>T\u1ed5ng k\u1ebft<\/h2>\n<p>Th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u1ee7a h\u00e0m Match l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh n\u00e0y trong Excel nh\u01b0 th\u1ebf n\u00e0o. C\u00f3 th\u1ec3 th\u1ea5y h\u00e0m t\u00ednh Match l\u00e0 m\u1ed9t h\u00e0m quan tr\u1ecdng \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 v\u1ec1 \u0111\u00fang v\u1ecb tr\u00ed trong c\u00f9ng c\u1ed9t. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng bi\u1ebft \u00fd ngh\u0129a v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m t\u00ednh Match khi k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c trong \u1ee9ng d\u1ee5ng Excel. Hy v\u1ecdng th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n s\u1ebd c\u00f3 th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 h\u00e0m t\u00ednh Match.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/them-cot-trong-excel\/\">C\u00e1ch ch\u00e8n th\u00eam c\u1ed9t trong Excel: H\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index\/\">H\u00e0m INDEX trong Excel, c\u00e1ch s\u1eed d\u1ee5ng c\u00f3 b\u00e0i t\u1eadp c\u1ee5 th\u1ec3<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hi\u00ea\u0323n nay \u01b0\u0301ng du\u0323ng Excel \u0111a\u0303 tr\u01a1\u0309 tha\u0300nh m\u00f4\u0323t ph\u00e2\u0300n m\u00ea\u0300m qua\u0309n ly\u0301 d\u01b0\u0303 li\u00ea\u0323u \u0111\u01b0\u01a1\u0323c nhi\u00ea\u0300u ng\u01b0\u01a1\u0300i s\u01b0\u0309 du\u0323ng b\u01a1\u0309i ti\u0301nh ti\u00ea\u0323n l\u01a1\u0323i va\u0300 chi\u0301nh xa\u0301c ma\u0300 no\u0301 mang \u0111\u00ea\u0301n. \u0110\u0103\u0323c bi\u00ea\u0323t, ca\u0301c ha\u0300m Excel nga\u0300y ca\u0300ng tr\u01a1\u0309 tha\u0300nh tr\u01a1\u0323 thu\u0309 \u0111\u0103\u0301c l\u01b0\u0323c giu\u0301p ng\u01b0\u01a1\u0300i du\u0300ng ti\u00ea\u0301t ki\u00ea\u0323m th\u01a1\u0300i gian va\u0300 \u0111\u01a1n gia\u0309n ho\u0301a [&hellip;]<\/p>\n","protected":false},"author":91,"featured_media":303737,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-299640","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-10T12:41:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\"},\"author\":{\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef\"},\"headline\":\"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5\",\"datePublished\":\"2024-01-10T12:41:48+00:00\",\"dateModified\":\"2024-01-10T12:41:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\"},\"wordCount\":3376,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\",\"name\":\"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg\",\"datePublished\":\"2024-01-10T12:41:48+00:00\",\"dateModified\":\"2024-01-10T12:41:48+00:00\",\"description\":\"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-match\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef\",\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g\",\"caption\":\"Tr\u1ea7n Tuy\u1ebft Nhung\"},\"description\":\"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5","description":"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5","og_description":"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-01-10T12:41:48+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg","type":"image\/jpeg"}],"author":"Tr\u1ea7n Tuy\u1ebft Nhung","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Tr\u1ea7n Tuy\u1ebft Nhung","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/"},"author":{"name":"Tr\u1ea7n Tuy\u1ebft Nhung","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef"},"headline":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5","datePublished":"2024-01-10T12:41:48+00:00","dateModified":"2024-01-10T12:41:48+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/"},"wordCount":3376,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/","name":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg","datePublished":"2024-01-10T12:41:48+00:00","dateModified":"2024-01-10T12:41:48+00:00","description":"H\u00e0m Match l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u h\u1eb1ng ng\u00e0y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m t\u1ea1i \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match.jpg","width":1200,"height":628,"caption":"ham-match"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef","name":"Tr\u1ea7n Tuy\u1ebft Nhung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g","caption":"Tr\u1ea7n Tuy\u1ebft Nhung"},"description":"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/299640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=299640"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/299640\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/303737"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=299640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=299640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=299640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}