{"id":24072,"date":"2021-05-07T16:48:20","date_gmt":"2021-05-07T09:48:20","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24072"},"modified":"2021-05-07T16:48:20","modified_gmt":"2021-05-07T09:48:20","slug":"ham-index-va-match","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-index-va-match\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match trong Excel qua b\u00e0i t\u1eadp"},"content":{"rendered":"

H\u00e0m Index v\u00e0 Match<\/strong> l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a 2 h\u00e0m ri\u00eang l\u1ebb trong Excel l\u00e0 h\u00e0m Index v\u00e0 h\u00e0m Match. Trong \u0111\u00f3 h\u00e0m =INDEX()<\/strong> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh d\u1ef1a tr\u00ean s\u1ed1 c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng, h\u00e0m = MATCH()<\/strong> tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t.<\/p>\n

B\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match<\/strong> trong Excel.<\/p>\n

H\u00e0m Index trong Excel<\/strong><\/h2>\n

H\u00e0m Index trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ho\u1eb7c tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb trong b\u1ea3ng t\u00ednh ho\u1eb7c ph\u1ea1m vi. H\u00e0m Index g\u1ed3m 2 d\u1ea1ng l\u00e0 h\u00e0m Index d\u1ea1ng m\u1ea3ng v\u00e0 d\u1ea1ng tham chi\u1ebfu.<\/p>\n

B\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n

H\u00e0m Match trong Excel<\/strong><\/h2>\n

H\u00e0m Match trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, x\u00e1c \u0111\u1ecbnh trong b\u1ea3ng t\u00ednh.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index trong Excel<\/strong><\/h2>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y bao g\u1ed3m c\u00e1c d\u1eef li\u1ec7u t\u00ean, chi\u1ec1u cao v\u00e0 c\u00e2n n\u1eb7ng c\u1ee7a m\u1ed7i ng\u01b0\u1eddi \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong b\u1ea3n. Y\u00eau c\u1ea7u l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Index Excel \u0111\u1ec3 tra c\u1ee9u chi\u1ec1u cao c\u1ee7a Kevin.<\/p>\n

\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1:<\/em>\u00a0<\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c\u00a0\u201c=Index\u201d (<\/strong>\u00a0v\u00e0 ch\u1ecdn v\u00f9ng b\u1ea3ng t\u00ednh r\u1ed3i th\u00eam d\u1ea5u ph\u1ea9y.<\/p>\n

B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Nh\u1eadp s\u1ed1 h\u00e0ng cho Kevin, l\u00e0 \u201c4\u201d r\u1ed3i th\u00eam d\u1ea5u ph\u1ea9y.<\/p>\n

B\u01b0\u1edbc 3:<\/em><\/strong>\u00a0Nh\u1eadp s\u1ed1 c\u1ed9t chi\u1ec1u cao cho Kevin l\u00e0 \u201c2\u201d r\u1ed3i \u0111\u00f3ng d\u1ea5u ngo\u1eb7c l\u1ea1i.<\/p>\n

B\u01b0\u1edbc 4<\/em>:<\/strong> K\u1ebft qu\u1ea3 h\u00e0m Index tr\u1ea3 v\u1ec1 l\u00e0 5.8.<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index trong Excel<\/figcaption><\/figure>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match trong Excel<\/strong><\/h2>\n

Ti\u1ebfp t\u1ee5c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u \u1edf tr\u00ean, trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed Kevin \u1edf h\u00e0ng n\u00e0o.<\/p>\n

Th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1:<\/em><\/strong>\u00a0Nh\u1eadp c\u00f4ng th\u1ee9c\u00a0\u201c=MATCH\u201d (<\/strong>\u00a0r\u1ed3i li\u00ean k\u1ebft \u0111\u1ebfn \u00f4 ch\u1ee9a v\u0103n b\u1ea3n l\u00e0 Kevin.<\/p>\n

B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t t\u00ean (name), bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1 c\u1ed9t l\u00e0 Name.<\/p>\n

B\u01b0\u1edbc 3:<\/em>\u00a0<\/strong>Ti\u1ebfp theo nh\u1eadp gi\u00e1 tr\u1ecb 0 \u0111\u1ec3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n

B\u01b0\u1edbc 4:<\/em><\/strong>\u00a0K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed Kevin l\u00e0 \u1edf h\u00e0ng s\u1ed1 4.<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match trong Excel – \u1ea2nh 1<\/figcaption><\/figure>\n

Ti\u1ebfp theo ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Match \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ed9t chi\u1ec1u cao (height).<\/p>\n

B\u01b0\u1edbc 1<\/em>:<\/strong> Nh\u1eadp h\u00e0m\u00a0\u201c=MATCH (<\/strong>\u00a0v\u00e0 li\u00ean k\u1ebft \u0111\u1ebfn \u00f4 c\u00f3 ti\u00eau \u0111\u1ec1 l\u00e0 Height (ti\u00eau ch\u00ed m\u00e0 ch\u00fang ta mu\u1ed1n tra c\u1ee9u).<\/p>\n

B\u01b0\u1edbc 2<\/em>:<\/strong> Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean h\u00e0ng tr\u00ean c\u00f9ng c\u1ee7a b\u1ea3ng t\u00ednh.<\/p>\n

B\u01b0\u1edbc 3:<\/em>\u00a0<\/strong>Ti\u1ebfp theo nh\u1eadp gi\u00e1 tr\u1ecb 0 \u0111\u1ec3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n

B\u01b0\u1edbc 4<\/em>:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t Height l\u00e0 \u1edf c\u1ed9t s\u1ed1 2.<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match trong Excel – \u1ea2nh 2<\/figcaption><\/figure>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match trong Excel<\/strong><\/h2>\n

Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 2 h\u00e0m Match \u0111\u1ec3 thay th\u1ebf gi\u00e1 tr\u1ecb \u201c4\u201d v\u00e0 \u201c2\u201d trong c\u00f4ng th\u1ee9c h\u00e0m Index ban \u0111\u1ea7u.
\nTh\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1:<\/em><\/strong>\u00a0C\u1eaft c\u00f4ng th\u1ee9c h\u00e0m Match cho Kevin v\u00e0 thay th\u1ebf b\u1eb1ng gi\u00e1 tr\u1ecb \u201c4\u201d.<\/p>\n

B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>C\u1eaft c\u00f4ng th\u1ee9c h\u00e0m Match cho Height v\u00e0 thay th\u1ebf b\u1eb1ng gi\u00e1 tr\u1ecb l\u00e0 \u201c2\u201d.<\/p>\n

B\u01b0\u1edbc 3<\/em>:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 chi\u1ec1u cao c\u1ee7a Kevin l\u00e0 5.8.<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match trong Excel<\/figcaption><\/figure>\n

L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match trong Excel<\/strong><\/h2>\n

1. L\u1ed7i #REF<\/strong><\/h3>\n

L\u1ed7i<\/strong> #REF<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t m\u00e0 ng\u01b0\u1eddi d\u00f9ng hay g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match trong Excel.<\/p>\n

L\u1ed7i n\u00e0y x\u1ea3y ra n\u1ebfu ph\u1ea1m vi tr\u1ea3 v\u1ec1 h\u00e0m Index kh\u00e1c v\u1edbi ph\u1ea1m vi tra c\u1ee9u c\u1ee7a h\u00e0m Match. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y ti\u00eau ch\u00ed \u0111\u00e3 cho, h\u00e0m Index v\u00e0 Match s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #REF. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y gi\u1ea3i ph\u00e1p l\u00e0 thay \u0111\u1ed5i ph\u1ea1m vi h\u00e0m Index.<\/p>\n

2. L\u1ed7i #N\/A<\/strong><\/h3>\n

Ngo\u00e0i ra h\u00e0m Index v\u00e0 Match trong Excel<\/strong> c\u0169ng tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A<\/strong> khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, gi\u1ed1ng nh\u01b0 h\u00e0m VLOOKUP.<\/p>\n

Hy v\u1ecdng sau b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y b\u1ea1n \u0111\u1ecdc \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 Match<\/strong> trong Excel nh\u01b0 th\u1ebf n\u00e0o. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n<\/a> v\u00e0 h\u00e0m n\u1ed1i chu\u1ed7i trong Excel<\/a> nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

H\u00e0m Index v\u00e0 Match l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a 2 h\u00e0m ri\u00eang l\u1ebb trong Excel l\u00e0 h\u00e0m Index v\u00e0 h\u00e0m Match. Trong \u0111\u00f3 h\u00e0m =INDEX() tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh d\u1ef1a tr\u00ean s\u1ed1 c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng, h\u00e0m = MATCH() tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t h\u00e0ng […]<\/p>\n","protected":false},"author":39,"featured_media":24136,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24072"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24072\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24136"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}