{"id":13087,"date":"2015-09-11T07:15:54","date_gmt":"2015-09-11T07:15:54","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13087"},"modified":"2015-09-12T04:15:16","modified_gmt":"2015-09-12T04:15:16","slug":"cach-su-dung-ham-vlookup-trong-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13087","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m VLOOKUP trong k\u1ebf to\u00e1n Excel"},"content":{"rendered":"

\"C\u00e1ch<\/span><\/h2>\n

H\u00e0m VLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm theo c\u1ed9t, s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 n\u1eb1m tr\u00ean m\u1ed9t c\u1ed9t n\u00e0o \u0111\u00f3 n\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n d\u00f2 t\u00ecm. K\u1ebf to\u00e1n Centax<\/a><\/strong> xin h\u01b0\u1edbng d\u1eabn b\u1ea1n \u0111\u1ecdc C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m VLOOKUP trong k\u1ebf to\u00e1n Excel.<\/span><\/p>\n

1. C\u00f4ng d\u1ee5ng h\u00e0m VLOOKUP<\/span><\/strong><\/span><\/p>\n

– T\u00ecm M\u00e3 h\u00e0ng h\u00f3a, t\u00ean h\u00e0ng h\u00f3a t\u1eeb Danh M\u1ee5c H\u00e0ng H\u00f3a v\u1ec1 B\u1ea3ng Nh\u1eadp Xu\u1ea5t T\u1ed3n <\/span>
\n – T\u00ecm M\u00e3 TK, T\u00ean TK t\u1eeb Danh M\u1ee5c T\u00e0i Kho\u1ea3n v\u1ec1 b\u1ea3ng C\u00e2n \u0110\u1ed1i Ph\u00e1t Sinh, v\u1ec1 s\u1ed5 131, 331\u2026<\/span>
\n -T\u00ecm \u0111\u01a1n gi\u00e1 Xu\u1ea5t kho t\u1eeb b\u00ean B\u1ea3ng Nh\u1eadp Xu\u1ea5t T\u1ed3n v\u1ec1 Phi\u1ebfu Xu\u1ea5t Kho<\/span>
\n – T\u00ecm s\u1ed1 d\u01b0 c\u1ee7a \u0111\u1ea7u th\u00e1ng N c\u0103n c\u1ee9 v\u00e0o c\u1ed9t s\u1ed1 d\u01b0 c\u1ee7a th\u00e1ng N-1<\/span>
\n – T\u00ecm s\u1ed1 kh\u1ea5u hao ph\u00e2n b\u1ed5 l\u0169y k\u1ebf k\u1ef3 tr\u01b0\u1edbc, c\u0103n c\u1ee9 v\u00e0o Gi\u00e1 tr\u1ecb kh\u1ea5u hao ph\u00e2n b\u1ed5 l\u0169y k\u1ebf c\u1ee7a b\u1ea3ng 142, 242, 214.<\/span>
\n – V\u00e0 c\u00e1c b\u1ea3ng kh\u00e1c li\u00ean quan\u2026<\/span><\/p>\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP:<\/span><\/strong><\/span><\/h2>\n

\"C\u00e1ch<\/p>\n

Gi\u1ea3i th\u00edch:<\/strong><\/span><\/p>\n

– Gi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ecm ki\u1ebfm:<\/em> Gi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ecm ki\u1ebfm ch\u1ec9 l\u00e0 m\u1ed9t \u00d4 v\u00e0 ph\u1ea3i c\u00f3 T\u00ean trong V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm (L\u00e0 \u00d4 m\u00e3 h\u00e0ng h\u00f3a, M\u00e3 t\u00e0i kho\u1ea3n, M\u00e3 t\u00e0i s\u1ea3n, M\u00e3 c\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5\u2026)<\/span>
\n – V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm:<\/em> \u201cV\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm\u201d ph\u1ea3i ch\u1ee9a t\u00ean c\u1ee7a \u201cGi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ecm ki\u1ebfm\u201d. (C\u1ee5 th\u1ec3 l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a th\u00e1ng tr\u01b0\u1edbc ho\u1eb7c d\u1eef li\u1ec7u c\u1ee7a Sheet kh\u00e1c)<\/span>
\n – C\u1ed9t tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm:<\/em> L\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t, t\u00ednh t\u1eeb b\u00ean tr\u00e1i sang c\u1ee7a \u201cv\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm\u201d<\/span>
\n – Tham s\u1ed1 \u201c0\u201d<\/em>: l\u00e0 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c.<\/span><\/p>\n

\u00a0<\/strong><\/span>S\u1eed d\u1ee5ng F4 c\u00f3 \u00fd ngh\u0129a:<\/strong><\/span><\/p>\n

– F4 (1 l\u1ea7n): \u0111\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i. Tuy\u1ec7t \u0111\u1ed1i \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u00a0\u21d2 \u00a0$c\u1ed9t$d\u00f2ng<\/span>
\n V\u00ed d\u1ee5: $B$9 \u21d2\u00a0c\u1ed1 \u0111\u1ecbnh c\u1ed9t B v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng 9<\/span><\/p>\n

-F4 (2 l\u1ea7n): \u0111\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i c\u1ed9t v\u00e0 tuy\u1ec7t \u0111\u1ed1i d\u00f2ng – \u0110\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng , kh\u00f4ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u21d2\u00a0c\u1ed9t$d\u00f2ng<\/span>
\n V\u00ed d\u1ee5: B$9 \u21d2\u00a0c\u1ed1 \u0111\u1ecbnh d\u00f2ng 9, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t B<\/span><\/p>\n

– F4 (3l\u1ea7n): \u0111\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i d\u00f2ng v\u00e0 tuy\u1ec7t \u0111\u1ed1i c\u1ed9t- \u0110\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u21d2\u00a0$c\u1ed9td\u00f2ng<\/span>
\n V\u00ed d\u1ee5: $B9 \u21d2\u00a0c\u1ed1 \u0111\u1ecbnh c\u1ed9t B, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng 9<\/span><\/p>\n

Sau \u0111\u00e2y, K\u1ebf to\u00e1n Centax xin \u0111\u01b0a v\u00ed d\u1ee5 v\u1ec1 h\u00e0m VLOOKUP \u0111\u1ec3 l\u1ea5y T\u00ean h\u00e0ng h\u00f3a t\u1eeb Danh m\u1ee5c h\u00e0ng h\u00f3a<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

M\u1eddi c\u00e1c b\u1ea1n xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/a><\/span><\/p>\n

C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel 2003, 2007, 2010, 2013<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin h\u01b0\u1edbng d\u1eabn C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m VLOOKUP trong k\u1ebf to\u00e1n Excel, m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1630],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13087"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13087"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13186"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13087"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}