{"id":8519,"date":"2024-12-22T14:46:24","date_gmt":"2024-12-22T14:46:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ham-vlookup-nang-cao-tra-cuu-tra-ve-nhieu-gia-tri\/"},"modified":"2024-12-22T14:46:24","modified_gmt":"2024-12-22T14:46:24","slug":"ham-vlookup-nang-cao-tra-cuu-tra-ve-nhieu-gia-tri","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ham-vlookup-nang-cao-tra-cuu-tra-ve-nhieu-gia-tri\/","title":{"rendered":"H\u00e0m VLOOKUP n\u00e2ng cao, tra c\u1ee9u tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\">Blog H\u1ecdc Excel Online<\/a> c\u00e1c b\u1ea1n s\u1ebd k\u1ebft h\u1ee3p m\u1ed9t s\u1ed1 h\u00e0m trong Excel \u0111\u1ec3 t\u1ea1o ra m\u1ed9t h\u00e0m t\u1ed5ng h\u1ee3p c\u00f3 ch\u1ee9c n\u0103ng d\u00f2 t\u00ecm v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb. Video v\u00e0 b\u00e0i thuy\u1ebft tr\u00ecnh sau \u0111\u00e2y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c m\u1ea3ng t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p n\u00e0y. L\u01b0u \u00fd, sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm CTRL + SHIFT + ENTER \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y.<\/p>\n<p>\u1ee8ng d\u1ee5ng c\u1ee7a c\u00e1ch tra c\u1ee9u ki\u1ec3u n\u00e0y l\u00e0 t\u1ea1o ra phi\u1ebfu xu\u1ea5t kho, \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong video <a href=\"https:\/\/blog.hocexcel.online\/60-%E2%97%8F-cach-tao-phieu-xuat-kho-trong-excel.html\">\u1edf b\u00e0i vi\u1ebft n\u00e0y<\/a><\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Y7NJYbnpXhg\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>\u00a0<\/p>\n<p><strong>Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/strong><\/p>\n<p>[sociallocker id=457]<\/p>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/nu11ritbxbtsnui\/101-hocexcelonline.xlsx?dl=0\">Download<\/a><\/p>\n<p>[\/sociallocker]<\/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-784.gif\" title=\"ex101_92019-nho-784\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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\/2024\/12\/ex101_92019-nho-784.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8519","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\/8519","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=8519"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8519\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8520"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}