{"id":11256,"date":"2022-11-10T21:17:26","date_gmt":"2022-11-10T14:17:26","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11256"},"modified":"2022-12-06T14:55:51","modified_gmt":"2022-12-06T07:55:51","slug":"ham-match-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/","title":{"rendered":"H\u00e0m Match trong Excel &#8211; 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11256&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng <\/span><\/i><b><i>h\u00e0m match<\/i><\/b><i><span style=\"font-weight: 400;\"> linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, T<a href=\"https:\/\/teky.edu.vn\/\">eky<\/a> s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <\/span><\/i><b><i>h\u00e0m Match trong excel<\/i><\/b><i><span style=\"font-weight: 400;\">.<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c bi\u1ebft, excel ch\u01b0a \u0111\u1ef1ng m\u1ed9t kho t\u00e0ng c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc trong \u0111\u00f3. N\u00f3 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho b\u1ea1n trong vi\u1ec7c t\u1ea1o l\u1eadp v\u00e0 t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3. <\/span><b>H\u00e0m Match<\/b><span style=\"font-weight: 400;\"> c\u0169ng l\u00e0 m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c h\u1eefu \u00edch trong th\u01b0 vi\u1ec7n \u0111\u00f3. \u00dd ngh\u0129a ch\u00ednh khi s\u1eed d\u1ee5ng n\u00f3 l\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong 1 v\u00f9ng gi\u00e1 tr\u1ecb. Th\u1ef1c t\u1ebf, s\u1eed d\u1ee5ng match c\u00f2n c\u00f3 t\u00e1c d\u1ee5ng h\u01a1n th\u1ebf n\u1eefa, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1edbi Teky ngay sau \u0111\u00e2y.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Ham_Match_trong_excel_su_dung_nhu_the_nao\" >H\u00e0m Match trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Luu_y_de_su_dung_cong_thuc_Match_co_ban_trong_excel\" >L\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Match c\u01a1 b\u1ea3n trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Ung_dung_trong_thuc_te_cong_viec_cua_ham_Match\" >\u1ee8ng d\u1ee5ng trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c c\u1ee7a h\u00e0m Match<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Tim_su_khac_biet_co_dieu_kien_trong_2_cot\" >T\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong 2 c\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Tham_chieu_ra_gia_tri_khi_ket_hop_voi_Vlookup\" >Tham chi\u1ebfu ra gi\u00e1 tr\u1ecb khi k\u1ebft h\u1ee3p v\u1edbi Vlookup<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#Ket_hop_Match_va_Index_cho_hieu_qua_bat_ngo\" >K\u1ebft h\u1ee3p Match v\u00e0 Index cho hi\u1ec7u qu\u1ea3 b\u1ea5t ng\u1edd<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Match_trong_excel_su_dung_nhu_the_nao\"><\/span><b>H\u00e0m Match trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 d\u00f9ng \u0111\u01b0\u1ee3c Match, b\u1ea1n c\u1ea7n bi\u1ebft c\u00fa ph\u00e1p c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a <\/span><b>h\u00e0m Match<\/b><span style=\"font-weight: 400;\">:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u201c<\/span><b>= Match (&lt;gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u00ed &gt;,&lt;v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb&gt;, [gi\u00e1 tr\u1ecb: 1 ho\u1eb7c -1 ho\u1eb7c 0])<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch c\u1ee5 th\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00ean:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u00ed: \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c c\u1ea7n nh\u1eadp. L\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n t\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb: \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c c\u1ea7n nh\u1eadp.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u1eadp s\u1ed1 1: K\u1ebft qu\u1ea3 s\u1ebd ch\u1ec9 ra gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong v\u00f9ng t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u1eadp s\u1ed1 0: K\u1ebft qu\u1ea3 s\u1ebd ch\u1ec9 ra gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm trong v\u00f9ng t\u00ecm ki\u1ebfm. \u0110\u1ed3ng th\u1eddi tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean m\u00e0 n\u00f3 t\u00ecm th\u1ea5y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u1eadp s\u1ed1 -1: K\u1ebft qu\u1ea3 s\u1ebd ch\u1ec9 ra gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong v\u00f9ng t\u00ecm ki\u1ebfm.<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Index v\u00e0 Match \u0111\u00fang c\u00e1ch (H\u01a1n c\u1ea3 Vlookup)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/m18BK1lb3w0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 minh h\u1ecda c\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n c\u00f9ng l\u00e0m theo v\u00ed d\u1ee5 sau \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11264\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\" alt=\"\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1 5, b\u1edfi m\u00e3 h\u00e0ng Mau05 trong v\u00f9ng t\u00ecm ki\u1ebfm A2:A11 c\u00f3 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i s\u1ed1 5, k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11258 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-1_1.jpg\" alt=\"H\u00e0m match s\u1eed d\u1ee5ng trong excel\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-1_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-1_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Luu_y_de_su_dung_cong_thuc_Match_co_ban_trong_excel\"><\/span><b>L\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Match c\u01a1 b\u1ea3n trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u00ed d\u1ee5 \u0111\u00e3 \u0111\u01b0a \u1edf ph\u1ea7n tr\u00ean, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match c\u0169ng \u0111\u01a1n gi\u1ea3n. M\u1ed9t s\u1ed1 l\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Match c\u01a1 b\u1ea3n trong excel hi\u1ec7u qu\u1ea3 l\u00e0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m Match trong excel ch\u1ec9 tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i m\u00e0 cho ra gi\u00e1 tr\u1ecb<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u1ecb b\u1ecb tr\u00f9ng nhau, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean n\u00f3 g\u1eb7p.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng c\u00f3 trong v\u00f9ng t\u00ecm ki\u1ebfm, k\u1ebft qu\u1ea3 s\u1ebd b\u00e1o l\u1ed7i #N\/A. Nh\u01b0 v\u00ed d\u1ee5 sau:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11259 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-2_1.jpg\" alt=\"C\u00f4ng th\u1ee9c Match\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-2_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-2_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch: Trong v\u00f9ng t\u00ecm ki\u1ebfm t\u1eeb A2:A5 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u1ecb tr\u00ed l\u00e0 Mau05. Do \u0111\u00f3, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 l\u1ed7i #N\/A, m\u1ed9t l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong excel.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ung_dung_trong_thuc_te_cong_viec_cua_ham_Match\"><\/span><b>\u1ee8ng d\u1ee5ng trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c c\u1ee7a h\u00e0m Match<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta kh\u00f4ng th\u1ec3 ph\u1ee7 nh\u1eadn \u0111\u01b0\u1ee3c l\u1ee3i \u00edch m\u00e0 c\u00e1c h\u00e0m to\u00e1n h\u1ecdc trong excel. N\u00f3 kh\u00f4ng ch\u1ec9 gi\u00fap ch\u00fang ta t\u00ednh nhanh, m\u00e0 c\u00f2n t\u00ednh r\u1ea5t ch\u00ednh x\u00e1c v\u00e0 chuy\u00ean nghi\u1ec7p. M\u1ed9t trong s\u1ed1 \u0111\u00f3 Match \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean v\u00e0 ph\u1ed5 bi\u1ebfn. C\u00e1c \u1ee9ng d\u1ee5ng ti\u00eau bi\u1ec3u c\u1ee7a h\u00e0m Match ph\u1ea3i k\u1ec3 \u0111\u1ebfn nh\u01b0 sau:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tim_su_khac_biet_co_dieu_kien_trong_2_cot\"><\/span><b>T\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong 2 c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c ti\u00eau t\u1ed1n nhi\u1ec1u th\u1eddi gian v\u00e0 d\u1ec5 nh\u1ea7m l\u1eabn l\u00e0 so s\u00e1nh gi\u00e1 tr\u1ecb \u1edf 2 c\u1ed9t trong excel. \u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, ng\u01b0\u1eddi ta k\u1ebft h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 gi\u1ea3 thi\u1ebft \u0111i\u1ec1u ki\u1ec7n. C\u00f9ng v\u1edbi h\u00e0m Match \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ea7n tham chi\u1ebfu \u0111\u1ebfn.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>\u201c=IF(ISNA(Match(&lt;gi\u00e1 tr\u1ecb trong c\u1ed9t 1&gt;,&lt;c\u1ed9t 2&gt;,0)), \u201cKh\u00f4ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t 2\u201d, \u201c\u201d).<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u1ee7a t\u1eebng h\u00e0m s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9 tr\u00ean nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Match tham chi\u1ebfu t\u1eebng gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 1 xu\u1ea5t hi\u1ec7n trong c\u1ed9t 2. N\u1ebfu t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb n\u00e0o s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3. N\u1ebfu kh\u00f4ng c\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 #N\/A.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m ISNA tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 tham chi\u1ebfu xem <\/span><b>h\u00e0m Match<\/b><span style=\"font-weight: 400;\"> c\u00f3 ph\u1ea3i #N\/A hay kh\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF l\u00e0 h\u00e0m cho k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng. N\u1ebfu gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t 1 kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t 2 th\u00ec tr\u1ea3 v\u1ec1 \u201cKh\u00f4ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t 2\u201d ho\u1eb7c c\u1ee5m t\u1eeb \u201cKh\u00f4ng \u1edf c\u1ed9t 2\u201d.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11260\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-3_1.jpg\" alt=\"\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-3_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-3_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch: C\u00e1c b\u1ea1n th\u1ea5y t\u00ean Th\u00e0nh, Huy, H\u00f9ng c\u00f3 \u1edf c\u1ed9t 1 kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t 2. N\u00ean k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c nh\u01b0 tr\u00ean h\u00ecnh. Ng\u01b0\u1ee3c l\u1ea1i, t\u00ean H\u01b0\u01a1ng, Lan c\u00f3 xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t 2, n\u00ean k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tham_chieu_ra_gia_tri_khi_ket_hop_voi_Vlookup\"><\/span><b>Tham chi\u1ebfu ra gi\u00e1 tr\u1ecb khi k\u1ebft h\u1ee3p v\u1edbi Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00a0H\u00e0m Vlookup l\u00e0 h\u00e0m c\u00f4ng th\u1ee9c ch\u1eafc h\u1eb3n \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi ng\u01b0\u1eddi d\u00f9ng. Nh\u01b0ng l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 k\u1ebft h\u1ee3p <\/span><b>h\u00e0m Match trong excel<\/b><span style=\"font-weight: 400;\"> v\u00e0 h\u00e0m Vlookup. \u0110\u1ec3 v\u1eeba tham chi\u1ebfu v\u1ecb tr\u00ed, v\u1eeba tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb. V\u00ed d\u1ee5 minh h\u1ecda sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng. \u0110\u1ed3ng th\u1eddi h\u01b0\u1edbng d\u1eabn cho nh\u1eefng ai ch\u01b0a s\u1eed d\u1ee5ng c\u00e1c k\u1ebft h\u1ee3p n\u00e0y trong t\u00ednh to\u00e1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Y\u00eau c\u1ea7u b\u00e0i to\u00e1n: Hi\u1ec3n th\u1ecb doanh thu 2018 theo t\u00ean h\u00e0ng d\u00f9ng h\u00e0m Vlookup k\u1ebft h\u1ee3p h\u00e0m Match.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11257\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-match-4_1.jpg\" alt=\"\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-match-4_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-match-4_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_Match_va_Index_cho_hieu_qua_bat_ngo\"><\/span><b>K\u1ebft h\u1ee3p Match v\u00e0 Index cho hi\u1ec7u qu\u1ea3 b\u1ea5t ng\u1edd<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Index l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n trong excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb trong \u00f4 c\u1ea7n\u00a0 t\u00ecm ki\u1ebfm. Khi k\u1ebft h\u1ee3p <\/span><b>h\u00e0m match v\u00e0 index<\/b><span style=\"font-weight: 400;\"> s\u1ebd cho k\u1ebft qu\u1ea3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00f3 c\u0169ng l\u00e0 th\u1eafc m\u1eafc c\u1ee7a nhi\u1ec1u ng\u01b0\u1eddi khi d\u00f9ng excel.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda <\/span><b>h\u00e0m match index<\/b><span style=\"font-weight: 400;\"> c\u01a1 b\u1ea3n sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Y\u00eau c\u1ea7u b\u00e0i to\u00e1n: B\u1ea3ng 2 cung c\u1ea5p \u0111\u01a1n gi\u00e1 c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m theo h\u00e3ng s\u1ea3n xu\u1ea5t. B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng <\/span><b>h\u00e0m match nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 nh\u1eadp \u0111\u01a1n gi\u00e1 v\u00e0o b\u1ea3ng 1.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11261\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-5_1.jpg\" alt=\"\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-5_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-5_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u01b0\u1edbng l\u00e0m: Ta s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 h\u00e0m Match \u0111\u1ec3 tham chi\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u01a1n gi\u00e1.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u201c<\/span><b>=Index(<\/b><b>($B$15:$E$18,MATCH(B4,$B$15:$B$18,0),MATCH(C4,$B$15:$E$15))<\/b><span style=\"font-weight: 400;\">\u201d.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11262\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-6_1.jpg\" alt=\"\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-6_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-6_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u1eeba l\u00e0m xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t \u0111\u01a1n gi\u00e1. B\u1ea1n ch\u1ec9 c\u1ea7n copy v\u00e0 paste l\u1ea5y c\u00f4ng th\u1ee9c, v\u1eady l\u00e0 \u0111\u00e3 ho\u00e0n th\u00e0nh y\u00eau c\u1ea7u b\u00e0i to\u00e1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11263 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-7_1.jpg\" alt=\"\u1ee8ng d\u1ee5ng h\u00e0m match trong excel\" width=\"600\" height=\"330\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-7_1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match-7_1-400x220.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Match trong excel. Hy v\u1ecdng b\u1ea1n \u0111\u1ecdc c\u1ea3m th\u1ea5y h\u1eefu \u00edch v\u00e0 \u1ee9ng d\u1ee5ng nhi\u1ec1u trong c\u00f4ng vi\u1ec7c. N\u1ebfu b\u1ea1n c\u00f2n th\u1eafc m\u1eafc g\u00ec, b\u1ea1n vui l\u00f2ng v\u1edbi Teky \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n v\u00e0 gi\u1ea3i \u0111\u00e1p.<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-index-va-match\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Index v\u00e0 Match trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch th\u00eam c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Kh\u00e1m ph\u00e1 ngay 3 c\u00e1ch \u0111\u1ed5i c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-khoa-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed c\u00e1ch kh\u00f3a c\u1ed9t trong Excel ch\u1ec9 trong m\u1ed9t n\u1ed1t nh\u1ea1c<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Match trong excel. Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c bi\u1ebft, excel ch\u01b0a \u0111\u1ef1ng m\u1ed9t kho t\u00e0ng c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc trong &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11264,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11256","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match<\/title>\n<meta name=\"description\" content=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match\" \/>\n<meta property=\"og:description\" content=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-10T14:17:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:55:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"330\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m Match trong Excel &#8211; 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match\",\"datePublished\":\"2022-11-10T14:17:26+00:00\",\"dateModified\":\"2022-12-06T07:55:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\"},\"wordCount\":1713,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\",\"name\":\"H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\",\"datePublished\":\"2022-11-10T14:17:26+00:00\",\"dateModified\":\"2022-12-06T07:55:51+00:00\",\"description\":\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg\",\"width\":600,\"height\":330},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Match trong Excel &#8211; 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match","description":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match","og_description":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng","og_url":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-10T14:17:26+00:00","article_modified_time":"2022-12-06T07:55:51+00:00","og_image":[{"width":600,"height":330,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m Match trong Excel &#8211; 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match","datePublished":"2022-11-10T14:17:26+00:00","dateModified":"2022-12-06T07:55:51+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/"},"wordCount":1713,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/","name":"H\u00e0m Match trong Excel - 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg","datePublished":"2022-11-10T14:17:26+00:00","dateModified":"2022-12-06T07:55:51+00:00","description":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m match linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t trong excel. B\u00e0i vi\u1ebft n\u00e0y, Teky s\u1ebd c\u00f9ng c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Ham-Match_1.jpg","width":600,"height":330},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-match-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Match trong Excel &#8211; 5 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Match"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11256"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11256\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11264"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}