{"id":471274,"date":"2025-07-09T20:47:35","date_gmt":"2025-07-09T13:47:35","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=471274"},"modified":"2025-07-09T20:47:35","modified_gmt":"2025-07-09T13:47:35","slug":"ham-match-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/","title":{"rendered":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MATCH l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m tra c\u1ee9u quan tr\u1ecdng trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh. D\u00f9 kh\u00f4ng ph\u1ed5 bi\u1ebfn nh\u01b0 VLOOKUP hay INDEX, nh\u01b0ng MATCH l\u1ea1i \u0111\u00f3ng vai tr\u00f2 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong c\u00e1c c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n c\u1ea7n tra c\u1ee9u v\u1ecb tr\u00ed thay v\u00ec n\u1ed9i dung. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 c\u00f4ng th\u1ee9c MATCH trong Excel l\u00e0 g\u00ec, c\u00fa ph\u00e1p chu\u1ea9n, c\u00e1c d\u1ea1ng h\u00e0m ph\u1ed5 bi\u1ebfn v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda th\u1ef1c t\u1ebf d\u1ec5 \u00e1p d\u1ee5ng ngay.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MATCH trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">MATCH trong Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong m\u1ed9t d\u00e3y \u00f4 ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u. Thay v\u00ec tr\u1ea3 v\u1ec1 ch\u00ednh gi\u00e1 tr\u1ecb, MATCH s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 (v\u1ecb tr\u00ed) m\u00e0 gi\u00e1 tr\u1ecb \u0111\u00f3 xu\u1ea5t hi\u1ec7n trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n t\u00ecm ki\u1ebfm s\u1ed1 25 trong d\u00e3y {10, 20, 25, 30}, MATCH s\u1ebd tr\u1ea3 v\u1ec1 3 v\u00ec 25 n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 ba trong m\u1ea3ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-471700 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-2.jpg\" alt=\"ham-match-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">MATCH th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 INDEX, VLOOKUP, CHOOSE \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t h\u01a1n, \u0111\u1eb7c bi\u1ec7t khi c\u1ea7n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u1edf c\u1ea3 b\u00ean tr\u00e1i ho\u1eb7c ph\u1ea3i m\u1ea3ng d\u1eef li\u1ec7u \u2014 \u0111i\u1ec1u m\u00e0 VLOOKUP th\u00f4ng th\u01b0\u1eddng kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, MATCH h\u1ed7 tr\u1ee3 3 ki\u1ec3u t\u00ecm ki\u1ebfm: ch\u00ednh x\u00e1c, g\u1ea7n \u0111\u00fang v\u1edbi d\u00e3y t\u0103ng d\u1ea7n v\u00e0 g\u1ea7n \u0111\u00fang v\u1edbi d\u00e3y gi\u1ea3m d\u1ea7n, gi\u00fap ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u nhu c\u1ea7u s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf. Nh\u1edd s\u1ef1 \u0111a n\u0103ng v\u00e0 t\u00ednh \u1ee9ng d\u1ee5ng cao, MATCH l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u Excel chuy\u00ean s\u00e2u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c chu\u1ea9n c\u1ee7a h\u00e0m MATCH<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m d\u00f2 v\u1ecb tr\u00ed MATCH nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=MATCH(lookup_value, lookup_array, [match_type])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">lookup_value: Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">lookup_array: D\u00e3y \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[match_type]: Lo\u1ea1i t\u00ecm ki\u1ebfm (tu\u1ef3 ch\u1ecdn):<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">1 (m\u1eb7c \u0111\u1ecbnh): T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng lookup_value (d\u00e3y ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">0: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">-1: T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng lookup_value (d\u00e3y ph\u1ea3i s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-471710 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-12.jpg\" alt=\"ham-match-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c lo\u1ea1i h\u00e0m MATCH trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">MATCH trong Excel h\u1ed7 tr\u1ee3 ba ki\u1ec3u t\u00ecm ki\u1ebfm kh\u00e1c nhau th\u00f4ng qua \u0111\u1ed1i s\u1ed1 match_type. M\u1ed7i lo\u1ea1i ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ri\u00eang, t\u1eeb t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c \u0111\u1ebfn t\u00ecm g\u1ea7n \u0111\u00fang theo th\u1ee9 t\u1ef1 t\u0103ng ho\u1eb7c gi\u1ea3m. Vi\u1ec7c hi\u1ec3u r\u00f5 t\u1eebng lo\u1ea1i s\u1ebd gi\u00fap b\u1ea1n \u00e1p d\u1ee5ng h\u00e0m hi\u1ec7u qu\u1ea3 v\u00e0 tr\u00e1nh sai s\u00f3t khi x\u1eed l\u00fd d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c (match_type = 0)\u00a0<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb kh\u1edbp ho\u00e0n to\u00e0n trong m\u1ed9t d\u00e3y \u00f4. H\u00e0m MATCH s\u1ebd qu\u00e9t qua t\u1eebng \u00f4 trong m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng \u0111\u00fang v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. C\u00e1ch n\u00e0y r\u1ea5t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u0103n b\u1ea3n, m\u00e3 s\u1ea3n ph\u1ea9m, ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 c\u1ee5 th\u1ec3 kh\u00f4ng theo th\u1ee9 t\u1ef1. Khi s\u1eed d\u1ee5ng match_type = 0, b\u1ea1n kh\u00f4ng c\u1ea7n s\u1eafp x\u1ebfp m\u1ea3ng d\u1eef li\u1ec7u, \u0111i\u1ec1u n\u00e0y gi\u00fap linh ho\u1ea1t h\u01a1n trong th\u1ef1c t\u1ebf. V\u00ed d\u1ee5: =MATCH(&#8220;B\u00ecnh&#8221;, A2:A10, 0) s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a t\u1eeb \u201cB\u00ecnh\u201d n\u1ebfu kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi m\u1ed9t \u00f4 trong m\u1ea3ng. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-471701 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-3.jpg\" alt=\"ham-match-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u1edbi gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n (match_type = 1)<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ki\u1ec3u t\u00ecm ki\u1ebfm n\u00e0y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi m\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. H\u00e0m MATCH s\u1ebd t\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. \u0110\u00e2y l\u00e0 c\u00e1ch t\u00ecm ki\u1ebfm t\u1ed1i \u01b0u trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0 ph\u00e2n lo\u1ea1i theo \u0111i\u1ec3m s\u1ed1, m\u1ee9c gi\u00e1, thu\u1ebf su\u1ea5t, v.v. V\u00ed d\u1ee5: khi b\u1ea1n c\u1ea7n bi\u1ebft m\u1ee9c thu\u1ebf t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ee9c thu nh\u1eadp 25 tri\u1ec7u, h\u00e0m s\u1ebd d\u00f2 m\u1ee9c thu nh\u1eadp g\u1ea7n nh\u1ea5t nh\u01b0ng kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 25 tri\u1ec7u \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh b\u1eadc thu\u1ebf. C\u00f4ng th\u1ee9c v\u00ed d\u1ee5: =MATCH(25, A2:A10, 1). L\u01b0u \u00fd: n\u1ebfu m\u1ea3ng kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang th\u1ee9 t\u1ef1 t\u0103ng, k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c ho\u1eb7c g\u00e2y l\u1ed7i. Ngo\u00e0i ra, n\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, h\u00e0m c\u0169ng s\u1ebd tr\u1ea3 v\u1ec1 #N\/A.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471702 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-4.jpg\" alt=\"ham-match-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u1edbi gi\u00e1 tr\u1ecb gi\u1ea3m d\u1ea7n (match_type = -1)<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u00edt g\u1eb7p h\u01a1n, nh\u01b0ng r\u1ea5t h\u1eefu \u00edch trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n. V\u1edbi match_type = -1, h\u00e0m MATCH s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm. Ki\u1ec3u t\u00ecm ki\u1ebfm n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng khi b\u1ea1n c\u00f3 b\u1ea3ng ph\u00e2n lo\u1ea1i r\u1ee7i ro, x\u1ebfp h\u1ea1ng, ho\u1eb7c c\u00e1c thang \u0111i\u1ec3m ng\u01b0\u1ee3c (v\u00ed d\u1ee5 \u0111i\u1ec3m t\u00edn d\u1ee5ng, m\u1ee9c \u0111\u1ed9 \u01b0u ti\u00ean, v.v.). Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang t\u00ecm kh\u00e1ch h\u00e0ng c\u00f3 \u0111i\u1ec3m t\u00edn d\u1ee5ng cao h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t m\u1ee9c nh\u1ea5t \u0111\u1ecbnh, MATCH s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3. C\u00f4ng th\u1ee9c v\u00ed d\u1ee5: =MATCH(70, A2:A10, -1). M\u1ea3ng ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n, n\u1ebfu kh\u00f4ng k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 sai. H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471703 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-5.jpg\" alt=\"ham-match-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH k\u00e8m v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m d\u00f2 v\u1ecb tr\u00ed MATCH trong th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y. M\u1ed7i v\u00ed d\u1ee5 s\u1ebd \u1ee9ng v\u1edbi m\u1ed9t ki\u1ec3u t\u00ecm ki\u1ebfm kh\u00e1c nhau, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 linh ho\u1ea1t.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 1: T\u00ecm v\u1ecb tr\u00ed c\u1ee7a t\u00ean trong danh s\u00e1ch (t\u00ecm ch\u00ednh x\u00e1c)\u00a0<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean trong c\u1ed9t A nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| \u00a0 A\u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| An \u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| B\u00ecnh \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| Ch\u00e2u \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| D\u0169ng \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471704 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-6.jpg\" alt=\"ham-match-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n bi\u1ebft t\u1eeb &#8220;Ch\u00e2u&#8221; n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y trong danh s\u00e1ch n\u00e0y. Khi \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi c\u00fa ph\u00e1p nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=MATCH(&#8220;Ch\u00e2u&#8221;, A1:A4, 0)<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Ch\u00e2u&#8221; l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A1:A4 l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u ch\u1ee9a danh s\u00e1ch t\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">0 l\u00e0 t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 3 v\u00ec &#8220;Ch\u00e2u&#8221; n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 3 trong m\u1ea3ng A1:A4 (t\u00ednh t\u1eeb tr\u00ean xu\u1ed1ng). \u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh cho tr\u01b0\u1eddng h\u1ee3p d\u00f9ng h\u00e0m n\u00e0y v\u1edbi t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c, th\u01b0\u1eddng \u00e1p d\u1ee5ng cho d\u1eef li\u1ec7u v\u0103n b\u1ea3n ho\u1eb7c m\u00e3 \u0111\u1ecbnh danh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 2: T\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang trong b\u1ea3ng s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n\u00a0<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch s\u1ed1 trong c\u1ed9t A, \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">|\u00a0 A\u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| 10\u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| 20\u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| 30\u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| 40\u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471705 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-7.jpg\" alt=\"ham-match-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a s\u1ed1 25 trong d\u00e3y tr\u00ean. V\u00ec 25 kh\u00f4ng t\u1ed3n t\u1ea1i ch\u00ednh x\u00e1c, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=MATCH(25, A1:A4, 1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">25 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A1:A4 l\u00e0 m\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">1 l\u00e0 t\u00f9y ch\u1ecdn t\u00ecm g\u1ea7n \u0111\u00fang theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">MATCH s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 25, t\u1ee9c l\u00e0 20, n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 2 trong danh s\u00e1ch. Do \u0111\u00f3, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2. L\u01b0u \u00fd: ki\u1ec3u t\u00ecm ki\u1ebfm n\u00e0y ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c khi d\u00e3y d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 3: K\u1ebft h\u1ee3p MATCH v\u1edbi INDEX \u0111\u1ec3 t\u00ecm t\u00ean theo \u0111i\u1ec3m s\u1ed1\u00a0<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m t\u00ean v\u00e0 \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| \u00a0 A\u00a0 \u00a0 | \u00a0 B\u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| T\u00ean\u00a0 \u00a0 | \u0110i\u1ec3m \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| An \u00a0 \u00a0 | 7\u00a0 \u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| B\u00ecnh \u00a0 | 9\u00a0 \u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">| Ch\u00e2u \u00a0 | 8\u00a0 \u00a0 \u00a0 |<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+&#8212;&#8212;&#8211;+&#8212;&#8212;&#8211;+<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471706 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-8.jpg\" alt=\"ham-match-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ee5c ti\u00eau l\u00e0: T\u00ecm t\u00ean h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m b\u1eb1ng 9. V\u00ec \u0111i\u1ec3m n\u1eb1m \u1edf c\u1ed9t B nh\u01b0ng t\u00ean n\u1eb1m \u1edf c\u1ed9t A, n\u00ean b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p hai h\u00e0m: MATCH \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed v\u00e0 INDEX \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=INDEX(A2:A4, MATCH(9, B2:B4, 0))<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">MATCH(9, B2:B4, 0) s\u1ebd t\u00ecm \u0111i\u1ec3m 9 trong c\u1ed9t B v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed l\u00e0 2.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">INDEX(A2:A4, 2) s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb d\u00f2ng th\u1ee9 2 trong c\u1ed9t A, t\u1ee9c l\u00e0 &#8220;B\u00ecnh&#8221;.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: \u201cB\u00ecnh\u201d<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch k\u1ebft h\u1ee3p hi\u1ec7u qu\u1ea3 \u0111\u1ec3 tra c\u1ee9u ch\u00e9o gi\u1eefa c\u00e1c c\u1ed9t trong Excel.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m MATCH trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb7c d\u00f9 h\u00e0m d\u00f2 v\u1ecb tr\u00ed MATCH r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c t\u00ecm ki\u1ebfm v\u00e0 \u0111\u1ecbnh v\u1ecb d\u1eef li\u1ec7u, nh\u01b0ng \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 m\u1ed9t s\u1ed1 \u0111\u1eb7c \u0111i\u1ec3m quan tr\u1ecdng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ba l\u01b0u \u00fd c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n tr\u00e1nh sai s\u00f3t v\u00e0 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng c\u1ee7a c\u00f4ng th\u1ee9c MATCH trong Excel.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hi\u1ec3u r\u00f5 t\u00f9y ch\u1ecdn match_type \u0111\u1ec3 tr\u00e1nh sai s\u00f3t<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i s\u1ed1 match_type trong h\u00e0m d\u00f2 v\u1ecb tr\u00ed MATCH c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u00e0 c\u00f3 \u1ea3nh h\u01b0\u1edfng l\u1edbn \u0111\u1ebfn k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1. C\u00f3 ba gi\u00e1 tr\u1ecb ch\u00ednh: 0, 1, v\u00e0 -1, nh\u01b0ng n\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp gi\u00e1 tr\u1ecb, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh l\u00e0 1. \u0110i\u1ec1u n\u00e0y d\u1ec5 g\u00e2y nh\u1ea7m l\u1eabn, nh\u1ea5t l\u00e0 khi b\u1ea1n \u0111ang mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c. Khi ch\u1ecdn match_type = 0, MATCH s\u1ebd t\u00ecm ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u \u2014 \u0111\u00e2y l\u00e0 l\u1ef1a ch\u1ecdn n\u00ean d\u00f9ng khi l\u00e0m vi\u1ec7c v\u1edbi v\u0103n b\u1ea3n, m\u00e3 s\u1ed1, t\u00ean ho\u1eb7c d\u1eef li\u1ec7u kh\u00f4ng theo th\u1ee9 t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471707 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-9.jpg\" alt=\"ham-match-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ng\u01b0\u1ee3c l\u1ea1i, match_type = 1 v\u00e0 -1 ch\u1ec9 d\u00f9ng khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n t\u01b0\u01a1ng \u1ee9ng. N\u1ebfu \u00e1p d\u1ee5ng sai, h\u00e0m n\u00e0y c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c ho\u1eb7c l\u1ed7i #N\/A. Do \u0111\u00f3, lu\u00f4n x\u00e1c \u0111\u1ecbnh \u0111\u00fang m\u1ee5c \u0111\u00edch t\u00ecm ki\u1ebfm v\u00e0 nh\u1eadp r\u00f5 match_type \u0111\u1ec3 ki\u1ec3m so\u00e1t k\u1ebft qu\u1ea3 \u0111\u1ea7u ra m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang khi d\u00f9ng g\u1ea7n \u0111\u00fang (1 ho\u1eb7c -1)<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi match_type = 1 (g\u1ea7n \u0111\u00fang t\u0103ng d\u1ea7n) ho\u1eb7c -1 (g\u1ea7n \u0111\u00fang gi\u1ea3m d\u1ea7n), b\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i s\u1eafp x\u1ebfp d\u00e3y d\u1eef li\u1ec7u theo \u0111\u00fang th\u1ee9 t\u1ef1 y\u00eau c\u1ea7u. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd sai l\u1ec7ch ho\u1eb7c g\u00e2y l\u1ed7i. C\u1ee5 th\u1ec3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1edbi match_type = 1, d\u1eef li\u1ec7u ph\u1ea3i t\u0103ng d\u1ea7n (v\u00ed d\u1ee5: 10, 20, 30&#8230;).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1edbi match_type = -1, d\u1eef li\u1ec7u ph\u1ea3i gi\u1ea3m d\u1ea7n (v\u00ed d\u1ee5: 90, 80, 70&#8230;).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-10.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-10-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-10-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471708 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-10.jpeg\" alt=\"ham-match-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-10.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-10-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-10-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n d\u00f9ng ki\u1ec3u t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang m\u00e0 m\u1ea3ng d\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp, MATCH c\u00f3 th\u1ec3 ch\u1ecdn sai v\u1ecb tr\u00ed ho\u1eb7c kh\u00f4ng t\u00ecm th\u1ea5y g\u00ec v\u00e0 tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra trong c\u00e1c b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean ho\u1eb7c ch\u01b0a qua x\u1eed l\u00fd.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1eddi khuy\u00ean: N\u1ebfu kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 th\u1ee9 t\u1ef1 c\u1ee7a d\u1eef li\u1ec7u, h\u00e3y d\u00f9ng match_type = 0 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i m\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00f4ng c\u1ee5 Sort trong Excel tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m \u0111\u1eb7c bi\u1ec7t c\u1ee7a MATCH: kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef, ch\u1ec9 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MATCH trong Excel c\u00f3 m\u1ed9t s\u1ed1 \u0111\u1eb7c \u0111i\u1ec3m \u0111\u1eb7c bi\u1ec7t m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 tr\u00e1nh hi\u1ec3u nh\u1ea7m khi \u00e1p d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng: MATCH coi \u201cabc\u201d v\u00e0 \u201cABC\u201d l\u00e0 gi\u1ed1ng nhau. V\u00ec v\u1eady, n\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ch\u1eef (v\u00ed d\u1ee5 t\u00ean \u0111\u0103ng nh\u1eadp, m\u00e3 \u0111\u1ecbnh danh), h\u00e3y c\u1ea9n tr\u1ecdng ho\u1eb7c k\u1ebft h\u1ee3p th\u00eam c\u00e1c h\u00e0m ki\u1ec3m tra kh\u00e1c nh\u01b0 EXACT \u0111\u1ec3 ph\u00e2n bi\u1ec7t r\u00f5 h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-match-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-471709 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-11.jpg\" alt=\"ham-match-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ec9 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean: N\u1ebfu c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb gi\u1ed1ng nhau trong m\u1ea3ng, MATCH s\u1ebd ch\u1ec9 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y hi\u1ec3u nh\u1ea7m n\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p v\u1edbi INDEX \u0111\u1ec3 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c: MATCH th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 nh\u1ea5t khi \u0111i c\u00f9ng v\u1edbi h\u00e0m INDEX, nh\u1ea5t l\u00e0 khi c\u1ea7n truy xu\u1ea5t d\u1eef li\u1ec7u n\u1eb1m b\u00ean tr\u00e1i c\u1ee7a c\u1ed9t t\u00ecm ki\u1ebfm \u2013 \u0111i\u1ec1u m\u00e0 VLOOKUP kh\u00f4ng h\u1ed7 tr\u1ee3. C\u1eb7p \u0111\u00f4i INDEX + MATCH l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p linh ho\u1ea1t, m\u1ea1nh m\u1ebd v\u00e0 c\u00f3 th\u1ec3 thay th\u1ebf ho\u00e0n to\u00e0n VLOOKUP trong h\u1ea7u h\u1ebft t\u00ecnh hu\u1ed1ng.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1m K\u1ebft\u00a0<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MATCH l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong Excel gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong ph\u1ea1m vi d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m nh\u01b0 INDEX \u0111\u1ec3 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c v\u00e0 linh ho\u1ea1t h\u01a1n. Qua c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng h\u00ecnh dung c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m d\u00f2 v\u1ecb tr\u00ed MATCH trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y nh\u01b0 tra c\u1ee9u \u0111i\u1ec3m s\u1ed1, ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u, hay t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed th\u00f4ng tin. Hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p, c\u00e1c lo\u1ea1i t\u00ecm ki\u1ebfm v\u00e0 l\u01b0u \u00fd quan tr\u1ecdng s\u1ebd gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH hi\u1ec7u qu\u1ea3 h\u01a1n trong ph\u00e2n t\u00edch v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\">3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\">H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m MATCH l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m tra c\u1ee9u quan tr\u1ecdng trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh. D\u00f9 kh\u00f4ng ph\u1ed5 bi\u1ebfn nh\u01b0 VLOOKUP hay INDEX, nh\u01b0ng MATCH l\u1ea1i \u0111\u00f3ng vai tr\u00f2 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong c\u00e1c c\u00f4ng [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":471699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-471274","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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 l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH<\/title>\n<meta name=\"description\" content=\"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \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-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\" \/>\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:published_time\" content=\"2025-07-09T13:47:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/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=\"H\u1ed3ng Th\u01a1\" \/>\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=\"H\u1ed3ng Th\u01a1\" \/>\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-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\"},\"headline\":\"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel\",\"datePublished\":\"2025-07-09T13:47:35+00:00\",\"dateModified\":\"2025-07-09T13:47:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\"},\"wordCount\":3343,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\",\"name\":\"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg\",\"datePublished\":\"2025-07-09T13:47:35+00:00\",\"dateModified\":\"2025-07-09T13:47:35+00:00\",\"description\":\"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-match\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel\"}]},{\"@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\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH","description":"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \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-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel","og_description":"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-07-09T13:47:35+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\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-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2"},"headline":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel","datePublished":"2025-07-09T13:47:35+00:00","dateModified":"2025-07-09T13:47:35+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/"},"wordCount":3343,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/","name":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg","datePublished":"2025-07-09T13:47:35+00:00","dateModified":"2025-07-09T13:47:35+00:00","description":"H\u00e0m MATCH l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c MATCH trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-match.jpg","width":1200,"height":628,"caption":"ham-match"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel"}]},{"@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\/6db3b2e6d8fb7f2e308c4625aeaa7dc2","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/471274","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\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=471274"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/471274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/471699"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=471274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=471274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=471274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}