{"id":10684,"date":"2025-01-14T23:09:25","date_gmt":"2025-01-14T23:09:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-su-dung-ham-vlookup-match\/"},"modified":"2025-01-14T23:09:25","modified_gmt":"2025-01-14T23:09:25","slug":"cach-su-dung-ham-vlookup-match","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-su-dung-ham-vlookup-match\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Match"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP MATCH.<\/p>\n<p style=\"text-align: justify\">VLOOKUP MATCH l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c tra c\u1ee9u kh\u1ea3 d\u1ee5ng trong Microsoft Excel. B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd gi\u1ea3 \u0111\u1ecbnh b\u1ea1n \u0111\u00e3 c\u00f3 s\u1ef1 hi\u1ec3u bi\u1ebft nh\u1ea5t \u0111\u1ecbnh v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12260 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/400.png\" width=\"501\" height=\"358\" title=\"400\"><\/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-6786eea4dfd3a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-match.html#Muc_tieu\" title=\"M\u1ee5c ti\u00eau\">M\u1ee5c ti\u00eau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-match.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-match.html#Ket_hop_chung_voi_nhau\" title=\"K\u1ebft h\u1ee3p ch\u00fang v\u1edbi nhau\">K\u1ebft h\u1ee3p ch\u00fang v\u1edbi nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-vlookup-match.html#Cach_no_van_hanh\" title=\"C\u00e1ch n\u00f3 v\u1eadn h\u00e0nh\">C\u00e1ch n\u00f3 v\u1eadn h\u00e0nh<\/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\/cach-su-dung-ham-vlookup-match.html#Nhuoc_diem\" title=\"Nh\u01b0\u1ee3c \u0111i\u1ec3m\">Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Muc_tieu\"><\/span>M\u1ee5c ti\u00eau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m VLOOKUP MATCH l\u00e0 m\u1ed9t bi\u1ebfn th\u1ec3 \u0111\u01b0\u1ee3c c\u1ea3i thi\u1ec7n c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP c\u01a1 b\u1ea3n ho\u1eb7c c\u1ee7a h\u00e0m INDEX MATCH. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m VLOOKUP MATCH cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n t\u00ednh n\u0103ng tra c\u1ee9u ma tr\u1eadn \u2013 thay v\u00ec ch\u1ec9 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb theo chi\u1ec1u d\u1ecdc, ph\u1ea7n MATCH c\u1ee7a c\u00f4ng th\u1ee9c s\u1ebd linh ho\u1ea1t chuy\u1ec3n tham chi\u1ebfu c\u1ed9t c\u1ee7a b\u1ea1n th\u00e0nh tra c\u1ee9u ngang. H\u00e0m VLOOKUP MATCH \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch cho c\u00e1c t\u00ecnh hu\u1ed1ng m\u00e0 b\u1ea1n ph\u1ea3i ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u nhi\u1ec1u sau khi b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t vi\u1ec7c l\u1eadp c\u00f4ng th\u1ee9c. \u0110i\u1ec1u n\u00e0y l\u00e0 do h\u00e0m VLOOKUP MATCH cho ph\u00e9p kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u00e8n c\u00f4ng th\u1ee9c tra c\u1ee9u; b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n ch\u00e8n ho\u1eb7c x\u00f3a m\u1ed9t c\u1ed9t trong m\u1ea3ng tra c\u1ee9u, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd v\u1eabn cho k\u1ebft qu\u1ea3 \u0111\u00fang. H\u00e0m VLOOKUP MATCH th\u1ef1c s\u1ef1 r\u1ea5t gi\u1ed1ng v\u1edbi h\u00e0m VLOOKUP HLOOKUP, nh\u01b0ng n\u00f3 t\u1ed1t h\u01a1n m\u1ed9t ch\u00fat v\u00ec n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u t\u1ea1o ra m\u1ed9t h\u00e0ng b\u1ed5 sung \u0111\u1ec3 ghi s\u1ed1 c\u1ed9t.<\/p>\n<p style=\"text-align: justify\">S\u1ef1 kh\u00e1c bi\u1ec7t ch\u00ednh gi\u1eefa vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m VLOOKUP MATCH so v\u1edbi c\u00f4ng th\u1ee9c VLOOKUP c\u01a1 b\u1ea3n l\u00e0, ngo\u00e0i gi\u00e1 tr\u1ecb tra c\u1ee9u d\u1ecdc c\u1ee7a b\u1ea1n (gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n t\u00ecm t\u1eeb tr\u00ean xu\u1ed1ng b\u00ean tr\u00e1i b\u1ea3ng), b\u1ea1n c\u0169ng s\u1ebd c\u00f3 m\u1ed9t <strong>gi\u00e1 tr\u1ecb tra c\u1ee9u c\u1ed9t<\/strong> (gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n t\u00ecm khi \u00a0xem qua h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t).<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m VLOOKUP v\u00e0 h\u00e0m MATCH l\u00e0 hai c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p \u0111\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u n\u00e0y. Ch\u00fang ta s\u1ebd xem x\u00e9t t\u1eebng c\u00f4ng th\u1ee9c ri\u00eang bi\u1ec7t tr\u01b0\u1edbc khi k\u1ebft h\u1ee3p ch\u00fang v\u1edbi nhau. C\u00f4ng th\u1ee9c ch\u00ednh ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng l\u00e0 h\u00e0m VLOOKUP:<\/p>\n<blockquote>\n<p style=\"text-align: justify\">=VLOOKUP (\u00a0<strong>lookup value\u00a0<\/strong>,\u00a0<strong>table_array\u00a0<\/strong>,\u00a0<strong>col_index_num\u00a0<\/strong>,\u00a0<strong>[range_lookup]\u00a0<\/strong>)<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t <strong>gi\u00e1 tr\u1ecb tra c\u1ee9u<\/strong> v\u00e0 m\u1ed9t <strong>m\u1ea3ng b\u1ea3ng.<\/strong> (Ch\u00fang ta s\u1ebd ch\u1ec9 ra <strong>s\u1ed1 ch\u1ec9 c\u1ed9t<\/strong> sau v\u00e0 v\u00ec ch\u00fang ta kh\u00f4ng th\u1ef1c hi\u1ec7n tra c\u1ee9u ph\u1ea1m vi, ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1ec3 tr\u1ed1ng \u0111o\u1ea1n \u0111\u00f3) Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, gi\u00e1 tr\u1ecb tra c\u1ee9u l\u00e0 <strong>ID<\/strong> s\u1ed1 \u201c5\u201d v\u00e0 m\u1ea3ng c\u1ee7a b\u1ea3ng l\u00e0 \u00a0\u0111\u01b0\u1eddng vi\u1ec1n m\u00e0u xanh l\u00e1 bao quanh c\u00e1c \u00f4 B6: F14.<\/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-10.gif\" title=\"vba101_92019-nho-10\"><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-210.gif\" title=\"ex101_92019-nho-210\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12262 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/401.png\" width=\"590\" height=\"380\" title=\"401\"><\/p>\n<p style=\"text-align: justify\">Ti\u1ebfp theo ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c MATCH:<\/p>\n<blockquote>\n<p style=\"text-align: justify\">=MATCH (\u00a0<strong>lookup value\u00a0<\/strong>,\u00a0<strong>lookup_array\u00a0<\/strong>,\u00a0<strong>[match _type]\u00a0<\/strong>)<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c match tr\u1ea3 v\u1ec1 s\u1ed1 ch\u1ec9 v\u1ecb tr\u00ed d\u1ef1a tr\u00ean v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb tra c\u1ee9u trong m\u1ea3ng m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn. \u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n c\u1ea3 <strong>gi\u00e1 tr\u1ecb tra c\u1ee9u<\/strong> v\u00e0 <strong>m\u1ea3ng tra c\u1ee9u<\/strong>. (Tham s\u1ed1 lo\u1ea1i match n\u00ean \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng \u2013 l\u00e0m nh\u01b0 v\u1eady l\u00e0 \u0111\u1ec3 n\u00f3i v\u1edbi Excel r\u1eb1ng ch\u00fang t\u00f4i mu\u1ed1n c\u00f3 m\u1ed9t k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c). Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, gi\u00e1 tr\u1ecb tra c\u1ee9u ch\u00fang ta l\u00e0 <strong>Ti\u1ec3u bang<\/strong> \u201cWA\u201d v\u00e0 m\u1ea3ng tra c\u1ee9u l\u00e0 khung m\u00e0u cam bao quanh c\u00e1c \u00f4 B6: F6.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12263 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/403.png\" width=\"590\" height=\"380\" title=\"403\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_hop_chung_voi_nhau\"><\/span>K\u1ebft h\u1ee3p ch\u00fang v\u1edbi nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110i\u1ec3m m\u1ea5u ch\u1ed1t c\u1ee7a h\u00e0m VLOOKUP MATCH l\u00e0 ch\u00fang ta \u0111ang thay th\u1ebf c\u00fa ph\u00e1p \u201cs\u1ed1 ch\u1ec9 c\u1ed9t\u201d c\u1ee7a h\u00e0m VLOOKUP b\u1eb1ng c\u00f4ng th\u1ee9c MATCH. Th\u1ef1c hi\u1ec7n s\u1ef1 k\u1ebft h\u1ee3p n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\"><span style=\"text-decoration: underline\"><strong> B\u01b0\u1edbc 1:<\/strong><\/span> B\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch nh\u1eadp c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n nh\u01b0 b\u00ecnh th\u01b0\u1eddng, nh\u1eadp <strong>gi\u00e1 tr\u1ecb tra c\u1ee9u<\/strong> ph\u00f9 h\u1ee3p v\u00e0 <strong>m\u1ea3ng b\u1ea3ng<\/strong> cho tra c\u1ee9u c\u1ee7a b\u1ea1n; trong v\u00ed d\u1ee5 n\u00e0y gi\u00e1 tr\u1ecb tra c\u1ee9u l\u00e0 <strong>ID<\/strong> s\u1ed1 \u201c5\u201d v\u00e0 m\u1ea3ng b\u1ea3ng l\u00e0 khung m\u00e0u xanh l\u00e1 c\u00e2y bao quanh c\u00e1c \u00f4 B6: F14.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12264 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/404.png\" width=\"590\" height=\"380\" title=\"404\"><\/p>\n<p style=\"text-align: justify\"><span style=\"text-decoration: underline\"><strong>B\u01b0\u1edbc 2:<\/strong> <\/span>Khi b\u1ea1n nh\u1eadp <strong>s\u1ed1 ch\u1ec9 c\u1ed9t<\/strong>, thay v\u00ec nh\u1eadp m\u1ed9t s\u1ed1 c\u1ed1 \u0111\u1ecbnh , h\u00e3y b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c MATCH<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12265 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/405.png\" width=\"590\" height=\"380\" title=\"405\"><\/p>\n<p style=\"text-align: justify\"><span style=\"text-decoration: underline\"><strong>B\u01b0\u1edbc 3:<\/strong> <\/span>\u0110\u1ed1i v\u1edbi <strong>gi\u00e1 tr\u1ecb tra c\u1ee9u<\/strong> c\u1ee7a c\u00f4ng th\u1ee9c MATCH, h\u00e3y ch\u1ecdn \u00f4 ch\u1ee9a t\u00ean c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1; trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta mu\u1ed1n tr\u1ea3 v\u1ec1 m\u1ed9t <strong>Ti\u1ec3u bang<\/strong>, v\u00ec v\u1eady ch\u00fang ta h\u00e3y nh\u1ea5p v\u00e0o n\u00f3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12266 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/406.png\" width=\"590\" height=\"380\" title=\"406\"><\/p>\n<p style=\"text-align: justify\"><strong><span style=\"text-decoration: underline\">B\u01b0\u1edbc 4:<\/span><\/strong> \u0110\u1ed1i v\u1edbi <strong>m\u1ea3ng t\u00ecm ki\u1ebfm<\/strong> c\u1ee7a h\u00e0m MATCH, h\u00e3y ch\u1ecdn ti\u00eau \u0111\u1ec1 h\u00e0ng cho m\u1ea3ng b\u1ea3ng c\u1ee7a b\u1ea1n; trong v\u00ed d\u1ee5 n\u00e0y n\u00f3 l\u00e0 khung m\u00e0u cam bao quanh c\u00e1c \u00f4 B6: F6.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12267 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/407.png\" width=\"590\" height=\"380\" title=\"407\"><\/p>\n<p style=\"text-align: justify\"><strong><span style=\"text-decoration: underline\">B\u01b0\u1edbc 5:<\/span><\/strong> \u0110\u00f3ng khung c\u1ea3 c\u00f4ng th\u1ee9c MATCH v\u00e0 c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n b\u1eb1ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n (l\u00e0m \u0111i\u1ec1u n\u00e0y \u0111\u01a1n gi\u1ea3n l\u00e0 \u0111\u1ec3 x\u00e1c nh\u1eadn v\u1edbi Excel r\u1eb1ng ch\u00fang ta mu\u1ed1n s\u1ef1 k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c MATCH v\u00e0 ch\u00fang ta kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng m\u1ed9t tra c\u1ee9u ph\u1ea1m vi cho h\u00e0m VLOOKUP)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12268 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/408.png\" width=\"590\" height=\"380\" title=\"408\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_no_van_hanh\"><\/span>C\u00e1ch n\u00f3 v\u1eadn h\u00e0nh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c MATCH ch\u00fang ta t\u1ea1o ra tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 4. Do \u0111\u00f3, d\u1ef1a tr\u00ean c\u00e1ch ch\u00fang ta s\u1eafp x\u1ebfp c\u00fa ph\u00e1p, v\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m VLOOKUP MATCH \u1edf tr\u1ea1ng th\u00e1i n\u00e0y th\u1ef1c hi\u1ec7n c\u00f9ng m\u1ed9t ch\u1ee9c n\u0103ng nh\u01b0 VLOOKUP v\u1edbi <strong>s\u1ed1 ch\u1ec9 c\u1ed9t<\/strong> l\u00e0 4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12269 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/409.png\" width=\"501\" height=\"358\" title=\"409\"><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, s\u1ef1 kh\u00e1c bi\u1ec7t ch\u00ednh l\u00e0 tham chi\u1ebfu c\u1ed9t n\u00e0y b\u00e2y gi\u1edd \u0111\u00e3 tr\u1edf n\u00ean linh ho\u1ea1t. N\u1ebfu t\u00f4i ch\u00e8n ho\u1eb7c x\u00f3a m\u1ed9t c\u1ed9t t\u1eeb b\u1ea3ng tra c\u1ee9u c\u1ee7a m\u00ecnh, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd v\u1eabn nh\u01b0 c\u0169. H\u00e3y nh\u00ecn xu\u1ed1ng \u0111\u00e2y \u0111\u1ec3 n\u1eafm r\u00f5 v\u00ed d\u1ee5 v\u1ec1 s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u00e1c gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 gi\u1eefa h\u00e0m VLOOKUP v\u00e0 h\u00e0m VLOOKUP MATCH sau khi ch\u00e8n m\u1ed9t c\u1ed9t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12270 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/410.png\" width=\"591\" height=\"389\" title=\"410\"><\/p>\n<p style=\"text-align: justify\">Sau khi ch\u00e8n, tham chi\u1ebfu c\u1ed9t c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP v\u1eabn l\u00e0 4 v\u00e0 hi\u1ec7n \u0111ang s\u1eed d\u1ee5ng ph\u1ea1m vi <strong>Th\u00e0nh ph\u1ed1<\/strong>. Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 c\u1ee7a b\u1ea1n \u0111\u00e3 thay \u0111\u1ed5i t\u1eeb \u201cWA\u201d th\u00e0nh \u201cSeattle\u201d. Tuy nhi\u00ean, v\u1edbi h\u00e0m VLOOKUP MATCH, v\u00ec b\u1ea1n \u0111\u00e3 ch\u1ec9 ra t\u00ean c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y k\u1ebft qu\u1ea3, vi\u1ec7c tham chi\u1ebfu c\u1ed9t s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 do \u0111\u00f3 b\u1ea1n duy tr\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 \u201cWA\u201d .<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhuoc_diem\"><\/span>Nh\u01b0\u1ee3c \u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong khi h\u00e0m VLOOKUP MATCH r\u00f5 r\u00e0ng l\u00e0 m\u1ed9t c\u1ea3i ti\u1ebfn so v\u1edbi h\u00e0m VLOOKUP c\u01a1 b\u1ea3n, nh\u01b0ng v\u1eabn c\u00f2n nh\u1eefng h\u1ea1n ch\u1ebf khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y. V\u1edbi h\u00e0m VLOOKUP MATCH, m\u1ecdi tra c\u1ee9u v\u1eabn ph\u1ea3i b\u1eaft \u0111\u1ea7u t\u1eeb tr\u00e1i sang ph\u1ea3i. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh v\u1ea5n \u0111\u1ec1 n\u1ebfu b\u1ea1n mu\u1ed1n b\u1ed5 sung c\u00e1c gi\u00e1 tr\u1ecb tra c\u1ee9u v\u00e0o b\u00ean ph\u1ea3i b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. Ngo\u00e0i ra, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 c\u1ee7a b\u1ea1n b\u1ecb gi\u1edbi h\u1ea1n trong m\u1ea3ng b\u1ea3ng m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn l\u00fac \u0111\u1ea7u. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam m\u1ed9t ho\u1eb7c hai c\u1ed9t \u1edf b\u00ean ph\u1ea3i b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 tra c\u1ee9u r\u1ed3i tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c c\u1ed9t n\u00e0y m\u00e0 kh\u00f4ng \u0111i\u1ec1u ch\u1ec9nh m\u1ea3ng b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c tra c\u1ee9u ma tr\u1eadn m\u00e0 kh\u00f4ng g\u1eb7p ph\u1ea3i nh\u1eefng h\u1ea1n ch\u1ebf c\u1ee5 th\u1ec3 n\u00e0y, h\u00e3y xem x\u00e9t vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH MATCH.<\/p>\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>\u00a0c\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. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/p>\n<p style=\"text-align: justify\">\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-10.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10684","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\/10684","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=10684"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10685"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}