{"id":8391,"date":"2024-12-22T14:25:29","date_gmt":"2024-12-22T14:25:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/application-vlookup-va-worksheetfunction-vlookup-trong-vba-excel\/"},"modified":"2024-12-22T14:25:29","modified_gmt":"2024-12-22T14:25:29","slug":"application-vlookup-va-worksheetfunction-vlookup-trong-vba-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/application-vlookup-va-worksheetfunction-vlookup-trong-vba-excel\/","title":{"rendered":"Application.VLOOKUP v\u00e0 WorksheetFunction.VLOOKUP trong VBA Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>N\u1ebfu b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng VBA trong c\u00f4ng vi\u1ec7c, c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ebfn h\u00e0m VLOOKUP phi\u00ean b\u1ea3n VBA. C\u00f3 2 h\u00e0m VLOOKUP trong VBA l\u00e0 Application.VLOOKUP v\u00e0 Application.WorksheetFunction.VLOOKUP. 2 h\u00e0m n\u00e0y kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i \u0111\u00e1p cho b\u1ea1n.<\/em><\/p>\n<p>B\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u v\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh v\u1ebd \u0111\u1ec3 bi\u1ebft th\u00eam \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-16-at-00.25.14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1074\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201024%20347'%3E%3C\/svg%3E\" alt=\"Excel n\u00e2ng cao s\u1eed d\u1ee5ng vlookup trong vba\" width=\"1024\" height=\"347\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-16-at-00-25-14-1024x347-1.png 1024w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-16-at-00.25.14-600x203.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-16-at-00.25.14-300x102.png 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-16-at-00.25.14-768x260.png 768w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-16-at-00.25.14-1024x347.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1074\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-16-at-00-25-14-1024x347-1.png\" alt=\"Excel n\u00e2ng cao s\u1eed d\u1ee5ng vlookup trong vba\" width=\"1024\" height=\"347\" title=\"screen-shot-2016-12-16-at-00-25-14-1024x347-1\"><\/a><\/p>\n<p>S\u1ef1 kh\u00e1c nhau c\u01a1 b\u1ea3n c\u1ee7a 2 phi\u00ean b\u1ea3n VLOOKUP n\u00e0y l\u00e0 c\u00e1ch x\u1eed l\u00fd l\u1ed7i khi kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u. Application.VLOOKUP c\u00f3 c\u00e1ch ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i ng\u1eafn g\u1ecdn v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n<p>\u0110\u00f3 l\u00e0 2 phi\u00ean b\u1ea3n c\u1ee7a <strong>h\u00e0m Vlookup trong VBA Excel<\/strong>. Ph\u00e2n bi\u1ec7t chung gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng thao t\u00e1c h\u01a1n trog c\u00f4ng vi\u1ec7c. Ch\u00fac c\u00e1c b\u1ea1n ng\u1ee7 ngon.<\/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":"<p>N\u1ebfu b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng VBA trong c\u00f4ng vi\u1ec7c, c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng..<\/p>\n","protected":false},"author":1,"featured_media":8392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8391","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\/8391","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=8391"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8392"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}