{"id":5197,"date":"2024-12-09T17:26:42","date_gmt":"2024-12-09T17:26:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/ham-indirect-trong-excel\/"},"modified":"2024-12-09T17:26:42","modified_gmt":"2024-12-09T17:26:42","slug":"ham-indirect-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/ham-indirect-trong-excel\/","title":{"rendered":"H\u00e0m Indirect trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>H\u00e0m Indirect trong Excel tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu t\u1eeb m\u1ed9t chu\u1ed7i, <strong>h\u00e0m Indir<\/strong><strong>e<\/strong><strong>ct<\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n chuy\u1ec3n t\u1eeb d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i sang tham chi\u1ebfu v\u00f9ng d\u1eef li\u1ec7u trong Excel.<\/em><\/p>\n<p>\u0110\u1ecdc t\u1edbi \u0111\u00e2y, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd ch\u01b0a h\u00ecnh dung ra \u0111\u01b0\u1ee3c c\u1ee5 th\u1ec3 h\u00e0m Indirect c\u00f3 t\u00e1c d\u00f9ng g\u00ec hay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect ra sao v\u00e0 h\u00e0m Indirect c\u00f3 \u1ee9ng d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. Trong b\u00e0i vi\u1ebft n\u00e0y, Thanh xin chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect trong Excel<\/strong><\/a> t\u1eeb ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t, \u0111\u00f3 l\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m Indirect, t\u1edbi nh\u1eefng v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 n\u00e2ng cao h\u01a1n khi s\u1eed d\u1ee5ng h\u00e0m Indirect k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m h\u1eefu \u00edch kh\u00e1c trong Excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 trong c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67572851bdcea\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Ham_Indirect_trong_Excel_%E2%80%93_Cu_phap_va_cach_su_dung_ham_Indirect_co_ban\" title=\"H\u00e0m Indirect trong Excel \u2013 C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n\">H\u00e0m Indirect trong Excel \u2013 C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Ham_Indirect_cu_phap_va_cac_tham_so\" title=\"H\u00e0m Indirect, c\u00fa ph\u00e1p v\u00e0 c\u00e1c tham s\u1ed1\">H\u00e0m Indirect, c\u00fa ph\u00e1p v\u00e0 c\u00e1c tham s\u1ed1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Cach_su_dung_ham_Indirect_co_ban\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Huong_dan_su_dung_ham_Indirect_%E2%80%93_cac_vi_du\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Indirect \u2013 c\u00e1c v\u00ed d\u1ee5\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Indirect \u2013 c\u00e1c v\u00ed d\u1ee5<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Su_dung_ham_Indirect_de_tong_hop_du_lieu_tu_nhieu_bang_tinh\" title=\"S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh\">S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Su_dung_ham_Indirect_de_tinh_tong_n_gia_tri_nho_nhat_trong_cot\" title=\"S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00ednh t\u1ed5ng n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong c\u1ed9t\">S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00ednh t\u1ed5ng n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Cach_su_dung_ham_Indirect_de_chuyen_chi_so_cot_thanh_so_thu_tu_cot\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 chuy\u1ec3n ch\u1ec9 s\u1ed1 c\u1ed9t th\u00e0nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 chuy\u1ec3n ch\u1ec9 s\u1ed1 c\u1ed9t th\u00e0nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-indirect-trong-excel.html#Su_dung_ham_Indirect_de_tach_so_ra_khoi_chu\" title=\"S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00e1ch s\u1ed1 ra kh\u1ecfi ch\u1eef\">S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00e1ch s\u1ed1 ra kh\u1ecfi ch\u1eef<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Indirect_trong_Excel_%E2%80%93_Cu_phap_va_cach_su_dung_ham_Indirect_co_ban\"><\/span>H\u00e0m Indirect trong Excel \u2013 C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 t\u00ean h\u00e0m \u0111\u00e3 g\u1ee3i \u00fd, h\u00e0m Indirect \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tham chi\u1ebfu t\u1edbi v\u00f9ng d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch gi\u00e1n ti\u1ebfp. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0, trong tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 1 chu\u1ed7i \u201cA1\u201d ch\u1eb3ng h\u1ea1n, th\u00ec h\u00e0m Indirect c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng chu\u1ed7i n\u00e0y l\u00e0m tham s\u1ed1, v\u00e0 tr\u1ea3 v\u1ec1 tham chi\u1ebfu t\u1edbi \u00f4 A1. \u0110\u00e2y l\u00e0 c\u00e1ch h\u00ecnh dung \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect. V\u00e0 sau \u0111\u00e2y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m Indirect.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_Indirect_cu_phap_va_cac_tham_so\"><\/span>H\u00e0m Indirect, c\u00fa ph\u00e1p v\u00e0 c\u00e1c tham s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m Indirect ch\u1ec9 c\u00f3 hai tham s\u1ed1, tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, tham s\u1ed1 th\u1ee9 hai kh\u00f4ng b\u1eaft bu\u1ed9c:<\/p>\n<p><code>INDIRECT(ref_text, [a1])<\/code><\/p>\n<p><strong><code>ref_text<\/code><\/strong>\u2013 l\u00e0 m\u1ed9t tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh Excel, ho\u1eb7c m\u1ed9t named range \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i.<\/p>\n<p><code><strong>[a1]<\/strong><\/code> \u2013 nh\u1eadn gi\u00e1 tr\u1ecb <code>TRUE<\/code> (m\u1eb7c \u0111\u1ecbnh) ho\u1eb7c <code>FALSE<\/code> \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1ch tham chi\u1ebfu, tham chi\u1ebfu theo ki\u1ec3u A1 (ki\u1ec3u ch\u00fang ta v\u1eabn th\u01b0\u1eddng d\u00f9ng) khi b\u1ecf qua ho\u1eb7c \u0111\u1ec3 gi\u00e1 tr\u1ecb l\u00e0 <code>TRUE<\/code>, ho\u1eb7c tham chi\u1ebfu ki\u1ec3u R1C1 khi ch\u00fang ta cho gi\u00e1 tr\u1ecb <code>FALSE<\/code><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-442.gif\" title=\"ex101_92019-nho-442\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>M\u1eb7c d\u00f9 tham chi\u1ebfu ki\u1ec3u R1C1 s\u1ebd c\u00f3 \u00edch trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, nh\u01b0ng trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng tham chi\u1ebfu ki\u1ec3u A1, trong b\u00e0i n\u00e0y, c\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m Indirect s\u1ebd s\u1eed d\u1ee5ng tham chi\u1ebfu ki\u1ec3u A1, v\u1eady n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 b\u1ecf qua tham s\u1ed1 th\u1ee9 hai c\u1ee7a h\u00e0m Indirect.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Indirect_co_ban\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect c\u01a1 b\u1ea3n, ch\u00fang ta h\u00e3y \u0111\u1ebfn v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n trong Excel minh ho\u1ea1 c\u00e1ch h\u00e0m Indirect ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32908\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-indirect-function.png\" alt=\"V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m indirect trong Excel\" width=\"355\" height=\"107\" title=\"excel-indirect-function\"><\/p>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 s\u1ed1 3 trong \u00f4 A1, v\u00e0 chu\u1ed7i \u201cA1\u201d trong \u00f4 C1. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0<strong><code>=INDIRECT(C1)<\/code>\u00a0<\/strong>trong \u00f4 D1 \u0111\u1ec3 xem \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra:<\/p>\n<ul>\n<li>\u0110\u1ea7u ti\u00ean, h\u00e0m Indirect s\u1ebd chuy\u1ec3n tham chi\u1ebfu C1 th\u00e0nh gi\u00e1 tr\u1ecb \u201cA1\u201d, do v\u1eady ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c trong \u00f4 D1 l\u00e0 <code><strong>=INDIRECT(\"A1\")<\/strong><\/code><\/li>\n<li>A1 l\u00e0 m\u1ed9t tham chi\u1ebfu h\u1ee3p l\u1ec7 trong Excel, v\u1eady n\u00ean \u00f4 D1 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 <strong><code>=A1<\/code>\u00a0<\/strong>do h\u00e0m Indirect \u0111\u00e3 bi\u1ebfn t\u1eeb chu\u1ed7i \u201cA1\u201d th\u00e0nh tham chi\u1ebfu A1.<\/li>\n<li>Do tham chi\u1ebfu A1 n\u00e0y, n\u00ean khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c Excel t\u00ednh to\u00e1n, s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, qua v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng h\u00e0m Indirect chuy\u1ec3n t\u1eeb tham chi\u1ebfu h\u1ee3p l\u1ec7 \u1edf d\u1ea1ng chu\u1ed7i sang tham chi\u1ebfu b\u00ecnh th\u01b0\u1eddng c\u1ee7a Excel.<\/p>\n<p>T\u1edbi \u0111\u00e2y, n\u1ebfu b\u1ea1n ngh\u0129 r\u1eb1ng, \u0111i\u1ec1u n\u00e0y ch\u1eafc kh\u00f4ng c\u00f3 nhi\u1ec1u \u00fd ngh\u0129a v\u1edbi c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n, th\u00ec xin h\u00e3y n\u00e1n l\u1ea1i th\u00eam m\u1ed9t ch\u00fat n\u1eefa. Ch\u00fang ta s\u1ebd c\u00f9ng nhau \u0111i t\u00ecm hi\u1ec3u m\u1ed9t v\u00e0i v\u00ed d\u1ee5 r\u1ea5t h\u1eefu \u00edch v\u00e0 c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c s\u1ee9c m\u1ea1nh c\u1ee7a h\u00e0m Indirect trong Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_Indirect_%E2%80%93_cac_vi_du\"><\/span>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Indirect \u2013 c\u00e1c v\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede ph\u1ea7n tr\u01b0\u1edbc, ch\u00fang ta v\u1eeba xem m\u1ed9t v\u00ed d\u1ee5 c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n minh ho\u1ea1 cho c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect. \u1ede ph\u1ea7n n\u00e0y, ch\u00fang ta h\u00e3y c\u00f9ng nhau \u0111i t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m Indirect trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a ch\u00fang ta.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Indirect_de_tong_hop_du_lieu_tu_nhieu_bang_tinh\"><\/span>S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c, b\u1ea1n c\u00f3 th\u1ec3 l\u01b0u d\u1eef li\u1ec7u c\u1ee7a nhi\u1ec1u s\u1ea3n ph\u1ea9m v\u00e0o nhi\u1ec1u sheets kh\u00e1c nhau tr\u00ean Excel, m\u1ed7i sheet t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed9t s\u1ea3n ph\u1ea9m. M\u1ed7i s\u1ea3n ph\u1ea9m l\u1ea1i c\u00f3 m\u1ed9t b\u1ea3ng thu\u1ed9c t\u00ednh ri\u00eang c\u1ee7a t\u1eebng s\u1ea3n ph\u1ea9m. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch l\u01b0u tr\u1eef r\u1ea5t t\u1ed1t, v\u00e0 khoa h\u1ecdc. Nhu c\u1ea7u b\u00e2y gi\u1edd c\u1ee7a b\u1ea1n c\u1ea7n t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb c\u00e1c sheet s\u1ea3n ph\u1ea9m \u0111\u00f3 v\u00e0o m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p, l\u00e0m sao \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y khi ch\u00fang ta c\u00f3 t\u1edbi c\u1ea3 tr\u0103m sheets? Trong v\u00ed d\u1ee5 sau \u0111\u00e2y, m\u00ecnh s\u1ebd minh ho\u1ea1 v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00f3 3 sheets<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32911\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-indirect-trong-excel.png\" alt=\"v\u00ed d\u1ee5 h\u00e0m indirect trong excel\" width=\"900\" height=\"843\" title=\"ham-indirect-trong-excel\"><\/p>\n<p>Gi\u1ea3 s\u1eed c\u00e1c sheets \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean m\u1ed9t c\u00e1ch c\u00f3 quy lu\u1eadt l\u00e0 \u201cItem\u201d + s\u1ed1 th\u1ee9 t\u1ef1: \u201cItem 01\u201d, \u201cItem 02\u201d, \u2026, \u201cItem 10\u201d. V\u1eady ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Indirect nh\u01b0 sau \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-32912\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-indirect-1024x480-1.png\" alt=\"v\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m indirect trong Excel\" width=\"1024\" height=\"480\" title=\"vi-du-ham-indirect-1024x480-1\"><\/p>\n<p>Trong \u00f4 C48, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Text v\u00e0 k\u1ef9 thu\u1eadt n\u1ed1i chu\u1ed7i trong Excel \u0111\u1ec3 t\u1ea1o ra t\u00ean sheet. T\u00ean sheet n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c Indirect \u1edf \u00f4 D48 \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb \u00f4 F23 c\u1ee7a c\u00e1c Sheet nh\u01b0 tr\u00ean.<\/p>\n<p>M\u1ed9t l\u01b0u \u00fd \u1edf \u0111\u00e2y \u0111\u1ed1i v\u1edbi t\u00ean Sheet c\u00f3 d\u1ea5u c\u00e1ch l\u00e0 ch\u00fang ta c\u1ea7n vi\u1ebft t\u00ean sheet n\u00e0y trong d\u1ea5u nh\u00e1y \u0111\u01a1n \u2018. Khi n\u1ed1i chu\u1ed7i \u0111\u1ec3 t\u1ea1o ra tham chi\u1ebfu s\u1eed d\u1ee5ng cho h\u00e0m Indirect th\u00ec ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/701755985dbef9d87226de91a2dbeef0\">Gist<\/a>.<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Indirect_de_tinh_tong_n_gia_tri_nho_nhat_trong_cot\"><\/span>S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00ednh t\u1ed5ng n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00ednh t\u1ed5ng 5 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t c\u1ed9t:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-32914\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-indirect-trong-excel-1024x663-1.png\" alt=\"S\u1eed d\u1ee5ng h\u00e0m indirect \u0111\u1ec3 t\u00ednh t\u1ed5ng\" width=\"1024\" height=\"663\" title=\"su-dung-ham-indirect-trong-excel-1024x663-1\"><\/p>\n<p>H\u00e0m Indirect \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u00e0 s\u1eed d\u1ee5ng trong v\u00ed d\u1ee5 tr\u00ean l\u00e0:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/93c5eadaed7993e1d02a5725802ca86c\">Gist<\/a>.<\/div>\n<p>Trong h\u00e0m tr\u00ean:<\/p>\n<ul>\n<li>Ph\u1ea7n <code>ROW(INDIRECT(\"1:5\"))<\/code> s\u1ebd t\u1ea1o ra m\u1ea3ng <code>{1,2,3,4,5}<\/code> \u2013 v\u00ec ch\u00fang ta \u0111ang mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a 5 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, n\u00ean ch\u00fang ta t\u1ea1o ra m\u1ea3ng t\u1eeb 1 t\u1edbi 5. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a 3 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t th\u00f4i, th\u00ec b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t m\u1ea3ng s\u1ed1 t\u1eeb 1 t\u1edbi 3.<\/li>\n<li>H\u00e0m <code>SMALL<\/code> s\u1ebd l\u1ea5y ra 5 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/li>\n<li>H\u00e0m <code>SUMPRODUCT<\/code> cu\u1ed1i c\u00f9ng s\u1ebd \u0111i t\u00ednh t\u1ed5ng c\u1ee7a 5 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t n\u00e0y.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Indirect_de_chuyen_chi_so_cot_thanh_so_thu_tu_cot\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 chuy\u1ec3n ch\u1ec9 s\u1ed1 c\u1ed9t th\u00e0nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 bao gi\u1edd b\u1ea1n mu\u1ed1n bi\u1ebft m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3 \u1edf trong Excel l\u00e0 c\u1ed9t th\u1ee9 m\u1ea5y? \u0110\u1ed1i v\u1edbi c\u00e1c c\u1ed9t ch\u00fang ta th\u01b0\u1eddng d\u00f9ng ho\u1eb7c trong b\u1ea3ng ch\u1eef c\u00e1i th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng bi\u1ebft \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, v\u00ed d\u1ee5 c\u1ed9t A s\u1ebd \u1edf v\u1ecb tr\u00ed th\u1ee9 nh\u1ea5t, c\u1ed9t H \u1edf v\u1ecb tr\u00ed th\u1ee9 8, tuy nhi\u00ean, m\u1ed9t v\u00ed d\u1ee5 vui trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y: m\u00ecnh t\u00ean l\u00e0 Nguy\u1ec5n \u0110\u1ee9c Thanh, vi\u1ebft t\u1eaft l\u00e0 NDT, m\u00ecnh mu\u1ed1n bi\u1ebft c\u1ed9t NDT l\u00e0 c\u1ed9t c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 bao nhi\u00eau tr\u00ean b\u1ea3ng t\u00ednh, th\u00ec m\u00ecnh c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ra \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb \u0111\u00f3:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/8af5ebf31421db1fb0081495db1063af\">Gist<\/a>.<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32917\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/huong-dan-su-dung-ham-indirect.png\" alt=\"h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Indirect\" width=\"832\" height=\"554\" title=\"huong-dan-su-dung-ham-indirect\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Indirect_de_tach_so_ra_khoi_chu\"><\/span>S\u1eed d\u1ee5ng h\u00e0m Indirect \u0111\u1ec3 t\u00e1ch s\u1ed1 ra kh\u1ecfi ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, ch\u1eafc h\u1eb3n b\u1ea1n c\u0169ng g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n t\u00e1ch ri\u00eang s\u1ed1 ra kh\u1ecfi m\u1ed9t \u0111o\u1ea1n text. Th\u1eadt may m\u1eafn, h\u00e0m Indirect c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y v\u1edbi c\u00f4ng th\u1ee9c sau \u0111\u00e2y<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/adad50f11ccd340fb79886a2621be5f7\">Gist<\/a>.<\/div>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, v\u1eady n\u00ean c\u00e1c b\u1ea1n l\u01b0u \u00fd khi nh\u1eadp c\u00f4ng th\u1ee9c xong, ch\u00fang ta c\u1ea7n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <code>Ctrl + Shift + Enter<\/code> \u0111\u1ec3 c\u00f3 th\u1ec3 nh\u1eadp \u0111\u00fang c\u00f4ng th\u1ee9c (D\u1ea5u ngo\u1eb7c nh\u1ecdn <code>{}<\/code> trong c\u00f4ng th\u1ee9c tr\u00ean th\u1ec3 hi\u1ec7n \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o Excel b\u1ea1n kh\u00f4ng c\u1ea7n nh\u1eadp ph\u1ea7n ngo\u1eb7c nh\u1ecdn n\u00e0y)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-32919\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-indirect-tach-so-khoi-chu-1024x277-1.png\" alt=\"h\u00e0m indirect t\u00e1ch s\u1ed1 kh\u1ecfi ch\u1eef\" width=\"1024\" height=\"277\" title=\"ham-indirect-tach-so-khoi-chu-1024x277-1\"><\/p>\n<p>Sau \u0111\u00e2y l\u00e0 video h\u01b0\u1edbng d\u1eabn cho c\u00e1c ki\u1ebfn th\u1ee9c c\u1ee7a b\u00e0i n\u00e0y:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/PMK2h1Z9fek\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>File k\u00e8m theo video c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c download t\u1ea1i \u0111\u01b0\u1eddng link: <strong><a href=\"http:\/\/gofile.me\/5yKFU\/AZZ98WJtp\" target=\"_blank\" rel=\"noopener noreferrer\">Download<\/a><\/strong><\/p>\n<p>Nh\u01b0 v\u1eady, qua b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> v\u00e0 b\u1ea1n \u0111\u00e3 t\u00ecm hi\u1ec3u th\u00eam \u0111\u01b0\u1ee3c m\u1ed9t h\u00e0m r\u1ea5t th\u00fa v\u1ecb trong Excel, \u0111\u00f3 l\u00e0 h\u00e0m Indirect v\u00e0 nh\u1eefng v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf h\u1ebft s\u1ee9c h\u1eefu d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y m\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ngay trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-442.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5198,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5197"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5197\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5198"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}