{"id":24050,"date":"2021-05-07T08:53:57","date_gmt":"2021-05-07T01:53:57","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24050"},"modified":"2021-05-07T08:57:12","modified_gmt":"2021-05-07T01:57:12","slug":"ham-index-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-index-trong-excel\/","title":{"rendered":"H\u00e0m Index trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"<p><strong>H\u00e0m Index trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 giao gi\u1eefa c\u1ed9t v\u00e0 d\u00f2ng. H\u00e0m Index th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Match trong Excel. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p <strong>h\u00e0m Index trong Excel<\/strong> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"2003\" height=\"1011\" class=\"wp-image-24051\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel.png\" alt=\"H\u00e0m Index trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel.png 2003w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-300x151.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-1024x517.png 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-768x388.png 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-1536x775.png 1536w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-750x379.png 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-index-trong-excel-1140x575.png 1140w\" sizes=\"auto, (max-width: 2003px) 100vw, 2003px\" \/><\/p>\n<h2><strong>1. H\u00e0m Index d\u1ea1ng M\u1ea3ng trong Excel<\/strong><\/h2>\n<p>H\u00e0m Index d\u1ea1ng m\u1ea3ng \u0111\u01b0\u1ee3c s\u1ee7 d\u1ee5ng n\u1ebfu \u0111\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t c\u1ee7a h\u00e0m l\u00e0 m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng.<\/p>\n<p>H\u00e0m Index m\u1ea3ng c\u00f3 d\u1ea1ng, c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=INDEX(array, row_num, [col_num])<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>\u2013 Array<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 m\u1ea3ng ho\u1eb7c d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p><strong>\u2013 Row_num<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): ch\u1ecdn h\u00e0ng trong m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb.<\/p>\n<p><strong>\u2013 Col_num<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): ch\u1ecdn c\u1ed9t trong m\u1ea3ng t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb.<\/p>\n<p><strong>L\u01b0u \u00fd quan tr\u1ecdng:<\/strong>\u00a0Ph\u1ea3i c\u00f3 \u00edt nh\u1ea5t m\u1ed9t trong hai \u0111\u1ed1i s\u1ed1 Row_num v\u00e0 Column_num \u0111\u1ec3 h\u00e0m Index m\u1ea3ng ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang c\u00e1ch, kh\u00f4ng b\u1ecb l\u1ed7i x\u1ea3y ra.<\/p>\n<h2><strong>2. H\u00e0m Index d\u1ea1ng tham chi\u1ebfu<\/strong><\/h2>\n<p>H\u00e0m Index d\u1ea1ng tham chi\u1ebfu \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu ch\u00fang ta mu\u1ed1n tr\u1ea3 v\u1ec1 tham chi\u1ebfu c\u1ee7a \u00f4 n\u1eb1m \u1edf giao c\u1ee7a m\u1ed9t h\u00e0ng v\u00e0 m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3.<\/p>\n<h3><strong>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m Index d\u1ea1ng tham chi\u1ebfu<\/strong><\/h3>\n<p>C\u00fa ph\u00e1p h\u00e0m Index d\u1ea1ng tham chi\u1ebfu c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=INDEX(reference, row_num, [column_num], [area_num])<\/strong><\/p><\/blockquote>\n<p>Trong h\u00e0m tr\u00ean:<\/p>\n<p><strong>\u2013 Reference (<\/strong>tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu nh\u1eadp nhi\u1ec1u v\u00f9ng tham chi\u1ebfu, c\u00e1c v\u00f9ng ph\u1ea3i \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y.<\/p>\n<p><strong>\u2013 Row_num<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 ch\u1ec9 s\u1ed1 h\u00e0ng t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu.<\/p>\n<p><strong>\u2013 Column_num<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): ch\u1ec9 s\u1ed1 c\u1ed9t t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu.<\/p>\n<p><strong>\u2013 Area_num<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): s\u1ed1 c\u1ee7a v\u00f9ng \u00f4 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong Reference. N\u1ebfu Area_num \u0111\u01b0\u1ee3c b\u1ecf qua th\u00ec h\u00e0m INDEX d\u00f9ng v\u00f9ng 1.<\/p>\n<h3><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Index d\u1ea1ng tham chi\u1ebfu<\/strong><\/h3>\n<ul>\n<li>Tham s\u1ed1 row_num ho\u1eb7c column_num l\u00e0 0 th\u00ec h\u00e0m Index tr\u1ea3 v\u1ec1 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p n\u1ebfu c\u1ea3 tham s\u1ed1 row_num v\u00e0 column_num b\u1ecb b\u1ecf qua, h\u00e0m Index tr\u1ea3 v\u1ec1 v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong \u0111\u1ed1i s\u1ed1 area_num.<\/li>\n<li>T\u1ea5t c\u1ea3 tham s\u1ed1 row_num, column_num v\u00e0 area_num ph\u1ea3i tham kh\u1ea3o m\u1ed9t \u00f4 trong tham chi\u1ebfu, n\u1ebfu kh\u00f4ng h\u00e0m Index tr\u1ea3 v\u1ec1 l\u1ed7i #REF!.<\/li>\n<li>K\u1ebft qu\u1ea3 h\u00e0m Index tr\u1ea3 v\u1ec1 l\u00e0 tham chi\u1ebfu. Tu\u0300y thu\u00f4\u0323c va\u0300o c\u00fa ph\u00e1p h\u00e0m Excel, k\u1ebft qu\u1ea3 ma\u0300 ha\u0300m Index tra\u0309 v\u00ea\u0300 co\u0301 th\u00ea\u0309 \u0111\u01b0\u01a1\u0323c du\u0300ng nh\u01b0 m\u00f4\u0323t tham chi\u00ea\u0301u ho\u0103\u0323c m\u00f4\u0323t gia\u0301 tri\u0323.<\/li>\n<\/ul>\n<h2><strong>3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index trong Excel<\/strong><\/h2>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index trong Excel nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3><strong>V\u00ed d\u1ee5 tr\u1ef1c quan<\/strong><\/h3>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"521\" height=\"231\" class=\"aligncenter wp-image-17136 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12-300x133.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12.png 521w\" alt=\"1 12 - H\u00e0m Index trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m Index Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"230\" class=\"aligncenter wp-image-17137 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-11.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-11-300x146.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-11.png 472w\" alt=\"2 11 - H\u00e0m Index trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, h\u00e0m Index ch\u1ec9 c\u00f3 m\u1ed9t d\u1ea3i \u00f4 duy nh\u1ea5t v\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed cho h\u00e0ng 5 trong d\u1ea3i \u00f4 C3 : C7. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 4.<\/p>\n<h3><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Index trong Excel<\/strong><\/h3>\n<p><strong>1.<\/strong> H\u00e0m Index tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! n\u1ebfu m\u1ed9t trong s\u1ed1 c\u00e1c tham s\u1ed1 row_num, col_num ho\u1eb7c area_num \u0111\u00e3 cho n\u00e0o kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1.<\/p>\n<p><strong>2.<\/strong> L\u1ed7i #REF! h\u00e0m Index x\u1ea3y ra c\u00f3 th\u1ec3 l\u00e0 do:<\/p>\n<ul>\n<li>Tham s\u1ed1<strong>\u00a0row_num<\/strong>\u00a0l\u1edbn h\u01a1n s\u1ed1 h\u00e0ng trong ph\u1ea1m vi \u0111\u00e3 cho.<\/li>\n<li>Tham s\u1ed1<strong>\u00a0[col_num]<\/strong>\u00a0\u0111\u00e3 cho l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong ph\u1ea1m vi \u0111\u01b0\u1ee3c cho.<\/li>\n<li>Tham s\u1ed1<strong>\u00a0[area_num]<\/strong>\u00a0\u0111\u00e3 cho l\u1edbn h\u01a1n s\u1ed1 v\u00f9ng trong ph\u1ea1m vi \u0111\u01b0\u1ee3c cung c\u1ea5p.<\/li>\n<\/ul>\n<p>\u0110\u1ebfn \u0111\u00e2y ch\u1eafc b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u0169ng nh\u01b0 <strong>c\u00e1ch s\u1eed d\u1ee5ng<\/strong> <strong>h\u00e0m Index trong Excel<\/strong>. Hy v\u1ecdng b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y c\u1ee7a Ben Computer \u0111\u00e3 mang \u0111\u1ebfn cho b\u1ea1n th\u00eam c\u00e1c th\u00f4ng tin h\u1eefu \u00edch m\u1edbi v\u1ec1 c\u00e1c h\u00e0m Excel v\u00e0 v\u1eadn d\u1ee5ng trong h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y. Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-rank-trong-excel\/\">H\u00e0m Rank trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-hlookup-trong-google-sheets\/\">H\u00e0m Hlookup trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-value-trong-excel\/\">H\u00e0m Value trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-len-trong-excel\/\">H\u00e0m Len trong Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Index trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 giao gi\u1eefa c\u1ed9t v\u00e0 d\u00f2ng. H\u00e0m Index th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Match trong Excel. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p h\u00e0m Index trong [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24051,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24050","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24050"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24050\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24051"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}