{"id":28413,"date":"2021-08-09T17:13:54","date_gmt":"2021-08-09T10:13:54","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=28413"},"modified":"2021-11-23T16:58:07","modified_gmt":"2021-11-23T09:58:07","slug":"ham-indirect","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-indirect\/","title":{"rendered":"H\u00e0m Indirect trong Excel l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 V\u00ed d\u1ee5"},"content":{"rendered":"<p>\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea1n sinh vi\u00ean ho\u1eb7c d\u00e2n v\u0103n ph\u00f2ng th\u00ec kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 v\u1edbi ph\u1ea7n m\u1ec1m Excel. Excel cho ph\u00e9p h\u1ed7 tr\u1ee3 c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m t\u00ednh \u0111\u1ec3 gi\u00fap th\u1ed1ng k\u00ea m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t. Nhi\u1ec1u h\u00e0m t\u00ednh to\u00e1n quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u01b0: Sum, Average, Count, Max, Min,&#8230;. B\u00ean c\u1ea1nh c\u00e1c h\u00e0m quen thu\u1ed9c c\u00f2n c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m ti\u1ec7n \u00edch kh\u00e1c, \u1edf b\u00e0i vi\u1ebft n\u00e0y, Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n <strong>h\u00e0m Indirect<\/strong> trong Excel v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng v\u00e0o trong b\u00e0i.<\/p>\n<h2><span style=\"font-size: 18pt;\"><strong>1\/ H\u00e0m Indirect l\u00e0 g\u00ec?<\/strong><\/span><\/h2>\n<p><span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-indirect\/\"><strong>H\u00e0m Indirect<\/strong><\/a><\/span> l\u00e0 m\u1ed9t h\u00e0m trong Excel cho ph\u00e9p c\u00e1c b\u1ea1n t\u1ea1o tham chi\u1ebfu \u0111\u1ed9ng trong c\u00e1c \u00f4, c\u00e1c d\u00e3y th\u1eadm ch\u00ed c\u00e1c trang t\u00ednh kh\u00e1c m\u00e0 v\u1eabn gi\u1eef nguy\u00ean c\u00f4ng th\u1ee9c ban \u0111\u1ea7u c\u1ee7a \u00f4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"329\" class=\"aligncenter wp-image-28414 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect.jpg\" alt=\"H\u00e0m Indirect\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect.jpg 600w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-300x165.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span style=\"font-size: 18pt;\"><strong>2\/ C\u00f4ng th\u1ee9c h\u00e0m Indirect trong Excel<\/strong><\/span><\/h2>\n<p>Khi c\u00e1c b\u1ea1n g\u00f5 h\u00e0m Indirect trong m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 c\u1ee7a Excel s\u1ebd \u0111\u01b0\u1ee3c th\u1ea5y c\u00f4ng th\u1ee9c g\u1ee3i \u00fd l\u00e0: <strong>INDIRECT(ref_text, [a1]).<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"398\" class=\"aligncenter wp-image-28415 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-1.jpg\" alt=\"h\u00e0m indirect(substitute)\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-1.jpg 600w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-1-300x199.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>C\u1ee5 th\u1ec3:<\/p>\n<ul>\n<li><strong>ref_text<\/strong>: l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 c\u00e1c b\u1ea1n \u0111\u1ecbnh tham chi\u1ebfu, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u00f4, ho\u1eb7c m\u1ed9t d\u00e3y, m\u1ed9t v\u00f9ng m\u00e0 c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1eb7t t\u00ean. (l\u01b0u \u00fd: \u0111\u1ec3 \u0111\u1eb7t t\u00ean cho v\u00f9ng tham chi\u1ebfu, c\u00e1c b\u1ea1n b\u00f4i \u0111en c\u1ea3 v\u00f9ng v\u00e0 \u0111i\u1ec1n v\u00e0o \u00f4 tr\u1ed1ng ngay b\u00ean d\u01b0\u1edbi khung clipboard). \u1ede \u0111\u00e2y, c\u00e1c b\u1ea1n c\u00f3 2 c\u00e1ch \u0111\u1ec3 \u0111i\u1ec1n v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng v\u1edbi 2 c\u00e1ch g\u1ecdi \u0111\u1ecba ch\u1ec9 \u00f4: v\u00ed d\u1ee5: A1 (A l\u00e0 t\u00ean c\u1ed9t, 1 l\u00e0 v\u1ecb tr\u00ed \u00f4 trong c\u1ed9t) ho\u1eb7c R1C1 (V\u1ecb tr\u00ed l\u00e0 d\u00f2ng 1, c\u1ed9t 1)<\/li>\n<li><strong>a1<\/strong>: l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh ki\u1ec3u tham chi\u1ebfu \u0111\u00e3 k\u1ec3 tr\u00ean:\u00a0N\u1ebfu l\u00e0 <strong><em>TRUE<\/em><\/strong> ho\u1eb7c l\u00e0 b\u1ecf qua, <strong><em>ref_text<\/em>\u00a0<\/strong>ph\u00eda tr\u01b0\u1edbc \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 tham chi\u1ebfu m\u1ed9t \u00f4. VD: A1 \u2013 tham chi\u1ebfu \u00f4. N\u1ebfu l\u00e0 <strong><em>FALSE<\/em><\/strong>,\u00a0<strong><em>ref_text <\/em><\/strong>s\u1ebd \u0111\u01b0\u1ee3c xem nh\u01b0 tham chi\u1ebfu R1C1.<\/li>\n<li>Th\u00f4ng th\u01b0\u1eddng khi nh\u1eadp h\u00e0m , c\u00e1c b\u1ea1n s\u1ebd nh\u1eadp theo c\u00e1ch ki\u1ec3u tham chi\u1ebfu th\u1ee9 nh\u1ea5t, t\u1ee9c l\u00e0 tham chi\u1ebfu 1 \u00f4 &#8211; A1<\/li>\n<\/ul>\n<p>L\u01b0u \u00fd: Khi c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng <strong>h\u00e0m Indirect<\/strong>, n\u1ebfu v\u00f9ng c\u00e1c b\u1ea1n \u0111\u1ecbnh tham chi\u1ebfu n\u1eb1m trong m\u1ed9t trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c th\u00ec c\u00e1c b\u1ea1n c\u1ea7n m\u1edf b\u1ea3ng t\u00ednh \u0111\u00f3 l\u00ean \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p b\u1ecb b\u00e1o l\u1ed7i khi nh\u1eadp h\u00e0m.<\/p>\n<h2><span style=\"font-size: 18pt;\"><strong>3\/ V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m Indirect<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"307\" class=\"aligncenter wp-image-28416 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-3.jpg\" alt=\"H\u00e0m Indirect trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-3.jpg 600w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/08\/ham-indirect-3-300x154.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>\u0110\u1ec3 minh h\u1ecda cho c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Indirect trong excel<\/strong>, Ben Computer s\u1ebd l\u1ea5y m\u1ed9t v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>V\u00ed d\u1ee5 b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng sheet c\u00f3 c\u00e1c \u00f4 ch\u1ee9a th\u00f4ng tin nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>\u00d4 A1<\/strong>: 120, <strong>\u00f4 A2<\/strong>: 130, <strong>\u00f4 A3<\/strong>: 140, <strong>\u00f4\u00a0A4<\/strong>: 150<\/li>\n<li><strong>\u00d4 C1<\/strong>: A2, <strong>\u00f4 C3<\/strong>: R2C1, <strong>\u00f4 C5<\/strong>: R3C.<\/li>\n<\/ul>\n<p>N\u1ebfu c\u00e1c b\u1ea1n mu\u1ed1n l\u1eadp c\u00f4ng th\u1ee9c tham chi\u1ebfu, tham kh\u1ea3o nh\u1eefng c\u00e1ch sau:<\/p>\n<ul>\n<li><strong>C\u00f4ng th\u1ee9c: &#8220;= INDIRECT (C1)&#8221;<\/strong><\/li>\n<\/ul>\n<p>N\u1ebfu c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o b\u1ea5t c\u1ee9 \u00f4 n\u00e0o, \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c tham chi\u1ebfu theo \u00f4 C1. Theo d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng, n\u1ed9i dung \u00f4 C1 l\u00e0 A2, nh\u01b0 v\u1eady \u00f4 c\u00e1c b\u1ea1n nh\u1eadp h\u00e0m s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 A2 l\u00e0 130.<\/p>\n<ul>\n<li><strong>C\u00f4ng th\u1ee9c: &#8220;= INDIRECT (C3, FALSE)&#8221;<\/strong><\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o 1 \u00f4 b\u1ea5t k\u1ef3, ch\u1eef FALSE cho th\u1ea5y ki\u1ec3u tham chi\u1ebfu \u1edf \u00f4 n\u00e0y s\u1ebd theo ki\u1ec3u R1C1. N\u1ed9i dung c\u1ee7a \u00f4 C3 l\u00e0 R2C1, nh\u01b0 v\u1eady, c\u00e1c b\u1ea1n s\u1ebd t\u00ecm \u00f4 thu\u1ed9c d\u00f2ng th\u1ee9 2 c\u1ee7a c\u1ed9t 1 \u0111\u1ec3 tham chi\u1ebfu gi\u00e1 tr\u1ecb. \u1ede \u0111\u00e2y \u00f4 tham chi\u1ebfu ch\u00ednh l\u00e0 A2, v\u1eady gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0 130.<\/p>\n<p>V\u00ed d\u1ee5 tr\u00ean \u0111\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u00e1c b\u1ea1n th\u01b0\u1eddng s\u1eed d\u1ee5ng <strong>h\u00e0m Indirect<\/strong> \u0111\u1ec3 tham chi\u1ebfu. Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 Vlookup \u0111\u1ec3 gi\u1ea3i quy\u1ebft nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n<p><strong>K\u1ebft lu\u1eadn:<\/strong> Tr\u00ean \u0111\u00e2y,<strong><a href=\"https:\/\/ben.com.vn\/\"> Ben Computer<\/a><\/strong> \u0111\u00e3 cung c\u1ea5p cho c\u00e1c b\u1ea1n nh\u1eefng th\u00f4ng tin v\u1ec1 h\u00e0m Indirect trong Excel v\u00e0 v\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p c\u01a1 b\u1ea3n s\u1eed d\u1ee5ng <strong>h\u00e0m Indirect trong Excel<\/strong>. Ch\u00fac c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m th\u00e0nh c\u00f4ng trong trang t\u00ednh c\u1ee7a m\u00ecnh. N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 \u0111\u00f3ng g\u00f3p ho\u1eb7c th\u1eafc m\u1eafc g\u00ec li\u00ean quan \u0111\u1ebfn b\u00e0i vi\u1ebft tr\u00ean, h\u00e3y comment xu\u1ed1ng ph\u00eda d\u01b0\u1edbi cho Ben Computer bi\u1ebft nh\u00e9!<\/p>\n<blockquote><p>C\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m:<\/p>\n<ul>\n<li><span style=\"color: #ff0000;\"><strong><a style=\"color: #ff0000;\" href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-loc-du-lieu-trung-nhau-trong-excel\/\">H\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel<\/a><\/strong><\/span><\/li>\n<li><span style=\"color: #ff0000;\"><strong><a style=\"color: #ff0000;\" href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-trim-trong-excel\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Trim trong Excel<\/a><\/strong><\/span><\/li>\n<\/ul>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea1n sinh vi\u00ean ho\u1eb7c d\u00e2n v\u0103n ph\u00f2ng th\u00ec kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 v\u1edbi ph\u1ea7n m\u1ec1m Excel. Excel cho ph\u00e9p h\u1ed7 tr\u1ee3 c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m t\u00ednh \u0111\u1ec3 gi\u00fap th\u1ed1ng k\u00ea m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t. Nhi\u1ec1u h\u00e0m t\u00ednh to\u00e1n quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u01b0: [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":28414,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-28413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28413","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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=28413"}],"version-history":[{"count":2,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28413\/revisions"}],"predecessor-version":[{"id":44445,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28413\/revisions\/44445"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/28414"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=28413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=28413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=28413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}