{"id":4731,"date":"2025-11-13T21:13:03","date_gmt":"2025-11-13T14:13:03","guid":{"rendered":"https:\/\/autofillform.com\/blog\/tim-hieu-nguyen-nhan-va-cach-sua-loi-n-a-trong-excel-hieu-qua\/"},"modified":"2025-11-13T21:13:03","modified_gmt":"2025-11-13T14:13:03","slug":"tim-hieu-nguyen-nhan-va-cach-sua-loi-n-a-trong-excel-hieu-qua","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/tim-hieu-nguyen-nhan-va-cach-sua-loi-n-a-trong-excel-hieu-qua\/","title":{"rendered":"T\u00ecm hi\u1ec3u nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A trong Excel hi\u1ec7u qu\u1ea3"},"content":{"rendered":"
\n

L\u1ed7i #N\/A trong Excel c\u00f3 th\u1ec3 s\u1eeda b\u1eb1ng c\u00e1ch ki\u1ec3m tra l\u1ea1i ph\u1ea1m vi d\u1eef li\u1ec7u, c\u1ed1 \u0111\u1ecbnh v\u00f9ng tra c\u1ee9u v\u1edbi ph\u00edm F4, ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m IFERROR, ISNA \u0111\u1ec3 thay th\u1ebf l\u1ed7i b\u1eb1ng gi\u00e1 tr\u1ecb kh\u00e1c. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n c\u1ee7a l\u1ed7i #N\/A v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eeda l\u1ed7i hi\u1ec7u qu\u1ea3 \u0111\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/p>\n

\"C\u00e1chNguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A trong Excel<\/em><\/p>\n

\n

1. L\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

L\u1ed7i #N\/A trong Excel l\u00e0 th\u00f4ng b\u00e1o cho bi\u1ebft gi\u00e1 tr\u1ecb ho\u1eb7c d\u1eef li\u1ec7u m\u00e0 c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u kh\u00f4ng t\u1ed3n t\u1ea1i ho\u1eb7c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y. T\u00ean vi\u1ebft t\u1eaft \u201cN\/A\u201d c\u00f3 th\u1ec3 hi\u1ec3u l\u00e0 Not Available, No Answer ho\u1eb7c Not Applicable, ngh\u0129a l\u00e0 \u201ckh\u00f4ng c\u00f3 d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p\u201d ho\u1eb7c \u201ckh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng\u201d.<\/p>\n

L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m tra c\u1ee9u nh\u01b0 VLOOKUP, HLOOKUP, MATCH ho\u1eb7c INDEX nh\u01b0ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng xu\u1ea5t hi\u1ec7n trong v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu. Khi \u0111\u00f3, Excel kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 h\u1ee3p l\u1ec7, n\u00ean hi\u1ec3n th\u1ecb l\u1ed7i #N\/A \u0111\u1ec3 b\u00e1o r\u1eb1ng ph\u00e9p t\u00ednh kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd.<\/p>\n

\n

1.1 V\u00ed d\u1ee5 v\u1ec1 l\u1ed7i #N\/A<\/h3>\n<\/div>\n

L\u1ed7i #N\/A trong Excel xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u trong ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n

\"Th\u00f4ngV\u00ed d\u1ee5 v\u1ec1 l\u1ed7i #N\/A trong Excel khi c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u<\/em><\/p>\n

\n

1.2 M\u1ed9t s\u1ed1 h\u00e0m d\u1ec5 m\u1eafc ph\u1ea3i l\u1ed7i #N\/A<\/h3>\n<\/div>\n

M\u1ed9t s\u1ed1 h\u00e0m trong Excel th\u01b0\u1eddng ph\u00e1t sinh l\u1ed7i #N\/A<\/strong> l\u00e0 nh\u1eefng h\u00e0m c\u00f3 ch\u1ee9c n\u0103ng tra c\u1ee9u ho\u1eb7c so s\u00e1nh d\u1eef li\u1ec7u. C\u1ee5 th\u1ec3 g\u1ed3m:<\/p>\n

    \n
  • VLOOKUP <\/strong>v\u00e0 HLOOKUP:<\/strong> X\u1ea3y ra khi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng xu\u1ea5t hi\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u tham chi\u1ebfu.<\/li>\n
  • MATCH:<\/strong> B\u00e1o l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u.<\/li>\n
  • INDEX:<\/strong> C\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 #N\/A khi \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MATCH v\u00e0 \u0111\u1ed1i s\u1ed1 tra c\u1ee9u b\u1ecb l\u1ed7i.<\/li>\n
  • IF<\/strong> (ho\u1eb7c IFERROR<\/strong>, IFNA<\/strong>): Kh\u00f4ng tr\u1ef1c ti\u1ebfp g\u00e2y l\u1ed7i #N\/A, nh\u01b0ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u1eed l\u00fd ho\u1eb7c \u1ea9n l\u1ed7i n\u00e0y khi xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c kh\u00e1c.<\/li>\n<\/ul>\n
    Xem th\u00eam: <\/strong>11 C\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng, t\u0103ng t\u1ed1c x\u1eed l\u00fd file Excel<\/div>\n
    \n

    2. Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i #N\/A v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/h2>\n<\/div>\n
    \n

    2.1 V\u00f9ng t\u00ecm ki\u1ebfm b\u1ecb thi\u1ebfu ho\u1eb7c sai ph\u1ea1m vi<\/h3>\n<\/div>\n

    Nguy\u00ean nh\u00e2n: L\u1ed7i n\u00e0y x\u1ea3y ra khi h\u00e0m tra c\u1ee9u kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. N\u00f3i c\u00e1ch kh\u00e1c, v\u00f9ng t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c nh\u1eadp kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n truy xu\u1ea5t, khi\u1ebfn Excel kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 h\u1ee3p l\u1ec7.<\/p>\n

    V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u00ecm th\u00f4ng tin s\u1ea3n ph\u1ea9m M\u0103ng c\u1ee5t trong b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb \u00f4 A2:D6.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP(“M\u0103ng c\u1ee5t”,A2:D6,4,0)<\/strong> v\u00e0o Excel.<\/p>\n

    \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c t\u00ecm th\u00f4ng tin s\u1ea3n ph\u1ea9m \u201cM\u0103ng c\u1ee5t\u201d v\u00e0o Excel<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3 nh\u1ea5n Enter<\/strong>, gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm (\u201cM\u0103ng c\u1ee5t\u201d) kh\u00f4ng c\u00f3 trong c\u1ed9t tra c\u1ee9u c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u A2:D6, v\u00ec v\u1eady Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #N\/A \u0111\u1ec3 b\u00e1o r\u1eb1ng kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p.<\/p>\n

    \"Th\u00f4ngExcel hi\u1ec7n l\u1ed7i #N\/A v\u00ec kh\u00f4ng t\u00ecm th\u1ea5y s\u1ea3n ph\u1ea9m \u201cM\u0103ng c\u1ee5t\u201d<\/em><\/p>\n

    C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> H\u00e3y ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u v\u00e0 ch\u1ec9nh s\u1eeda t\u00ean s\u1ea3n ph\u1ea9m cho \u0111\u00fang. V\u00ed d\u1ee5, n\u1ebfu s\u1ea3n ph\u1ea9m th\u1ef1c t\u1ebf l\u00e0 Nh\u00e3n, b\u1ea1n nh\u1eadp l\u1ea1i c\u00f4ng th\u1ee9c: =VLOOKUP(“Nh\u00e3n”;B2:D6;2;0)<\/strong>. L\u00fac n\u00e0y, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u1ee9ng v\u1edbi d\u00f2ng ch\u1ee9a \u201cNh\u00e3n\u201d trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

    \"S\u1eedaNh\u1eadp l\u1ea1i \u0111\u00fang t\u00ean s\u1ea3n ph\u1ea9m, k\u1ebft qu\u1ea3 h\u00e0m Excel tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c<\/em><\/p>\n

    \n

    2.2 L\u1ed7i do kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng tham chi\u1ebfu khi sao ch\u00e9p c\u00f4ng th\u1ee9c<\/h3>\n<\/div>\n

    Nguy\u00ean nh\u00e2n: <\/strong>Khi c\u00f4ng th\u1ee9c kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i v\u00f9ng tra c\u1ee9u cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c. K\u1ebft qu\u1ea3 l\u00e0 Excel kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u trong b\u1ea3ng d\u1eef li\u1ec7u, g\u00e2y ra l\u1ed7i #N\/A.<\/p>\n

    V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm s\u1ea3n ph\u1ea9m \u201cM\u0103ng c\u1ee5t\u201d trong b\u1ea3ng d\u1eef li\u1ec7u, nh\u01b0ng kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng tra c\u1ee9u. Khi sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c, Excel s\u1ebd thay \u0111\u1ed5i v\u00f9ng tra c\u1ee9u, g\u00e2y ra l\u1ed7i #N\/A.<\/p>\n

    \"L\u1ed7iL\u1ed7i #N\/A do kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng tra c\u1ee9u khi sao ch\u00e9p c\u00f4ng th\u1ee9c<\/em><\/p>\n

    C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

    \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c. B\u1ea1n b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh, v\u00ed d\u1ee5, \u00f4 B2:D6.<\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n ph\u00edm F4 tr\u00ean b\u00e0n ph\u00edm. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam d\u1ea5u $ v\u00e0o v\u00f9ng d\u1eef li\u1ec7u, v\u00ed d\u1ee5: $B$2:$D$6. \u0110\u00e2y l\u00e0 c\u00e1ch gi\u00fap c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 thay \u0111\u1ed5i v\u00f9ng tra c\u1ee9u.<\/p>\n

    Sau khi th\u1ef1c hi\u1ec7n, c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c, gi\u00fap tr\u00e1nh l\u1ed7i #N\/A.<\/p>\n

    \"ThaoD\u00f9ng ph\u00edm F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh v\u00f9ng tra c\u1ee9u<\/em><\/p>\n

    \n

    2.3 L\u1ed7i x\u1ea3y ra khi d\u00f9ng VLOOKUP ho\u1eb7c HLOOKUP k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT<\/h3>\n<\/div>\n

    Tr\u01b0\u1eddng h\u1ee3p 1: L\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m MID<\/strong><\/p>\n

    Nguy\u00ean nh\u00e2n: <\/strong>L\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n khi d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u kh\u00f4ng kh\u1edbp v\u1ec1 \u0111\u1ecbnh d\u1ea1ng v\u1edbi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m MID.<\/p>\n

    V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed b\u1ea1n d\u00f9ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ecm \u0111i\u1ec3m khu v\u1ef1c d\u1ef1a tr\u00ean s\u1ed1 b\u00e1o danh sinh vi\u00ean. B\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: =HLOOKUP(MID(A3;4;1);$C$9:$F$10;2;0)<\/strong><\/p>\n

      \n
    • MID(A3; 4; 1):<\/strong> L\u1ea5y 1 k\u00fd t\u1ef1 th\u1ee9 4 t\u1eeb \u00f4 A3.<\/li>\n
    • $C$9:$F$10:<\/strong> V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm.<\/li>\n
    • 2:<\/strong> C\u1ed9t tr\u1ea3 v\u1ec1 \u0111i\u1ec3m khu v\u1ef1c.<\/li>\n
    • 0<\/strong>: L\u1ea5y gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/li>\n<\/ul>\n

      \"L\u1ed7iD\u00f9ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ecm \u0111i\u1ec3m khu v\u1ef1c<\/em><\/p>\n

      Khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Enter<\/strong>, Excel b\u00e1o l\u1ed7i #N\/A.<\/p>\n

      \"Th\u00f4ngNh\u1ea5n Enter v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i #N\/A<\/em><\/p>\n

      C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Ki\u1ec3m tra l\u1ea1i \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong b\u1ea3ng v\u00e0 trong \u00f4 t\u00ednh. \u0110\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m MID sang d\u1ea1ng s\u1ed1.<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> S\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c nh\u01b0 sau: =HLOOKUP(VALUE(MID(A3;4;1));$C$9:$F$10;2;0)<\/strong><\/p>\n

      \"Nh\u1eadpS\u1eeda l\u1ea1i th\u00e0nh c\u00f4ng th\u1ee9c \u0111\u00fang<\/em><\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Sau khi thay \u0111\u1ed5i, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n

      \"L\u1ed7iK\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c sau khi \u0111\u1ed5i c\u00f4ng th\u1ee9c<\/em><\/p>\n

      Tr\u01b0\u1eddng h\u1ee3p 2: L\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m LEFT<\/strong><\/p>\n

      V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n \u0111i\u1ec1n t\u00ean h\u00e3ng v\u00e0o m\u00e3 l\u00f4 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi LEFT: =VLOOKUP(LEFT(B3;3);E8:F11;2;0)<\/strong><\/p>\n

        \n
      • LEFT(B3; 3):<\/strong> L\u1ea5y 3 k\u00fd t\u1ef1 \u0111\u1ea7u t\u1eeb \u00f4 B3.<\/li>\n
      • E8:F11:<\/strong> V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u.<\/li>\n<\/ul>\n

        \"V\u00edS\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m LEFT<\/em><\/p>\n

        Khi th\u1ef1c hi\u1ec7n, Excel s\u1ebd b\u00e1o l\u1ed7i #N\/A.<\/p>\n

        \"Th\u00f4ngTh\u1ef1c hi\u1ec7n xong c\u00f4ng th\u1ee9c, Excel b\u00e1o l\u1ed7i #N\/A<\/em><\/p>\n

        C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> L\u1ed7i x\u1ea3y ra khi s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n tr\u00edch xu\u1ea5t t\u1eeb h\u00e0m LEFT kh\u00f4ng kh\u1edbp v\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng. Khi \u0111\u00f3, b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea1i s\u1ed1 k\u00fd t\u1ef1 trong c\u00f4ng th\u1ee9c \u0111\u1ec3 kh\u1edbp v\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng.<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP(LEFT(A3;2);C8:D11;2;0)<\/strong><\/p>\n

        \"Nh\u1eadpKh\u1eafc ph\u1ee5c l\u1ed7i b\u1eb1ng c\u00e1ch ch\u1ec9nh s\u1eeda v\u00e0 nh\u1eadp l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u00fang<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter v\u00e0 k\u1ebft qu\u1ea3 h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c.<\/p>\n

        \"Kh\u1eafcNh\u1ea5n Enter v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c h\u00e3ng TOSHIBA<\/em><\/p>\n

        Tr\u01b0\u1eddng h\u1ee3p 3: L\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m RIGHT<\/strong><\/p>\n

        V\u00ed d\u1ee5:<\/strong> \u0110i\u1ec1n t\u00ean h\u00e3ng v\u00e0o m\u00e3 l\u00f4 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

        S\u1eed d\u1ee5ng h\u00e0m RIGHT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP: =VLOOKUP(RIGHT(A3;2); C8:D11;2;0)<\/strong><\/p>\n

          \n
        • RIGHT(A3; 2):<\/strong> L\u1ea5y 2 k\u00fd t\u1ef1 \u1edf ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a \u00f4 A3.<\/li>\n
        • C8:D11:<\/strong> V\u00f9ng ch\u1ee9a b\u1ea3ng th\u00f4ng tin.<\/li>\n
        • 2:<\/strong> V\u1ecb tr\u00ed l\u1ea5y \u1edf c\u1ed9t t\u00ean h\u00e3ng.<\/li>\n
        • 0:<\/strong> L\u1ea5y gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/li>\n<\/ul>\n

          \"L\u1ed7iS\u1eed d\u1ee5ng h\u00e0m RIGHT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP<\/em><\/p>\n

          K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A m\u1eb7c d\u00f9 d\u1eef li\u1ec7u trong \u00f4 t\u00ednh v\u00e0 b\u1ea3ng th\u00f4ng tin \u0111\u00fang.<\/p>\n

          \"Th\u00f4ngK\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A m\u1eb7c d\u00f9 \u0111\u00e3 nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u00fang<\/em><\/p>\n

          Nguy\u00ean nh\u00e2n: <\/strong>L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 do b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng kh\u00f4ng nh\u00ecn th\u1ea5y trong m\u00e3 h\u00e0ng, g\u00e2y l\u1ed7i trong vi\u1ec7c so kh\u1edbp d\u1eef li\u1ec7u.<\/p>\n

          \"Nguy\u00eanNguy\u00ean nh\u00e2n ch\u1ee7 y\u1ebfu do kho\u1ea3ng tr\u1eafng kh\u00f4ng nh\u00ecn th\u1ea5y trong m\u00e3 h\u00e0ng<\/em><\/p>\n

          C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Ki\u1ec3m tra v\u00e0 x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba trong b\u1ea3ng d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c m\u00e3 h\u00e0ng. Sau khi lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng, Excel s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n

          \"X\u00f3aX\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba trong b\u1ea3ng d\u1eef li\u1ec7u, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c<\/em><\/p>\n

          \n

          2.4 Nguy\u00ean nh\u00e2n l\u1ed7i #N\/A d\u00f9 \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm v\u1eabn n\u1eb1m trong v\u00f9ng d\u1eef li\u1ec7u<\/h3>\n<\/div>\n

          Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i #N\/A x\u1ea3y ra khi c\u00f3 d\u1ea5u c\u00e1ch th\u1eeba ph\u00eda sau gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm ho\u1eb7c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec1u \u0111\u00f3 l\u00e0m cho Excel kh\u00f4ng th\u1ec3 so kh\u1edbp ch\u00ednh x\u00e1c, v\u00ec trong khi c\u00e1c k\u00fd t\u1ef1 kh\u00e1c gi\u1ed1ng nhau, Excel coi d\u1ea5u c\u00e1ch l\u00e0 m\u1ed9t k\u00fd t\u1ef1 kh\u00e1c bi\u1ec7t.<\/p>\n

          C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

            \n
          • Ch\u1ecdn t\u1eebng gi\u00e1 tr\u1ecb:<\/strong> Ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm.<\/li>\n
          • S\u1eed d\u1ee5ng ph\u00edm F2:<\/strong> Khi b\u1ea1n nh\u1ea5n ph\u00edm F2 \u0111\u1ec3 ch\u1ec9nh s\u1eeda gi\u00e1 tr\u1ecb trong \u00f4, b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y c\u00e1c d\u1ea5u c\u00e1ch th\u1eeba n\u1ebfu c\u00f3. N\u1ebfu th\u1ea5y c\u00f3 d\u1ea5u c\u00e1ch ph\u00eda sau chu\u1ed7i, h\u00e3y x\u00f3a n\u00f3 \u0111i.<\/li>\n
          • L\u1eb7p l\u1ea1i cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb:<\/strong> L\u00e0m t\u01b0\u01a1ng t\u1ef1 cho c\u1ea3 hai gi\u00e1 tr\u1ecb, gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0 gi\u00e1 tr\u1ecb trong v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n
            \n

            2.5 D\u00f9ng h\u00e0m ISNA \u0111\u1ec3 s\u1eeda l\u1ed7i #N\/A<\/h3>\n<\/div>\n

            L\u1ed3ng h\u00e0m ISNA v\u00e0o c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

            B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m ISNA v\u1edbi c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm nh\u01b0 VLOOKUP, HLOOKUP, ho\u1eb7c MATCH. C\u1ee5 th\u1ec3, h\u00e0m ISNA s\u1ebd ki\u1ec3m tra xem k\u1ebft qu\u1ea3 c\u00f3 ph\u1ea3i l\u00e0 l\u1ed7i #N\/A hay kh\u00f4ng. N\u1ebfu c\u00f3, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf l\u1ed7i \u0111\u00f3 b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/p>\n

            C\u00f4ng th\u1ee9c minh h\u1ecda: Gi\u1ea3 s\u1eed b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u00e0 g\u1eb7p ph\u1ea3i l\u1ed7i #N\/A, b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i b\u1eb1ng c\u00e1ch l\u1ed3ng h\u00e0m ISNA nh\u01b0 sau:<\/p>\n

            =IF(ISNA(VLOOKUP(RIGHT(A3;3); C8:D11;2;0)); “Kh\u00f4ng t\u00ecm th\u1ea5y”; VLOOKUP(RIGHT(A3;3); C8:D11;2;0))<\/strong><\/p>\n

              \n
            • ISNA(VLOOKUP(RIGHT(A3;3); C8:D11;2;0) ki\u1ec3m tra n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a VLOOKUP l\u00e0 l\u1ed7i #N\/A.<\/li>\n
            • N\u1ebfu c\u00f3 l\u1ed7i, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i “Kh\u00f4ng t\u00ecm th\u1ea5y” thay v\u00ec #N\/A.<\/li>\n
            • N\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u1ee7a VLOOKUP.<\/li>\n<\/ul>\n

              \"D\u00f9ngH\u00e0m ISNA s\u1ebd ki\u1ec3m tra xem k\u1ebft qu\u1ea3 c\u00f3 ph\u1ea3i l\u00e0 l\u1ed7i #N\/A hay kh\u00f4ng<\/em><\/p>\n

              \n

              3. C\u00e1ch \u1ea9n l\u1ed7i #N\/A<\/h2>\n<\/div>\n

              \u0110\u1ec3 \u1ea9n l\u1ed7i #N\/A trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR. H\u00e0m n\u00e0y gi\u00fap x\u1eed l\u00fd c\u00e1c l\u1ed7i trong c\u00f4ng th\u1ee9c, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb thay th\u1ebf khi g\u1eb7p l\u1ed7i.<\/p>\n

              C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t c\u1ee7a IFERROR l\u00e0:<\/p>\n

              =IFERROR(value, value_if_error)<\/strong><\/p>\n

              Trong \u0111\u00f3:<\/p>\n

                \n
              • value:<\/strong> L\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra l\u1ed7i.<\/li>\n
              • value_if_error:<\/strong> L\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c th\u00f4ng b\u00e1o thay th\u1ebf s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu value g\u1eb7p ph\u1ea3i l\u1ed7i.<\/li>\n<\/ul>\n

                C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFERROR k\u1ebft h\u1ee3p v\u1edbi VLOOKUP<\/strong><\/p>\n

                V\u00ed d\u1ee5, khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u v\u00e0 c\u00f3 th\u1ec3 g\u1eb7p l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng IFERROR \u0111\u1ec3 thay th\u1ebf l\u1ed7i n\u00e0y b\u1eb1ng gi\u00e1 tr\u1ecb kh\u00e1c nh\u01b0 “Kh\u00f4ng t\u00ecm th\u1ea5y” ho\u1eb7c gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n

                C\u00f4ng th\u1ee9c v\u00ed d\u1ee5:<\/p>\n

                =IFERROR(VLOOKUP(RIGHT(A3; 2); C8:D11; 2; FALSE); “Kh\u00f4ng t\u00ecm th\u1ea5y”)<\/strong><\/p>\n

                Gi\u1ea3i th\u00edch:<\/p>\n

                  \n
                • H\u00e0m VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong \u00f4 A3 trong ph\u1ea1m vi t\u1eeb C8 \u0111\u1ebfn D11.<\/li>\n
                • N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. Khi \u0111\u00f3, h\u00e0m IFERROR s\u1ebd thay th\u1ebf l\u1ed7i n\u00e0y b\u1eb1ng th\u00f4ng b\u00e1o “Kh\u00f4ng t\u00ecm th\u1ea5y”.<\/li>\n<\/ul>\n

                  \"D\u00f9ngH\u00e0m IFERROR gi\u00fap x\u1eed l\u00fd c\u00e1c l\u1ed7i trong c\u00f4ng th\u1ee9c, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb thay th\u1ebf khi g\u1eb7p l\u1ed7i<\/em><\/p>\n

                  L\u1ed7i #N\/A trong Excel c\u00f3 th\u1ec3 khi\u1ebfn c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n b\u1ecb gi\u00e1n \u0111o\u1ea1n, nh\u01b0ng v\u1edbi nh\u1eefng gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u01b0 ki\u1ec3m tra v\u00f9ng d\u1eef li\u1ec7u, c\u1ed1 \u0111\u1ecbnh v\u00f9ng tham chi\u1ebfu, hay s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 ISNA ho\u1eb7c IFERROR, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3. H\u00e3y \u00e1p d\u1ee5ng nh\u1eefng c\u00e1ch s\u1eeda l\u1ed7i m\u00e0 b\u00e0i vi\u1ebft \u0111\u00e3 chia s\u1ebb \u0111\u1ec3 c\u00f4ng th\u1ee9c Excel lu\u00f4n ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n

                  \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt Excel h\u1eefu \u00edch.<\/p>\n

                  >> N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm ph\u1ee5 ki\u1ec7n vi t\u00ednh ch\u1ea5t l\u01b0\u1ee3ng \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u1edbi Excel, \u0111\u1eebng qu\u00ean gh\u00e9 th\u0103m Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. T\u1ea1i \u0111\u00e2y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y nh\u1eefng s\u1ea3n ph\u1ea9m gi\u00fap n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                  L\u1ed7i #N\/A trong Excel c\u00f3 th\u1ec3 s\u1eeda b\u1eb1ng c\u00e1ch ki\u1ec3m tra l\u1ea1i ph\u1ea1m vi d\u1eef li\u1ec7u, c\u1ed1 \u0111\u1ecbnh v\u00f9ng tra c\u1ee9u v\u1edbi ph\u00edm F4, ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m IFERROR, ISNA \u0111\u1ec3 thay th\u1ebf l\u1ed7i b\u1eb1ng gi\u00e1 tr\u1ecb kh\u00e1c. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n c\u1ee7a l\u1ed7i #N\/A v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1c […]<\/p>\n","protected":false},"author":1,"featured_media":4732,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4731","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19300.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4731"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4731\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4732"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}