{"id":289094,"date":"2023-11-27T19:50:39","date_gmt":"2023-11-27T12:50:39","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=289094"},"modified":"2023-11-27T19:50:39","modified_gmt":"2023-11-27T12:50:39","slug":"ref","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ref\/","title":{"rendered":"C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"

N\u1ebfu b\u1ea1n \u0111ang g\u1eb7p l\u1ed7i <\/span>#REF!<\/b> trong Excel m\u00e0 kh\u00f4ng bi\u1ebft c\u00e1ch gi\u1ea3i quy\u1ebft. V\u1eady th\u00ec h\u00e3y \u0111\u1ecdc nhanh b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile. Ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1c nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y nh\u00e9. \u0110\u1eb7c bi\u1ec7t, ch\u00fang t\u00f4i c\u00f2n \u0111\u00ednh k\u00e8m th\u00eam v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ec3 b\u1ea1n d\u1ec5 h\u00ecnh dung, c\u0169ng nh\u01b0 \u00e1p d\u1ee5ng thao t\u00e1c d\u1ec5 d\u00e0ng h\u01a1n.<\/span><\/p>\n

L\u1ed7i #REF! trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n

\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng th\u00f4ng b\u00e1o l\u1ed7i ph\u1ed5 bi\u1ebfn, th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi m\u1ed9t \u00f4 ch\u1ee9a tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ed1i v\u1edbi m\u1ed9t ph\u1ea1m vi ho\u1eb7c \u00f4 \u0111\u00e3 n\u00e0o \u0111\u00f3. Bi\u1ec3u hi\u1ec7n c\u1ee7a l\u1ed7i \u201cReference\u201d l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 trong c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh c\u1ee7a Excel. H\u01a1n n\u1eefa, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng bi\u1ebft c\u00e1ch s\u1eeda l\u1ed7i n\u00e0y th\u00ec s\u1ebd t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u0169ng nh\u01b0 c\u00f4ng s\u1ee9c.<\/span><\/p>\n

\"ref-1\"<\/picture><\/p>\n

Th\u00f4ng th\u01b0\u1eddng, l\u1ed7i <\/span>#REF!<\/b> s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf r\u1ea5t nhi\u1ec1u h\u00e0m t\u00ednh trong Excel. Ch\u1eb3ng h\u1ea1n nh\u01b0 AVERAGE, SUM, VLOOKUP, SUMPRODUCT, INDEX hay IFERROR. B\u1edfi v\u00ec c\u00e1c h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n d\u1ef1a tr\u00ean tham chi\u1ebfu th\u00f4ng tin c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c trong b\u1ea3ng t\u00ednh. Do \u0111\u00f3, n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 v\u1ea5n \u0111\u1ec1 th\u00ec ngay l\u1eadp t\u1ee9c b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i.<\/span><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3, l\u1ed7i tham chi\u1ebfu xu\u1ea5t hi\u1ec7n \u1edf r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau. N\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng \u201cb\u1eaft \u0111\u00fang b\u1ec7nh\u201d th\u00ec b\u1ea1n r\u1ea5t kh\u00f3 \u201cch\u1eefa b\u1ec7nh\u201d cho t\u1ec7p Excel c\u1ee7a m\u00ecnh. \u0110\u1eb7c bi\u1ec7t, n\u1ebfu b\u1ea1n \u0111ang ph\u1ea3i x\u1eed l\u00fd m\u1ed9t kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u th\u00ec l\u1ed7i tham chi\u1ebfu s\u1ebd c\u00e0ng tr\u1edf n\u00ean phi\u1ec1n ph\u1ee9c. Ch\u00ednh v\u00ec v\u1eady, b\u1ea1n \u0111\u1ecdc kh\u00f4ng n\u00ean b\u1ecf qua c\u00e1c n\u1ed9i dung quan tr\u1ecdng ngay sau \u0111\u00e2y.<\/span><\/p>\n

Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #REF! ch\u00ednh x\u00e1c<\/b><\/h2>\n

C\u00f3 th\u1ec3 n\u00f3i, nguy\u00ean nh\u00e2n ch\u00ednh c\u1ee7a l\u1ed7i tham chi\u1ebfu l\u00e0 bao g\u1ed3m vi\u1ec7c b\u1ecb tr\u1ed1ng th\u00f4ng tin ho\u1eb7c s\u1ef1 thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a d\u1eef li\u1ec7u m\u00e0 c\u00e1c c\u00f4ng th\u1ee9c \u0111ang ph\u1ee5 thu\u1ed9c. Tuy nhi\u00ean, \u0111\u1ec3 gi\u00fap b\u1ea1n \u0111\u1ecdc c\u00f3 h\u01b0\u1edbng gi\u1ea3i quy\u1ebft c\u1ee5 th\u1ec3 nh\u1ea5t. Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 ph\u00e2n t\u00e1ch t\u1eebng nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i tham chi\u1ebfu c\u1ed1 \u0111\u1ecbnh v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda, \u0111\u1ec3 t\u1eeb \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 v\u1ea5n \u0111\u1ec1 nh\u00e9.<\/span><\/p>\n

L\u1ed7i v\u00ec d\u1eef li\u1ec7u tham chi\u1ebfu b\u1ecb x\u00f3a ho\u1eb7c b\u1ecb ghi \u0111\u00e8<\/b><\/h3>\n

V\u1edbi l\u1ed7i \u0111\u1ea7u ti\u00ean n\u00e0y \u0111\u01b0\u1ee3c xem l\u00e0 v\u1ea5n \u0111\u1ec1 chung m\u00e0 r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng Excel \u0111\u00e3 v\u00e0 \u0111ang g\u1eb7p ph\u1ea3i. Ch\u00ednh \u0111i\u1ec1u n\u00e0y \u0111\u00e3 g\u00e2y ra kh\u00f3 kh\u0103n cho m\u1ecdi ng\u01b0\u1eddi trong vi\u1ec7c hi\u1ec3u, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, c\u0169ng nh\u01b0 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/span><\/p>\n

Nguy\u00ean nh\u00e2n<\/b><\/h4>\n

Nguy\u00ean nh\u00e2n c\u1ee7a v\u1ea5n \u0111\u1ec1 n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n c\u1ed1 g\u1eafng th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 c\u1eaft, ch\u00e9p, d\u00e1n, ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng c\u1eadp nh\u1eadt c\u00e1c li\u00ean k\u1ebft tham chi\u1ebfu t\u01b0\u01a1ng \u1ee9ng. T\u1eeb \u0111\u00f3, d\u1eabn \u0111\u1ebfn c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c n\u1eefa v\u00e0 xu\u1ea5t hi\u1ec7n l\u1ed7i tham chi\u1ebfu ngay tr\u00ean \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n

Nh\u1eb1m gi\u00fap b\u1ea1n h\u00ecnh dung chi ti\u1ebft h\u01a1n, ch\u00fang t\u00f4i s\u1ebd cung c\u1ea5p th\u00eam cho b\u1ea1n m\u1ed9t v\u00e0i h\u00ecnh \u1ea3nh v\u1ec1 l\u1ed7i n\u00e0y nh\u00e9. C\u1ee5 th\u1ec3, ch\u00fang ta c\u00f3 b\u1ea3ng t\u00ednh ch\u1ee9a \u0111i\u1ec3m c\u00e1c m\u00f4n h\u1ecdc v\u00e0 t\u1ed5ng \u0111i\u1ec3m r\u1ea5t l\u00e0 ho\u00e0n thi\u1ec7n nh\u01b0 h\u00ecnh m\u00f4 t\u1ea3.<\/span><\/p>\n

\"ref-2\"<\/picture><\/p>\n

Tuy nhi\u00ean, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh x\u00f3a m\u1ea5t c\u1ed9t D ch\u1ee9a \u0111i\u1ec3m m\u00f4n l\u00fd \u0111i th\u00ec t\u1ee9c ngh\u0129a c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng hi\u1ec3u \u0111\u01b0\u1ee3c thao t\u00e1c. V\u00ec l\u1ebd \u0111\u00f3 m\u00e0 ngay t\u1ea1i c\u1ed9t t\u1ed5ng \u0111i\u1ec3m n\u00f3 l\u1ea1i xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o <\/span>#REF!<\/b><\/p>\n

\"ref-3\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h4>\n

\u0110\u1ed1i v\u1edbi nguy\u00ean nh\u00e2n th\u1ee9 nh\u1ea5t, c\u00e1ch s\u1eeda l\u1ed7i nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t l\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra v\u00e0 c\u1eadp nh\u1eadt l\u1ea1i c\u00e1c li\u00ean k\u1ebft tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang \u0111ang ch\u1ec9 \u0111\u1ecbnh v\u00e0o \u0111\u00fang m\u1ed9t v\u00f9ng c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3. Nh\u01b0 v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta m\u1ea5t \u0111i c\u1ed9t D th\u00ec b\u1ea1n ph\u1ea3i b\u1ed5 sung l\u1ea1i d\u1eef li\u1ec7u ch\u00ednh x\u00e1c cho c\u1ed9t th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 kh\u1eafc hi\u1ec3u \u0111\u01b0\u1ee3c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed5ng \u0111i\u1ec3m d\u1ef1a v\u00e0o h\u00e0m SUM ch\u00ednh x\u00e1c nh\u1ea5t.<\/span><\/p>\n

\"ref-4\"<\/picture><\/p>\n

L\u1ed7i v\u00ec c\u00e1c \u00f4 tham chi\u1ebfu kh\u00f4ng c\u00f3 s\u1eb5n ho\u1eb7c v\u01b0\u1ee3t qu\u00e1 v\u00f9ng d\u1eef li\u1ec7u<\/b><\/h3>\n

M\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn ti\u1ebfp theo c\u1ee7a l\u1ed7i <\/span>#REF!<\/b>, \u0111\u00f3 ch\u00ednh l\u00e0 ph\u1ea1m v\u1ee5 d\u1eef li\u1ec7u b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn \u0111\u00e3 v\u01b0\u1ee3t ngo\u00e0i \u201ct\u1ea7m ki\u1ec3m so\u00e1t\u201d. V\u1eady c\u1ee5 th\u1ec3 \u0111\u00e2y l\u00e0 l\u1ed7i nh\u01b0 th\u1ebf n\u00e0o v\u00e0 gi\u1ea3i ph\u00e1p ra sau. Ho\u00e0ng H\u00e0 Mobile m\u1eddi b\u1ea1n \u0111\u1ecdc ti\u1ebfp \u0111o\u1ea1n n\u1ed9i dung gi\u1ea3i th\u00edch ngay sau \u0111\u00e2y nh\u00e9.<\/span><\/p>\n

Nguy\u00ean nh\u00e2n<\/b><\/h4>\n

M\u1ed9t khi ng\u01b0\u1eddi d\u00f9ng thao t\u00e1c nh\u1eadp l\u1ec7nh th\u00ec c\u00f3 kh\u1ea3 n\u0103ng v\u00f9ng ch\u1ecdn c\u1ee7a b\u1ea1n \u0111\u00e3 qu\u00e1 gi\u1edbi h\u1ea1n cho ph\u00e9p. Do \u0111\u00f3, Excel kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft v\u00e0 vi\u1ec7c hi\u1ec3n th\u1ecb l\u1ed7i tham chi\u1ebfu trong \u00f4 l\u00e0 \u0111i\u1ec1u hi\u1ec3n nhi\u00ean.\u00a0<\/span><\/p>\n

V\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u h\u01a1n l\u00e0 nh\u01b0 b\u1ea3ng t\u00ednh b\u00ean d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta th\u1ea5y \u0111\u01b0\u1ee3c h\u00e0m VLOOKUP ch\u1ec9 \u00e1p d\u1ee5ng tham chi\u1ebfu \u0111\u1ebfn 4 ph\u1ea1m vi m\u00e0 th\u00f4i. Nh\u01b0ng \u0111\u00f4i khi v\u00ec nh\u1eadp sai s\u1ed1 m\u00e0 l\u1ec7nh t\u00ecm ki\u1ebfm l\u1ea1i xu\u1ea5t hi\u1ec7n cho 5 c\u1ed9t. T\u1eeb \u0111\u00f3, l\u1ed7i tham chi\u1ebfu <\/span>hi\u1ec3n th\u1ecb v\u00e0 g\u00e2y ra nhi\u1ec1u hoang mang cho ng\u01b0\u1eddi d\u00f9ng.<\/span><\/p>\n

\"ref-5\"<\/picture><\/p>\n

K\u1ebft qu\u1ea3 sau khi ng\u01b0\u1eddi d\u00f9ng nh\u1ea5n ph\u00edm \u201cEnter\u201d, ngay t\u1ee9c th\u00ec b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ec7 th\u1ed1ng b\u00e1o v\u1ec1 l\u1ed7i sai. N\u1ebfu kh\u00f4ng tinh \u00fd th\u00ec c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn kh\u00f4ng nh\u1eadn ra \u0111\u01b0\u1ee3c l\u1ed7i #REF<\/strong> n\u00e0y \u0111\u00e2u nh\u00e9.<\/span><\/p>\n

\"ref-6\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h4>\n

V\u1edbi m\u1ed7i h\u00e0m c\u00f4ng th\u1ee9c trong Excel s\u1ebd c\u00f3 m\u1ed9t quy lu\u1eadt s\u1eed d\u1ee5ng kh\u00e1c nhau. Do \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng n\u00ean \u0111\u1ecdc hi\u1ec3u k\u1ef9 c\u00e1c h\u00e0m tr\u01b0\u1edbc khi ti\u1ebfn h\u00e0nh s\u1eed d\u1ee5ng. V\u00e0 n\u1ebfu g\u1eb7p l\u1ed7i \u0111\u1ed1i s\u00e1nh th\u00ec b\u1ea1n h\u00e3y x\u00e1c minh xem c\u00e1c \u00f4 m\u00e0 c\u00f4ng th\u1ee9c tham chi\u1ebfu c\u00f3 t\u1ed3n t\u1ea1i hay kh\u00f4ng. N\u1ebfu kh\u00f4ng, ng\u01b0\u1eddi d\u00f9ng h\u00e3y tinh ch\u1ec9nh c\u00f4ng th\u1ee9c h\u00e0m Excel \u0111\u1ec3 h\u01b0\u1edbng t\u1edbi \u0111\u00fang ph\u1ea1m vi d\u1eef li\u1ec7u m\u1edbi. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u201cT\u00ecm v\u00e0 Thay th\u1ebf\u201d \u0111\u1ec3 nhanh ch\u00f3ng thay \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c li\u00ean k\u1ebft tham chi\u1ebfu trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n

Ch\u1eb3ng h\u1ea1n nh\u01b0 \u1edf v\u00ed d\u1ee5 v\u1eeba r\u1ed3i, ch\u00fang ta s\u1ebd x\u00e9t l\u1ea1i s\u1ef1 \u0111\u1ed3ng nh\u1ea5t gi\u1eefa s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u1ea7n t\u00ecm ki\u1ebfm v\u00e0 \u00f4 tham chi\u1ebfu. \u0110\u01a1n gi\u1ea3n nh\u01b0 v\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh th\u00e0nh c\u00f4ng r\u1ed3i nh\u00e9.<\/span><\/p>\n

\"ref-7\"<\/picture><\/p>\n

L\u1ed7i #REF! v\u00ec sao ch\u00e9p d\u1eef li\u1ec7u Excel t\u1eeb file n\u00e0y sang file kh\u00e1c<\/b><\/h3>\n

Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd data, r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i th\u01b0\u1eddng xuy\u00ean sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb file Excel n\u00e0y sang file Excel kh\u00e1c. Kh\u00f4ng nh\u1eefng th\u1ebf, \u0111\u1ed1i v\u1edbi nh\u1eefng t\u1ec7p d\u1eef li\u1ec7u l\u1edbn c\u00f3 \u0111\u1ed9 x\u1eed l\u00fd ph\u1ee9c t\u1ea1p h\u01a1n, ng\u01b0\u1eddi d\u00f9ng c\u00f2n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c tham chi\u1ebfu qua l\u1ea1i gi\u1eefa c\u00e1c t\u1ec7p kh\u00e1c nhau. Song, v\u1eabn c\u00f3 kh\u00f4ng \u00edt ng\u01b0\u1eddi thao t\u00e1c sai n\u00ean d\u1eabn \u0111\u1ebfn l\u1ed7i tham chi\u1ebfu xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n

Nguy\u00ean nh\u00e2n<\/b><\/h4>\n

Khi b\u1ea1n sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb m\u1ed9t file n\u00e0y sang m\u1ed9t file kh\u00e1c, c\u00e1c li\u00ean k\u1ebft tham chi\u1ebfu gi\u1eefa c\u00e1c \u00f4 c\u00f3 th\u1ec3 kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt \u0111\u00fang c\u00e1ch. V\u1ea5n \u0111\u1ec1 n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi t\u00ean file, \u0111\u01b0\u1eddng d\u1eabn, ho\u1eb7c c\u1ea3 c\u00e1c kho\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu thay \u0111\u1ed5i kh\u00f4ng tr\u00f9ng kh\u1edbp. K\u1ebft qu\u1ea3 l\u00e0, Excel kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu v\u00e0 hi\u1ec3n th\u1ecb l\u1ed7i trong \u00f4 ho\u1eb7c ph\u1ea1m vi b\u1ea3ng t\u00ednh.<\/span><\/p>\n

Ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00ecnh minh h\u1ecda sau \u0111\u00e2y ch\u00fang ta s\u1ebd t\u1eadn d\u1ee5ng l\u1ea1i b\u1ea3ng t\u00ednh v\u1ec1 t\u1ed5ng \u0111i\u1ec3m c\u00e1c m\u00f4n h\u1ecdc. Ch\u00fang ta \u0111i\u1ec1n th\u00f4ng tin t\u1eeb c\u1ed9t A \u0111\u1ebfn E v\u00e0 t\u00ednh SUM \u0111i\u1ec3m \u1edf c\u1ed9t F.<\/span><\/p>\n

\"ref-8\"<\/picture><\/p>\n

Tuy th\u1ebf, khi copy qua m\u1ed9t file kh\u00e1c, ch\u00fang ta l\u1ea1i \u0111\u1ed5i d\u1eef li\u1ec7u nh\u1eadp v\u00e0o t\u1eeb c\u1ed9t C \u0111\u1ebfn D v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 t\u1ed5ng \u0111i\u1ec3m \u1edf c\u1ed9t H. Nh\u01b0 v\u1eady, Excel s\u1ebd kh\u00f4ng hi\u1ec3u \u0111\u01b0\u1ee3c thao t\u00e1c b\u1ea1n v\u1eeba l\u00e0m v\u00e0 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u n\u00e0y l\u00e0 kh\u00f4ng tr\u00f9ng kh\u1edbp v\u1edbi c\u00f4ng th\u1ee9c.<\/span><\/p>\n

\"ref-9\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h4>\n

C\u00e1ch kh\u1eafc ph\u1ee5c t\u1ed1t nh\u1ea5t \u0111\u1ed1i v\u1edbi l\u1ed7i <\/span>#REF!<\/b> khi sao ch\u00e9p d\u1eef li\u1ec7u kh\u00f4ng th\u00e0nh c\u00f4ng, \u0111\u00f3 ch\u00ednh l\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ef1 tr\u00f9ng kh\u1edbp v\u1edbi file Excel g\u1ed1c. \u0110\u1eb7c bi\u1ec7t, \u0111\u1ed1i v\u1edbi c\u00e1c d\u1ef1 \u00e1n l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u201cQu\u1ea3n l\u00fd T\u00ean\u201d c\u0169ng c\u00f3 th\u1ec3 gi\u00fap duy tr\u00ec t\u00ednh nh\u1ea5t qu\u00e1n gi\u1eefa c\u00e1c li\u00ean k\u1ebft tham chi\u1ebfu khi sao ch\u00e9p d\u1eef li\u1ec7u gi\u1eefa c\u00e1c file Excel kh\u00e1c nhau.<\/span><\/p>\n

V\u00e0 t\u1ea1i v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 tinh ch\u1ec9nh l\u1ea1i d\u1eef li\u1ec7u \u1edf c\u00e1c c\u1ed9t theo \u0111\u00fang nh\u01b0 b\u1ea3n g\u1ed1c th\u00ec s\u1ebd ghi nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u01b0 h\u00ecnh.\u00a0<\/span><\/p>\n

\"ref-10\"<\/picture><\/p>\n

L\u1ed7i #REF <\/span>v\u00ec tham chi\u1ebfu t\u1edbi h\u00e0m INDIRECT Excel \u0111ang \u0111\u00f3ng<\/b><\/h3>\n

H\u00e0m INDIRECT trong Excel l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1, c\u0169ng nh\u01b0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n ho\u1eb7c t\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u \u0111\u00f3. M\u1eb7c d\u00f9 h\u00e0m INDIRECT r\u1ea5t d\u1ec5 s\u1eed d\u1ee5ng, nh\u01b0ng n\u1ebfu kh\u00f4ng d\u00f9ng \u0111\u00fang c\u00e1ch th\u00ec b\u1ea1n v\u1eabn g\u1eb7p l\u1ed7i tham chi\u1ebfu nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/span><\/p>\n

Nguy\u00ean nh\u00e2n<\/b><\/h4>\n

Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m INDIRECT c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn l\u1ed7i tham chi\u1ebfu xu\u1ea5t ph\u00e1t t\u1eeb m\u1ed9t trong 3 nguy\u00ean nh\u00e2n ch\u00ednh sau \u0111\u00e2y. Th\u1ee9 nh\u1ea5t, \u0111\u00f3 l\u00e0 v\u00ec ph\u1ea7n \u201cref_text\u201d trong b\u1ea3ng t\u00ednh kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ph\u1ea1m vi \u0111\u1ed1i s\u00e1nh h\u1ee3p l\u1ec7. H\u01a1n n\u1eefa, vi\u1ec7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u201cmi\u1ec1n\u201d v\u01b0\u1ee3t qua gi\u1edbi h\u1ea1n cho ph\u00e9p c\u1ee7a c\u00f4ng th\u1ee9c INDIRECT c\u0169ng c\u00f3 th\u1ec3 g\u00e2y ra l\u1ed7i tr\u00ean. V\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t, khi b\u1ea3ng t\u00ednh hay file Excel \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn \u0111ang \u0111\u00f3ng.\u00a0<\/span><\/p>\n

Nh\u01b0 h\u00ecnh \u1ea3nh v\u00ed d\u1ee5 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m trong kho, ch\u00fang ta th\u1ea5y \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111ang tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 <\/span>#REF!<\/b>. Do v\u1eady, c\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i v\u00e0 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng hay kh\u00f4ng?<\/span><\/p>\n

\"ref-11\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h4>\n

H\u01b0\u1edbng gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1ea5t \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng ngay l\u00fac n\u00e0y, \u0111\u00f3 ch\u00ednh l\u00e0 h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng m\u00ecnh \u0111\u00e3 m\u1edf file Excel m\u00e0 b\u1ea3ng t\u00ednh \u0111ang tham chi\u1ebfu. Sau \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng h\u00e3y \u0111\u1ed1i chi\u1ebfu l\u1ea1i c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu trong ph\u1ea1m vi Excel \u0111\u1ec3 ch\u00fang x\u00e1c \u0111\u1ecbnh \u0111\u00fang v\u1ecb tr\u00ed, trong khi file \u0111\u00e3 m\u1edf. Th\u1ef1c hi\u1ec7n nh\u1eefng b\u01b0\u1edbc n\u00e0y gi\u00fap t\u00e1i thi\u1ebft l\u1eadp li\u00ean k\u1ebft v\u00e0 gi\u1ea3m thi\u1ec3u kh\u1ea3 n\u0103ng xu\u1ea5t hi\u1ec7n l\u1ed7i \u0111\u1ed1i s\u00e1nh khi tham chi\u1ebfu \u0111\u1ebfn file Excel \u0111ang \u0111\u00f3ng.<\/span><\/p>\n

\"ref-12\"<\/picture><\/p>\n

M\u1ed9t s\u1ed1 l\u1ed7i h\u00e0m Excel kh\u00e1c m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua<\/b><\/h2>\n

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Microsoft Excel, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi nh\u1eefng th\u00e1ch th\u1ee9c li\u00ean quan \u0111\u1ebfn c\u00fa ph\u00e1p. Ngo\u00e0i l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u01b0 <\/span>#REF!<\/b>, c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i c\u00fa ph\u00e1p kh\u00e1c m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p ph\u1ea3i. Ch\u1eb3ng h\u1ea1n nh\u01b0 l\u1ed7i \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u sai #VALUE!, l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 #N\/A, l\u1ed7i Excel ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00f4ng h\u1ee3p l\u1ec7 #NUM!, hay l\u1ed7i chia cho 0 #DIV\/0!. Song song \u0111\u00f3, L\u1ed7i #NAME? l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 kh\u00e1c, x\u1ea3y ra khi t\u00ean ho\u1eb7c h\u00e0m kh\u00f4ng \u0111\u01b0\u1ee3c Excel nh\u1eadn di\u1ec7n.<\/span><\/p>\n

\"ref-13\"<\/picture><\/p>\n

L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 tr\u00e1nh nh\u1eefng l\u1ed7i n\u00e0y l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel. Vi\u1ec7c hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch c\u00fa ph\u00e1p ho\u1ea1t \u0111\u1ed9ng v\u00e0 ki\u1ec3m so\u00e1t c\u00e1c tham chi\u1ebfu, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m l\u00e0 ch\u00eca kh\u00f3a \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a c\u00e1c c\u00fa ph\u00e1p h\u00e0m trong b\u1ea3ng t\u00ednh Excel. \u0110\u1ed3ng th\u1eddi, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 ki\u1ec3m tra l\u1ed7i v\u00e0 theo d\u00f5i c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng ph\u00e1t hi\u1ec7n v\u00e0 kh\u1eafc ph\u1ee5c l\u1ed7i m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. Ho\u1eb7c n\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft c\u00e1ch s\u1eeda c\u00e1c l\u1ed7i Excel chi ti\u1ebft h\u01a1n th\u00ec c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u v\u1ec1 th\u1ee7 thu\u1eadt Excel t\u1ea1i Trang Tin Nhanh c\u1ee7a Ho\u00e0ng H\u00e0 Mobile nh\u00e9.<\/span><\/p>\n

K\u1ebft lu\u1eadn<\/b><\/h2>\n

V\u1edbi nh\u1eefng th\u00f4ng tin v\u1ec1 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i <\/span>#REF!<\/b> trong b\u1ea3ng t\u00ednh Excel, Ho\u00e0ng H\u00e0 Mobile hy v\u1ecdng b\u1ea1n c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng th\u1ee7 thu\u1eadt th\u00e0nh c\u00f4ng. V\u00e0 \u0111\u1eebng qu\u00ean ti\u1ebfp t\u1ee5c theo d\u00f5i c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u m\u1eb9o s\u1eed d\u1ee5ng Excel hay ho kh\u00e1c b\u1ea1n nh\u00e9.\u00a0<\/span><\/p>\n

Xem th\u00eam:<\/b><\/p>\n