{"id":570248,"date":"2026-07-27T10:21:04","date_gmt":"2026-07-27T03:21:04","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=570248"},"modified":"2026-07-27T10:21:21","modified_gmt":"2026-07-27T03:21:21","slug":"ham-index-match","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/","title":{"rendered":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5"},"content":{"rendered":"<p>H\u00e0m INDEX MATCH trong Excel l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa hai h\u00e0m INDEX v\u00e0 MATCH, gi\u00fap b\u1ea1n tra c\u1ee9u v\u00e0 l\u1ea5y d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n h\u1eb3n so v\u1edbi h\u00e0m VLOOKUP quen thu\u1ed9c. C\u00fa ph\u00e1p ph\u1ed5 bi\u1ebfn c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 INDEX(v\u00f9ng d\u1eef li\u1ec7u, MATCH(gi\u00e1 tr\u1ecb d\u00f2, v\u00f9ng d\u00f2, 0)). \u0110i\u1ec3m m\u1ea1nh c\u1ee7a INDEX MATCH l\u00e0 d\u00f2 \u0111\u01b0\u1ee3c theo c\u1ea3 hai chi\u1ec1u tr\u00e1i &#8211; ph\u1ea3i, kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o v\u1ecb tr\u00ed c\u1ed9t v\u00e0 ch\u1ea1y nhanh h\u01a1n tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn. N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh, n\u1eafm ch\u1eafc b\u1ed9 \u0111\u00f4i n\u00e0y s\u1ebd gi\u00fap c\u00f4ng vi\u1ec7c tra c\u1ee9u tr\u1edf n\u00ean g\u1ecdn g\u00e0ng v\u00e0 \u00edt l\u1ed7i h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n<h2>H\u00e0m INDEX MATCH l\u00e0 g\u00ec?<\/h2>\n<p>INDEX MATCH l\u00e0 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX (l\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed trong v\u00f9ng d\u1eef li\u1ec7u) v\u1edbi h\u00e0m MATCH (t\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong h\u00e0ng ho\u1eb7c c\u1ed9t). Khi gh\u00e9p hai h\u00e0m l\u1ea1i, MATCH \u0111\u00f3ng vai tr\u00f2 x\u00e1c \u0111\u1ecbnh &#8220;d\u00f2ng th\u1ee9 m\u1ea5y&#8221; ho\u1eb7c &#8220;c\u1ed9t th\u1ee9 m\u1ea5y&#8221;, c\u00f2n INDEX d\u1ef1a v\u00e0o v\u1ecb tr\u00ed \u0111\u00f3 \u0111\u1ec3 tr\u1ea3 v\u1ec1 \u0111\u00fang gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n. Nh\u1edd c\u01a1 ch\u1ebf n\u00e0y, INDEX MATCH kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c nhi\u1ec1u h\u1ea1n ch\u1ebf c\u1ed1 h\u1eefu c\u1ee7a VLOOKUP v\u00e0 tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 tra c\u1ee9u \u0111\u01b0\u1ee3c d\u00e2n v\u0103n ph\u00f2ng chuy\u00ean nghi\u1ec7p \u01b0a chu\u1ed9ng.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-570479 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-1.jpg\" alt=\"ham-index-match-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>C\u00fa ph\u00e1p h\u00e0m INDEX v\u00e0 h\u00e0m MATCH<\/h2>\n<p>Tr\u01b0\u1edbc khi k\u1ebft h\u1ee3p, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p c\u1ee7a t\u1eebng h\u00e0m ri\u00eang l\u1ebb:<\/p>\n<ul>\n<li><strong>H\u00e0m INDEX:<\/strong> =INDEX(array, row_num, [column_num]) &#8211; tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u1eb1m t\u1ea1i giao \u0111i\u1ec3m c\u1ee7a d\u00f2ng (row_num) v\u00e0 c\u1ed9t (column_num) trong v\u00f9ng array.<\/li>\n<li><strong>H\u00e0m MATCH:<\/strong> =MATCH(lookup_value, lookup_array, [match_type]) &#8211; tr\u1ea3 v\u1ec1 <em>v\u1ecb tr\u00ed<\/em> (s\u1ed1 th\u1ee9 t\u1ef1) c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t. V\u1edbi match_type = 0 ngh\u0129a l\u00e0 d\u00f2 ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 t\u1eebng h\u00e0m qua b\u00e0i <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\">h\u00e0m MATCH trong Excel<\/a> \u0111\u1ec3 n\u1eafm ch\u1eafc ph\u1ea7n l\u00f5i tr\u01b0\u1edbc khi gh\u00e9p c\u00f4ng th\u1ee9c.<\/p>\n<h2>C\u00e1ch k\u1ebft h\u1ee3p INDEX MATCH<\/h2>\n<p>C\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p ph\u1ed5 bi\u1ebfn nh\u1ea5t d\u00f9ng cho tra c\u1ee9u m\u1ed9t chi\u1ec1u l\u00e0:<\/p>\n<ul>\n<li>=INDEX(c\u1ed9t k\u1ebft qu\u1ea3, MATCH(gi\u00e1 tr\u1ecb d\u00f2, c\u1ed9t d\u00f2, 0))<\/li>\n<\/ul>\n<p>Trong \u0111\u00f3, s\u1ed1 0 (ho\u1eb7c FALSE) trong MATCH ngh\u0129a l\u00e0 t\u00ecm ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i. MATCH s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb d\u00f2 trong &#8220;c\u1ed9t d\u00f2&#8221;, sau \u0111\u00f3 INDEX d\u00f9ng v\u1ecb tr\u00ed n\u00e0y \u0111\u1ec3 l\u1ea5y \u0111\u00fang \u00f4 t\u01b0\u01a1ng \u1ee9ng \u1edf &#8220;c\u1ed9t k\u1ebft qu\u1ea3&#8221;. C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a b\u1ed9 \u0111\u00f4i n\u00e0y r\u1ea5t tr\u1ef1c quan: MATCH t\u00ecm d\u00f2ng, INDEX l\u1ea5y gi\u00e1 tr\u1ecb.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c<\/a><\/strong><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-570480 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-2.jpg\" alt=\"ham-index-match-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>V\u00ed d\u1ee5 minh h\u1ecda c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc<\/h2>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau: c\u1ed9t A ch\u1ee9a t\u00ean h\u1ecdc sinh, c\u1ed9t B ch\u1ee9a \u0111i\u1ec3m s\u1ed1.<\/p>\n<table>\n<thead>\n<tr>\n<th>C\u1ed9t A (T\u00ean)<\/th>\n<th>C\u1ed9t B (\u0110i\u1ec3m)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>An<\/td>\n<td>7.5<\/td>\n<\/tr>\n<tr>\n<td>Nam<\/td>\n<td>8.0<\/td>\n<\/tr>\n<tr>\n<td>Lan<\/td>\n<td>9.0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0110\u1ec3 t\u00ecm \u0111i\u1ec3m c\u1ee7a &#8220;Nam&#8221;, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li>=INDEX(B:B, MATCH(&#8220;Nam&#8221;, A:A, 0))<\/li>\n<\/ul>\n<p>C\u00e1c b\u01b0\u1edbc di\u1ec5n ra nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> MATCH(&#8220;Nam&#8221;, A:A, 0) d\u00f2 t\u00ecm &#8220;Nam&#8221; trong c\u1ed9t A v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed l\u00e0 d\u00f2ng th\u1ee9 2.<\/li>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> INDEX(B:B, 2) l\u1ea5y gi\u00e1 tr\u1ecb \u1edf d\u00f2ng th\u1ee9 2 c\u1ee7a c\u1ed9t B, t\u1ee9c l\u00e0 8.0.<\/li>\n<li><strong>K\u1ebft qu\u1ea3:<\/strong> C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 8.0 &#8211; \u0111\u00fang \u0111i\u1ec3m c\u1ee7a Nam.<\/li>\n<\/ul>\n<h2>Tra c\u1ee9u hai chi\u1ec1u v\u1edbi INDEX MATCH MATCH<\/h2>\n<p>\u01afu \u0111i\u1ec3m l\u1edbn c\u1ee7a INDEX MATCH l\u00e0 tra c\u1ee9u \u0111\u01b0\u1ee3c \u0111\u1ed3ng th\u1eddi theo c\u1ea3 d\u00f2ng v\u00e0 c\u1ed9t. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m nhi\u1ec1u m\u00f4n, c\u1ed9t A l\u00e0 t\u00ean h\u1ecdc sinh, d\u00f2ng \u0111\u1ea7u (h\u00e0ng 1) l\u00e0 t\u00ean m\u00f4n h\u1ecdc. \u0110\u1ec3 t\u00ecm \u0111i\u1ec3m m\u00f4n &#8220;To\u00e1n&#8221; c\u1ee7a &#8220;Lan&#8221;, b\u1ea1n d\u00f9ng:<\/p>\n<ul>\n<li>=INDEX(v\u00f9ng \u0111i\u1ec3m, MATCH(&#8220;Lan&#8221;, c\u1ed9t t\u00ean, 0), MATCH(&#8220;To\u00e1n&#8221;, h\u00e0ng m\u00f4n, 0))<\/li>\n<\/ul>\n<p>\u1ede \u0111\u00e2y MATCH th\u1ee9 nh\u1ea5t x\u00e1c \u0111\u1ecbnh d\u00f2ng (Lan n\u1eb1m \u1edf d\u00f2ng n\u00e0o), MATCH th\u1ee9 hai x\u00e1c \u0111\u1ecbnh c\u1ed9t (To\u00e1n n\u1eb1m \u1edf c\u1ed9t n\u00e0o), c\u00f2n INDEX l\u1ea5y \u0111\u00fang \u00f4 giao nhau. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u VLOOKUP th\u00f4ng th\u01b0\u1eddng r\u1ea5t kh\u00f3 l\u00e0m \u0111\u01b0\u1ee3c m\u1ed9t c\u00e1ch g\u1ecdn g\u00e0ng.<\/p>\n<h2>So s\u00e1nh INDEX MATCH v\u00e0 VLOOKUP<\/h2>\n<p>C\u1ea3 hai \u0111\u1ec1u d\u00f9ng \u0111\u1ec3 tra c\u1ee9u, nh\u01b0ng INDEX MATCH linh ho\u1ea1t h\u01a1n trong h\u1ea7u h\u1ebft t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf. B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y t\u00f3m t\u1eaft kh\u00e1c bi\u1ec7t ch\u00ednh:<\/p>\n<table>\n<thead>\n<tr>\n<th>Ti\u00eau ch\u00ed<\/th>\n<th>VLOOKUP<\/th>\n<th>INDEX MATCH<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Chi\u1ec1u d\u00f2 t\u00ecm<\/td>\n<td>Ch\u1ec9 d\u00f2 t\u1eeb tr\u00e1i sang ph\u1ea3i<\/td>\n<td>D\u00f2 \u0111\u01b0\u1ee3c c\u1ea3 sang tr\u00e1i v\u00e0 ph\u1ea3i<\/td>\n<\/tr>\n<tr>\n<td>Ph\u1ee5 thu\u1ed9c v\u1ecb tr\u00ed c\u1ed9t<\/td>\n<td>Ph\u1ea3i \u0111\u1ebfm v\u00e0 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t<\/td>\n<td>Kh\u00f4ng c\u1ea7n, ch\u1ec9 ch\u1ecdn c\u1ed9t k\u1ebft qu\u1ea3<\/td>\n<\/tr>\n<tr>\n<td>Khi ch\u00e8n\/x\u00f3a c\u1ed9t<\/td>\n<td>D\u1ec5 b\u1ecb sai k\u1ebft qu\u1ea3<\/td>\n<td>\u1ed4n \u0111\u1ecbnh, \u00edt b\u1ecb \u1ea3nh h\u01b0\u1edfng<\/td>\n<\/tr>\n<tr>\n<td>Hi\u1ec7u su\u1ea5t v\u1edbi b\u1ea3ng l\u1edbn<\/td>\n<td>Ch\u1eadm h\u01a1n khi c\u1ed9t tra c\u1ee9u r\u1ed9ng<\/td>\n<td>Nhanh h\u01a1n, ch\u1ec9 x\u1eed l\u00fd c\u1ed9t c\u1ea7n thi\u1ebft<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>N\u1ebfu b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u, h\u00e3y tham kh\u1ea3o th\u00eam b\u00e0i <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\">h\u00e0m VLOOKUP trong Excel<\/a> \u0111\u1ec3 so s\u00e1nh tr\u1ef1c ti\u1ebfp v\u00e0 ch\u1ecdn c\u00f4ng th\u1ee9c ph\u00f9 h\u1ee3p cho t\u1eebng nhu c\u1ea7u.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-570481 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-3.jpg\" alt=\"ham-index-match-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng INDEX MATCH<\/h2>\n<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p m\u1ed9t v\u00e0i l\u1ed7i ph\u1ed5 bi\u1ebfn sau:<\/p>\n<ul>\n<li><strong>L\u1ed7i #N\/A:<\/strong> Xu\u1ea5t hi\u1ec7n khi MATCH kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb d\u00f2. Nguy\u00ean nh\u00e2n th\u01b0\u1eddng do sai ch\u00ednh t\u1ea3, th\u1eeba kho\u1ea3ng tr\u1eafng, ho\u1eb7c d\u1eef li\u1ec7u \u1edf d\u1ea1ng text v\u00e0 s\u1ed1 kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t. B\u1ea1n c\u00f3 th\u1ec3 xem c\u00e1ch x\u1eed l\u00fd trong b\u00e0i <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-na\/\">s\u1eeda l\u1ed7i #N\/A trong Excel<\/a>.<\/li>\n<li><strong>L\u1ed7i #REF!:<\/strong> X\u1ea3y ra khi v\u1ecb tr\u00ed MATCH tr\u1ea3 v\u1ec1 v\u01b0\u1ee3t qu\u00e1 ph\u1ea1m vi v\u00f9ng c\u1ee7a INDEX (v\u00ed d\u1ee5 v\u00f9ng d\u1eef li\u1ec7u v\u00e0 c\u1ed9t d\u00f2 kh\u00f4ng c\u00f9ng s\u1ed1 d\u00f2ng).<\/li>\n<li><strong>Sai match_type:<\/strong> Qu\u00ean nh\u1eadp s\u1ed1 0 khi\u1ebfn MATCH d\u00f2 g\u1ea7n \u0111\u00fang v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng mong mu\u1ed1n khi d\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/li>\n<li><strong>V\u00f9ng ch\u1ecdn l\u1ec7ch d\u00f2ng:<\/strong> C\u1ed9t k\u1ebft qu\u1ea3 v\u00e0 c\u1ed9t d\u00f2 ph\u1ea3i b\u1eaft \u0111\u1ea7u \u1edf c\u00f9ng m\u1ed9t d\u00f2ng, n\u1ebfu kh\u00f4ng k\u1ebft qu\u1ea3 s\u1ebd b\u1ecb l\u1ec7ch m\u1ed9t v\u00e0i d\u00f2ng.<\/li>\n<\/ul>\n<h2>B\u00e0i t\u1eadp v\u1eadn d\u1ee5ng c\u00f3 l\u1eddi gi\u1ea3i<\/h2>\n<ul>\n<li><strong>B\u00e0i 1:<\/strong> Vi\u1ebft c\u00f4ng th\u1ee9c t\u00ecm \u0111i\u1ec3m c\u1ee7a &#8220;Lan&#8221; (t\u00ean \u1edf c\u1ed9t A, \u0111i\u1ec3m \u1edf c\u1ed9t B). L\u1eddi gi\u1ea3i: =INDEX(B:B, MATCH(&#8220;Lan&#8221;, A:A, 0)).<\/li>\n<li><strong>B\u00e0i 2:<\/strong> S\u1ed1 0 trong h\u00e0m MATCH c\u00f3 \u00fd ngh\u0129a g\u00ec? L\u1eddi gi\u1ea3i: y\u00eau c\u1ea7u MATCH t\u00ecm ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i gi\u00e1 tr\u1ecb d\u00f2.<\/li>\n<li><strong>B\u00e0i 3:<\/strong> \u01afu \u0111i\u1ec3m ch\u00ednh c\u1ee7a INDEX MATCH so v\u1edbi VLOOKUP l\u00e0 g\u00ec? L\u1eddi gi\u1ea3i: d\u00f2 \u0111\u01b0\u1ee3c c\u1ea3 sang tr\u00e1i v\u00e0 kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o v\u1ecb tr\u00ed c\u1ed9t.<\/li>\n<li><strong>B\u00e0i 4 (tr\u1eafc nghi\u1ec7m):<\/strong> H\u00e0m n\u00e0o tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm? A. INDEX B. MATCH C. SUM D. IF. \u0110\u00e1p \u00e1n: B.<\/li>\n<li><strong>B\u00e0i 5:<\/strong> Mu\u1ed1n tra c\u1ee9u \u0111\u1ed3ng th\u1eddi theo c\u1ea3 t\u00ean v\u00e0 m\u00f4n h\u1ecdc, b\u1ea1n d\u00f9ng c\u1ea5u tr\u00fac n\u00e0o? L\u1eddi gi\u1ea3i: INDEX k\u1ebft h\u1ee3p hai h\u00e0m MATCH (INDEX MATCH MATCH).<\/li>\n<\/ul>\n<p><strong>Xem th\u00eam: <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/microsoft-excel-huong-dan-toan-dien-tu-a-z\/\">Microsoft Excel: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n t\u1eeb A-Z<\/a><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-570482 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-4.jpg\" alt=\"ham-index-match-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m INDEX MATCH<\/h2>\n<h3>H\u00e0m INDEX MATCH l\u00e0 g\u00ec?<\/h3>\n<p>L\u00e0 s\u1ef1 k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u linh ho\u1ea1t trong Excel, trong \u0111\u00f3 MATCH t\u00ecm v\u1ecb tr\u00ed c\u00f2n INDEX l\u1ea5y gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<h3>C\u00fa ph\u00e1p INDEX MATCH c\u01a1 b\u1ea3n l\u00e0 g\u00ec?<\/h3>\n<p>C\u00fa ph\u00e1p ph\u1ed5 bi\u1ebfn l\u00e0 =INDEX(c\u1ed9t k\u1ebft qu\u1ea3, MATCH(gi\u00e1 tr\u1ecb d\u00f2, c\u1ed9t d\u00f2, 0)).<\/p>\n<h3>H\u00e0m MATCH l\u00e0m nhi\u1ec7m v\u1ee5 g\u00ec trong c\u00f4ng th\u1ee9c?<\/h3>\n<p>MATCH tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed (s\u1ed1 th\u1ee9 t\u1ef1) c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong h\u00e0ng ho\u1eb7c c\u1ed9t, \u0111\u1ec3 INDEX bi\u1ebft c\u1ea7n l\u1ea5y \u00f4 n\u00e0o.<\/p>\n<h3>INDEX MATCH kh\u00e1c VLOOKUP nh\u01b0 th\u1ebf n\u00e0o?<\/h3>\n<p>INDEX MATCH d\u00f2 \u0111\u01b0\u1ee3c c\u1ea3 sang tr\u00e1i, kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u1ecb tr\u00ed c\u1ed9t v\u00e0 \u1ed5n \u0111\u1ecbnh h\u01a1n khi ch\u00e8n ho\u1eb7c x\u00f3a c\u1ed9t.<\/p>\n<h3>S\u1ed1 0 trong h\u00e0m MATCH ngh\u0129a l\u00e0 g\u00ec?<\/h3>\n<p>S\u1ed1 0 (ho\u1eb7c FALSE) y\u00eau c\u1ea7u MATCH d\u00f2 t\u00ecm ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<h3>V\u00ec sao INDEX MATCH b\u00e1o l\u1ed7i #N\/A?<\/h3>\n<p>Th\u01b0\u1eddng do MATCH kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb d\u00f2 v\u00ec sai ch\u00ednh t\u1ea3, d\u01b0 kho\u1ea3ng tr\u1eafng ho\u1eb7c l\u1ec7ch \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u gi\u1eefa text v\u00e0 s\u1ed1.<\/p>\n<h2>K\u1ebft lu\u1eadn<\/h2>\n<p>T\u00f3m l\u1ea1i, h\u00e0m INDEX MATCH k\u1ebft h\u1ee3p hai h\u00e0m INDEX v\u00e0 MATCH \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n, d\u00f2 t\u00ecm \u0111\u01b0\u1ee3c theo c\u1ea3 hai chi\u1ec1u v\u00e0 \u00edt ph\u1ee5 thu\u1ed9c v\u00e0o v\u1ecb tr\u00ed c\u1ed9t h\u01a1n VLOOKUP. Khi n\u1eafm v\u1eefng b\u1ed9 \u0111\u00f4i n\u00e0y c\u00f9ng c\u00e1ch x\u1eed l\u00fd c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p, b\u1ea1n s\u1ebd tra c\u1ee9u v\u00e0 x\u1eed l\u00fd b\u1ea3ng t\u00ednh nhanh g\u1ecdn, ch\u00ednh x\u00e1c h\u01a1n nhi\u1ec1u. \u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam, m\u1eddi b\u1ea1n tham kh\u1ea3o c\u00e1c b\u00e0i <strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/\">h\u00e0m IF trong Excel<\/a><\/strong> v\u00e0 <strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-check-cau-hinh-may-tinh\/\">c\u00e1ch check c\u1ea5u h\u00ecnh m\u00e1y t\u00ednh<\/a><\/strong> tr\u00ean chuy\u00ean m\u1ee5c tin t\u1ee9c c\u1ee7a Ho\u00e0ng H\u00e0 Mobile.<\/p>\n<p><script type=\"application\/ld+json\">\n{\"@context\":\"https:\/\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"H\u00e0m INDEX MATCH l\u00e0 g\u00ec?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"L\u00e0 s\u1ef1 k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u linh ho\u1ea1t trong Excel, trong \u0111\u00f3 MATCH t\u00ecm v\u1ecb tr\u00ed c\u00f2n INDEX l\u1ea5y gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng.\"}},{\"@type\":\"Question\",\"name\":\"C\u00fa ph\u00e1p INDEX MATCH c\u01a1 b\u1ea3n l\u00e0 g\u00ec?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"C\u00fa ph\u00e1p ph\u1ed5 bi\u1ebfn l\u00e0 =INDEX(c\u1ed9t k\u1ebft qu\u1ea3, MATCH(gi\u00e1 tr\u1ecb d\u00f2, c\u1ed9t d\u00f2, 0)).\"}},{\"@type\":\"Question\",\"name\":\"H\u00e0m MATCH l\u00e0m nhi\u1ec7m v\u1ee5 g\u00ec trong c\u00f4ng th\u1ee9c?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"MATCH tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed (s\u1ed1 th\u1ee9 t\u1ef1) c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong h\u00e0ng ho\u1eb7c c\u1ed9t, \u0111\u1ec3 INDEX bi\u1ebft c\u1ea7n l\u1ea5y \u00f4 n\u00e0o.\"}},{\"@type\":\"Question\",\"name\":\"INDEX MATCH kh\u00e1c VLOOKUP nh\u01b0 th\u1ebf n\u00e0o?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"INDEX MATCH d\u00f2 \u0111\u01b0\u1ee3c c\u1ea3 sang tr\u00e1i, kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u1ecb tr\u00ed c\u1ed9t v\u00e0 \u1ed5n \u0111\u1ecbnh h\u01a1n khi ch\u00e8n ho\u1eb7c x\u00f3a c\u1ed9t.\"}},{\"@type\":\"Question\",\"name\":\"S\u1ed1 0 trong h\u00e0m MATCH ngh\u0129a l\u00e0 g\u00ec?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"S\u1ed1 0 (ho\u1eb7c FALSE) y\u00eau c\u1ea7u MATCH d\u00f2 t\u00ecm ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.\"}},{\"@type\":\"Question\",\"name\":\"V\u00ec sao INDEX MATCH b\u00e1o l\u1ed7i #N\/A?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Th\u01b0\u1eddng do MATCH kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb d\u00f2 v\u00ec sai ch\u00ednh t\u1ea3, d\u01b0 kho\u1ea3ng tr\u1eafng ho\u1eb7c l\u1ec7ch \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u gi\u1eefa text v\u00e0 s\u1ed1.\"}}]}\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m INDEX MATCH trong Excel l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa hai h\u00e0m INDEX v\u00e0 MATCH, gi\u00fap b\u1ea1n tra c\u1ee9u v\u00e0 l\u1ea5y d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n h\u1eb3n so v\u1edbi h\u00e0m VLOOKUP quen thu\u1ed9c. C\u00fa ph\u00e1p ph\u1ed5 bi\u1ebfn c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 INDEX(v\u00f9ng d\u1eef li\u1ec7u, MATCH(gi\u00e1 tr\u1ecb d\u00f2, v\u00f9ng d\u00f2, 0)). \u0110i\u1ec3m m\u1ea1nh c\u1ee7a INDEX [&hellip;]<\/p>\n","protected":false},"author":65,"featured_media":570478,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"h\u00e0m index match","_yoast_wpseo_title":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng","_yoast_wpseo_metadesc":"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.","footnotes":""},"categories":[28955,3910,16,412],"tags":[],"class_list":["post-570248","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-kham-pha","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 INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng<\/title>\n<meta name=\"description\" content=\"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.\" \/>\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-index-match\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-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=\"2026-07-27T03:21:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-27T03:21:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-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=\"Vo Giang\" \/>\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=\"Vo Giang\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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-index-match\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/\"},\"author\":{\"name\":\"Vo Giang\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/72d0493d28396e6a0cdc358e9260c03c\"},\"headline\":\"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5\",\"datePublished\":\"2026-07-27T03:21:04+00:00\",\"dateModified\":\"2026-07-27T03:21:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/\"},\"wordCount\":2015,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/ham-index-match.jpg\",\"articleSection\":[\"Excel\",\"Kh\u00e1m Ph\u00e1\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/\",\"name\":\"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/ham-index-match.jpg\",\"datePublished\":\"2026-07-27T03:21:04+00:00\",\"dateModified\":\"2026-07-27T03:21:21+00:00\",\"description\":\"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\\\/A.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/ham-index-match.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/ham-index-match.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-index-match\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-index-match\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 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\\\/72d0493d28396e6a0cdc358e9260c03c\",\"name\":\"Vo Giang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g\",\"caption\":\"Vo Giang\"},\"description\":\"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"],\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/giang-vo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng","description":"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.","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-index-match\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5","og_description":"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-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":"2026-07-27T03:21:04+00:00","article_modified_time":"2026-07-27T03:21:21+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match.jpg","type":"image\/jpeg"}],"author":"Vo Giang","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Giang","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"5 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/"},"author":{"name":"Vo Giang","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/72d0493d28396e6a0cdc358e9260c03c"},"headline":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5","datePublished":"2026-07-27T03:21:04+00:00","dateModified":"2026-07-27T03:21:21+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/"},"wordCount":2015,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match.jpg","articleSection":["Excel","Kh\u00e1m Ph\u00e1","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/","name":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match.jpg","datePublished":"2026-07-27T03:21:04+00:00","dateModified":"2026-07-27T03:21:21+00:00","description":"H\u00e0m INDEX MATCH trong Excel gi\u00fap tra c\u1ee9u d\u1eef li\u1ec7u 2 chi\u1ec1u linh ho\u1ea1t h\u01a1n VLOOKUP. Xem ngay c\u00fa ph\u00e1p, v\u00ed d\u1ee5 c\u00f3 l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/07\/ham-index-match.jpg","width":1200,"height":628,"caption":"ham-index-match"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-index-match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m INDEX MATCH trong Excel: c\u00e1ch d\u00f9ng v\u00e0 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\/72d0493d28396e6a0cdc358e9260c03c","name":"Vo Giang","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/77997fb123ed6295d07f6612ad5a1afc8283a96f9c379981b21365a22e2cff35?s=96&d=mm&r=g","caption":"Vo Giang"},"description":"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/570248","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\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=570248"}],"version-history":[{"count":3,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/570248\/revisions"}],"predecessor-version":[{"id":570804,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/570248\/revisions\/570804"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/570478"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=570248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=570248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=570248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}