{"id":12951,"date":"2022-11-02T17:15:35","date_gmt":"2022-11-02T10:15:35","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12951"},"modified":"2022-11-09T14:44:50","modified_gmt":"2022-11-09T07:44:50","slug":"ham-indirect-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/","title":{"rendered":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12951&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><b><i>H\u00e0m INDIRECT trong excel <\/i><\/b><i><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 h\u00e0m tham chi\u1ebfu gi\u00fap b\u1ea1n truy xu\u1ea5t s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch gi\u00e1n ti\u1ebfp. H\u00e0m n\u00e0y m\u1eb7c d\u00f9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 \u00edt trong excel, kh\u00f4ng th\u00f4ng d\u1ee5ng b\u1eb1ng m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m if, sum, average,&#8230; Nh\u01b0ng n\u00f3 c\u0169ng c\u00f3 nh\u1eefng l\u1ee3i \u00edch ri\u00eang v\u00e0 vi\u1ec7c n\u1eafm r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng kh\u00f4ng bao gi\u1edd l\u00e0 th\u1eeba. H\u00e3y c\u00f9ng v\u1edbi Teky tham kh\u1ea3o c\u1ee5 th\u1ec3 th\u00eam v\u1ec1 h\u00e0m INDIRECT excel c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng n\u00f3 nh\u00e9!<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Ham_INDIRECT_trong_excel_va_cong_thuc_su_dung\" >H\u00e0m INDIRECT trong excel v\u00e0 c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Cach_su_dung_ham_INDIRECT_trong_excel_ban_nen_biet\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT trong excel b\u1ea1n n\u00ean bi\u1ebft<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Su_dung_truc_tiep\" >S\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Su_dung_gian_tiep\" >S\u1eed d\u1ee5ng gi\u00e1n ti\u1ebfp<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Su_dung_ket_hop_voi_ham_Sum\" >S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#Tong_ket\" >T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_INDIRECT_trong_excel_va_cong_thuc_su_dung\"><\/span><b>H\u00e0m INDIRECT trong excel v\u00e0 c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m INDIRECT trong excel c\u00f3 l\u1ebd l\u00e0 c\u00f4ng th\u1ee9c xa l\u1ea1 \u0111\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi. Song n\u00f3 th\u1ef1c s\u1ef1 b\u1ed5 \u00edch v\u00e0 mang l\u1ea1i l\u1ee3i \u00edch tuy\u1ec7t v\u1eddi cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. C\u1ee5 th\u1ec3, n\u00f3 gi\u00fap b\u1ea1n tham chi\u1ebfu d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. V\u00e0 khi \u0111\u00f3 c\u00f4ng th\u1ee9c trong \u00f4 \u0111ang x\u00e9t b\u1ecb thay \u0111\u1ed5i c\u0169ng s\u1ebd kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn. V\u1eady h\u00e0m INDIRECT excel c\u00f3 c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3, c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m INDIRECT nh\u01b0 sau: <\/span><span style=\"font-weight: 400;\">=INDIRECT (ref_text, a1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi ref_text l\u00e0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u1ea7n tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u (chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c d\u1ea1ng m\u1ed9t m\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean). C\u00f2n a1 l\u00e0 gi\u00e1 tr\u1ecb ch\u1ec9 r\u00f5 ki\u1ec3u tham chi\u1ebfu. C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ed1i v\u1edbi h\u00e0m n\u00e0y t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n, ch\u1ec9 c\u00f3 m\u1ed9t s\u1ed1 b\u01b0\u1edbc c\u01a1 b\u1ea3n. C\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c cung c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 \u1edf ph\u1ea7n k\u1ebf ti\u1ebfp!<\/span><\/p>\n<figure id=\"attachment_12952\" aria-describedby=\"caption-attachment-12952\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12952\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\" alt=\"ham-indirect-trong-excel-1\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12952\" class=\"wp-caption-text\">H\u00e0m INDIRECT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1eb1m tham chi\u1ebfu d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/cach-nen-file-word\/\">C\u00e1ch n\u00e9n file word \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_INDIRECT_trong_excel_ban_nen_biet\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT trong excel b\u1ea1n n\u00ean bi\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi h\u00e0m INDIRECT, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp ho\u1eb7c gi\u00e1n ti\u1ebfp khi ch\u1ec9 c\u00f3 m\u1ed9t m\u00ecnh n\u00f3. Ngo\u00e0i ra b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p s\u1eed d\u1ee5ng v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c nh\u01b0: Sum, Average,&#8230; V\u00e0 \u1edf b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd t\u1eadp trung n\u00f3i v\u1ec1 s\u1eed d\u1ee5ng <\/span><b>h\u00e0m INDIRECT<\/b> <b>trong excel <\/b><span style=\"font-weight: 400;\">tr\u1ef1c ti\u1ebfp, gi\u00e1n ti\u1ebfp v\u00e0 k\u1ebft h\u1ee3p v\u1edbi Sum. C\u1ee5 th\u1ec3 tham kh\u1ea3o th\u00eam \u1edf nh\u1eefng ph\u1ea7n ti\u1ebfp theo!<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m indirect trong excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao (5 v\u00ed d\u1ee5 m\u1eabu)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/1HKS8FwCBN4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_truc_tiep\"><\/span><b><i>S\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed cho m\u1ed9t b\u1ea3ng s\u1ed1 li\u1ec7u gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. B\u1ea1n s\u1ebd tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp. C\u1ee5 th\u1ec3 s\u1eed d\u1ee5ng c\u00fa ph\u00e1p: = INDIRECT (B2).\u00a0 \u1ede \u0111\u00e2y \u00f4 tham chi\u1ebfu ch\u00ednh l\u00e0 A3. Sau khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u v\u1ec1 \u00f4 A3 th\u00ec \u0111\u01b0\u1ee3c \u0111\u00e1p \u00e1n l\u00e0 gi\u00e1 tr\u1ecb 4. T\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u00e1c h\u00e0ng kh\u00e1c b\u1eb1ng c\u00e1ch di chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 C2. Sau \u0111\u00f3 k\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ebfn v\u1ecb tr\u00ed \u00f4 C8 \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f9ng c\u00f4ng th\u1ee9c \u0111\u00f3 cho c\u00e1c \u00f4 sau.\u00a0<\/span><\/p>\n<figure id=\"attachment_12953\" aria-describedby=\"caption-attachment-12953\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12953\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-2.jpg\" alt=\"ham-indirect-trong-excel-2\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-2.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-2-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-2-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12953\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m INDIRECT \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 sau th\u00ec ch\u00fang ta s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u1ed1ng nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng gi\u00e1 tr\u1ecb C2 = B2= A3 = 4. T\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u00e1c \u00f4 kh\u00e1c.\u00a0<\/span><\/p>\n<figure id=\"attachment_12954\" aria-describedby=\"caption-attachment-12954\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12954\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-3.jpg\" alt=\"ham-indirect-trong-excel-3\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-3.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-3-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-3-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12954\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng sau khi s\u1eed d\u1ee5ng h\u00e0m INDIRECT tr\u1ef1c ti\u1ebfp<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT tr\u1ef1c ti\u1ebfp kh\u00e1 d\u1ec5 hi\u1ec3u v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. Ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111\u1ec3 \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_gian_tiep\"><\/span><b><i>S\u1eed d\u1ee5ng gi\u00e1n ti\u1ebfp<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m tham s\u1ed1 gi\u00e1n ti\u1ebfp th\u00ec s\u1ebd c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t so v\u1edbi h\u00e0m tham s\u1ed1 tr\u1ef1c ti\u1ebfp n\u00f3i \u0111\u1ebfn \u1edf tr\u00ean. C\u1ee5 th\u1ec3 v\u1edbi th\u00f4ng tin d\u1eef li\u1ec7u nh\u01b0 \u1edf h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c gi\u00e1n ti\u1ebfp: = INDIRECT(\u201cA\u201d&amp;B2).\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y c\u00f3 ngh\u0129a nh\u01b0 sau: Ch\u1eef A \u1edf trong b\u1ea3ng t\u00ednh ch\u1ec9 c\u1ed9t A. C\u00f2n B2 ch\u1ec9 gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 B2 =4. L\u00fac n\u00e0y, ch\u1eef &amp; s\u1ebd k\u1ebft n\u1ed1i \u201cA\u201d v\u00e0 3 ch\u1ec9 gi\u00e1 tr\u1ecb A4. M\u00e0 t\u1ea1i \u00f4 A4 th\u00ec gi\u00e1 tr\u1ecb l\u00e0 6. Nh\u01b0 v\u1eady sau khi INDIRECT tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u v\u1ec1 \u00f4 A4 th\u00ec \u0111\u00e1p \u00e1n ch\u00ednh l\u00e0 6.\u00a0<\/span><\/p>\n<figure id=\"attachment_12955\" aria-describedby=\"caption-attachment-12955\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12955\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-4.jpg\" alt=\"ham-indirect-trong-excel-4\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-4.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-4-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-4-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12955\" class=\"wp-caption-text\">H\u00e0m tham s\u1ed1 gi\u00e1n ti\u1ebfp t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi h\u00e0m tham s\u1ed1 tr\u1ef1c ti\u1ebfp<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi k\u00e9o chu\u1ed9t \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y cho c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi l\u1ea7n l\u01b0\u1ee3t t\u1eeb C3 \u0111\u1ebfn C8 th\u00ec ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh d\u01b0\u1edbi. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng gi\u00e1 tr\u1ecb \u1edf \u00f4 C2 = A4 = 6. T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c \u00f4 kh\u00e1c.\u00a0\u00a0<\/span><\/p>\n<figure id=\"attachment_12956\" aria-describedby=\"caption-attachment-12956\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12956\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-5.jpg\" alt=\"ham-indirect-trong-excel-5\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-5.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-5-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-5-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12956\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng h\u00e0m INDIRECT gi\u00e1n ti\u1ebfp<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, h\u00e0m INDIRECT gi\u00e1n ti\u1ebfp ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi h\u00e0m tr\u1ef1c ti\u1ebfp. V\u00e0 c\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho \u00f4 tham chi\u1ebfu b\u1ea5t k\u1ef3.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_voi_ham_Sum\"><\/span><b><i>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i s\u1eed d\u1ee5ng m\u1ed9t m\u00ecnh th\u00ec h\u00e0m INDIRECT c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum. T\u1ee9c l\u00e0 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb tham chi\u1ebfu. C\u1ee5 th\u1ec3 v\u00ed d\u1ee5 minh h\u1ecda cho b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o nh\u01b0 sau.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean ta c\u00f3 m\u1ed9t b\u1ea3ng ghi s\u1ed1 l\u01b0\u1ee3ng \u00e1o, qu\u1ea7n v\u00e0 m\u0169 c\u1ee7a c\u00e1c th\u00f9ng h\u00e0ng. V\u00e0 y\u00eau c\u1ea7u l\u00e0 c\u1ea7n t\u00ednh t\u1ed5ng s\u1ed1 m\u0169 c\u00f3 trong t\u1ea5t c\u1ea3 c\u00e1c th\u00f9ng h\u00e0ng. Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m INDIRECT + Sum \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 m\u0169.\u00a0<\/span><\/p>\n<figure id=\"attachment_12957\" aria-describedby=\"caption-attachment-12957\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12957\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-6.jpg\" alt=\"ham-indirect-trong-excel-6\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-6.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-6-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-6-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12957\" class=\"wp-caption-text\">T\u00ednh t\u1ed5ng s\u1ed1 m\u0169 v\u1edbi h\u00e0m INDIRECT v\u00e0 h\u00e0m Sum<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n b\u00f4i \u0111en h\u1ebft s\u1ed1 li\u1ec7u t\u1eeb C3 \u0111\u1ebfn C7, sau \u0111\u00f3 \u0111\u1eb7t t\u00ean cho n\u00f3 l\u00e0 \u201cM\u0169\u201d. Ti\u1ebfp theo, b\u1ea1n s\u1ebd d\u00f9ng c\u00f4ng th\u1ee9c: = SUM(INDIRECT(F2)). \u1ede \u0111\u00e2y, F2 ch\u00ednh l\u00e0 M\u0169. V\u00e0 khi tham chi\u1ebfu th\u00ec s\u1ebd d\u1eabn \u0111\u1ebfn gi\u00e1 tr\u1ecb m\u0169 l\u00e0 t\u1eeb C3 \u0111\u1ebfn C7. Sau khi t\u00ednh Sum th\u00ec s\u1ebd ra k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng.\u00a0<\/span><\/p>\n<figure id=\"attachment_12958\" aria-describedby=\"caption-attachment-12958\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12958\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-7.jpg\" alt=\"ham-indirect-trong-excel-7\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-7.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-7-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-7-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12958\" class=\"wp-caption-text\">T\u00ednh t\u1ed5ng s\u1ed1 m\u0169 \u0111\u01a1n gi\u1ea3n sau khi g\u00e1n t\u00ean g\u1ecdi cho kho\u1ea3ng gi\u00e1 tr\u1ecb<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng th\u00ec ch\u00fang ta s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1p \u00e1n t\u1ed5ng s\u1ed1 m\u0169 gi\u1ed1ng nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi \u0111\u00e2y. Nh\u00ecn chung m\u1ecdi th\u1ee9 kh\u00e1 d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 d\u1ec5 hi\u1ec3u, \u0111\u00fang kh\u00f4ng n\u00e0o? V\u00e0 c\u00e1c phi\u00ean b\u1ea3n excel nh\u01b0 2010, 2014, 2016,&#8230; \u0111\u1ec1u c\u00f3 chung m\u1ed9t c\u00e1ch t\u00ednh gi\u1ed1ng nh\u01b0 v\u1eady.\u00a0<\/span><\/p>\n<figure id=\"attachment_12959\" aria-describedby=\"caption-attachment-12959\" style=\"width: 920px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12959\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-8.jpg\" alt=\"ham-indirect-trong-excel-8\" width=\"920\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-8.jpg 920w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-8-400x217.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-8-768x417.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption id=\"caption-attachment-12959\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c INDIRECT k\u1ebft h\u1ee3p v\u1edbi Sum ra \u0111\u00e1p \u00e1n nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><b>T\u1ed5ng k\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 nh\u1eefng th\u00f4ng tin li\u00ean quan \u0111\u1ebfn <\/span><b>h\u00e0m INDIRECT trong excel <\/b><span style=\"font-weight: 400;\">v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang. Mong r\u1eb1ng th\u00f4ng tin tr\u00ean do Teky cung c\u1ea5p s\u1ebd c\u00f3 \u00edch cho b\u1ea1n. Khi\u1ebfn cho b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 b\u1ea3n ch\u1ea5t c\u0169ng nh\u01b0 c\u00e1ch d\u00f9ng h\u00e0m INDIRECT. Tham kh\u1ea3o th\u00eam nh\u1eefng th\u00f4ng tin kh\u00e1ch li\u00ean quan t\u1ea1i Teky nh\u00e9! C\u1ea3m \u01a1n v\u00ec \u0111\u00e3 \u0111\u00f3n \u0111\u1ecdc th\u00f4ng tin ch\u00fang t\u00f4i mang \u0111\u1ebfn.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 h\u00e0m tham chi\u1ebfu gi\u00fap b\u1ea1n truy xu\u1ea5t s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch gi\u00e1n ti\u1ebfp. H\u00e0m n\u00e0y m\u1eb7c d\u00f9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 \u00edt trong excel, kh\u00f4ng th\u00f4ng d\u1ee5ng b\u1eb1ng m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m if, sum, average,&#8230; Nh\u01b0ng n\u00f3 c\u0169ng c\u00f3 nh\u1eefng l\u1ee3i \u00edch ri\u00eang &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12952,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12951","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/title>\n<meta name=\"description\" content=\"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-02T10:15:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-09T07:44:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"920\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o\",\"datePublished\":\"2022-11-02T10:15:35+00:00\",\"dateModified\":\"2022-11-09T07:44:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\"},\"wordCount\":1701,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\",\"name\":\"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\",\"datePublished\":\"2022-11-02T10:15:35+00:00\",\"dateModified\":\"2022-11-09T07:44:50+00:00\",\"description\":\"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg\",\"width\":920,\"height\":500,\"caption\":\"H\u00e0m INDIRECT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1eb1m tham chi\u1ebfu d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o","description":"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o","og_description":"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky","og_url":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-02T10:15:35+00:00","article_modified_time":"2022-11-09T07:44:50+00:00","og_image":[{"width":920,"height":500,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o","datePublished":"2022-11-02T10:15:35+00:00","dateModified":"2022-11-09T07:44:50+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/"},"wordCount":1701,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/","name":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg","datePublished":"2022-11-02T10:15:35+00:00","dateModified":"2022-11-09T07:44:50+00:00","description":"H\u00e0m INDIRECT trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. H\u00e3y t\u00ecm hi\u1ec3u v\u1edbi Teky","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-indirect-trong-excel-1.jpg","width":920,"height":500,"caption":"H\u00e0m INDIRECT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1eb1m tham chi\u1ebfu d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-indirect-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m INDIRECT trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12951"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12951\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12952"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}