{"id":12170,"date":"2025-01-15T07:28:42","date_gmt":"2025-01-15T07:28:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/loi-n-a-trong-excle-loi-n-a-trong-ham-vlookup-va-hlookup\/"},"modified":"2025-01-15T07:28:42","modified_gmt":"2025-01-15T07:28:42","slug":"loi-n-a-trong-excle-loi-n-a-trong-ham-vlookup-va-hlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/loi-n-a-trong-excle-loi-n-a-trong-ham-vlookup-va-hlookup\/","title":{"rendered":"L\u00f4\u0303i #N\/A trong Excle? L\u00f4\u0303i #N\/A trong ha\u0300m VLOOKUP V\u00c0 HLOOKUP"},"content":{"rendered":"
\n

L\u1ed7i #N\/A<\/a> trong excel l\u00e0 v\u1ea5n n\u1ea1n c\u1ee7a nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng Excel, quan tr\u1ecdng l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eeda l\u1ed7i, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP ho\u1eb7c HLOOKUP.<\/p>\n

1\/ \u00dd ngh\u0129a c\u1ee7a l\u1ed7i #N\/A<\/strong><\/p>\n

Trong ti\u1ebfng Anh, N\/A l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a \u201cNo Answer\u201d ho\u1eb7c \u201cNot Available\u201d ho\u1eb7c \u201cNot Applicable\u201d, c\u00f3 ngh\u0129a l\u00e0 kh\u00f4ng c\u00f3 c\u00e2u tr\u1ea3 l\u1eddi ho\u1eb7c kh\u00f4ng t\u1ed3n t\u1ea1i c\u00e2u tr\u1ea3 l\u1eddi ph\u00f9 h\u1ee3p ho\u1eb7c kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi. Do \u0111\u00f3, l\u1ed7i #N\/A khi qua c\u00f4ng th\u1ee9c excel kh\u00f4ng th\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng th\u00edch.<\/p>\n

\u0110\u1eb7c bi\u1ec7t, l\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a> v\u00e0 h\u00e0m HLOOKUP<\/a> v\u00ec Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb theo y\u00eau c\u1ea7u t\u00ecm ki\u1ebfm. Ti\u1ebfp theo \u0111\u00e2y, ch\u00fang ta s\u1ebd \u0111i s\u00e2u v\u00e0o x\u1eed l\u00fd l\u1ed7i #N\/A khi s\u1eed d\u1ee5ng hai h\u00e0m n\u00e0y.<\/p>\n

2\/ C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A<\/strong><\/p>\n

Tr\u01b0\u1eddng h\u1ee3p 1:<\/em><\/strong> L\u1ed7i x\u1ea3y ra v\u00ec v\u1ea5n \u0111\u1ec1 \u1edf v\u00f9ng t\u00ecm ki\u1ebfm.<\/p>\n

V\u00f9ng t\u00ecm ki\u1ebfm c\u00f3 2 v\u1ea5n \u0111\u1ec1 ch\u00ednh: m\u1ed9t l\u00e0 b\u1ea1n ch\u01b0a c\u1ed1 \u0111\u1ecbnh v\u00f9ng t\u00ecm k\u1ebfm, hai l\u00e0\u00a0gi\u1edbi h\u1ea1n v\u00f9ng t\u00ecm ki\u1ebfm ch\u01b0a \u0111\u1ee7 r\u1ed9ng.<\/p>\n

Gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n l\u00e0 gi\u1edbi h\u1ea1n l\u1ea1i v\u00f9ng t\u00ecm ki\u1ebfm v\u00e0 c\u1ed1 \u0111\u1ecbng v\u00f9ng t\u00ecm ki\u1ebfm b\u1eb1ng k\u00fd t\u1ef1 \u201c$\u201d<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/a><\/p>\n

Tr\u01b0\u1eddng h\u1ee3p 2:<\/strong><\/em> L\u1ed7i x\u1ea3y ra khi k\u1ebft h\u1ee3p h\u00e0m VLOOKUP\/HLOOKUP v\u1edbi h\u00e0m LEFT, RIGHT ho\u1eb7c MID.<\/p>\n

C\u00f9ng theo d\u00f5i v\u00ed d\u1ee5 sau \u0111\u00e2y:<\/p>\n

L\u1ed7i #N\/A trong h\u00e0m VLOOKUP v\u00e0 h\u00e0m HLOOKUP<\/figcaption><\/figure>\n

Ta c\u1ea7n d\u00f9ng HLOOKUP \u0111\u1ec3 d\u00f2 T\u00caN NG\u00c0NH theo M\u00c3 NG\u00c0NH cho tr\u01b0\u1edbc:<\/p>\n