{"id":8684,"date":"2021-08-24T14:42:35","date_gmt":"2021-08-24T07:42:35","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8684"},"modified":"2026-05-28T14:36:37","modified_gmt":"2026-05-28T07:36:37","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":"<p>\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... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"excerpt":{"rendered":"<p>\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&#8230;... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"author":3,"featured_media":0,"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","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":1,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8684\/revisions"}],"predecessor-version":[{"id":10597,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8684\/revisions\/10597"}],"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}]}}