{"id":291816,"date":"2023-12-12T10:33:38","date_gmt":"2023-12-12T03:33:38","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=291816"},"modified":"2023-12-12T10:33:38","modified_gmt":"2023-12-12T03:33:38","slug":"ham-importrange","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n chuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 thu th\u1eadp d\u1eef li\u1ec7u ho\u1eb7c t\u00ednh to\u00e1n th\u00ec ho\u00e0n to\u00e0n kh\u00e1 quen thu\u1ed9c v\u1edbi c\u00e1c h\u00e0m c\u1ee7a b\u1ea3ng t\u00ednh n\u00e0y. M\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi l\u1ef1a ch\u1ecdn s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 h\u00e0m IMPORTRANGE. Tuy nhi\u00ean, c\u00e1ch d\u00f9ng h\u00e0m t\u00ednh IMPORTRANGE trong Google Sheets c\u00f3 t\u01b0\u01a1ng t\u1ef1 Excel kh\u00f4ng? Th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE trong Google Sheets c\u00f9ng Ho\u00e0ng H\u00e0 Mobile nh\u00e9.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m IMPORTRANGE l\u00e0 g\u00ec?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m IMPORTRANGE \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a l\u00e0 h\u00e0m t\u00ednh \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t c\u00e1c d\u1eef li\u1ec7u t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c nhau. T\u1eeb c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c nhau s\u1ebd t\u1eadp h\u1ee3p v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh cu\u1ed1i c\u00f9ng m\u00e0 ng\u01b0\u1eddi d\u00f9ng s\u1ebd s\u1eed d\u1ee5ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ee3i \u00edch ma\u0300 ba\u0323n c\u00e2\u0300n bi\u00ea\u0301t khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE trong Google Sheet c\u1ee5 th\u1ec3 nh\u01b0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 nhanh ch\u00f3ng c\u00e1c thao t\u00e1c tri\u0301ch xu\u00e2\u0301t d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 co\u0301 th\u00ea\u0309 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t \u0111\u01b0\u1ee3c th\u00f4ng tin d\u1ec5 d\u00e0ng v\u00e0 linh ho\u1ea1t h\u01a1n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1edd v\u00e0o h\u00e0m t\u00ednh IMPORTRANGE th\u00ec d\u1eef li\u1ec7u n\u0103\u0300m tr\u00ean file Sheet \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t se\u0303 \u0111\u01b0\u01a1\u0323c thay \u0111\u00f4\u0309i. Lu\u0301c na\u0300y d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh cu\u1ed1i c\u00f9ng c\u0169ng s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i m\u00f4\u0323t ca\u0301ch t\u01b0\u01a1ng \u01b0\u0301ng.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-292095 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-1.jpg\" alt=\"ham-importrange-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e2\u0301u tru\u0301c ti\u0301nh c\u1ee7a h\u00e0m IMPORTRANGE l\u00e0 g\u00ec?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1eady c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m IMPORTRANGE l\u00e0 g\u00ec? C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m t\u00ednh IMPORTRANGE trong b\u1ea3ng t\u00ednh Google Sheets chi ti\u00ea\u0301t bao g\u00f4\u0300m:<\/span><\/p>\n<p><b><i>=IMPORTRANGE(\u201cspreadsheet_url\u201d; \u201cgia\u0301_tri\u0323_\u00f4\u201d).\u00a0<\/i><\/b><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-292097 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-2.jpg\" alt=\"ham-importrange-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c y\u1ebfu t\u1ed1 trong c\u1ea5u tr\u00fac h\u00e0m bao g\u1ed3m nh\u1eefng n\u1ed9i dung sau:\u00a0<\/span><\/p>\n<ul>\n<li data-sourcepos=\"9:3-9:189\"><strong>Spreadsheet URL<\/strong> l\u00e0 y\u1ebfu t\u1ed1 c\u1ee7a \u0111\u01b0\u1eddng d\u1eabn cu\u0309a link URL c\u1ee7a t\u1ec7p Google Sheet \u0111\u01b0\u1ee3c tr\u00edch d\u1eef li\u1ec7u. \u0110\u01b0\u1eddng d\u1eabn URL c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a URL c\u1ee7a b\u1ea3ng t\u00ednh d\u1eef li\u1ec7u.<\/li>\n<li data-sourcepos=\"9:3-9:189\"><b>Gia\u0301 tri\u0323 da\u0309i \u00f4 <\/b>l\u00e0 y\u1ebfu t\u1ed1 x\u00e1c \u0111\u1ecbnh c\u00e1c c\u1ed9t ho\u1eb7c h\u00e0ng c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u. Gi\u00e1 tr\u1ecb c\u1ee7a y\u1ebfu t\u1ed1 n\u00e0y c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a n\u1ed9i dung v\u0103n b\u1ea3n ph\u00f9 h\u1ee3p trong b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau m\u00e0 b\u1ea1n c\u00e2\u0300n n\u0103\u0301m \u0111\u00ea\u0309 th\u01b0\u0323c hi\u00ea\u0323n c\u1ee5 th\u1ec3 chi ti\u1ebft c\u00e1c b\u01b0\u1edbc:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ea5y d\u1eef li\u1ec7u trong Google Sheet t\u1eeb m\u00f4\u0323t file Google Sheet kha\u0301c\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE trong Google Sheet \u0111\u1ec3 tr\u00edch xu\u00e2\u0301t d\u01b0\u0303 li\u00ea\u0323u th\u00f4ng qua file kha\u0301c. \u0110\u1ec3 hi\u1ec3u r\u00f5 chi ti\u1ebft h\u01a1n, ch\u00fang t\u00f4i s\u1ebd v\u00ed d\u1ee5 s\u1eed d\u1ee5ng file c\u00f3 s\u1eb5n d\u1eef li\u1ec7u v\u1ec1 danh s\u00e1ch sinh vi\u00ean.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n ph\u1ea3i copy \u0111\u01b0\u1eddng d\u00e2\u0303n link url c\u1ee7a file c\u00f3 s\u1eb5n v\u1ec1 danh s\u00e1ch sinh vi\u00ean.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-3-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-3-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-3-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-295200 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-3-1.jpg\" alt=\"ham-importrange-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-3-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-3-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-3-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfn h\u00e0nh s\u1eed d\u1ee5ng c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m t\u00ednh IMPORTRANGE n\u0103\u0300m trong b\u1ea3ng t\u00ednh cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea1n nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><b>=IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws\/edit#gid=0&#8217;; &#8216;Danh sa\u0301ch sinh vi\u00ean \u0110\u1ea1i Tr\u00e0!A3:E7&#8217;)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">C\u1ea5u tr\u00fac n\u00e0y c\u00f3 \u00fd ngh\u0129a \u0111\u00f3 l\u00e0 tr\u00edch v\u00f9ng d\u1eef li\u1ec7u dao \u0111\u00f4\u0323ng t\u01b0\u0300 A2 \u0111\u1ebfn \u00f4 E7 c\u00f3 trong file d\u1eef li\u1ec7u danh s\u00e1ch sinh vi\u00ean. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0\u1eddng link url b\u1eb1ng k\u00fd t\u1ef1 k\u00ea\u0301t thu\u0301c c\u1ee7a file \u0111\u1ec3 ng\u1eafn g\u1ecdn h\u01a1n v\u1edbi c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><b>=IMPORTRANGE(&#8216;1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws&#8217;; &#8216;Danh sa\u0301ch sinh vi\u00ean \u0110\u1ea1i Tr\u00e0!A3:E8&#8217;)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Sau khi \u0111\u00e3 nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh xong th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m Enter r\u1ed3i ch\u1edd h\u1ec7 th\u1ed1ng Loading. Khi b\u1ea1n th\u1ea5y b\u1ea1n t\u00ednh th\u1ec3 hi\u1ec7n n\u1ed9i dung t\u01b0\u01a1ng t\u1ef1 d\u01b0\u1edbi h\u00ecnh ngh\u0129a l\u00e0 \u0111\u00e3 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c vi\u1ec7c tr\u00edch d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-4-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-4-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-4-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295201 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-4-1.jpg\" alt=\"ham-importrange-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-4-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-4-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-4-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng qua 3 b\u01b0\u01a1\u0301c h\u01b0\u01a1\u0301ng d\u00e2\u0303n chi ti\u00ea\u0301t \u01a1\u0309 tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n toa\u0300n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t \u0111\u01b0\u1ee3c v\u00f9ng d\u1eef li\u1ec7u t\u1eeb file kh\u00e1c v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ea5y d\u1eef li\u1ec7u trong Google Sheet th\u00f4ng qua ca\u0301c Sheet n\u1eb1m trong file\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u li\u00ean k\u1ebft t\u1eeb 2 file kh\u00e1c nhau th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch v\u00f9ng d\u1eef li\u1ec7u t\u1eeb c\u00e1c Sheet kh\u00e1c nhau n\u1eb1m thu\u00f4\u0323c cu\u0300ng file d\u01b0\u0303 li\u00ea\u0323u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE gi\u1eefa c\u00e1c Sheet trong c\u00f9ng m\u1ed9t file chi ti\u1ebft.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong file c\u1ee7a danh s\u00e1ch sinh vi\u00ean bao g\u1ed3m 2 Sheet v\u1edbi n\u1ed9i dung c\u1ee7a l\u1edbp ch\u00e2\u0301t l\u01b0\u01a1\u0323ng cao (CLC) v\u00e0 l\u1edbp \u0111a\u0323i tra\u0300. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u li\u00ean k\u1ebft t\u1eeb Sheet l\u1edbp ch\u1ea5t l\u01b0\u1ee3ng cao qua Sheet d\u1eef li\u1ec7u l\u1edbp \u0111\u1ea1i tr\u00e0 chi ti\u1ebft:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n ph\u1ea3i copy \u0111\u01b0\u1eddng d\u1eabn link c\u1ee7a file danh s\u00e1ch sinh vi\u00ean.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-5-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-5-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-5-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295202 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-5-1.jpg\" alt=\"ham-importrange-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-5-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-5-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-5-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh paste \u0111\u01b0\u1eddng link v\u1eeba \u0111\u01b0\u1ee3c copy v\u00e0o c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m IMPORTRANGE n\u1eb1m \u1edf trong sheet danh sa\u0301ch sinh vi\u00ean \u0111\u1ea1i tr\u00e0 c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><b>=IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws\/edit#gid=0&#8217;; &#8216;Danh sa\u0301ch sinh vi\u00ean CLC!A3:E13&#8217;)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi \u00fd ngh\u0129a \u0111\u1ec3 tr\u00edch v\u00f9ng d\u1eef li\u1ec7u n\u1eb1m t\u1eeb \u00f4 A3 \u0111\u1ebfn \u00f4 E13 trong sheet c\u1ee7a l\u1edbp ch\u1ea5t l\u01b0\u1ee3ng cao.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ti\u1ebfp theo, b\u1ea1n s\u1ebd nh\u1ea5n n\u00fat Enter r\u1ed3i ch\u1edd h\u1ec7 th\u1ed1ng Loading. Khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t v\u00f9ng d\u1eef li\u1ec7u th\u00f4ng qua sheet c\u1ee7a l\u1edbp ch\u1ea5t l\u01b0\u1ee3ng cao s\u1ebd hi\u1ec3n th\u1ecb n\u1ed9i dung k\u1ebft qu\u1ea3 b\u00ean d\u01b0\u1edbi.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-6-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-6-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-6-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295203 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-6-1.jpg\" alt=\"ham-importrange-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-6-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-6-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-6-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng qua vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m t\u00ednh <\/span><span style=\"font-weight: 400;\">IMPORTRANGE s\u1ebd gi\u00fap cho v\u00e2\u0301n \u0111\u00ea\u0300 li\u00ean k\u1ebft th\u00f4ng qua c\u00e1c Sheet n\u1eb1m trong cu\u0300ng file nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE c\u00f3 \u0111i\u1ec1u ki\u1ec7n\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE c\u00f3 \u0111i\u1ec1u ki\u1ec7n hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c h\u01a1n trong Google Sheets:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">File Google Sheets ph\u1ea3i \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n truy c\u1eadp\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE li\u00ean k\u1ebft v\u1edbi file Google Sheet kh\u00f4ng thu\u1ed9c quy\u1ec1n s\u1edf h\u1eefu c\u1ee7a m\u00ecnh th\u00ec c\u1ea7n ph\u1ea3i \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 quy\u1ec1n truy c\u1eadp. Khi b\u1ea1n \u0111\u01b0\u1ee3c c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 quy\u1ec1n truy c\u1eadp th\u00ec c\u00f3 th\u1ec3 l\u1ea5y to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea5t k\u1ef3 sheet n\u00e0o c\u1ee7a file Google Sheets.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-7-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-7-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-7-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295204 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-7-1.jpg\" alt=\"ham-importrange-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-7-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-7-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-7-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">Quy\u1ec1n truy c\u1eadp sau khi \u0111\u00e3 nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m IMPORTRANGE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Sau khi li\u00ean k\u1ebft d\u1eef li\u1ec7u v\u1edbi c\u00e1c file Google Sheets kh\u00e1c c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec3n th\u1ecb l\u1ed7i #REF!. \u0110\u00e2y l\u00e0 l\u1ed7i th\u1ec3 hi\u1ec7n th\u00f4ng b\u00e1o v\u1edbi n\u1ed9i dung \u201cB\u1ea1n c\u1ea7n ph\u1ea3i k\u1ebft n\u1ed1i v\u1edbi c\u00e1c file t\u00ednh kh\u00e1c v\u00e0 cho ph\u00e9p quy\u1ec1n truy c\u1eadp\u201d. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng l\u1ed7i n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m ch\u1ecdn \u201cAllow Access\u201d \u0111\u1ec3 cho ph\u00e9p quy\u1ec1n truy c\u1eadp d\u1eef li\u1ec7u sau khi nh\u1eadp c\u00f4ng th\u1ee9c. N\u1ebfu kh\u00f4ng ph\u1ea7n d\u1eef li\u1ec7u s\u1ebd kh\u00f4ng xu\u1ea5t hi\u1ec7n.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-8-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-8-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-8-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295205 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-8-1.jpg\" alt=\"ham-importrange-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-8-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-8-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-8-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 vi\u1ebft hoa hay vi\u1ebft th\u01b0\u1eddng c\u00fa ph\u00e1p h\u00e0m IMPORTRANGE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi nh\u1eadp c\u1ea5u tr\u00fac h\u00e0m t\u00ednh IMPORTRANGE, b\u1ea1n ho\u00e0n c\u00f3 th\u1ec3 vi\u1ebft ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng t\u00f9y \u00fd. Vi\u1ec7c vi\u1ebft hoa hay vi\u1ebft th\u01b0\u1eddng c\u0169ng s\u1ebd kh\u00f4ng \u1ea3nh h\u01b0\u1edfng qu\u00e1 nhi\u1ec1u \u0111\u1ebfn c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-9-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-9-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-9-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295206 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-9-1.jpg\" alt=\"ham-importrange-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-9-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-9-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-9-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture>\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft h\u1ee3p IMPORTRANGE v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m t\u00ednh IMPORTRANGE c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n k\u00ea\u0301t h\u01a1\u0323p cu\u0300ng v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c co\u0301 s\u0103\u0303n trong Google Sheet bao g\u1ed3m h\u00e0m IF, h\u00e0m INDEX, h\u00e0m QUERY v\u00e0 h\u00e0m MATCH. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch k\u1ebft h\u1ee3p m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m t\u00ednh IMPORTRANGE cu\u0300ng ha\u0300m IF<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c k\u1ebft h\u1ee3p hai h\u00e0m IMPORTRANGE v\u00e0 IF l\u00e0 \u0111\u1ec3 so s\u00e1nh hai gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t trong hai k\u1ebft qu\u1ea3. K\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu bi\u1ec3u th\u1ee9c \u0111\u00fang, k\u1ebft qu\u1ea3 th\u1ee9 hai s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu bi\u1ec3u th\u1ee9c sai. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m t\u00ednh IMPORTRANGE v\u1edbi h\u00e0m IF c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><b><i>=IF(bi\u1ec3u_th\u1ee9c_logic;IMPORTRANGE(spreadsheet_url; chu\u1ed7i_d\u1ea3i_\u00f4);gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 &#8220;K\u1ebft qu\u1ea3 \u0111\u00fang&#8221; n\u1ebfu \u00f4 A1 ch\u1ee9a gi\u00e1 tr\u1ecb &#8220;\u0110\u00fang&#8221;, v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 &#8220;K\u1ebft qu\u1ea3 sai&#8221; n\u1ebfu \u00f4 A1 ch\u1ee9a gi\u00e1 tr\u1ecb kh\u00e1c &#8220;\u0110\u00fang&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-10-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-10-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-10-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295207 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-10-1.jpg\" alt=\"ham-importrange-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-10-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-10-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-10-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m t\u00ednh IMPORTRANGE v\u1edbi h\u00e0m QUERY\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi h\u1ebft h\u1ee3p h\u00e0m <\/span><span style=\"font-weight: 400;\">IMPORTRANGE v\u1edbi h\u00e0m QUERY gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng tra c\u1ee9u, s\u00e0ng l\u1ecdc d\u1eef li\u1ec7u theo b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c khi k\u1ebft h\u1ee3p h\u00e0m t\u00ednh IMPORTRANGE v\u1edbi h\u00e0m QUERY c\u1ee5 th\u1ec3:\u00a0<\/span><\/p>\n<p><b><i>=QUERY(IMPORTRANGE(spreadsheet_url ; chu\u1ed7i_d\u1ea3i_\u00f4); QUERY)<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u1ee7a c\u00e1c y\u1ebfu t\u1ed1 trong \u0111\u00f3 bao g\u1ed3m:\u00a0<\/span><\/p>\n<ul>\n<li data-sourcepos=\"5:1-5:114\">IMPORTRANGE(spreadsheet_url ; chu\u1ed7i_d\u1ea3i_\u00f4):\u00a0l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/li>\n<li data-sourcepos=\"6:1-7:0\">QUERY:\u00a0l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-11-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-11-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-11-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295208 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-11-1.jpg\" alt=\"ham-importrange-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-11-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-11-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-11-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m t\u00ednh IMPORTRANGE cu\u0300ng h\u00e0m INDEX, MATCH\u00a0<\/span><\/h3>\n<p>H\u00e0m IMPORTRANGE gi\u00fap b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c v\u00e0o b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i. H\u00e0m INDEX\/MATCH gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u. Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh tr\u00ean d\u1eef li\u1ec7u \u0111\u00f3 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p><b><i>=INDEX(IMPORTRANGE(&#8216;Spreadsheet url&#8217;;Range string);MATCH(Gia\u0301 tri\u0323 \u0111\u01b0\u01a1\u0323c ti\u0300m ki\u00ea\u0301m;IMPORTRANGE(Spreadsheet url;Ma\u0309ng c\u00e2\u0300n ti\u0300m ki\u00ea\u0301m)))<\/i><\/b><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-12-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-12-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-12-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295209 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-12-1.jpg\" alt=\"ham-importrange-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-12-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-12-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-12-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u1ee7a c\u00e1c y\u1ebfu t\u1ed1 trong \u0111\u00f3 bao g\u1ed3m:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Spreadsheet url: \u0111\u00e2y l\u00e0 y\u1ebfu t\u1ed1 c\u1ee7a \u0111\u01b0\u1eddng link url c\u1ee7a m\u1ed9t file Google Sheet.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range string: \u0111\u00e2y l\u00e0 gia\u0301 tri\u0323 cu\u0309a \u00f4 c\u1ee7a sheet c\u1ea7n \u0111\u01b0\u1ee3c truy v\u1ea5n, theo \u0111u\u00f4i k\u00ea\u0301t thu\u0301c l\u00e0 \u201c!\u201d, \u0111\u00f4\u0300ng th\u01a1\u0300i la\u0300 v\u00f9ng ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gia\u0301 tri\u0323 \u0111\u01b0\u01a1\u0323c ti\u0300m ki\u00ea\u0301m: \u0111\u00e2y l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u01b0\u1ee3c so trong m\u1ea3ng t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ma\u0309ng c\u00e2\u0300n ti\u0300m ki\u00ea\u0301m ti\u0300m ki\u00ea\u0301m: ph\u1ea1m vi v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE v\u1edbi d\u1eef li\u1ec7u qu\u00e1 l\u1edbn\u00a0\u00a0<\/span><\/h2>\n<p data-sourcepos=\"9:1-9:197\">Th\u00f4ng th\u01b0\u1eddng, khi s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u qu\u00e1 l\u1edbn t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, Google Sheets s\u1ebd b\u00e1o l\u1ed7i #ERROR!. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong hai c\u00e1ch sau:<\/p>\n<p data-sourcepos=\"11:1-11:206\"><strong>C\u00e1ch 1:<\/strong> Chia v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n tr\u00edch xu\u1ea5t th\u00e0nh nhi\u1ec1u ph\u1ea1m vi nh\u1ecf h\u01a1n. V\u00ed d\u1ee5, n\u1ebfu v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n tr\u00edch xu\u1ea5t c\u00f3 52 c\u1ed9t.<\/p>\n<p><b><i>=IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws\/edit#gid=0&#8217;; &#8216;Danh sa\u0301ch sinh vi\u00ean \u0110\u1ea1i Tr\u00e0!A2:E52&#8217;)<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 G2, b\u1ea1n s\u1ebd nh\u1eadp c\u1ea5u tr\u00fac sau \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c v\u00f9ng d\u1eef li\u1ec7u n\u1eb1m t\u1eeb c\u1ed9t F3 \u0111\u1ebfn c\u1ed9t H53 c\u00f3 trong file danh s\u00e1ch sinh vi\u00ean.\u00a0<\/span><\/p>\n<p><b><i>=IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws\/edit#gid=0&#8217;; &#8216;L\u1edbp \u0110\u1ea1i Tr\u00e0!F2:H52&#8217;)<\/i><\/b><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-13-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-13-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-13-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295210 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-13-1.jpg\" alt=\"ham-importrange-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-13-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-13-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-13-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch 2: A\u0301p d\u1ee5ng h\u00e0m t\u00ednh ARRAYFORMULA \u0111\u1ec3 c\u00f3 th\u1ec3 chia v\u00f9ng d\u1eef li\u1ec7u ti\u0301nh t\u01b0\u0300 chi\u00ea\u0300u ngang.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp v\u1edbi \u00fd ngh\u0129a s\u1eed d\u1ee5ng h\u00e0m ARRAYFORMULA \u0111\u1ec3 s\u1eafp x\u1ebfp hai h\u00e0ng d\u1eef li\u1ec7u th\u00e0nh m\u1ed9t h\u00e0ng ngang k\u1ebft h\u1ee3p h\u00e0m t\u00ednh <\/span><span style=\"font-weight: 400;\">IMPORTRANGE \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u l\u1ea7n l\u01b0\u1ee3t v\u1edbi d\u1ea3i \u00f4 A1:I7000 v\u00e0 A11:I17 trong file Google Sheets:\u00a0<\/span><\/p>\n<p><b><i>=ARRAYFORMULA({IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1AFBhK9TdCZ9FcDtezaVtlKYmw2Pw6xBQ57NlQwP58Ws\/edit#gid=115033607&#8242;;&#8217;Danh sa\u0301ch sinh vi\u00ean \u0110\u1ea1i Tr\u00e0!A1:I10&#8217;);IMPORTRANGE(&#8216;https:\/\/docs.google.com\/spreadsheets\/d\/1erTGZMXB0xnUu5ODtX8sB5pHJbuoV0LgKvmDvbqOG6k\/edit#gid=115033607&#8242;;&#8217;Danh sa\u0301ch sinh vi\u00ean \u0110\u1ea1i Tr\u00e0!A11:I17&#8217;)})<\/i><\/b><\/p>\n<h2><span style=\"font-weight: 400;\">4 l\u00f4\u0303i th\u01b0\u1eddng g\u1eb7p khi a\u0301p du\u0323ng ha\u0300m ti\u0301nh IMPORTRANGE trong Google Sheets<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE trong file Google Sheets m\u00e0 b\u1ea1n n\u00ean bi\u1ebft:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i th\u00ea\u0309 hi\u00ea\u0323n #N\/A: \u0111\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb hay d\u1eef li\u1ec7u c\u1ea7n t\u00ecm trong b\u1ea3ng t\u00ednh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i #VALUE: \u0111\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ea5y kh\u00f4ng kh\u1edbp v\u1edbi c\u00f4ng th\u1ee9c h\u00e0m \u0111\u01b0\u1ee3c nh\u1eadp.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i #NAME: \u0111\u00e2y l\u00e0 l\u1ed7i x\u1ea3y ra khi nh\u1eadp sai t\u00ean h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i #REF: \u0111\u00e2y l\u00e0 l\u1ed7i xu\u1ea5t hi\u1ec7n khi kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y \u0111\u01b0\u1ee3c c\u00e1c d\u1ea3i \u00f4 ho\u1eb7c trang t\u00ednh d\u00e0nh cho ph\u1ea7n d\u1ea3i \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp trong c\u00f4ng th\u1ee9c.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-14-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-14-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-importrange-14-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-295213 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-14-3.jpg\" alt=\"ham-importrange-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-14-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-14-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange-14-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>T\u1ed5ng k\u1ebft<\/h2>\n<p>Th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean th\u00ec b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm r\u00f5 \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a, c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m IMPORTRANGE nh\u01b0 th\u1ebf n\u00e0o. \u0110\u1ed3ng th\u1eddi, b\u1ea1n c\u00f2n bi\u1ebft \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh IMPORTRANGE. Hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p nh\u1eefng th\u00f4ng tin b\u1ed5 \u00edch v\u1ec1 h\u00e0m t\u00ednh IMPORTRANGE \u0111\u1ec3 b\u1ea1n \u0111\u1ec5 d\u00e0ng c\u00f3 th\u1ec3 thao t\u00e1c th\u1ef1c hi\u1ec7n.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/hlookup\/\"><strong>H\u00e0m HLOOKUP trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng d\u1ec5 hi\u1ec3u<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\"><strong>C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/strong><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n chuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 thu th\u1eadp d\u1eef li\u1ec7u ho\u1eb7c t\u00ednh to\u00e1n th\u00ec ho\u00e0n to\u00e0n kh\u00e1 quen thu\u1ed9c v\u1edbi c\u00e1c h\u00e0m c\u1ee7a b\u1ea3ng t\u00ednh n\u00e0y. M\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi l\u1ef1a ch\u1ecdn s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 h\u00e0m IMPORTRANGE. Tuy nhi\u00ean, c\u00e1ch d\u00f9ng h\u00e0m t\u00ednh IMPORTRANGE trong Google Sheets [&hellip;]<\/p>\n","protected":false},"author":91,"featured_media":292084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-291816","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets<\/title>\n<meta name=\"description\" content=\"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-12T03:33:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\"},\"author\":{\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef\"},\"headline\":\"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets\",\"datePublished\":\"2023-12-12T03:33:38+00:00\",\"dateModified\":\"2023-12-12T03:33:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\"},\"wordCount\":3208,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\",\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg\",\"datePublished\":\"2023-12-12T03:33:38+00:00\",\"dateModified\":\"2023-12-12T03:33:38+00:00\",\"description\":\"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-importrange\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef\",\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g\",\"caption\":\"Tr\u1ea7n Tuy\u1ebft Nhung\"},\"description\":\"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets","description":"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.","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:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets","og_description":"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-12-12T03:33:38+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg","type":"image\/jpeg"}],"author":"Tr\u1ea7n Tuy\u1ebft Nhung","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Tr\u1ea7n Tuy\u1ebft Nhung","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/"},"author":{"name":"Tr\u1ea7n Tuy\u1ebft Nhung","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef"},"headline":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets","datePublished":"2023-12-12T03:33:38+00:00","dateModified":"2023-12-12T03:33:38+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/"},"wordCount":3208,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/","name":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg","datePublished":"2023-12-12T03:33:38+00:00","dateModified":"2023-12-12T03:33:38+00:00","description":"H\u00e0m IMPORTRANGE l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Google Sheets v\u1edbi m\u1ee5c \u0111\u00edch tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-importrange.jpg","width":1200,"height":628,"caption":"ham-importrange"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a08711755cabea83499b8c2e106349ef","name":"Tr\u1ea7n Tuy\u1ebft Nhung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9fa3316dff70d9e42f6d22216d898acd?s=96&d=mm&r=g","caption":"Tr\u1ea7n Tuy\u1ebft Nhung"},"description":"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/291816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=291816"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/291816\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/292084"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=291816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=291816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=291816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}