{"id":449881,"date":"2025-04-15T19:34:27","date_gmt":"2025-04-15T12:34:27","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=449881"},"modified":"2025-04-15T19:34:27","modified_gmt":"2025-04-15T12:34:27","slug":"ham-vlookup","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/","title":{"rendered":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP l\u00e0 h\u00e0m s\u1ed1 \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng nh\u1ea5t trong Excel, c\u00f3 kh\u1ea3 n\u0103ng t\u00ecm ki\u1ebfm theo chi\u1ec1u d\u1ecdc v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1eb7c bi\u1ec7t, h\u00e0m n\u00e0y c\u0169ng \u0111\u00e3 tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1 hay b\u1ea5t k\u1ef3 ai th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Song, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 <\/span><b>VLOOKUP<\/b><span style=\"font-weight: 400;\"> l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng d\u1ec5 d\u00e0ng v\u00e0o th\u1ef1c t\u1ebf.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? L\u1ee3i \u00edch khi s\u1eed d\u1ee5ng?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP (vi\u1ebft t\u1eaft c\u1ee7a \u201cVertical Lookup\u201d \u2013 tra c\u1ee9u theo c\u1ed9t d\u1ecdc) l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb m\u1ed9t c\u1ed9t kh\u00e1c n\u1eb1m c\u00f9ng h\u00e0ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449883 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-1.jpg\" alt=\"ham-vlookup-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Tr\u00ean th\u1ef1c t\u1ebf, \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m tra c\u1ee9u ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. H\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tra th\u00f4ng tin nh\u01b0 t\u00ean s\u1ea3n ph\u1ea9m, gi\u00e1 ti\u1ec1n, m\u00e3 s\u1ed1, \u0111i\u1ec3m s\u1ed1,&#8230;V\u00ed d\u1ee5, n\u1ebfu c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng k\u00e8m m\u00e3 v\u00e0 gi\u00e1, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng VLOOKUP \u0111\u1ec3 nhanh ch\u00f3ng t\u00ecm gi\u00e1 c\u1ee7a m\u1ed9t m\u1eb7t h\u00e0ng b\u1ea5t k\u1ef3 d\u1ef1a tr\u00ean m\u00e3 c\u1ee7a n\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 VLOOKUP mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch r\u00f5 r\u1ec7t trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel. C\u1ee5 th\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian khi c\u1ea7n tra c\u1ee9u d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng l\u1edbn m\u00e0 kh\u00f4ng ph\u1ea3i t\u00ecm ki\u1ebfm th\u1ee7 c\u00f4ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">VLOOKUP \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c cao, h\u1ea1n ch\u1ebf sai s\u00f3t khi x\u1eed l\u00fd th\u00f4ng tin l\u1eb7p \u0111i l\u1eb7p l\u1ea1i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">VLOOKUP c\u00f3 kh\u1ea3 n\u0103ng gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00f4ng vi\u1ec7c, nh\u1ea5t l\u00e0 khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 IF, ISERROR hay IFERROR.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u1edd nh\u1eefng l\u1ee3i \u00edch n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c b\u1ea3ng t\u00ednh th\u00f4ng minh, linh ho\u1ea1t v\u00e0 d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Ph\u00e2n bi\u1ec7t h\u00e0m VLOOKUP v\u00e0 h\u00e0m HLOOKUP<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m s\u1ed1 VLOOKUP v\u00e0 h\u00e0m HLOOKUP c\u00f3 nh\u1eefng \u0111i\u1ec3m kh\u00e1c nhau nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p style=\"text-align: center;\"><b>Ti\u00eau ch\u00ed<\/b><\/p>\n<\/td>\n<td style=\"text-align: center;\"><b>VLOOKUP<\/b><\/td>\n<td style=\"text-align: center;\"><b>HLOOKUP<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ean \u0111\u1ea7y \u0111\u1ee7<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Vertical Lookup<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Horizontal Lookup<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ch\u1ee9c n\u0103ng ch\u00ednh<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Tra c\u1ee9u d\u1eef li\u1ec7u theo c\u1ed9t d\u1ecdc (t\u00ecm t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi)<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng ngang (t\u00ecm t\u1eeb tr\u00e1i sang ph\u1ea3i)<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ecm gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t kh\u00e1c c\u00f9ng h\u00e0ng<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ecm gi\u00e1 tr\u1ecb trong h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb h\u00e0ng kh\u00e1c c\u00f9ng c\u1ed9t<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ecm gi\u00e1 s\u1ea3n ph\u1ea9m d\u1ef1a v\u00e0o m\u00e3 s\u1ea3n ph\u1ea9m<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ecm \u0111i\u1ec3m s\u1ed1 theo t\u00ean m\u00f4n h\u1ecdc n\u1eb1m ngang<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">T\u00ednh ph\u1ed5 bi\u1ebfn<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ph\u1ed5 bi\u1ebfn h\u01a1n, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean trong th\u1ef1c t\u1ebf<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">\u00cdt ph\u1ed5 bi\u1ebfn h\u01a1n, ch\u1ee7 y\u1ebfu d\u00f9ng khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo h\u00e0ng<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m VLOOKUP trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p chu\u1ea9n x\u00e1c c\u1ee7a h\u00e0m VLOOOKUP trong b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/b><\/p>\n<p><span style=\"font-weight: 400;\"><b>M\u00f4 t\u1ea3 chi ti\u1ebft<\/b><\/span><span style=\"font-weight: 400;\">:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p style=\"text-align: center;\"><b>Th\u00e0nh ph\u1ea7n<\/b><\/p>\n<\/td>\n<td style=\"text-align: center;\"><b>\u00dd ngh\u0129a<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">lookup_value<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng t\u00ednh.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">table_array<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">B\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u.<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">col_index_num<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong table_array m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 (t\u00ednh t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 1).<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">[range_lookup] (t\u00f9y ch\u1ecdn)<\/span><\/p>\n<\/td>\n<td>\n<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh ki\u1ec3u t\u00ecm ki\u1ebfm:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">TRUE ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng: t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i (g\u1ea7n \u0111\u00fang).<\/span><\/li>\n<li><span style=\"font-weight: 400;\">FALSE: t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng VLOOKUP v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 VLOOKUP trong b\u1ea3ng t\u00ednh Excel r\u1ea5t \u0111a d\u1ea1ng. T\u00f9y v\u00e0o m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng, b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c ri\u00eang. D\u01b0\u1edbi \u0111\u00e2y l\u00e0\u00a0 c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng VLOOKUP gi\u1eefa 2 sheet<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c t\u1ebf, h\u00e0m VLOOKUP kh\u00f4ng ch\u1ec9 gi\u00fap ng\u01b0\u1eddi d\u00f9ng tra c\u1ee9u d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t trang t\u00ednh (sheet), m\u00e0 c\u00f2n c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng linh ho\u1ea1t gi\u1eefa hai ho\u1eb7c nhi\u1ec1u sheet kh\u00e1c nhau. H\u00e3y c\u00f9ng xem v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 sau \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y nh\u00e9.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: H\u00e3y d\u00f9ng h\u00e0m s\u1ed1 VLOOKUP trong Excel \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng cho c\u00e1c nh\u00e2n vi\u00ean trong 2 sheet sau:<\/span><\/p>\n<figure id=\"attachment_449884\" aria-describedby=\"caption-attachment-449884\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-449884 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-2.jpg\" alt=\"ham-vlookup-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-449884\" class=\"wp-caption-text\">Sheet 1<\/figcaption><\/figure>\n<figure id=\"attachment_449885\" aria-describedby=\"caption-attachment-449885\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-449885 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-3.jpg\" alt=\"ham-vlookup-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-449885\" class=\"wp-caption-text\">Sheet 2<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u1ede sheet 1, b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: =VLOOKUP(Sheet1!D3).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449886 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-4.jpg\" alt=\"ham-vlookup-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n ti\u1ebfp t\u1ee5c ti\u1ebfn h\u00e0nh chuy\u1ec3n sang sheet 2. Sau \u0111\u00f3, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449887 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-5.jpg\" alt=\"ham-vlookup-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u1ea7n sao ch\u00e9p h\u00e0m s\u1ed1 VLOOKUP \u0111\u00e3 nh\u1eadp tr\u1ef1c ti\u1ebfp \u1edf Sheet 2 sang \u00f4 th\u1ee9 t\u1ef1 E3 v\u00e0 nh\u1ea5n Enter. Ngay sau \u0111\u00f3, \u00f4 ch\u1ee9a &#8220;L\u01b0\u01a1ng&#8221; s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c l\u00e0 5000 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u1ea3ng \u1edf sheet th\u1ee9 2.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449888 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-6.jpg\" alt=\"ham-vlookup-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: B\u1ea1n c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 E3 cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i (ch\u1eb3ng h\u1ea1n t\u1eeb E4 \u0111\u1ebfn E8) b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o \u00f4 E3. Sau \u0111\u00f3, k\u00e9o h\u00ecnh vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 E3 xu\u1ed1ng \u0111\u1ebfn c\u00e1c \u00f4 c\u1ea7n \u00e1p d\u1ee5ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449889 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-7.jpg\" alt=\"ham-vlookup-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 d\u00f9ng h\u00e0m s\u1ed1 VLOOKUP trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n h\u00e3y gi\u1ea3 s\u1eed m\u00ecnh \u0111ang qu\u1ea3n l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean trong Excel, bao g\u1ed3m c\u00e1c c\u1ed9t nh\u01b0 m\u00e3 nh\u00e2n vi\u00ean, t\u00ean v\u00e0 ch\u1ee9c v\u1ee5. Ngo\u00e0i ra, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c cho th\u00eam m\u1ed9t b\u1ea3ng ph\u1ee5 kh\u00e1c ch\u1ee9a m\u00e3 nh\u00e2n vi\u00ean, qu\u00ea qu\u00e1n v\u00e0 tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n. M\u1ee5c ti\u00eau cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea1n l\u00e0 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n th\u00f4ng tin qu\u00ea qu\u00e1n v\u00e0 tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n v\u00e0o b\u1ea3ng ch\u00ednh d\u1ef1a tr\u00ean m\u00e3 nh\u00e2n vi\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 th\u00f4ng tin v\u1ec1 danh s\u00e1ch c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449890 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-8.jpg\" alt=\"ham-vlookup-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft t\u00ecnh hu\u1ed1ng n\u00e0y, \u0111\u1ea7u ti\u00ean t\u1ea1i \u00f4 D4 (c\u1ed9t Qu\u00ea qu\u00e1n trong b\u1ea3ng ch\u00ednh), b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP($A4,$A$16:$C$25,2,0). Sau \u0111\u00f3, b\u1ea1n ti\u1ebfp t\u1ee5c nh\u1ea5n Enter.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449891 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-9.jpg\" alt=\"ham-vlookup-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp theo, b\u1ea1n h\u00e3y k\u00e9o th\u1ea3 \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 nh\u1eefng nh\u00e2n vi\u00ean kh\u00e1c trong b\u1ea3ng sheet.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449892 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-10.jpg\" alt=\"ham-vlookup-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, t\u1ea1i \u00f4 E4 c\u1ee7a c\u1ed9t tr\u00ecnh \u0111\u1ed9 h\u1ecdc v\u1ea5n, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp: =VLOOKUP($A4,$A$16:$C$25,3,0).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449893 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-11.jpg\" alt=\"ham-vlookup-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n h\u00e3y nh\u1ea5n Enter v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c \u0111\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449894 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-12.jpg\" alt=\"ham-vlookup-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng VLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c cho c\u00e1c b\u1ea1n h\u1ecdc sinh d\u1ef1a tr\u00ean \u0111i\u1ec3m TB. Theo \u0111\u00f3, b\u1ea3ng x\u1ebfp lo\u1ea1i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n t\u1eeb lo\u1ea1i Y\u1ebfu \u0111\u1ebfn Gi\u1ecfi. Do \u0111\u00f3, ch\u00fang ta c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i trong h\u00e0m s\u1ed1 VLOOKUP. C\u1ee5 th\u1ec3, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 hai b\u1ea3ng t\u00ednh minh h\u1ecda m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449895 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-13.jpg\" alt=\"ham-vlookup-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Theo b\u1ea3ng Excel tr\u00ean, gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm s\u1ebd n\u1eb1m \u1edf v\u1ecb tr\u00ed c\u1ed9t C v\u00e0 \u0111\u01b0\u1ee3c b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng th\u1ee9 6. Trong \u0111\u00f3, ph\u1ea1m vi c\u1ea7n t\u00ecm ki\u1ebfm s\u1ebd l\u00e0 $A$18:$B$21 v\u00e0 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm l\u00e0 c\u1ed9t th\u1ee9 2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c t\u1ea1i v\u1ecb tr\u00ed \u00f4 D6, b\u1ea1n h\u00e3y nh\u1eadp =VLOOKUP($C6,$A$18:$B$21,2,1).\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c \u0111\u1ec3 gi\u00fap d\u00f2 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i. N\u1ebfu c\u1ea7n thi\u1ebft, b\u1ea1n h\u00e3y t\u00ecm gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp b\u1eb1ng h\u00e0m =VLOOKUP($C6,$A$18:$B$21,2,0) v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 nh\u1ea5n Enter.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449896 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-14.jpg\" alt=\"ham-vlookup-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u1ede b\u01b0\u1edbc n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449897 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-15.jpg\" alt=\"ham-vlookup-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, k\u1ebft qu\u1ea3 c\u1ee7a v\u00ed d\u1ee5 n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449898 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-16.jpg\" alt=\"ham-vlookup-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ednh th\u01b0\u1edfng nh\u00e2n vi\u00ean theo c\u1ea5p b\u1eadc<\/span><\/h3>\n<p><b>T\u00ecnh hu\u1ed1ng<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do \u1ea3nh h\u01b0\u1edfng c\u1ee7a d\u1ecbch Covid-19, c\u00f4ng ty quy\u1ebft \u0111\u1ecbnh h\u1ed7 tr\u1ee3 ph\u1ee5 c\u1ea5p cho nh\u00e2n vi\u00ean theo t\u1eebng ch\u1ee9c v\u1ee5, d\u1ef1a tr\u00ean b\u1ea3ng ph\u1ee5 c\u1ea5p (B\u1ea3ng 2 \u2013 ph\u1ea1m vi \u00f4 B16:C21). Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 tra c\u1ee9u m\u1ee9c ph\u1ee5 c\u1ea5p t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng nh\u00e2n vi\u00ean trong danh s\u00e1ch t\u1ea1i B\u1ea3ng 1, n\u01a1i \u0111\u00e3 c\u00f3 s\u1eb5n t\u00ean v\u00e0 ch\u1ee9c v\u1ee5 b\u1eb1ng h\u00e0m s\u1ed1 VLOOKUP.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449899 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-17.jpg\" alt=\"ham-vlookup-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 E4 trong B\u1ea3ng 1 (c\u1ed9t ph\u1ee5 c\u1ea5p), b\u1ea1n nh\u1eadp theo c\u00f4ng th\u1ee9c: =VLOOKUP(D4, $B$16:$C$21, 2, FALSE). Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D4: L\u00e0 \u00f4 ch\u1ee9a ch\u1ee9c v\u1ee5 c\u1ee7a nh\u00e2n vi\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">$B$16:$C$21: L\u00e0 ph\u1ea1m vi b\u1ea3ng tra c\u1ee9u ch\u1ee9a ch\u1ee9c v\u1ee5 v\u00e0 ph\u1ee5 c\u1ea5p. D\u1ea5u $ gi\u00fap c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 kh\u00f4ng b\u1ecb thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">2: L\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 (c\u1ed9t ph\u1ee5 c\u1ea5p trong b\u1ea3ng tra c\u1ee9u).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">FALSE: Y\u00eau c\u1ea7u t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c ch\u1ee9c v\u1ee5.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449900 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-18.jpg\" alt=\"ham-vlookup-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi nh\u1eadp xong c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p (copy) xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i ho\u1eb7c d\u00f9ng t\u00ednh n\u0103ng Flash Fill c\u1ee7a Excel. V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t vi\u1ec7c t\u00ednh ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5 c\u1ee7a 2 sheet m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449901 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-19.jpg\" alt=\"ham-vlookup-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 VLOOKUP, ng\u01b0\u1eddi d\u00f9ng s\u1ebd hay b\u1ecb m\u1eafc c\u00e1c l\u1ed7i ph\u1ed5 bi\u1ebfn sau \u0111\u00e2y.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #NAME?<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #NAME? th\u01b0\u1eddng x\u1ea3y ra khi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (Lookup_value) l\u00e0 v\u0103n b\u1ea3n nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;). Khi ng\u01b0\u1eddi d\u00f9ng thao t\u00e1c v\u1edbi chu\u1ed7i k\u00fd t\u1ef1 trong Excel, b\u1ea1n c\u1ea7n \u0111\u1eb7t n\u1ed9i dung c\u1ea7n thao t\u00e1c trong d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel nh\u1eadn di\u1ec7n \u0111\u00fang.<\/span><\/p>\n<p><b>V\u00ed d\u1ee5<\/b><span style=\"font-weight: 400;\">: N\u1ebfu b\u1ea1n nh\u1eadp =VLOOKUP(C\u1ea3i xo\u0103n, A2:B10, 2, 0) th\u00ec \u1ee9ng d\u1ee5ng Excel s\u1ebd b\u00e1o l\u1ed7i #NAME?. B\u1edfi l\u1ebd, \u1ee9ng d\u1ee5ng n\u00e0y kh\u00f4ng hi\u1ec3u \u201cC\u1ea3i xo\u0103n\u201d l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449902 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-20.jpg\" alt=\"ham-vlookup-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><span style=\"font-weight: 400;\">: B\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam d\u1ea5u ngo\u1eb7c k\u00e9p xung quanh v\u0103n b\u1ea3n, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 =VLOOKUP(&#8220;C\u1ea3i xo\u0103n&#8221;, A2:B10, 2, 0)<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #N\/A<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #N\/A th\u01b0\u1eddng x\u1ea3y ra khi \u1ee9ng d\u1ee5ng Excel kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm trong v\u00f9ng tra c\u1ee9u. Th\u1ef1c t\u1ebf, c\u00f3 m\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn d\u1eabn \u0111\u1ebfn l\u1ed7i n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<p><b>Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u00f2 (Table_array)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP ch\u1ec9 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng b\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. N\u1ebfu gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n t\u00ecm n\u1eb1m \u1edf c\u1ed9t kh\u00e1c, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm v\u00e0 b\u00e1o l\u1ed7i #N\/A. V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n \u0111\u1eb7t b\u1ea3ng d\u00f2 l\u00e0 A2:C10, VLOOKUP s\u1ebd t\u00ecm trong c\u1ed9t A. Mu\u1ed1n t\u00ecm trong c\u1ed9t B, b\u1ea1n c\u1ea7n thay \u0111\u1ed5i Table_array th\u00e0nh B2:C10.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449903 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-21.jpg\" alt=\"ham-vlookup-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tr\u00f9ng kh\u1edbp<\/b><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n t\u00ecm kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng d\u00f2, Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IFERROR \u0111\u1ec3 thay th\u1ebf l\u1ed7i b\u1eb1ng m\u1ed9t n\u1ed9i dung d\u1ec5 hi\u1ec3u h\u01a1n, v\u00ed d\u1ee5: =IFERROR(VLOOKUP(&#8230;), &#8220;Kh\u00f4ng t\u00ecm th\u1ea5y&#8221;). V\u00ed d\u1ee5: Khi b\u1ea1n t\u00ecm ki\u1ebfm &#8220;Rau mu\u1ed1ng&#8221; m\u00e0 d\u1eef li\u1ec7u n\u00e0y kh\u00f4ng c\u00f3 trong b\u1ea3ng, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 #N\/A.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449904 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-22.jpg\" alt=\"ham-vlookup-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>D\u1eef li\u1ec7u b\u1ecb \u1ea9n kho\u1ea3ng tr\u1eafng ho\u1eb7c sai \u0111\u1ecbnh d\u1ea1ng<\/b><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi d\u1eef li\u1ec7u nh\u00ecn th\u00ec gi\u1ed1ng nhau nh\u01b0ng th\u1eadt ra l\u1ea1i kh\u00e1c do c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng sai (ch\u1eef th\u00e0nh s\u1ed1 ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i). N\u1ebfu b\u1ea1n ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm c\u00f3 trong b\u1ea3ng m\u00e0 v\u1eabn b\u00e1o l\u1ed7i #N\/A, h\u00e3y ki\u1ec3m tra k\u1ef9 l\u1ea1i c\u00e1c \u00f4 d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u00fang \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng v\u00e0 kh\u00f4ng ch\u1ee9a k\u00fd t\u1ef1 \u1ea9n.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #VALUE!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #REF! xu\u1ea5t hi\u1ec7n khi s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tr\u1ea3 v\u1ec1 (hay c\u00f2n g\u1ecdi l\u00e0 Col_index_num) l\u1edbn h\u01a1n s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t trong v\u00f9ng b\u1ea3ng d\u00f2 (Table_array) m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn. C\u1ee5 th\u1ec3, trong c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m VLOOKUP, tham s\u1ed1 Col_index_num quy \u0111\u1ecbnh c\u1ed9t n\u00e0o trong b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3. N\u1ebfu b\u1ea1n nh\u1eadp s\u1ed1 c\u1ed9t v\u01b0\u1ee3t qu\u00e1 ph\u1ea1m vi c\u00f3 th\u1ef1c trong b\u1ea3ng d\u00f2, Excel s\u1ebd kh\u00f4ng th\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i #REF!.<\/span><\/p>\n<p><b>V\u00ed d\u1ee5<\/b><span style=\"font-weight: 400;\">: B\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau: =VLOOKUP(A2, B2:C10, 3, FALSE). Nh\u01b0ng v\u00f9ng b\u1ea3ng B2:C10 ch\u1ec9 g\u1ed3m 2 c\u1ed9t (c\u1ed9t B v\u00e0 c\u1ed9t C), trong khi b\u1ea1n y\u00eau c\u1ea7u l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u1ed9t th\u1ee9 3 \u2192 Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #REF!.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449906 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-24.jpg\" alt=\"ham-vlookup-24\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><span style=\"font-weight: 400;\">: B\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t trong Table_array. \u0110\u1ed3ng th\u1eddi, \u0111\u1ea3m b\u1ea3o Col_index_num lu\u00f4n b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n s\u1ed1 c\u1ed9t c\u00f3 trong b\u1ea3ng d\u00f2.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H3 L\u1ed7i #REF!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #VALUE! x\u1ea3y ra khi tham s\u1ed1 Col_index_num trong c\u00f4ng th\u1ee9c VLOOKUP nh\u1ecf h\u01a1n 1. Trong h\u00e0m VLOOKUP, Col_index_num l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1, t\u00ednh t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u00f2 (Table_array). Do \u0111\u00f3, gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t h\u1ee3p l\u1ec7 c\u1ee7a Col_index_num l\u00e0 1. N\u1ebfu b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb b\u1eb1ng 0 ho\u1eb7c nh\u1ecf h\u01a1n, Excel s\u1ebd kh\u00f4ng hi\u1ec3u v\u00e0 tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/span><\/p>\n<p><b>V\u00ed d\u1ee5<\/b><span style=\"font-weight: 400;\">: C\u00f4ng th\u1ee9c: =VLOOKUP(A2, B2:D10, 0, FALSE). Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Col_index_num = 0 \u2192 Excel s\u1ebd b\u00e1o l\u1ed7i #VALUE! v\u00ec kh\u00f4ng c\u00f3 c\u1ed9t n\u00e0o th\u1ee9 0 \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449905 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-23.jpg\" alt=\"ham-vlookup-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch kh\u1eafc ph\u1ee5c<\/b><span style=\"font-weight: 400;\">: Ki\u1ec3m tra v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng Col_index_num lu\u00f4n l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean \u2265 1. \u0110\u1ed1i chi\u1ebfu l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t b\u1ea1n mu\u1ed1n tr\u1ea3 k\u1ebft qu\u1ea3 trong v\u00f9ng b\u1ea3ng d\u00f2 \u0111\u1ec3 nh\u1eadp \u0111\u00fang.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m s\u1ed1 VLOOKUP v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 m\u1edf r\u1ed9ng t\u00ednh linh ho\u1ea1t v\u00e0 x\u1eed l\u00fd nhi\u1ec1u t\u00ecnh hu\u1ed1ng tra c\u1ee9u d\u1eef li\u1ec7u trong Excel:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p VLOOKUP v\u1edbi h\u00e0m LEFT \/ RIGHT<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Hai h\u00e0m LEFT v\u00e0 RIGHT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, t\u00ednh t\u1eeb b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ed1<\/b><span style=\"font-weight: 400;\">: =LEFT(text, num_chars) \/ =RIGHT(text, num_chars)<\/span><\/p>\n<p><b>Trong \u0111\u00f3:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">text: \u0110\u01b0\u1ee3c hi\u1ec3u l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">num_chars: S\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y (t\u00ednh t\u1eeb tr\u00e1i v\u1edbi LEFT, t\u1eeb ph\u1ea3i v\u1edbi RIGHT).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch sinh vi\u00ean v\u1edbi m\u00e3 sinh vi\u00ean bao g\u1ed3m th\u00f4ng tin v\u1ec1 ng\u00e0nh h\u1ecdc. C\u1ee5 th\u1ec3, 4 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a m\u00e3 sinh vi\u00ean l\u00e0 m\u00e3 ng\u00e0nh. Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u1ea1o c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh t\u00ean ng\u00e0nh h\u1ecdc t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449907 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25.jpg\" alt=\"ham-vlookup-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">G\u1ee3i y: T\u1ea1i \u00f4 C2, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp =VLOOKUP(LEFT(A2;4);$A$8:$B$10;2;0). Theo \u0111\u00f3, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ngay theo h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-26.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-26-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449908 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26.jpg\" alt=\"ham-vlookup-26\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m CHOOSE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m CHOOSE c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi VLOOKUP trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n d\u00f2 t\u00ecm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c c\u1ea7n ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong b\u1ea3ng d\u00f2.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p chu\u1ea9n<\/b><span style=\"font-weight: 400;\">: =VLOOKUP(Lookup_value;CHOOSE({1;2};v\u00f9ng gi\u00e1 tr\u1ecb 1;v\u00f9ng gi\u00e1 tr\u1ecb 2); Col_index_ num; Range_lookup)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh m\u1ee9c gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean t\u00ean s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t. C\u1ea3 hai th\u00f4ng tin n\u00e0y \u0111\u01b0\u1ee3c cung c\u1ea5p tr\u01b0\u1edbc.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449907 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25.jpg\" alt=\"ham-vlookup-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 B14, b\u1ea1n nh\u1eadp =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<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-26.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-26-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-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-449908 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26.jpg\" alt=\"ham-vlookup-26\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-26-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m VLOOKUP v\u00e0 h\u00e0m IF<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m IF c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi VLOOKUP t\u00f9y theo m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng. T\u00f9y v\u00e0o v\u1ecb tr\u00ed l\u1ed3ng gh\u00e9p, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c nh\u1eefng k\u1ebft qu\u1ea3 kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed cho \u0111i\u1ec1u ki\u1ec7n nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea1n h\u00e3y \u0111i\u1ec1n ti\u1ebfp ph\u1ea7n h\u1ecdc ph\u00ed c\u1ee7a c\u00e1c sinh vi\u00ean v\u00e0o b\u1ea3ng. L\u01b0u \u00fd r\u1eb1ng, t\u00f9y v\u00e0o t\u1eebng di\u1ec7n \u0111\u00f3ng h\u1ecdc ph\u00ed n\u00ean m\u1ed7i ng\u00e0nh h\u1ecdc c\u00e1c sinh vi\u00ean s\u1ebd c\u00f3 nh\u1eefng kho\u1ea3n h\u1ecdc ph\u00ed kh\u00e1c nhau.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-27.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-27-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-27-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449909 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-27.jpg\" alt=\"ham-vlookup-27\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-27.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-27-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-27-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Theo \u0111\u00f3, \u0111\u00e1p \u00e1n ch\u00ednh x\u00e1c c\u1ee7a \u00f4 E2 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-28.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-28-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-28-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449910 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-28.jpg\" alt=\"ham-vlookup-28\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-28.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-28-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-28-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP v\u00e0 SUM<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m s\u1ed1 VLOOKUP c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM \u0111\u1ec3 x\u1eed l\u00fd nh\u1eefng t\u00ecnh hu\u1ed1ng c\u1ea7n t\u00ednh t\u1ed5ng tr\u01b0\u1edbc khi tra c\u1ee9u d\u1eef li\u1ec7u. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb sau khi \u0111\u00e3 t\u00ednh t\u1ed5ng t\u1eeb nhi\u1ec1u \u00f4, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng h\u00e0m SUM v\u00e0o v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm (lookup_value) trong c\u00f4ng th\u1ee9c VLOOKUP.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p chu\u1ea9n<\/b><span style=\"font-weight: 400;\">: =VLOOKUP(SUM(a;b;&#8230;);Table_array; Col_index_ num; Range_lookup)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed th\u00f4ng tin nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea1n h\u00e3y t\u00ednh s\u1ed1 ti\u1ec1n th\u01b0\u1eddng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong b\u1ea3ng. L\u01b0u \u00fd, s\u1ed1 h\u00e0ng m\u00e0 nh\u00e2n vi\u00ean l\u00e0m \u0111\u01b0\u1ee3c s\u1ebd t\u00ednh b\u1eb1ng t\u1ed5ng s\u1ed1 h\u00e0ng h\u00f3a c\u1ee7a qu\u00fd 1 v\u00e0 2.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-29.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-29-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-29-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449911 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-29.jpg\" alt=\"ham-vlookup-29\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-29.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-29-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-29-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u00e1p \u00e1n ch\u00ednh x\u00e1c cho \u00f4 D2 s\u1ebd l\u00e0 =VLOOKUP(SUM(B2;C2);$A$9:$B$11;2;0).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-30.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-30-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-30-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449912 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-30.jpg\" alt=\"ham-vlookup-30\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-30.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-30-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-30-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP v\u00e0 MID<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m MID ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 LEFT v\u00e0 RIGHT, nh\u01b0ng cho ph\u00e9p b\u1ea1n l\u1ea5y k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong chu\u1ed7i.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p<\/b><span style=\"font-weight: 400;\">: =MID(a;b;c)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">a: Chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c \u0111\u1ecba ch\u1ec9 \u00f4 c\u1ea7n l\u1ea5y k\u00fd t\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">b: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u l\u1ea5y k\u00fd t\u1ef1 (t\u00ednh t\u1eeb tr\u00e1i sang).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">c: S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1eady n\u00ean, n\u1ebfu b\u1ea1n k\u1ebft h\u1ee3p h\u00e0m MID v\u1edbi VLOOKUP s\u1ebd \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c chu\u1ea9n nh\u01b0 sau: =VLOOKUP(MID(a;b;c); Table_array; Col_index_ num; Range_lookup).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed cho \u0111\u1ec1 b\u00e0i t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea1n h\u00e3y \u0111i\u1ec1n ng\u00e0nh h\u1ecdc c\u1ee7a nh\u1eefng b\u1ea1n sinh vi\u00ean v\u00e0o b\u1ea3ng. L\u01b0u \u00fd, ng\u00e0nh h\u1ecdc c\u1ee7a c\u00e1c b\u1ea1n sinh vi\u00ean s\u1ebd ho\u00e0n to\u00e0n d\u1ef1a v\u00e0o m\u00e3 ng\u00e0nh \u1edf b\u1ea3ng hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-33.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-33-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-33-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449915 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-33.jpg\" alt=\"ham-vlookup-33\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-33.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-33-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-33-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Theo \u0111\u00f3, \u0111\u00e1p \u00e1n ch\u00ednh x\u00e1c cho \u00f4 C2 s\u1ebd l\u00e0 =VLOOKUP(MID(A2;4;4); $A$8:$B$10; 2; 0).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-34.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-34-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-34-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449916 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-34.jpg\" alt=\"ham-vlookup-34\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-34.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-34-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-34-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 tr\u00e1nh l\u1ed7i<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 VLOOKUP trong Excel, b\u1ea1n n\u00ean n\u1eafm m\u1ed9t s\u1ed1 nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n \u0111\u1ec3 tr\u00e1nh l\u1ed7i v\u00e0 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 cao:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>V\u1ecb tr\u00ed c\u1ed9t tra c\u1ee9u<\/b><span style=\"font-weight: 400;\">: Gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 ph\u1ea3i n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u (Table_array). N\u1ebfu kh\u00f4ng \u0111\u00fang v\u1ecb tr\u00ed n\u00e0y, h\u00e0m s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Ki\u1ec3u \u0111\u1ed1i s\u00e1nh<\/b><span style=\"font-weight: 400;\">: S\u1eed d\u1ee5ng TRUE (ho\u1eb7c b\u1ecf qua) n\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1ed1i s\u00e1nh t\u01b0\u01a1ng \u0111\u1ed1i. Ng\u01b0\u1ee3c l\u1ea1i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m FALSE n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c \u2013 th\u01b0\u1eddng l\u00e0 tr\u01b0\u1eddng h\u1ee3p ph\u1ed5 bi\u1ebfn h\u01a1n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>\u0110\u1ed9 ch\u00ednh x\u00e1c khi t\u00ecm ki\u1ebfm<\/b><span style=\"font-weight: 400;\">: N\u1ebfu range_lookup b\u1ecb b\u1ecf qua, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh l\u00e0 TRUE, c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c. V\u00ec v\u1eady, n\u00ean ch\u1ec9 r\u00f5 FALSE khi b\u1ea1n c\u1ea7n k\u1ebft qu\u1ea3 \u0111\u00fang tuy\u1ec7t \u0111\u1ed1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>X\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<\/b><span style=\"font-weight: 400;\">: N\u1ebfu c\u1ed9t d\u00f2 t\u00ecm ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng, VLOOKUP ch\u1ec9 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean m\u00e0 n\u00f3 t\u00ecm \u0111\u01b0\u1ee3c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>H\u1ea1n ch\u1ebf v\u1ec1 h\u01b0\u1edbng tra c\u1ee9u<\/b><span style=\"font-weight: 400;\">: H\u00e0m s\u1ed1 VLOOKUP ch\u1ec9 t\u00ecm \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u n\u1eb1m \u1edf b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t tra c\u1ee9u. B\u1ea1n kh\u00f4ng th\u1ec3 t\u00ecm ng\u01b0\u1ee3c sang b\u00ean tr\u00e1i.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-35.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-35-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-vlookup-35-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-449917 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-35.jpg\" alt=\"ham-vlookup-35\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-35.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-35-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup-35-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">T\u1ea1m k\u1ebft<\/span><\/h2>\n<p><b>H\u00e0m VLOOKUP<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong Excel, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn c\u1ea7n tra c\u1ee9u th\u00f4ng tin nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Do \u0111\u00f3, h\u00e3y th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean v\u00e0 k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 IF, SUM, LEFT, MID&#8230; \u0111\u1ec3 khai th\u00e1c t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a VLOOKUP trong Excel nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM<\/span><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\">H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m VLOOKUP l\u00e0 h\u00e0m s\u1ed1 \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng nh\u1ea5t trong Excel, c\u00f3 kh\u1ea3 n\u0103ng t\u00ecm ki\u1ebfm theo chi\u1ec1u d\u1ecdc v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1eb7c bi\u1ec7t, h\u00e0m n\u00e0y c\u0169ng \u0111\u00e3 tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1 [&hellip;]<\/p>\n","protected":false},"author":101,"featured_media":449882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-449881","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 trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p &amp; v\u00ed d\u1ee5 chi ti\u1ebft<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!\" \/>\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\/ham-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\" \/>\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:published_time\" content=\"2025-04-15T12:34:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.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=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\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=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 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\/ham-vlookup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d\"},\"headline\":\"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft\",\"datePublished\":\"2025-04-15T12:34:27+00:00\",\"dateModified\":\"2025-04-15T12:34:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\"},\"wordCount\":4845,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.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\/ham-vlookup\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\",\"name\":\"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p & v\u00ed d\u1ee5 chi ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg\",\"datePublished\":\"2025-04-15T12:34:27+00:00\",\"dateModified\":\"2025-04-15T12:34:27+00:00\",\"description\":\"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-vlookup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft\"}]},{\"@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\/8e2486d5b72154b4200037e1bf6c063d\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p & v\u00ed d\u1ee5 chi ti\u1ebft","description":"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!","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\/ham-vlookup\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft","og_description":"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-04-15T12:34:27+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"25 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d"},"headline":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft","datePublished":"2025-04-15T12:34:27+00:00","dateModified":"2025-04-15T12:34:27+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/"},"wordCount":4845,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.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\/ham-vlookup\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/","name":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p & v\u00ed d\u1ee5 chi ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg","datePublished":"2025-04-15T12:34:27+00:00","dateModified":"2025-04-15T12:34:27+00:00","description":"B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u00e0m VLOOKUP l\u00e0 g\u00ec, c\u00fa ph\u00e1p s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft. N\u00e0o c\u00f9ng tham kh\u1ea3o ngay nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-vlookup.jpg","width":1200,"height":628,"caption":"ham-vlookup"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft"}]},{"@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\/8e2486d5b72154b4200037e1bf6c063d","name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/449881","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\/101"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=449881"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/449881\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/449882"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=449881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=449881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=449881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}