{"id":10923,"date":"2025-01-15T00:41:47","date_gmt":"2025-01-15T00:41:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-su-dung-ham-vlookup-trong-ke-toan-tien-luong-nhan-su\/"},"modified":"2025-01-15T00:41:47","modified_gmt":"2025-01-15T00:41:47","slug":"cach-su-dung-ham-vlookup-trong-ke-toan-tien-luong-nhan-su","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-su-dung-ham-vlookup-trong-ke-toan-tien-luong-nhan-su\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1"},"content":{"rendered":"
\n

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? Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u1edbi thi\u1ec7u v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n\u00a0h\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 Vlookup<\/strong><\/a> gi\u00fap cho vi\u1ec7c\u00a0h\u1ecdc Excel k\u1ebf to\u00e1n<\/a><\/strong> tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n m\u00e0 l\u1ea1i hi\u1ec7u qu\u1ea3.<\/em><\/p>\n

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.<\/em><\/p>\n

B\u00e0i 1: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/strong><\/p>\n

<\/p>\n

C\u1ea5u tr\u00fac h\u00e0m\u00a0VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/strong><\/p>\n

lookup_value<\/em><\/strong>: l\u00e0 ph\u1ea7n h\u1ecd t\u00ean c\u1ee7a\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n l\u1ea5y th\u00f4ng tin (\u00f4 G3)<\/p>\n

table_array<\/em><\/strong>: B\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n truy v\u1ea5n, trong b\u1ea3ng n\u00e0y c\u1ea7n l\u01b0u\u00a0\u00fd c\u1ed9t ch\u1ee9a lookup_value ph\u1ea3i l\u00e0 c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean ph\u00eda b\u00ean tr\u00e1i b\u1ea3ng.\u00a0\u1ede\u00a0\u0111\u00e2y b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 v\u00f9ng B2:E11, c\u00f3 c\u1ed9t B l\u00e0 c\u1ed9t h\u1ecd t\u00ean.<\/p>\n

col_index_num<\/em><\/strong>: th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t c\u1ea7n l\u1ea5y k\u1ebft qu\u1ea3. V\u1edbi k\u1ebft qu\u1ea3 c\u1ea7n l\u1ea5y l\u00e0 B\u1ed9 ph\u1eadn th\u00ec c\u1ed9t\u00a0\u0111\u00f3 l\u00e0 c\u1ed9t th\u1ee9 2 (so v\u1edbi c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t H\u1ecd t\u00ean). V\u1edbi k\u1ebft qu\u1ea3 c\u1ea7n l\u1ea5y l\u00e0 Ng\u00e0y sinh th\u00ec c\u1ed9t\u00a0\u0111\u00f3 l\u00e0 c\u1ed9t th\u1ee9 3.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

[range_lookup]<\/em><\/strong>:\u00a0\u0111\u1eb7t trong ngo\u1eb7c vu\u00f4ng t\u1ee9c l\u00e0 gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 trong c\u00f4ng th\u1ee9c. Range_lookup l\u00e0 c\u00e1ch th\u1ee9c t\u00ecm ki\u1ebfm, gi\u00e1 tr\u1ecb m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 0,\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo gi\u00e1 tr\u1ecb lookup_value<\/p>\n

\n

Xem th\u00eam: Kho\u0301a ho\u0323c excel online<\/a> gia\u0301 re\u0309 ta\u0323i Ha\u0300 N\u00f4\u0323i<\/p>\n<\/blockquote>\n

<\/p>\n

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

\u2014<\/p>\n

N\u1ebfu b\u1ea1n quan t\u00e2m t\u1edbi vi\u1ec7c\u00a0\u00e1p d\u1ee5ng\u00a0Excel v\u00e0 VBA v\u00e0o c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1, ha\u0303y \u0111\u00ea\u0301n v\u01a1\u0301i blog.hocexcel.online la\u0300 m\u00f4\u0323t trong nh\u01b0\u0303ng trung t\u00e2m\u00a0ho\u0323c excel c\u00e2\u0301p t\u00f4\u0301c<\/a>\u00a0s\u00f4\u0301 1 ta\u0323i Ha\u0300 N\u00f4\u0323i v\u01a1\u0301i ca\u0301c chuy\u00ean gia h\u01b0\u01a1\u0301ng d\u00e2\u0303n co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m se\u0303 giu\u0301p ba\u0323n hi\u00ea\u0309u va\u0300 s\u01b0\u0309 du\u0323ng excel m\u00f4\u0323t ca\u0301ch tha\u0300nh tha\u0323o.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10924,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10923","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\/10923","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=10923"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10923\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10924"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}