{"id":2501,"date":"2024-12-02T07:59:08","date_gmt":"2024-12-02T07:59:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi\/"},"modified":"2024-12-02T07:59:08","modified_gmt":"2024-12-02T07:59:08","slug":"cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi\/","title":{"rendered":"C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP NHI\u1ec0U GI\u00c1 TR\u1eca V\u1edaI M\u1ed8T HO\u1eb6C NHI\u1ec0U TI\u00caU CH\u00cd"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft sau \u0111\u00e2y,<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec1 <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> nhi\u1ec1u k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p trong Excel d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 trong m\u1ed9t c\u1ed9t, m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t \u00f4.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Khi s\u1eed d\u1ee5ng Microsoft Excel \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u00ecnh hu\u1ed1ng th\u01b0\u1eddng g\u1eb7p l\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb cho m\u1ed9t ID c\u1ee5 th\u1ec3 nh\u01b0 t\u00ean, \u0111\u1ecba ch\u1ec9 email ho\u1eb7c m\u1ed9t s\u1ed1 \u0111\u1ecbnh danh duy nh\u1ea5t kh\u00e1c. M\u1ed9t gi\u1ea3i ph\u00e1p ngh\u0129 \u0111\u1ebfn \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng <strong>h\u00e0m Vlookup trong Excel<\/strong> nh\u01b0ng v\u1ea5n \u0111\u1ec1 n\u00f3 ch\u1ec9 tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3 kh\u1edbp duy nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>Vlookup<\/strong> cho nhi\u1ec1u gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n th\u00f4ng qua vi\u1ec7c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p m\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng. N\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u1ea3i th\u00edch nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c nhi\u1ec7m v\u1ee5 t\u01b0\u01a1ng t\u1ef1. Ngo\u00e0i ra b\u00e0i vi\u1ebft c\u0169ng s\u1ebd cung c\u1ea5p cho b\u1ea1n m\u1ed9t s\u1ed1 m\u1eb9o nh\u1ecf ch\u1ec9 b\u1eb1ng c\u00fa nh\u1ea5p chu\u1ed9t m\u00e0 kh\u00f4ng y\u00eau c\u1ea7u b\u1ea5t k\u1ef3 ki\u1ebfn th\u1ee9c n\u00e0o ph\u1ee9c t\u1ea1p n\u00e0o.<\/span><\/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-674d68cb1795a\" 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-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Vlookup_nhieu_gia_tri_bang_cong_thuc\" title=\"Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb b\u1eb1ng c\u00f4ng th\u1ee9c\">Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb b\u1eb1ng c\u00f4ng th\u1ee9c<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Cong_thuc_1_Dung_Vlookup_de_tham_chieu_nhieu_ket_qua_trong_cung_mot_cot\" title=\"C\u00f4ng th\u1ee9c 1: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t\">C\u00f4ng th\u1ee9c 1: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Ham_IF\" title=\"H\u00e0m IF:\">H\u00e0m IF:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Ham_SMALL\" title=\"H\u00e0m SMALL\">H\u00e0m SMALL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Ham_INDEX\" title=\"H\u00e0m INDEX\">H\u00e0m INDEX<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Ham_IFERROR\" title=\"H\u00e0m IFERROR\">H\u00e0m IFERROR<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Cong_thuc_2_Dung_Vlookup_de_tham_chieu_ket_qua_trong_cung_mot_hang\" title=\"C\u00f4ng th\u1ee9c 2: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t h\u00e0ng\">C\u00f4ng th\u1ee9c 2: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t h\u00e0ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Cong_thuc_3_Dung_Vlookup_de_tham_chieu_nhieu_ket_qua_cung_luc_voi_dieu_kien_rang_buoc\" title=\"C\u00f4ng th\u1ee9c 3: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac v\u1edbi \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c\">C\u00f4ng th\u1ee9c 3: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac v\u1edbi \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Truong_hop_tra_nhieu_ket_qua_theo_mot_cot\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 nhi\u1ec1u k\u1ebft qu\u1ea3 theo m\u1ed9t c\u1ed9t\">Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 nhi\u1ec1u k\u1ebft qu\u1ea3 theo m\u1ed9t c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Truong_hop_tra_ve_nhieu_ket_qua_theo_cung_1_hang\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 theo c\u00f9ng 1 h\u00e0ng\">Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 theo c\u00f9ng 1 h\u00e0ng<\/a><\/li>\n<\/ul>\n<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Cach_Vlookup_tra_ve_nhieu_gia_tri_trong_mot_o\" title=\"C\u00e1ch Vlookup tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb trong m\u1ed9t \u00f4\">C\u00e1ch Vlookup tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb trong m\u1ed9t \u00f4<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Du_lieu_goc_va_ket_qua_mong_doi_voi_Ultimate_Suite\" title=\"D\u1eef li\u1ec7u g\u1ed1c v\u00e0 k\u1ebft qu\u1ea3 mong \u0111\u1ee3i v\u1edbi Ultimate Suite\">D\u1eef li\u1ec7u g\u1ed1c v\u00e0 k\u1ebft qu\u1ea3 mong \u0111\u1ee3i v\u1edbi Ultimate Suite<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-nhieu-gia-tri-voi-mot-hoac-nhieu-tieu-chi.html#Ket_hop_cac_hang_trung_lap_thanh_mot_hang\" title=\"K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\">K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vlookup_nhieu_gia_tri_bang_cong_thuc\"><\/span><b>Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb b\u1eb1ng c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf ph\u1ea7n \u0111\u1ea7u h\u01b0\u1edbng d\u1eabn th\u00ec h\u00e0m Vlookup kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb. T\u00e1c v\u1ee5 n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ch\u1ec9 khi k\u1ebft h\u1ee3p c\u00e1c h\u00e0m sau trong c\u00f4ng th\u1ee9c m\u1ea3ng:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">IF \u2013 \u0111\u00e1nh gi\u00e1 \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">SMALL \u2013 nh\u1eadn gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t th\u1ee9 k trong chu\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">INDEX \u2013 tr\u1ea3 v\u1ec1 m\u1ed9t ph\u1ea7n t\u1eed d\u1ef1a tr\u00ean s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">ROW \u2013 tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">COLUMN \u2013 tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">IFERROR \u2013 C\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed sai s\u1ed1.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Dung_Vlookup_de_tham_chieu_nhieu_ket_qua_trong_cung_mot_cot\"><\/span><b>C\u00f4ng th\u1ee9c 1: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 minh h\u1ecda: Ch\u00fang ta c\u00f3 t\u00ean ng\u01b0\u1eddi b\u00e1n c\u1ed9t A, v\u00e0 s\u1ea3n ph\u1ea9m h\u1ecd \u0111\u00e3 b\u00e1n trong c\u1ed9t B. L\u01b0u \u00fd \u1edf c\u1ed9t A ta th\u1ea5y c\u00f3 m\u1ed9t s\u1ed1 t\u00ean ng\u01b0\u1eddi b\u00e1n l\u1eb7p \u0111i l\u1eb7p l\u1ea1i h\u01a1n 1 l\u1ea7n. Nhi\u1ec7m v\u1ee5 c\u1ee7a ch\u00fang ta l\u00e0 th\u1ed1ng k\u00ea ng\u01b0\u1eddi b\u00e1n t\u1ed5ng c\u1ed9ng b\u00e1n nh\u1eefng m\u1eb7t h\u00e0ng n\u00e0o. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp t\u00ean ng\u01b0\u1eddi b\u00e1n ri\u00eang ra m\u1ed9t h\u00e0ng kh\u00e1c, c\u00f3 th\u1ec3 n\u1eb1m trong c\u00f9ng trang t\u00ednh hi\u1ec7n t\u1ea1i. Trong v\u00ed d\u1ee5 n\u00e0y, t\u00ean \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u00e1c \u00f4 D2: G2:<\/span><\/li>\n<\/ol>\n<figure style=\"width: 470px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/source-data-1.png\" alt=\"The source data to Vlookup multiple matches in Excel\" width=\"470\" height=\"201\"><figcaption class=\"wp-caption-text\">D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 \u00a02. Ngay c\u00e1i t\u00ean \u0111\u1ea7u ti\u00ean, h\u00e3y ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng m\u00e0 ng\u01b0\u1eddi b\u00e1n c\u00f3 th\u1ec3 cung c\u1ea5p, sau \u0111\u00f3 nh\u1eadp m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y v\u00e0o ch\u1ed7 tr\u1ed1ng v\u00e0 b\u1ea5m t\u1ed5 h\u1ee3p Ctrl+Shift+Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c trong ph\u1ea1m vi m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn). Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean, nh\u1ea5n Ctrl + Shift + Enter, v\u00e0 sau \u0111\u00f3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t v\u00e0i \u00f4 n\u1eefa trong c\u1ed9t (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c trong t\u1eebng \u00f4 ri\u00eang l\u1ebb).<\/span><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-194.gif\" title=\"ex101_92019-nho-194\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-83.gif\" title=\"vba101_92019-nho-83\"><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-194.gif\" title=\"ex101_92019-nho-194\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><b>=IFERROR(INDEX($B$3:$B$13,SMALL(IF(D$2=$A$3:$A$13,ROW($B$3:$B$13)-2,\u201d\u201d), ROW()-2)),\u201d\u201d)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c l\u00e0:<\/span><\/p>\n<p><b>=IFERROR(INDEX($B$3:$B$13,SMALL(IF(D$2=$A$3:$A$13,ROW($A$3:$A$13)- MIN(ROW($A$3:$A$13))+1,\u201d\u201d), ROW()-2)),\u201d\u201d)<\/b><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean c\u00f3 th\u1ec3 tr\u00f4ng g\u1ecdn nh\u1eb9 h\u01a1n nh\u1eefng c\u00f4ng th\u1ee9c th\u1ee9 hai l\u1ea1i \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn h\u01a1n do \u00edt ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh (c\u1ea5u tr\u00fac c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch c\u1ee5 th\u1ec3 h\u01a1n \u1edf ph\u1ea7n sau).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 3. Sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c c\u1ed9t kh\u00e1c. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c, b\u1ea1n ch\u1ec9 c\u1ea7n b\u00f4i \u0111en ph\u1ea7n c\u1ed9t v\u1eeba \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o\u00a0 v\u00e0 click ph\u00edm \u0111i\u1ec1u h\u01b0\u1edbng (l\u00e0 \u00f4 h\u00ecnh vu\u00f4ng nh\u1ecf n\u1eb1m \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a ph\u1ea7n \u0111\u01b0\u1ee3c b\u00f4i \u0111en) r\u1ed3i k\u00e9o sang ph\u1ea3i l\u00e0 xong.<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<figure style=\"width: 613px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 3: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-values-excel.png\" alt=\"A formula to Vlookup multiple values and return results in a column\" width=\"613\" height=\"321\"><figcaption class=\"wp-caption-text\"><em>B\u01b0\u1edbc 3: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t c\u1ed9t<\/em><\/figcaption><\/figure>\n<p><i><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau:<\/span><\/i><\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Ham_IF\"><\/span><b>H\u00e0m IF:<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u1ed1t l\u00f5i c\u1ee7a c\u00f4ng th\u1ee9c ch\u00ednh l\u00e0 h\u00e0m IF v\u1edbi ch\u1ee9c n\u0103ng l\u00e0 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a t\u1eebng t\u1ed5 h\u1ee3p gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1 c\u1ee7a \u00f4 c\u1ea7n t\u00ecm (D2) trong khu v\u1ef1c c\u1ea7n t\u00ecm l\u00e0 A3:A13: IF(D$2=$A$3:$A$13, ROW($B$3:$B$13)\u20132,\u201d\u201d).<\/span><\/p>\n<p><span style=\"font-weight: 400\">IF so s\u00e1nh gi\u00e1 tr\u1ecb tra c\u1ee9u (D2) v\u1edbi m\u1ed7i gi\u00e1 tr\u1ecb trong v\u00f9ng d\u1eef li\u1ec7u (A3:A13) v\u00e0 n\u1ebfu t\u00ecm th\u1ea5y kh\u1edbp s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng, n\u1ebfu kh\u00f4ng kh\u1edbp m\u1ed9t chu\u1ed7i r\u1ed7ng (\u201c\u201d) xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 gi\u1ed1ng th\u00ec h\u00e0m ROW s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t c\u1ee7a \u00f4 tr\u1ed1ng \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi tr\u1ea3 k\u1ebft qu\u1ea3 (B3:B13). Sau \u0111\u00f3 ch\u00fang ta s\u1ebd t\u00ednh to\u00e1n 1 con s\u1ed1 \u0111\u1ec3 tr\u1eeb b\u1edbt \u0111i sao cho kho\u1ea3ng c\u00e1ch khu v\u1ef1c c\u1ea7n t\u00ecm v\u00e0 khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3 b\u1eb1ng 1. V\u1edbi v\u00ed d\u1ee5 tr\u00ean ta c\u1ea7n tr\u1eeb b\u1edbt \u0111i 2 v\u00ec ph\u1ea7n khu v\u1ef1c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u1eaft \u0111\u1ea7u \u1edf h\u00e0ng th\u1ee9 3. N\u1ebfu khu v\u1ef1c n\u1eb1m \u1edf h\u00e0ng th\u1ee9 2 th\u00ec ph\u1ea3i tr\u1eeb \u0111i 1 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c m\u1ed9t c\u00e1ch kh\u00e1c l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng bi\u1ec3u th\u1ee9c: <\/span><b>ROW(lookup_column)-MIN(ROW(lookup_column))+1<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u00a0Khi \u0111\u00f3 k\u1ebft qu\u1ea3 v\u1eabn tr\u1ea3 v\u1ec1 gi\u1ed1ng nh\u01b0 v\u1eady v\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh g\u00ec m\u1eb7c cho v\u1ecb tr\u00ed c\u1ee7a khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3 \u1edf \u0111\u00e2u.\u00a0 Trong v\u00ed d\u1ee5 n\u00e0y s\u1ebd l\u00e0 <\/span><b>ROW($A$3:$A$13)-MIN(ROW($A$3:$A$13))+1.<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u1ed1ng, th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd c\u00f3 d\u1ea1ng\u00a0 r\u1ed7ng (\u201c\u201d).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111ang c\u00f3 m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 (\u0111\u1ea1i di\u1ec7n cho s\u1ed1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3 gi\u1ed1ng) v\u00e0 c\u00e1c k\u00fd t\u1ef1 d\u1ea1ng r\u1ed7ng (\u0111\u1ea1i di\u1ec7n cho s\u1ed1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3 kh\u00e1c). Gi\u1ea3 s\u1eed v\u00ed d\u1ee5 v\u1edbi \u00f4 D3, ta c\u00f3 t\u1eadp h\u1ee3p k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Th\u1eed ki\u1ec3m tra \u0111\u1ed1i chi\u1ebfu v\u1edbi d\u1eef li\u1ec7u g\u1ed1c, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y l\u00e0 gi\u00e1 tr\u1ecb \u201cAdam\u201d (gi\u00e1 tr\u1ecb tham chi\u1ebfu trong \u00f4 D2) xu\u1ea5t hi\u1ec7n \u1edf v\u1ecb tr\u00ed th\u1ee9 3, 8 v\u00e0 10 c\u1ee7a khu v\u1ef1c k\u1ebft qu\u1ea3 tham chi\u1ebfu (A3:A13).<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_SMALL\"><\/span><b>H\u00e0m SMALL<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, h\u00e0m SMALL(t\u1eadp h\u1ee3p k) \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ea7n tr\u1ea3 v\u1ec1 c\u1ee7a t\u1eebng k\u1ebft qu\u1ea3 tham chi\u1ebfu.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng th\u00f4ng s\u1ed1 \u0111\u00e3 x\u00e1c \u0111\u1ecbnh t\u1eeb tr\u01b0\u1edbc vi\u1ec7c c\u1ea7n l\u00e0m l\u00e0 x\u00e1c \u0111\u1ecbnh s\u1ed1 th\u1ee9 t\u1ef1 \u201ck\u201d t\u1ee9c l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 k nh\u1ecf nh\u1ea5t \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.\u00a0 \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1ea1n s\u1eed d\u1ee5ng b\u1ed9 \u0111\u1ebfm s\u1ed1 d\u01b0\u1edbi d\u1ea1ng h\u00e0m ROW()-n, trong \u0111\u00f3 n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean tr\u1eeb \u0111i 1. Trong v\u00ed d\u1ee5 n\u00e0y, ta \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o d\u1ea3i \u00f4 D3:D7, cho n\u00ean ROW()-2 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1 \u0111\u1ed1i v\u1edbi \u00f4 D3 (h\u00e0ng th\u1ee9 3 tr\u1eeb \u0111i 2 \u0111\u01a1n v\u1ecb) v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2 \u0111\u1ed1i v\u1edbi \u00f4 D4 (h\u00e0ng th\u1ee9 4 tr\u1eeb \u0111i 2 \u0111\u01a1n v\u1ecb), v\u00e0 l\u1eb7p l\u1ea1i t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady.<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 l\u00e0, h\u00e0m SMALL s\u1ebd \u0111\u1eb7t gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a t\u1eadp h\u1ee3p trong \u00f4 D3, gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 nh\u00ec v\u00e0o \u00f4 D4, v\u00e0 c\u1ee9 ti\u1ebfp di\u1ec5n nh\u01b0 th\u1ebf. T\u1eeb \u0111\u00f3, c\u00f4ng th\u1ee9c d\u00e0i lo\u1eb1ng ngo\u1eb1ng ph\u1ee9c t\u1ea1p nh\u01b0 ban \u0111\u1ea7u \u0111\u01b0\u1ee3c gi\u1ea3n l\u01b0\u1ee3c \u0111i th\u00e0nh d\u1ea1ng \u0111\u01a1n gi\u1ea3n h\u01a1n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u1eddi khuy\u00ean: \u0110\u1ec3 nh\u00ecn th\u1ea5y gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n \u1ea9n sau t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c, ch\u1ec9 c\u1ea7n b\u00f4i \u0111en ph\u1ea7n \u0111\u00f3 l\u1ea1i v\u00e0 b\u1ea5m ph\u00edm F9\u201d<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_INDEX\"><\/span><b>H\u00e0m INDEX<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\"><strong>H\u00e0m index<\/strong><\/a> n\u00e0y ho\u1ea1t \u0111\u1ed9ng kh\u00e1 \u0111\u01a1n gi\u1ea3n. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t th\u00e0nh ph\u1ea7n trong t\u1eadp h\u1ee3p d\u1ef1a tr\u00ean s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a n\u00f3.\u00a0<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_IFERROR\"><\/span><b>H\u00e0m IFERROR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, b\u1ea1n l\u00f4ng h\u00e0m IFERROR v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u1eed l\u00fd t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra. \u0110i\u1ec1u n\u00e0y kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi v\u00ec b\u1ea1n s\u1ebd kh\u00f4ng bi\u1ebft c\u00f3 bao nhi\u00eau k\u1ebft qu\u1ea3 tham chi\u1ebfu tr\u1ea3 gi\u1ed1ng nau \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 cho t\u1eebng gi\u00e1 tr\u1ecb, v\u00e0 t\u1eeb \u0111\u00f3 trong qu\u00e1 tr\u00ecnh sao ch\u00e9p c\u00f4ng th\u1ee9c sang nh\u1eefng \u00f4 t\u00ednh kh\u00e1c b\u1ea1n kh\u00f4ng th\u1ec3 bi\u1ebft ch\u00ednh x\u00e1c n\u00ean sao ch\u00e9p bao nhi\u00eau \u00f4 l\u00e0 \u0111\u1ee7. \u0110\u1ec3 tr\u00e1nh xu\u1ea5t hi\u1ec7n nh\u1eefng c\u1ea3nh b\u00e1o l\u1ed7i kh\u00f4ng c\u1ea7n thi\u1ebft, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 d\u1ea1ng string r\u1ed7ng (\u201c\u201d) \u0111\u1ec3 thay th\u1ebf.<\/span><\/p>\n<p><b><i>L\u01b0u \u00fd<\/i><\/b><span style=\"font-weight: 400\">: B\u1ea1n c\u1ea7n ph\u00e2n bi\u1ec7t c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i trong c\u00e1c c\u00f4ng th\u1ee9c Excel. T\u1ea5t c\u1ea3 tham chi\u1ebfu s\u1ebd kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u1ea1i tr\u1eeb c\u1ed9t tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n tham chi\u1ebfu (D$2), \u0111i\u1ec1u n\u00e0y l\u00e0 y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c trong qu\u00e1 tr\u00ecnh sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c c\u1ed9t b\u00ean c\u1ea1nh, \u0111\u1ec3 t\u1eeb \u0111\u00f3 cho ra c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng c\u1ed9t c\u1ee5 th\u1ec3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 nh\u1eefng \u0111i\u1ec1u n\u00e0y l\u1ea1i v\u1edbi nhau, ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c chung sau \u0111\u1ec3 Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb trong Excel:<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c s\u1ed1 1:<\/span><\/i> <b>IFERROR(INDEX( return_range, SMALL(IF( lookup_value = lookup_range, ROW( return_range )- m ,\u201d\u201d), ROW() \u2013 n )),\u201d\u201d)<\/b><\/p>\n<p><i><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c s\u1ed1 2:<\/span><\/i><b> IFERROR(INDEX( return_range, SMALL(IF( lookup_value = lookup_range , ROW( lookup_range) -MIN(ROW( lookup_range ))+1,\u201d\u201d), ROW() \u2013 n)),\u201d\u201d)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">m\u00a0 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ee7a khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3, tr\u1eeb 1 \u0111\u01a1n v\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t c\u1ee7a \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c ban \u0111\u1ea7u, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: Trong v\u00ed d\u1ee5 tr\u00ean, c\u1ea3 m v\u00e0 n \u0111\u1ec1u c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 2 b\u1edfi v\u00ec khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3 v\u00e0 khu v\u1ef1c ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u1ec1u b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng th\u1ee9 3. T\u00f9y theo t\u1eebng b\u1ea3ng t\u00ednh c\u1ee5 th\u1ec3 m\u00e0 con s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 kh\u00e1c nhau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Dung_Vlookup_de_tham_chieu_ket_qua_trong_cung_mot_hang\"><\/span><b>C\u00f4ng th\u1ee9c 2: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu k\u1ebft qu\u1ea3 trong c\u00f9ng m\u1ed9t h\u00e0ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n v\u1eabn mu\u1ed1n tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac nh\u01b0ng c\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd n\u1eb1m tr\u00ean c\u00f9ng 1 h\u00e0ng thay v\u00ec c\u1ed9t th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/span><\/p>\n<p><strong>=IFERROR(INDEX($B$3:$B$13,SMALL(IF($D3=$A$3:$A$13,ROW($B$3:$B$13)-2,\u201d\u201d), COLUMN()-4)),\u201d\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c:<\/span><\/p>\n<p><strong>=IFERROR(INDEX($B$3:$B$13,SMALL(IF($D3=$A$3:$A$13,ROW($A$3:$A$13)-MIN(ROW($A$3:$A$13))+1,\u201d\u201d),COLUMN()-4)), \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1 v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3, \u0111\u00e2y \u0111\u1ec1u l\u00e0 c\u00f4ng th\u1ee9c d\u00e0nh cho t\u1eadp h\u1ee3p, n\u00ean l\u00e0 b\u1ea1n l\u01b0u \u00fd ph\u1ea3i b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm Ctrl+Shift+Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-matches-rows.png\" alt=\"Formula to Vlookup multiple matches and return results in rows\" title=\"vlookup-multiple-matches-rows\"><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a n\u00f3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u00ed d\u1ee5 tr\u01b0\u1edbc, ngo\u1ea1i tr\u1eeb 1 \u0111i\u1ec1u l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COLUMN thay v\u00ec h\u00e0m ROW nh\u1eb1m x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3: COLUMN()-n. Trong \u0111\u00f3 n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean ch\u1ee9a c\u00f4ng th\u1ee9c, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb. Trong v\u00ed d\u1ee5 n\u00e0y c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o d\u1ea3i \u00f4 E2:H2. V\u1edbi vi\u1ec7c c\u1ed9t E n\u1eb1m \u1edf th\u1ee9 t\u1ef1 s\u1ed1 5 th\u00ec khi \u0111\u00f3 n s\u1ebd b\u1eb1ng 4.<\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>L\u01b0u \u00fd:<\/strong> \u0110\u1ec3 c\u00f3 th\u1ec3 sao ch\u00e9p ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c sang c\u00e1c h\u00e0ng kh\u00e1c, l\u01b0u \u00fd h\u00e3y \u0111\u1ec3 th\u00f4ng s\u1ed1 tham chi\u1ebfu d\u1ea1ng tuy\u1ec7t \u0111\u1ed1i theo c\u1ed9t v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i theo h\u00e0ng, ch\u1eb3ng h\u1ea1n: $D3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau khi t\u1ed5ng h\u1ee3p l\u1ea1i, ta c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t d\u00e0nh h\u00e0m Vlookup tham chi\u1ebfu nhi\u1ec1u gi\u00e1 tr\u1ecb c\u00f9ng l\u00fac theo h\u00e0ng trong Excel nh\u01b0 sau:<\/span><\/p>\n<p><b><i>C\u00f4ng th\u1ee9c s\u1ed1 1:<\/i><\/b><span style=\"font-weight: 400\"> IFERROR(INDEX( return_range, SMALL(IF( lookup_value = lookup_range, ROW( return_range) \u2013 m, \u201c\u201d), COLUMN() \u2013 n)), \u201c\u201d)<\/span><\/p>\n<p><b><i>C\u00f4ng th\u1ee9c s\u1ed1 2:<\/i><\/b><span style=\"font-weight: 400\"> IFERROR(INDEX( return_range, SMALL(IF( lookup_value = lookup_range, ROW(lookup_range) \u2013 MIN(ROW( lookup_range))+1,\u201d\u201d),COLUMN() \u2013 n)), \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">m l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t c\u1ee7a \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c ban \u0111\u1ea7u, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Dung_Vlookup_de_tham_chieu_nhieu_ket_qua_cung_luc_voi_dieu_kien_rang_buoc\"><\/span><b>C\u00f4ng th\u1ee9c 3: D\u00f9ng Vlookup \u0111\u1ec3 tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac v\u1edbi \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Vlookup th\u01b0\u1eddng \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn tra c\u1ee9u tr\u1ea3 k\u1ebft qu\u1ea3 trong Excel th\u00f4ng qua 1 \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c. Tuy nhi\u00ean n\u1ebfu b\u1ea1n mu\u1ed1n tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean nhi\u1ec1u h\u01a1n 1 ti\u00eau ch\u00ed? Ch\u1eb3ng h\u1ea1n v\u1edbi v\u00ed d\u1ee5 v\u1eeba r\u1ed3i n\u1ebfu nh\u01b0 th\u00eam m\u1ed9t ti\u00eau ch\u00ed l\u00e0 c\u1ed9t \u201cth\u00e1ng\u201d v\u00e0 y\u00eau c\u1ea7u \u0111\u1eb7t ra l\u00e0m sao ph\u00e2n lo\u1ea1i \u0111\u01b0\u1ee3c danh s\u00e1ch m\u1eb7t h\u00e0ng ng\u01b0\u1eddi b\u00e1n cung c\u1ea5p theo t\u1eebng th\u00e1ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n qu\u00e1 quen v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng, b\u1ea1n s\u1ebd th\u1ea5y l\u00e0 th\u01b0\u1eddng c\u00f3 d\u1ea5u \u201c*\u201d v\u00e0 h\u00e0m AND \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.\u00a0 V\u00ec v\u1eady m\u00e0 b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u00e3 th\u1ea3o lu\u1eadn trong 2 v\u00ed d\u1ee5 tr\u00ean v\u00e0 y\u00eau c\u1ea7u ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0 v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Truong_hop_tra_nhieu_ket_qua_theo_mot_cot\"><\/span><b>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 nhi\u1ec1u k\u1ebft qu\u1ea3 theo m\u1ed9t c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>IFERROR(INDEX(return_range,SMALL(IF(1=((\u2013(lookup_value1=lookup_range1))* (\u2013(lookup_value2=lookup_range2))), ROW(return_range)-m,\u201d\u201d), ROW()-n)),\u201d\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">m l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c ban \u0111\u1ea7u, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed danh s\u00e1ch Seller (ng\u01b0\u1eddi b\u00e1n)\u00a0 (lookup_range1) n\u1eb1m \u1edf d\u1ea3i \u00f4 A1:A30, danh s\u00e1ch Months c\u00e1c th\u00e1ng (lookup_range2) n\u1eb1m \u1edf d\u1ea3i \u00f4 B1:B30, nh\u00e0 ph\u00e2n ph\u1ed1i c\u1ea7n quan t\u00e2m (lookup_value1) n\u1eb1m \u1edf \u00f4 t\u00ednh E3 v\u00e0 th\u00e1ng c\u1ea7n quan t\u00e2m (lookup_value2) n\u1eb1m \u1edf \u00f4 t\u00ednh F3, khi \u0111\u00f3 ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><b>=IFERROR(INDEX($C$3:$C$30,SMALL(IF(1=((\u2013($E$3=$A$3:$A$30))<\/b> <b>*(\u2013($F$3=$B$3:$B$30))), ROW($C$3:$C$30)-2,\u201d\u201d), ROW()-2)),\u201d\u201d)<\/b><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi d\u1ea1ng tr\u00ean, ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thi\u1ebft l\u1eadp n\u00f3 tr\u1edf th\u00e0nh m\u1ed9t b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n, ch\u1eb3ng h\u1ea1n b\u1ea1n ch\u1ec9 c\u1ea7n \u0111i\u1ec1n t\u00ean Seller (ng\u01b0\u1eddi b\u00e1n) v\u00e0o \u00f4 E3 v\u00e0 t\u00ean Month (th\u00e1ng) c\u1ea7n t\u00ecm v\u00e0o \u00f4 F3, l\u1eadp t\u1ee9c k\u1ebft qu\u1ea3 cho ra m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ea3n ph\u1ea9m \u1edf c\u1ed9t G.<\/span><\/p>\n<figure style=\"width: 482px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 nhi\u1ec1u k\u1ebft qu\u1ea3 theo m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-matches-column.png\" alt=\"Vlookup with multiple criteria returning multiple matches in a column\" width=\"482\" height=\"584\"><figcaption class=\"wp-caption-text\"><em>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 nhi\u1ec1u k\u1ebft qu\u1ea3 theo m\u1ed9t c\u1ed9t<\/em><\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Truong_hop_tra_ve_nhieu_ket_qua_theo_cung_1_hang\"><\/span><b>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 theo c\u00f9ng 1 h\u00e0ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y nhi\u1ec1u k\u1ebft qu\u1ea3 tham chi\u1ebfu c\u00f9ng l\u00fac nh\u01b0ng ch\u1ecbu ph\u1ee5 thu\u1ed9c v\u00e0o nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c kh\u00e1c nhau, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng b\u1ed1 c\u1ee5c h\u00e0ng ngang \u0111\u1ec3 k\u1ebft qu\u1ea3 tham chi\u1ebfu s\u1ebd \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed theo c\u00f9ng 1 h\u00e0ng. H\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><b>FERROR(INDEX(return_range, SMALL(IF(1 = ((\u2013(lookup_value1=lookup_range1)) * (\u2013(lookup_value2 = lookup_range2))), ROW(return_range) \u2013 m, \u201c\u201d), COLUMN() \u2013 n)),\u201d\u201d)<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">m l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a khu v\u1ef1c tr\u1ea3 k\u1ebft qu\u1ea3, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 theo h\u00e0ng c\u1ee7a \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c ban \u0111\u1ea7u, tr\u1eeb \u0111i 1 \u0111\u01a1n v\u1ecb.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng d\u1eef li\u1ec7u c\u1ee7a v\u00ed d\u1ee5 tr\u00ean, c\u00f4ng th\u1ee9c s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/span><\/p>\n<p><b>=IFERROR(INDEX($C$3:$C$30,SMALL(IF(1=((\u2013($E3=$A$3:$A$30))*(\u2013($F3=$B$3:$B$30))), ROW($C$3:$C$30)-2,\u201d\u201d), COLUMN()-6)),\u201d\u201d)<\/b><\/p>\n<figure style=\"width: 639px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 theo c\u00f9ng 1 h\u00e0ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-matches-row.png\" alt=\"Vlookup with multiple criteria returning multiple matches in rows\" width=\"639\" height=\"582\"><figcaption class=\"wp-caption-text\"><em>Tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 theo c\u00f9ng 1 h\u00e0ng<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Vlookup \u0111\u1ec3 tham chi\u1ebfu k\u1ebft qu\u1ea3 v\u1edbi 3, 4 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c h\u01a1n.<\/span><\/p>\n<p><b><i>C\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng:<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">V\u1ec1 c\u01a1 b\u1ea3n, c\u00f4ng th\u1ee9c tham chi\u1ebfu nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac b\u1eb1ng h\u00e0m Vlookup r\u00e0ng bu\u1ed9c b\u1edfi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u1eabn c\u00f3 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng nh\u01b0 c\u00e1ch gi\u1ea3i th\u00edch \u1edf v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean. S\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t n\u1eb1m \u1edf ch\u1ed7 h\u00e0m IF b\u00e2y gi\u1edd s\u1ebd ph\u1ea3i x\u1eed l\u00fd nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c h\u01a1n.<\/span><\/p>\n<p><b>1=((\u2013(lookup_value1=lookup_range1))*(\u2013(lookup_value2=lookup_range2))*\u2026)<\/b><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 c\u1ee7a m\u1ed7i qu\u00e1 tr\u00ecnh so s\u00e1nh 2 bi\u1ebfn lookup_value=lookup_range l\u00e0 m\u1ed9t chu\u1ed7i c\u00e1c k\u1ebft qu\u1ea3 logic d\u1ea1ng TRUE (n\u1ebfu \u0111\u00fang) ho\u1eb7c FALSE (n\u1ebfu sai). D\u1ea5u g\u1ea1ch n\u1ed1i \u0111\u00f4i (-) \u0111\u1ec3 bi\u1ebfn k\u1ebft qu\u1ea3 logic th\u00e0nh k\u00fd t\u1ef1 s\u1ed1 1 v\u00e0 0. B\u1edfi v\u00ec b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o nh\u00e2n v\u1edbi 0 c\u0169ng b\u1eb1ng 0 n\u00ean h\u1ea7u nh\u01b0 b\u1ea1n s\u1ebd ch\u1ec9 th\u1ea5y s\u1ed1 1 minh h\u1ecda th\u00e0nh t\u1ed1 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c. B\u00e2y gi\u1edd, b\u1ea1n c\u1ea7n l\u00e0m \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 so s\u00e1nh chu\u1ed7i k\u1ebft qu\u1ea3 v\u1edbi 1 sao cho h\u00e0m ROW tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u00e0ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c, c\u00f2n kh\u00f4ng k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 m\u1ed9t k\u00fd t\u1ef1 r\u1ed7ng.<\/span><\/p>\n<p><b><i>Ch\u00fa \u00fd:<\/i><\/b><span style=\"font-weight: 400\"> T\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c Vlookup trong b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec1u \u1edf d\u1ea1ng c\u00f4ng th\u1ee9c d\u00e0nh cho t\u1eadp h\u1ee3p. V\u00ec th\u1ebf, c\u00f4ng th\u1ee9c s\u1ebd l\u1eb7p l\u1ea1i c\u00e1c th\u00e0nh t\u1ed1 c\u1ee7a chu\u1ed7i m\u1ed7i l\u1ea7n d\u1eef li\u1ec7u g\u1ed1c b\u1ecb thay \u0111\u1ed5i, ho\u1eb7c trang t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i. \u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn v\u1edbi s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0 c\u1ed9t l\u00ean \u0111\u1ebfn h\u00e0ng tr\u0103m th\u00ec qu\u00e1 tr\u00ecnh n\u00e0y s\u1ebd l\u00e0m gi\u1ea3m t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u1ee7a Excel m\u1ed9t c\u00e1ch t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_Vlookup_tra_ve_nhieu_gia_tri_trong_mot_o\"><\/span><b>C\u00e1ch Vlookup tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb trong m\u1ed9t \u00f4<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u1ea7n b\u1ed5 tr\u1ee3 \u0111i k\u00e8m l\u00e0 Ultimate Suite v\u00e0 Combine Rows Wizard d\u00e0nh cho Excel. N\u1ebfu b\u1ea1n ch\u01b0a c\u00f3 n\u00f3 trong Excel th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng phi\u00ean b\u1ea3n d\u00f9ng th\u1eed 14 ng\u00e0y mi\u1ec5n ph\u00ed v\u00e0 ti\u1ebfn h\u00e0nh c\u00e1c b\u01b0\u1edbc nh\u01b0 b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Du_lieu_goc_va_ket_qua_mong_doi_voi_Ultimate_Suite\"><\/span><b>D\u1eef li\u1ec7u g\u1ed1c v\u00e0 k\u1ebft qu\u1ea3 mong \u0111\u1ee3i v\u1edbi Ultimate Suite<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta s\u1ebd ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c v\u1edbi t\u1eadp d\u1eef li\u1ec7u \u0111\u00e3 s\u1eed d\u1ee5ng trong c\u00e1c v\u00ed d\u1ee5 tr\u01b0\u1edbc. Nh\u01b0ng l\u1ea7n nay thay v\u00ec tr\u00edch xu\u1ea5t nhi\u1ec1u k\u1ebft qu\u1ea3 tham chi\u1ebfu trong t\u1eebng \u00f4 ri\u00eang bi\u1ec7t th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n trong m\u1ed9t \u00f4 duy nh\u1ea5t v\u00e0 ph\u00e2n t\u00e1ch b\u1edfi d\u1ea5u ph\u1ea9y, d\u1ea5u c\u00e1ch ho\u1eb7c ph\u00e2n c\u00e1ch theo c\u00e1ch b\u1ea1n ch\u1ecdn.<\/span><\/p>\n<figure style=\"width: 523px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"D\u1eef li\u1ec7u g\u1ed1c v\u00e0 k\u1ebft qu\u1ea3 mong \u0111\u1ee3i v\u1edbi Ultimate Suite\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/source-data-result.png\" alt=\"Source data and expected result\" width=\"523\" height=\"283\"><figcaption class=\"wp-caption-text\"><em>D\u1eef li\u1ec7u g\u1ed1c v\u00e0 k\u1ebft qu\u1ea3 mong \u0111\u1ee3i v\u1edbi Ultimate Suite<\/em><\/figcaption><\/figure>\n<p><em><strong>Di chuy\u1ec3n c\u00e1c h\u00e0ng c\u00f3 nhi\u1ec1u k\u1ebft qu\u1ea3 v\u00e0o b\u1ea3ng ch\u00ednh<\/strong><\/em><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng ch\u00ednh b\u1ea1n nh\u1eadp danh s\u00e1ch c\u00e1c t\u00ean duy nh\u1ea5t trong c\u1ed9t \u0111\u1ea7u ti\u00ean, c\u00e1c th\u00e1ng trong c\u1ed9t th\u1ee9 2 v\u00e0 s\u1eafp x\u1ebfp ch\u00fang nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn b\u1ea3ng ch\u00ednh c\u1ee7a b\u1ea1n ho\u1eb7c b\u1ea5m v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong \u0111\u00f3, sau \u0111\u00f3 b\u1ea5m v\u00e0o n\u00fat H\u1ee3p nh\u1ea5t Hai b\u1ea3ng tr\u00ean thanh c\u00f4ng c\u1ee5:<\/span><\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-two-tables.png\" alt=\"Merge Two Tables button on the Excel ribbon\" title=\"merge-two-tables\"><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ph\u1ea7n t\u00ednh n\u0103ng b\u1ed5 tr\u1ee3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng, v\u00ec v\u1eady b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o Ti\u1ebfp theo :<\/span><\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/main-table.png\" alt=\"Select the main table.\" title=\"main-table\"><\/p>\n<p><span style=\"font-weight: 400\">L\u1eddi khuy\u00ean: Khi b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u1ea7n \u0111\u1ea7u ti\u00ean th\u00ec n\u00ean ch\u1ecdn \u201ccreate a backup copy of the worksheet\u201d \u0111\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng x\u1ea3y ra s\u1ef1 c\u1ed1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 3. Ch\u1ecdn Lookup table v\u00e0 nh\u1ea5n <\/span><i><span style=\"font-weight: 400\">next:<\/span><\/i><\/p>\n<p><strong><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-table.png\" alt=\"Select the lookup table.\" title=\"lookup-table\"><\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 4. B\u1ea1n ch\u1ecdn nh\u1eefng c\u1eb7p gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p \u0111\u01b0\u1ee3c so s\u00e1nh trong b\u1ea3ng ch\u00ednh v\u00e0 b\u1ea3ng tra c\u1ee9u (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 c\u1ed9t Seller v\u00e0 Month), sau \u0111\u00f3 nh\u1ea5n<\/span><i><span style=\"font-weight: 400\"> Next.<\/span><\/i><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-matching-columns.png\" alt=\"Choose one or more matching pairs of columns.\" title=\"select-matching-columns\"><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a05. Ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 c\u1ed9t Product) v\u00e0 nh\u1ea5n <\/span><i><span style=\"font-weight: 400\">Next.<\/span><\/i><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/columns-pull-matches.png\" alt=\"Select the column(s) from which you want to pull matching values.\" title=\"columns-pull-matches\"><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a06. B\u1ea1n l\u1ef1a ch\u1ecdn h\u00ecnh th\u1ee9c s\u1eafp x\u1ebfp nhi\u1ec1u k\u1ebft qu\u1ea3 trong b\u1ea3ng ch\u00ednh. V\u1edbi v\u00ed d\u1ee5 n\u00e0y s\u1ebd l\u00e0 <\/span><i><span style=\"font-weight: 400\">\u201cInsert rows with duplicate matching values after the row with the same value\u201d<\/span><\/i><span style=\"font-weight: 400\"> . N\u1ebfu kh\u00f4ng c\u00f3 t\u00f9y ch\u1ecdn nh\u1ea5t Finish.\u00a0<\/span><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/multiple-matches-arrangement.png\" alt=\"Specify how to arrange matching values.\" title=\"multiple-matches-arrangement\"><\/p>\n<p><span style=\"font-weight: 400\"><strong>K\u1ebft qu\u1ea3:<\/strong> T\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng ph\u00f9 h\u1ee3p s\u1ebd \u0111\u01b0\u1ee3c di chuy\u1ec3n \u0111\u1ebfn b\u1ea3ng ch\u00ednh v\u00e0 \u0111\u01b0\u1ee3c ph\u00e2n theo c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t tra c\u1ee9u: Seller, Month, Product.<\/span><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-duplicate-rows.png\" alt=\"Matching rows are pulled to the main table.\" title=\"vlookup-duplicate-rows\"><\/p>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean \u0111\u00e2y ch\u01b0a ph\u1ea3i l\u00e0 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng m\u00e0 ch\u00fang ta mong mu\u1ed1n. Ch\u00fang ta \u0111ang s\u1eed d\u1ee5ng Vlookup \u0111\u1ec3 t\u00ecm ki\u1ebfm nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac v\u00e0 \u0111\u01b0\u1ee3c c\u00e1ch nhau d\u1ea5u ph\u1ea9y, d\u1ea5u c\u00e1ch ho\u1eb7c d\u1ea5u kh\u00e1c. \u0110\u1ec3 l\u00e0m nh\u01b0 v\u1eady ch\u00fang ta ti\u1ebfp t\u1ee5c c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_cac_hang_trung_lap_thanh_mot_hang\"><\/span><b>K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 h\u1ee3p nh\u1ea5t \u201cc\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p\u201d trong m\u1ed9t h\u00e0ng, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1c \u2013 Combine Rows Wizard<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn b\u1ea3ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00f4ng c\u1ee5 <\/span><i><span style=\"font-weight: 400\">Merge Tables<\/span><\/i><span style=\"font-weight: 400\"> (xem \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean) ho\u1eb7c b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng v\u00e0 nh\u1ea5p v\u00e0o n\u00fat <\/span><i><span style=\"font-weight: 400\">Combine Rows <\/span><\/i><span style=\"font-weight: 400\">tr\u00ean thanh c\u00f4ng c\u1ee5: <\/span><span style=\"font-weight: 400\">B\u1ea1n ki\u1ec3m tra \u0111\u00fang b\u1ea3ng v\u00e0 nh\u1ea5n <\/span><i><span style=\"font-weight: 400\">Next<\/span><\/i><\/li>\n<\/ol>\n<figure style=\"width: 231px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 1: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/combine-rows-wizard.png\" alt=\"Combine Rows button on the ribbon\" width=\"231\" height=\"372\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 1: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a02. Ki\u1ec3m tra n\u1ebfu d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1ea3ng \u0111\u00fang, b\u1ea1n nh\u1ea5n Next \u0111\u1ec3 ti\u1ebfp t\u1ee5c:<\/span><\/p>\n<figure style=\"width: 620px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 2: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-table-1.png\" alt=\"Select the table.\" width=\"620\" height=\"526\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 2: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 3. Ch\u1ecdn c\u1ed9t ch\u00ednh l\u00e0m vi\u1ec7c ( <i>Seller<\/i> v\u00e0 <i>Month<\/i> trong v\u00ed d\u1ee5 n\u00e0y) v\u00e0 nh\u1ea5p v\u00e0o Next :<\/span><\/p>\n<figure style=\"width: 620px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 3: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-key-columns.png\" alt=\"Select the key column(s).\" width=\"620\" height=\"526\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 3: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 4. Ch\u1ecdn (c\u00e1c) c\u1ed9t ch\u1ee9a nhi\u1ec1u k\u1ebft qu\u1ea3 ( <\/span><i><span style=\"font-weight: 400\">Product<\/span><\/i><span style=\"font-weight: 400\"> trong v\u00ed d\u1ee5 n\u00e0y), ch\u1ecdn d\u1ea5u ph\u00e2n c\u00e1ch mong mu\u1ed1n (d\u1ea5u ch\u1ea5m ph\u1ea9y, d\u1ea5u ph\u1ea9y, d\u1ea5u c\u00e1ch ho\u1eb7c ng\u1eaft d\u00f2ng) v\u00e0 nh\u1ea5p v\u00e0o <\/span><i><span style=\"font-weight: 400\">Finish:<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">Theo t\u00f9y ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 b\u1eadt m\u1ed9t trong c\u00e1c t\u00ednh n\u0103ng b\u1ed5 sung ho\u1eb7c c\u1ea3 hai:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">X\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u2013 n\u1ebfu c\u1ed9t \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t ch\u1ee9a m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb gi\u1ed1ng nhau, l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i, c\u00e1c k\u1ebft qu\u1ea3 tr\u00f9ng l\u1eb7p s\u1ebd b\u1ecb x\u00f3a.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng<\/span><\/li>\n<\/ul>\n<figure style=\"width: 620px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 4: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/return-column-delimiter.png\" alt=\"Select the column(s) from which you want to pull multiple values and choose the desired delimiter.\" width=\"620\" height=\"526\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 4: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n<p>5. \u0110\u1ee3i v\u00e0i gi\u00e2y \u0111\u1ec3 x\u1eed l\u00fd, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 d\u01b0\u1edbi h\u00ecnh:<\/p>\n<figure style=\"width: 428px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 5: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng\u00a0\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/multiple-values-comma-separated.png\" alt=\"Multiple matches are returned in a single sell, comma separated.\" width=\"428\" height=\"412\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 5: K\u1ebft h\u1ee3p c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p th\u00e0nh m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, kh\u00f4ng s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn n\u00e0y do \u0111\u00f3 c\u00f4ng c\u1ee5 n\u00e0y tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y. V\u00ed d\u1ee5, trong \u00f4 C2, ch\u00fang ta c\u00f3 chu\u1ed7i n\u00e0y: Lemon, Banana, Apple, Lemon, Banana (vui l\u00f2ng xem k\u1ebft qu\u1ea3 \u1edf b\u01b0\u1edbc 5 b\u00ean d\u01b0\u1edbi). N\u1ebfu b\u1ea1n ch\u1ecdn x\u00f3a c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0: Lemon, Banana, Apple .<\/span><\/p>\n<p><em><strong>K\u1ebft qu\u1ea3\u00a0<\/strong><\/em><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch tra c\u1ee9u v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb trong Excel b\u1eb1ng c\u00e1c 2 c\u00f4ng c\u1ee5 tr\u00ean. N\u1ebfu b\u1ea1n mu\u1ed1n d\u00f9ng th\u1eed ch\u00fang, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng phi\u00ean b\u1ea3n Ultimate Suite b\u00ean d\u01b0\u1edbi \u0111\u1ec3 tr\u1ea3i nghi\u1ec7m.\u00a0<\/span><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-194.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2501","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\/2501","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=2501"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2501\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2502"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}