{"id":5886,"date":"2024-12-21T11:12:16","date_gmt":"2024-12-21T11:12:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-cong-thuc-excel-thong-dung-trong-ke-toan-tien-luong-nhan-su-ham-index-match\/"},"modified":"2024-12-21T11:12:16","modified_gmt":"2024-12-21T11:12:16","slug":"ham-cong-thuc-excel-thong-dung-trong-ke-toan-tien-luong-nhan-su-ham-index-match","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-cong-thuc-excel-thong-dung-trong-ke-toan-tien-luong-nhan-su-ham-index-match\/","title":{"rendered":"H\u00e0m, c\u00f4ng th\u1ee9c excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: H\u00e0m Index, Match"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u1eefng h\u00e0m, c\u00f4ng th\u1ee9c Excel n\u00e0o th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1? N\u1ed9i dung n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p qua b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong.html\">H\u00e0m, c\u00f4ng th\u1ee9c\u00a0excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/a><\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u1ee5 th\u1ec3 c\u00e1ch\u00a0\u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m\u00a0\u0111\u00f3 v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p><strong>B\u00e0i 2: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index + match<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11393 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03.gif\" width=\"884\" height=\"299\" title=\"pic03\"><\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m<\/p>\n<p>=INDEX(v\u00f9ng_d\u1eef_li\u1ec7u, h\u00e0ng_th\u1ee9_m\u1ea5y, [c\u1ed9t_th\u1ee9_m\u1ea5y])<\/p>\n<ul>\n<li>v\u00f9ng_d\u1eef_li\u1ec7u\u00a0\u2013 l\u00e0 \u0111\u1ecba ch\u1ec9 v\u00f9ng d\u1eef li\u1ec7u ch\u00fang ta mu\u1ed1n \u201cnh\u1eb7t\u201d ra 1 gi\u00e1 tr\u1ecb,\u00a0\u1edf\u00a0\u0111\u00e2y n\u1ebfu mu\u1ed1n t\u00ecm n\u1ed9i dung Ng\u00e0y sinh th\u00ec ra\u00a0\u00e1p d\u1ee5ng cho v\u00f9ng t\u1eeb D1:D11<\/li>\n<li>h\u00e0ng_th\u1ee9_m\u1ea5y\u00a0\u2013 \u00f4 c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u n\u1eb1m \u1edf h\u00e0ng th\u1ee9 m\u1ea5y? =&gt; N\u1ed9i dung n\u00e0y s\u1ebd t\u00ecm th\u00f4ng qua h\u00e0m Match<\/li>\n<li>c\u1ed9t_th\u1ee9_m\u1ea5y\u00a0\u2013 \u00f4 c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u n\u1eb1m \u1edf c\u1ed9t th\u1ee9 m\u1ea5y? (v\u00ec gi\u00e1 tr\u1ecb V\u00f9ng_d\u1eef_li\u1ec7u ch\u1ec9 c\u00f3 1 c\u1ed9t n\u00ean ta c\u00f3 th\u1ec3 b\u1ecf qua n\u1ed9i dung n\u00e0y. N\u1ebfu c\u00f3 nhi\u1ec1u h\u01a1n 1 c\u1ed9t th\u00ec ta ch\u1ecdn c\u1ed9t c\u1ea7n cho ra k\u1ebft qu\u1ea3)<\/li>\n<\/ul>\n<blockquote>\n<p>Xewm th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">h\u1ecdc Excel k\u1ebf to\u00e1n \u01a1\u0309 Ha\u0300 N\u00f4\u0323i<\/a><\/p>\n<\/blockquote>\n<p>=MATCH(gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm, m\u1ea3ng_t\u00ecm_ki\u1ebfm, [ki\u1ec3u_t\u00ecm_ki\u1ebfm])<\/p>\n<ul>\n<li>gi\u00e1_tr\u1ecb_c\u1ea7n_t\u00ecm\u00a0\u2013\u00a0gi\u1ed1ng nh\u01b0 lookup_value c\u1ee7a h\u00e0m vlookup<\/li>\n<li>m\u1ea3ng_t\u00ecm_ki\u1ebfm\u00a0\u2013 m\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm,\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/li>\n<li>ki\u1ec3u_t\u00ecm_ki\u1ebfm\u00a0\u2013 s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb 0\u00a0\u0111\u1ec3 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. N\u1ebfu kh\u00f4ng nh\u1eadp gi\u00e1 tr\u1ecb n\u00e0y th\u00ec hi\u1ec3u m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 gi\u00e1 tr\u1ecb 0<\/li>\n<\/ul>\n<p>C\u00e1ch vi\u1ebft h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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\/2024\/12\/ex101_92019-nho-522.gif\" title=\"ex101_92019-nho-522\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/vba101_92019-nho-221.gif\" title=\"vba101_92019-nho-221\"><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\/2024\/12\/ex101_92019-nho-522.gif\" title=\"ex101_92019-nho-522\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ng\u00e0y sinh =INDEX($D$1:$D$11,MATCH($G8,$B$1:$B$11,0))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11400 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-hc3a0m-index-match.png\" width=\"939\" height=\"349\" title=\"pic01-hc3a0m-index-match\"><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1<\/p>\n<p>B\u1ed9 ph\u1eadn =INDEX($C$1:$C$11,MATCH($G8,$B$1:$B$11,0))<\/p>\n<p>L\u01b0\u01a1ng c\u01a1 b\u1ea3n =INDEX($E$1:$E$11,MATCH($G8,$B$1:$B$11,0))<\/p>\n<p>Trong c\u00e1c b\u00e0i h\u1ecdc sau, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 nh\u00e9.<\/p>\n<p>\u2014<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng\u00a0Excel trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1,\u00a0c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0tham gia kh\u00f3a h\u1ecdc<\/p>\n<p><a href=\"http:\/\/excel-ke-toan-tien-luong2.hocexcel.online\/\">TL01 \u2013\u00a0\u1ee9ng d\u1ee5ng\u00a0EXCEL VBA trong TI\u1ec0N L\u01af\u01a0NG \u2013 NH\u00c2N S\u1ef0<\/a><\/p>\n<p>kh\u00f3a h\u1ecdc s\u1ebd cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 trong th\u1ef1c t\u1ebf v\u00e0 c\u00e1c k\u1ef9 n\u0103ng\u00a0excel k\u1ebft h\u1ee3p v\u1edbi VBA\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c, t\u1ed1i\u00a0\u01b0u hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea1n.<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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\/2024\/12\/ex101_92019-nho-522.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5887,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5886","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5886","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=5886"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5886\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5887"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}