{"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":"2026-08-25T15:09:50","modified_gmt":"2026-08-25T08:09:50","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\u1ec7n nay \u1ee9ng d\u1ee5ng Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng b\u1edfi t\u00ednh ti\u1ec7n l\u1ee3i v\u00e0 ch\u00ednh x\u00e1c m\u00e0 n\u00f3 mang \u0111\u1ebfn. \u0110\u1eb7c bi\u1ec7t, c\u00e1c h\u00e0m Excel ng\u00e0y c\u00e0ng tr\u1edf th\u00e0nh tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1c thao t\u00e1c ph\u1ee9c t\u1ea1p \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c. Th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc h\u00e0m Match trong Excel c\u00f9ng c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 \u0111\u1ec3 b\u1ea1n tham kh\u1ea3o.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m Match l\u00e0 g\u00ec?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m Match trong b\u1ea3ng t\u00ednh Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ecm ki\u1ebfm v\u00e0 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 \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 t\u00ednh 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 t\u00ednh 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\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 l\u1ee3i \u00edch nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ec5 s\u1eed d\u1ee5ng v\u00e0 t\u00ednh linh ho\u1ea1t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Index \u0111\u1ec3 t\u1ea1o ra c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm v\u00e0 d\u00f2 t\u00ecm ph\u1ee9c t\u1ea1p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong danh s\u00e1ch c\u00f3 th\u1ee9 t\u1ef1 ho\u1eb7c kh\u00f4ng c\u00f3 th\u1ee9 t\u1ef1.\u00a0<\/span><\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-303748\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-1.jpg\" alt=\"H\u00e0m Match l\u00e0 g\u00ec\" 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\" \/><\/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\u1ee9c h\u00e0m Match l\u00e0 g\u00ec?\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 \u0111\u00f3:\u00a0<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (Lookup Value): Th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb c\u00f3 \u00fd \u0111\u1ecbnh t\u00ecm ki\u1ebfm v\u00e0 tra c\u1ee9u. \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb quan tr\u1ecdng c\u1ea7n ph\u1ea3i c\u00f3 \u0111\u1ec3 h\u00e0m \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n c\u1ea7n v\u00e0 thao t\u00e1c th\u00e0nh c\u00f4ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u1ea1m vi t\u00ecm ki\u1ebfm (Look array): \u0110\u00e2y l\u00e0 y\u1ebfu t\u1ed1 th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c ph\u1ea1m vi c\u00e1c \u00f4 c\u1ea7n t\u00ecm ki\u1ebfm. \u0110\u00e2y c\u0169ng l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n ph\u1ea3i c\u00f3 \u0111\u1ec3 th\u1ef1c hi\u00ean jvieejc tra c\u1ee9u.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ki\u1ec3u kh\u1edbp (Match type): \u0110\u00e2y l\u00e0 y\u1ebfu t\u1ed1 th\u1ec3 hi\u1ec7n ki\u1ec3u c\u1ea7n t\u00ecm ki\u1ebfm. Tuy nhi\u00ean, gi\u00e1 tr\u1ecb n\u00e0y kh\u00f4ng b\u1eaft bu\u1ed9c v\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 b\u1ecf qua.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-303749\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-2.jpg\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m Match l\u00e0 g\u00ec\" 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\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb ki\u1ec3u kh\u1edbp bao g\u1ed3m c\u00e1c y\u1ebfu t\u1ed1:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 -1 (Greater than): \u0110\u00e2y l\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t nh\u01b0ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Khi s\u1eed d\u1ee5ng ki\u1ec3u t\u00ecm ki\u1ebfm 01 th\u00ec gi\u00e1 tr\u1ecb trong ph\u1ea1m vi t\u00ecm ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n nh\u01b0 trong h\u00ecnh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 0 (Exact Match): \u0110\u00e2y l\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u01b0ng b\u1eb1ng so v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Khi s\u1eed d\u1ee5ng ki\u1ec3u t\u00ecm ki\u1ebfm Exact Match c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n s\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb ph\u1ea1m vi t\u00ecm ki\u1ebfm theo b\u1ea5t k\u1ef3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 1\/ b\u1ecf qua (Less than): \u0110\u00e2y l\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u01b0ng nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng so v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Khi s\u1eed d\u1ee5ng ki\u1ec3u t\u00ecm ki\u1ebfm Less than n\u00e0y th\u00ec gi\u00e1 tr\u1ecb trong ph\u1ea1m vi t\u00ecm ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.\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 t\u00ednh Match c\u00f3 4 ki\u1ec3u t\u00ecm ki\u1ebfm, \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi tham s\u1ed1 Match_type. Nh\u00ecn chung, t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c tham s\u1ed1 Match_type kh\u00e1c nhau th\u00ec b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c lo\u1ea1i h\u00e0m t\u00ednh Match trong b\u1ea3ng t\u00ednh 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><img decoding=\"async\" class=\"aligncenter size-full wp-image-303750\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-3.jpg\" alt=\"C\u00e1c ki\u1ec3u h\u00e0m Match trong Excel\" 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\" \/><\/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 t\u00ednh 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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303740\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-4.jpg\" alt=\"Tr\u01b0\u1eddng h\u1ee3p 1 - S\u1eed d\u1ee5ng h\u00e0m Match v\u1edbi ki\u1ec3u 1 ho\u1eb7c ki\u1ec3u b\u1ecf qua - h\u00ecnh 1\" 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\" \/><\/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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303741\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-5.jpg\" alt=\"Tr\u01b0\u1eddng h\u1ee3p 1 - S\u1eed d\u1ee5ng h\u00e0m Match v\u1edbi ki\u1ec3u 1 ho\u1eb7c ki\u1ec3u b\u1ecf qua - h\u00ecnh 2\" 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\" \/><\/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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303742\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-6.jpg\" alt=\"Tr\u01b0\u1eddng h\u1ee3p 2 - S\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match v\u1edbi ki\u1ec3u t\u00ecm ki\u1ebfm 0 - h\u00ecnh 1\" 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\" \/><\/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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-303743\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-7.jpg\" alt=\"Tr\u01b0\u1eddng h\u1ee3p 2 - S\u1eed d\u1ee5ng h\u00e0m t\u00ednh Match v\u1edbi ki\u1ec3u t\u00ecm ki\u1ebfm 0 - h\u00ecnh 2\" 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\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m Match khi k\u1ebft h\u1ee3p c\u00f9ng v\u1edbi c\u00e1c h\u00e0m kh\u00e1c 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 t\u00ednh 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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305769 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-8-1.jpg\" alt=\"H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m HLOOKUP\" 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\" \/><\/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 t\u00ednh 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 t\u00ednh Match v\u00e0 h\u00e0m HLOOKUP:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh 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 t\u00ednh 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 t\u00ednh 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 t\u00ednh 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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305771 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-9-1.jpg\" alt=\"H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m VLOOKUP\" 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\" \/><\/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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305772 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-10-1.jpg\" alt=\"H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m INDEX\" 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\" \/><\/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 t\u00ednh 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><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-305773 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-match-11-1.jpg\" alt=\"H\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi v\u1edbi h\u00e0m ISNA\" 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\" \/><\/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\u1ec7n nay \u1ee9ng d\u1ee5ng Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng b\u1edfi t\u00ednh ti\u1ec7n l\u1ee3i v\u00e0 ch\u00ednh x\u00e1c m\u00e0 n\u00f3 mang \u0111\u1ebfn. \u0110\u1eb7c bi\u1ec7t, c\u00e1c h\u00e0m Excel ng\u00e0y c\u00e0ng tr\u1edf th\u00e0nh tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a [&hellip;]<\/p>\n","protected":false},"author":91,"featured_media":303737,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"h\u00e0m match","_yoast_wpseo_title":"H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5","_yoast_wpseo_metadesc":"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!","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 v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\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=\"article:modified_time\" content=\"2026-08-25T08:09:50+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\\\/747926ea7016abddd180d7180c7dc1cd\"},\"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\":\"2026-08-25T08:09:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-match\\\/\"},\"wordCount\":3369,\"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\":\"2026-08-25T08:09:50+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\":\"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\\\/747926ea7016abddd180d7180c7dc1cd\",\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?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","article_modified_time":"2026-08-25T08:09:50+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\/747926ea7016abddd180d7180c7dc1cd"},"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":"2026-08-25T08:09:50+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/"},"wordCount":3369,"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":"2026-08-25T08:09:50+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":"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\/747926ea7016abddd180d7180c7dc1cd","name":"Tr\u1ea7n Tuy\u1ebft Nhung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ae75e44f2e02ca4ff438a413d38570378ce91d47167e8ee49d3da61dc062202f?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":1,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/299640\/revisions"}],"predecessor-version":[{"id":591495,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/299640\/revisions\/591495"}],"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}]}}