{"id":4784,"date":"2024-12-08T09:14:05","date_gmt":"2024-12-08T09:14:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup\/"},"modified":"2024-12-08T09:14:05","modified_gmt":"2024-12-08T09:14:05","slug":"cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup\/","title":{"rendered":"C\u00e1ch \u0111\u1ec3 Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb trong GG Sheets \u2013 Google Sheets Vlookup"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u1edbi thi\u1ec7u b\u1ea1n c\u00e1ch \u0111\u1ec3 <strong>h\u00e0m Vlookup nhi\u1ec1u gi\u00e1 tr\u1ecb trong Google Sheets \u2013 Google Sheets Vlookup<\/strong>. Ngo\u00e0i ra, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> c\u0169ng s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn c\u00e1c s\u1ef1 c\u1ed1 t\u00ecm ki\u1ebfm nhi\u1ec1u k\u1ebft qu\u1ea3 trong Google Sheets sau \u0111\u00e2y.<\/em><\/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-6755635c13a98\" 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-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Cach_de_tra_cuu_cac_gia_tri_theo_chieu_doc_trong_trang_tinh_Google_Sheets\" title=\"C\u00e1ch \u0111\u1ec3 tra c\u1ee9u c\u00e1c gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc trong trang t\u00ednh Google Sheets\">C\u00e1ch \u0111\u1ec3 tra c\u1ee9u c\u00e1c gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc trong trang t\u00ednh Google Sheets<\/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\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Su_co_khi_tim_kiem_nhieu_ket_qua_phu_hop_voi_cong_thuc_Google_Sheets\" title=\"S\u1ef1 c\u1ed1 khi t\u00ecm ki\u1ebfm nhi\u1ec1u k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi c\u00f4ng th\u1ee9c Google Sheets\">S\u1ef1 c\u1ed1 khi t\u00ecm ki\u1ebfm nhi\u1ec1u k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi c\u00f4ng th\u1ee9c Google Sheets<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Tai_sao_nhieu_Vlookup_la_giai_phap_tot_nhat\" title=\"T\u1ea1i sao nhi\u1ec1u Vlookup l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t\">T\u1ea1i sao nhi\u1ec1u Vlookup l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Chay_cong_cu_va_chon_pham_vi_du_lieu\" title=\"Ch\u1ea1y c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u\">Ch\u1ea1y c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Quyet_dinh_tra_lai_nhung_gi\" title=\"Quy\u1ebft \u0111\u1ecbnh tr\u1ea3 l\u1ea1i nh\u1eefng g\u00ec\">Quy\u1ebft \u0111\u1ecbnh tr\u1ea3 l\u1ea1i nh\u1eefng g\u00ec<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Thiet_lap_cac_dieu_kien\" title=\"Thi\u1ebft l\u1eadp c\u00e1c \u0111i\u1ec1u ki\u1ec7n\u00a0\">Thi\u1ebft l\u1eadp c\u00e1c \u0111i\u1ec1u ki\u1ec7n\u00a0<\/a><\/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-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html#Xem_truoc_ket_qua\" title=\"Xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3\">Xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_de_tra_cuu_cac_gia_tri_theo_chieu_doc_trong_trang_tinh_Google_Sheets\"><\/span><b>C\u00e1ch \u0111\u1ec3 tra c\u1ee9u c\u00e1c gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc trong trang t\u00ednh Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1eebng c\u1ed1 g\u1eafng t\u00ecm ki\u1ebfm c\u00e1c k\u1ebft qu\u1ea3 tr\u00f9ng trong <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-google-sheets-co-ban-nang-cao.html\"><strong>Google Sheets<\/strong><\/a> v\u00e0 l\u1ea5y d\u1eef li\u1ec7u li\u00ean quan.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng l\u1ea5y t\u00ean c\u1ee7a t\u1ea5t c\u1ea3 h\u1ecdc sinh \u0111\u00e3 v\u01b0\u1ee3t qua b\u00e0i ki\u1ec3m tra hay kh\u00f4ng? C\u00f2n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u1eefa \u2013 ch\u1ec9 c\u00f3 nh\u1eefng ng\u01b0\u1eddi \u0111\u00e3 h\u1ecdc ti\u1ebfng T\u00e2y Ban Nha th\u00ec sao? Tr\u00ean th\u1ef1c t\u1ebf, ch\u00fang ta h\u00e3y t\u00ednh \u0111\u1ebfn c\u1ea3 ng\u00e0y th\u00e1ng: ch\u1ec9 l\u1ea5y ng\u01b0\u1eddi \u0111\u00e3 l\u00e0m b\u00e0i ki\u1ec3m tra ti\u1ebfng T\u00e2y Ban Nha v\u00e0o th\u00e1ng ba. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng c\u00f3 k\u1ebft qu\u1ea3 sang m\u1ed9t trang t\u00ednh m\u1edbi kh\u00f4ng?<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_co_khi_tim_kiem_nhieu_ket_qua_phu_hop_voi_cong_thuc_Google_Sheets\"><\/span><b>S\u1ef1 c\u1ed1 khi t\u00ecm ki\u1ebfm nhi\u1ec1u k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi c\u00f4ng th\u1ee9c Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n chuy\u1ec3n sang c\u00e1c ch\u1ee9c n\u0103ng Google Sheets \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf cho m\u1ee5c ti\u00eau n\u00e0y. Nh\u01b0ng x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u1eeb \u0111\u1ea7u c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh m\u1ed9t th\u1eed th\u00e1ch th\u1ef1c s\u1ef1 ngay l\u1eadp t\u1ee9c; \u0111\u1eb7c bi\u1ec7t n\u1ebfu s\u1ed1 l\u01b0\u1ee3ng ch\u00ednh x\u00e1c l\u00e0 kh\u00f4ng x\u00e1c \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 v\u1edbi<a href=\"http:\/\/blog.ezworkapp.com\/cach-de-vlookup-nhieu-gia-tri-trong-gg-sheets-google-sheets-vlookup.html\"><strong> Google Sheets VLOOKUP<\/strong><\/a>: lo l\u1eafng v\u1ec1 vi\u1ec7c s\u1eafp x\u1ebfp ph\u00f9 h\u1ee3p v\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t trong b\u1ea3ng. H\u00e0m n\u00e0y kh\u00f4ng th\u1ec3 \u0111\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i c\u1ee7a n\u00f3 v\u00e0 ch\u1ec9 t\u00ecm ki\u1ebfm nh\u1eefng k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p.<\/span><\/p>\n<figure id=\"attachment_33403\" aria-describedby=\"caption-attachment-33403\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33403\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-google-sheets-vlookup.png\" alt=\"1 Google Sheets Vlookup\" width=\"640\" height=\"360\" title=\"1-google-sheets-vlookup\"><figcaption id=\"caption-attachment-33403\" class=\"wp-caption-text\">1 Google Sheets Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">H\u00e0m FILTER d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n, nh\u01b0ng n\u00f3 kh\u00f4ng k\u00e9o d\u1eef li\u1ec7u sang m\u1ed9t trang t\u00ednh kh\u00e1c v\u00e0 ph\u1ea3i d\u00f9ng h\u00e0m IF \u0111\u1ec3 t\u00ecm ki\u1ebfm th\u00eam nhi\u1ec1u ti\u00eau ch\u00ed. C\u00f3 v\u1ebb t\u1ea5t c\u1ea3 kh\u00f4ng d\u1ec5 d\u00e0ng nh\u01b0 v\u1eady.<\/span><\/p>\n<p><span style=\"font-weight: 400\">INDEX MATCH d\u01b0\u1eddng nh\u01b0 \u0111\u1ea7y tri\u1ec3n v\u1ecdng, nh\u01b0ng trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, n\u00f3 n\u00ean \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng. Th\u1eadt kh\u00f4ng may, tr\u00ean th\u1ef1c t\u1ebf cho th\u1ea5y r\u1eb1ng b\u1ea1n r\u1ea5t c\u00f3 th\u1ec3 b\u1ecb nh\u1ea7m l\u1eabn gi\u1eefa c\u00e1c tham s\u1ed1.<\/span><\/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-391.gif\" title=\"ex101_92019-nho-391\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi h\u00e0m QUERY, n\u00f3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t ho\u00e0n to\u00e0n kh\u00e1c. \u0110\u1ec3 x\u00e2y d\u1ef1ng ho\u1eb7c ch\u1ec9nh s\u1eeda m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady, b\u1ea1n s\u1ebd ph\u1ea3i xem qua h\u01b0\u1edbng d\u1eabn tr\u00ean Docs Editors Help.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_nhieu_Vlookup_la_giai_phap_tot_nhat\"><\/span><b>T\u1ea1i sao nhi\u1ec1u Vlookup l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n s\u1eb5n s\u00e0ng t\u1eeb b\u1ecf c\u00e1c c\u00f4ng th\u1ee9c kh\u00f3 tr\u00ean Google Sheets. <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\u00a0Vlookup<\/strong><\/a> s\u1ebd tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 h\u1eefu \u00edch cho b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i chu\u1ea9n b\u1ecb b\u1ea5t c\u1ee9 g\u00ec khi s\u1eed d\u1ee5ng add-on n\u00e0y: n\u00f3 \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c kh\u00f3 kh\u0103n nh\u1ea5t cho b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 c\u00f4ng c\u1ee5 n\u00e0y trong tay, b\u1ea1n s\u1ebd nhanh ch\u00f3ng \u0111\u1eb7t v\u00e0 ch\u1ec9nh s\u1eeda nhi\u1ec1u ti\u00eau ch\u00ed trong c\u00e1c ph\u1ea7n nh\u1ecf v\u00e0 b\u1eb1ng ti\u1ebfng Anh \u0111\u01a1n gi\u1ea3n \u2013 m\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t n\u00e0o kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u0169ng s\u1ebd nh\u1eadp ng\u00e0y, gi\u1edd v\u00e0 c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng \u2013 theo c\u00e1ch th\u1ee7 c\u00f4ng m\u00e0 kh\u00f4ng c\u1ea7n th\u00eam b\u1ea5t k\u1ef3 ch\u1ee9c n\u0103ng n\u00e0o. C\u00e1c c\u00e1ch th\u1ee7 c\u00f4ng \u0111\u1ec3 d\u00f9ng \u0111\u1ec3 t\u1ea1o \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c \u00f4 tr\u1ed1ng ho\u1eb7c th\u1eadm ch\u00ed so s\u00e1nh m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Add-on s\u1ebd hi\u1ec3n th\u1ecb cho b\u1ea1n b\u1ea3n xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3 n\u1ebfu b\u1ea1n c\u1ea7n v\u00e0 k\u00e9o t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p sang m\u1ed9t trang t\u00ednh kh\u00e1c.<\/span><\/p>\n<figure id=\"attachment_33400\" aria-describedby=\"caption-attachment-33400\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33400\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-google-sheets-vlookup.png\" alt=\"T\u1ea1i sao nhi\u1ec1u Vlookup l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t\" width=\"640\" height=\"358\" title=\"2-google-sheets-vlookup\"><figcaption id=\"caption-attachment-33400\" class=\"wp-caption-text\">T\u1ea1i sao nhi\u1ec1u Vlookup l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u1ea5t c\u1ea3 nh\u1eefng \u0111i\u1ec1u n\u00e0y l\u00e0 s\u1ef1 th\u1eadt, h\u00e3y xem add-on ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chay_cong_cu_va_chon_pham_vi_du_lieu\"><\/span><b>Ch\u1ea1y c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Chuy\u1ec3n \u0111\u1ebfn menu Add-on \u0111\u1ec3 t\u00ecm c\u00f4ng c\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 n\u00f3 nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a Power Tools &gt; Process Group ho\u1eb7c d\u01b0\u1edbi d\u1ea1ng m\u1ed9t c\u00f4ng c\u1ee5 ri\u00eang bi\u1ec7t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ngay khi b\u1ea1n kh\u1edfi \u0111\u1ed9ng, add-on s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ecm d\u1eef li\u1ec7u ngu\u1ed3n c\u1ee7a b\u1ea1n. N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u00f9y ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Quyet_dinh_tra_lai_nhung_gi\"><\/span><b>Quy\u1ebft \u0111\u1ecbnh tr\u1ea3 l\u1ea1i nh\u1eefng g\u00ec<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3, b\u1ea1n\u00a0 c\u1ea7n quy\u1ebft \u0111\u1ecbnh s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t cho k\u1ebft qu\u1ea3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn All \u0111\u1ec3 tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng ph\u00f9 h\u1ee3p ho\u1eb7c ch\u1ecdn First v\u00e0 gi\u1edbi h\u1ea1n s\u1ed1 d\u00f2ng tr\u1ea3 v\u1ec1\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u00e9o th\u1ea3 xu\u1ed1ng ti\u1ebfp theo cho ph\u00e9p b\u1ea1n ch\u1ecdn t\u1ea5t c\u1ea3 ho\u1eb7c c\u00e1c c\u1ed9t c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_cac_dieu_kien\"><\/span><b>Thi\u1ebft l\u1eadp c\u00e1c \u0111i\u1ec1u ki\u1ec7n\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi \u0111\u00e3 ho\u00e0n th\u00e0nh, \u0111\u00e3 \u0111\u1ebfn l\u00fac thi\u1ebft l\u1eadp c\u00e1c ti\u00eau ch\u00ed t\u00ecm ki\u1ebfm:<\/span><\/p>\n<p><span style=\"font-weight: 400\">1. B\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch ch\u1ecdn c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u0111\u00f3, c\u1ed9t \u0111\u00f3 s\u1ebd \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">2. Danh s\u00e1ch ti\u1ebfp theo l\u00e0 danh s\u00e1ch c\u00e1c ph\u00e9p to\u00e1n logic \u0111\u1eb7c bi\u1ec7t \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e2y d\u1ef1ng ti\u00eau ch\u00ed. Ch\u1ecdn ti\u00eau ch\u00ed v\u00e0 c\u00f4ng c\u1ee5 s\u1ebd y\u00eau c\u1ea7u b\u1ea1n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm. V\u00ec add-on lu\u00f4n nh\u1eafc nh\u1edf v\u1ec1 c\u00e1ch gi\u00e1 tr\u1ecb s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n s\u1ebd nh\u1eadp nhi\u1ec1u b\u1ea3ng m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng b\u1ea5t k\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u2013 ngay c\u1ea3 ng\u00e0y v\u00e0 gi\u1edd<\/span><span style=\"font-weight: 400\">. Add-on s\u1ebd nh\u1eafc c\u00e1ch nh\u1eadp gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau.<\/span><\/p>\n<figure id=\"attachment_33401\" aria-describedby=\"caption-attachment-33401\" style=\"width: 662px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33401\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-google-sheets-vlookup.png\" alt=\"3 Google Sheets Vlookup\" width=\"662\" height=\"319\" title=\"3-google-sheets-vlookup\"><figcaption id=\"caption-attachment-33401\" class=\"wp-caption-text\">3 Google Sheets Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">3. \u0110\u1ec3 t\u1ea1o th\u00eam \u0111i\u1ec1u ki\u1ec7n, h\u00e3y nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng v\u00e0 ch\u1ec9nh s\u1eeda c\u00f9ng m\u1ed9t b\u1ed9 t\u00f9y ch\u1ec9nh. V\u1edbi nhi\u1ec1u Vlookup, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do ch\u1ec9 \u0111\u1ecbnh h\u00e0ng ch\u1ee5c ti\u00eau ch\u00ed v\u00e0 \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c lo\u1ea1i b\u1ecf ch\u00fang khi \u0111ang di chuy\u1ec3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">4. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u00f3 quy\u1ec1n ki\u1ec3m so\u00e1t vi\u1ec7c th\u1ef1c hi\u1ec7n t\u1ea5t c\u1ea3 ho\u1eb7c \u00edt nh\u1ea5t m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 ph\u00f9 h\u1ee3p. Drop-down n\u00e0y s\u1ebd cho ph\u00e9p b\u1ea1n thay \u0111\u1ed5i bi\u1ec3u th\u1ee9c logic AND\/OR cho to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xem_truoc_ket_qua\"><\/span><b>Xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ph\u1ea7n d\u01b0\u1edbi c\u00f9ng c\u1ee7a add-on l\u00e0 k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng trong tr\u01b0\u1eddng \u0111\u1ea7u ti\u00ean \u0111\u1ec3 ch\u1ecdn v\u1ecb tr\u00ed cho d\u1eef li\u1ec7u k\u1ebft qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 tr\u00ean c\u00f9ng b\u00ean trai trong c\u00e1c trang t\u00ednh hi\u1ec7n c\u00f3 ho\u1eb7c th\u00eam m\u1ed9t trang t\u00ednh m\u1edbi v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 \u1edf \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00fat Preview result cho ph\u00e9p b\u1ea1n xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3 \u0111\u1ec3 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c c\u00e1ch th\u1ef1c hi\u1ec7n b\u1edfi t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n v\u1eeba x\u00e2y d\u1ef1ng. B\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng ph\u1ea1m vi \u0111\u1ec3 thu\u1eadn ti\u1ec7n cho m\u00ecnh, cu\u1ed9n xu\u1ed1ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y v\u00e0 xem c\u00f4ng th\u1ee9c \u0111\u1ee9ng sau ch\u00fang.<\/span><\/p>\n<figure id=\"attachment_33402\" aria-describedby=\"caption-attachment-33402\" style=\"width: 692px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33402\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-google-sheets-vlookup.png\" alt=\"4 Google Sheets Vlookup\" width=\"692\" height=\"344\" title=\"4-google-sheets-vlookup\"><figcaption id=\"caption-attachment-33402\" class=\"wp-caption-text\">4 Google Sheets Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu m\u1ecdi th\u1ee9 \u0111\u1ec1u \u1ed5n, c\u00f3 hai c\u00e1ch \u0111\u1ec3 t\u00ecm n\u1ea1p d\u1eef li\u1ec7u, c\u00f3 hai c\u00e1ch \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u n\u00e0y v\u00e0o trang t\u00ednh c\u1ee7a b\u1ea1n. N\u00fat m\u00e0u xanh lam n\u00e0y s\u1ebd ch\u00e8n c\u00f4ng th\u1ee9c t\u1eeb b\u1ea3n xem tr\u01b0\u1edbc \u1edf tr\u00ean \u00f4 \u0111\u00edch \u0111\u00e3 ch\u1ecdn. Ti\u1ebfp theo, paste k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb. Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o m\u1ed9t trong c\u00e1c n\u00fat v\u00e0 nh\u1eadn t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p trong m\u1ed9t b\u1ea3ng m\u1edbi.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t add-on t\u1eeb c\u1eeda h\u00e0ng d\u01b0\u1edbi d\u1ea1ng m\u1ed9t c\u00f4ng c\u1ee5 duy nh\u1ea5t ho\u1eb7c nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a Power Tools. N\u1ebfu b\u1ea1n v\u1eabn c\u00f3 b\u1ea5t k\u1ef3 c\u00e2u h\u1ecfi n\u00e0o \u2013 vui l\u00f2ng \u0111\u1ec3 l\u1ea1i cmt, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd s\u1eb5n l\u00f2ng tr\u1ee3 gi\u00fap b\u1ea1n.<\/span><\/p>\n<p><strong>H\u1ecdc Excel Online<\/strong> l\u00e0 n\u1ec1n t\u1ea3ng h\u1ecdc tr\u1ef1c tuy\u1ebfn, l\u00e0 c\u1ed5ng k\u1ebft n\u00f3i c\u00e1c Chuy\u00ean Gia v\u00e0 c\u00e1c H\u1ecdc Vi\u00ean. <strong>H\u1ecdc Excel Online<\/strong> c\u0169ng c\u1ea5p cho b\u1ea1n nhi\u1ec1u kh\u00f3a h\u1ecdc Excel b\u1ed5 \u00edch nh\u01b0 kh\u00f3a h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, kh\u00f3a h\u1ecdc VBA Excel,\u2026 \u0110\u1ed3ng h\u00e0nh c\u00f9ng c\u00e1ch kh\u00f3a h\u1ecdc c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c h\u1ecdc ph\u00ed, th\u1eddi gian v\u00e0 \u0111\u01b0\u1ee3c s\u1edf h\u1eefu kh\u00f3a h\u1ecdc tr\u1ecdn \u0111\u1eddi, linh \u0111\u1ed9ng gi\u1edd h\u1ecdc m\u1ecdi l\u00fac, m\u1ecdi n\u01a1i.<\/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-391.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4785,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4784","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4784","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=4784"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4784\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4785"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}