{"id":9739,"date":"2025-01-02T13:37:46","date_gmt":"2025-01-02T13:37:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel\/"},"modified":"2025-01-02T13:37:46","modified_gmt":"2025-01-02T13:37:46","slug":"huong-dan-su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u hai hay nhi\u1ec1u b\u1ea3ng v\u1edbi nhau trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m b\u00e1o c\u00e1o, \u0111\u00e3 bao nhi\u00eau l\u1ea7n b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u trong m\u1ed9t trang t\u00ednh duy nh\u1ea5t? G\u1ea7n nh\u01b0 l\u00e0 kh\u00f4ng bao gi\u1edd ph\u1ea3i kh\u00f4ng n\u00e0o. \u0110\u00e2y l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 r\u1ea5t ph\u1ed5 bi\u1ebfn khi m\u00e0 c\u00e1c m\u1ea3nh d\u1eef li\u1ec7u n\u1eb1m r\u1ea3i r\u00e1c \u1edf c\u00e1c trang t\u00ednh v\u00e0 s\u1ed5 t\u00ednh kh\u00e1c nhau.\u00a0 Trong b\u00e0i h\u1ecdc n\u00e0y, c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn \u0111\u1ec3 c\u00f3 th\u1ec3\u00a0x\u1eed l\u00fd theo c\u00e1ch\u00a0\u0111\u01a1n gi\u1ea3n nh\u1ea5t, \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u c\u01a1 b\u1ea3n hai hay nhi\u1ec1u b\u1ea3ng trong Excel d\u1ef1a theo ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/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-677696a9b6ed8\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel.html#Su_dung_ham_ghep_noi_du_lieu_hai_hay_nhieu_bang_voi_nhau\" title=\"S\u1eed d\u1ee5ng h\u00e0m gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u hai hay nhi\u1ec1u b\u1ea3ng v\u1edbi nhau\">S\u1eed d\u1ee5ng h\u00e0m gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u hai hay nhi\u1ec1u b\u1ea3ng v\u1edbi nhau<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel.html#Lien_ket_cac_bang_du_lieu_voi_VLOOKUP\" title=\"Li\u00ean k\u1ebft c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi VLOOKUP\">Li\u00ean k\u1ebft c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-ghep-noi-du-lieu-hai-hay-nhieu-bang-voi-nhau-trong-excel.html#Su_dung_INDEX_va_MATCH_de_lien_ket_cac_bang_du_lieu\" title=\"S\u1eed d\u1ee5ng INDEX v\u00e0 MATCH \u0111\u1ec3\u00a0li\u00ean k\u1ebft\u00a0c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u\">S\u1eed d\u1ee5ng INDEX v\u00e0 MATCH \u0111\u1ec3\u00a0li\u00ean k\u1ebft\u00a0c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_ghep_noi_du_lieu_hai_hay_nhieu_bang_voi_nhau\"><\/span>S\u1eed d\u1ee5ng h\u00e0m gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u hai hay nhi\u1ec1u b\u1ea3ng v\u1edbi nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n trong trang t\u00ednh, h\u00e3y nh\u1edb r\u1eb1ng \u0111\u1ec3 \u00fd \u0111\u1ebfn th\u1ebb <strong>Formulas\u00a0<\/strong>\u0111\u1ea7u ti\u00ean nh\u00e9. \u0110\u00e2y l\u00e0 m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c ch\u1ee9c n\u0103ng v\u00f4 c\u00f9ng h\u1eefu \u00edch \u0111\u00f3.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Lien_ket_cac_bang_du_lieu_voi_VLOOKUP\"><\/span>Li\u00ean k\u1ebft c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n gh\u00e9p d\u1eef li\u1ec7u c\u1ee7a hai b\u1ea3ng ph\u1ee5 thu\u1ed9c v\u00e0o\u00a0<strong>m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u<\/strong>, VLOOKUP l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn r\u1ea5t \u0111\u00e1ng gi\u00e1.<\/p>\n<p>H\u00e0m VLOOKUP c\u00f3 c\u1ea5u tr\u00fac:<\/p>\n<blockquote>\n<p>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 trong tr\u01b0\u1eddng h\u1ee3p d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 2 b\u1ea3ng kh\u00e1c nhau. B\u1ea3ng ch\u00ednh bao g\u1ed3m m\u00e3 s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u00ecnh tr\u1ea1ng thanh to\u00e1n; b\u1ea3ng ph\u1ee5 l\u00e0 t\u00ean s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh theo m\u00e3 x\u1ea3n ph\u1ea9m. B\u00e2y gi\u1edd, b\u1ea1n ph\u1ea3i l\u1ea5y d\u1eef li\u1ec7u \u0111\u1ec3 b\u00e1o c\u00e1o trong b\u1ea3ng ch\u00ednh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23629\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-noi-bang-1.png\" width=\"829\" height=\"262\" title=\"ham-noi-bang-1\"><\/p>\n<h3 id=\"merge-tables-1-column-VLOOKUP\"><\/h3>\n<p>B\u1edfi v\u00ec \u0111\u00e3 c\u00f3 s\u1ef1 x\u00e1o tr\u1ed9n trong b\u1ea3ng, n\u00ean thao t\u00e1c th\u00f4ng th\u01b0\u1eddng l\u00e0 Copy\/Paste trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd kh\u00f4ng hi\u1ec7u qu\u1ea3.<\/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\/2025\/01\/ex101_92019-nho-84.gif\" title=\"ex101_92019-nho-84\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 k\u1ebft h\u1ee3p hai b\u1ea3ng, t\u1ea1i \u00f4 B2 ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p>=VLOOKUP($A2,$F$2:$G$5,2,0)<\/p>\n<\/blockquote>\n<p><code><\/code><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><em>$A2<\/em>\u00a0l\u00e0 gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/li>\n<li><em>$F$2:$G$5<\/em> l\u00e0 b\u1ea3ng ph\u1ee5 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tra c\u1ee9u. L\u01b0u \u00fd l\u00e0 ch\u00fang ta s\u1ebd c\u1ed1 \u0111\u1ecbnh b\u1ea3ng b\u1eb1ng k\u00ed t\u1ef1 <strong>$<\/strong> nh\u00e9.<\/li>\n<li><em>2<\/em>\u00a0l\u00e0 s\u1ed1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u1ec3 tra c\u1ee9u t\u1eeb <strong>A2<\/strong>.<\/li>\n<\/ul>\n<p>Sau \u0111\u00f3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i v\u00e0 ta \u0111\u00e3 c\u00f3 m\u1ed9t b\u1ea3ng ho\u00e0n ch\u1ec9nh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23631\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-noi-bang-2.png\" width=\"670\" height=\"279\" title=\"ham-noi-bang-2\"><\/p>\n<p>Tuy nhi\u00ean, h\u00e3y l\u01b0u \u00fd r\u1eb1ng VLOOKUP c\u00f3 m\u1ed9t v\u00e0i h\u1ea1n ch\u1ebf nh\u01b0 l\u00e0:<br \/>\n1. Ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb tr\u00e1i qua ph\u1ea3i, v\u1edbi c\u1ed9t s\u1eed d\u1ee5ng t\u00ecm ki\u1ebfm ph\u1ea3i l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n<p>2. S\u1ed1 c\u1ed9t b\u1ecb \u201ckh\u00f3a c\u1ee9ng\u201d s\u1ebd l\u00e0m sai c\u00f4ng th\u1ee9c khi th\u00eam ho\u1eb7c b\u1edbt c\u1ed9t. \u0110\u1ec3 thay \u0111\u1ed5i b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda gi\u00e1 tr\u1ecb trong \u0111\u1ed1i s\u1ed1\u00a0<em>col_index_num<\/em>, tuy nhi\u00ean ch\u00fang ta s\u1ebd c\u00f3 nh\u1eefng c\u00e1ch l\u00e0m kh\u00e1c t\u1ed1i \u01b0u h\u01a1n trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_INDEX_va_MATCH_de_lien_ket_cac_bang_du_lieu\"><\/span>S\u1eed d\u1ee5ng INDEX v\u00e0 MATCH \u0111\u1ec3\u00a0li\u00ean k\u1ebft\u00a0c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t gi\u1ea3i ph\u00e1p m\u1ea1nh m\u1ebd v\u00e0 \u0111a chi\u1ec1u h\u01a1n VLOOKUP, h\u00e3y ch\u1ecdn INDEX k\u1ebft h\u1ee3p v\u1edbi MATCH theo c\u00fa ph\u00e1p:<\/p>\n<blockquote>\n<div class=\"xl-formula\"><strong>=INDEX (<\/strong><i>v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1<\/i><strong>, MATCH (<\/strong><em>gi\u00e1 tr\u1ecb \u0111\u1ed1i chi\u1ebfu<\/em><strong>, <\/strong><i>v\u00f9ng \u0111\u1ed1i chi\u1ebfu<\/i><strong>, 0))<\/strong><\/div>\n<\/blockquote>\n<div class=\"xl-formula\">C\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m, c\u00e1c b\u1ea1n h\u00e3y xem b\u00e0i: <a href=\"http:\/\/blog.ezworkapp.com\/ham-index-va-ham-match-trong-excel-su-thay-tot-hon-ca-ham-vlookup.html\">INDEX v\u00e0 MATCH trong Excel<\/a>.<\/div>\n<div class=\"xl-formula\">Trong v\u00ed d\u1ee5 tr\u00ean, ta s\u1ebd \u00e1p d\u1ee5ng nh\u01b0 sau:<\/div>\n<p>\u00a0<\/p>\n<h3 id=\"join-tables-INDEX-MATCH\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23647\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-noi-bang-3.png\" width=\"673\" height=\"281\" title=\"ham-noi-bang-3\"><\/h3>\n<blockquote>\n<p>=INDEX($G$2:$G$5,MATCH(A3,$F$2:$F$5,0))<\/p>\n<p>\u00a0<\/p>\n<\/blockquote>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 2 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u01a1n gi\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng nh\u1ea5t. H\u1ecdc Excel Online mong r\u1eb1ng c\u00e1c b\u1ea1n s\u1ebd r\u00fat ra \u0111\u01b0\u1ee3c nhi\u1ec1u ki\u1ebfn th\u1ee9c m\u1edbi b\u1ed5 \u00edch \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch tr\u01a1n tru v\u00e0 ho\u00e0n thi\u1ec7n h\u01a1n.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/2025\/01\/ex101_92019-nho-84.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9740,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9739","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\/9739","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=9739"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9739\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9740"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}