{"id":10079,"date":"2025-01-08T04:57:01","date_gmt":"2025-01-08T04:57:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/cach-su-dung-ham-match-trong-excel\/"},"modified":"2025-01-08T04:57:01","modified_gmt":"2025-01-08T04:57:01","slug":"cach-su-dung-ham-match-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/cach-su-dung-ham-match-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong th\u01b0 vi\u00ean h\u00e0m ch\u1ee9c n\u0103ng \u0111\u1ed3 s\u1ed9 c\u1ee7a Excel, c\u00f3 th\u1ec3 n\u00f3i h\u00e0m Match l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u01b0u vi\u1ec7t nh\u1ea5t nh\u01b0ng l\u1ea1i \u00edt \u0111\u01b0\u1ee3c ch\u00fa \u00fd nh\u1ea5t. L\u00fd do ch\u00ednh khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng th\u1edd \u01a1 v\u1edbi n\u00f3 \u0111\u00f3 l\u00e0 vi\u1ec7c h\u1ecd kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh th\u1ef1c s\u1ef1 r\u00f5 r\u00e0ng m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 l\u00e0m g\u00ec. N\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t trong m\u1ed9t b\u1ed1i c\u1ea3nh c\u1ee5 th\u1ec3, b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 nh\u1eadn ra \u0111\u01b0\u1ee3c s\u1ef1 h\u1eefu \u00edch c\u0169ng nh\u01b0 t\u00ednh ti\u1ec7n l\u1ee3i c\u1ee7a n\u00f3.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\"><strong>h\u00e0m Match trong Excel<\/strong><\/a> sao cho hi\u1ec7u qu\u1ea3.<\/p>\n<p style=\"text-align: justify\">M\u1ee5c \u0111\u00edch ch\u00ednh khi s\u1eed d\u1ee5ng h\u00e0m Match l\u00e0 \u0111\u1ec3: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb b\u1ea5t k\u1ef3 trong t\u1eadp h\u1ee3p<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c h\u00e0m Match c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= MATCH (\u00a0<strong>gi\u00e1 tr\u1ecb c\u1ea7n tham chi\u1ebfu<\/strong>,\u00a0<strong>t\u1eadp h\u1ee3p c\u1ea7n tham chi\u1ebfu<\/strong>,\u00a0<strong>[\u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu]<\/strong>\u00a0)<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed ta c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 5 s\u1ed1 kh\u00e1c nhau nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y v\u00e0 nhi\u1ec7m v\u1ee5 l\u00e0 ph\u1ea3i t\u00ecm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 25 trong t\u1eadp h\u1ee3p n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/how-to-use-match-01.html\" alt=\"How to Use MATCH 01\" title=\"how-to-use-match-01\"><\/p>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match, ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 th\u00f4ng qua vi\u1ec7c x\u00e1c \u0111inhk c\u00e1c y\u1ebfu t\u1ed1 th\u00e0nh ph\u1ea7n sau \u0111\u00e2y:<\/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-130.gif\" title=\"ex101_92019-nho-130\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>Gi\u00e1 tr\u1ecb c\u1ea7n tham chi\u1ebfu<\/strong>: 25<\/p>\n<p style=\"text-align: justify\"><strong>T\u1eadp h\u1ee3p c\u1ea7n tham chi\u1ebfu<\/strong>: (ghi r\u00f5 b\u1ea3ng d\u1eef li\u1ec7u ph\u00eda tr\u00ean)<\/p>\n<p style=\"text-align: justify\"><strong>Match Type<\/strong>: 0 (c\u00f3 ngh\u0129a l\u00e0 ta y\u00eau c\u1ea7u Excel ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e9p t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u0111\u1ed1i chi\u1ebfu ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i c\u1ee7a s\u1ed1 25, ch\u1ee9 kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/how-to-use-match-02.html\" alt=\"How to Use MATCH 02\" title=\"how-to-use-match-02\"><\/p>\n<p style=\"text-align: justify\">D\u1ef1a tr\u00ean c\u00e1c th\u00f4ng s\u1ed1 tr\u00ean, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0\u00a0<strong>3<\/strong>, do s\u1ed1 25 n\u1eb1m \u1edf \u00f4 s\u1ed1 3 trong d\u00e3y c\u00e1c s\u1ed1.\u00a0 (C\u00f4ng th\u1ee9c h\u00e0m tr\u00ean c\u00f3 th\u1ec3 t\u1ef1 suy lu\u1eadn ra v\u1ecb tr\u00ed c\u1ee7a c\u00e1c \u00f4 s\u1ed1, v\u00ec th\u1ec3 b\u1ea1n kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 t\u1eeb 1 \u0111\u1ebfn 5)<\/p>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 th\u1ea5y c\u01a1 ch\u1ebf ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m Match kh\u00e1 \u0111\u01a1n gi\u1ea3n. Tuy v\u1eady, c\u00e2u h\u1ecfi \u0111\u1eb3t ra l\u00e0 li\u1ec7u \u0111\u00e2y c\u00f3 ph\u1ea3i l\u00e0 c\u00e1ch \u00e1p d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m n\u00e0y hay kh\u00f4ng. Li\u1ec7u b\u1ea1n c\u00f3 th\u01b0\u1eddng xuy\u00ean t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb b\u1ea5t k\u1ef3 trong t\u1eadp h\u1ee3p hay kh\u00f4ng? C\u00f3 l\u1ebd hi\u1ebfm khi khi t\u00e1c v\u1ee5 n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u0111\u1ebfn.<\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 3 v\u00ed d\u1ee5 ti\u00eau bi\u1ec3u cho th\u1ea5y c\u00e1ch s\u1eed d\u1ee5ng h\u1ee3p l\u00fd nh\u1ea5t c\u1ee7a h\u00e0m Match. \u0110\u1eb7t trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 ta m\u1edbi th\u1ea5y \u0111\u01b0\u1ee3c c\u00f4ng d\u1ee5ng th\u1ef1c s\u1ef1 c\u1ee7a h\u00e0m ch\u1ee9c n\u0103ng n\u00e0y.<\/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-677e059cacee0\" 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\/cach-su-dung-ham-match-trong-excel.html#Cong_thuc_hon_hop\" title=\"C\u00f4ng th\u1ee9c h\u1ed7n h\u1ee3p\">C\u00f4ng th\u1ee9c h\u1ed7n h\u1ee3p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-match-trong-excel.html#Kiem_tra_xem_gia_tri_co_ton_tai_trong_du_lieu_goc_hay_khong\" title=\"Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb c\u00f3 t\u1ed3n t\u1ea1i trong d\u1eef li\u1ec7u g\u1ed1c hay kh\u00f4ng\">Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb c\u00f3 t\u1ed3n t\u1ea1i trong d\u1eef li\u1ec7u g\u1ed1c hay kh\u00f4ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-match-trong-excel.html#Giai_phap_khac_thay_the_cho_ham_IF_long_nhau\" title=\"Gi\u1ea3i ph\u00e1p kh\u00e1c thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau\">Gi\u1ea3i ph\u00e1p kh\u00e1c thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_hon_hop\"><\/span>C\u00f4ng th\u1ee9c h\u1ed7n h\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Hi\u1ec7n t\u1ea1i m\u1ed9t trong nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match hi\u1ec7u qu\u1ea3 nh\u1ea5t l\u00e0 th\u00f4ng qua c\u00f4ng th\u1ee9c h\u1ed7n h\u1ee3p.\u00a0 T\u1ee9c l\u00e0 ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Match \u0111i k\u00e8m v\u1edbi c\u00e1c h\u00e0m c\u01a1 b\u1ea3n kh\u00e1c trong Excel.\u00a0 \u0110\u1ed1i v\u1edbi c\u00e1c d\u1ea1ng c\u00f4ng th\u1ee9c tham chi\u1ebfu h\u1ed7n h\u1ee3p, b\u1ea1n ph\u1ea3i lu\u00f4n \u0111\u1ec3 \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i \u1edf trong ph\u1ea7n match_type c\u1ee7a h\u00e0m Match.<\/p>\n<p style=\"text-align: justify\">Khi k\u1ebft h\u1ee3p h\u00e0m Match v\u1edbi c\u00f4ng th\u1ee9c tham chi\u1ebfu, vi\u1ec7c tham chi\u1ebfu tr\u1edf n\u00ean thu\u1eadn ti\u1ec7n h\u01a1n. Ch\u1eb3ng h\u1ea1n, khi b\u1ea1n k\u1ebft h\u1ee3p h\u00e0m Match v\u00e0 h\u00e0m Vlookup, l\u00fac n\u00e0y h\u00e0m Match s\u1ebd thay th\u1ebf y\u1ebfu t\u1ed1 \u0111i\u1ec1u ki\u1ec7n column_reference (s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t c\u1ea7n tham chi\u1ebfu) trong h\u00e0m Vlookup. Thay v\u00ec ph\u1ea3i \u0111i\u1ec1n m\u1ee5c n\u00e0y b\u1eb1ng 1 k\u00fd t\u1ef1 s\u1ed1 nh\u1ea5t \u0111\u1ecbnh, nh\u01b0 s\u1ed1 3 ch\u1eb3ng h\u1ea1n, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf b\u1eb1ng h\u00e0m Match \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c t\u00ean c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu b\u1eb1ng h\u00e0m Vlookup, ch\u1ec9 d\u1ef1a v\u00e0o t\u00ean g\u1ecdi c\u1ee7a c\u1ed9t thay v\u00ec s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/how-to-use-match-03.html\" alt=\"How to Use MATCH 03\" title=\"how-to-use-match-03\"><\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m Match c\u00f2n gi\u00fap b\u1ea1n tr\u00e1nh kh\u1ecfi l\u1ed7i ch\u00e8n c\u1ed9t trong qu\u00e1 tr\u00ecnh tham chi\u1ebfu, n\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n ch\u00e8n 1 c\u1ed9t b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m Match hi\u1ec7u qu\u1ea3 nh\u1ea5t ch\u00ednh l\u00e0 th\u00f4ng qua h\u00e0m Index Match. Ph\u1ea7n nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng \u0111\u1ec1u \u0111\u00e3 quen s\u1eed d\u1ee5ng h\u00e0m n\u00e0y m\u00e0 kh\u00f4ng h\u1ec1 bi\u1ebft c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m Match l\u00e0 nh\u01b0 th\u1ebf n\u00e0o, h\u1ecd \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 ghi nh\u1edb c\u1ea5u tr\u00fac c\u00fa ph\u00e1p c\u1ee7a h\u00e0m m\u00e0 th\u00f4i. K\u1ec3 c\u1ea3 nh\u01b0 v\u1eady th\u00ec \u0111i\u1ec1u \u0111\u00f3 c\u0169ng cho th\u1ea5y c\u00f4ng d\u1ee5ng r\u1ea5t l\u1edbn c\u1ee7a h\u00e0m Match trong vi\u1ec7c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m tham chi\u1ebfu h\u1ed7n h\u1ee3p kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c c\u00f4ng th\u1ee9c tham chi\u1ebfu hay s\u1eed d\u1ee5ng nh\u1ea5t m\u00e0 c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a h\u00e0m Match. Danh s\u00e1ch bao g\u1ed3m c\u1ea3 h\u00e0m tham chi\u1ebfu theo chi\u1ec1u d\u1ecdc, tham chi\u1ebfu theo chi\u1ec1u ngang, (INDEX MATCH c\u00f3 th\u1ec3 tham chi\u1ebfu theo chi\u1ec1u ngang) v\u00e0 c\u1ea3 c\u00e1c h\u00e0m tham chi\u1ebfu theo d\u1ea1ng ma tr\u1eadn 2 chi\u1ec1u.<\/p>\n<ul style=\"text-align: justify\">\n<li><a href=\"http:\/\/www.randomwok.com\/excel\/how-to-use-index-match\/\">INDEX MATCH<\/a><\/li>\n<li><a href=\"http:\/\/www.mbaexcel.com\/excel\/how-to-use-vlookup-match\/\">VLOOKUP MATCH<\/a><\/li>\n<li><a href=\"http:\/\/www.mbaexcel.com\/excel\/how-to-use-index-match-match\/\">INDEX MATCH MATCH<\/a><\/li>\n<li><a href=\"http:\/\/www.mbaexcel.com\/excel\/how-to-use-offset-match-match\/\">OFFSET MATCH MATCH<\/a><\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Kiem_tra_xem_gia_tri_co_ton_tai_trong_du_lieu_goc_hay_khong\"><\/span>Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb c\u00f3 t\u1ed3n t\u1ea1i trong d\u1eef li\u1ec7u g\u1ed1c hay kh\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u1eadn d\u1ee5ng \u0111i\u1ec3m m\u1ea1nh c\u1ee7a h\u00e0m Match \u0111\u00f3 l\u00e0 vi\u1ec7c ki\u1ec3m tra xem li\u1ec7u c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 t\u1ed3n t\u1ea1i hay kh\u00f4ng. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i trong ph\u1ea7n match_type c\u1ee7a h\u00e0m.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, ta c\u00f3 5 gi\u00e1 tr\u1ecb tham chi\u1ebfu c\u1ea7n ki\u1ec3m tra xem c\u00f3 thu\u1ed9c t\u1eadp h\u1ee3p d\u1eef li\u1ec7u g\u1ed1c hay kh\u00f4ng. C\u00f4ng vi\u1ec7c \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Match cho t\u1eebng gi\u00e1 tr\u1ecb m\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><strong>Gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/strong>: (l\u1ef1a ch\u1ecdn gi\u00e1 tr\u1ecb tham chi\u1ebfu mong mu\u1ed1n)<\/p>\n<p style=\"text-align: justify\"><strong>T\u1eadp h\u1ee3p tham chi\u1ebfu<\/strong>: (l\u1ef1a ch\u1ecdn b\u1ea3ng t\u1eadp h\u1ee3p s\u1ed1 li\u1ec7u)<\/p>\n<p style=\"text-align: justify\"><strong>\u0110i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu<\/strong>: 0 (t\u1ee9c l\u00e0 quy \u0111\u1ecbnh Excel ch\u1ec9 \u0111\u01b0\u1ee3c tham chi\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/how-to-use-match-04.html\" alt=\"How to Use MATCH 04\" title=\"how-to-use-match-04\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 1 s\u1ed1 th\u1ee9 t\u1ef1 b\u1ea5t k\u1ef3 th\u00ec \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n quan t\u00e2m c\u00f3 t\u1ed3n t\u1ea1i trong t\u1eadp h\u1ee3p d\u1eef li\u1ec7u g\u1ed1c. N\u1ebfu nh\u01b0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i th\u00ec t\u1ee9c l\u00e0 kh\u00f4ng t\u1ed3n t\u1ea1i gi\u00e1 tr\u1ecb n\u00f3i tr\u00ean.<\/p>\n<p style=\"text-align: justify\">V\u1ec1 m\u1eb7t c\u1ea3m quan m\u00e0 n\u00f3i th\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng d\u1ee5ng t\u1ed1t nh\u1ea5t c\u1ee7a h\u00e0m Match. N\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 \u0111\u01a1n gi\u1ea3n t\u1ed3n t\u1ea1i trong t\u1eadp h\u1ee3p d\u1eef li\u1ec7u \u0111\u00e3 cho th\u00ec l\u1ebd d\u0129 nhi\u00ean h\u00e0m Match ph\u1ea3i c\u00f3 ngh\u0129a. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 ki\u1ec3m tra gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ef1c quan v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c t\u1ebf ta c\u00f2n c\u00e1c c\u00e1ch kh\u00e1c \u0111\u1ec3 x\u00e1c minh s\u1ef1 t\u1ed3n t\u1ea1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl+F \u0111\u1ec3 kh\u1edfi \u0111\u1ed9ng ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm trong Excel. Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ph\u00e2n lo\u1ea1i v\u00e0 l\u1ecdc d\u1eef li\u1ec7u \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. Tuy v\u1eady, gi\u1ea3i ph\u00e1p nhanh nh\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t c\u00f3 l\u1ebd l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 ki\u1ec3m tra, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi c\u00f3 nhi\u1ec1u h\u01a1n 1 gi\u00e1 tr\u1ecb c\u1ea7n x\u00e1c minh, nh\u01b0 v\u00ed d\u1ee5 ph\u00eda tr\u00ean. Ch\u1ec9 c\u1ea7n vi\u1ebft c\u00f4ng th\u1ee9c 1 l\u1ea7n, tham chi\u1ebfu \u0111\u1ea7y \u0111\u1ee7 v\u00e0 sao ch\u00e9p xu\u1ed1ng c\u00e1c d\u00f2ng k\u1ebf ti\u1ebfp l\u00e0 xong.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Giai_phap_khac_thay_the_cho_ham_IF_long_nhau\"><\/span>Gi\u1ea3i ph\u00e1p kh\u00e1c thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong c\u1ea3 hai v\u00ed d\u1ee5 tr\u00ean c\u1ee7a h\u00e0m IF, ta \u0111\u1ec1u s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i. Ph\u1ea7n l\u1edbn khi s\u1eed d\u1ee5ng h\u00e0m Match ph\u1ea3i \u0111\u1ebfn 95% ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 l\u1ef1a ch\u1ecdn t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c m\u00e0 th\u00f4i. Tuy v\u1eady, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu \u0111\u00f3 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u0111\u1ed1i. M\u1ed9t trong s\u1ed1 \u0111\u00f3 l\u00e0 vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 tr\u00e1nh ph\u1ea3i vi\u1ebft c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau th\u01b0\u1eddng c\u00f3 b\u1ed1 c\u1ee5c kh\u00e1 ph\u1ee9c t\u1ea1p. \u0110\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu m\u00e0 b\u1ea1n n\u00ean bi\u1ebft:<\/p>\n<table style=\"width: 748px\">\n<thead>\n<tr>\n<td style=\"width: 136.023px;text-align: center\"><strong>Lo\u1ea1i \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed1i chi\u1ebfu<\/strong><\/td>\n<td style=\"width: 445.114px;text-align: center\"><strong>T\u00e1c v\u1ee5 c\u1ee7a Excel<\/strong><\/td>\n<td style=\"width: 145.114px;text-align: center\"><strong>\u0110i\u1ec1u ki\u1ec7n ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u trong t\u1eadp h\u1ee3p<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 136.023px;text-align: center\">\u201c1\u201d ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng<\/td>\n<td style=\"width: 445.114px;text-align: center\">T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong t\u1eadp h\u1ee3p tham chi\u1ebfu c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/td>\n<td style=\"width: 145.114px;text-align: center\">Theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 136.023px;text-align: center\">\u201c0\u201d<\/td>\n<td style=\"width: 445.114px;text-align: center\">T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n trong t\u1eadp h\u1ee3p tham chi\u1ebfu c\u00f3 gi\u00e1 tr\u1ecb ch\u00ednh b\u1eb1ng gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/td>\n<td style=\"width: 145.114px;text-align: center\">Kh\u00f4ng c\u00f3<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 136.023px;text-align: center\">\u201c-1\u201d<\/td>\n<td style=\"width: 445.114px;text-align: center\">T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong t\u1eadp h\u1ee3p tham chi\u1ebfu c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/td>\n<td style=\"width: 145.114px;text-align: center\">Theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 cho th\u1ea5y \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu quy \u0111\u1ecbnh r\u00f5 r\u1eb1ng Excel ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i. V\u00ed d\u1ee5 nh\u1eefng t\u1eeb kh\u00f3a \u0111\u01b0\u1ee3c b\u00f4i \u0111en d\u01b0\u1edbi \u0111\u00e2y s\u1ebd th\u1ec3 hi\u1ec7n t\u00ednh t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm:<\/p>\n<p style=\"text-align: justify\">T\u00ecm <strong>gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/strong>\u00a0trong\u00a0<strong>t\u1eadp h\u1ee3p<\/strong>\u00a0c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng\u00a0<strong>gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/strong>.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed ta g\u00e1n 1 gi\u00e1 tr\u1ecb tham chi\u1ebfu v\u00e0o t\u1eadp h\u1ee3p c\u00e1c bin c\u1ee7a bi\u1ec3u \u0111\u1ed3 t\u1ea7n su\u1ea5t histogram (m\u1eb7c \u0111\u1ecbnh t\u1eadp h\u1ee3p tham chi\u1ebfu l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong s\u1ed1 c\u00e1c bin c\u1ee7a bi\u1ec3u \u0111\u1ed3 t\u1ea7n su\u1ea5t), khi \u0111\u00f3 ta n\u00ean s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i.\u00a0 D\u01b0\u1edbi \u0111\u00e2y ta c\u00f3 v\u00ed d\u1ee5 g\u00e1n gi\u00e1 tr\u1ecb s\u1ed1 36 to v\u00e0o t\u1eadp h\u1ee3p c\u00e1c bin c\u1ee7a bi\u1ec3u \u0111\u1ed3 t\u1ea7n su\u1ea5t histogram.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/how-to-use-match-06.html\" alt=\"How to Use MATCH 06\" title=\"how-to-use-match-06\"><\/p>\n<p style=\"text-align: justify\">L\u00fd do v\u00ec sao h\u00e0m Match l\u1ea1i t\u1ecf ra v\u01b0\u1ee3t tr\u1ed9i h\u01a1n h\u00e0m If l\u1ed3ng nhau l\u00e0 b\u1edfi:<\/p>\n<ul>\n<li style=\"text-align: justify\">C\u00f3 \u0111\u1ed9 d\u00e0i ng\u1eafn h\u01a1n v\u00e0 \u0111\u01a1n gi\u1ea3n h\u01a1n h\u00e0m If l\u1ed3ng<\/li>\n<li style=\"text-align: justify\">D\u1ec5 ki\u1ec3m tra v\u00e0 so\u00e1t l\u1ed7i h\u01a1n<\/li>\n<li style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m Match gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho quy m\u00f4 d\u1eef li\u1ec7u l\u1edbn h\u01a1n; ch\u1eb3ng h\u1ea1n n\u1ebfu b\u1ea1n mu\u1ed1n t\u0103ng s\u1ed1 l\u01b0\u1ee3ng bin trong bi\u1ec3u \u0111\u1ed3 histogram, c\u1ea5u tr\u00fac c\u1ee7a c\u00f4ng th\u1ee9c c\u0169ng kh\u00f4ng b\u1ecb k\u00e9o d\u00e0i h\u01a1n.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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-130.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10080,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10079","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\/10079","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=10079"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10080"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}