{"id":5810,"date":"2025-12-04T14:35:00","date_gmt":"2025-12-04T07:35:00","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-index-trong-excel-cong-thuc-va-cach-su-dung\/"},"modified":"2025-12-04T14:35:00","modified_gmt":"2025-12-04T07:35:00","slug":"ham-index-trong-excel-cong-thuc-va-cach-su-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-index-trong-excel-cong-thuc-va-cach-su-dung\/","title":{"rendered":"H\u00e0m INDEX trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>H\u00e0m INDEX trong Excel cho ph\u00e9p b\u1ea1n l\u1ea5y d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u1ecb tr\u00ed h\u00e0ng \u2013 c\u1ed9t trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 r\u00f5 r\u00e0ng. B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda, gi\u00fap b\u1ea1n \u00e1p d\u1ee5ng h\u00e0m INDEX v\u00e0o c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<p><img decoding=\"async\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m INDEX trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-1.jpg\" title=\"ham-index-trong-excel-1\"><em>C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. C\u00f4ng th\u1ee9c h\u00e0m INDEX trong Excel<\/h2>\n<\/div>\n<p>H\u00e0m INDEX trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c m\u1ed9t tham chi\u1ebfu n\u1eb1m trong m\u1ed9t b\u1ea3ng ho\u1eb7c m\u1ed9t ph\u1ea1m vi x\u00e1c \u0111\u1ecbnh.<\/p>\n<p><strong>C\u00fa ph\u00e1p:<\/strong><\/p>\n<p>=INDEX(array, row_num, column_num)<\/p>\n<p><strong>Gi\u1ea3i th\u00edch c\u00e1c tham s\u1ed1<\/strong><\/p>\n<ul>\n<li><strong>array: <\/strong>Ph\u1ea1m vi d\u1eef li\u1ec7u ho\u1eb7c m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng.<\/li>\n<li>N\u1ebfu m\u1ea3ng ch\u1ec9 c\u00f3 m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua l\u1ea7n l\u01b0\u1ee3t row_num ho\u1eb7c column_num.<\/li>\n<li>Khi m\u1ea3ng c\u00f3 nhi\u1ec1u h\u00e0ng v\u00e0 nhi\u1ec1u c\u1ed9t nh\u01b0ng b\u1ea1n ch\u1ec9 cung c\u1ea5p m\u1ed9t trong hai tham s\u1ed1 row_num ho\u1eb7c column_num, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 h\u00e0ng ho\u1eb7c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng.<\/li>\n<li><strong>row_num: <\/strong>Ch\u1ec9 s\u1ed1 h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y. \u0110\u00e2y l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c n\u1ebfu column_num b\u1ecb b\u1ecf tr\u1ed1ng. N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp row_num, b\u1ea1n ph\u1ea3i nh\u1eadp column_num.<\/li>\n<li><strong>column_num: <\/strong>Ch\u1ec9 s\u1ed1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y. T\u01b0\u01a1ng t\u1ef1, n\u1ebfu kh\u00f4ng d\u00f9ng column_num th\u00ec ph\u1ea3i khai b\u00e1o row_num.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng:<\/strong><\/p>\n<ul>\n<li>Khi c\u1ea3 row_num v\u00e0 column_num \u0111\u1ec1u \u0111\u01b0\u1ee3c cung c\u1ea5p, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i v\u1ecb tr\u00ed giao nhau c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t \u0111\u00f3.<\/li>\n<li>H\u00e0m s\u1ebd b\u00e1o l\u1ed7i #REF! n\u1ebfu hai tham s\u1ed1 n\u00e0y kh\u00f4ng tr\u1ecf \u0111\u1ebfn \u00f4 h\u1ee3p l\u1ec7 trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/li>\n<li>N\u1ebfu row_num ho\u1eb7c column_num b\u1eb1ng 0, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 h\u00e0ng ho\u1eb7c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng (khi \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng).<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"Minh h\u1ecda nh\u1eadp h\u00e0m INDEX trong b\u1ea3ng d\u1eef li\u1ec7u\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-2.jpg\" title=\"ham-index-trong-excel-2\"><em>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m INDEX trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX trong Excel<\/h2>\n<\/div>\n<p><strong>V\u00ed d\u1ee5 1: S\u1eed d\u1ee5ng h\u00e0m INDEX \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i h\u00e0ng v\u00e0 c\u1ed9t trong m\u1ea3ng<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a h\u00e0m<\/p>\n<ul>\n<li><strong>array: <\/strong>ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u l\u00e0 B2:F9<\/li>\n<li><strong>row_num: <\/strong>h\u00e0ng c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u l\u00e0 4<\/li>\n<li><strong>column_num: <\/strong>c\u1ed9t c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u l\u00e0 2<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c nh\u1eadp v\u00e0o \u00f4 nh\u01b0 sau:<\/p>\n<p>=INDEX(B2:F9,4,2)<\/p>\n<p><img decoding=\"async\" alt=\"S\u1eed d\u1ee5ng INDEX \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb theo d\u00f2ng v\u00e0 c\u1ed9t trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-3.jpg\" title=\"ham-index-trong-excel-3\"><em>C\u00f4ng th\u1ee9c INDEX tra c\u1ee9u gi\u00e1 tr\u1ecb t\u1ea1i h\u00e0ng 4 v\u00e0 c\u1ed9t 2 trong m\u1ea3ng<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n <strong>Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3<\/p>\n<p>H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf v\u1ecb tr\u00ed giao gi\u1eefa h\u00e0ng 4 v\u00e0 c\u1ed9t 2 c\u1ee7a m\u1ea3ng, \u0111\u00f3 l\u00e0: Nguy\u1ec5n Thu H\u00e0<\/p>\n<p><img decoding=\"async\" alt=\"H\u00e0m INDEX tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u1eeb hai v\u00f9ng d\u1eef li\u1ec7u trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-6.jpg\" title=\"ham-index-trong-excel-6\"><em>K\u1ebft qu\u1ea3 h\u00e0m INDEX tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1ecb tr\u00ed h\u00e0ng 4 c\u1ed9t 2<\/em><\/p>\n<p><strong>V\u00ed d\u1ee5 2: D\u00f9ng h\u00e0m INDEX n\u00e2ng cao \u0111\u1ec3 truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u v\u00f9ng m\u1ea3ng<\/strong><\/p>\n<p>H\u00e0m INDEX m\u1edf r\u1ed9ng c\u00f3 d\u1ea1ng:<\/p>\n<p>=INDEX(reference, row_num, [column_num], [area_num])<\/p>\n<p><strong>Gi\u1ea3i th\u00edch c\u00e1c tham s\u1ed1:<\/strong><\/p>\n<ul>\n<li><strong>reference: <\/strong>t\u1eadp h\u1ee3p c\u00e1c v\u00f9ng d\u1eef li\u1ec7u d\u00f9ng l\u00e0m ngu\u1ed3n truy xu\u1ea5t (c\u00f3 th\u1ec3 g\u1ed3m m\u1ed9t ho\u1eb7c nhi\u1ec1u m\u1ea3ng gh\u00e9p l\u1ea1i).<\/li>\n<li><strong>row_num: <\/strong>s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn m\u00e0 h\u00e0m s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb.<\/li>\n<li><strong>column_num: <\/strong>v\u1ecb tr\u00ed c\u1ed9t trong v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n<li><strong>area_num: <\/strong>x\u00e1c \u0111\u1ecbnh m\u1ea3ng n\u00e0o trong danh s\u00e1ch reference s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. \u0110\u00e2y l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a t\u1eebng v\u00f9ng trong reference; n\u1ebfu kh\u00f4ng nh\u1eadp, Excel t\u1ef1 hi\u1ec3u l\u00e0 v\u00f9ng s\u1ed1 1.<\/li>\n<\/ul>\n<p>Gi\u1ea3 s\u1eed b\u1ea3ng nh\u00e2n s\u1ef1 \u0111\u01b0\u1ee3c chia th\u00e0nh 2 v\u00f9ng:<\/p>\n<ul>\n<li><strong>V\u00f9ng 1 (m\u1ea3ng 1):<\/strong> B2:F5<\/li>\n<li><strong>V\u00f9ng 2 (m\u1ea3ng 2): <\/strong>B6:F9<\/li>\n<li><strong>M\u1ee5c ti\u00eau: <\/strong>L\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i h\u00e0ng th\u1ee9 2 \u2013 c\u1ed9t th\u1ee9 2 c\u1ee7a m\u1ea3ng s\u1ed1 2.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh tham s\u1ed1<\/p>\n<ul>\n<li>reference = (B2:F5, B6:F9)<\/li>\n<li>row_num = 2<\/li>\n<li>column_num = 2<\/li>\n<li>area_num = 2<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/p>\n<p>=INDEX((B2:F5,B6:F9),2,2,2)<\/p>\n<p><img decoding=\"async\" alt=\"H\u00e0m INDEX tham chi\u1ebfu nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-5.jpg\" title=\"ham-index-trong-excel-5\"><em>Thi\u1ebft l\u1eadp 2 v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eed d\u1ee5ng INDEX n\u00e2ng cao<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n <strong>Enter <\/strong>\u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3<\/p>\n<p>H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb: H\u00e0 V\u0103n Th\u1edbi<\/p>\n<p><img decoding=\"async\" alt=\"H\u00e0m INDEX tr\u1ea3 v\u1ec1 t\u00ean nh\u00e2n vi\u00ean trong b\u1ea3ng Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-4.jpg\" title=\"ham-index-trong-excel-4\"><em>C\u00f4ng th\u1ee9c INDEX nhi\u1ec1u v\u00f9ng l\u1ea5y gi\u00e1 tr\u1ecb h\u00e0ng 2 c\u1ed9t 2 c\u1ee7a m\u1ea3ng th\u1ee9 2<\/em><\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/div>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m INDEX<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab3_1\">\n<h3>3.1. L\u1ed7i #N\/A ho\u1eb7c #VALUE!<\/h3>\n<\/div>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n<ul>\n<li>Khi d\u00f9ng INDEX \u0111\u1ec3 tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t row_num ho\u1eb7c column_num b\u1eb1ng 0. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y y\u00eau c\u1ea7u c\u00f4ng th\u1ee9c ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<li>\u1ede nh\u1eefng phi\u00ean b\u1ea3n Excel c\u0169 (kh\u00f4ng ph\u1ea3i Microsoft 365), n\u1ebfu b\u1ea1n ch\u1ec9 nh\u1ea5n Enter th\u00f4ng th\u01b0\u1eddng th\u00ec Excel s\u1ebd b\u00e1o l\u1ed7i #N\/A ho\u1eb7c #VALUE!.<\/li>\n<\/ul>\n<p><strong>C\u00e1ch x\u1eed l\u00fd:<\/strong><\/p>\n<ul>\n<li>V\u1edbi Excel truy\u1ec1n th\u1ed1ng (kh\u00f4ng ph\u1ea3i Microsoft 365):<\/li>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng s\u1ebd nh\u1eadn k\u1ebft qu\u1ea3<\/li>\n<li>G\u00f5 c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng<\/li>\n<li>Sau \u0111\u00f3 nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng k\u1ebf th\u1eeba<\/li>\n<li>V\u1edbi Microsoft 365 ho\u1eb7c Excel Online, b\u1ea1n ch\u1ec9 c\u1ea7n Enter v\u00ec h\u1ec7 th\u1ed1ng h\u1ed7 tr\u1ee3 c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: <\/strong>Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n h\u00e0m INDEX tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t th\u1ee9 nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u B4:E13, b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh ph\u1ea1m vi s\u1ebd ch\u1ee9a k\u1ebft qu\u1ea3. \u1ede v\u00ed d\u1ee5 n\u00e0y, ta c\u1ea7n 10 h\u00e0ng n\u00ean ch\u1ecdn v\u00f9ng G4:G13.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng \u0111\u1ea7u ra (\u00f4 G4):<\/p>\n<p>=INDEX(B4:E13,0,1)<\/p>\n<p><img decoding=\"async\" alt=\"H\u00e0m INDEX trong Excel v\u1edbi ph\u1ea1m vi \u0111\u1ea7u ra \u0111\u01b0\u1ee3c ch\u1ecdn\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-7.jpg\" title=\"ham-index-trong-excel-7\"><em>D\u00f9ng INDEX \u0111\u1ec3 tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t c\u1ed9t<\/em><\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>C\u00f4ng th\u1ee9c n\u00e0y y\u00eau c\u1ea7u nh\u1eadp d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169.<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Gi\u1eef nguy\u00ean v\u00f9ng G4:G13 \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn, sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + Shift + Enter<\/strong>. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam d\u1ea5u ngo\u1eb7c nh\u1ecdn <strong>{ } <\/strong>bao quanh c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u00e1c nh\u1eadn \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb \u1edf c\u1ed9t th\u1ee9 nh\u1ea5t c\u1ee7a m\u1ea3ng B4:E13.<\/p>\n<p><img decoding=\"async\" alt=\"Th\u1ef1c hi\u1ec7n t\u1ed5 h\u1ee3p Ctrl Shift Enter \u0111\u1ec3 ch\u1ea1y INDEX m\u1ea3ng trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-8.jpg\" title=\"ham-index-trong-excel-8\"><em>K\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c m\u1ea3ng INDEX hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a c\u1ed9t \u0111\u1ea7u ti\u00ean<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_2\">\n<h3>3.2. L\u1ed7i #REF!<\/h3>\n<\/div>\n<p>L\u1ed7i #REF! xu\u1ea5t hi\u1ec7n khi c\u1eb7p tham s\u1ed1 row_num v\u00e0 column_num ch\u1ec9 t\u1edbi v\u1ecb tr\u00ed kh\u00f4ng t\u1ed3n t\u1ea1i trong m\u1ea3ng \u0111\u00e3 khai b\u00e1o.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> Ph\u1ea1m vi ch\u1ec9 g\u1ed3m 5 c\u1ed9t nh\u01b0ng b\u1ea1n l\u1ea1i nh\u1eadp column_num = 6, Excel s\u1ebd b\u00e1o l\u1ed7i #REF!.<\/p>\n<p><img decoding=\"async\" alt=\"L\u1ed7i #REF khi nh\u1eadp sai \u0111\u1ed1i s\u1ed1 trong h\u00e0m INDEX Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/ham-index-trong-excel-9.jpg\" title=\"ham-index-trong-excel-9\"><em>V\u00ed d\u1ee5 l\u1ed7i #REF! khi row_num ho\u1eb7c column_num v\u01b0\u1ee3t ngo\u00e0i ph\u1ea1m vi m\u1ea3ng<\/em><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c: <\/strong>Xem l\u1ea1i to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c, \u0111\u1eb7c bi\u1ec7t l\u00e0 hai tham s\u1ed1 row_num v\u00e0 column_num, \u0111\u1ea3m b\u1ea3o ch\u00fang n\u1eb1m trong gi\u1edbi h\u1ea1n s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t th\u1ef1c t\u1ebf c\u1ee7a m\u1ea3ng, sau \u0111\u00f3 s\u1eeda l\u1ea1i cho \u0111\u00fang.<\/p>\n<p>H\u00e0m INDEX mang l\u1ea1i s\u1ef1 linh ho\u1ea1t khi b\u1ea1n c\u1ea7n truy xu\u1ea5t d\u1eef li\u1ec7u trong nh\u1eefng b\u1ea3ng t\u00ednh l\u1edbn, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch cho c\u00e1c thao t\u00e1c t\u00ecm ki\u1ebfm theo h\u00e0ng v\u00e0 c\u1ed9t. \u0110\u1ec3 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u m\u1eb9o Excel d\u1ec5 hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng nhanh, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<p>Tham kh\u1ea3o ngay c\u00e1c d\u00f2ng m\u00e1y t\u00ednh b\u1ea3ng c\u1ea5u h\u00ecnh m\u1ea1nh, m\u00e0n h\u00ecnh \u0111\u1eb9p v\u00e0 nhi\u1ec1u m\u1ee9c gi\u00e1 linh ho\u1ea1t \u0111ang c\u00f3 t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn m\u1eabu ph\u00f9 h\u1ee3p cho h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c ho\u1eb7c gi\u1ea3i tr\u00ed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 H\u00e0m INDEX trong Excel cho ph\u00e9p b\u1ea1n l\u1ea5y d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u1ecb tr\u00ed h\u00e0ng \u2013 c\u1ed9t trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 r\u00f5 r\u00e0ng. B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda, gi\u00fap b\u1ea1n \u00e1p d\u1ee5ng h\u00e0m INDEX v\u00e0o c\u00f4ng vi\u1ec7c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/19564.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5810"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5811"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}