{"id":23933,"date":"2021-05-05T13:45:39","date_gmt":"2021-05-05T06:45:39","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23933"},"modified":"2021-05-05T13:47:37","modified_gmt":"2021-05-05T06:47:37","slug":"ham-hlookup-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-hlookup-trong-google-sheets\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hlookup trong Google Sheets"},"content":{"rendered":"

C\u0169ng gi\u1ed1ng nh\u01b0 trong Excel, h\u00e0m Hlookup<\/strong> trong Google Sheets<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. H\u00e0m Google Sheets n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong ph\u1ea1m vi cho tr\u01b0\u1edbc.<\/p>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hlookup<\/strong> trong Google Sheets<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n

H\u00e0m Hlookup trong Google Sheets<\/strong><\/h2>\n

H\u00e0m Hlookup trong Google Sheets<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tra c\u1ee9u theo chi\u1ec1u d\u1ecdc, t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u00f3a xu\u1ed1ng c\u1ed9t \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi cho tr\u01b0\u1edbc v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong c\u00f9ng h\u00e0ng t\u1eeb c\u1ed9t kh\u00e1c.<\/p>\n

\"H\u00e0m
H\u00e0m Hlookup trong Google Sheets<\/figcaption><\/figure>\n

C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c h\u00e0m Hlookup trong Google Sheets<\/strong><\/h2>\n

C\u00fa ph\u00e1p h\u00e0m Hlookup trong Google Sheets<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

\u2013 lookup_value:<\/strong>\u00a0l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ecm trong table_array.<\/p>\n

\u2013 table_array:<\/strong>\u00a0l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta mu\u1ed1n tra c\u1ee9u, d\u00f2 t\u00ecm. L\u01b0u \u00fd, v\u00f9ng d\u1eef li\u1ec7u n\u00e0y ph\u1ea3i l\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i.<\/p>\n

\u2013 row_index_num:<\/strong>\u00a0s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y trong table_array, hi\u1ec3n th\u1ecb t\u1ea1i \u00f4 k\u1ebft qu\u1ea3.<\/p>\n

\u2013 range_lookup:<\/strong>\u00a0L\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n ch\u00ednh x\u00e1c ho\u1eb7c gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang. N\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 n\u00e0y l\u00e0 l\u00e0 0 (FASLE), h\u00e0m t\u00ecm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c. N\u1ebfu gi\u00e1 tr\u1ecb l\u00e0 1 (TRUE) h\u00e0m s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hlookup trong Google Sheets<\/strong><\/h2>\n

Cho v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, y\u00eau c\u1ea7u \u0111\u1eb7t ra l\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb h\u00e0ng \u201cProduct Description\u201d<\/strong> trong b\u1ea3ng t\u00ednh th\u1ee9 2 v\u00e0 \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o \u00f4 C7.<\/p>\n

Nh\u01b0 v\u1eady c\u00f4ng t\u1ee9c h\u00e0m Hlookup s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=HLOOKUP(B7, C2:G3, 2, FALSE)<\/strong><\/p>\n

Trong v\u00ed d\u1ee5 tr\u00ean, tham s\u1ed1 lookup_value l\u00e0 \u00f4 B3 trong c\u1ed9t \u201cProduct ID\u201d. Tham s\u1ed1 table_array l\u00e0 $B$2:$G$3 v\u00ec ch\u00fang ta mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb trong ph\u1ea1m vi B2 : G3. Tham s\u1ed1 Row_index_num c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 2, v\u00ec ch\u00fang ta mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb h\u00e0ng th\u1ee9 2 trong ph\u1ea1m vi d\u1eef li\u1ec7u. Cu\u1ed1i c\u00f9ng tham s\u1ed1 range_lookup c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0 v\u00ec ch\u00fang ta mu\u1ed1n t\u00ecm k\u1ebft qu\u1ea3 g\u1ea7n \u0111\u00fang v\u1edbi gi\u00e1 tr\u1ecb \u201cProduct ID\u201d.<\/p>\n

\"0<\/p>\n

\u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m Hlookup, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1:<\/em><\/strong>\u00a0Click ch\u1ecdn \u00f4 C7.<\/p>\n

B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m Excel d\u01b0\u1edbi \u0111\u00e2y v\u00e0o:<\/p>\n

=HLOOKUP(B7,$B$2:$G$3,2,FALSE)<\/strong><\/p>\n

B\u01b0\u1edbc 3:<\/em><\/strong>\u00a0Nh\u1ea5n\u00a0Enter.<\/strong><\/p>\n

\"00<\/p>\n

K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 trong \u00f4 C7 l\u00e0 Product C. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y gi\u00e1 tr\u1ecb \u201cProduct Description\u201d trong \u00f4 E3 trong b\u1ea3ng t\u00ednh \u0111\u1ea7u ti\u00ean l\u00e0 Product C.<\/p>\n

H\u00e0m Hlookup trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><\/h2>\n

H\u00e0m Hlookup trong Excel c\u00f3 c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

\u2013 lookup_value:<\/strong>\u00a0l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, c\u00f3 th\u1ec3 l\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c tham chi\u1ebfu \u00f4.<\/p>\n

\u2013 table_array:<\/strong>\u00a0l\u00e0 b\u1ea3ng tra c\u1ee9u, tham chi\u1ebfu ph\u1ea1m vi c\u00f3 2 ho\u1eb7c nhi\u1ec1u c\u1ed9t.<\/p>\n

\u2013 row_index_num<\/strong>: h\u00e0ng trong b\u1ea3ng tra c\u1ee9u, ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/p>\n

\u2013 [range_lookup]:<\/strong>\u00a0\u0111\u1ec3 \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c, s\u1eed \u1ee5ng FALSE ho\u1eb7c \u00f4 \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c ho\u1eb7c s\u1eed d\u1ee5ng TRUE ho\u1eb7c 1 \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang.<\/p>\n

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

Cho v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Hlookup \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u1edf h\u00e0ng tr\u00ean c\u00f9ng b\u1ea3ng tra c\u1ee9u, c\u1ee5 th\u1ec3 l\u00e0 t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a khu v\u1ef1c \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

\"1
\nV\u00ec y\u00eau c\u1ea7u l\u00e0 t\u00ecm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c, do \u0111\u00f3 c\u00f4ng th\u1ee9c h\u00e0m Hlookup Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=HLOOKUP(B7,C2:F3,2,FALSE)<\/strong><\/p>\n

\"2<\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu h\u00e0m tr\u00ean kh\u00f4ng t\u00ecm th\u1ea5y t\u00ean v\u00f9ng trong h\u00e0ng \u0111\u1ea7u ti\u00ean tr\u00ean b\u1ea3ng tra c\u1ee9u, c\u00f4ng th\u1ee9c h\u00e0m Hlookup s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n

B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hlookup trong Google Sheets, Excel<\/strong>. Ngo\u00e0i ra n\u1ebfu \u0111ang c\u1ea7n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m h\u00e0m Choose Excel nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean trang nh\u00e9.<\/p>\n

N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, \u0111\u1eebng qu\u00ean chia s\u1ebb \u00fd ki\u1ebfn, th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n cho Ben Computer nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

C\u0169ng gi\u1ed1ng nh\u01b0 trong Excel, h\u00e0m Hlookup trong Google Sheets \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. H\u00e0m Google Sheets n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong ph\u1ea1m vi cho tr\u01b0\u1edbc. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m […]<\/p>\n","protected":false},"author":39,"featured_media":23934,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-23933","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\/23933","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=23933"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23933\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/23934"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=23933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=23933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=23933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}