{"id":2651,"date":"2024-12-02T08:19:16","date_gmt":"2024-12-02T08:19:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/6-loi-lam-ham-vlookup-khong-hoat-dong\/"},"modified":"2024-12-02T08:19:16","modified_gmt":"2024-12-02T08:19:16","slug":"6-loi-lam-ham-vlookup-khong-hoat-dong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/6-loi-lam-ham-vlookup-khong-hoat-dong\/","title":{"rendered":"6 L\u1ed6I L\u00c0M H\u00c0M VLOOKUP KH\u00d4NG HO\u1ea0T \u0110\u1ed8NG"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">H\u00e0m VLOOKUP l\u00e0 h\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00f3 nh\u1ea5t v\u00e0 th\u00f4ng b\u00e1o <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao-xu-ly-loi-na-vlookup.html\"><strong>l\u1ed7i #N\/A trong h\u00e0m Vloopkup<\/strong><\/a> \u0111\u00e1ng s\u1ee3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u0111i\u1ec1u v\u00f4 c\u00f9ng ph\u1ed5 bi\u1ebfn. B<\/span><span style=\"font-weight: 400\">\u00e0i vi\u1ebft n\u00e0y,<strong> H\u1ecdc Excel Online <\/strong>s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn 6 l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t khi\u1ebfn <strong>h\u00e0m VLOOKUP<\/strong> kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d6d83138e1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Ban_can_co_mot_phep_toan_chinh_xac\" title=\"B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c\">B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Co_dinh_vung_du_lieu\" title=\"C\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u\">C\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Chen_them_cot\" title=\"Ch\u00e8n th\u00eam c\u1ed9t\">Ch\u00e8n th\u00eam c\u1ed9t<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Giai_phap_1\" title=\"Gi\u1ea3i ph\u00e1p 1\">Gi\u1ea3i ph\u00e1p 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Giai_phap_2\" title=\"Gi\u1ea3i ph\u00e1p 2\">Gi\u1ea3i ph\u00e1p 2<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Mo_rong_bang_bieu\" title=\"M\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u\">M\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Ham_VLOOKUP_khong_the_tim_kiem_cac_gia_tri_ben_trai\" title=\"H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i\">H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Bang_bieu_chua_cac_gia_tri_bi_trung\" title=\"B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng\">B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Giai_phap_1-2\" title=\"Gi\u1ea3i ph\u00e1p 1\">Gi\u1ea3i ph\u00e1p 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/6-loi-lam-ham-vlookup-khong-hoat-dong.html#Giai_phap_2-2\" title=\"Gi\u1ea3i ph\u00e1p 2\">Gi\u1ea3i ph\u00e1p 2<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ban_can_co_mot_phep_toan_chinh_xac\"><\/span><b>B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Tham s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m VLOOKUP<\/strong><\/a>, \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 range_lookup, h\u1ecfi b\u1ea1n mu\u1ed1n ch\u1ecdn kh\u1edbp g\u1ea7n \u0111\u00fang hay kh\u1edbp ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong h\u1ea7u h\u1ebft tr\u01b0\u1eddng h\u1ee3p, m\u1ecdi ng\u01b0\u1eddi \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t s\u1ea3n ph\u1ea9m, \u0111\u01a1n h\u00e0ng, nh\u00e2n vi\u00ean ho\u1eb7c kh\u00e1ch h\u00e0ng c\u1ee5 th\u1ec3 v\u00e0 do \u0111\u1ed1 y\u00eau c\u1ea7u m\u1ed9t k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. Khi t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb duy nh\u1ea5t, ph\u1ea3i nh\u1eadp FALSE cho tham s\u1ed1 range_lookup.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tham s\u1ed1 n\u00e0y l\u00e0 t\u00f9y ch\u1ecdn, nh\u01b0ng n\u1ebfu \u0111\u1ec3 tr\u1ed1ng, gi\u00e1 tr\u1ecb TRUE s\u1ebd \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh. Gi\u00e1 tr\u1ecb TRUE d\u1ef1a tr\u00ean vi\u1ec7c d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n \u0111\u1ec3 ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi cho th\u1ea5y m\u1ed9t h\u00e0m VLOOKUP v\u1edbi tham s\u1ed1 range_lookup b\u1ecb lo\u1ea1i b\u1ecf v\u00e0 gi\u00e1 tr\u1ecb kh\u00f4ng ch\u00ednh x\u00e1c \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/no_false_resized.png\" alt=\"VLOOKUP function returned incorrect value because range_lookup argument is omitted\" width=\"640\" height=\"343\"><figcaption class=\"wp-caption-text\">B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<p><b>Gi\u1ea3i ph\u00e1p<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u00ecm gi\u00e1 tr\u1ecb duy nh\u1ea5t, th\u00ec n\u00ean nh\u1eadp FALSE cho tham s\u1ed1 cu\u1ed1i. H\u00e0m VLOOKUP \u1edf tr\u00ean n\u00ean \u0111\u01b0\u1ee3c nh\u1eadp th\u00e0nh\u00a0 <strong>=VLOOKUP(H3,B3:F11,2,FALSE).<\/strong><\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-205.gif\" title=\"ex101_92019-nho-205\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure style=\"width: 725px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slide-3.png\" alt=\"B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c 1\" width=\"725\" height=\"434\"><figcaption class=\"wp-caption-text\">B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t ph\u00e9p to\u00e1n ch\u00ednh x\u00e1c 1<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Co_dinh_vung_du_lieu\"><\/span><b>C\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 b\u1ea1n \u0111ang mu\u1ed1n s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm nhi\u1ec1u th\u00f4ng tin kh\u00e1c nhau v\u1ec1 m\u1ed9t bi\u00ean b\u1ea3n. N\u1ebfu b\u1ea1n c\u00f3 \u00fd \u0111\u1ecbnh sao ch\u00e9p h\u00e0m VLOOKUP c\u1ee7a m\u00ecnh sang nhi\u1ec1u \u00f4 t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i c\u1ed1 \u0111\u1ecbnh b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y m\u1ed9t h\u00e0m VLOOKUP \u0111\u01b0\u1ee3c nh\u1eadp kh\u00f4ng ch\u00ednh x\u00e1c. V\u00f9ng d\u1eef li\u1ec7u nh\u1eadp sai \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n qua tham chi\u1ebfu lookup_value v\u00e0 table_array.<\/span><\/p>\n<p><b><i>Gi\u1ea3i ph\u00e1p<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea3ng d\u1eef li\u1ec7u tra c\u1ee9u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o tham s\u1ed1 table_array, b\u1ea3ng n\u00e0y c\u1ea7n \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 thu\u1eadn ti\u1ec7n cho vi\u1ec7c sao ch\u00e9p h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p c\u00f4ng th\u1ee9c v\u00e0o tham chi\u1ebfu v\u00e0 nh\u1ea5n ph\u00edm F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu t\u1eeb t\u01b0\u01a1ng \u0111\u1ed1i sang tuy\u1ec7t \u0111\u1ed1i. C\u00f4ng th\u1ee9c ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp l\u00e0 <strong>=VLOOKUP($H$3,$B$3:$F$11,4,FALSE).<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, c\u1ea3 hai tham chi\u1ebfu lookup_value v\u00e0 table_array \u0111\u1ec1u \u0111\u01b0\u1ee3c coi l\u00e0 tuy\u1ec7t \u0111\u1ed1i. Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n ch\u1ec9 c\u1ea7n c\u1ed1 \u0111\u1ecbnh table_array.<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/unlocked_table_resized.png\" alt=\"VLOOKUP entered incorrectly\" width=\"640\" height=\"202\"><figcaption class=\"wp-caption-text\">C\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Chen_them_cot\"><\/span><b>Ch\u00e8n th\u00eam c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ecba ch\u1ec9 m\u1ed9t c\u1ed9t, ho\u1eb7c col_index_num, trong h\u00e0m VLOOKUP s\u1eed d\u1ee5ng \u0111\u1ec3 nh\u1eadp th\u00f4ng tin.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec \u0111\u00e2y \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng s\u1ed1 ch\u1ec9 m\u1ee5c n\u00ean n\u00f3 d\u1ec5 sai l\u1ec7ch. N\u1ebfu m\u1ed9t c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o b\u1ea3ng, n\u00f3 c\u00f3 th\u1ec3 l\u00e0m h\u00e0m VLOOKUP b\u1ecb l\u1ed7i. H\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi cho th\u1ea5y minh h\u1ecda nh\u01b0 v\u1eady.\u00a0<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Ch\u00e8n th\u00eam c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/inserted_column_resized.png\" alt=\"VLOOKUP could stop working if you inserted new column in the lookup table\" width=\"640\" height=\"275\"><figcaption class=\"wp-caption-text\">Ch\u00e8n th\u00eam c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">S\u1ed1 l\u01b0\u1ee3ng n\u1eb1m trong c\u1ed9t 3, nh\u01b0ng sau khi m\u1ed9t c\u1ed1 m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o n\u00f3 \u0111\u00e3 tr\u1edf th\u00e0nh c\u1ed9t 4. Tuy nhi\u00ean, h\u00e0m VLOOKUP ch\u01b0a t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giai_phap_1\"><\/span><b>Gi\u1ea3i ph\u00e1p 1<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t gi\u1ea3i ph\u00e1p c\u00f3 th\u1ec3 l\u00e0 b\u1ea3o v\u1ec7 trang t\u00ednh \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 ch\u00e8n c\u1ed9t. N\u1ebfu ng\u01b0\u1eddi d\u00f9ng c\u1ed1 ch\u00e8n th\u00eam c\u1ed9t, th\u00ec \u0111\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t gi\u1ea3i gi\u00e1p kh\u1ea3 khi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giai_phap_2\"><\/span><b>Gi\u1ea3i ph\u00e1p 2<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t s\u1ef1 l\u1ef1a ch\u1ecdn kh\u00e1c l\u00e0 nh\u1eadp h\u00e0m MATCH v\u1edbi trong tham s\u1ed1 col_index_num v\u00e0o h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m MATCH c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 ch\u1ecdn \u0111\u00fang c\u1ed9t c\u1ea7n thi\u1ebft h\u1ed7 tr\u1ee3 cho h\u00e0m VLOOKUP. \u0110i\u1ec1u n\u00e0y s\u1ebd gi\u00fap cho ch\u1ec9 s\u1ed1 col_index_num lu\u00f4n \u0111\u00fang khi ch\u00e8n b\u1ea5t c\u1ee9 c\u1ed9t n\u00e0o m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng t\u1edbi h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd minh h\u1ecda r\u00f5 n\u00e9t cho gi\u1ea3i ph\u00e1p tr\u00ean.<\/span><\/p>\n<figure style=\"width: 639px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"imgl2\" title=\"K\u1ebft qu\u1ea3 Ch\u00e8n th\u00eam c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dynamic_col_num.png\" alt=\"Use the MATCH function to return dynamic col_index_num\" width=\"639\" height=\"73\"><figcaption class=\"wp-caption-text\">K\u1ebft qu\u1ea3\u00a0 ch\u00e8n th\u00eam c\u1ed9t<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Mo_rong_bang_bieu\"><\/span><b>M\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0o b\u1ea3ng, b\u1ea1n c\u1ea7n c\u1eadp nh\u1eadt l\u1ea1i h\u00e0m VLOOKUP \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c h\u00e0ng b\u1ed5 sung c\u0169ng \u0111\u01b0\u1ee3c th\u00eam gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. H\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi th\u1ec3 hi\u1ec7n h\u00e0m VLOOKUP kh\u00f4ng t\u00ecm ki\u1ebfm h\u1ebft gi\u00e1 tr\u1ecb tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng c\u1ee7a m\u1eb7t h\u00e0ng tr\u00e1i c\u00e2y.<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"M\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/increased_range_resized.png\" alt=\"VLOOKUP does not check newly added rows\" width=\"640\" height=\"215\"><figcaption class=\"wp-caption-text\">M\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u<\/figcaption><\/figure>\n<p><b>Gi\u1ea3i ph\u00e1p<\/b><\/p>\n<p><span style=\"font-weight: 400\">Xem x\u00e9t \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng (Excel 2007+) v\u00e0 th\u1ee7 thu\u1eadt n\u00e0y s\u1ebd \u0111\u1ea3m b\u1ea3o r\u1eb1ng h\u00e0m VLOOKUP lu\u00f4n \u0111\u01b0\u1ee3c ki\u1ec3m tra to\u00e0n b\u1ed9 b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng bi\u1ec3u, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o tham s\u1ed1 table_array v\u00e0 click Home &gt; Format as Table v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng m\u1eabu. N\u1ebfu nh\u1ea5n ch\u1ecdn th\u1ebb Design d\u01b0\u1edbi th\u1ebb Table Tools v\u00e0 thay \u0111\u1ed5i t\u00ean b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m VLOOKUP b\u00ean d\u01b0\u1edbi th\u1ec3 hi\u1ec7n b\u1ea3ng Fruitlist \u0111\u00e3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng.<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Gi\u1ea3i ph\u00e1p m\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/using_table_resized.png\" alt=\"Use named range in VLOOKUP function\" width=\"640\" height=\"249\"><figcaption class=\"wp-caption-text\">Gi\u1ea3i ph\u00e1p m\u1edf r\u1ed9ng b\u1ea3ng bi\u1ec3u<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_khong_the_tim_kiem_cac_gia_tri_ben_trai\"><\/span><strong>H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m VLOOKUP l\u00e0 n\u00f3 kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i. N\u00f3 s\u1ebd nh\u00ecn xu\u1ed1ng c\u1ed9t b\u00ean tr\u00e1i c\u1ee7a b\u1ea3ng v\u00e0 tr\u1ea3 th\u00f4ng tin t\u1eeb b\u00ean ph\u1ea3i.<\/span><\/p>\n<p><b>Gi\u1ea3i ph\u00e1p<\/b><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3i ph\u00e1p cho \u0111i\u1ec1u n\u00e0y li\u00ean quan \u0111\u1ebfn vi\u1ec7c kh\u00f4ng s\u1eed d\u1ee5ng h\u00e0m VLOOKUP. S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel l\u00e0 m\u1ed9t c\u00e1ch thay th\u1ebf ph\u1ed5 bi\u1ebfn cho h\u00e0m VLOOKUP. N\u00f3 linh ho\u1ea1t h\u01a1n nhi\u1ec1u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 th\u00f4ng tin \u1edf b\u00ean tr\u00e1i c\u1ee7a c\u1ed9t b\u1ea1n \u0111ang xem.<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/index_and_match_resized.png\" alt=\"Use INDEX and MATCH functions instead of VLOOKUP\" width=\"640\" height=\"340\"><figcaption class=\"wp-caption-text\">H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Bang_bieu_chua_cac_gia_tri_bi_trung\"><\/span><b>B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m VLOOKUP ch\u1ec9 c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 b\u1ea3ng \u0111\u1ea7u ti\u00ean ph\u00f9 h\u1ee3p v\u1edbi gi\u00e1 tr\u1ecb b\u1ea1n \u0111\u00e3 t\u00ecm ki\u1ebfm.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng th\u00ec h\u00e0m VLOOKUP s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giai_phap_1-2\"><\/span><b>Gi\u1ea3i ph\u00e1p 1<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Danh s\u00e1ch c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 n\u1ebfu kh\u00f4ng xem x\u00e9t lo\u1ea1i b\u1ecf ch\u00fang, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn b\u1ea3ng t\u00ednh v\u00e0 nh\u1ea5p v\u00e0o Remove Duplicates trong th\u1ebb Data.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra AbleBits Duplicate Remover \u0111\u1ec3 c\u00f3 c\u00f4ng c\u1ee5 ho\u00e0n ch\u1ec9nh h\u01a1n v\u00e0 x\u1eed l\u00fd c\u00e1c b\u1ea3n sao trong Excel.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giai_phap_2-2\"><\/span><b>Gi\u1ea3i ph\u00e1p 2<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p danh s\u00e1ch c\u1ee7a b\u1ea1n n\u00ean c\u00f3 c\u00e1c b\u1ea3n sao, h\u00e0m VLOOKUP kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1i \u01b0u. PivotTable l\u00e0 l\u1ef1a ch\u1ecdn ho\u00e0n h\u1ea3o \u0111\u1ec3 ch\u1ecdn gi\u00e1 tr\u1ecb v\u00e0 thay v\u00e0o \u0111\u00f3 li\u1ec7t k\u00ea k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng. Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n tr\u1ea3 l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng cho m\u1ed9t lo\u1ea1i tr\u00e1i c\u00e2y c\u1ee5 th\u1ec3.<\/span><\/p>\n<figure style=\"width: 589px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/duplicates_list-1.png\" alt=\"Table with duplicated rows\" width=\"589\" height=\"349\"><figcaption class=\"wp-caption-text\">B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">PivoTable \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn ID ph\u00f9 h\u1ee3p t\u1eeb b\u1ed9 l\u1ecdc b\u00e1o c\u00e1o v\u00e0 danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng s\u1ebd xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n<figure style=\"width: 605px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable.png\" alt=\"Use PivotTable to group duplicate rows\" width=\"605\" height=\"448\"><figcaption class=\"wp-caption-text\">B\u1ea3ng bi\u1ec3u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng 1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>\u0111\u00e3 tr\u00ecnh b\u00e0y 6 l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t m\u00e0 <strong>h\u00e0m VLOOKUP<\/strong> kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. \u0110\u01b0\u1ee3c trang b\u1ecb nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y, b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd \u00edt g\u1eb7p l\u1ea1i nh\u1eefng r\u1eafc r\u1ed1i n\u00e0y trong t\u01b0\u01a1ng lai h\u01a1n v\u1edbi h\u00e0m Excel.<\/span><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-205.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2652,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2651"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2651\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2652"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}