{"id":10890,"date":"2025-01-15T00:29:34","date_gmt":"2025-01-15T00:29:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel\/"},"modified":"2025-01-15T00:29:34","modified_gmt":"2025-01-15T00:29:34","slug":"cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m FIND ho\u1eb7c SEARCH trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>M\u1ed1 s\u1ed1 nguy\u00ean nh\u00e2n c\u00f3 th\u1ec3 g\u00e2y ra l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m FIND ho\u1eb7c SEARCH trong Excel. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i trong Excel, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i b\u00e0i vi\u1ebft sau \u0111\u00e2y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a><\/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-6787016d7474c\" 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\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel.html#Chuoi_can_tim_khong_duoc_tim_thay\" title=\"Chu\u1ed7i c\u1ea7n t\u00ecm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y\">Chu\u1ed7i c\u1ea7n t\u00ecm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y<\/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\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel.html#Vi_tri_bat_dau_tim_kiem_bat_dau_tu_so_0\" title=\"V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 0\">V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 0<\/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\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel.html#Vi_tri_bat_dau_tim_lon_hon_do_dai_cua_chuoi_de_tim_kiem\" title=\"V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ec3 t\u00ecm ki\u1ebfm\">V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chuoi_can_tim_khong_duoc_tim_thay\"><\/span>Chu\u1ed7i c\u1ea7n t\u00ecm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Find v\u00e0 Search \u0111\u1ec1u l\u00e0 2 h\u00e0m t\u00ecm ki\u1ebfm k\u00ed t\u1ef1 trong 1 chu\u1ed7i k\u00ed t\u1ef1 kh\u00e1c trong Excel, v\u00ec v\u1eady khi chu\u1ed7i k\u00ed t\u1ef1 c\u1ea7n t\u00ecm kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong chu\u1ed7i \u0111ang t\u00ecm s\u1ebd g\u00e2y ra l\u1ed7i #VALUE!<\/p>\n<p>V\u00ed d\u1ee5: t\u00ecm Word trong chu\u1ed7i \u201cH\u1ecdc Excel Online\u201d:<\/p>\n<p><strong>=FIND(\u201cWord\u201d, \u201cH\u1ecdc Excel Online\u201d,1)<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m tr\u00ean s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 #VALUE! b\u1edfi v\u00ec Word kh\u00f4ng c\u00f3 m\u1eb7t trong chu\u1ed7i \u201cH\u1ecdc Excel Online\u201d<\/p>\n<p>Xem th\u00eam: <strong>Nh\u1eadn di\u1ec7n v\u00e0 s\u1eeda t\u1ea5t c\u1ea3 c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\">l\u1ed7i Excel<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_tri_bat_dau_tim_kiem_bat_dau_tu_so_0\"><\/span>V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 0<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m FIND ho\u1eb7c SEARCH c\u00f3 tham s\u1ed1 th\u1ee9 3 l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm, m\u1eb7c \u0111\u1ecbnh th\u00ec tham s\u1ed1 n\u00e0y c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 1 n\u1ebfu ch\u00fang ta b\u1ecf qua. Tuy nhi\u00ean n\u1ebfu tham s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c g\u00e1n cho gi\u00e1 tr\u1ecb b\u1eb1ng 0 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m FIND ho\u1eb7c SEARCH s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 #VALUE!<\/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\/2025\/01\/ex101_92019-nho-235.gif\" title=\"ex101_92019-nho-235\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00e1ch x\u1eed l\u00fd: b\u1ecf qua vi\u1ec7c g\u00e1n gi\u00e1 tr\u1ecb cho tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c n\u00e0y n\u1ebfu kh\u00f4ng c\u1ea7n thi\u1ebft<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_tri_bat_dau_tim_lon_hon_do_dai_cua_chuoi_de_tim_kiem\"><\/span>V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ec3 t\u00ecm ki\u1ebfm<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t v\u00ed d\u1ee5 cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<p><strong><i class=\"ocpItalic\">=FIND(\u201cs\u201d,\u201dFunctions and formulas\u201d,25)<\/i><\/strong><\/p>\n<p>Tuy r\u1eb1ng trong chu\u1ed7i c\u1ea7n t\u00ecm c\u00f3 k\u00ed t\u1ef1 \u201cs\u201d nh\u01b0ng k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m FIND tr\u1ea3 v\u1ec1 v\u1eabn l\u00e0 #VALUE! b\u1edfi v\u00ec tham s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m FIND \u2013 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u \u0111\u1ec3 t\u00ecm ki\u1ebfm l\u1edbn h\u01a1n s\u1ed1 k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i \u201cFunctions and formulas\u201d<\/p>\n<p>C\u00e1ch x\u1eed l\u00fd: S\u1eeda l\u1ea1i tham s\u1ed1 v\u1ec1 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm trong c\u00f4ng th\u1ee9c cho ph\u00f9 h\u1ee3p<\/p>\n<p>Ngo\u00e0i ki\u1ebfn th\u1ee9c \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i n\u00e0y, c\u00f3 th\u1ec3 b\u1ea1n n\u00ean xem th\u00eam b\u00e0i t\u1ed5ng h\u1ee3p c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m trong Excel \u1edf link sau \u0111\u00e2y:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\"><strong>L\u1ed7i #VALUE!, #REF!, #NUM, #N\/A, #DIV\/0!, #NAME?, #NULL! trong Excel v\u00e0 c\u00e1ch s\u1eeda<\/strong><\/a><\/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\/2025\/01\/ex101_92019-nho-235.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10890","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\/10890","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=10890"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10891"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}