{"id":7464,"date":"2024-12-21T17:39:34","date_gmt":"2024-12-21T17:39:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa\/"},"modified":"2024-12-21T17:39:34","modified_gmt":"2024-12-21T17:39:34","slug":"cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT trong Excel, c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh ho\u1ea1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, blog.hocexcel.online\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn v\u1ec1 ca\u0301c ba\u0323n ca\u0301ch s\u01b0\u0309 du\u0323ng\u00a0h\u00e0m <strong>INDIRECT<\/strong>, cu\u0303ng nh\u01b0 c\u00e1c ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n v\u00e0 cung c\u1ea5p m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 nh\u1eb1m minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <strong>INDIRECT <\/strong>trong Excel.<\/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-6766fd55bbaff\" 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\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Ham_INDIRECT_trong_Excel_%E2%80%93_cu_phap_va_cac_ung_dung_co_ban\" title=\"H\u00e0m INDIRECT trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u01a1 b\u1ea3n:\">H\u00e0m INDIRECT trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng 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\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Doi_so_ham_INDIRECT\" title=\"\u0110\u1ed1i s\u1ed1 h\u00e0m INDIRECT:\">\u0110\u1ed1i s\u1ed1 h\u00e0m INDIRECT:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Chuc_nang_co_ban_cua_ham_INDIRECT\" title=\"Ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m INDIRECT:\">Ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m INDIRECT:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Lam_the_nao_de_su_dung_INDIRECT_trong_Excel_cac_cong_thuc_vi_du\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng INDIRECT trong Excel, c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng INDIRECT trong Excel, c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Tao_cac_tham_chieu_INDIRECT_tu_cac_o_chua_gia_tri\" title=\"T\u1ea1o c\u00e1c tham chi\u1ebfu INDIRECT t\u1eeb c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb:\">T\u1ea1o c\u00e1c tham chi\u1ebfu INDIRECT t\u1eeb c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb:<\/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\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Tao_cac_tham_chieu_gian_tiep_tu_cac_gia_tri_o_va_van_ban\" title=\"T\u1ea1o c\u00e1c tham chi\u1ebfu gi\u00e1n ti\u1ebfp t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb \u00a0\u00f4 v\u00e0 v\u0103n b\u1ea3n\">T\u1ea1o c\u00e1c tham chi\u1ebfu gi\u00e1n ti\u1ebfp t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb \u00a0\u00f4 v\u00e0 v\u0103n b\u1ea3n<\/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\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Su_dung_ham_INDIRECT_voi_cac_vung_da_dat_ten\" title=\"S\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi c\u00e1c v\u00f9ng \u0111\u00e3 \u0111\u1eb7t t\u00ean\">S\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi c\u00e1c v\u00f9ng \u0111\u00e3 \u0111\u1eb7t t\u00ean<\/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\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Cong_thuc_INDIRECT_%E2%80%93_tu_dong_tham_chieu_den_mot_trang_tinh_khac\" title=\"C\u00f4ng th\u1ee9c INDIRECT \u2013 t\u1ef1 \u0111\u1ed9ng tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c:\">C\u00f4ng th\u1ee9c INDIRECT \u2013 t\u1ef1 \u0111\u1ed9ng tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Tao_mot_tham_chieu_dong_den_mot_bang_tinh_khac\" title=\"T\u1ea1o m\u1ed9t tham chi\u1ebfu \u0111\u1ed9ng \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c\">T\u1ea1o m\u1ed9t tham chi\u1ebfu \u0111\u1ed9ng \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Su_dung_ham_INDIRECT_de_co_dinh_mot_tham_chieu_o\" title=\"S\u1eed d\u1ee5ng h\u00e0m INDIRECT \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t tham chi\u1ebfu \u00f4:\">S\u1eed d\u1ee5ng h\u00e0m INDIRECT \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t tham chi\u1ebfu \u00f4:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Su_dung_ham_INDIRECT_voi_cac_ham_Excel_khac\" title=\"S\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c\">S\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html#Ham_INDIRECT_cac_loi_va_su_co_co_the_xay_ra\" title=\"H\u00e0m INDIRECT,\u00a0c\u00e1c l\u1ed7i v\u00e0 s\u1ef1 c\u1ed1 c\u00f3 th\u1ec3 x\u1ea3y ra:\">H\u00e0m INDIRECT,\u00a0c\u00e1c l\u1ed7i v\u00e0 s\u1ef1 c\u1ed1 c\u00f3 th\u1ec3 x\u1ea3y ra:<\/a><\/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_cac_ung_dung_co_ban\"><\/span><strong>H\u00e0m INDIRECT trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u01a1 b\u1ea3n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m <strong><em>INDIRECT<\/em><\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tham chi\u1ebfu gi\u00e1n ti\u1ebfp c\u00e1c \u00f4, d\u00e3y, c\u00e1c trang t\u00ednh ho\u1eb7c c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c. N\u00f3i c\u00e1ch kh\u00e1c, h\u00e0m <strong><em>INDIRECT<\/em><\/strong> cho ph\u00e9p b\u1ea1n t\u1ea1o m\u1ed9t \u00f4 ch\u1ee9a tham chi\u1ebfu \u0111\u1ed9ng ho\u1eb7c 1 m\u1ea3ng ch\u1ee9a tham chi\u1ebfu trong Excel, thay v\u00ec \u201cm\u00e3 h\u00f3a c\u1ed1 \u0111\u1ecbnh\u201d lu\u00f4n nh\u1eefng tham chi\u1ebfu \u0111\u00f3 v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n. K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u1ed9t tham chi\u1ebfu \u00f4 trong m\u1ed9t c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i c\u00f4ng th\u1ee9c \u0111\u00f3. H\u01a1n n\u1eefa, c\u00e1c tham chi\u1ebfu INDIRECT s\u1ebd kh\u00f4ng thay \u0111\u1ed5i khi m\u1ed9t s\u1ed1 h\u00e0ng ho\u1eb7c c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o b\u1ea3ng t\u00ednh ho\u1eb7c khi b\u1ea1n x\u00f3a b\u1ea5t k\u1ef3 nh\u1eefng g\u00ec hi\u1ec7n c\u00f3.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 nh\u1eefng \u0111i\u1ec1u n\u00e0y c\u00f3 l\u1ebd s\u1ebd d\u1ec5 hi\u1ec3u qua m\u1ed9t v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi \u0111\u00e2y. Tuy nhi\u00ean, \u0111\u1ec3 c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c, th\u1eadm ch\u00ed l\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t, b\u1ea1n c\u1ea7n bi\u1ebft c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m. V\u00ec v\u1eady, ch\u00fang ta h\u00e3y xem x\u00e9t c\u00fa ph\u00e1p c\u1ee7a h\u00e0m INDIRECT:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Doi_so_ham_INDIRECT\"><\/span><strong>\u0110\u1ed1i s\u1ed1 h\u00e0m INDIRECT:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m <strong><em>INDIRECT<\/em><\/strong> ch\u1ec9 c\u00f3 hai \u0111\u1ed1i s\u1ed1, \u0111\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t l\u00e0 b\u1eaft bu\u1ed9c trong khi \u0111\u1ed1i s\u1ed1 th\u1ee9 hai th\u00ec kh\u00f4ng:<\/p>\n<p style=\"text-align: justify\"><strong><em>INDIRECT (ref_text, [a1])<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ref_text \u2013 l\u00e0 m\u1ed9t \u00f4 tham chi\u1ebfu, ho\u1eb7c m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 \u1edf d\u1ea1ng m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, ho\u1eb7c m\u1ed9t m\u1ea3ng m\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/p>\n<p style=\"text-align: justify\">a1 \u2013 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb logic x\u00e1c \u0111\u1ecbnh lo\u1ea1i tham chi\u1ebfu c\u1ee7a \u0111\u1ed1i s\u1ed1 <strong><em>ref_text<\/em><\/strong>:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-299.gif\" title=\"vba101_92019-nho-299\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-669.gif\" title=\"ex101_92019-nho-669\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu <strong><em>TRUE<\/em><\/strong> ho\u1eb7c b\u1ecf qua, th\u00ec <strong><em>ref_text <\/em><\/strong>\u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 m\u1ed9t tham chi\u1ebfu \u00f4 VD: A1 \u2013 tham chi\u1ebfu \u00f4.<\/li>\n<li>N\u1ebfu <strong><em>FALSE<\/em><\/strong>, <strong><em>ref_text <\/em><\/strong>\u0111\u01b0\u1ee3c coi nh\u01b0 tham chi\u1ebfu R1C1.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 ki\u1ec3u tham chi\u1ebfu R1C1 c\u00f3 th\u1ec3 h\u1eefu \u00edch trong nh\u1eefng t\u00ecnh hu\u1ed1ng nh\u1ea5t \u0111\u1ecbnh, c\u00f3 th\u1ec3 b\u1ea1n, th\u01b0\u1eddng s\u1ebd mu\u1ed1n s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu A1 quen thu\u1ed9c h\u01a1n. D\u00f9 sao, g\u1ea7n nh\u01b0 t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>INDIRECT<\/em><\/strong><\/a> trong h\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu A1, do \u0111\u00f3 ch\u00fang ta s\u1ebd b\u1ecf qua \u0111\u1ed1i s\u1ed1 th\u1ee9 hai.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuc_nang_co_ban_cua_ham_INDIRECT\"><\/span><strong>Ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m INDIRECT:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 h\u00e0m, h\u00e3y vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n th\u1ec3 hi\u1ec7n c\u00e1ch b\u1ea1n s\u1eed d\u1ee5ng INDIRECT trong Excel.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 s\u1ed1 3 trong \u00f4 A1 v\u00e0 v\u0103n b\u1ea3n \u201cA1\u201d trong \u00f4 C1. B\u00e2y gi\u1edd, \u0111\u1eb7t c\u00f4ng th\u1ee9c = INDIRECT (C1) trong b\u1ea5t k\u1ef3 \u00f4 n\u00e0o v\u00e0 h\u00e3y xem nh\u1eefng g\u00ec x\u1ea3y ra nh\u00e9:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>H\u00e0m INDIRECT <\/em><\/strong>tham chi\u1ebfu \u0111\u1ebfn gi\u00e1 tr\u1ecb trong \u00f4 C1, l\u00e0 A1.<\/li>\n<li>C\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ebfn \u00f4 A1, n\u01a1i n\u00f3 l\u1ea5y gi\u00e1 tr\u1ecb \u0111\u1ec3 tr\u1ea3 v\u1ec1, l\u00e0 \u201c3\u201d.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-indirect-function-1.png\" alt=\"Using the INDIRECT function in Excel\" width=\"355\" height=\"107\" title=\"excel-indirect-function-1\"><\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, \u0111i\u1ec1u m\u00e0 h\u00e0m <strong><em>INDIRECT <\/em><\/strong>th\u1ef1c s\u1ef1 l\u00e0m trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t \u00f4 tham chi\u1ebfu.<\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">Kho\u0301a ho\u0323c Excel online<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_INDIRECT_trong_Excel_cac_cong_thuc_vi_du\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng <em>INDIRECT<\/em> trong Excel, c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y trong v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INDIRECT \u0111\u1ec3 \u0111\u1eb7t \u0111\u1ecba ch\u1ec9 c\u1ee7a m\u1ed9t \u00f4 v\u00e0o m\u1ed9t \u00f4 kh\u00e1c nh\u01b0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00f4ng th\u01b0\u1eddng, v\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 th\u1ee9 nh\u1ea5t b\u1eb1ng c\u00e1ch tham chi\u1ebfu \u0111\u1ebfn \u00f4 th\u1ee9 hai. Tuy nhi\u00ean, v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh \u0111\u00f3 c\u0169ng ch\u1ec9 l\u00e0 m\u1ed9t g\u1ee3i \u00fd nh\u1ecf v\u1ec1 c\u00e1c kh\u1ea3 n\u0103ng <strong><em>INDIRECT.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u th\u1ef1c, h\u00e0m <strong><em>INDIRECT<\/em><\/strong> c\u00f3 th\u1ec3 bi\u1ebfn b\u1ea5t k\u1ef3 chu\u1ed7i v\u0103n b\u1ea3n n\u00e0o th\u00e0nh tham chi\u1ebfu, bao g\u1ed3m c\u00e1c chu\u1ed7i r\u1ea5t ph\u1ee9c t\u1ea1p m\u00e0 b\u1ea1n x\u00e2y d\u1ef1ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 kh\u00e1c v\u00e0 c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c c\u00f4ng th\u1ee9c Excel kh\u00e1c. Nh\u01b0ng \u0111\u1eebng \u00e1p \u0111\u1eb7t cho n\u00f3 m\u1ed9t gi\u1edbi h\u1ea1n, h\u00e3y l\u01b0\u1edbt qua m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c kh\u00e1c li\u00ean quan \u0111\u1ebfn INDIRECT trong Excel, xem k\u0129 t\u1eebng c\u00e1i m\u1ed9t.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_cac_tham_chieu_INDIRECT_tu_cac_o_chua_gia_tri\"><\/span><strong>T\u1ea1o c\u00e1c tham chi\u1ebfu <em>INDIRECT<\/em> t\u1eeb c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n nh\u1edb, h\u00e0m INDIRECT cho ph\u00e9p c\u00e1c ki\u1ec3u tham chi\u1ebfu A1 v\u00e0 R1C1. Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u1ea3 hai ki\u1ec3u trong c\u00f9ng 1 trang c\u00f9ng l\u00fac \u0111\u01b0\u1ee3c, m\u00e0 b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa hai ki\u1ec3u tham chi\u1ebfu, th\u00f4ng <strong>qua File&gt; Options&gt; Formula&gt; ch\u1ecdn R1C1<\/strong>. \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao ng\u01b0\u1eddi d\u00f9ng Excel l\u1ea1i hi\u1ebfm khi ngh\u0129 \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng R1C1 l\u00e0m ph\u01b0\u01a1ng ph\u00e1p tham chi\u1ebfu thay th\u1ebf.<\/p>\n<p style=\"text-align: justify\">Trong m\u1ed9t c\u00f4ng th\u1ee9c INDIRECT kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong hai ki\u1ec3u tham chi\u1ebfu tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh, n\u1ebfu b\u1ea1n mu\u1ed1n. Tr\u01b0\u1edbc khi ch\u00fang t\u00f4i chuy\u1ec3n t\u1edbi m\u1ee5c kh\u00e1c, th\u00ec c\u00f3 th\u1ec3 b\u1ea1n r\u1ea5t mu\u1ed1n bi\u1ebft s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c ki\u1ec3u tham chi\u1ebfu A1 v\u00e0 R1C1:<\/p>\n<p style=\"text-align: justify\">Ki\u1ec3u A1 l\u00e0 ki\u1ec3u tham chi\u1ebfu th\u00f4ng th\u01b0\u1eddng trong Excel, li\u00ean quan \u0111\u1ebfn m\u1ed9t c\u1ed9t theo sau b\u1edfi m\u1ed9t s\u1ed1 h\u00e0ng. V\u00ed d\u1ee5, B2 tham chi\u1ebfu \u0111\u1ebfn \u00f4 t\u1ea1i giao \u0111i\u1ec3m Tr\u00ean c\u1ed9t B v\u00e0 d\u00f2ng 2.<\/p>\n<p style=\"text-align: justify\">R1C1 l\u00e0 lo\u1ea1i tham chi\u1ebfu ng\u01b0\u1ee3c l\u1ea1i v\u1edbi A1 \u2013 c\u00e1c h\u00e0ng m\u00e0 ti\u1ebfp theo l\u00e0 c\u00e1c c\u1ed9t, \u0111i\u1ec1u n\u00e0y s\u1ebd khi\u1ebfn b\u1ea1n ph\u1ea3i m\u1ea5t m\u1ed9t th\u1eddi gian \u0111\u1ec3 l\u00e0m quen \ud83d\ude42 V\u00ed d\u1ee5, R4C1 d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u00f4 A4 trong h\u00e0ng 4, c\u1ed9t 1 trong m\u1ed9t trang t\u00ednh. N\u1ebfu kh\u00f4ng c\u00f3 s\u1ed1 n\u00e0o xu\u1ea5t hi\u1ec7n sau ch\u1eef c\u00e1i, th\u00ec b\u1ea1n \u0111ang tham chi\u1ebfu \u0111\u1ebfn c\u00f9ng h\u00e0ng ho\u1eb7c c\u1ed9t.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y xem c\u00e1ch m\u00e0 <strong><em>h\u00e0m INDIRECT<\/em><\/strong> x\u1eed l\u00fd c\u00e1c tham chi\u1ebfu A1 v\u00e0 R1C1:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-indirect-cell-references.png\" alt=\"INDIRECT formulas with A1 and R1C1 references\" title=\"excel-indirect-cell-references\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, ba c\u00f4ng th\u1ee9c INDIRECT \u00a0\u0111\u1ec1u tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1. T\u00f4i c\u01b0\u1ee3c l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft t\u1ea1i sao.<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00f4ng th\u1ee9c trong \u00f4 <strong><em>D1: = INDIRECT (C1)<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t. C\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn \u00f4 C1, l\u1ea5y chu\u1ed7i gi\u00e1 tr\u1ecb-v\u0103n b\u1ea3n A2 c\u1ee7a n\u00f3, chuy\u1ec3n n\u00f3 th\u00e0nh m\u1ed9t tham chi\u1ebfu \u00f4, v\u00e0 khi tham chi\u1ebfu qua \u00f4 A2 th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 222.<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00f4ng th\u1ee9c trong \u00f4 D3: <strong><em>= INDIRECT (C3, FALSE)<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">FALSE trong \u0111\u1ed1i s\u1ed1 th\u1ee9 2 ch\u1ec9 ra r\u1eb1ng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tham chi\u1ebfu (C3) l\u00e0 tham chi\u1ebfu \u00f4 ki\u1ec3u R1C1, t\u1ee9c l\u00e0 m\u1ed9t s\u1ed1 h\u00e0ng, ti\u1ebfp theo l\u00e0 m\u1ed9t s\u1ed1 c\u1ed9t. Do \u0111\u00f3, c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a ch\u00fang t\u00f4i di\u1ec5n gi\u1ea3i gi\u00e1 tr\u1ecb trong \u00f4 C3 (R2C1) nh\u01b0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 t\u1ea1i k\u1ebft h\u1ee3p c\u1ee7a h\u00e0ng 2 v\u00e0 c\u1ed9t 1, \u0111\u00f3 l\u00e0 \u00f4 A2.<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00f4ng th\u1ee9c trong \u00f4 D5: <strong><em>= INDIRECT(C5, FALSE)<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 c\u00f4ng th\u1ee9c tr\u01b0\u1edbc, c\u00f4ng th\u1ee9c INDIRECT n\u00e0y c\u0169ng c\u00f3 FALSE trong \u0111\u1ed1i s\u1ed1 th\u1ee9 hai, c\u00f3 ngh\u0129a l\u00e0 n\u00f3 di\u1ec5n gi\u1ea3i gi\u00e1 tr\u1ecb trong \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean nh\u01b0 m\u1ed9t tham chi\u1ebfu ki\u1ec3u R1C1. V\u00ec v\u1eady, c\u00f4ng th\u1ee9c s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb trong \u00f4 C5 (R3C) v\u00e0 bi\u1ebfn n\u00f3 th\u00e0nh \u0111\u1ecba ch\u1ec9 \u00f4 D3 (h\u00e0ng 3 trong c\u1ed9t \u0111\u00f3) v\u00e0 ti\u1ebfp t\u1ee5c nh\u01b0 tr\u00ean.<\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 C5 l\u00e0 R3C3 ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 R3C, c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb trong \u00f4 C3 (R2C1) m\u00e0 kh\u00f4ng \u0111i th\u00eam n\u1eefa. Th\u00e0nh th\u1ef1c m\u00e0 n\u00f3i, t\u00f4i kh\u00f4ng th\u1ec3 \u0111\u01b0a ra b\u1ea5t k\u1ef3 l\u1eddi gi\u1ea3i th\u00edch h\u1ee3p l\u00fd cho t\u00ecnh hu\u1ed1ng nh\u01b0 v\u1eady, c\u00f3 th\u1ec3 r\u1eb1ng n\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t s\u1ef1 m\u1eadp m\u1edd m\u01a1 h\u1ed3 trong h\u00e0m <strong><em>INDIRECT<\/em><\/strong> c\u1ee7a Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_cac_tham_chieu_gian_tiep_tu_cac_gia_tri_o_va_van_ban\"><\/span><strong>T\u1ea1o c\u00e1c tham chi\u1ebfu gi\u00e1n ti\u1ebfp t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb \u00a0\u00f4 v\u00e0 v\u0103n b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch ch\u00fang ta t\u1ea1o c\u00e1c tham chi\u1ebfu t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a \u00f4, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a b\u1ea1n, g\u1eafn li\u1ec1n d\u1ea5u (&amp;).<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 sau, c\u00f4ng th\u1ee9c: <strong><em>= INDIRECT (\u201cB\u201d &amp; C2)<\/em><\/strong> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb \u00f4 B2 d\u1ef1a tr\u00ean chu\u1ed7i logic sau:<\/p>\n<p style=\"text-align: justify\">H\u00e0m INDIRECT k\u1ebft n\u1ed1i c\u00e1c ph\u1ea7n t\u1eed trong \u0111\u1ed1i s\u1ed1 ref_text \u2013 v\u0103n b\u1ea3n \u201cB\u201d v\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 C2 -&gt; gi\u00e1 tr\u1ecb trong \u00f4 C2 l\u00e0 s\u1ed1 2, t\u1ea1o ra tham chi\u1ebfu \u00f4 l\u00e0 B2 -&gt; c\u00f4ng th\u1ee9c \u0111i \u0111\u1ebfn \u00f4 B2 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3, l\u00e0 \u201c10\u201d.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-reference-cell-text.png\" alt=\"Making indirect references from cell values and text\" title=\"indirect-reference-cell-text\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_INDIRECT_voi_cac_vung_da_dat_ten\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi c\u00e1c v\u00f9ng \u0111\u00e3 \u0111\u1eb7t t\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ngo\u00e0i vi\u1ec7c t\u1ea1o c\u00e1c tham chi\u1ebfu t\u1eeb c\u00e1c \u00f4 v\u00e0 v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m INDIRECT \u0111\u1ec3 tham chi\u1ebfu t\u1edbi c\u00e1c v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u1eb7t t\u00ean.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 c\u00e1c v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean sau trong b\u1ea3ng c\u1ee7a b\u1ea1n:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>Apples \u2013 B2:B6<\/em><\/strong><\/li>\n<li><strong><em>Bananas \u2013 C2:C6<\/em><\/strong><\/li>\n<li><strong><em>Lemons \u2013 D2:D6<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t tham chi\u1ebfu \u0111\u1ed9ng cho b\u1ea5t k\u1ef3 v\u00f9ng d\u1eef li\u1ec7u n\u00e0o \u1edf tr\u00ean, ch\u1ec9 c\u1ea7n nh\u1eadp t\u00ean c\u1ee7a n\u00f3 v\u00e0o m\u1ed9t s\u1ed1 \u00f4, gi\u1ea3 s\u1eed l\u00e0 G1, v\u00e0 tham chi\u1ebfu \u00f4 \u0111\u00f3 t\u1eeb c\u00f4ng th\u1ee9c <strong><em>INDIRECT: \u00a0= INDIRECT (G1).<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c INDIRECT n\u00e0y v\u00e0o c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u00e0 trung b\u00ecnh c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t d\u1ea3i n\u00e0o \u0111\u00f3, ho\u1eb7c t\u00ecm gi\u00e1 tr\u1ecb c\u1ef1c \u0111\u1ea1i \/ t\u1ed1i thi\u1ec3u trong d\u1ea3i:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em> = SUM (INDIRECT (G1))<\/em><\/strong><\/li>\n<li><strong><em> = AVERAGE (INDIRECT (G1))<\/em><\/strong><\/li>\n<li><strong><em> = MAX (INDIRECT (G1))<\/em><\/strong><\/li>\n<li><strong><em> = MIN (INDIRECT (G1))<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5906\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-100.png\" width=\"600\" height=\"170\" title=\"excel-dialog-box-launcher-1-100\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c \u00fd t\u01b0\u1edfng chung v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u00f4ng th\u1ee9c INDIRECT trong Excel, ch\u00fang ta c\u00f3 th\u1ec3 th\u1eed l\u00e0m v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea1nh h\u01a1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_INDIRECT_%E2%80%93_tu_dong_tham_chieu_den_mot_trang_tinh_khac\"><\/span><strong>C\u00f4ng th\u1ee9c <em>INDIRECT<\/em> \u2013 t\u1ef1 \u0111\u1ed9ng tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u00ednh h\u1eefu \u00edch c\u1ee7a h\u00e0m INDIRECT trong Excel kh\u00f4ng gi\u1edbi h\u1ea1n trong vi\u1ec7c x\u00e2y d\u1ef1ng c\u00e1c tham chi\u1ebfu cho nh\u1eefng \u00f4 c\u00f3 th\u1ec3 b\u1ecb thay \u0111\u1ed5i. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 tham chi\u1ebfu c\u00e1c \u00f4 trong c\u00e1c trang t\u00ednh kh\u00e1c, v\u00e0 \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u quan tr\u1ecdng trong B\u1ea3ng 1 v\u00e0 b\u1ea1n mu\u1ed1n k\u00e9o d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0o trong B\u1ea3ng 2. H\u00ecnh sau \u0111\u00e2y cho th\u1ea5y c\u00e1ch m\u1ed9t c\u00f4ng th\u1ee9c <strong><em>INDIRECT<\/em><\/strong> c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-reference-other-sheet.png\" alt=\"INDIRECT formula to dynamically refer to another worksheet\" title=\"indirect-reference-other-sheet\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y chia nh\u1ecf c\u00f4ng th\u1ee9c b\u1ea1n nh\u00ecn th\u1ea5y trong h\u00ecnh \u0111\u1ec3 nghi\u00ean c\u1ee9u.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u00e1ch th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 tham chi\u1ebfu m\u1ed9t trang t\u00ednh kh\u00e1c trong Excel l\u00e0 ghi sau t\u00ean c\u1ee7a b\u1ea3ng m\u1ed9t d\u1ea5u ch\u1ea5m than v\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 \/ d\u1ea3i, v\u00ed nh\u01b0 <strong><em>SheetName! Range<\/em><\/strong>. V\u00ec m\u1ed9t t\u00ean trang th\u01b0\u1eddng ch\u1ee9a m\u1ed9t d\u1ea5u c\u00e1ch, n\u00ean b\u1ea1n ph\u1ea3i d\u00e1n n\u00f3 v\u00e0o trong d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1ec3 tr\u00e1nh l\u1ed7i, v\u00ed d\u1ee5 <strong><em>\u2018My Sheet!<\/em><\/strong>\u2018 $A$1.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 nh\u1eadp t\u00ean b\u1ea3ng trong m\u1ed9t \u00f4, \u0111\u1ecba ch\u1ec9 \u00f4 trong m\u1ed9t \u00f4 kh\u00e1c, n\u1ed1i ch\u00fang v\u1edbi nhau trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, v\u00e0 \u0111\u01b0a n\u00f3 v\u00e0o <strong><em>h\u00e0m INDIRECT<\/em><\/strong>. H\u00e3y nh\u1edb r\u1eb1ng trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, b\u1ea1n ph\u1ea3i k\u00e8m theo m\u1ed7i ph\u1ea7n t\u1eed v\u1edbi \u0111\u1ecba ch\u1ec9 ho\u1eb7c s\u1ed1 c\u1ee7a \u00f4 trong ngo\u1eb7c k\u00e9p v\u00e0 li\u00ean k\u1ebft t\u1ea5t c\u1ea3 c\u00e1c y\u1ebfu t\u1ed1 v\u1edbi nhau b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u201c&amp;\u201d<\/p>\n<p style=\"text-align: justify\">V\u1edbi nh\u1eefng \u0111i\u1ec1u tr\u00ean, c\u1ea5u tr\u00fac h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>INDIRECT(\u201c\u2018\u201d &amp;\u00a0<\/em><\/strong><strong><em>Sheet\u2019s name<\/em><\/strong><strong><em>\u00a0&amp; \u201c\u2018!\u201d &amp;\u00a0<\/em><\/strong><strong><em>Cell to pull data from<\/em><\/strong><strong><em>)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Quay l\u1ea1i v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, b\u1ea1n \u0111\u1eb7t t\u00ean c\u1ee7a b\u1ea3ng trong \u00f4 A1, v\u00e0 g\u00f5 c\u00e1c \u0111\u1ecba ch\u1ec9 \u00f4 trong c\u1ed9t B, nh\u01b0 \u00a0\u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong h\u00ecnh \u1edf tr\u00ean. Khi \u0111\u00f3, b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>INDIRECT (\u201c\u2018\u201d &amp; $A$1 &amp; \u201c\u2018!\u201d &amp; B1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, h\u00e3y l\u01b0u \u00fd r\u1eb1ng n\u1ebfu b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4, b\u1ea1n ph\u1ea3i c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u0111\u1ebfn t\u00ean trang t\u00ednh, b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i nh\u01b0 $A$1.<\/p>\n<p style=\"text-align: justify\">Ghi ch\u00fa:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu m\u1ed9t trong hai \u00f4 ch\u1ee9a t\u00ean v\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a trang th\u1ee9 2 (A1 v\u00e0 B1 trong c\u00f4ng th\u1ee9c tr\u00ean) l\u00e0 r\u1ed7ng, th\u00ec c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i. \u0110\u1ec3 ng\u0103n ch\u1eb7n \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng <strong><em>h\u00e0m INDIRECT<\/em><\/strong> trong h\u00e0m <strong><em>IF<\/em><\/strong>:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>IF (OR ($A$1 = \u201c\u201d, B1 = \u201c\u201d), \u201c\u201d, INDIRECT (\u201c\u2018\u201d &amp; $A$1 &amp; \u201c\u2018!\u201d &amp; B1))<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c INDIRECT c\u00f3 tham chi\u1ebfu \u0111\u1ebfn trang kh\u00e1c, \u0111\u1ec3 n\u00f3 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c th\u00ec trang \u0111\u01b0\u1ee3c tham chi\u00eau n\u00ean \u0111\u01b0\u1ee3c m\u1edf, n\u1ebfu kh\u00f4ng c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #REF. \u0110\u1ec3 tr\u00e1nh l\u1ed7i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng IFERROR, n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t chu\u1ed7i r\u1ed7ng, b\u1ea5t k\u1ec3 l\u1ed7i c\u00f3 x\u1ea3y ra hay kh\u00f4ng:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>IFERROR (INDIRECT (\u201c\u2018\u201d &amp; $A$1 &amp; \u201c\u2018!\u201d &amp; B1), \u201c\u201d)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_mot_tham_chieu_dong_den_mot_bang_tinh_khac\"><\/span><strong>T\u1ea1o m\u1ed9t tham chi\u1ebfu \u0111\u1ed9ng \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c INDIRECT tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00ednh Excel kh\u00e1c d\u1ef1a tr\u00ean c\u00e1ch ti\u1ebfp c\u1eadn t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tham chi\u1ebfu \u0111\u1ebfn trang t\u00ednh kh\u00e1c. B\u1ea1n ch\u1ec9 c\u1ea7n x\u00e1c \u0111\u1ecbnh t\u00ean c\u1ee7a b\u1ea3ng t\u00ednh, ngh\u0129a l\u00e0 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u00ean b\u1ea3ng v\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho m\u1ecdi vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n, h\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch t\u1ea1o m\u1ed9t tham chi\u1ebfu cho m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng (d\u1ea5u nh\u1ea5y \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng t\u00ednh v\u00e0 \/ ho\u1eb7c t\u00ean b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a d\u1ea5u c\u00e1ch):<\/p>\n<p style=\"text-align: justify\"><strong><em>\u2018[Book_name.xlsx] Sheet_name\u2019!Range<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed r\u1eb1ng t\u00ean s\u00e1ch n\u1eb1m trong \u00f4 A2, t\u00ean b\u1ea3ng l\u00e0 B2, v\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4 trong C2, ch\u00fang ta l\u1ea5y c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= INDIRECT (\u201c\u2018[\u201d &amp; $A$2 &amp; \u201c]\u201d &amp; $B$2 &amp; \u201c\u2018!\u201d &amp; C2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00e1c \u00f4 ch\u1ee9a t\u00ean c\u1ee7a b\u1ea3ng t\u00ednh v\u00e0 trang t\u00ednh thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c, b\u1ea1n s\u1ebd ph\u1ea3i c\u1ed1 \u0111\u1ecbnh ch\u00fang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i, t\u01b0\u01a1ng \u1ee9ng l\u00e0 $A$2 v\u00e0 $B$2.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-reference-other-book.png\" alt=\"Excel INDIRECT formula to refer to another workbook\" title=\"indirect-reference-other-book\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng vi\u1ebft tham chi\u1ebfu \u0111\u1ed9ng c\u1ee7a ri\u00eang b\u1ea1n v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh Excel kh\u00e1c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1eabu sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=INDIRECT(\u201c\u2018[\u201d &amp;\u00a0<\/em><\/strong><strong><em>Book name<\/em><\/strong><strong><em>\u00a0&amp; \u201c]\u201d &amp;\u00a0<\/em><\/strong><strong><em>Sheet name<\/em><\/strong><strong><em>\u00a0&amp; \u201c\u2018!\u201d &amp;\u00a0<\/em><\/strong><strong><em>Cell address<\/em><\/strong><strong><em>)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch<\/strong>: B\u1ea3ng t\u00ednh m\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn n\u00ean lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c m\u1edf, n\u1ebfu kh\u00f4ng ch\u1ee9c n\u0103ng INDIRECT s\u1ebd n\u00e9m m\u1ed9t l\u1ed7i #REF. Nh\u01b0 th\u01b0\u1eddng l\u1ec7, ch\u1ee9c n\u0103ng IFERROR c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c n\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong><em>= IFERROR (INDIRECT (\u201c\u201d [\u201c&amp; A2 &amp;\u201d] \u201c&amp; $A$1 &amp;\u201d \u2018! \u201c&amp; B1),\u201d \u201c)<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_INDIRECT_de_co_dinh_mot_tham_chieu_o\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m INDIRECT \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t tham chi\u1ebfu \u00f4:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, Microsoft Excel thay \u0111\u1ed5i c\u00e1c tham chi\u1ebfu \u00f4 khi b\u1ea1n ch\u00e8n m\u1edbi ho\u1eb7c xo\u00e1 c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t hi\u1ec7n c\u00f3 trong m\u1ed9t trang t\u00ednh. \u0110\u1ec3 ng\u0103n ch\u1eb7n \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng H\u00e0m INDIRECT \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c tham chi\u1ebfu \u00f4 c\u1ea7n gi\u1eef nguy\u00ean trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 minh h\u1ecda s\u1ef1 kh\u00e1c bi\u1ec7t, vui l\u00f2ng th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1eadp b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o v\u00e0o \u00f4 b\u1ea5t k\u1ef3, v\u00ed d\u1ee5, s\u1ed1 20 trong \u00f4 A1.<\/li>\n<li>Tham chi\u1ebfu A1 t\u1eeb hai \u00f4 kh\u00e1c b\u1eb1ng nhi\u1ec1u c\u00e1ch kh\u00e1c nhau: = A1 v\u00e0 <strong><em>= INDIRECT (\u201cA1\u201d)<\/em><\/strong><\/li>\n<li>Ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi ph\u00eda tr\u00ean h\u00e0ng 1.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00e0 h\u00e3y xem \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra? Gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c g\u00e1n gi\u00e1 tr\u1ecb \u00f4 kh\u00e1c, v\u1eabn tr\u1ea3 v\u1ec1 20, v\u00ec c\u00f4ng th\u1ee9c c\u1ee7a n\u00f3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i th\u00e0nh = A2. \u00d4 v\u1edbi c\u00f4ng th\u1ee9c INDIRECT s\u1ebd b\u00e2y gi\u1edd tr\u1ea3 v\u1ec1 0, v\u00ec c\u00f4ng th\u1ee9c \u0111\u00e3 kh\u00f4ng thay \u0111\u1ed5i khi c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o v\u00e0 n\u00f3 v\u1eabn c\u00f2n tham chi\u1ebfu \u0111\u1ebfn \u00f4 A1, hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-lock-reference.png\" alt=\"Using Excel INDIRECT function to lock a cell reference\" title=\"indirect-lock-reference\"><\/p>\n<p style=\"text-align: justify\">Sau khi nghe t\u00f4i gi\u1ea3i th\u00edch, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3m th\u1ea5y r\u1eb1ng h\u00e0m c\u00f4ng th\u1ee9c <strong><em>INDIRECT<\/em><\/strong> c\u00f3 v\u1ebb l\u00e0 g\u00e2y phi\u1ec1n to\u00e1i nhi\u1ec1u h\u01a1n l\u00e0 gi\u00fap \u0111\u1ee1. \u0110\u01b0\u1ee3c th\u00f4i, h\u00e3y th\u1eed m\u1ed9t v\u00ed d\u1ee5 kh\u00e1c:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n l\u1ea5y t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong d\u1ea3i A2: A5, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM (A2: A5)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c v\u1eabn gi\u1eef nguy\u00ean, cho d\u00f9 c\u00f3 bao nhi\u00eau h\u00e0ng \u0111\u01b0\u1ee3c x\u00f3a ho\u1eb7c ch\u00e8n v\u00e0o. Gi\u1ea3i ph\u00e1p r\u00f5 r\u00e0ng nh\u1ea5t \u2013 s\u1eed d\u1ee5ng tham chi\u1ebfu c\u1ed1 \u0111\u1ecbnh \u2013 s\u1ebd kh\u00f4ng gi\u00fap \u00edch g\u00ec. \u0110\u1ec3 ch\u1eafc ch\u1eafn, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c = SUM ($A$2:$A$5) v\u00e0o m\u1ed9t s\u1ed1 \u00f4, ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi, gi\u1ea3 s\u1eed \u00a0\u1edf d\u00f2ng 3, v\u00e0 \u2026 ph\u00e1t hi\u1ec7n c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh = SUM ($A$2:$A$6) .<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, nh\u01b0 v\u1eady Microsoft Excel l\u00e0m vi\u1ec7c t\u1ed1t trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p. Tuy nhi\u00ean, c\u00f3 th\u1ec3 \u00a0b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i. Gi\u1ea3i ph\u00e1p l\u00e0 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng INDIRECT, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM (INDIRECT (\u201cA2: A5\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ec Excel nh\u1eadn ra r\u1eb1ng \u201cA1: A5\u201d ch\u1ec9 l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t d\u1ea3i tham chi\u1ebfu, n\u00f3 s\u1ebd kh\u00f4ng th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o khi b\u1ea1n ch\u00e8n ho\u1eb7c x\u00f3a m\u1ed9t h\u00e0ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_INDIRECT_voi_cac_ham_Excel_khac\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m <em>INDIRECT<\/em> v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ngo\u00e0i SUM, INDIRECT th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng Excel kh\u00e1c nh\u01b0 ROW, COLUMN, ADDRESS, <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIF<\/a>, \u0111\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t v\u00e0i \u0111\u1ea1i di\u1ec7n ti\u00eau bi\u1ec3u.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 1. H\u00e0m <strong><em>INDIRECT<\/em><\/strong> v\u00e0 <strong><em>ROW<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Th\u01b0\u1eddng th\u00ec h\u00e0m ROW \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau (nh\u1edb nh\u1ea5n Ctrl + Shift + Enter) \u0111\u1ec3 tr\u1ea3 l\u1ea1i trung b\u00ecnh c\u1ee7a 3 s\u1ed1 nh\u1ecf nh\u1ea5t trong d\u1ea3i A1: A10:<\/p>\n<p style=\"text-align: justify\"><strong><em>= AVERAGE(SMALL (A1: A10, ROW (1: 3))) <\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, n\u1ebfu b\u1ea1n ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o gi\u1eefa c\u00e1c h\u00e0ng 1 v\u00e0 3, d\u1ea3i trong c\u00f4ng th\u1ee9c h\u00e0m ROW s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh ROW (1:4) v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 l\u1ea1i trung b\u00ecnh c\u1ee7a 4 con s\u1ed1 nh\u1ecf nh\u1ea5t, thay v\u00ec 3 .<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, h\u00e3y l\u1ed3ng h\u00e0m INDIRECT trong h\u00e0m ROW v\u00e0 c\u00f4ng th\u1ee9c tr\u00ean c\u1ee7a b\u1ea1n s\u1ebd lu\u00f4n lu\u00f4n ch\u00ednh x\u00e1c, cho d\u00f9 c\u00f3 bao nhi\u00eau d\u00f2ng \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o ho\u1eb7c b\u1ecb x\u00f3a:<\/p>\n<p style=\"text-align: justify\"><strong><em>= AVERAGE(SMALL(A1: A10, ROW (INDIRECT (\u201c1: 3\u201d)))))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indircet-row-functions.png\" alt=\"Using INDIRECT and ROW functions\" title=\"indircet-row-functions\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 2. H\u00e0m <strong><em>INDIRECT<\/em><\/strong> v\u00e0 <strong><em>ADDRESS<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <strong><em>INDIRECT<\/em><\/strong> c\u00f9ng v\u1edbi h\u00e0m <strong><em>ADDRESS<\/em><\/strong> \u0111\u1ec3 nh\u1eadn gi\u00e1 tr\u1ecb trong m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh khi \u0111ang chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m <strong><em>ADDRESS<\/em><\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 l\u1ea5y m\u1ed9t \u0111\u1ecba ch\u1ec9 \u00f4 theo s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c = ADDRESS (1,3) tr\u1ea3 v\u1ec1 chu\u1ed7i $C$1 v\u00ec C1 l\u00e0 \u00f4 \u1edf giao \u0111i\u1ec3m c\u1ee7a h\u00e0ng 1 v\u00e0 c\u1ed9t th\u1ee9 3.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t tham chi\u1ebfu \u00f4 <strong><em>INDIRECT<\/em><\/strong>, b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ed3ng h\u00e0m ADDRESS v\u00e0o c\u00f4ng th\u1ee9c INDIRECT nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= INDIRECT (ADDRESS (1,3))<\/p>\n<p style=\"text-align: justify\"><strong>S\u1eed d\u1ee5ng <em>INDIRECT<\/em> v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INDIRECT v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ec3 t\u1ea1o c\u00e1c danh s\u00e1ch theo m\u1ee5c d\u1ea1ng x\u1ebfp ch\u1ed3ng l\u00ean nhau \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c l\u1ef1a ch\u1ecdn kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 ch\u1ecdn trong danh s\u00e1ch theo m\u1ee5c \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn, th\u1ef1c s\u1ef1 r\u1ea5t d\u1ec5 l\u00e0m. Nh\u1eefng g\u00ec n\u00f3 c\u1ea7n l\u00e0 m\u1ed9t v\u00e0i d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, \u0111\u1ec3 l\u01b0u tr\u1eef th\u00e0nh c\u00e1c m\u1ee5c v\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n <strong><em>= INDIRECT (A2<\/em><\/strong>), trong \u0111\u00f3 A2 l\u00e0 \u00f4 hi\u1ec3n th\u1ecb danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-data-validation.png\" alt=\"Using INDIRECT with Data Validation in Excel\" title=\"indirect-data-validation\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o c\u00e1c danh s\u00e1ch 3 c\u1ea5p ph\u1ee9c t\u1ea1p h\u01a1n ho\u1eb7c th\u1ea3 xu\u1ed1ng v\u1edbi c\u00e1c m\u1ee5c nh\u1eadp nhi\u1ec1u t\u1eeb, th\u00ec b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat v\u1edbi m\u1ed9t h\u00e0m <strong><em>SUBSTITUTE<\/em><\/strong> l\u1ed3ng v\u00e0o nhau.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc chi ti\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <strong><em>INDIRECT<\/em><\/strong> v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel, vui l\u00f2ng xem h\u01b0\u1edbng d\u1eabn n\u00e0y: C\u00e1ch t\u1ea1o danh s\u00e1ch c\u00e1c t\u00f9y ch\u1ecdn trong Excel.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_INDIRECT_cac_loi_va_su_co_co_the_xay_ra\"><\/span><strong>H\u00e0m <em>INDIRECT,<\/em>\u00a0c\u00e1c l\u1ed7i v\u00e0 s\u1ef1 c\u1ed1 c\u00f3 th\u1ec3 x\u1ea3y ra:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y trong c\u00e1c v\u00ed d\u1ee5 tr\u00ean, h\u00e0m <strong><em>INDIRECT<\/em><\/strong> kh\u00e1 h\u1eefu \u00edch khi d\u00f9ng v\u1edbi tham chi\u1ebfu \u00f4 v\u00e0 d\u00e3y. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel n\u00e0o c\u0169ng h\u00e1o h\u1ee9c \u0111\u00f3n nh\u1eadn n\u00f3, ch\u1ee7 y\u1ebfu l\u00e0 v\u00ec vi\u1ec7c s\u1eed d\u1ee5ng INDIRECT r\u1ed9ng r\u00e3i trong c\u00e1c c\u00f4ng th\u1ee9c Excel s\u1ebd d\u1eabn \u0111\u1ebfn thi\u1ebfu minh b\u1ea1ch. H\u00e0m INDIRECT kh\u00f3 \u0111\u00e1nh gi\u00e1 v\u00ec \u00f4 m\u00e0 n\u00f3 tham chi\u1ebfu \u0111\u1ebfn kh\u00f4ng ph\u1ea3i l\u00e0 v\u1ecb tr\u00ed cu\u1ed1i c\u00f9ng c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c, \u0111i\u1ec1u n\u00e0y kh\u00e1 r\u1eafc r\u1ed1i, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c d\u00e0i v\u00e0 ph\u1ee9c t\u1ea1p.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i nh\u1eefng \u0111i\u1ec1u tr\u00ean, c\u0169ng gi\u1ed1ng nh\u01b0 b\u1ea5t k\u1ef3 h\u00e0m Excel n\u00e0o kh\u00e1c<strong><em>, INDIRECT <\/em><\/strong>c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i n\u1ebfu b\u1ea1n l\u1ea1m d\u1ee5ng c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c l\u1ed7i \u0111i\u1ec3n h\u00ecnh nh\u1ea5t:<\/p>\n<p style=\"text-align: justify\"><strong><em>INDIRECT #REF! l\u1ed7i<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, c\u00f4ng th\u1ee9c INDIRECT s\u1ebd tr\u1ea3 v\u1ec1 #REF! l\u1ed7i trong ba tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<ol style=\"text-align: justify\">\n<li><strong><em>ref_text <\/em><\/strong>kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 h\u1ee3p l\u1ec7: V\u00ec n\u1ebfu tham s\u1ed1 ref_text trong c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0 tham chi\u1ebfu \u00f4 h\u1ee3p l\u1ec7, th\u00ec c\u00f4ng th\u1ee9c s\u1ebd cho k\u1ebft qu\u1ea3 l\u00e0 <strong><em>#REF! <\/em><\/strong>Gi\u00e1 tr\u1ecb l\u1ed7i. \u0110\u1ec3 tr\u00e1nh c\u00e1c v\u1ea5n \u0111\u1ec1 c\u00f3 th\u1ec3 x\u1ea3y ra, vui l\u00f2ng ki\u1ec3m tra c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m INDIRECT.<\/li>\n<li>\u0110\u00e3 v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n d\u1ea3i: N\u1ebfu \u0111\u1ed1i s\u1ed1 <strong><em>ref_text<\/em><\/strong> c\u1ee7a c\u00f4ng th\u1ee9c <strong><em>INDIRECT<\/em><\/strong> c\u1ee7a b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t lo\u1ea1t c\u00e1c \u00f4 v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n c\u1ee7a h\u00e0ng l\u00e0 1,048,576 ho\u1eb7c gi\u1edbi h\u1ea1n c\u1ed9t l\u00e0 16,384, b\u1ea1n c\u0169ng s\u1ebd g\u1eb7p l\u1ed7i #REF trong Excel 2007, 2010 v\u00e0 Excel 2013. C\u00e1c phi\u00ean b\u1ea3n Excel s\u1edbm h\u01a1n th\u00ec \u0111\u00e3 b\u1ecf qua qu\u00e1 m\u1ee9c gi\u1edbi h\u1ea1n v\u00e0 tr\u1ea3 l\u1ea1i m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb, m\u1eb7c d\u00f9, k\u1ebft qu\u1ea3 n\u00e0y th\u01b0\u1eddng kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t trong nh\u1eefng b\u1ea1n mong \u0111\u1ee3i.<\/li>\n<li>M\u1ed9t trang tham chi\u1ebfu ho\u1eb7c m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u00f3ng l\u1ea1i: N\u1ebfu c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c m\u1ed9t t\u00ednh Excel kh\u00e1c, th\u00ec b\u1ea3ng t\u00ednh \/ trang t\u00ednh kh\u00e1c ph\u1ea3i \u0111\u01b0\u1ee3c m\u1edf, n\u1ebfu kh\u00f4ng th\u00ec INDIRECT tr\u1ea3 v\u1ec1 #REF! l\u1ed7i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>INDIRECT #NAME? <\/em><\/strong>l\u1ed7i<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p r\u00f5 r\u00e0ng nh\u1ea5t, ng\u1ee5 \u00fd r\u1eb1ng c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i trong t\u00ean c\u1ee7a h\u00e0m c\u00f4ng th\u1ee9c, v\u00e0 \u0111i\u1ec1u n\u00e0y s\u1ebd d\u1eabn ch\u00fang ta \u0111\u1ebfn m\u1ee5c ti\u1ebfp sau \u0111\u00e2y \ud83d\ude42<\/p>\n<p style=\"text-align: justify\"><strong>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <em>INDIRECT<\/em> trong c\u00e1c ng\u00f4n ng\u1eef kh\u00f4ng ph\u1ea3i ti\u1ebfng Anh<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u00f2 m\u00f2 mu\u1ed1n bi\u1ebft r\u1eb1ng t\u00ean ti\u1ebfng Anh c\u1ee7a h\u00e0m INDIRECT \u0111\u00e3 \u0111\u01b0\u1ee3c d\u1ecbch sang 14 ng\u00f4n ng\u1eef nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y nh\u00ecn danh s\u00e1ch b\u00ean d\u01b0\u1edbi:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em> \u0110an M\u1ea1ch \u2013 INDIREKTE<\/em><\/strong><\/li>\n<li><strong><em> Ti\u1ebfng Ph\u1ea7n Lan \u2013 EP\u00c4SUORA<\/em><\/strong><\/li>\n<li><strong><em> Ti\u1ebfng \u0110\u1ee9c \u2013 INDIREKT<\/em><\/strong><\/li>\n<li><strong><em> Hungarian \u2013 INDIREKT<\/em><\/strong><\/li>\n<li><strong><em> \u00dd \u2013 INDIRETTO <\/em><\/strong><\/li>\n<li><strong><em> Na Uy \u2013 INDIREKTE<\/em><\/strong><\/li>\n<li><strong><em> Ba Lan \u2013 ADR.PO\u015aR<\/em><\/strong><\/li>\n<li><strong><em> Ti\u1ebfng T\u00e2y Ban Nha \u2013 INDIRECTO<\/em><\/strong><\/li>\n<li><strong><em> Th\u1ee5y \u0110i\u1ec3n \u2013 INDIREKT<\/em><\/strong><\/li>\n<li><strong><em> Th\u1ed5 Nh\u0129 K\u1ef3 \u2013 DOLAYLI<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u1ed9t v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p \u0111\u1ed1i v\u1edbi nh\u1eefng v\u00f9ng khu v\u1ef1c kh\u00f4ng s\u1eed d\u1ee5ng ti\u1ebfng anh th\u00ec t\u00ean c\u1ee7a h\u00e0m n\u00e0y kh\u00f4ng c\u00f2n l\u00e0 INDIRECT n\u1eefa, m\u00e0 s\u1ebd c\u00f3 c\u00e1c thi\u1ebft l\u1eadp khu v\u1ef1c (<strong><em>Regional Settings<\/em><\/strong>) kh\u00e1c nhau cho <strong><em>List Separator<\/em><\/strong>. Trong c\u1ea5u h\u00ecnh Windows chu\u1ea9n cho B\u1eafc M\u1ef9 v\u00e0 m\u1ed9t s\u1ed1 qu\u1ed1c gia kh\u00e1c, <strong><em>List Separator<\/em><\/strong> m\u1eb7c \u0111\u1ecbnh l\u00e0 m\u1ed9t d\u1ea5u ph\u1ea9y. Trong khi \u1edf c\u00e1c n\u01b0\u1edbc Ch\u00e2u \u00c2u, v\u1edbi d\u1ea5u ph\u1ea9y \u0111\u01b0\u1ee3c gi\u1eef nh\u01b0 bi\u1ec3u th\u1ee9c th\u1eadp ph\u00e2n (<strong><em>Decimal Symbol<\/em><\/strong>) th\u00ec khi \u0111\u00f3 <strong><em>List Separator<\/em><\/strong> \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh d\u1ea5u ch\u1ea5m ph\u1ea9y.<\/p>\n<p style=\"text-align: justify\">Do \u0111\u00f3, khi sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c gi\u1eefa hai v\u1ecb tr\u00ed Excel kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i \u201cWe found a problem with this data \u2026\u201d b\u1edfi <strong><em>v\u00ec List separator<\/em><\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c s\u1ebd kh\u00e1c v\u1edbi nh\u1eefng g\u00ec \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00ean m\u00e1y c\u1ee7a b\u1ea1n. N\u00ean n\u1ebfu b\u1ea1n g\u1eb7p l\u1ed7i n\u00e0y khi sao ch\u00e9p m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c INDIRECT t\u1eeb h\u01b0\u1edbng d\u1eabn n\u00e0y v\u00e0o Excel c\u1ee7a b\u1ea1n, ch\u1ec9 c\u1ea7n thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c d\u1ea5u ph\u1ea9y (,) b\u1eb1ng d\u1ea5u ch\u1ea5m ph\u1ea9y (;) \u0111\u1ec3 l\u00e0m cho n\u00f3 c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ki\u1ec3m tra D\u1ea5u t\u00e1ch Danh s\u00e1ch v\u00e0 K\u00fd hi\u1ec7u th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, h\u00e3y m\u1edf B\u1ea3ng \u0111i\u1ec1u khi\u1ec3n v\u00e0 \u0111i <strong><em>Region and Language &gt; Additional Settings<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Hy v\u1ecdng r\u1eb1ng, h\u01b0\u1edbng d\u1eabn n\u00e0y \u0111\u00e3 l\u00e0m s\u00e1ng t\u1ecf v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <strong><em>INDIRECT<\/em><\/strong> trong Excel. B\u00e2y gi\u1edd, khi b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111i\u1ec3m m\u1ea1nh v\u00e0 h\u1ea1n ch\u1ebf c\u1ee7a n\u00f3, th\u00ec \u0111\u00e3 \u0111\u1ebfn l\u00fac b\u1ea1n ph\u1ea3i b\u1eaft tay v\u00e0o v\u00e0 xem h\u00e0m <strong><em>INDIRECT<\/em><\/strong> c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1c c\u00f4ng vi\u1ec7c trong Excel nh\u01b0 th\u1ebf n\u00e0o. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc!<\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Blog ho\u0323c Excel Online<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2v84iM8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-299.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7464","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=7464"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7465"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}