{"id":9982,"date":"2025-01-06T12:23:50","date_gmt":"2025-01-06T12:23:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-su-dung-ket-hop-vlookup-va-choose-mot-cach-khac-de-tim-kiem-tu-phai-qua-trai\/"},"modified":"2025-01-06T12:23:50","modified_gmt":"2025-01-06T12:23:50","slug":"huong-dan-su-dung-ket-hop-vlookup-va-choose-mot-cach-khac-de-tim-kiem-tu-phai-qua-trai","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-su-dung-ket-hop-vlookup-va-choose-mot-cach-khac-de-tim-kiem-tu-phai-qua-trai\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p VLOOKUP v\u00e0 CHOOSE: M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb ph\u1ea3i qua tr\u00e1i"},"content":{"rendered":"
\n

Vlookup l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn trong Excel, tuy nhi\u00ean m\u1ed9t trong nh\u1eefng \u0111i\u1ec3m y\u1ebfu t\u1ed3n t\u1ea1i l\u00e0 v\u1ec1 c\u01a1 b\u1ea3n ch\u1ec9 c\u00f3 th\u1ec3 tra c\u1ee9u theo m\u1ed9t chi\u1ec1u t\u1eeb tr\u00e1i sang ph\u1ea3i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c nh\u01b0\u1ee3c \u0111i\u1ec3m n\u00e0y, th\u00f4ng th\u01b0\u1eddng ng\u01b0\u1eddi s\u1eed d\u1ee5ng s\u1ebd l\u1ef1a ch\u1ecdn\u00a0k\u1ebft h\u1ee3p<\/strong> INDEX v\u00e0 MATCH<\/strong><\/a>. Trong b\u00e0i vi\u1ebft n\u00e0y, h\u00e3y xem H\u1ecdc Excel Online s\u1eed d\u1ee5ng VLOOKUP v\u00e0 CHOOSE \u0111\u1ec3 c\u00f3 th\u1ec3 \u201ctra ng\u01b0\u1ee3c\u201d ra sao nh\u00e9:<\/p>\n

H\u00e0m CHOOSE<\/strong><\/h3>\n

Tr\u01b0\u1edbc ti\u00ean ta s\u1ebd t\u00ecm hi\u1ec3u c\u00fa ph\u00e1p h\u00e0m CHOOSE:<\/p>\n

\n

=CHOOSE(index_num, value1, [value2],\u2026)<\/p>\n<\/blockquote>\n

H\u00e0m CHOOSE s\u1eed d\u1ee5ng index_num\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch \u0111\u1ed1i s\u1ed1 gi\u00e1 tr\u1ecb value1, value2\u2026<\/p>\n

V\u00ed d\u1ee5: =CHOOSE(3,\u201d\u0111\u00e2y\u201d,\u201dl\u00e0\u201d,\u201ds\u1ed1\u201d,\u201dba)<\/strong>. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1: s<\/strong>\u1ed1.<\/strong><\/p>\n

Tuy nhi\u00ean, l\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng CHOOSE<\/strong> v\u1edbi m\u1ea3ng. H\u00e3y xem c\u00e1ch v\u1eadn h\u00e0nh sau \u0111\u00e2y:<\/p>\n

\n

=CHOOSE({1,2},B1:B5,A1:A5)<\/strong><\/p>\n<\/blockquote>\n

V\u1edbi c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p m\u1ea3ng n\u00e0y, m\u1ed9t m\u1ea3ng \u1ea3o v\u1edbi 2 c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o ra. C\u1ed9t th\u1ee9 nh\u1ea5t l\u00e0 B1:B5, <\/strong>c\u1ed9t th\u1ee9 hai l\u00e0 A1:A5.<\/strong><\/p>\n

<\/p>\n

V\u00e0 gi\u1edd ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p v\u1edbi VLOOKUP.<\/strong><\/p>\n

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

=VLOOKUP(<gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm t\u1ea1i c\u1ed9t B>,CHOOSE({1,2},B1:B5,A1:A5),2,0)<\/strong><\/p>\n<\/blockquote>\n

K\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t A.<\/p>\n

H\u00e3y xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n:<\/p>\n

<\/p>\n

\u00a0<\/p>\n

T\u1ea1i \u0111\u00e2y, \u0111\u1ed1i v\u1edbi INDEX v\u00e0\u00a0<\/strong>MATCH,\u00a0<\/strong>h\u00e0m\u00a0MATCH\u00a0<\/strong>\u0111\u1ea7u ti\u00ean cho ta bi\u1ebft \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm n\u1eb1m \u1edf h\u00e0ng m\u1ea5y. H\u00e0m\u00a0MATCH\u00a0<\/strong>th\u1ee9 hai cho bi\u1ebft gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm t\u1ea1i c\u1ed9t n\u00e0o. H\u00e0m\u00a0INDEX<\/strong> s\u1eed d\u1ee5ng 2 th\u00f4ng tin tr\u00ean v\u00e0 t\u00ecm ra cho ta d\u1eef li\u1ec7u ch\u00ednh x\u00e1c.<\/p>\n

\u0110\u1ed1i v\u1edbi\u00a0VLOOKUP k\u1ebft h\u1ee3p CHOOSE<\/strong>, h\u00e0m\u00a0CHOOSE<\/strong> t\u1ea1o ra m\u1ed9t m\u1ea3ng \u1ea3o g\u1ed3m c\u1ed9t th\u1ee9 nh\u1ea5t l\u00e0 t\u00ean nh\u00e2n vi\u00ean, c\u1ed9t th\u1ee9 hai l\u00e0 qu\u00fd t\u01b0\u01a1ng \u1ee9ng. H\u00e0m\u00a0VLOOKUP<\/strong> ti\u1ebfn h\u00e0nh t\u00ecm ki\u1ebfm theo c\u1ed9t \u1ea3o t\u1eeb tr\u00e1i qua ph\u1ea3i.<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng c\u1ee7a\u00a0VLOOKUP v\u00e0 CHOOSE<\/strong>. Tuy r\u1eb1ng\u00a0v\u1eabn t\u1ed3n t\u1ea1i\u00a0nh\u1eefng h\u1ea1n ch\u1ebf nh\u1ea5t \u0111\u1ecbnh, nh\u01b0ng kh\u00f4ng th\u1ec3 kh\u00f4ng n\u00f3i r\u1eb1ng s\u1ef1 k\u1ebft h\u1ee3p n\u00e0y kh\u00e1 \u0111\u1ed9c \u0111\u00e1o ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n

Xem th\u00eam v\u1ec1 h\u00e0m\u00a0VLOOKUP<\/strong> t\u1ea1i \u0110\u00e2y<\/a>.<\/p>\n

Gi\u1edbi thi\u1ec7u c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m\u00a0CHOOSE<\/strong> t\u1ea1i \u0110\u00e2y<\/a>.<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online.<\/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":9983,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9982","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\/9982","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=9982"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9982\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9983"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}