{"id":8684,"date":"2021-08-24T14:42:35","date_gmt":"2021-08-24T07:42:35","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8684"},"modified":"2021-08-24T14:44:16","modified_gmt":"2021-08-24T07:44:16","slug":"cach-lay-du-lieu-tu-sheet-nay-sang-sheet-khac-theo-dieu-kien","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-lay-du-lieu-tu-sheet-nay-sang-sheet-khac-theo-dieu-kien\/","title":{"rendered":"C\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet n\u00e0y sang Sheet kh\u00e1c theo \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet kh\u00e1c trong\u00a0Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m VLOOKUP. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m v\u00f4 c\u00f9ng quen thu\u1ed9c v\u00e0 ph\u1ed5 bi\u1ebfn khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 theo c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n

=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])<\/strong><\/p>\n

Gi\u1ea3i th\u00edch \u00fd ngh\u0129a c\u00e1c k\u00fd t\u1ef1 nh\u01b0 sau:<\/p>\n

– Lookup_Value: Bi\u1ec3u \u0111\u1ea1t gi\u00e1 tr\u1ecb mu\u1ed1n d\u00f2 t\u00ecm<\/p>\n

– Table_Array: Bi\u1ec3u \u0111\u1ea1t v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb<\/p>\n

– Col_Index_num: Bi\u1ec3u \u0111\u1ea1t s\u1ed1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb<\/p>\n

– Ranger_Lookup: Bi\u1ec3u \u0111\u1ea1t ki\u1ec3u t\u00ecm ki\u1ebfm<\/p>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet n\u00e0y sang Sheet kh\u00e1c, b\u1ea1n n\u00ean th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

– B\u01b0\u1edbc 1: D\u01b0\u1edbi v\u00ed d\u1ee5 minh h\u1ecda, Unica \u0111\u00e3 t\u1ea1o m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 trong Sheet 1 c\u1ee7a trang t\u00ednh Excel v\u1edbi n\u1ed9i dung nh\u01b0 sau:<\/p>\n

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

– B\u01b0\u1edbc 2: T\u1ea1o th\u00eam Sheet 2 b\u1eb1ng c\u00e1ch Click v\u00e0o d\u1ea5u\u00a0\u201c+\u201d<\/strong>\u00a0v\u00e0 \u0111\u1ed5i t\u00ean Sheet nh\u01b0 \u00fd mu\u1ed1n.<\/p>\n

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

– B\u01b0\u1edbc 3: Trong Sheet 2, t\u1ea1i c\u1ed9t B d\u00f2ng s\u1ed1 2, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c theo h\u01b0\u1edbng d\u1eabn nh\u01b0 sau: =VLOOKUP(A2,Sheet1!$A$1:$E$9,2)<\/strong><\/p>\n

\"c\u00e1ch<\/strong><\/p>\n

– B\u01b0\u1edbc 4: V\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i, bao g\u1ed3m C,D,E b\u1ea1n c\u0169ng nh\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u01b0\u1edbc 3:\u00a0=VLOOKUP(A2,Sheet1!$A$1:$E$9,2)<\/strong><\/p>\n

\"c\u00e1ch<\/strong><\/p>\n

– B\u01b0\u1edbc 5: Sau khi th\u1ef1c hi\u1ec7n xong thao t\u00e1c nh\u1eadp h\u00e0m \u1edf c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1eeb Sheet 1 sang Sheet 2 trong c\u00f9ng m\u1ed9t trang t\u00ednh Excel b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i s\u1ed1 b\u00e1o danh v\u00e0 c\u00e1c n\u1ed9i dung li\u00ean quan s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf t\u01b0\u01a1ng t\u1ef1 nh\u01b0 d\u1eef li\u1ec7u b\u00ean Sheet 1.<\/p>\n

\"\"<\/p>\n

Nh\u01b0 v\u1eady ch\u1ec9 b\u1eb1ng 5 b\u01b0\u1edbc v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh xong c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet n\u00e0y sang Sheet kh\u00e1c v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n r\u1ed3i<\/p>\n

C\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb \u00f4 n\u00e0y sang \u00f4 kh\u00e1c trong Excel<\/strong><\/h2>\n

– B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean b\u1ea1n b\u1ea1n m\u1edf b\u1ea3ng t\u00ednh Excel v\u00e0 Click ch\u1ecdn m\u1ed9t Sheet m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n.<\/p>\n

– B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a b\u1ea3ng t\u00ednh Excel, nh\u1ea5n v\u00e0o\u201cHome\u201d<\/strong>\u00a0\u1edf g\u00f3c trong c\u00f9ng b\u00ean tr\u00e1i, ti\u1ebfp t\u1ee5c \u1ea5n ch\u1ecdn\u00a0\u201cFormat\u201d<\/strong>\u00a0\u1edf g\u00f3c trong c\u00f9ng b\u00ean tay ph\u1ea3i.<\/p>\n

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

– B\u01b0\u1edbc 4: Trong Format, b\u1ea1n ti\u1ebfp t\u1ee5c ch\u1ecdn\u00a0Move Or Copy Sheet<\/strong>trong m\u1ee5c Organize Sheets<\/p>\n

– B\u01b0\u1edbc 5: Trong Move Or Copy b\u1ea1n Sheet c\u1ea7n chuy\u1ec3n d\u1eef li\u1ec7u sang, sau \u0111\u00f3 \u1ea5n\u201cOk\u201d<\/strong>\u00a0l\u00e0 ho\u00e0n th\u00e0nh.<\/p>\n

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

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Sheet kh\u00e1c trong\u00a0Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m VLOOKUP. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m v\u00f4 c\u00f9ng quen thu\u1ed9c v\u00e0 ph\u1ed5 bi\u1ebfn khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 theo c\u1ea5u tr\u00fac nh\u01b0 sau: =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) Gi\u1ea3i th\u00edch \u00fd ngh\u0129a c\u00e1c k\u00fd t\u1ef1 […]<\/p>\n","protected":false},"author":3,"featured_media":8685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-8684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8684"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8685"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}