{"id":9770,"date":"2025-01-02T21:19:17","date_gmt":"2025-01-02T21:19:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel\/"},"modified":"2025-01-02T21:19:17","modified_gmt":"2025-01-02T21:19:17","slug":"huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m LEFT trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>VLOOKUP l\u00e0 m\u1ed9t h\u00e0m c\u01a1 b\u1ea3n v\u00e0 hay s\u1eed d\u1ee5ng trong\u00a0Excel d\u00f9ng\u00a0\u0111\u1ec3 t\u00ecm ki\u1ebfm, tham chi\u1ebfu theo 1 gi\u00e1 tr\u1ecb. Nh\u01b0ng trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta mu\u1ed1n d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 d\u1ef1a theo m\u1ed9t s\u1ed1\u00a0k\u00fd t\u1ef1 nh\u1ea5t\u00a0\u0111\u1ecbnh ch\u1ee9 kh\u00f4ng ph\u1ea3i to\u00e0n b\u1ed9 c\u00e1c k\u00fd t\u1ef1\u00a0c\u1ee7a\u00a0\u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Trong tr\u01b0\u1eddng h\u1ee3p nh\u01b0 v\u1eady ch\u00fang ta s\u1ebd c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m LEFT b\u00ean trong h\u00e0m VLOOKUP. Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/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-677702d43ee08\" 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\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel.html#Xac_dinh_bo_phan_lam_viec_theo_ma_nhan_vien\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh b\u1ed9 ph\u1eadn l\u00e0m vi\u1ec7c theo m\u00e3 nh\u00e2n vi\u00ean\">X\u00e1c\u00a0\u0111\u1ecbnh b\u1ed9 ph\u1eadn l\u00e0m vi\u1ec7c theo m\u00e3 nh\u00e2n vi\u00ean<\/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\/huong-dan-cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel.html#Tham_chieu_voi_1_so_o_dinh_dang_Text\" title=\"Tham chi\u1ebfu v\u1edbi 1 s\u1ed1\u00a0\u1edf\u00a0\u0111\u1ecbnh d\u1ea1ng Text\">Tham chi\u1ebfu v\u1edbi 1 s\u1ed1\u00a0\u1edf\u00a0\u0111\u1ecbnh d\u1ea1ng Text<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Xac_dinh_bo_phan_lam_viec_theo_ma_nhan_vien\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh b\u1ed9 ph\u1eadn l\u00e0m vi\u1ec7c theo m\u00e3 nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 1 b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean v\u1edbi 3 c\u1ed9t: M\u00e3 nh\u00e2n vi\u00ean, H\u1ecd t\u00ean, B\u1ed9 ph\u1eadn nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23531\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-left-vi-du-01.png\" width=\"715\" height=\"236\" title=\"vlookup-left-vi-du-01\"><\/p>\n<p>Trong\u00a0\u0111\u00f3 m\u00e3 nh\u00e2n vi\u00ean g\u1ed3m 5 k\u00fd t\u1ef1, 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u\u00a0\u0111\u1ea1i di\u1ec7n cho b\u1ed9 ph\u1eadn l\u00e0m vi\u1ec7c.<\/p>\n<p>B\u1ea3ng E1:F5 bao g\u1ed3m n\u1ed9i dung chi ti\u1ebft t\u00ean c\u00e1c b\u1ed9 ph\u1eadn.<\/p>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 tra c\u1ee9u\u00a0\u0111\u01b0\u1ee3c B\u1ed9 ph\u1eadn c\u1ee7a t\u1eebng ng\u01b0\u1eddi c\u0103n c\u1ee9 v\u00e0o M\u00e3 c\u1ee7a h\u1ecd?<\/p>\n<p><strong>C\u00e1ch l\u00e0m:<\/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\/2025\/01\/ex101_92019-nho-89.gif\" title=\"ex101_92019-nho-89\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 tra c\u1ee9u\u00a0\u0111\u01b0\u1ee3c b\u1ed9 ph\u1eadn theo m\u00e3 nh\u00e2n vi\u00ean, ch\u00fang ta c\u1ea7n l\u00e0m 2 vi\u1ec7c sau:<\/p>\n<ul>\n<li>Th\u1ee9 1: T\u00e1ch\u00a0\u0111\u01b0\u1ee3c 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u trong m\u00e3 nh\u00e2n vi\u00ean b\u1eb1ng h\u00e0m LEFT<\/li>\n<li>Th\u1ee9 2: S\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m LEFT\u00a0\u0111\u1ec3 tham chi\u1ebfu trong b\u1ea3ng E1:F5\u00a0\u0111\u1ec3 t\u00ecm b\u1ed9 ph\u1eadn t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/li>\n<\/ul>\n<p>V\u1ec1 <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT<\/strong> ch\u00fang ta c\u00f3:<\/p>\n<p>=LEFT(text,\u00a0[num_chars])<\/p>\n<ul>\n<li>text:\u00a0\u0111o\u1ea1n v\u0103n b\u1ea3n c\u1ea7n t\u00e1ch k\u00fd t\u1ef1<\/li>\n<li>num_chars: s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch. N\u1ebfu kh\u00f4ng nh\u1eadp th\u00ec s\u1ebd t\u1ef1 nh\u1eadn gi\u00e1 tr\u1ecb l\u00e0 1<\/li>\n<\/ul>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, s\u1ed1\u00a0k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch l\u00e0 2, do\u00a0\u0111\u00f3 ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23532\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/su-dung-ham-left-tach-2-ky-tu.png\" width=\"441\" height=\"131\" title=\"su-dung-ham-left-tach-2-ky-tu\"><\/p>\n<p>T\u1ea1i\u00a0\u00f4 C2 s\u1eed d\u1ee5ng h\u00e0m =LEFT(A2,2) ta thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u c\u1ee7a\u00a0\u00f4 A2.<\/p>\n<p>Ti\u1ebfp theo, ch\u00fang ta tham chi\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m LEFT t\u1edbi v\u00f9ng b\u1ea3ng E1:F5\u00a0\u0111\u1ec3 t\u00ecm t\u00ean b\u1ed9 ph\u1eadn. Khi\u00a0\u0111\u00f3 coi k\u1ebft qu\u1ea3 h\u00e0m LEFT ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<p>Vi\u1ebft h\u00e0m VLOOKUP l\u1ed3ng v\u1edbi\u00a0h\u00e0m LEFT nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23533\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-ket-hop-left-01.png\" width=\"430\" height=\"210\" title=\"vlookup-ket-hop-left-01\"><\/p>\n<p>=VLOOKUP(LEFT(A2,2),E1:F5,2,0)<\/p>\n<p>Trong\u00a0\u0111\u00f3\u00a0k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm l\u00e0 c\u1ed9t th\u1ee9 2 trong v\u00f9ng b\u1ea3ng E1:F5. Ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu l\u00e0 t\u00ecm ch\u00ednh x\u00e1c theo k\u00fd hi\u1ec7u n\u00ean s\u1eed d\u1ee5ng s\u1ed1 0.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_voi_1_so_o_dinh_dang_Text\"><\/span>Tham chi\u1ebfu v\u1edbi 1 s\u1ed1\u00a0\u1edf\u00a0\u0111\u1ecbnh d\u1ea1ng Text<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 th\u1ec3\u00a0\u00edt khi b\u1ea1n g\u1eb7p tr\u01b0\u1eddng h\u1ee3p n\u00e0y, nh\u01b0ng trong K\u1ebf to\u00e1n th\u00ec g\u1eb7p nhi\u1ec1u,\u00a0\u0111\u00f3 l\u00e0 khi s\u1eed d\u1ee5ng c\u00e1c t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n, ch\u00fang ta r\u1ea5t hay nh\u1ea7m l\u1eabn kh\u00f4ng bi\u1ebft con s\u1ed1\u00a0\u0111\u00f3\u00a0\u1edf d\u1ea1ng Text hay d\u1ea1ng s\u1ed1. Do\u00a0\u0111\u00f3 khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP ra k\u1ebft qu\u1ea3 l\u1ed7i #N\/A nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23142\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-vlookup-so-cai.png\" width=\"912\" height=\"245\" title=\"loi-vlookup-so-cai\"><\/p>\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong><\/p>\n<p>Trong h\u00e0m VLOOKUP, v\u1ecb tr\u00ed\u00a0\u00f4 I1 l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng S\u1ed1<\/p>\n<p>Trong v\u00f9ng\u00a0DM_TK!A5:E315 th\u00ec c\u1ed9t S\u1ed1 TK (c\u1ed9t A)\u00a0l\u1ea1i l\u00e0 d\u1ea1ng Text<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23143\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mau-danh-muc-tai-khoan-ke-toan.png\" width=\"633\" height=\"349\" title=\"mau-danh-muc-tai-khoan-ke-toan\"><\/p>\n<p>Khi\u00a0\u0111\u00f3\u00a0Excel s\u1ebd coi 2 d\u1eef li\u1ec7u n\u00e0y kh\u00f4ng t\u01b0\u01a1ng\u00a0\u0111\u1ed3ng v\u1edbi nhau. D\u1eabn t\u1edbi kh\u00f4ng t\u00ecm ra k\u1ebft qu\u1ea3.<\/p>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c\u00a0\u0111i\u1ec1u n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m LEFT v\u00e0 h\u00e0m LEN\u00a0\u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 I1 v\u1ec1 d\u1ea1ng TEXT. Khi\u00a0\u0111\u00f3 tham chi\u1ebfu b\u1eb1ng h\u00e0m VLOOKUP s\u1ebd ch\u00ednh x\u00e1c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23145\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-vlookup-so-cai-ket-qua.png\" width=\"909\" height=\"241\" title=\"loi-vlookup-so-cai-ket-qua\"><\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT n\u00e2ng cao k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m trong Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m LEFT r\u1ed3i. Trong n\u1ed9i dung n\u00e0y, c\u00e1c b\u1ea1n n\u00ean ch\u00fa\u00a0\u00fd tr\u00ecnh t\u1ef1 logic: D\u00f9ng h\u00e0m LEFT tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 m\u1edbi vi\u1ebft h\u00e0m VLOOKUP l\u1ed3ng b\u00ean ngo\u00e0i. Nh\u01b0 v\u1eady khi vi\u1ebft s\u1ebd ch\u00ednh x\u00e1c h\u01a1n, kh\u00f4ng b\u1ecb sai s\u00f3t c\u0169ng nh\u01b0 d\u1ec5 hi\u1ec3u h\u01a1n.<\/p>\n<p>Ngo\u00e0i ra h\u00e0m VLOOKUP c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi r\u1ea5t nhi\u1ec1u h\u00e0m kh\u00e1c nh\u01b0:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-ket-hop-ham-match-khi-tim-theo-nhieu-cot-chua-ket-qua.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m Match khi t\u00ecm theo nhi\u1ec1u c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ket-hop-vlookup-va-choose-tim-kiem-tu-phai-qua-trai.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p VLOOKUP v\u00e0 CHOOSE: M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb ph\u1ea3i qua tr\u00e1i<\/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-89.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9770","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\/9770","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=9770"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9770\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9771"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}