{"id":3547,"date":"2024-12-03T02:55:01","date_gmt":"2024-12-03T02:55:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ham-match-trong-excel-qua-cac-vi-du\/"},"modified":"2024-12-03T02:55:01","modified_gmt":"2024-12-03T02:55:01","slug":"ham-match-trong-excel-qua-cac-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ham-match-trong-excel-qua-cac-vi-du\/","title":{"rendered":"H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i n\u00e0y, Blog <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u h\u00e0m Match \u1edf trong Excel v\u00e0 ch\u1ec9 ra c\u00e1ch c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m Match v\u00e0 Vlookup \u0111\u1ec3 t\u1ea1o ra nh\u1eefng c\u00f4ng th\u1ee9c linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/em><\/p>\n<p>Trong Excel, c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong 1 m\u1ea3ng, h\u00e0m Match l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u00f3. N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, h\u00e0m Match s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong 1 v\u00f9ng. Tuy nhi\u00ean, h\u00e0m Match c\u00f2n c\u00f3 th\u1ec3 l\u00e0m nhi\u1ec1u h\u01a1n nh\u01b0 v\u1eady.<\/p>\n<p><strong>M\u1ee5c l\u1ee5c<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#doan-1\">H\u01b0\u1edbng d\u1eabn h\u00e0m Match \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#doan-2\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#doan-3\">S\u1eed d\u1ee5ng h\u00e0m match c\u00f3 ph\u1ea7n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#doan-4\">So s\u00e1nh 2 c\u1ed9t, t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#doan-5\">K\u1ebft h\u1ee3p Vlookup v\u00e0 Match<\/a><\/li>\n<\/ol>\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-674e7304baafc\" 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\/su-dung-ham-match.html#Huong_dan_ham_Match_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u01b0\u1edbng d\u1eabn h\u00e0m Match trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">H\u01b0\u1edbng d\u1eabn h\u00e0m Match trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/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\/su-dung-ham-match.html#Lam_the_nao_de_su_dung_ham_Match_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match trong Excel<\/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\/su-dung-ham-match.html#Su_dung_ham_Match_co_phan_biet_chu_hoa_chu_thuong\" title=\"S\u1eed d\u1ee5ng h\u00e0m Match c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng\">S\u1eed d\u1ee5ng h\u00e0m Match c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#So_sanh_2_cot_tim_su_khac_biet\" title=\"So s\u00e1nh 2 c\u1ed9t t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t\">So s\u00e1nh 2 c\u1ed9t t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-match.html#Ket_hop_Vlookup_va_Match\" title=\"K\u1ebft h\u1ee3p Vlookup v\u00e0 Match\">K\u1ebft h\u1ee3p Vlookup v\u00e0 Match<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_ham_Match_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span><a id=\"doan-1\" href=\"\"><\/a>H\u01b0\u1edbng d\u1eabn h\u00e0m Match trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Match trong Excel nh\u01b0 sau:<\/p>\n<p><strong>=MATCH(&lt;gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u00ed&gt;, &lt;v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0y&gt;, [ 1 trong 3 s\u1ed1 : 1 ho\u1eb7c 0 ho\u1eb7c -1])<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n<ul>\n<li><strong>&lt;gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u00ed&gt; <\/strong>(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i trong m\u1ea3ng, c\u00f3 th\u1ec3 thu\u1ed9c lo\u1ea1i d\u1eef li\u1ec7u s\u1ed1, text, logic ho\u1eb7c l\u00e0 1 tham chi\u1ebfu \u0111\u1ebfn 1 \u0111\u1ecba ch\u1ec9 \u00f4<\/li>\n<li><strong>&lt;v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0y&gt;\u00a0<\/strong>(tham s\u1ed1 b\u1eaft bu\u1ed9c): v\u00f9ng mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb<\/li>\n<li>\u00a0<strong>[ 1 trong 3 s\u1ed1 : 1 ho\u1eb7c 0 ho\u1eb7c -1]\u00a0<\/strong>(Tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c): \u0111\u1ecbnh ngh\u0129a c\u00e1ch t\u00ecm ki\u1ebfm\n<ul>\n<li>N\u1ebfu b\u1ea1n \u0111i\u1ec1n s\u1ed1 1 ho\u1eb7c b\u1ecf tr\u1ed1ng: h\u00e0m Match s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong v\u00f9ng t\u00ecm ki\u1ebfm nh\u01b0ng nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb \u0111ang \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm. <strong>Ch\u00fa \u00fd: <\/strong>v\u00f9ng t\u00ecm ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c <strong>s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n<\/strong>, ngh\u0129a l\u00e0, t\u1eeb gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t \u0111\u1ebfn gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c t\u1eeb A t\u1edbi Z<\/li>\n<li>N\u1ebfu b\u1ea1n \u0111i\u1ec1n s\u1ed1 0: h\u00e0m Match s\u1ebd t\u00ecm ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong v\u00f9ng v\u00e0 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean m\u00e0 n\u00f3 t\u00ecm th\u1ea5y<\/li>\n<li>N\u1ebfu b\u1ea1n \u0111i\u1ec1n s\u1ed1 -1: h\u00e0m Match s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong v\u00f9ng t\u00ecm ki\u1ebfm nh\u01b0ng l\u01a1n h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb \u0111ang \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm. <strong>Ch\u00fa \u00fd<\/strong>: v\u00f9ng t\u00ecm ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c <strong>s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n<\/strong>, ngh\u0129a l\u00e0, t\u1eeb gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u0111\u1ebfn gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t ho\u1eb7c t\u1eeb Z t\u1edbi A<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u0110\u1ecdc \u0111\u1ebfn \u0111\u00e2y, c\u00f3 th\u1ec3 c\u00e1c b\u1ea1n th\u1ea5y b\u1eaft \u0111\u1ea7u kh\u00f3 hi\u1ec3u ph\u1ea3i kh\u00f4ng? H\u00e3y c\u00f9ng nhau l\u00e0m m\u1ed9t v\u00ed d\u1ee5 \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n:<\/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-274.gif\" title=\"ex101_92019-nho-274\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>=MATCH(E1,A2:A11,0)<\/strong><\/p>\n<figure id=\"attachment_2294\" aria-describedby=\"caption-attachment-2294\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.06.37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2294 size-large\" title=\"1- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-06-37-1024x594-1.png\" alt=\"1- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"594\"><\/a><figcaption id=\"caption-attachment-2294\" class=\"wp-caption-text\">1- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 th\u1ea5y, m\u00e3 h\u00e0ng SGK07 \u1edf v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i s\u1ed1 7 trong v\u00f9ng A2:A11, n\u00ean k\u1ebft qu\u1ea3 h\u00e0m Match c\u1ee7a ch\u00fang ta l\u00e0 7<\/p>\n<p><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match:<\/strong><\/p>\n<ol>\n<li>H\u00e0m Match tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u00f3<\/li>\n<li>H\u00e0m Match kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ch\u1eef<\/li>\n<li>N\u1ebfu v\u00f9ng t\u00ecm ki\u1ebfm c\u00f3 m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb tr\u00f9ng nhau, h\u00e0m Match s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean m\u00e0 n\u00f3 g\u1eb7p<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng c\u00f3 trong v\u00f9ng t\u00ecm ki\u1ebfm, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_ham_Match_trong_Excel\"><\/span><a id=\"doan-2\" href=\"\"><\/a>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede ph\u1ea7n tr\u01b0\u1edbc, c\u00e1c b\u1ea1n \u0111\u00e3 h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n. Gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c, h\u00e0m Match c\u1ee7a ch\u00fang ta c\u0169ng ch\u01a1i v\u1edbi c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n:<\/p>\n<ul>\n<li>D\u1ea5u h\u1ecfi ch\u1ea5m (?) \u2013 \u0111\u1ea1i di\u1ec7n cho 1 k\u00ed t\u1ef1 b\u1ea5t k\u00ec<\/li>\n<li>D\u1ea5u sao (*) \u2013 \u0111\u1ea1i di\u1ec7n cho b\u1ea5t k\u00ec s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 n\u00e0o. (Ch\u1ec9 s\u1eed d\u1ee5ng v\u1edbi Match khi tham s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m Match c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0)<\/li>\n<\/ul>\n<p>Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 sau: T\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a t\u00ean ng\u01b0\u1eddi b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cCar\u201d<\/p>\n<figure id=\"attachment_2296\" aria-describedby=\"caption-attachment-2296\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.18.53.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2296 size-large\" title=\"2- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-18-53-1024x596-1.png\" alt=\"2- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"596\"><\/a><figcaption id=\"caption-attachment-2296\" class=\"wp-caption-text\">2- H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>V\u1edbi h\u00e0m match s\u1eed d\u1ee5ng c\u00f9ng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n d\u1ea5u \u201c*\u201d, ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 2:<\/p>\n<p><strong>=MATCH( E1 &amp; <span style=\"background-color: #ffff00\">\u201c*\u201d<\/span> , A2:A11 , 0 )<\/strong><\/p>\n<p>M\u1ed9t v\u00ed d\u1ee5 n\u1eefa v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n d\u1ea5u h\u1ecfi ch\u1ea5m (?) v\u1edbi d\u1eef li\u1ec7u \u1edf b\u1ea3ng ph\u00eda tr\u00ean:<\/p>\n<p><strong>=MATCH( <span style=\"background-color: #ffff00\">\u201cba?er\u201d<\/span>\u00a0, A2:A11 , 0 )<\/strong><\/p>\n<p>Ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 5, l\u00e0 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a t\u00ean \u201cBaker\u201d<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_Match_co_phan_biet_chu_hoa_chu_thuong\"><\/span><a id=\"doan-3\" href=\"\"><\/a>S\u1eed d\u1ee5ng h\u00e0m Match c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf ph\u1ea7n tr\u01b0\u1edbc, h\u00e0m Match khi t\u00ecm ki\u1ebfm s\u1ebd kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng. \u0110\u1ec3 gi\u00fap h\u00e0m Match ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, ta s\u1ebd k\u1ebft h\u1ee3p h\u00e0m Match v\u1edbi h\u00e0m EXACT nh\u01b0 sau:<\/p>\n<p><strong>=MATCH( TRUE, EXACT ( &lt;v\u00f9ng t\u00ecm ki\u1ebfm &gt;, &lt; gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm &gt;), 0)<\/strong><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 hi\u1ec3u c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<ul>\n<li>H\u00e0m EXACT s\u1ebd gi\u00fap ch\u00fang ta so s\u00e1nh gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm v\u1edbi m\u1ed7i gi\u00e1 tr\u1ecb trong v\u00f9ng t\u00ecm ki\u1ebfm. N\u1ebfu \u00f4 \u0111\u01b0\u1ee3c so s\u00e1nh tr\u00f9ng kh\u00edt v\u1ec1 n\u1ed9i dung 100% v\u1edbi \u00f4 \u0111em \u0111i so s\u00e1nh th\u00ec h\u00e0m EXACT s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE, n\u1ebfu kh\u00f4ng h\u00e0m EXACT s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE<\/li>\n<li>Sau \u0111\u00f3 h\u00e0m Match s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb TRUE \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m EXACT n\u00e0y, k\u1ebft qu\u1ea3 l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MATCH c\u00f3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/li>\n<\/ul>\n<p><strong>Ch\u00fa \u00fd: <\/strong>\u0111\u00e2y l\u00e0 1 <strong>c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong>, sau khi nh\u1eadp xong c\u00f4ng th\u1ee9c, b\u1ea1n s\u1eed d\u1ee5ng ph\u00edm t\u1eaft<strong> CTRL + SHIFT + ENTER <\/strong>\u0111\u1ec3 nh\u1eadp, b\u1ea1n kh\u00f4ng c\u1ea7n th\u00eam d\u1ea5u ngo\u1eb7c nh\u1ecdn v\u00e0o c\u00f4ng th\u1ee9c.<\/p>\n<figure id=\"attachment_2298\" aria-describedby=\"caption-attachment-2298\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.31.35.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2298 size-large\" title=\"3 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-31-35-1024x512-1.png\" alt=\"3 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"512\"><\/a><figcaption id=\"caption-attachment-2298\" class=\"wp-caption-text\">3 \u2013 H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p><a href=\"http:\/\/www.hocexcel.online\/ex101\">http:\/\/www.hocexcel.online\/ex101<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_2_cot_tim_su_khac_biet\"><\/span><a id=\"doan-4\" href=\"\"><\/a>So s\u00e1nh 2 c\u1ed9t t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u00f3 l\u00e0 so s\u00e1nh 2 c\u1ed9t trong Excel \u0111\u1ec3 bi\u1ebft th\u00e0nh ph\u1ea7n n\u00e0o \u1edf c\u1ed9t 1 ch\u01b0a c\u00f3 trong c\u1ed9t 2 ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i. C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, trong \u0111\u00f3 c\u00f3 c\u00e1ch s\u1eed d\u1ee5ng Match k\u1ebft h\u1ee3p v\u1edbi h\u00e0m ISNA:<\/p>\n<p><strong>=IF(ISNA(MATCH(&lt; gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong c\u1ed9t 1 &gt;, &lt; c\u1ed9t 2 &gt;, 0)), \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d, \u201c\u201d )<\/strong><\/p>\n<p>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li>H\u00e0m Match s\u1ebd t\u00ecm t\u1eebng gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 1 trong c\u1ed9t 2, n\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, h\u00e0m Match s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/li>\n<li>H\u00e0m ISNA ki\u1ec3m tra xem k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m Match c\u00f3 ph\u1ea3i l\u00e0 #N\/A hay kh\u00f4ng. N\u1ebfu h\u00e0m ISNA tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u00fang, ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, \u0111i\u1ec1u n\u00e0y d\u1eabn \u0111\u1ebfn vi\u1ec7c tham s\u1ed1 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0m IF c\u00f3 gi\u00e1 tr\u1ecb TRUE, do v\u1eady k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF s\u1ebd l\u00e0 \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d<\/li>\n<\/ul>\n<p>\u0110\u1ec3 minh ho\u1ea1 cho \u0111o\u1ea1n gi\u1ea3i th\u00edch r\u1ea5t l\u00e0 d\u00e0i ph\u00eda tr\u00ean, kh\u00f4ng c\u00f3 g\u00ec t\u1ed1t h\u01a1n 1 v\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_2300\" aria-describedby=\"caption-attachment-2300\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.44.42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2300 size-large\" title=\"4 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-44-42-1024x627-1.png\" alt=\"4 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"627\"><\/a><figcaption id=\"caption-attachment-2300\" class=\"wp-caption-text\">4 \u2013 H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, 2 t\u00ean Alexander v\u00e0 Graham c\u00f3 trong c\u1ed9t 1 m\u00e0 kh\u00f4ng c\u00f3 trong c\u1ed9t 2, v\u1eady n\u00ean k\u1ebft qu\u1ea3 th\u00f4ng b\u00e1o nh\u01b0 \u1edf c\u1ed9t C.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_Vlookup_va_Match\"><\/span><a id=\"doan-5\" href=\"\"><\/a>K\u1ebft h\u1ee3p Vlookup v\u00e0 Match<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ebfn \u0111\u00e2y, m\u00ecnh tin l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft s\u1eed d\u1ee5ng h\u00e0m vlookup r\u1ed3i, n\u1ebfu ch\u01b0a, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o ch\u1eef <a href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html\">Vlookup<\/a> \u0111\u1ec3 t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y tr\u01b0\u1edbc khi ti\u1ebfp t\u1ee5c.<\/p>\n<p>M\u1ed9t v\u1ea5n \u0111\u1ec1 r\u1ea5t hay g\u1eb7p ph\u1ea3i c\u1ee7a h\u00e0m Vlookup \u0111\u00f3 l\u00e0: L\u1ed7i khi b\u1ea3ng tra c\u1ee9u thay \u0111\u1ed5i c\u1ea5u tr\u00fac, c\u00e1ch gi\u1ea3i quy\u1ebft \u0111\u1ea7u ti\u00ean l\u00e0 <a href=\"https:\/\/blog.hocexcel.online\/to-chuc-du-lieu-tranh-loi-vlookup.html\">t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t h\u01a1n trong Excel<\/a>\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u 1 k\u0129 thu\u1eadt n\u1eefa \u0111\u1ec3 h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y.<\/p>\n<p>Ch\u00fang ta c\u00f3 1 v\u00ed d\u1ee5 v\u1ec1 h\u00e0m VLookup nh\u01b0 sau:<\/p>\n<figure id=\"attachment_2302\" aria-describedby=\"caption-attachment-2302\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.52.24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2302 size-large\" title=\"5 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-52-24-1024x533-1.png\" alt=\"5 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"533\"><\/a><figcaption id=\"caption-attachment-2302\" class=\"wp-caption-text\">5 \u2013 H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd xo\u00e1 c\u1ed9t \u0110\u01a1n Gi\u00e1 \u0111i:<\/p>\n<figure id=\"attachment_2303\" aria-describedby=\"caption-attachment-2303\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.53.33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2303 size-large\" title=\"6 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-53-33-1024x628-1.png\" alt=\"6 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"628\"><\/a><figcaption id=\"caption-attachment-2303\" class=\"wp-caption-text\">6 \u2013 H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>\u0110\u1ec3 h\u1ea1n ch\u1ebf l\u1ed7i n\u00e0y, ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p h\u00e0m Match v\u00e0 Vlookup nh\u01b0 sau:<\/p>\n<p><strong>=VLOOKUP(G1,$B$2:$D$11,MATCH($F$2,$B$1:$D$1,0),FALSE)<\/strong><\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.55.50.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2304\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-55-50-1024x564-1.png\" width=\"1024\" height=\"564\" title=\"screen-shot-2016-12-26-at-16-55-50-1024x564-1\"><\/a><\/p>\n<p>V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta c\u00f3 th\u1ec3 th\u1eed xo\u00e1 c\u1ed9t \u0110\u01a1n gi\u00e1 \u0111i, k\u1ebft qu\u1ea3 l\u00e0, h\u00e0m VLOOKUP kh\u00f4ng c\u00f2n b\u1ecb l\u1ed7i n\u1eefa. V\u00e0 Excel c\u0169ng s\u1eeda lu\u00f4n c\u00f4ng th\u1ee9c cho ch\u00fang ta.<\/p>\n<figure id=\"attachment_2305\" aria-describedby=\"caption-attachment-2305\" style=\"width: 1024px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-26-at-16.57.36.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2305 size-large\" title=\"7 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-26-at-16-57-36-1024x631-1.png\" alt=\"7 - H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5\" width=\"1024\" height=\"631\"><\/a><figcaption id=\"caption-attachment-2305\" class=\"wp-caption-text\">7 \u2013 H\u00e0m Match trong Excel qua c\u00e1c v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>M\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u00e3 kh\u00e9p l\u1ea1i b\u00e0i h\u1ecdc h\u00f4m nay. Xin h\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n v\u00e0o th\u1eddi gian t\u1edbi nh\u00e9!<\/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-274.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3548,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3547","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\/3547","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=3547"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3547\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3548"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}