{"id":3051,"date":"2024-12-02T09:52:29","date_gmt":"2024-12-02T09:52:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel\/"},"modified":"2024-12-02T09:52:29","modified_gmt":"2024-12-02T09:52:29","slug":"huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\"><em>Vi\u1ec7c s\u1eed d\u1ee5ng <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> ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi ng\u01b0\u1eddi d\u00f9ng Excel, \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m d\u00f2 t\u00ecm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn m\u00e0 ph\u1ea7n \u0111\u00f4ng nh\u1eefng ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel l\u00e0m c\u00f4ng c\u1ee5 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m d\u00f2 t\u00ecm VLOOKUP \u0111\u1ec3 tr\u1ea3 c\u1ea3 m\u1ea3ng gi\u00e1 tr\u1ecb m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng.<\/em><\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc \u0111\u00e2y ta h\u1ea7u nh\u01b0 ch\u1ec9 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m l\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t n\u00e0o \u0111\u00f3, \u0111i\u1ec1u \u0111\u00f3 th\u00ec kh\u00f4ng xa l\u1ea1 g\u00ec. V\u1eady, VLOOKUP\u00a0tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1 m\u1ea3ng, 1 v\u00f9ng gi\u00e1 tr\u1ecb th\u00ec c\u00f3 l\u00e0m \u0111\u01b0\u1ee3c kh\u00f4ng???<\/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-674d835c8b9c2\" 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-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel.html#Hieu_co_ban_ve_mang\" title=\"Hi\u1ec3u c\u01a1 b\u1ea3n v\u1ec1 m\u1ea3ng\">Hi\u1ec3u c\u01a1 b\u1ea3n v\u1ec1 m\u1ea3ng<\/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-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel.html#Su_dung_ham_VLOOKUP_tra_ve_mang_gia_tri_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb trong Excel\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb trong Excel<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel.html#Truong_hop_tra_ve_mang_gia_tri_nam_tren_1_hang\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 h\u00e0ng\">Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 h\u00e0ng<\/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\/huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel.html#Truong_hop_tra_ve_mang_gia_tri_nam_tren_1_cot\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 c\u1ed9t\">Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 c\u1ed9t<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-vlookup-tra-ve-mang-gia-tri-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hieu_co_ban_ve_mang\"><\/span>Hi\u1ec3u c\u01a1 b\u1ea3n v\u1ec1 m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e2u tr\u1ea3 l\u1eddi c\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3. V\u00e0 tr\u01b0\u1edbc khi c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 th\u00ec H\u1ecdc Excel Online hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u01a1 b\u1ea3n v\u1ec1 m\u1ea3ng trong Excel<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n \u0111i\u1ec1u \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-excel-tim-hieu-ve-cong-thuc-mang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\">C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u01a1 b\u1ea3n v\u1ec1 m\u1ea3ng. V\u1eady th\u00ec vi\u1ec7c v\u1eadn d\u1ee5ng v\u00e0o h\u00e0m VLOOKUP nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 \u0111\u01b0\u1ee3c k\u1ebf qu\u1ea3 l\u00e0 1 m\u1ea3ng gi\u00e1 tr\u1ecb ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 1 gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb nh\u01b0 b\u1ea1n v\u1eabn th\u01b0\u1eddng d\u00f9ng tr\u01b0\u1edbc kia???<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-96.gif\" title=\"vba101_92019-nho-96\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-230.gif\" title=\"ex101_92019-nho-230\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP_tra_ve_mang_gia_tri_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111\u1ecdc hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a H\u1ecdc Excel Online th\u00ec t\u1ea5t nhi\u00ean l\u00e0 b\u1ea1n ph\u1ea3i th\u00e0nh t\u1ea1o vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 1 gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb \u0111\u00e3 ph\u1ea3i kh\u00f4ng n\u00e0o \ud83d\ude0a<\/p>\n<p style=\"text-align: justify\">T\u1edbi \u0111\u00e2y th\u00ec \u0111\u1ea3m b\u1ea3o c\u00e1c \u0111i\u1ec1n ki\u1ec7n c\u1ea7n tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 r\u1ed3i nha, v\u00e0 ta s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c t\u00ecm ki\u1ebfm tr\u1ea3 v\u1ec1 m\u1ea3ng ngay b\u00e2y gi\u1edd.<\/p>\n<p style=\"text-align: justify\">Ta c\u00f3 b\u00e0i to\u00e0n nh\u01b0 sau: C\u0103n c\u1ee9 v\u00e0o Product \u0111\u1ec3 l\u1ea5y ra c\u00e1c th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng v\u1ec1 Region, Color, Units, Revenue b\u1eb1ng 1 c\u00f4ng th\u1ee9c duy nh\u1ea5t v\u00e0 kh\u00f4ng ph\u1ea3i th\u1ef1c hi\u1ec7n vi\u1ec7c k\u00e9o c\u00f4ng th\u1ee9c. Ch\u1ec9 c\u1ea7n 1 c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u1ea3 v\u1ec1 1 m\u1ea3ng g\u1ed3m c\u00e1c th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng c\u1ee7a Product m\u00e0 b\u1ea1n ch\u1ecdn trong \u00f4 H3<\/p>\n<blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31002 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-8-1024x342-1.png\" alt=\"huong-dan-su-dung-vlookup-1\" width=\"1024\" height=\"342\" title=\"1-8-1024x342-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Ta s\u1ebd th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 b\u1eb1ng c\u00e1ch n\u00e0o \u0111\u00e2y???<\/p>\n<p style=\"text-align: justify\">B\u1ea1n h\u00e3y quan t\u00e2m t\u1edbi \u0111\u1ed1i s\u1ed1 th\u1ee9 3 <em><strong>(col_index_num)<\/strong><\/em> trong h\u00e0m VLOOKUP, n\u00f3 l\u00e0 c\u1ed9t k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 khi gi\u00e1 tr\u1ecb d\u00f2 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong v\u00f9ng d\u00f2.<\/p>\n<p style=\"text-align: justify\">Thay v\u00ec ch\u1ec9 \u0111\u1ecbnh 1 c\u1ed9t th\u00ec \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c m\u1ea3ng tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb (m\u1ea3ng gi\u00e1 tr\u1ecb) th\u00ec \u0111\u1ed1i s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m VLOOKUP ta s\u1ebd c\u1ea7n 1 m\u1ea3ng (nhi\u1ec1u c\u1ed9t c\u1ea7n tr\u1ea3 v\u1ec1).<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Truong_hop_tra_ve_mang_gia_tri_nam_tren_1_hang\"><\/span>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u1ea1i \u00f4 <strong>H3<\/strong> ta c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p><strong>=VLOOKUP(H3,B3:F10,I2:L2,0)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31003 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-8-1024x339-1.png\" alt=\"huong-dan-su-dung-vlookup-2\" width=\"1024\" height=\"339\" title=\"2-8-1024x339-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>Trong \u0111\u00f3:<\/strong><\/span><\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00e1c \u0111\u1ed1i s\u1ed1 th\u1ee9 1, 2, 4 trong h\u00e0m n\u00e0y v\u1eabn l\u00e0 nh\u1eefng \u0111i\u1ec1u quen thu\u1ed9c (gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u00f9ng t\u00ecm ki\u1ebfm, ki\u1ec3u t\u00ecm ki\u1ebfm)<\/li>\n<li>\u0110\u1ed1i s\u1ed1 th\u1ee9c 3 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong v\u00f9ng I2:L2 ({2,3,4,5})<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Thay v\u00ec b\u1ea1n g\u00f5 c\u00e1c gi\u00e1 tr\u1ecb 2,3,4,5 ra 1 v\u00f9ng n\u1eb1m li\u00ean ti\u1ebfp tr\u00ean c\u00f9ng 1 h\u00e0ng r\u1ed3i tham chi\u1ebfu t\u1edbi v\u00f9ng \u0111\u00f3 (nh\u01b0 m\u00ecnh \u0111\u00e3 l\u00e0m) th\u00ec b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 tr\u1ef1c ti\u1ebfp lu\u00f4n th\u00e0nh {2,3,4,5} <em>(trong d\u1ea5u ngo\u1eb7c nh\u1ecdn nh\u00e9 {})<\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c n\u00e0y th\u00ec tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ch\u1ecdn 1 v\u00f9ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 c\u1ed9t k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 (\u1edf \u0111\u00e2y m\u00ecnh ch\u1ecdn v\u00f9ng I3:L3) sau \u0111\u00f3 g\u00f5 c\u00f4ng th\u1ee9c nh\u01b0 tr\u00ean v\u00e0 \u1ea5n <strong>Ctrl + Shift + Enter<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Excel 365 ho\u1eb7c Excel 2019 th\u00ec c\u00f3 th\u1ec3 b\u1ea1n ch\u1ec9 c\u1ea7n \u1ea5n Enter<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Truong_hop_tra_ve_mang_gia_tri_nam_tren_1_cot\"><\/span>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 m\u1ea3ng gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean 1 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1eeba r\u1ed3i ta \u0111\u00e3 th\u1ef1c hi\u1ec7n s\u1eed d\u1ee5ng VLOOKUP m\u1ea3ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m tr\u00ean c\u00f9ng 1 h\u00e0ng. Tuy nhi\u00ean, b\u1ea1n l\u1ea1i mu\u1ed1n m\u1ea3ng gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u00e0y n\u1eb1m tr\u00ean 1 c\u1ed9t th\u00ec sao???<\/p>\n<p>B\u1ea1n s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 \u0111\u01a1n gi\u1ea3n v\u1edbi m\u1ed9t s\u1ed1 c\u00e1ch nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>C\u00e1ch 1<\/strong> l\u00e0 b\u1ea1n g\u00f5 danh s\u00e1ch c\u00e1c c\u1ed9t c\u1ea7n tr\u1ea3 v\u1ec1 li\u00ean ti\u1ebfp n\u1eb1m tr\u00ean c\u00f9ng 1 c\u1ed9t r\u1ed3i tham chi\u1ebfu t\u1edbi v\u00f9ng \u0111\u00f3 trong \u0111\u1ed1i s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m VLOOKUP<\/li>\n<li><strong>C\u00e1ch 2<\/strong> l\u00e0 b\u1ea1n g\u00f5 tr\u1ef1c ti\u1ebfp v\u00e0o \u0111\u1ed1i s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m nh\u01b0 sau: {2;3;4;5} <em>(ch\u00fa \u00fd d\u1ea5u ngo\u1eb7c nh\u1ecdn v\u00e0 d\u1ea5u ch\u1ea5m ph\u1ea9y)<\/em><\/li>\n<li><strong>C\u00e1ch 3<\/strong> l\u00e0 b\u1ea1n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\">TRANSPOSE <\/a>nh\u01b0 c\u00f4ng th\u1ee9c t\u1ea1i v\u00f9ng I3:I6 d\u01b0\u1edbi \u0111\u00e2y<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31004 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1-1024x459-1.png\" alt=\"huong-dan-su-dung-vlookup-3\" width=\"1024\" height=\"459\" title=\"3-1-1024x459-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb thay v\u00ec 1 gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb nh\u01b0 tr\u01b0\u1edbc kia ta v\u1eabn th\u01b0\u1eddng d\u00f9ng.<\/p>\n<p><span style=\"font-size: 14pt\">Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong><\/span><\/p>\n<hr>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng Index v\u00e0 Match t\u1ed1t h\u01a1n d\u00f9ng Vlookup trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m vlookup thay th\u1ebf h\u00e0m if l\u1ed3ng nhau trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/4-tuyet-chieu-tra-cuu-voi-vlookup-index-match-sumproduct-va-names-range-trong-excel.html\">4 tuy\u1ec7t chi\u00eau tra c\u1ee9u v\u1edbi vlookup, index, match, sumproduct v\u00e0 names range trong excel<\/a><\/strong><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-96.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3051","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\/3051","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=3051"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3051\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3052"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}