{"id":12030,"date":"2025-01-15T06:34:51","date_gmt":"2025-01-15T06:34:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-match-va-cac-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016\/"},"modified":"2025-01-15T06:34:51","modified_gmt":"2025-01-15T06:34:51","slug":"ham-match-va-cac-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-match-va-cac-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016\/","title":{"rendered":"H\u00e0m Match v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Match trong Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH c\u00f9ng c\u00e1c v\u00ed d\u1ee5 c\u1ee7a h\u00e0m. \u0110\u1ed3ng th\u1eddi, b\u1ea1n s\u1ebd h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1ch ph\u00e1t tri\u1ec3n h\u00e0m lookup c\u1ee7a ri\u00eang m\u00ecnh b\u1eb1ng c\u00e1ch t\u1ea1o h\u00e0m d\u1ef1a tr\u00ean <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a> v\u00e0 MATCH Excel<\/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-678757077c7bb\" 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\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ham_Match_trong_Excel_cu_phap_va_cach_su_dung\" title=\"H\u00e0m Match trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">H\u00e0m Match trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/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\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#4_dien_ban_can_biet_ve_ham_Match\" title=\"4 \u0111i\u1ec1n b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Match\">4 \u0111i\u1ec1n b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Match<\/a><\/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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ung_dung_cua_ham_Match_trong_Excel\" title=\"\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m Match trong Excel\u00a0\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m Match trong Excel\u00a0<\/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\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ham_Match_voi_cac_ky_tu_dai_dien\" title=\"H\u00e0m Match v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\">H\u00e0m Match v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/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\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ham_Match_phan_biet_kieu_chu\" title=\"H\u00e0m Match ph\u00e2n bi\u1ec7t ki\u1ec3u ch\u1eef\">H\u00e0m Match ph\u00e2n bi\u1ec7t ki\u1ec3u ch\u1eef<\/a><\/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-6\" href=\"https:\/\/blog.hocexcel.online\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#So_sanh_hai_cot_tim_su_giong_va_khac_nhau_bang_ham_IsnaMatch\" title=\"So s\u00e1nh hai c\u1ed9t t\u00ecm s\u1ef1 gi\u1ed1ng v\u00e0 kh\u00e1c nhau b\u1eb1ng\u00a0h\u00e0m Isna\/Match\">So s\u00e1nh hai c\u1ed9t t\u00ecm s\u1ef1 gi\u1ed1ng v\u00e0 kh\u00e1c nhau b\u1eb1ng\u00a0h\u00e0m Isna\/Match<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ham_VlookUp_va_Match\" title=\"H\u00e0m VlookUp v\u00e0 Match\">H\u00e0m VlookUp v\u00e0 Match<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html#Ham_HlookUp_va_Match\" title=\"H\u00e0m HlookUp v\u00e0 Match\">H\u00e0m HlookUp v\u00e0 Match<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Match_trong_Excel_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m Match trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\" target=\"_blank\" rel=\"noopener noreferrer\">S\u1eed d\u1ee5ng h\u00e0m MATCH<\/a> trong Excel gi\u00fap t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4, v\u00e0 \u0111\u01b0a ra v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MATCH excel nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify\"><b>MATCH (lookup_value, lookup_array, [match_type])<\/b><\/li>\n<li style=\"text-align: justify\"><b>Lookup_value<\/b><span style=\"font-weight: 400\">(b\u1eaft bu\u1ed9c): l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm. C\u00f3 th\u1ec3 l\u00e0 s\u1ed1, ch\u1eef, gi\u00e1 tr\u1ecb logic ho\u1eb7c \u00f4 tham chi\u1ebfu <\/span><\/li>\n<li style=\"text-align: justify\"><b>Lookup_array <\/b><span style=\"font-weight: 400\">(b\u1eaft bu\u1ed9c): l\u00e0 d\u00e3y c\u00e1c \u00f4 c\u1ea7n t\u00ecm ki\u1ebfm<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>Match_type <\/b><span style=\"font-weight: 400\">(tu\u1ef3 ch\u1ecdn): x\u00e1c \u0111\u1ecbnh lo\u1ea1i t\u00ecm ki\u1ebfm. C\u00f3 th\u1ec3 nh\u1eadn m\u1ed9t trong c\u00e1c gi\u00e1 tr\u1ecb sau: 1, 0, -1. Khi \u0111\u1eb7t match_type b\u1eb1ng 0, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 ch\u00ednh x\u00e1c, trong khi hai lo\u1ea1i c\u00f2n l\u1ea1i cho gi\u00e1 tr\u1ecb x\u1ea5p x\u1ec9. <\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">1 ho\u1eb7c kh\u00f4ng ghi g\u00ec (m\u1eb7c \u0111\u1ecbnh): t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong d\u00e3y t\u00ecm ki\u1ebfm sao cho gi\u00e1 tr\u1ecb \u0111\u00f3 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Lo\u1ea1i n\u00e0y y\u00eau c\u1ea7u s\u1eafp x\u1ebfp d\u00e3y t\u00ecm ki\u1ebfm theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t ho\u1eb7c t\u1eeb A \u0111\u1ebfn Z<\/span><\/li>\n<li><span style=\"font-weight: 400\">0: t\u00ecm gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong d\u00e3y b\u1eb1ng \u0111\u00fang gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Kh\u00f4ng y\u00eau c\u1ea7u s\u1eafp x\u1ebfp d\u00e3y t\u00ecm ki\u1ebfm<\/span><\/li>\n<li><span style=\"font-weight: 400\">-1: t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong d\u00e3y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. D\u00e3y t\u00ecm ki\u1ebfm n\u00ean \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, t\u1eeb to nh\u1ea5t \u0111\u1ebfn nh\u1ecf nh\u1ea5t ho\u1eb7c t\u1eeb Z \u0111\u1ebfn A.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u h\u01a1n <strong>h\u00e0m MATCH excel<\/strong>, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n d\u1ef1a tr\u00ean d\u1eef li\u1ec7u sau: T\u00ean h\u1ecdc sinh \u1edf c\u1ed9t A v\u00e0 \u0111i\u1ec3m \u1edf c\u1ed9t B, s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n. \u0110\u1ec3 t\u00ecm ra v\u1ecb tr\u00ed m\u1ed9t h\u1ecdc sinh c\u1ee5 th\u1ec3 (v\u00ed d\u1ee5 Ho\u00e0ng), s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><strong>=MATCH (\u201cHo\u00e0ng\u201d, A2:A8, 0)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4713\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-27-at-21-57-34.png\" width=\"600\" height=\"307\" title=\"screen-shot-2017-04-27-at-21-57-34\"><\/p>\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\/2025\/01\/vba101_92019-nho-70.gif\" title=\"vba101_92019-nho-70\"><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\/2025\/01\/ex101_92019-nho-344.gif\" title=\"ex101_92019-nho-344\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong b\u1ee9c \u1ea3nh tr\u00ean, t\u00ean h\u1ecdc sinh \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o d\u00e3y m\u1ed9t c\u00e1ch ng\u1eabu nhi\u00ean, do \u0111\u00f3 ch\u00fang ta \u0111\u1eb7t match_type b\u1eb1ng 0 v\u00ec lo\u1ea1i n\u00e0y kh\u00f4ng y\u00eau c\u1ea7u s\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb trong d\u00e3y t\u00ecm ki\u1ebfm. C\u00f4ng th\u1ee9c MATCH cho ch\u00fang ta bi\u1ebft r\u1eb1ng Ho\u00e0ng \u0111\u1ee9ng \u1edf v\u1ecb tr\u00ed th\u1ee9 7 trong d\u00e3y gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. \u00a0<\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"4_dien_ban_can_biet_ve_ham_Match\"><\/span>4 \u0111i\u1ec1n b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Match<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\"> Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, s\u1eed d\u1ee5ng <strong>h\u00e0m MATCH<\/strong>\u00a0Excel kh\u00f4ng h\u1ec1 kh\u00f3. Tuy nhi\u00ean, b\u1ea1n n\u00ean ch\u00fa \u00fd nh\u1eefng \u0111i\u1ec1u sau \u0111\u00e2y:<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m MATCH Excel ch\u1ec9 tr\u1ea3 l\u1ea1i <\/span><b>v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i <\/b><span style=\"font-weight: 400\">\u00a0c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm trong m\u1ed9t d\u00e3y, kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb c\u1ee7a ch\u00ednh n\u00f3<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m MATCH kh\u00f4ng ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef in hoa v\u00e0 kh\u00f4ng in hoa khi x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng ch\u1eef<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu chu\u1ed7i t\u00ecm ki\u1ebfm ch\u1ee9a m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong chu\u1ed7i t\u00ecm ki\u1ebfm, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/span><\/li>\n<\/ol>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ung_dung_cua_ham_Match_trong_Excel\"><\/span><b>\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m Match trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_Match_voi_cac_ky_tu_dai_dien\"><\/span>H\u00e0m Match v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, h\u00e0m MATCH excel hi\u1ec3u nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n sau:<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><span style=\"font-weight: 400\">D\u1ea5u h\u1ecfi (?): thay th\u1ebf cho m\u1ed9t k\u00fd t\u1ef1 <\/span><\/li>\n<li><span style=\"font-weight: 400\">D\u1ea5u hoa th\u1ecb (*): thay th\u1ebf cho m\u1ed9t chu\u1ed7i c\u00e1c k\u00ed t\u1ef1 <\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>L\u01b0u \u00a0\u00fd<\/b><span style=\"font-weight: 400\">: K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1ecfng c\u00f4ng th\u1ee9c h\u00e0m MATCH excel v\u1edbi match_type l\u00e0 0.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c Match v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u01b0\u1ee3c d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t v\u00e0i k\u00ed t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n. \u0110\u1ec3 minh ho\u1ea1 r\u00f5 h\u01a1n, ch\u00fang ta h\u00e3y xem v\u00ed d\u1ee5 sau <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch nh\u1eefng ng\u01b0\u1eddi b\u00e1n trong khu v\u1ef1c v\u00e0 doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a h\u1ecd trong th\u00e1ng v\u1eeba r\u1ed3i. B\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t ng\u01b0\u1eddi b\u00e1n nh\u1ea5t \u0111\u1ecbnh trong danh s\u00e1ch nh\u01b0ng kh\u00f4ng th\u1ec3 nh\u1edb ch\u00ednh x\u00e1c t\u00ean anh ta, nh\u01b0ng b\u1ea1n nh\u1edb \u0111\u01b0\u1ee3c m\u1ed9t v\u00e0i ch\u1eef c\u00e1i trong t\u00ean c\u1ee7a anh \u1ea5y.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u00ean c\u1ee7a ng\u01b0\u1eddi b\u00e1n n\u1eb1m trong d\u00e3y A2:A11, v\u00e0 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm t\u00ean b\u1eaft \u0111\u1ea7u v\u1edbi t\u1eeb \u201cHo\u201d, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=MATCH (\u201cHo*\u201d, A2:A11, 0)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0o m\u1ed9t v\u00e0i \u00f4 (nh\u01b0 \u00f4 E1 trong v\u00ed d\u1ee5 n\u00e0y), v\u00e0 gh\u00e9p \u00f4 \u0111\u00f3 v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=MATCH (E1&amp; \u201c*\u201d, A2:A11, 0)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 h\u00ecnh ch\u1ee5p b\u00ean d\u01b0\u1edbi, c\u00f4ng th\u1ee9c tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb , l\u00e0 v\u1ecb tr\u00ed c\u1ee7a \u201cHo\u00e0ng\u201d<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4714\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-16-56-19.png\" width=\"600\" height=\"329\" title=\"screen-shot-2017-04-28-at-16-56-19\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 thay th\u1ebf m\u1ed9t k\u00ed t\u1ef1 trong gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, s\u1eed d\u1ee5ng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n \u201c?\u201d nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=MATCH (\u201cm?nh\u201d, A2:A11, 0)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c tr\u00ean h\u1ee3p v\u1edbi t\u00ean Minh v\u00e0 ch\u1ea1y l\u1ea1i v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a n\u00f3 l\u00e0 5<\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Match_phan_biet_kieu_chu\"><\/span><strong>H\u00e0m Match ph\u00e2n bi\u1ec7t ki\u1ec3u ch\u1eef<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp l\u00fac \u0111\u1ea7u, h\u00e0m MATCH trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef in hoa v\u00e0 th\u01b0\u1eddng. \u0110\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c Match ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c hai lo\u1ea1i k\u00ed t\u1ef1 n\u00e0y, c\u00e1c b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m MATCH excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m EXACT so s\u00e1nh c\u00e1c \u00f4 ch\u00ednh x\u00e1c, bao g\u1ed3m d\u1ea1ng k\u00ed t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef \u0111\u1ec3 tr\u00f9ng v\u1edbi d\u1eef li\u1ec7u trong Excel l\u00e0<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=MATCH (TRUE, EXACT (<\/b><b>d\u00e3y t\u00ecm ki\u1ebfm, gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/b><b>), 0)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c ch\u1ea1y \u0111\u01b0\u1ee3c khi<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><span style=\"font-weight: 400\">H\u00e0m EXACT so s\u00e1nh gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u1edbi m\u1ed7i y\u1ebfu t\u1ed1 c\u1ee7a d\u00e3y t\u00ecm ki\u1ebfm. N\u1ebfu \u00f4 \u0111\u01b0\u1ee3c so s\u00e1nh b\u1eb1ng ch\u00ednh x\u00e1c, h\u00e0m tr\u1ea3 gi\u00e1 tr\u1ecb TRUE, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 FALSE<\/span><\/li>\n<li><span style=\"font-weight: 400\">Sau \u0111\u00f3, h\u00e0m MATCH Excel so s\u00e1nh TRUE (gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u1ee7a n\u00f3) v\u1edbi gi\u00e1 tr\u1ecb trong d\u00e3y \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i b\u1edfi h\u00e0m EXACT, v\u00e0 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb tr\u00f9ng \u0111\u1ea7u ti\u00ean.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1c b\u1ea1n n\u00ean nh\u1edb \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c chu\u1ed7i n\u00ean c\u00e1c b\u1ea1n c\u1ea7n ph\u1ea3i \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <\/span><span style=\"font-weight: 400\">Ctrl + Shift + Enter<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n \u1edf \u00f4 E1 v\u00e0 chu\u1ed7i t\u00ecm ki\u1ebfm l\u00e0 A2:A9, c\u00f4ng th\u1ee9c nh\u01b0 sau <\/span><\/p>\n<p style=\"text-align: justify\"><b>=MATCH (TRUE, EXACT (A2:A9, E1), 0)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y minh ho\u1ea1 cho c\u00f4ng th\u1ee9c Match ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef trong Excel<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4715\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-18-47-45.png\" width=\"600\" height=\"306\" title=\"screen-shot-2017-04-28-at-18-47-45\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel 2016 <\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"So_sanh_hai_cot_tim_su_giong_va_khac_nhau_bang_ham_IsnaMatch\"><\/span>So s\u00e1nh hai c\u1ed9t t\u00ecm s\u1ef1 gi\u1ed1ng v\u00e0 kh\u00e1c nhau b\u1eb1ng\u00a0h\u00e0m Isna\/Match<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00fa ph\u00e1p nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=IF (ISNA (MATCH (<\/b><b>gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong c\u1ed9t 1, c\u1ed9t 2, 0<\/b><b>)), \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d, \u201c\u201d)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o c\u1ee7a c\u1ed9t 2 m\u00e0 kh\u00f4ng c\u00f3 trong c\u1ed9t 1, c\u00f4ng th\u1ee9c tr\u1ea3 l\u1ea1i l\u00e0 \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d. Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">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 Excel 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.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">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, h\u00e0m tr\u1ea3 v\u1ec1 l\u00e0 TRUE, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 FALSE. Trong v\u00ed d\u1ee5 n\u00e0y, TRUE ngh\u0129a l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 1 kh\u00f4ng t\u00ecm th\u1ea5y trong c\u1ed9t 2 do \u0111\u00f3 l\u1ed7i #N\/A \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m MATCH<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Vi\u1ec7c nh\u00ecn th\u1ea5y TRUE cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t 1 c\u00f3 th\u1ec3 g\u00e2y nh\u1ea7m l\u1eabn cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng, b\u1ea1m c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng h\u00e0m IF \u0111\u1ec3 hi\u1ec3n th\u1ecb \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d ho\u1eb7c b\u1ea5t c\u1ee9 ch\u1eef n\u00e0o b\u1ea1n mu\u1ed1n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang so s\u00e1nh gi\u00e1 tr\u1ecb \u1edf c\u1ed9t B v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t A, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng sau:<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=IF (ISNA (MATCH (B2, A:A, 0)), \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d, \u201c\u201d)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m MATCH trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c d\u1ea1ng ch\u1eef. Do v\u1eady, \u0111\u1ec3 ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, ta g\u1eafn th\u00eam h\u00e0m EXACT v\u00e0o chu\u1ed7i t\u00ecm ki\u1ebfm lookup_array, v\u00e0 nh\u1edb \u1ea5n t\u1ed5 h\u1ee3p <\/span><span style=\"font-weight: 400\">Ctrl + Shift + Enter<\/span><\/p>\n<p style=\"text-align: justify\"><em><b>=IF (ISNA (MATCH (TRUE, EXACT (A:A, B2), 0)), \u201cKh\u00f4ng c\u00f3 trong c\u1ed9t 1\u201d, \u201c\u201d)<\/b><\/em><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u1ea3 hai c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4716\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-22-19-06.png\" width=\"600\" height=\"461\" title=\"screen-shot-2017-04-28-at-22-19-06\"><\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_VlookUp_va_Match\"><\/span>H\u00e0m VlookUp v\u00e0 Match<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u1ede b\u00e0i vi\u1ebft n\u00e0y m\u1eb7c \u0111\u1ecbnh b\u1ea1n \u0111\u00e3 c\u00f3 ki\u1ebfm ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m VLOOKUP trong Excel. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng khuy\u1ebft \u0111i\u1ec3m l\u1edbn nh\u1ea5t c\u1ee7a h\u00e0m VLOOKUP \u00a0l\u00e0 n\u00f3 d\u1eebng l\u00e0m vi\u1ec7c sau khi ch\u00e8n ho\u1eb7c xo\u00e1 m\u1ed9t c\u1ed9t trong b\u1ea3ng t\u00ecm ki\u1ebfm. \u0110\u00f3 l\u00e0 v\u00ec VLOOKUP k\u00e9o m\u1ed9t gi\u00e1 tr\u1ecb tr\u00f9ng d\u1ef1a tr\u00ean s\u1ed1 c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n x\u00e1c \u0111\u1ecbnh, Excel s\u1ebd kh\u00f4ng th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh s\u1ed1 khi m\u1ed9t hay nhi\u1ec1u c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ho\u1eb7c xo\u00e1 b\u1edbt \u0111i kh\u1ecfi b\u1ea3ng. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m MATCH excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, do \u0111\u00f3 ho\u00e0n to\u00e0n ph\u00f9 h\u1ee3p \u0111\u1ed1i v\u1edbi <\/span><i><span style=\"font-weight: 400\">col_index_num <\/span><\/i><span style=\"font-weight: 400\">c\u1ee7a h\u00e0m VLOOKUP. N\u00f3i c\u00e1ch kh\u00e1c, thay v\u00ec ch\u1ec9 r\u00f5 c\u1ed9t tr\u1ea3 l\u1ea1i nh\u01b0 m\u1ed9t s\u1ed1 kh\u00f4ng thay \u0111\u1ed5i, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m MATCH \u0111\u1ec3 bi\u1ebft v\u1ecb tr\u00ed hi\u1ec7n t\u1ea1i c\u1ee7a c\u1ed9t \u0111\u00f3. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u d\u1ec5 d\u00e0ng h\u01a1n, ch\u00fang ta h\u00e3y c\u00f9ng xem l\u1ea1i v\u00ed d\u1ee5 v\u1ec1 \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh nh\u01b0ng l\u1ea7n n\u00e0y ch\u00fang ta s\u1ebd g\u1ecdi \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh m\u00e0 kh\u00f4ng ph\u1ea3i v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i nh\u01b0 l\u1ea7n tr\u01b0\u1edbc.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 F1, d\u00e3y b\u1ea3ng l\u00e0 A1:C2, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=VLOOKUP (F1, A1:C8, 3, FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Tham s\u1ed1 th\u1ee9 3 (<\/span><i><span style=\"font-weight: 400\">col_index_num<\/span><\/i><span style=\"font-weight: 400\">) \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u00e0 3 v\u00ec \u0110i\u1ec3m to\u00e1n m\u00e0 ch\u00fang ta mu\u1ed1n k\u00e9o n\u1eb1m \u1edf c\u1ed9t th\u1ee9 3 trong b\u1ea3ng. Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m Vlookup l\u00e0m vi\u1ec7c b\u00ecnh th\u01b0\u1eddng<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4717\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-22-26-17.png\" width=\"600\" height=\"299\" title=\"screen-shot-2017-04-28-at-22-26-17\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">cho \u0111\u1ebfn khi b\u1ea1n ch\u00e8n th\u00eam ho\u1eb7c xo\u00e1 b\u1edbt c\u1ed9t <\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4718\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-22-27-07.png\" width=\"600\" height=\"303\" title=\"screen-shot-2017-04-28-at-22-27-07\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1eady t\u1ea1i sao l\u1ed7i #REF l\u1ea1i x\u1ea3y ra? \u0110\u00f3 l\u00e0 v\u00ec tham s\u1ed1\u00a0<\/span><i><span style=\"font-weight: 400\">col_index_num <\/span><\/i><span style=\"font-weight: 400\">khi \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u1eb1ng 3 \u0111\u00e3 th\u00f4ng b\u00e1o cho Excel \u0111\u1ec3 l\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t th\u1ee9 3, trong khi hi\u1ec7n t\u1ea1i l\u1ea1i ch\u1ec9 c\u00f3 2 c\u1ed9t trong b\u1ea3ng.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ph\u00e1t tri\u1ec3n h\u00e0m Vlookup b\u1eb1ng c\u00e1ch th\u00eam h\u00e0m Match:<\/span><\/p>\n<p style=\"text-align: justify\"><b>MATCH (E2, A1:C1, 0)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi:<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><span style=\"font-weight: 400\">E2 l\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, l\u00e0 t\u00ean ch\u00ednh x\u00e1c c\u1ee7a c\u1ed9t tr\u1ea3 l\u1ea1i, v\u00ed d\u1ee5 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb, \u1edf \u0111\u00e2y l\u00e0 c\u1ed9t \u201c\u0110i\u1ec3m To\u00e1n\u201d<\/span><\/li>\n<li><span style=\"font-weight: 400\">A1:C1 l\u00e0 d\u00e3y t\u00ecm ki\u1ebfm ch\u1ee9a b\u1ea3ng <\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Sau \u0111\u00f3 g\u1ed9p h\u00e0m Match v\u00e0o tham s\u1ed1 <\/span><i><span style=\"font-weight: 400\">col_index_num <\/span><\/i><span style=\"font-weight: 400\">c\u1ee7a h\u00e0m Vlookup nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><b>=VLOOKUP (F1, A:C8, MATCH (E2, A1:C1, O), FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00e0 ch\u1eafc ch\u1eafn r\u1eb1ng h\u00e0m s\u1ebd l\u00e0m vi\u1ec7c t\u1ed1t d\u00f9 b\u1ea1n c\u00f3 th\u00eam hay xo\u00e1 bao nhi\u00eau c\u1ed9t <\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4719\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-22-45-24.png\" width=\"600\" height=\"254\" title=\"screen-shot-2017-04-28-at-22-45-24\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong h\u00ecnh ch\u1ee5p tr\u00ean, H\u1ecdc Excel Online \u0111\u00e3 xo\u00e1 t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tham chi\u1ebfu \u0111\u1ec3 h\u00e0m ho\u1ea1t \u0111\u1ed9ng t\u1ed1t k\u1ec3 c\u1ea3 khi ng\u01b0\u1eddi s\u1eed d\u1ee5ng chuy\u1ec3n t\u1edbi v\u1ecb tr\u00ed kh\u00e1c trong worksheet. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c sau khi xo\u00e1 m\u1ed9t c\u1ed9t v\u00e0 Excel th\u1eadm ch\u00ed c\u00f2n c\u00f3 th\u1ec3 t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/span><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel 2010<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_HlookUp_va_Match\"><\/span>H\u00e0m HlookUp v\u00e0 Match<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 Vlookup, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 ph\u00e1t tri\u1ec3n c\u00f4ng th\u1ee9c HLOOKUP c\u1ee7a m\u00ecnh. Nguy\u00ean t\u1eafc chung c\u0169ng gi\u1ed1ng nh\u01b0 Vlookup: b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 l\u1ea5y v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a c\u1ed9t c\u1ea7n tr\u1ea3 l\u1ea1i, v\u00e0 cung c\u1ea5p s\u1ed1 c\u1ee7a c\u1ed9t \u0111\u00f3 cho tham s\u1ed1 <\/span><i><span style=\"font-weight: 400\">row_index_number <\/span><\/i><span style=\"font-weight: 400\">c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\">h\u00e0m Hlookup<\/a><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 B5, b\u1ea3ng B1:h3, t\u00ean c\u1ee7a h\u00e0ng tr\u1ea3 l\u1ea1i (c\u0169ng l\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u1ee7a h\u00e0m MATCH) \u1edf \u00f4 A6 v\u00e0 ti\u00eau \u0111\u1ec1 h\u00e0ng l\u00e0 A1:A3, c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B5, B1:H3, MATCH (A6, A1:A3, 0), FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4720\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-04-28-at-22-50-12.png\" width=\"600\" height=\"253\" title=\"screen-shot-2017-04-28-at-22-50-12\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 v\u1eady, s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa Hlookup\/Vlookup v\u1edbi Match \u0111\u00e3 gi\u00fap ph\u00e1t tri\u1ec3n h\u00e0m Hlookup v\u00e0 Vlookup. Tuy nhi\u00ean, h\u00e0m MATCH excel kh\u00f4ng th\u1ec3 lo\u1ea1i b\u1ecf h\u1ebft t\u1ea5t c\u1ea3 c\u00e1c khuy\u1ebft \u0111i\u1ec3m. \u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, b\u1ea1n n\u00ean th\u1eed s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH, m\u1ed9t c\u00f4ng c\u1ee5 th\u1ef1c s\u1ef1 m\u1ea1nh v\u00e0 linh ho\u1ea1t gi\u00fap t\u00ecm ki\u1ebfm trong Excel v\u00e0 v\u01b0\u1ee3t tr\u1ed9i h\u01a1n Vlookup v\u00e0 Hlookup tr\u00ean nhi\u1ec1u ph\u01b0\u01a1ng di\u1ec7n. <\/span><\/p>\n<p style=\"text-align: left\"><span style=\"font-weight: 400\">Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n \u0111\u00e3 bi\u1ebft l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Match Excel. Hy v\u1ecdng nh\u1eefng v\u00ed d\u1ee5 m\u00e0 H\u1ecdc Excel Online cung c\u1ea5p trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap \u00edch trong c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n. <\/span>Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: left\">\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\/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\/2025\/01\/vba101_92019-nho-70.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12031,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12030","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\/12030","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=12030"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12031"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}