{"id":4818,"date":"2024-12-08T10:38:49","date_gmt":"2024-12-08T10:38:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet\/"},"modified":"2024-12-08T10:38:49","modified_gmt":"2024-12-08T10:38:49","slug":"nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet\/","title":{"rendered":"Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi vi\u1ebft h\u00e0m Vlookup trong Google Sheet"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nO_m37Xw#1\">\n<p><em><span style=\"font-weight: 400\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0m Vlookup kh\u00f4ng b\u1ecb l\u1ed7i trong Google Sheet? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> xem qua nh\u1eefng tr\u01b0\u1eddng h\u1ee3p l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi l\u00e0m vi\u1ec7c v\u1edbi <strong>h\u00e0m VLOOKUP trong Google Sheet<\/strong> sau \u0111\u00e2y.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Google Sheets VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m h\u1eefu \u00edch nh\u1ea5t nh\u01b0ng kh\u00f3 nh\u1ea5t. N\u00f3 gi\u00fap t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p tr\u00ean nhi\u1ec1u trang t\u00ednh. Tuy nhi\u00ean, c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p khi c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 nh\u1eefng l\u1ed7i nh\u01b0 #N\/A, #NAME?, #VALUE!, and #REF!.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta h\u00e3y c\u00f9ng nhau th\u1eed v\u00e0 tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi sau, \u201cT\u1ea1i sao <em><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><\/em> kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng?\u201d<\/span><\/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-675577384227c\" 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\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Cac_loi_VLOOKUP_pho_bien_nhat\" title=\"C\u00e1c l\u1ed7i VLOOKUP ph\u1ed5 bi\u1ebfn nh\u1ea5t\u00a0\">C\u00e1c l\u1ed7i VLOOKUP ph\u1ed5 bi\u1ebfn nh\u1ea5t\u00a0<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Sai_dau_phan_cach\" title=\"Sai d\u1ea5u ph\u00e2n c\u00e1ch\">Sai d\u1ea5u ph\u00e2n c\u00e1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Du_lieu_khong_chinh_xac\" title=\"D\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c\">D\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Ten_ham_khong_chinh_xac\" title=\"T\u00ean h\u00e0m kh\u00f4ng ch\u00ednh x\u00e1c\">T\u00ean h\u00e0m kh\u00f4ng ch\u00ednh x\u00e1c<\/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\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Tham_chieu_o_VLOOKUP_khong_chinh_xac\" title=\"Tham chi\u1ebfu \u00f4 VLOOKUP kh\u00f4ng ch\u00ednh x\u00e1c\">Tham chi\u1ebfu \u00f4 VLOOKUP kh\u00f4ng ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Tham_so_%E2%80%9Cis_sorted%E2%80%9D_khong_chinh_xac\" title=\"Tham s\u1ed1 \u201cis_sorted\u201d kh\u00f4ng ch\u00ednh x\u00e1c\">Tham s\u1ed1 \u201cis_sorted\u201d kh\u00f4ng ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Cot_tra_cuu_khong_chinh_xac\" title=\"C\u1ed9t tra c\u1ee9u kh\u00f4ng ch\u00ednh x\u00e1c\">C\u1ed9t tra c\u1ee9u kh\u00f4ng ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#So_cot_khong_chinh_xac\" title=\"S\u1ed1 c\u1ed9t kh\u00f4ng ch\u00ednh x\u00e1c\">S\u1ed1 c\u1ed9t kh\u00f4ng ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Tham_chieu_khong_chinh_xac\" title=\"Tham chi\u1ebfu kh\u00f4ng ch\u00ednh x\u00e1c\u00a0\">Tham chi\u1ebfu kh\u00f4ng ch\u00ednh x\u00e1c\u00a0<\/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\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Dinh_dang_so_khong_chinh_xac\" title=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c\u00a0\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Khoang_trang_thua_va_cac_ky_tu_dac_biet\" title=\"Kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t\">Kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/nhung-loi-thuong-gap-khi-viet-ham-vlookup-trong-google-sheet.html#Thay_the_loi_VLOOKUP_bang_van_ban\" title=\"Thay th\u1ebf l\u1ed7i VLOOKUP b\u1eb1ng v\u0103n b\u1ea3n\">Thay th\u1ebf l\u1ed7i VLOOKUP b\u1eb1ng v\u0103n b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_loi_VLOOKUP_pho_bien_nhat\"><\/span><b>C\u00e1c l\u1ed7i VLOOKUP ph\u1ed5 bi\u1ebfn nh\u1ea5t\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">L\u00fd do \u0111\u1ea7u ti\u00ean \u0111\u01a1n gi\u1ea3n l\u00e0 kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 n\u00e0o ph\u00f9 h\u1ee3p trong ph\u1ea1m vi b\u1ea1n \u0111\u00e3 khoanh v\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n \u0111\u00e3 m\u1eafc l\u1ed7i \u1edf \u0111\u00e2u \u0111\u00f3 trong c\u00f4ng th\u1ee9c. H\u00e3y xem x\u00e9t k\u1ef9 h\u01a1n nh\u1eefng g\u00ec c\u00f3 th\u1ec3 x\u1ea3y ra.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sai_dau_phan_cach\"><\/span><b>Sai d\u1ea5u ph\u00e2n c\u00e1ch<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">D\u1ea5u ph\u00e2n c\u00e1ch l\u00e0 nh\u1eefng k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n \u1edf V\u01b0\u01a1ng qu\u1ed1c Anh ho\u1eb7c Hoa K\u1ef3, r\u1ea5t c\u00f3 th\u1ec3 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n y\u00eau c\u1ea7u d\u1ea5u ph\u1ea9y l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch:<\/span><\/p>\n<p><strong>=VLOOKUP(A2,$F$2:$G$10,2,FALSE)<\/strong><\/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-395.gif\" title=\"ex101_92019-nho-395\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">V\u00e0 ch\u00ednh ng\u00f4n ng\u1eef b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n s\u1ebd ki\u1ec3m so\u00e1t s\u1ef1 l\u1ef1a ch\u1ecdn c\u1ee7a d\u1ea5u ph\u00e2n t\u00e1ch. C\u00e1c ng\u00f4n ng\u1eef kh\u00e1c nhau y\u00eau c\u1ea7u c\u00e1c d\u1ea5u ph\u00e2n t\u00e1ch kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 ki\u1ec3m tra ng\u00f4n ng\u1eef c\u1ee7a b\u1ea1n trong Google Sheets, h\u00e3y chuy\u1ec3n \u0111\u1ebfn File &gt; Spreadsheets settings. B\u1ea1n s\u1ebd th\u1ea5y ng\u00f4n ng\u1eef trong General Tab:<\/span><\/p>\n<figure id=\"attachment_33412\" aria-describedby=\"caption-attachment-33412\" style=\"width: 718px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33412\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup.png\" alt=\"L\u1ed7i sai d\u1ea5u c\u00e1ch khi vi\u1ebft h\u00e0m Vlookup trong gg sheet\" width=\"718\" height=\"457\" title=\"1-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup\"><figcaption id=\"caption-attachment-33412\" class=\"wp-caption-text\">L\u1ed7i sai d\u1ea5u c\u00e1ch khi vi\u1ebft h\u00e0m Vlookup trong gg sheet<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch <strong>h\u00e0m VLOOKUP<\/strong> c\u1ea7n d\u1ef1a tr\u00ean ng\u00f4n ng\u1eef c\u1ee7a b\u1ea1n, ch\u1ec9 c\u1ea7n b\u1eaft \u0111\u1ea7u nh\u1eadp h\u00e0m. Google Sheets s\u1ebd cho b\u1ea1n bi\u1ebft c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n tr\u00f4ng ch\u00ednh x\u00e1c nh\u01b0 th\u1ebf n\u00e0o v\u00e0 nh\u1eefng d\u1ea5u ph\u00e2n c\u00e1ch n\u00e0o ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng:<\/span><\/p>\n<figure id=\"attachment_33413\" aria-describedby=\"caption-attachment-33413\" style=\"width: 322px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33413\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"Sai d\u1ea5u ph\u00e2n c\u00e1ch trong vlookup\" width=\"322\" height=\"162\" title=\"2-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33413\" class=\"wp-caption-text\">Sai d\u1ea5u ph\u00e2n c\u00e1ch trong vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c d\u1ea5u ph\u00e2n c\u00e1ch \u0111\u1ec1u \u0111\u00fang nh\u01b0 <strong>h\u00e0m VLOOKUP trong Google Sheet<\/strong>, b\u1ea1n v\u1eabn g\u1eb7p l\u1ed7i, h\u00e3y ki\u1ec3m tra c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u00f3 th\u1ec3 x\u1ea3y ra kh\u00e1c v\u00e0 gi\u1ea3i ph\u00e1p c\u1ee7a ch\u00fang b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Du_lieu_khong_chinh_xac\"><\/span><b>D\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c kh\u00f4ng t\u00ecm th\u1ea5y g\u00ec v\u00e0 tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A?<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u2013 r\u1ea5t c\u00f3 th\u1ec3 l\u00e0 b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t n\u1ebfu b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c tr\u1ef1c ti\u1ebfp v\u00e0o thanh c\u00f4ng th\u1ee9c thay v\u00ec \u00f4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ten_ham_khong_chinh_xac\"><\/span><b>T\u00ean h\u00e0m kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n th\u1ea5y #NAME? L\u1ed7i, r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n vi\u1ebft sai t\u00ean h\u00e0m \u2013 thi\u1ebfu ho\u1eb7c vi\u1ebft sai ch\u00ednh t\u1ea3 m\u1ed9t ho\u1eb7c hai ch\u1eef c\u00e1i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra \u0111i\u1ec1u \u0111\u00f3 v\u00e0 s\u1eeda l\u1ed7i ch\u00ednh t\u1ea3 th\u00ec h\u00e0m VLOOKUP s\u1ebd ho\u1ea1t \u0111\u1ed9ng tr\u1edf l\u1ea1i.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_o_VLOOKUP_khong_chinh_xac\"><\/span><b>Tham chi\u1ebfu \u00f4 VLOOKUP kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng t\u1ed1t cho \u0111\u1ebfn khi b\u1ea1n th\u00eam m\u1ed9t v\u00e0i d\u00f2ng ho\u1eb7c c\u1ed9t v\u00e0o b\u1ea3ng v\u00e0 l\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n m\u00e0u xanh lam.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra xem ph\u1ea1m vi t\u00ecm ki\u1ebfm v\u00e0 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm \u0111\u01b0\u1ee3c nh\u1eadp ch\u00ednh x\u00e1c hay kh\u00f4ng?<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (v\u00ed d\u1ee5: A1) thay v\u00ec tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i (v\u00ed d\u1ee5: $A$1) v\u00e0 sau \u0111\u00f3 s\u1eeda \u0111\u1ed5i b\u1ea3ng (v\u00ed d\u1ee5: th\u00eam c\u1ed9t), d\u1eef li\u1ec7u s\u1ebd thay \u0111\u1ed5i, tham chi\u1ebfu s\u1ebd thay \u0111\u1ed5i v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd tham chi\u1ebfu \u0111\u1ebfn \u00f4 sai:<\/span><\/p>\n<figure id=\"attachment_33414\" aria-describedby=\"caption-attachment-33414\" style=\"width: 545px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33414\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"3 Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi vi\u1ebft h\u00e0m Vlookup trong Google Sheet\" width=\"545\" height=\"507\" title=\"3-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33414\" class=\"wp-caption-text\">3 Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi vi\u1ebft h\u00e0m Vlookup trong Google Sheet<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Th\u00eam c\u1ed9t \u201cArticle\u201d. C\u1ed9t \u201cPrice\u201d kh\u00f4ng \u0111\u01b0\u1ee3c bao g\u1ed3m trong ph\u1ea1m vi n\u1eefa, do \u0111\u00f3 kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gia.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111i\u1ec1u \u0111\u00f3 x\u1ea3y ra, ch\u1ec9 c\u1ea7n Undo l\u1ea1i v\u00e0 suae c\u00e1c tham chi\u1ebfu.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Formulas trong Power Tools add-on \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i th\u00e0nh tuy\u1ec7t \u0111\u1ed1i trong m\u1ed9t v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t:<\/span><\/p>\n<figure id=\"attachment_33415\" aria-describedby=\"caption-attachment-33415\" style=\"width: 301px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33415\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"Tham chi\u1ebfu sai d\u1eef li\u1ec7u trong vlookup\" width=\"301\" height=\"424\" title=\"4-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33415\" class=\"wp-caption-text\">Tham chi\u1ebfu sai d\u1eef li\u1ec7u trong vlookup<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Tham_so_%E2%80%9Cis_sorted%E2%80%9D_khong_chinh_xac\"><\/span><b>Tham s\u1ed1 \u201cis_sorted\u201d kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1eb7t \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp g\u1ea7n \u0111\u00fang (TRUE), trong khi c\u1ed9t tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u \u0111\u00f3, h\u00e3y s\u1eafp x\u1ebfp c\u1ed9t tra c\u1ee9u A th\u00e0nh Z ho\u1eb7c thay \u0111\u1ed5i TRUE th\u00e0nh FALSE.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cot_tra_cuu_khong_chinh_xac\"><\/span><b>C\u1ed9t tra c\u1ee9u kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 qu\u00ean r\u1eb1ng h\u00e0m VLOOKUP trong Google Sheets lu\u00f4n t\u00ecm ki\u1ebfm c\u1ed9t \u0111\u1ea7u ti\u00ean (ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i) c\u1ee7a ph\u1ea1m vi tra c\u1ee9u. N\u1ebfu gi\u00e1 tr\u1ecb cho tham \u0111\u1ed1 search_key n\u1eb1m trong c\u1ed9t th\u1ee9 hai ho\u1eb7c m\u1ed9t s\u1ed1 kh\u00e1c, th\u00ec h\u00e0m VLOOKUP s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A:<\/span><\/p>\n<figure id=\"attachment_33416\" aria-describedby=\"caption-attachment-33416\" style=\"width: 588px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33416\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"C\u1ed9t tra c\u1ee9u kh\u00f4ng ch\u00ednh x\u00e1c\" width=\"588\" height=\"374\" title=\"5-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33416\" class=\"wp-caption-text\">C\u1ed9t tra c\u1ee9u kh\u00f4ng ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: Ghi nh\u1edb h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i c\u1ee7a n\u00f3.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_cot_khong_chinh_xac\"><\/span><b>S\u1ed1 c\u1ed9t kh\u00f4ng ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u00f4i khi tham s\u1ed1 th\u1ee9 ba c\u1ee7a Google Sheets VLOOKUP \u0111\u01b0\u1ee3c cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1ecf h\u01a1n 1 v\u00e0 nhi\u1ec1u h\u01a1n t\u1ed5ng s\u1ed1 c\u1ed9t trong ph\u1ea1m vi t\u00ecm ki\u1ebfm. N\u1ebfu s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c, h\u00e0m VLOOKUP s\u1ebd b\u00e1o l\u1ed7i #VALUE!.<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: S\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u1ed9t ph\u1ea3i l\u00e0 1 ho\u1eb7c nhi\u1ec1u h\u01a1n. T\u1ea5t nhi\u00ean, kh\u00f4ng ch\u1eafc b\u1ea1n s\u1ebd nh\u1eadp 0 ho\u1eb7c -1, nh\u01b0ng n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ecm d\u00e3y s\u1ed1 t\u1eeb m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u, b\u1ea1n s\u1ebd g\u1eb7p nhi\u1ec1u l\u1ed7i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111i\u1ec1u \u0111\u00f3 x\u1ea3y ra, h\u00e3y \u0111\u1ebfm s\u1ed1 c\u1ed9t trong ph\u1ea1m vi \u0111\u00e3 nh\u1eadp v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng bao g\u1ed3m tham s\u1ed1 th\u1ee9 ba c\u1ee7a h\u00e0m VLOOKUP.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_khong_chinh_xac\"><\/span><b>Tham chi\u1ebfu kh\u00f4ng ch\u00ednh x\u00e1c\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ph\u1ea1m vi t\u00ecm ki\u1ebfm c\u00f3 th\u1ec3 n\u1eb1m trong m\u1ed9t b\u1ea3ng kh\u00e1c ho\u1eb7c th\u1eadm ch\u00ed m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c c\u1ee7a Google.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i #REF! T\u1eeb Google.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 ngh\u0129a l\u00e0 ph\u1ea1m vi b\u1ea1n \u0111\u01b0a v\u00e0o c\u00f4ng th\u1ee9c kh\u00f4ng ch\u00ednh x\u00e1c v\u00e0 kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c ph\u1ea1m vi \u0111\u00f3.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_so_khong_chinh_xac\"><\/span><b>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u00f3i c\u00e1ch kh\u00e1c, \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c (D3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y) v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i trong ph\u1ea1m vi t\u00ecm ki\u1ebfm (A3:A21 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y) kh\u00e1c nhau (s\u1ed1 v\u00e0 v\u0103n b\u1ea3n).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n s\u1eed d\u1ee5ng m\u00e3 s\u1ed1 thay v\u00ec nh\u1eadp b\u1eb1ng v\u0103n b\u1ea3n (s\u1ed1 \u0111\u01a1n h\u00e0ng, ID, ng\u00e0y th\u00e1ng v\u00e0 m\u00e3 s\u1ed1 kh\u00e1c).<\/span><\/p>\n<figure id=\"attachment_33405\" aria-describedby=\"caption-attachment-33405\" style=\"width: 524px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33405\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c\" width=\"524\" height=\"464\" title=\"6-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33405\" class=\"wp-caption-text\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0 trong v\u00ed d\u1ee5 b\u00ean tr\u00ean, c\u00e1c gi\u00e1 tr\u1ecb tr\u00f4ng gi\u1ed1ng nhau nh\u01b0ng m\u1ee5c \u0111\u01b0\u1ee3c nh\u1eadp trong D6 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng nh\u01b0 m\u1ed9t con s\u1ed1 trong khi A10 l\u00e0 v\u0103n b\u1ea3n. M\u1ed9t v\u0103n b\u1ea3n kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c coi nh\u01b0 m\u1ed9t con s\u1ed1, l\u00e0m cho h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A trong Google Sheets.<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhanh ch\u00f3ng v\u1ea5n \u0111\u1ec1 n\u00e0y?<\/span><\/p>\n<p><span style=\"font-weight: 400\">1. B\u1ea1n c\u00f3 th\u1ec3 th\u00eam h\u00e0m TEXT s\u1ebd chuy\u1ec3n \u0111\u1ed5i b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o th\u00e0nh v\u0103n b\u1ea3n.<\/span><\/p>\n<figure id=\"attachment_33406\" aria-describedby=\"caption-attachment-33406\" style=\"width: 524px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33406\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"7 Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi vi\u1ebft h\u00e0m Vlookup trong Google Sheet\" width=\"524\" height=\"353\" title=\"7-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33406\" class=\"wp-caption-text\">7 Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi vi\u1ebft h\u00e0m Vlookup trong Google Sheet<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 sau:<\/span><\/p>\n<p><strong>=VLOOKUP(TEXT(D6,\u201d#\u201d),$A$3:$B$21,2,FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong khi thay th\u1ebf tham chi\u1ebfu \u00f4 D6 th\u00e0nh m\u1ed9t h\u00e0m kh\u00e1c:<\/span><\/p>\n<p><strong>TEXT(D6,\u201d#\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m <strong>TEXT<\/strong> r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400\">Tham s\u1ed1 \u0111\u1ea7u ti\u00ean, s\u1ed1, ch\u1ec9 ra \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng.<\/span><\/li>\n<li><span style=\"font-weight: 400\">Tham s\u1ed1 th\u1ee9 hai, \u0111\u1ecbnh d\u1ea1ng l\u00e0 m\u1ed9t m\u1eabu m\u00e0 th\u00f4i s\u1ebd chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">2. N\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t l\u1ed7i nh\u01b0 th\u1ebf n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i nhanh h\u01a1n b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1. Ch\u1ecdn \u00f4 v\u00e0 nh\u1ea5n Format &gt; Number &gt; \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n trong menu Google Sheets. N\u1ed9i dung c\u1ee7a n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh v\u0103n b\u1ea3n:<\/span><\/p>\n<figure id=\"attachment_33407\" aria-describedby=\"caption-attachment-33407\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33407\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"B\u01b0\u1edbc 2: \u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c\" width=\"627\" height=\"448\" title=\"8-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33407\" class=\"wp-caption-text\">B\u01b0\u1edbc 2: \u0110\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y, l\u1ed7i \u0111\u00e3 x\u1ea3y ra v\u00ec ch\u00fang ta \u0111ang t\u00ecm gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n trong s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Khoang_trang_thua_va_cac_ky_tu_dac_biet\"><\/span><b>Kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c v\u00ec \u00f4 ch\u1ee9a th\u1eeba kho\u1ea3ng tr\u1eafng ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t (xu\u1ed1ng d\u00f2ng v\u00e0 c\u00e1c k\u00fd t\u1ef1 kh\u00e1c).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 l\u1ed7i v\u00ec c\u00f3 ai kho\u1ea3ng tr\u1eafng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o D4 m\u1ed9t c\u00e1ch v\u00f4 t\u00ecnh. V\u00ec h\u00e0m so s\u00e1nh c\u00e1c k\u00fd hi\u1ec7u, vi\u1ec7c t\u00ecm ki\u1ebfm s\u1ebd kh\u00f4ng th\u00e0nh c\u00f4ng:<\/span><\/p>\n<figure id=\"attachment_33408\" aria-describedby=\"caption-attachment-33408\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33408\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"Kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t\" width=\"525\" height=\"468\" title=\"9-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33408\" class=\"wp-caption-text\">Kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra kh\u00e1 th\u01b0\u1eddng xuy\u00ean v\u00e0 h\u1ea7u nh\u01b0 kh\u00f4ng th\u1ec3 ki\u1ec3m tra b\u1eb1ng m\u1eaft th\u01b0\u1eddng. V\u00ed d\u1ee5: n\u1ebfu gi\u00e1 tr\u1ecb bao g\u1ed3m hai t\u1eeb, th\u00ec m\u1ed9t kho\u1ea3ng tr\u1ed1ng th\u1eeba c\u00f3 th\u1ec3 n\u1eb1m gi\u1eefa c\u00e1c t\u1eeb.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1eadp nh\u1ea7m nh\u1eefng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0 v\u1eady b\u1ecb \u1ea9n tr\u00ean m\u00e0n h\u00ecnh (b\u1ea3ng, ng\u1eaft d\u00f2ng,\u2026).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 gi\u1ea3i ph\u00e1p:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400\"> C\u00e1c ch\u1ee9c n\u0103ng v\u0103n b\u1ea3n TRIM v\u00e0 CLEAN s\u1ebd gi\u00fap v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c k\u00fd t\u1ef1 t\u1ef1 \u1ea9n kh\u00f4ng mong mu\u1ed1n:<\/span><\/li>\n<\/ol>\n<p><strong>=VLOOKUP(TRIM(CLEAN(D4)),$A$3:$B$21,2,FALSE)<\/strong><\/p>\n<figure id=\"attachment_33409\" aria-describedby=\"caption-attachment-33409\" style=\"width: 524px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33409\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"C\u00e1c ch\u1ee9c n\u0103ng v\u0103n b\u1ea3n TRIM v\u00e0 CLEAN\" width=\"524\" height=\"422\" title=\"10-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33409\" class=\"wp-caption-text\">C\u00e1c ch\u1ee9c n\u0103ng v\u0103n b\u1ea3n TRIM v\u00e0 CLEAN<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">H\u00e0m TRIM x\u00f3a c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba trong khi h\u00e0m CLEAN x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng in \u0111\u01b0\u1ee3c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb9o: B\u1ea1n lu\u00f4n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c ch\u1ee9c n\u0103ng n\u00e0y \u201cch\u1ec9 trong tr\u01b0\u1eddng h\u1ee3p\u201d \u0111\u1ec3 tr\u00e1nh b\u1ea5t k\u1ef3 l\u1ed7i n\u00e0o.<\/span><\/p>\n<ol start=\"2\">\n<li><span style=\"font-weight: 400\"> Ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove t\u1eeb Power Tools \u0111\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n c\u00f9ng m\u1ed9t l\u00fac:<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_33410\" aria-describedby=\"caption-attachment-33410\" style=\"width: 302px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33410\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove t\u1eeb Power Tools\" width=\"302\" height=\"425\" title=\"11-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33410\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove t\u1eeb Power Tools<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Thay_the_loi_VLOOKUP_bang_van_ban\"><\/span><b>Thay th\u1ebf l\u1ed7i VLOOKUP b\u1eb1ng v\u0103n b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">T\u00f4i ngh\u0129 r\u1eb1ng b\u1ea1n s\u1ebd \u0111\u1ed3ng \u00fd v\u1edbi th\u1ef1c t\u1ebf l\u00e0 c\u00e1c l\u1ed7i kh\u00f4ng l\u00e0m cho b\u1ea3ng c\u1ee7a b\u1ea1n tr\u00f4ng \u0111\u1eb9p h\u01a1n. C\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00fang kh\u00f4ng?<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00e2ng, c\u00f3 nh\u01b0ng s\u1ebd kh\u00f4ng c\u00f3 \u1ea3nh h\u01b0\u1edfng g\u00ec n\u1ebfu tr\u01b0\u1edbc ti\u00ean h\u00e3y ki\u1ec3m tra l\u1ea1i xem c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n trong Google Sheets c\u00f3 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng ch\u00ednh x\u00e1c hay kh\u00f4ng:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1eaft \u0111\u1ea7u v\u1edbi ph\u1ea1m vi tra c\u1ee9u. B\u1ea1n \u0111\u00e3 \u0111\u1eb7t n\u00f3 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c? Gi\u00e1 tr\u1ecb c\u1ee7a b\u1ea1n c\u00f3\u00a0 xu\u1ea5t hi\u1ec7n \u1edf c\u00e1c c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a ph\u1ea1m vi n\u00e0y kh\u00f4ng?<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ea3m b\u1ea3o tham s\u1ed1 \u201cis_sorted\u201d l\u00e0 ch\u00ednh x\u00e1c: TRUE ho\u1eb7c FALSE, t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u00e0 c\u00e1ch s\u1eafp x\u1ebfp ph\u1ea1m vi c\u1ee7a b\u1ea1n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ki\u1ec3m tra t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f3 th\u1ec3 kh\u00f4ng kh\u1edbp v\u00e0 d\u1ea5u c\u00e1ch th\u1eeba ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t,<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">N\u1ebfu m\u1ecdi th\u1ee9 \u0111\u1ec1u \u1ed5n nh\u01b0ng c\u00f4ng th\u1ee9c kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb, h\u00e3y th\u00eam h\u00e0m IFERROR v\u00e0o \u0111\u00f3:<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP(D9,$A$3:$B$21,2,FALSE),\u201dNo items\u201d)<\/strong><\/p>\n<figure id=\"attachment_33411\" aria-describedby=\"caption-attachment-33411\" style=\"width: 577px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33411\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet.png\" alt=\"Thay th\u1ebf l\u1ed7i VLOOKUP b\u1eb1ng v\u0103n b\u1ea3n\" width=\"577\" height=\"374\" title=\"12-nhe1bbafng-le1bb97i-thc6b0e1bb9dng-ge1bab7p-khi-vie1babft-hc3a0m-vlookup-trong-google-sheet\"><figcaption id=\"caption-attachment-33411\" class=\"wp-caption-text\">Thay th\u1ebf l\u1ed7i VLOOKUP b\u1eb1ng v\u0103n b\u1ea3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m <strong>IFERROR<\/strong> r\u1ea5t d\u1ec5 hi\u1ec3u:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Value \u2013 gi\u00e1 tr\u1ecb m\u00e0 ch\u00fang ta ki\u1ec3m tra l\u1ed7i. N\u1ebfu m\u1ecdi th\u1ee9 \u0111\u1ec1u \u1ed5n, k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n c\u1ee7a ch\u00fang ta s\u1ebd tr\u1ea3 v\u1ec1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">[value_if_error] \u2013 gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 n\u1ebfu tham s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecb l\u1ed7i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y nh\u1ea5n F9 hi\u1ec3n th\u1ecb \u201cNo items\u201d b\u1edfi v\u00ec h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y b\u1ea5t k\u1ef3 k\u1ebft qu\u1ea3 n\u00e0o ph\u00f9 h\u1ee3p.<\/span><\/p>\n<p><em><span style=\"font-weight: 400\"><strong>H\u1ecdc Excel Online<\/strong> \u0111\u00e3 gi\u1edbi thi\u1ec7u b\u1ea1n c\u00e1ch ki\u1ec3m tra <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-cac-loi-thuong-gap-nguyen-nhan-va-cach-khac-phuc.html\">l\u1ed7i th\u01b0\u1eddng g\u1eb7p c\u1ee7a h\u00e0m VLOOKUP<\/a> trong Google Sheet<\/strong>. N\u1ebfu c\u00f2n b\u1ea5t k\u1ef3 c\u00e2u h\u1ecfi n\u00e0o d\u1eebng ng\u1ea1i ng\u1ea7n m\u00e0 cmt xu\u1ed1ng ph\u00eda bne d\u01b0\u1edbi \u0111\u1ec3 ch\u00fang t\u00f4i c\u00f3 th\u1ec3 gi\u1ea3i \u0111p\u00e1 th\u1ecfa \u0111\u00e1ng cho b\u1ea1n trong th\u1eddi gian ng\u1eafn nh\u1ea5t.<\/span><\/em><\/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-395.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4819,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4818","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4818","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=4818"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4818\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4819"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}