{"id":475154,"date":"2025-07-21T07:51:43","date_gmt":"2025-07-21T00:51:43","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=475154"},"modified":"2025-07-21T07:52:05","modified_gmt":"2025-07-21T00:52:05","slug":"vlookup-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/","title":{"rendered":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>VLOOKUP Excel l\u00e0 g\u00ec?<\/b><span style=\"font-weight: 400;\"> B\u1ea1n \u0111\u00e3 th\u1ef1c s\u1ef1 t\u1eadn d\u1ee5ng h\u1ebft s\u1ee9c m\u1ea1nh c\u1ee7a h\u00e0m t\u00ecm ki\u1ebfm \u201cth\u1ea7n th\u00e1nh\u201d n\u00e0y ch\u01b0a? N\u1ebfu t\u1eebng b\u1ed1i r\u1ed1i khi ph\u1ea3i t\u00ecm d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh l\u1edbn ho\u1eb7c mu\u1ed1n t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c tra c\u1ee9u th\u00f4ng tin, th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 c\u00f4ng c\u1ee5 b\u1ea1n kh\u00f4ng th\u1ec3 b\u1ecf qua. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP qua v\u00ed d\u1ee5 minh h\u1ecda \u0111\u01a1n gi\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3 nh\u00e9.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ean g\u1ecdi VLOOKUP b\u1eaft ngu\u1ed3n t\u1eeb ch\u1eef &#8220;V&#8221; trong t\u1eeb Vertical, ngh\u0129a l\u00e0 theo chi\u1ec1u d\u1ecdc, ph\u1ea3n \u00e1nh c\u00e1ch h\u00e0m ho\u1ea1t \u0111\u1ed9ng ch\u1ee7 y\u1ebfu theo c\u1ed9t d\u1ecdc \u0111\u1ec3 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb c\u1ea7n thi\u1ebft. Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u mong mu\u1ed1n trong h\u00e0ng d\u1ecdc v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng tr\u00ean h\u00e0ng ngang c\u00f9ng d\u00f2ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-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-475156 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-1.jpg\" alt=\"vlookup-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, c\u1ea7n tra c\u1ee9u nhanh ho\u1eb7c k\u1ebft n\u1ed1i th\u00f4ng tin gi\u1eefa c\u00e1c b\u1ea3ng v\u1edbi nhau. VLOOKUP c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c c\u00f4ng vi\u1ec7c nh\u01b0 \u0111\u1ed1i chi\u1ebfu danh s\u00e1ch, t\u00ecm ki\u1ebfm th\u00f4ng tin s\u1ea3n ph\u1ea9m, tra c\u1ee9u \u0111i\u1ec3m s\u1ed1 hay c\u1eadp nh\u1eadt d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng m\u00e0 kh\u00f4ng c\u1ea7n m\u1ea5t nhi\u1ec1u th\u1eddi gian t\u00ecm ki\u1ebfm th\u1ee7 c\u00f4ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1edd c\u00fa ph\u00e1p linh ho\u1ea1t, h\u00e0m n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau, t\u1eeb vi\u1ec7c t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c \u0111\u1ebfn t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m VLOOKUP s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c \u0111\u00e1ng k\u1ec3.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m VLOOKUP Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m VLOOKUP r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u x\u1eed l\u00fd d\u1eef li\u1ec7u. Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 c\u1ea5u tr\u00fac c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>=VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Lookup_value (Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm): \u0110\u00e2y l\u00e0 d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm trong b\u1ea3ng, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, ch\u1eef ho\u1eb7c tham chi\u1ebfu t\u1edbi \u00f4 trong Excel. Gi\u00e1 tr\u1ecb n\u00e0y gi\u00fap h\u00e0m bi\u1ebft c\u1ea7n tra c\u1ee9u th\u00f4ng tin d\u1ef1a tr\u00ean g\u00ec.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Table_array (V\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u): L\u00e0 ph\u1ea1m vi ch\u1ee9a b\u1ea3ng d\u1eef li\u1ec7u n\u01a1i h\u00e0m s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm. Ph\u1ea1m vi n\u00e0y ph\u1ea3i bao g\u1ed3m c\u1ed9t ch\u1ee9a Lookup_value v\u00e0 c\u00e1c c\u1ed9t ch\u1ee9a th\u00f4ng tin b\u1ea1n mu\u1ed1n l\u1ea5y. \u0110\u1ec3 tr\u00e1nh sai s\u00f3t khi sao ch\u00e9p c\u00f4ng th\u1ee9c, b\u1ea1n n\u00ean c\u1ed1 \u0111\u1ecbnh v\u00f9ng n\u00e0y b\u1eb1ng k\u00fd hi\u1ec7u $ (v\u00ed d\u1ee5: $B$2:$E$10).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Col_index_num (S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tr\u1ea3 v\u1ec1): Ch\u1ec9 s\u1ed1 c\u1ed9t trong Table_array m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. C\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng Table_array \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u \u1edf c\u1ed9t th\u1ee9 ba th\u00ec gi\u00e1 tr\u1ecb l\u00e0 3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range_lookup (Ki\u1ec3u d\u00f2 t\u00ecm): X\u00e1c \u0111\u1ecbnh c\u00e1ch d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb Lookup_value trong b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch d\u00f9ng h\u00e0m VLOOKUP Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/b><\/h2>\n<p style=\"text-align: justify;\"><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 VLOOKUP m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, k\u00e8m theo v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng v\u00e0o th\u1ef1c t\u1ebf v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng, ch\u00ednh x\u00e1c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>S\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 x\u1ebfp lo\u1ea1i h\u1ecdc sinh, sinh vi\u00ean<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh \u1edf m\u1ed9t c\u1ed9t v\u00e0 b\u1ea3ng x\u1ebfp lo\u1ea1i theo thang \u0111i\u1ec3m \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb th\u1ea5p \u0111\u1ebfn cao. V\u00ed d\u1ee5, b\u1ea3ng ph\u00e2n lo\u1ea1i n\u1eb1m trong ph\u1ea1m vi t\u1eeb \u00f4 A18 \u0111\u1ebfn B21, v\u1edbi c\u1ed9t A l\u00e0 \u0111i\u1ec3m chu\u1ea9n v\u00e0 c\u1ed9t B l\u00e0 x\u1ebfp lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-475157 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-2.jpg\" alt=\"vlookup-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, th\u01b0\u1eddng l\u00e0 \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh n\u1eb1m \u1edf c\u1ed9t C, b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng 6 tr\u1edf \u0111i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: T\u1ea1i \u00f4 D6, nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm x\u1ebfp lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng d\u1ef1a tr\u00ean \u0111i\u1ec3m. C\u00f4ng th\u1ee9c chu\u1ea9n cho t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i l\u00e0: =VLOOKUP($C6,$A$18:$B$21,2,1). N\u1ebfu mu\u1ed1n k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i, thay s\u1ed1 1 b\u1eb1ng 0.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-475158 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-3.jpg\" alt=\"vlookup-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 x\u1ebfp lo\u1ea1i cho h\u1ecdc sinh \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: S\u1eed d\u1ee5ng \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 D6, k\u00e9o xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c h\u1ecdc sinh c\u00f2n l\u1ea1i trong danh s\u00e1ch. Vi\u1ec7c n\u00e0y gi\u00fap t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng x\u1ebfp lo\u1ea1i cho to\u00e0n b\u1ed9 h\u1ecdc sinh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475159 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-4.jpg\" alt=\"vlookup-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: Ki\u1ec3m tra k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o h\u00e0m \u0111\u00e3 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, t\u1ea5t c\u1ea3 c\u00e1c h\u1ecdc sinh \u0111\u1ec1u c\u00f3 x\u1ebfp lo\u1ea1i ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec3m s\u1ed1 c\u1ee7a m\u00ecnh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475160 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-5.jpg\" alt=\"vlookup-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>S\u1eed d\u1ee5ng VLOOKUP d\u00f2 t\u00ecm tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb hai b\u1ea3ng d\u1eef li\u1ec7u trong <\/span><b>VLOOKUP Excel<\/b><span style=\"font-weight: 400;\"> g\u1ed3m b\u1ea3ng \u0111\u1ea7u ti\u00ean g\u1ed3m m\u00e3 nh\u00e2n vi\u00ean, t\u00ean v\u00e0 ch\u1ee9c v\u1ee5. B\u1ea3ng th\u1ee9 hai ch\u1ee9a m\u00e3 nh\u00e2n vi\u00ean, qu\u00ea qu\u00e1n v\u00e0 tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n. M\u00e3 nh\u00e2n vi\u00ean s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb kh\u00f3a \u0111\u1ec3 d\u00f2 t\u00ecm.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475161 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-6.jpg\" alt=\"vlookup-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111i\u1ec1n th\u00f4ng tin qu\u00ea qu\u00e1n (v\u00ed d\u1ee5 \u00f4 D4), nh\u1eadp c\u00f4ng th\u1ee9c sau: =VLOOKUP($A4,$A$16:$C$25,2,0). Trong \u0111\u00f3, $A4 l\u00e0 m\u00e3 nh\u00e2n vi\u00ean c\u1ea7n t\u00ecm, ph\u1ea1m vi $A$16:$C$25 l\u00e0 b\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u tham chi\u1ebfu, s\u1ed1 2 ch\u1ec9 c\u1ed9t ch\u1ee9a qu\u00ea qu\u00e1n, c\u00f2n s\u1ed1 0 \u0111\u1ea3m b\u1ea3o d\u00f2 t\u00ecm tuy\u1ec7t \u0111\u1ed1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 nh\u00e2n vi\u00ean t\u1ea1i \u00f4 A4.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475162 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-7.jpg\" alt=\"vlookup-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 D4, khi xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng nh\u1ecf, k\u00e9o xu\u1ed1ng h\u1ebft danh s\u00e1ch nh\u00e2n vi\u00ean \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi. C\u00e1ch n\u00e0y gi\u00fap t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u cho to\u00e0n b\u1ed9 b\u1ea3ng nhanh ch\u00f3ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475163 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-8.jpg\" alt=\"vlookup-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: T\u01b0\u01a1ng t\u1ef1, t\u1ea1i \u00f4 E4 \u0111\u1ec3 l\u1ea5y tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n, nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP($A4,$A$16:$C$25,3,0). S\u1ed1 3 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t ch\u1ee9a tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n trong b\u1ea3ng tham chi\u1ebfu.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475164 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-9.jpg\" alt=\"vlookup-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: Nh\u1ea5n Enter, sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng h\u1ebft danh s\u00e1ch nh\u01b0 b\u01b0\u1edbc tr\u01b0\u1edbc \u0111\u1ec3 ho\u00e0n th\u00e0nh vi\u1ec7c nh\u1eadp li\u1ec7u cho to\u00e0n b\u1ed9 nh\u00e2n vi\u00ean.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475165 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-10.jpg\" alt=\"vlookup-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>D\u00f9ng h\u00e0m VLOOKUP Excel tr\u00ean 2 sheet kh\u00e1c nhau<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i sheet ch\u1ee9a danh s\u00e1ch nh\u00e2n vi\u00ean (g\u1ecdi l\u00e0 Sheet1), ch\u1ecdn \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, v\u00ed d\u1ee5 \u00f4 E3. \u0110\u00e2y l\u00e0 n\u01a1i s\u1ebd hi\u1ec3n th\u1ecb m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean ch\u1ee9c v\u1ee5.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475166 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-11.jpg\" alt=\"vlookup-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP, b\u1eaft \u0111\u1ea7u b\u1eb1ng tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm tr\u00ean Sheet1, k\u1ebft h\u1ee3p v\u1edbi v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu tr\u00ean Sheet2 ch\u1ee9a m\u00e3 ch\u1ee9c v\u1ee5 v\u00e0 m\u1ee9c l\u01b0\u01a1ng. C\u1ee5 th\u1ec3: =VLOOKUP(Sheet1!D3, Sheet2!$A$3:$B$7, 2, 0). Trong \u0111\u00f3, Sheet1!D3 l\u00e0 m\u00e3 ch\u1ee9c v\u1ee5 nh\u00e2n vi\u00ean, ph\u1ea1m vi Sheet2!$A$3:$B$7 l\u00e0 b\u1ea3ng tham chi\u1ebfu, s\u1ed1 2 ch\u1ec9 c\u1ed9t ch\u1ee9a l\u01b0\u01a1ng, c\u00f2n 0 \u0111\u1ea3m b\u1ea3o d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475167 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-12.jpg\" alt=\"vlookup-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 cho nh\u00e2n vi\u00ean \u0111\u1ea7u ti\u00ean. B\u1ea1n s\u1ebd th\u1ea5y m\u1ee9c l\u01b0\u01a1ng ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u1ee9ng v\u1edbi ch\u1ee9c v\u1ee5 hi\u1ec3n th\u1ecb t\u1ea1i \u00f4 E3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475168 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-13.jpg\" alt=\"vlookup-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: S\u1eed d\u1ee5ng \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i d\u01b0\u1edbi c\u1ee7a \u00f4 E3, k\u00e9o xu\u1ed1ng \u0111\u1ebfn \u00f4 E8 \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i. K\u1ebft qu\u1ea3 m\u1ee9c l\u01b0\u01a1ng cho t\u1eebng ng\u01b0\u1eddi s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1ef1a tr\u00ean ch\u1ee9c v\u1ee5 c\u1ee7a h\u1ecd.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475169 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-14.jpg\" alt=\"vlookup-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>D\u00f9ng VLOOKUP \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1o b\u1ea3ng m\u1edbi \u1edf v\u1ecb tr\u00ed F15:G18 trong <\/span><b>VLOOKUP Excel<\/b><span style=\"font-weight: 400;\">, trong \u0111\u00f3 c\u1ed9t F ch\u1ee9a t\u00ean nh\u00e2n vi\u00ean c\u1ea7n t\u00ecm ki\u1ebfm, c\u00f2n c\u1ed9t G s\u1ebd d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 qu\u00ea qu\u00e1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i \u00f4 G16, nh\u1eadp c\u00f4ng th\u1ee9c d\u00f2 t\u00ecm tuy\u1ec7t \u0111\u1ed1i nh\u01b0 sau: <\/span><span style=\"font-weight: 400;\">=VLOOKUP($F16,$B$3:$E$13,3,0). <\/span><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y, $F16 l\u00e0 t\u00ean nh\u00e2n vi\u00ean c\u1ea7n tra c\u1ee9u, v\u00f9ng $B$3:$E$13 l\u00e0 ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a th\u00f4ng tin nh\u00e2n vi\u00ean, c\u1ed9t th\u1ee9 3 trong ph\u1ea1m vi l\u00e0 n\u01a1i ch\u1ee9a qu\u00ea qu\u00e1n. Tham s\u1ed1 cu\u1ed1i c\u00f9ng l\u00e0 0 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm ph\u1ea3i ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/span><span style=\"font-weight: 400;\">\u00a0Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 cho nh\u00e2n vi\u00ean \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475170 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-15.jpg\" alt=\"vlookup-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: S\u1eed d\u1ee5ng \u0111i\u1ec3m vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i d\u01b0\u1edbi c\u1ee7a \u00f4 G16, k\u00e9o xu\u1ed1ng hai \u00f4 c\u00f2n l\u1ea1i \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 t\u1ef1 \u0111\u1ed9ng l\u1ea5y d\u1eef li\u1ec7u cho nh\u1eefng ng\u01b0\u1eddi c\u00f2n l\u1ea1i.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475171 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-16.jpg\" alt=\"vlookup-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: V\u00ec gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm (t\u00ean nh\u00e2n vi\u00ean) n\u1eb1m \u1edf c\u1ed9t B c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c, v\u00f9ng d\u00f2 t\u00ecm ph\u1ea3i b\u1eaft \u0111\u1ea7u t\u1eeb c\u1ed9t B ch\u1ee9 kh\u00f4ng ph\u1ea3i c\u1ed9t A. \u0110i\u1ec1u n\u00e0y gi\u00fap h\u00e0m VLOOKUP ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, tr\u00e1nh l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u01b0ng c\u0169ng d\u1ec5 g\u00e2y ra m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn khi s\u1eed d\u1ee5ng. Hi\u1ec3u r\u00f5 c\u00e1c v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh sai s\u00f3t, n\u00e2ng cao hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c khi truy xu\u1ea5t d\u1eef li\u1ec7u trong Excel. Ph\u1ea7n n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p nh\u1eefng l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nhanh ch\u00f3ng, gi\u00fap qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #NAME?<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i #NAME? l\u00e0 m\u1ed9t trong nh\u1eefng v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi thao t\u00e1c v\u1edbi h\u00e0m VLOOKUP trong Excel. Nguy\u00ean nh\u00e2n ch\u1ee7 y\u1ebfu c\u1ee7a t\u00ecnh tr\u1ea1ng n\u00e0y th\u01b0\u1eddng xu\u1ea5t ph\u00e1t t\u1eeb vi\u1ec7c tham s\u1ed1 Lookup_value ch\u01b0a \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang c\u00e1ch. C\u1ee5 th\u1ec3, khi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm l\u00e0 d\u1ea1ng v\u0103n b\u1ea3n, n\u1ebfu b\u1ea1n nh\u1eadp tr\u1ef1c ti\u1ebfp m\u00e0 kh\u00f4ng bao quanh b\u1eb1ng d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c\u201d), Excel s\u1ebd kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c v\u00e0 b\u00e1o l\u1ed7i. \u0110i\u1ec1u n\u00e0y khi\u1ebfn c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong mu\u1ed1n v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i #NAME? thay v\u00ec k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475172 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-17.jpg\" alt=\"vlookup-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng tr\u00ean, b\u1ea1n c\u1ea7n l\u01b0u \u00fd r\u1eb1ng t\u1ea5t c\u1ea3 chu\u1ed7i k\u00fd t\u1ef1 v\u0103n b\u1ea3n khi nh\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c \u0111\u1ec1u ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5, n\u1ebfu mu\u1ed1n t\u00ecm ki\u1ebfm t\u00ean \u201cNguy\u1ec5n V\u0103n A\u201d trong b\u1ea3ng d\u1eef li\u1ec7u, c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c ph\u1ea3i l\u00e0 =VLOOKUP(&#8220;Nguy\u1ec5n V\u0103n A&#8221;, ph\u1ea1m_vi, c\u1ed9t_tr\u1ea3_v\u1ec1, 0). Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, v\u00ed d\u1ee5 nh\u01b0 \u00f4 A2, th\u00ec kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c k\u00e9p b\u1edfi Excel \u0111\u00e3 hi\u1ec3u \u0111\u00f3 l\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 h\u1ee3p l\u1ec7.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #N\/A<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i #N\/A<\/span><b>\u00a0<\/b><span style=\"font-weight: 400;\">th\u01b0\u1eddng x\u1ea3y ra khi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng n\u1eb1m trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu (Table_array). Khi g\u1eb7p t\u00ecnh tr\u1ea1ng n\u00e0y, h\u00e0m s\u1ebd kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c m\u00e0 thay v\u00e0o \u0111\u00f3 hi\u1ec3n th\u1ecb l\u1ed7i #N\/A. \u0110\u1ec3 x\u1eed l\u00fd, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m MATCH c\u00f9ng h\u00e0m INDEX nh\u1eb1m t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n, kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi v\u1ecb tr\u00ed c\u1ed9t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475173 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-18.jpg\" alt=\"vlookup-excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, l\u1ed7i n\u00e0y c\u00f2n xu\u1ea5t hi\u1ec7n khi trong v\u00f9ng tham chi\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm. Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, vi\u1ec7c d\u00f9ng h\u00e0m IFERROR s\u1ebd gi\u00fap thay th\u1ebf l\u1ed7i #N\/A b\u1eb1ng m\u1ed9t th\u00f4ng b\u00e1o ho\u1eb7c gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn, t\u1eeb \u0111\u00f3 c\u1ea3i thi\u1ec7n t\u00ednh th\u1ea9m m\u1ef9 v\u00e0 d\u1ec5 \u0111\u1ecdc c\u1ee7a b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 thay l\u1ed7i b\u1eb1ng d\u00f2ng ch\u1eef \u201cKh\u00f4ng t\u00ecm th\u1ea5y\u201d ho\u1eb7c gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh kh\u00e1c ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch b\u00e1o c\u00e1o.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n ch\u1eafc ch\u1eafn b\u1ea3ng d\u1eef li\u1ec7u tham chi\u1ebfu c\u00f3 ch\u1ee9a th\u00f4ng tin c\u1ea7n t\u00ecm nh\u01b0ng h\u00e0m v\u1eabn kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3, c\u1ea7n ki\u1ec3m tra k\u1ef9 c\u00e1c \u00f4 li\u00ean quan. M\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c ho\u1eb7c kho\u1ea3ng tr\u1eafng \u1ea9n b\u00ean trong \u00f4, g\u00e2y c\u1ea3n tr\u1edf qu\u00e1 tr\u00ecnh d\u00f2 t\u00ecm ch\u00ednh x\u00e1c. Ngo\u00e0i ra, vi\u1ec7c d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t v\u1ec1 \u0111\u1ecbnh d\u1ea1ng c\u0169ng l\u00e0m h\u00e0m VLOOKUP ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng \u0111\u00fang, nh\u01b0 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ki\u1ec3u v\u0103n b\u1ea3n v\u00e0 s\u1ed1.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #REF!<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i #REF! trong <\/span><b>VLOOKUP Excel<\/b><span style=\"font-weight: 400;\"> g\u00e2y ra s\u1ef1 gi\u00e1n \u0111o\u1ea1n trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u. Nguy\u00ean nh\u00e2n ch\u1ee7 y\u1ebfu d\u1eabn \u0111\u1ebfn l\u1ed7i n\u00e0y l\u00e0 khi tham s\u1ed1 Col_index_num \u2014 t\u1ee9c s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t c\u1ea7n tr\u1ea3 v\u1ec1 \u2014 v\u01b0\u1ee3t qu\u00e1 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t c\u00f3 trong ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u tham chi\u1ebfu (Table_array). Khi \u0111\u00f3, Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u1ed9t c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u, n\u00ean t\u1ef1 \u0111\u1ed9ng b\u00e1o l\u1ed7i.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475174 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-19.jpg\" alt=\"vlookup-excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, b\u01b0\u1edbc \u0111\u1ea7u b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c VLOOKUP \u0111\u00e3 nh\u1eadp, \u0111\u1eb7c bi\u1ec7t l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a Col_index_num. Th\u00f4ng th\u01b0\u1eddng, s\u1ed1 n\u00e0y ph\u1ea3i n\u1eb1m trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn t\u1ed5ng s\u1ed1 c\u1ed9t c\u00f3 trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn l\u00e0m b\u1ea3ng d\u00f2 t\u00ecm. V\u00ed d\u1ee5, n\u1ebfu b\u1ea3ng tham chi\u1ebfu c\u00f3 4 c\u1ed9t, th\u00ec gi\u00e1 tr\u1ecb Col_index_num ph\u1ea3i b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n 4. N\u1ebfu v\u01b0\u1ee3t qu\u00e1, Excel s\u1ebd kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u \u0111\u00fang c\u00e1ch v\u00e0 hi\u1ec3n th\u1ecb l\u1ed7i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #VALUE!<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n ch\u00ednh g\u00e2y ra v\u1ea5n \u0111\u1ec1 n\u00e0y th\u01b0\u1eddng li\u00ean quan \u0111\u1ebfn tham s\u1ed1 Col_index_num trong c\u00f4ng th\u1ee9c kh\u00f4ng h\u1ee3p l\u1ec7. C\u1ee5 th\u1ec3, n\u1ebfu gi\u00e1 tr\u1ecb c\u1ee7a Col_index_num nh\u1ecf h\u01a1n 1, Excel s\u1ebd kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n tr\u1ea3 v\u1ec1, t\u1eeb \u0111\u00f3 sinh ra l\u1ed7i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong c\u1ea5u tr\u00fac h\u00e0m VLOOKUP, c\u1ed9t \u0111\u1ea7u ti\u00ean trong v\u00f9ng tham chi\u1ebfu (Table_array) \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 l\u00e0 1 v\u00e0 \u0111\u00e2y ch\u00ednh l\u00e0 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u1ec3 d\u00f2 t\u00ecm. C\u1ed9t th\u1ee9 hai s\u1ebd c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 2, t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean ph\u1ea3i c\u1ed9t t\u00ecm ki\u1ebfm, ti\u1ebfp theo l\u00e0 c\u1ed9t th\u1ee9 ba, th\u1ee9 t\u01b0,&#8230; Do \u0111\u00f3, khi ch\u1ec9 \u0111\u1ecbnh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tr\u1ea3 v\u1ec1 trong h\u00e0m, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o con s\u1ed1 n\u00e0y l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean d\u01b0\u01a1ng, t\u1eeb 1 tr\u1edf l\u00ean.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475175 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-20.jpg\" alt=\"vlookup-excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu trong qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n v\u00f4 t\u00ecnh \u0111\u1eb7t Col_index_num b\u1eb1ng 0 ho\u1eb7c s\u1ed1 \u00e2m, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c thi v\u00e0 b\u00e1o l\u1ed7i #VALUE!. Ngo\u00e0i ra, khi tham s\u1ed1 n\u00e0y kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 m\u00e0 \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i hay ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng h\u1ee3p l\u1ec7 c\u0169ng s\u1ebd g\u00e2y ra l\u1ed7i t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u1ea7n ki\u1ec3m tra k\u1ef9 ph\u1ea7n tham s\u1ed1 c\u1ee7a c\u00f4ng th\u1ee9c, \u0111\u1eb7c bi\u1ec7t l\u00e0 gi\u00e1 tr\u1ecb ch\u1ec9 s\u1ed1 c\u1ed9t. N\u1ebfu c\u1ea7n, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m ISNUMBER ho\u1eb7c c\u00e1c ph\u01b0\u01a1ng ph\u00e1p ki\u1ec3m tra kh\u00e1c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o gi\u00e1 tr\u1ecb nh\u1eadp v\u00e0o lu\u00f4n h\u1ee3p l\u1ec7. Vi\u1ec7c tu\u00e2n th\u1ee7 \u0111\u00fang quy t\u1eafc n\u00e0y s\u1ebd gi\u00fap h\u00e0m VLOOKUP ho\u1ea1t \u0111\u1ed9ng tr\u01a1n tru v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, tr\u00e1nh nh\u1eefng gi\u00e1n \u0111o\u1ea1n kh\u00f4ng mong mu\u1ed1n trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP Excel v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel gi\u00fap m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u, t\u0103ng t\u00ednh linh ho\u1ea1t v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. Ph\u1ea7n n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch \u00e1p d\u1ee5ng k\u1ebft h\u1ee3p \u0111\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a VLOOKUP trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP v\u00e0 h\u00e0m IF<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP v\u00e0 h\u00e0m IF l\u00e0 hai c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong Excel, khi k\u1ebft h\u1ee3p s\u1ebd m\u1edf r\u1ed9ng \u0111\u00e1ng k\u1ec3 kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 ra quy\u1ebft \u0111\u1ecbnh th\u00f4ng minh. Vi\u1ec7c l\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0o trong VLOOKUP ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i t\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3 c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. Khi \u0111\u1eb7t IF v\u00e0o v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm ho\u1eb7c ph\u1ea1m vi b\u1ea3ng gi\u1edbi h\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t ki\u1ec3m so\u00e1t \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu l\u1ed3ng VLOOKUP v\u00e0o b\u00ean trong IF, h\u00e0m d\u00f2 t\u00ecm s\u1ebd \u0111\u00f3ng vai tr\u00f2 nh\u01b0 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p ki\u1ec3m tra logic.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, khi t\u00ednh h\u1ecdc ph\u00ed cho sinh vi\u00ean theo di\u1ec7n \u0111\u00f3ng v\u00e0 ng\u00e0nh h\u1ecdc, m\u1ed7i lo\u1ea1i sinh vi\u00ean s\u1ebd c\u00f3 m\u1ee9c ph\u00ed kh\u00e1c nhau. \u1ede \u0111\u00e2y, h\u00e0m IF gi\u00fap x\u00e1c \u0111\u1ecbnh di\u1ec7n \u0111\u00f3ng h\u1ecdc ph\u00ed, c\u00f2n VLOOKUP tra c\u1ee9u m\u1ee9c h\u1ecdc ph\u00ed t\u01b0\u01a1ng \u1ee9ng theo ng\u00e0nh h\u1ecdc trong b\u1ea3ng d\u1eef li\u1ec7u. Vi\u1ec7c \u00e1p d\u1ee5ng \u0111\u00fang c\u00e1ch s\u1ebd gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, gi\u1ea3m thi\u1ec3u sai s\u00f3t v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475176 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-21.jpg\" alt=\"vlookup-excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c \u0111i\u1ec3n h\u00ecnh trong \u00f4 E2 s\u1ebd k\u1ebft h\u1ee3p c\u1ea3 hai h\u00e0m \u0111\u1ec3 d\u1ef1a v\u00e0o di\u1ec7n \u0111\u00f3ng v\u00e0 ng\u00e0nh h\u1ecdc x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c s\u1ed1 ti\u1ec1n c\u1ea7n thanh to\u00e1n. T\u00f9y thu\u1ed9c v\u00e0o c\u1ea5u tr\u00fac d\u1eef li\u1ec7u v\u00e0 y\u00eau c\u1ea7u b\u00e0i to\u00e1n, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u1ecb tr\u00ed l\u1ed3ng gh\u00e9p sao cho h\u1ee3p l\u00fd nh\u1ea5t nh\u1eb1m \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1i \u01b0u.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP v\u00e0 h\u00e0m SUM<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m <\/span>VLOOKUP <span style=\"font-weight: 400;\">k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m SUM t\u1ea1o n\u00ean c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 t\u00ednh to\u00e1n trong Excel. S\u1ef1 ph\u1ed1i h\u1ee3p n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi c\u1ea7n t\u00ednh t\u1ed5ng m\u1ed9t ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm trong b\u1ea3ng d\u1eef li\u1ec7u. Th\u00f4ng th\u01b0\u1eddng, h\u00e0m SUM s\u1ebd n\u1eb1m trong ph\u1ea7n gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm c\u1ee7a VLOOKUP, gi\u00fap x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c m\u1ee5c ti\u00eau d\u1ef1a tr\u00ean t\u1ed5ng h\u1ee3p c\u00e1c con s\u1ed1 c\u00f3 li\u00ean quan.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ea5u tr\u00fac ph\u1ed5 bi\u1ebfn khi s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y c\u00f3 d\u1ea1ng: =VLOOKUP(SUM(a;b;&#8230;), Table_array, Col_index_num, Range_lookup). Trong \u0111\u00f3, h\u00e0m SUM th\u1ef1c hi\u1ec7n c\u1ed9ng c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn, sau \u0111\u00f3 k\u1ebft qu\u1ea3 t\u1ed5ng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm cho h\u00e0m VLOOKUP trong b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 \u0111\u1ecbnh s\u1eb5n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475177 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-22.jpg\" alt=\"vlookup-excel-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n th\u01b0\u1edfng c\u1ee7a nh\u00e2n vi\u00ean d\u1ef1a tr\u00ean t\u1ed5ng s\u1ed1 h\u00e0ng l\u00e0m \u0111\u01b0\u1ee3c trong hai qu\u00fd \u0111\u1ea7u n\u0103m. Gi\u1ea3 s\u1eed, c\u1ed9t B v\u00e0 C ch\u1ee9a s\u1ed1 h\u00e0ng c\u1ee7a qu\u00fd 1 v\u00e0 qu\u00fd 2, h\u00e0m SUM s\u1ebd c\u1ed9ng hai gi\u00e1 tr\u1ecb n\u00e0y \u0111\u1ec3 t\u1ea1o ra t\u1ed5ng s\u1ed1 h\u00e0ng ho\u00e0n th\u00e0nh. Ti\u1ebfp \u0111\u00f3, VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm t\u1ed5ng s\u1ed1 n\u00e0y trong b\u1ea3ng th\u01b0\u1edfng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ee9c ti\u1ec1n th\u01b0\u1edfng t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c cho \u00f4 D2 s\u1ebd l\u00e0: =VLOOKUP(SUM(B2;C2);$A$9:$B$11;2;0), trong \u0111\u00f3 b\u1ea3ng $A$9:$B$11 ch\u1ee9a m\u1ed1c t\u1ed5ng h\u00e0ng v\u00e0 ti\u1ec1n th\u01b0\u1edfng t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP Excel v\u00e0 h\u00e0m LEFT\/RIGHT<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi LEFT ho\u1eb7c RIGHT gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n khi c\u1ea7n tr\u00edch xu\u1ea5t th\u00f4ng tin t\u1eeb m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n. C\u00e1c h\u00e0m LEFT v\u00e0 RIGHT cho ph\u00e9p t\u00e1ch ra m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i, sau \u0111\u00f3 d\u00f9ng k\u1ebft qu\u1ea3 \u0111\u00f3 l\u00e0m \u0111\u1ea7u v\u00e0o cho h\u00e0m VLOOKUP \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m LEFT v\u00e0 RIGHT nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(a;b) \u2014 L\u1ea5y b k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i a.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=RIGHT(a;b) \u2014 L\u1ea5y b k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i a.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p k\u1ebft h\u1ee3p v\u1edbi VLOOKUP, hai h\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf ph\u1ea7n gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm. T\u1ee9c l\u00e0 ta s\u1ebd d\u00f9ng m\u1ed9t ph\u1ea7n chu\u1ed7i l\u00e0m kh\u00f3a t\u00ecm ki\u1ebfm thay v\u00ec to\u00e0n b\u1ed9 chu\u1ed7i. C\u00f4ng th\u1ee9c th\u01b0\u1eddng d\u00f9ng c\u00f3 d\u1ea1ng:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=VLOOKUP(LEFT(a;b), Table_array, Col_index_num, Range_lookup)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=VLOOKUP(RIGHT(a;b), Table_array, Col_index_num, Range_lookup)<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475178 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-23.jpg\" alt=\"vlookup-excel-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, n\u1ebfu m\u00e3 sinh vi\u00ean ch\u1ee9a m\u00e3 ng\u00e0nh \u1edf 4 k\u00fd t\u1ef1 \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch ph\u1ea7n \u0111\u00f3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh t\u00ean ng\u00e0nh h\u1ecdc. C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C2 s\u1ebd l\u00e0: =VLOOKUP(LEFT(A2;4);$A$8:$B$10;2;0). Trong \u0111\u00f3, LEFT(A2;4) l\u1ea5y 4 k\u00fd t\u1ef1 \u0111\u1ea7u trong m\u00e3 sinh vi\u00ean, d\u00f9ng l\u00e0m gi\u00e1 tr\u1ecb \u0111\u1ec3 d\u00f2 t\u00ecm trong b\u1ea3ng m\u00e3 ng\u00e0nh. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 t\u00ean ng\u00e0nh h\u1ecdc t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP v\u00e0 h\u00e0m CHOOSE<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m CHOOSE khi k\u1ebft h\u1ee3p v\u1edbi <\/span><b>VLOOKUP Excel <\/b><span style=\"font-weight: 400;\">m\u1edf ra kh\u1ea3 n\u0103ng x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p li\u00ean quan \u0111\u1ebfn tra c\u1ee9u nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Thay v\u00ec ch\u1ec9 d\u00f2 theo m\u1ed9t c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng CHOOSE \u0111\u1ec3 t\u1ea1o m\u1ed9t m\u1ea3ng t\u1ea1m g\u1ed3m nhi\u1ec1u c\u1ed9t ho\u1eb7c k\u1ebft h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb nhi\u1ec1u v\u00f9ng kh\u00e1c nhau. Trong c\u00f4ng th\u1ee9c, CHOOSE th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed b\u1ea3ng d\u00f2 (Table_array) \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u00f9y ch\u1ec9nh theo y\u00eau c\u1ea7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p th\u00f4ng d\u1ee5ng nh\u01b0 sau: =VLOOKUP(Lookup_value; CHOOSE({1;2}; v\u00f9ng_1; v\u00f9ng_2); col_index_num; range_lookup). Trong \u0111\u00f3, CHOOSE({1;2}; v\u00f9ng_1; v\u00f9ng_2) t\u1ea1o ra m\u1ed9t b\u1ea3ng g\u1ed3m hai c\u1ed9t, l\u1ea7n l\u01b0\u1ee3t l\u00e0 v\u00f9ng_1 v\u00e0 v\u00f9ng_2. N\u1ebfu v\u00f9ng_1 ch\u1ee9a kh\u00f3a t\u00ecm ki\u1ebfm v\u00e0 v\u00f9ng_2 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y, th\u00ec h\u00e0m s\u1ebd ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng nh\u01b0 VLOOKUP th\u00f4ng th\u01b0\u1eddng nh\u01b0ng v\u1edbi b\u1ea3ng \u0111\u01b0\u1ee3c t\u1ea1o \u0111\u1ed9ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-24-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475179 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-24.jpg\" alt=\"vlookup-excel-24\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 th\u1ef1c t\u1ebf: B\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh m\u1ee9c gi\u00e1 s\u1ea3n ph\u1ea9m t\u1ea1i \u00f4 B14 d\u1ef1a tr\u00ean t\u00ean m\u1eb7t h\u00e0ng (B12) v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t (B13). V\u00ec th\u00f4ng tin t\u00ecm ki\u1ebfm c\u1ea7n d\u1ef1a v\u00e0o c\u1ea3 hai ti\u00eau ch\u00ed k\u1ebft h\u1ee3p, b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f2 theo m\u1ed9t c\u1ed9t duy nh\u1ea5t.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Do \u0111\u00f3, d\u00f9ng h\u00e0m CHOOSE \u0111\u1ec3 n\u1ed1i t\u00ean s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng th\u00e0nh kh\u00f3a t\u00ecm ki\u1ebfm, \u0111\u1ed3ng th\u1eddi t\u1ea1o b\u1ea3ng d\u00f2 c\u0169ng theo c\u00e1ch n\u1ed1i t\u01b0\u01a1ng t\u1ef1. C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 B14 l\u00e0: =VLOOKUP(B12&amp;B13;CHOOSE({1;2};$A$2:$A$10&amp;$B$2:$B$10;$C$2:$C$10);2;0)<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m VLOOKUP v\u00e0 h\u00e0m MID<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MID trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i con t\u1eeb gi\u1eefa m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c, d\u1ef1a tr\u00ean v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u v\u00e0 \u0111\u1ed9 d\u00e0i k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y. Kh\u00e1c v\u1edbi LEFT (l\u1ea5y t\u1eeb \u0111\u1ea7u) v\u00e0 RIGHT (l\u1ea5y t\u1eeb cu\u1ed1i), MID cho ph\u00e9p linh ho\u1ea1t l\u1ef1a ch\u1ecdn ph\u1ea7n c\u1ea7n c\u1eaft t\u1eeb b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong chu\u1ed7i. C\u00fa ph\u00e1p \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a h\u00e0m n\u00e0y l\u00e0: <\/span><b>=MID(a; b; c)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">a l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c \u0111\u1ecba ch\u1ec9 \u00f4 c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">b l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u (t\u00ednh t\u1eeb tr\u00e1i sang ph\u1ea3i)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">c l\u00e0 s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n tr\u00edch xu\u1ea5t<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m VLOOKUP, MID th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1ea1i v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p m\u00e3 s\u1ed1 ho\u1eb7c chu\u1ed7i d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin l\u1ed3ng gh\u00e9p.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-25-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475180 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-25.jpg\" alt=\"vlookup-excel-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t: =VLOOKUP(MID(a; b; c); Table_array; Col_index_num; Range_lookup)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 danh s\u00e1ch sinh vi\u00ean v\u1edbi m\u00e3 s\u1ed1 g\u1ed3m nhi\u1ec1u ph\u1ea7n, trong \u0111\u00f3 v\u1ecb tr\u00ed t\u1eeb k\u00fd t\u1ef1 th\u1ee9 4 \u0111\u1ebfn th\u1ee9 7 \u0111\u1ea1i di\u1ec7n cho m\u00e3 ng\u00e0nh h\u1ecdc. B\u1ea1n c\u1ea7n l\u1ea5y ph\u1ea7n n\u00e0y \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ng\u00e0nh t\u01b0\u01a1ng \u1ee9ng th\u00f4ng qua b\u1ea3ng tra m\u00e3 ng\u00e0nh. Khi \u0111\u00f3, h\u00e0m MID s\u1ebd t\u00e1ch 4 k\u00fd t\u1ef1 \u1edf gi\u1eefa m\u00e3 sinh vi\u00ean, r\u1ed3i VLOOKUP d\u00f9ng \u0111o\u1ea1n m\u00e3 n\u00e0y \u0111\u1ec3 tra trong b\u1ea3ng. C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C2 s\u1ebd l\u00e0: =VLOOKUP(MID(A2;4;4); $A$8:$B$10; 2; 0)<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 m\u1ed9t s\u1ed1 nguy\u00ean t\u1eafc quan tr\u1ecdng. Tr\u01b0\u1edbc h\u1ebft, gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 b\u1eaft bu\u1ed9c ph\u1ea3i n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1eaft bu\u1ed9c \u0111\u1ec3 h\u00e0m ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang c\u00e1ch. N\u1ebfu kh\u00f4ng tu\u00e2n th\u1ee7, h\u00e0m s\u1ebd kh\u00f4ng th\u1ec3 t\u00ecm ra d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft, d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 sai ho\u1eb7c l\u1ed7i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u1edf c\u1ed9t d\u00f2, VLOOKUP ch\u1ec9 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean, b\u1ecf qua c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p ph\u00eda sau. \u0110\u00e2y l\u00e0 h\u1ea1n ch\u1ebf m\u00e0 b\u1ea1n c\u1ea7n l\u01b0u \u00fd, nh\u1ea5t l\u00e0 khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c c\u00f3 t\u00ednh l\u1eb7p cao.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-26.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-26-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/vlookup-excel-26-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-475181 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-26.jpg\" alt=\"vlookup-excel-26\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-26.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-26-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel-26-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1eb7c bi\u1ec7t, h\u00e0m VLOOKUP kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng, n\u00ean khi tra c\u1ee9u v\u0103n b\u1ea3n, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o n\u1ed9i dung d\u1eef li\u1ec7u th\u1ed1ng nh\u1ea5t \u0111\u1ec3 tr\u00e1nh sai l\u1ec7ch kh\u00f4ng mong mu\u1ed1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t \u0111i\u1ec3m quan tr\u1ecdng kh\u00e1c l\u00e0 h\u00e0m kh\u00f4ng th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c c\u1ed9t n\u1eb1m b\u00ean tr\u00e1i c\u1ed9t d\u00f2, v\u00ec n\u00f3 ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng theo chi\u1ec1u t\u1eeb tr\u00e1i sang ph\u1ea3i. N\u1ebfu b\u1ea1n c\u1ea7n tra t\u1eeb ph\u1ea3i sang tr\u00e1i, n\u00ean d\u00f9ng INDEX k\u1ebft h\u1ee3p MATCH.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP Excel l\u00e0 c\u00f4ng c\u1ee5 tra c\u1ee9u m\u1ea1nh m\u1ebd, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3. Vi\u1ec7c th\u00e0nh th\u1ea1o VLOOKUP kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c trong c\u00f4ng vi\u1ec7c, \u0111\u1eb7c bi\u1ec7t v\u1edbi nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean thao t\u00e1c v\u1edbi d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c b\u1ea3ng t\u00ednh chuy\u00ean s\u00e2u.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/trong-excel-co-nghia-la-gi\/\"><strong>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec? C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match-excel\/\"><strong>H\u00e0m MATCH l\u00e0 g\u00ec? V\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n n\u1eafm v\u1eefng h\u00e0m MATCH trong Excel<\/strong><\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP Excel l\u00e0 g\u00ec? B\u1ea1n \u0111\u00e3 th\u1ef1c s\u1ef1 t\u1eadn d\u1ee5ng h\u1ebft s\u1ee9c m\u1ea1nh c\u1ee7a h\u00e0m t\u00ecm ki\u1ebfm \u201cth\u1ea7n th\u00e1nh\u201d n\u00e0y ch\u01b0a? N\u1ebfu t\u1eebng b\u1ed1i r\u1ed1i khi ph\u1ea3i t\u00ecm d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh l\u1edbn ho\u1eb7c mu\u1ed1n t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c tra c\u1ee9u th\u00f4ng tin, th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 c\u00f4ng c\u1ee5 b\u1ea1n kh\u00f4ng th\u1ec3 b\u1ecf qua. [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":475155,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-475154","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>H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, v\u00ed d\u1ee5 minh h\u1ecda<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m 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\/vlookup-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m kh\u00e1c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\" \/>\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=\"2025-07-21T00:51:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-21T00:52:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.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=\"Daisy Daisy\" \/>\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=\"Daisy Daisy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"28 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\/vlookup-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30\"},\"headline\":\"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\",\"datePublished\":\"2025-07-21T00:51:43+00:00\",\"dateModified\":\"2025-07-21T00:52:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\"},\"wordCount\":6173,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.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\/vlookup-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\",\"name\":\"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, v\u00ed d\u1ee5 minh h\u1ecda\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg\",\"datePublished\":\"2025-07-21T00:51:43+00:00\",\"dateModified\":\"2025-07-21T00:52:05+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m kh\u00e1c.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"vlookup-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\"}]},{\"@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\/506edc7aab4e26e80b30c1a70bffcb30\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, v\u00ed d\u1ee5 minh h\u1ecda","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m 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\/vlookup-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m kh\u00e1c.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/","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":"2025-07-21T00:51:43+00:00","article_modified_time":"2025-07-21T00:52:05+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"28 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30"},"headline":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","datePublished":"2025-07-21T00:51:43+00:00","dateModified":"2025-07-21T00:52:05+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/"},"wordCount":6173,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.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\/vlookup-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/","name":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, v\u00ed d\u1ee5 minh h\u1ecda","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg","datePublished":"2025-07-21T00:51:43+00:00","dateModified":"2025-07-21T00:52:05+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u1ee7 thu\u1eadt v\u1ec1 VLOOKUP Excel, bao g\u1ed3m c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n v\u00e0 k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m kh\u00e1c.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/vlookup-excel.jpg","width":1200,"height":628,"caption":"vlookup-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"}]},{"@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\/506edc7aab4e26e80b30c1a70bffcb30","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/475154","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\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=475154"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/475154\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/475155"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=475154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=475154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=475154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}