<\/span><\/h3>\n\n\n\nGi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai b\u1ea3ng t\u00ednh Google Sheet: m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a danh s\u00e1ch s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh. B\u1ea1n mu\u1ed1n l\u1ea5y th\u00f4ng tin h\u1ecdc sinh t\u1eeb b\u1ea3ng t\u00ednh th\u1ee9 nh\u1ea5t sang b\u1ea3ng t\u00ednh th\u1ee9 hai \u0111\u1ec3 ti\u1ec7n theo d\u00f5i.<\/p>\n\n\n\n
C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n\n\n\n\n- M\u1edf b\u1ea3ng t\u00ednh Google Sheet ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n sao ch\u00e9p.<\/strong> Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea3ng t\u00ednh ngu\u1ed3n c\u00f3 t\u00ean l\u00e0 “S\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh”.<\/li>\n<\/ul>\n\n\n\n
![\"M\u1edf](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-2.png\" "\\"\\"")
M\u1edf b\u1ea3ng t\u00ednh g\u1ed1c m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u ra<\/figcaption><\/figure>\n\n\n\n\n- M\u1edf b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o.<\/strong> Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea3ng t\u00ednh \u0111\u00edch c\u00f3 t\u00ean l\u00e0 “S\u1ed1 h\u1ecdc sinh”.<\/li>\n<\/ul>\n\n\n\n
![\"M\u1edf](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-4.png\" "\\"\\"")
M\u1edf b\u1ea3ng t\u00ednh th\u1ee9 2 (b\u1ea3ng t\u00ednh \u0111\u00edch) c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o<\/figcaption><\/figure>\n\n\n\n\n- Sao ch\u00e9p URL c\u1ee7a b\u1ea3ng t\u00ednh ngu\u1ed3n<\/strong> \u2014 h\u00e3y sao ch\u00e9p to\u00e0n b\u1ed9 URL ngo\u1ea1i tr\u1eeb ph\u1ea7n “edit#gid=0” t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n \u1edf cu\u1ed1i.<\/li>\n<\/ul>\n\n\n\n
![\"Sao](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-3-1.png\" "\\"\\"")
Sao ch\u00e9p \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft c\u1ee7a trang t\u00ednh g\u1ed1c ngo\u1ea1i tr\u1eeb ph\u1ea7n “edit#gid=0”<\/figcaption><\/figure>\n\n\n\n\n- Nh\u1ea5p v\u00e0o \u00f4 \u0111\u00edch<\/strong>, t\u1ee9c l\u00e0 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u00f3. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u00f3 l\u00e0 \u00f4 A2 c\u1ee7a b\u1ea3ng t\u00ednh “S\u1ed1 h\u1ecdc sinh”.<\/li>\n<\/ul>\n\n\n\n
![\"Nh\u1ea5p](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-5.png\" "\\"\\"")
Nh\u1ea5p v\u00e0o \u00f4 trong b\u1ea3ng t\u00ednh \u0111\u00edch m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o v\u00e0 b\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng h\u00e0m <\/figcaption><\/figure>\n\n\n\n\n- Nh\u1eadp c\u00f4ng th\u1ee9c =IMPORTRANGE<\/strong> ngay sau \u0111\u00f3 l\u00e0 (spreadsheet_url, range_string). V\u00ed d\u1ee5: =IMPORTRANGE(“https:\/\/docs.google.com\/spreadsheets\/d\/1vvp0Cvtd3tF9AfXwUKjuO3HDvfB1sx1-7ZNOdTJ2gw0”, “Sheet1!A2:C4”)<\/li>\n\n\n\n
- N\u1ebfu b\u1ea3ng t\u00ednh ngu\u1ed3n c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u trang t\u00ednh, b\u1ea1n c\u1ea7n ph\u1ea3i ch\u1ec9 \u0111\u1ecbnh r\u00f5 r\u00e0ng trang t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u <\/strong>(V\u00ed d\u1ee5 Sheet1, Sheet2, …).<\/strong> N\u1ebfu kh\u00f4ng, Google Sheets s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh \u0111\u1ea7u ti\u00ean.<\/li>\n\n\n\n
- Nh\u1ea5n Enter.<\/strong><\/li>\n\n\n\n
- L\u1ea7n \u0111\u1ea7u ti\u00ean b\u1ea1n k\u1ebft n\u1ed1i d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd g\u1eb7p th\u00f4ng b\u00e1o l\u1ed7i #REF!.<\/strong> \u0110\u00e2y l\u00e0 \u0111i\u1ec1u b\u00ecnh th\u01b0\u1eddng. H\u00e3y nh\u1ea5p v\u00e0o “Cho ph\u00e9p truy c\u1eadp – Allow access” \u0111\u1ec3 c\u1ea5p quy\u1ec1n cho b\u1ea3ng t\u00ednh \u0111\u00edch truy c\u1eadp v\u00e0o d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng t\u00ednh ngu\u1ed3n.<\/li>\n<\/ul>\n\n\n\n
![\"Khi](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-6.png\" "\\"\\"")
Khi hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i REF! b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Allow access \u0111\u1ec3 c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c<\/figcaption><\/figure>\n\n\n\n\n- V\u1eady l\u00e0 xong!<\/strong> Google Sheets s\u1ebd nh\u1eadp ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh v\u00e0o b\u1ea3ng t\u00ednh \u0111\u00edch c\u1ee7a b\u1ea1n. M\u1ecdi c\u1eadp nh\u1eadt \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean b\u1ea3ng t\u00ednh ngu\u1ed3n c\u0169ng s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt tr\u00ean b\u1ea3ng t\u00ednh \u0111\u00edch.<\/li>\n<\/ul>\n\n\n\n
![\"B\u1ea3ng](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-7.png\" "\\"\\"")
B\u1ea3ng t\u00ednh \u0111\u00edch s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 lu\u00f4n \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt thay \u0111\u1ed5i d\u1ef1a theo b\u1ea3ng t\u00ednh g\u1ed1c<\/figcaption><\/figure>\n\n\n\n<\/span>L\u1ea5y tr\u1ef1c ti\u1ebfp d\u1eef li\u1ec7u n\u1eb1m trong file<\/strong><\/span><\/h3>\n\n\n\nNgo\u00e0i vi\u1ec7c l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t file Google Sheet kh\u00e1c, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t sheet kh\u00e1c trong c\u00f9ng m\u1ed9t file. C\u00e1ch th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, ch\u1ec9 kh\u00e1c \u1edf b\u01b0\u1edbc nh\u1eadp chu\u1ed7i v\u00f9ng d\u1eef li\u1ec7u. B\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh r\u00f5 t\u00ean sheet m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n\n\n\n
V\u00ed d\u1ee5, \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet1 sang Sheet2 trong c\u00f9ng file h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n
\n- M\u1edf sheet b\u1ea1n mu\u1ed1n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o<\/li>\n<\/ul>\n\n\n\n
![\"M\u1edf](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-8.png\" "\\"\\"")
M\u1edf trang m\u1edbi trong c\u00f9ng m\u1ed9t file b\u1ea3ng t\u00ednh<\/figcaption><\/figure>\n\n\n\n\n- Nh\u1eadp h\u00e0m =IMPORTRANGE(spreadsheet_url, range_string). Trong \u0111\u00f3 ph\u1ea7n “spreadsheet_url” \u0111\u01b0\u1ee3c nh\u1eadp ph\u1ea7n url t\u1eeb ch\u00ednh file b\u1ea1n \u0111ang m\u1edf. V\u00e0 ph\u1ea7n chu\u1ed7i v\u00f9ng d\u1eef li\u1ec7u “range_string” s\u1ebd l\u00e0 t\u00ean trang v\u00e0 v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ea5y ra t\u1eeb ch\u00ednh trang \u0111\u00f3.<\/li>\n<\/ul>\n\n\n\n
![\"Nh\u1eadp](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-9.png\" "\\"\\"")
Nh\u1eadp h\u00e0m IMPORTRANGE v\u1edbi v\u00f9ng d\u1eef li\u1ec7u l\u00fac n\u00e0y \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb sheet kh\u00e1c trong c\u00f9ng 1 file<\/figcaption><\/figure>\n\n\n\n![\"Sau](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-16.png\" "\\"\\"")
Sau khi nh\u1ea5n Enter d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng tinh g\u1ed1c s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ea1i \u0111\u00e2y v\u00e0 lu\u00f4n \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt thay \u0111\u1ed5i<\/figcaption><\/figure>\n\n\n\n<\/span>C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IMPORTRANGE v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c<\/strong><\/span><\/h2>\n\n\n\n\u0110\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p n\u00f3 v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Google Sheet. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5:<\/p>\n\n\n\n
<\/span>K\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF<\/strong><\/span><\/h3>\n\n\n\nK\u1ebft h\u1ee3p IMPORTRANGE v\u1edbi h\u00e0m IF (hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m IMPORTRANGE c\u00f3 \u0111i\u1ec1u ki\u1ec7n) cho ph\u00e9p b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5, b\u1ea1n ch\u1ec9 mu\u1ed1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh g\u1ed1c n\u1ebfu m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n.<\/p>\n\n\n\n
Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e3y l\u1ecdc ra c\u00e1c h\u1ecdc sinh c\u00f3 \u0111\u1ed9 tu\u1ed5i l\u1edbn h\u01a1n 14, l\u00fac n\u00e0y d\u1eef li\u1ec7u ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb b\u1ea3ng t\u00ednh g\u1ed1c n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 B2 l\u1edbn h\u01a1n 14.<\/p>\n\n\n\n
=IF(B2>14, IMPORTRANGE(“https:\/\/docs.google.com\/spreadsheets\/d\/1vvp0Cvtd3tF9AfXwUKjuO3HDvfB1sx1-7ZNOdTJ2gw0\/”, “Sheet1!A1:C4”), “”)<\/p>\n\n\n\n![\"K\u1ebft](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-10-1.png\" "\\"\\"")
K\u1ebft h\u1ee3p gi\u1eefa h\u00e0m IF v\u00e0 h\u00e0m IMPORTRANGE \u0111\u1ec3 c\u00f3 th\u00eam \u0111i\u1ec1u ki\u1ec7n cho b\u1ea3ng t\u00ednh g\u1ed1c tr\u01b0\u1edbc khi \u0111\u01b0\u1ee3c nh\u1eadp sang b\u1ea3ng t\u00ednh \u0111\u00edch<\/figcaption><\/figure>\n\n\n\nK\u1ebft qu\u1ea3 hi\u1ec7n ra s\u1ebd l\u00e0 th\u00f4ng tin c\u00e1c h\u1ecdc sinh c\u00f3 \u0111\u1ed9 tu\u1ed5i l\u1edbn h\u01a1n 14<\/p>\n\n\n\n
<\/span>K\u1ebft h\u1ee3p c\u00f9ng h\u00e0m Query<\/strong><\/span><\/h3>\n\n\n\nH\u00e0m QUERY cho ph\u00e9p b\u1ea1n l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb b\u1ea3ng t\u00ednh g\u1ed1c.<\/p>\n\n\n\n
Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, h\u00e3y l\u1ecdc ra c\u00e1c h\u1ecdc sinh c\u00f3 \u0111\u1ed9 tu\u1ed5i l\u1edbn h\u01a1n 15, l\u00fac n\u00e0y d\u1eef li\u1ec7u ch\u1ec9 \u0111\u01b0\u1ee3c l\u1ea5y \u1edf c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 2 l\u1edbn h\u01a1n 15.<\/p>\n\n\n\n
=QUERY(IMPORTRANGE(“https:\/\/docs.google.com\/spreadsheets\/d\/1vvp0Cvtd3tF9AfXwUKjuO3HDvfB1sx1-7ZNOdTJ2gw0\/”, “Sheet1!A1:C6”), “select Col1, Col2, Col3 where Col2 > 15”)<\/p>\n\n\n\n![\"C\u00e2u](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-11.png\" "\\"\\"")
C\u00e2u l\u1ec7nh n\u00e0y s\u1ebd nh\u1eadp d\u1eef li\u1ec7u t\u1eeb c\u1ed9t A \u0111\u1ebfn C trong Sheet1, sau \u0111\u00f3 l\u1ecdc ra c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb \u1edf c\u1ed9t B l\u1edbn h\u01a1n 15 v\u00e0 hi\u1ec3n th\u1ecb c\u1ed9t 1,2,3<\/figcaption><\/figure>\n\n\n\n![\"Sau](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-12.png\" "\\"\\"")
Sau khi l\u1ecdc xong, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec7n th\u1ecb c\u00e1c h\u00e0ng th\u1ecfa v\u1edbi \u0111i\u1ec1u ki\u1ec7n tr\u00ean<\/figcaption><\/figure>\n\n\n\nK\u1ebft qu\u1ea3 s\u1ebd l\u00e0 danh s\u00e1ch c\u00e1c h\u1ecdc sinh c\u00f3 \u0111\u1ed9 tu\u1ed5i l\u1edbn h\u01a1n 15<\/p>\n\n\n\n
<\/span>K\u1ebft h\u1ee3p c\u00f9ng h\u00e0m Index, Match<\/strong><\/span><\/h3>\n\n\n\nS\u1ef1 k\u1ebft h\u1ee3p n\u00e0y cho ph\u00e9p b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 t\u1eeb d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp.<\/p>\n\n\n\n
Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, h\u00e3y t\u00ecm t\u00ean c\u1ee7a sinh vi\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 s\u1ed1 sinh vi\u00ean t\u1ea1i \u00f4 D2. Khi \u0111\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o s\u1ebd l\u1ea1i t\u00ean c\u1ee7a sinh vi\u00ean trong c\u1ed9t B t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 s\u1ed1 sinh vi\u00ean \u0111\u01b0\u1ee3c c\u00f3 t\u1eeb c\u1ed9t A<\/p>\n\n\n\n
=INDEX(IMPORTRANGE(“https:\/\/docs.google.com\/spreadsheets\/d\/1GHan8M_GMNLMHZRypCxCMAb9-Pf6aZiw4A-MRg2RZVE\/”;”DS GHI NH\u1eacN \u0110RL!A:A”);MATCH(D2;IMPORTRANGE(“https:\/\/docs.google.com\/spreadsheets\/d\/1GHan8M_GMNLMHZRypCxCMAb9-Pf6aZiw4A-MRg2RZVE\/”;”DS GHI NH\u1eacN \u0110RL!B:B”);0))<\/p>\n\n\n\n
Trong \u0111\u00f3:<\/p>\n\n\n\n
– S\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE v\u00e0 INDEX \u0111\u1ec3 l\u1ea5y th\u00f4ng tin c\u1ed9t T\u00ean ch\u00ednh x\u00e1c c\u1ee7a m\u1ed9t h\u1ecdc sinh trong file DS GHI NH\u1eacN \u0110RL \u0111\u1ec3 v\u00e0o.<\/p>\n\n\n\n
– H\u00e0m MATCH v\u00e0 IMPORTRANGE s\u1ebd x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a T\u00ean h\u1ecdc sinh \u1edf \u00f4 D2 trong d\u1ea3i \u00f4 B:B c\u1ee7a file DS GHI NH\u1eacN \u0110RL.<\/p>\n\n\n\n
C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 D2 trong c\u1ed9t B c\u1ee7a b\u1ea3ng t\u00ednh g\u1ed1c v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t A.<\/p>\n\n\n\n![\"T\u00ecm](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-13.png\" "\\"\\"")
T\u00ecm t\u00ean c\u1ee7a sinh vi\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 s\u1ed1 sinh vi\u00ean t\u1ea1i \u00f4 D2<\/figcaption><\/figure>\n\n\n\n![\"C\u00e2u](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-14.png\" "\\"\\"")
C\u00e2u l\u1ec7nh n\u00e0y s\u1ebd t\u00ecm ki\u1ebfm m\u00e3 s\u1ed1 sinh vi\u00ean 2021009052 trong c\u1ed9t B c\u1ee7a Sheet1, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t A.<\/figcaption><\/figure>\n\n\n\n![\"Sau](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/cach-lay-du-lieu-google-sheet-voi-importrange-15.png\" "\\"\\"")
Sau khi t\u00ecm ki\u1ebfm t\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 s\u1ed1 sinh vi\u00ean \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o, t\u00ean s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ea1i \u00f4 nh\u1eadp h\u00e0m<\/figcaption><\/figure>\n\n\n\n<\/span>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE<\/strong><\/span><\/h2>\n\n\n\n\n- Quy\u1ec1n truy c\u1eadp:<\/strong> \u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o b\u1ea3ng t\u00ednh g\u1ed1c. N\u1ebfu kh\u00f4ng, h\u00e0m IMPORTRANGE s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/li>\n\n\n\n
- Hi\u1ec7u su\u1ea5t:<\/strong> Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi b\u1ea1n nh\u1eadp m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u.<\/li>\n\n\n\n
- C\u1eadp nh\u1eadt d\u1eef li\u1ec7u:<\/strong> D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng h\u00e0m IMPORTRANGE s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt khi c\u00f3 thay \u0111\u1ed5i tr\u00ean b\u1ea3ng t\u00ednh g\u1ed1c. Tuy nhi\u00ean, vi\u1ec7c c\u1eadp nh\u1eadt n\u00e0y c\u00f3 th\u1ec3 m\u1ea5t m\u1ed9t ch\u00fat th\u1eddi gian.<\/li>\n<\/ul>\n\n\n\n
<\/span>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m IMPORTRANGE<\/strong><\/span><\/h2>\n\n\n\n<\/span>L\u1ed7i #N\/A<\/strong><\/span><\/h3>\n\n\n\nL\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi h\u00e0m IMPORTRANGE kh\u00f4ng t\u00ecm th\u1ea5y b\u1ea3ng t\u00ednh g\u1ed1c ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. H\u00e3y ki\u1ec3m tra l\u1ea1i spreadsheet_url v\u00e0 range_string \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u00fang ch\u00ednh x\u00e1c.<\/p>\n\n\n\n
<\/span>L\u1ed7i #VALUE<\/strong><\/span><\/h3>\n\n\n\nL\u1ed7i n\u00e0y th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi range_string kh\u00f4ng h\u1ee3p l\u1ec7. H\u00e3y ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p v\u00e0 \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u00fang t\u00ean sheet v\u00e0 v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n\n\n\n
<\/span>L\u1ed7i #NAME<\/strong><\/span><\/h3>\n\n\n\nL\u1ed7i n\u00e0y cho th\u1ea5y c\u00f3 l\u1ed7i ch\u00ednh t\u1ea3 trong t\u00ean h\u00e0m IMPORTRANGE. H\u00e3y ki\u1ec3m tra l\u1ea1i v\u00e0 \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 g\u00f5 \u0111\u00fang t\u00ean h\u00e0m.<\/p>\n\n\n\n
<\/span>L\u1ed7i #REF<\/strong><\/span><\/h3>\n\n\n\nL\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n ch\u01b0a c\u1ea5p quy\u1ec1n truy c\u1eadp cho b\u1ea3ng t\u00ednh \u0111\u00edch. H\u00e3y nh\u1ea5p v\u00e0o “Cho ph\u00e9p truy c\u1eadp – Allow access” khi \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u.<\/p>\n\n\n\n
<\/span>C\u00e2u h\u1ecfi li\u00ean quan \u0111\u1ebfn h\u00e0m IMPORTRANGE<\/strong><\/span><\/h2>\n\n\n\n<\/span>S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa IMPORTRANGE v\u00e0 IMPORTDATA l\u00e0 g\u00ec?<\/strong><\/span><\/h3>\n\n\n\n\n- IMPORTRANGE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh Google Sheet.<\/li>\n\n\n\n
- IMPORTDATA \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c nhau nh\u01b0 CSV, HTML, TSV, v\u00e0 XML.<\/li>\n<\/ul>\n\n\n\n
<\/span>L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng IMPORTRANGE trong Excel?<\/strong><\/span><\/h3>\n\n\n\nIMPORTRANGE l\u00e0 h\u00e0m ri\u00eang c\u1ee7a Google Sheet, kh\u00f4ng c\u00f3 s\u1eb5n trong Excel. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c \u0111\u1ec3 li\u00ean k\u1ebft d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh Excel, ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng “Paste Link” ho\u1eb7c “Workbook Links”.<\/p>\n\n\n\n
<\/span>H\u00e0m IMPORTRANGE c\u00f3 gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp kh\u00f4ng?<\/strong> <\/span><\/h3>\n\n\n\nV\u1ec1 m\u1eb7t l\u00fd thuy\u1ebft, kh\u00f4ng c\u00f3 gi\u1edbi h\u1ea1n c\u1ee5 th\u1ec3. Tuy nhi\u00ean, vi\u1ec7c nh\u1eadp m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n
Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 h\u00e0m IMPORTRANGE v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u Google Sheet m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p IMPORTRANGE v\u1edbi c\u00e1c h\u00e0m kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng nh\u1eefng b\u1ea3ng t\u00ednh th\u00f4ng minh, t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 ph\u1ee5c v\u1ee5 t\u1ed1t cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n","protected":false},"excerpt":{"rendered":"
Trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y, ch\u00fang ta lu\u00f4n c\u1ea7n ph\u1ea3i x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean Google Sheet, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi b\u1ea1n ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u b\u1ea3ng t\u00ednh kh\u00e1c nhau. Vi\u1ec7c sao ch\u00e9p th\u1ee7 c\u00f4ng d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh n\u00e0y kh\u00f4ng ch\u1ec9 t\u1ed1n th\u1eddi gian m\u00e0 c\u00f2n ti\u1ec1m \u1ea9n nhi\u1ec1u r\u1ee7i ro […]<\/p>\n","protected":false},"author":19,"featured_media":101978,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74,1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101945"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=101945"}],"version-history":[{"count":5,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101945\/revisions"}],"predecessor-version":[{"id":102180,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/101945\/revisions\/102180"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/101978"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=101945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=101945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=101945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}