{"id":10493,"date":"2025-01-14T10:09:19","date_gmt":"2025-01-14T10:09:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel\/"},"modified":"2025-01-14T10:09:19","modified_gmt":"2025-01-14T10:09:19","slug":"cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ecm d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t c\u1ed9t b\u1eb1ng h\u00e0m Match trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\">H\u00e0m Match<\/a> l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong Excel \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a 1 gi\u00e1 tr\u1ecb trong 1 v\u00f9ng. V\u00e0 ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 t\u00ecm d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match. L\u00e0m vi\u1ec7c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch th\u1ef1c hi\u1ec7n nh\u00e9.<\/p>\n<p>H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u qua v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19365\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-dong-cuoi-ham-match-de-bai.png\" width=\"706\" height=\"397\" title=\"tim-dong-cuoi-ham-match-de-bai\"><\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta l\u00e0 t\u00ecm d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u \u1edf c\u1ed9t B, c\u1ed9t C v\u00e0 \u0111i\u1ec1n k\u1ebft qu\u1ea3 v\u00e0o \u00f4 B15, C15. Trong \u0111\u00f3 c\u1ed9t B t\u00ecm theo d\u00f2ng cu\u1ed1i ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng Text, c\u1ed9t C t\u00ecm theo d\u00f2ng cu\u1ed1i ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng S\u1ed1.<\/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-678637ce9b62a\" 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\/cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel.html#Nguyen_tac_xac_dinh_dong_cuoi_co_du_lieu_cua_ham_Match\" title=\"Nguy\u00ean t\u1eafc x\u00e1c \u0111\u1ecbnh d\u00f2ng cu\u1ed1i c\u00f3 d\u1eef li\u1ec7u c\u1ee7a h\u00e0m Match\">Nguy\u00ean t\u1eafc x\u00e1c \u0111\u1ecbnh d\u00f2ng cu\u1ed1i c\u00f3 d\u1eef li\u1ec7u c\u1ee7a h\u00e0m Match<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel.html#Xac_dinh_vi_tri_o_cuoi_cung_chua_ky_tu_Text\" title=\"X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 Text\">X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 Text<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-dong-cuoi-co-chua-du-lieu-cua-mot-cot-bang-ham-match-trong-excel.html#Xac_dinh_vi_tri_o_cuoi_cung_chua_ky_tu_So\" title=\"X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 S\u1ed1\">X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 S\u1ed1<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_tac_xac_dinh_dong_cuoi_co_du_lieu_cua_ham_Match\"><\/span>Nguy\u00ean t\u1eafc x\u00e1c \u0111\u1ecbnh d\u00f2ng cu\u1ed1i c\u00f3 d\u1eef li\u1ec7u c\u1ee7a h\u00e0m Match<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 m\u1ed9t \u0111i\u1ec1u kh\u00e1 th\u00fa v\u1ecb v\u1ec1 h\u00e0m Match m\u00e0 c\u00f3 th\u1ec3 ch\u00fang ta \u00edt \u0111\u1ec3 \u00fd, \u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>H\u00e0m Match c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang ho\u1eb7c ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb qu\u00e1 l\u1edbn th\u00ec h\u00e0m Match s\u1ebd tr\u1ea3 ngay v\u1ec1 <strong>k\u1ebft qu\u1ea3 l\u00e0 d\u00f2ng cu\u1ed1i c\u00f9ng<\/strong> trong v\u00f9ng t\u00ecm ki\u1ebfm <strong>t\u01b0\u01a1ng \u1ee9ng v\u1edbi Lo\u1ea1i d\u1eef li\u1ec7u<\/strong> c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm khi s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang.<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 \u0111\u1ed1i t\u01b0\u1ee3ng lookup_value c\u1ee7a h\u00e0m Match l\u00e0 lo\u1ea1i d\u1eef li\u1ec7u n\u00e0o th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 theo lo\u1ea1i d\u1eef li\u1ec7u \u0111\u00f3. Trong Excel c\u00f3 2 lo\u1ea1i d\u1eef li\u1ec7u c\u01a1 b\u1ea3n l\u00e0 lo\u1ea1i Text v\u00e0 lo\u1ea1i S\u1ed1 (Number)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_vi_tri_o_cuoi_cung_chua_ky_tu_Text\"><\/span>X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 text trong m\u1ed9t v\u00f9ng b\u1eb1ng h\u00e0m Match th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i t\u1ea1o ra 1 gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n: D\u1ea1ng text v\u00e0 l\u00e0 k\u00fd t\u1ef1 r\u1ea5t l\u1edbn.<\/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-178.gif\" title=\"ex101_92019-nho-178\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html\">h\u00e0m REPT<\/a>. \u0110\u00e2y l\u00e0 h\u00e0m gi\u00fap t\u1ea1o ra 1\u00a0chu\u1ed7i\u00a0Text\u00a0l\u1edbn d\u1ef1a v\u00e0o vi\u1ec7c nh\u00e2n b\u1ea3n ch\u00ednh k\u00fd t\u1ef1\u00a0l\u00ean nhi\u1ec1u l\u1ea7n. Trong Excel 1 chu\u1ed7i ch\u1ec9 quy \u0111\u1ecbnh t\u1ed1i \u0111a l\u00e0 255 k\u00fd t\u1ef1. Do \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=MATCH(REPT(\u201cz\u201d,255),B2:B15)<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>lookup_value<\/strong> l\u00e0 REPT(\u201cz\u201d,255) c\u00f3 ngh\u0129a l\u00e0 chu\u1ed7i c\u00f3 255 k\u00fd t\u1ef1 z (c\u00f3 th\u1ec3 thay k\u00fd t\u1ef1 z b\u1eb1ng b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o)<\/li>\n<li><strong>lookup_array<\/strong> l\u00e0 B2:B15 l\u00e0 v\u00f9ng c\u1ea7n t\u00ecm v\u1ecb tr\u00ed cu\u1ed1i c\u00f9ng<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19366\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-dong-cuoi-ham-match-dong-cuoi-du-lieu-text.png\" width=\"766\" height=\"397\" title=\"tim-dong-cuoi-ham-match-dong-cuoi-du-lieu-text\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_vi_tri_o_cuoi_cung_chua_ky_tu_So\"><\/span>X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a k\u00fd t\u1ef1 S\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch t\u00ecm k\u00fd t\u1ef1 Text, nh\u01b0ng \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c 1 k\u00fd t\u1ef1 s\u1ed1 th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 thay k\u00fd t\u1ef1 z b\u1eb1ng 1 s\u1ed1 b\u1ea5t k\u1ef3 trong h\u00e0m REPT.<\/p>\n<p>Tuy nhi\u00ean h\u00e0m REPT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 d\u1ea1ng Text. Do \u0111\u00f3 \u0111\u1ec3 chuy\u1ec3n con s\u1ed1 c\u1ee7a h\u00e0m REPT v\u1ec1 d\u1ea1ng s\u1ed1 th\u00ec ta \u0111\u1eb7t h\u00e0m REPT trong <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">h\u00e0m VALUE<\/a>.<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C16 l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">=MATCH(VALUE(REPT(9,255)),C2:C15)<\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19367\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tim-dong-cuoi-ham-match-dong-cuoi-du-lieu-number.png\" width=\"814\" height=\"395\" title=\"tim-dong-cuoi-ham-match-dong-cuoi-du-lieu-number\"><\/p>\n<p>Nh\u01b0 v\u1eady b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 REPT, VALUE ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong 1 c\u1ed9t. Ngo\u00e0i ra ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u trong 1 h\u00e0ng b\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 c\u00e1ch l\u00e0m n\u00e0y.<\/p>\n<p>Tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/vba-tim-dong-cuoi-cung-chua-du-lieu-trong-excel.html\">T\u00ecm d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u b\u1eb1ng VBA\u00a0Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2MMRPVc\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-178.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10493","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\/10493","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=10493"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10493\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10494"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}