Ghi ch\u00fa: T\u00e0i li\u1ec7u tr\u00edch d\u1eabn<\/p>\n\n\n\n
H\u00e0m Vlookup l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. V\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Vlookup hay h\u00e0m Hlookup t\u01b0\u01a1ng t\u1ef1 l\u00e0 \u0111i\u1ec1u d\u1ec5 d\u00e0ng. Nh\u01b0ng v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi m\u1edbi h\u1ecdc, h\u00e0m n\u00e0y v\u00f4 c\u00f9ng kh\u00f3 hi\u1ec3u, v\u00e0 kh\u00f4ng bi\u1ebft th\u1ef1c h\u00e0nh. H\u00e0m Vlookup l\u00e0 g\u00ec, \u0111\u1ec3 l\u00e0m g\u00ec m\u00e0 kh\u00f3 nh\u1eb1n cho ng\u01b0\u1eddi m\u1edbi v\u1eady. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1ec1 h\u00e0m Vlookup c\u0169ng nh\u01b0 Hlookup l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup.<\/p>\n\n\n\n
H\u00e0m Vlookup l\u00e0 g\u00ec? Hlookup l\u00e0 g\u00ec?<\/p>\n\n\n\n
Do \u00fd ngh\u0129a v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m Hlookup t\u01b0\u01a1ng t\u1ef1 h\u00e0m vlookup n\u00ean ph\u1ea7n n\u1ed9i dung d\u01b0\u1edbi, ch\u00fang t\u00f4i s\u1ebd ch\u1ec9 n\u00eau v\u1ec1 h\u00e0m vlookup. N\u1ed9i dung h\u00e0m Hlookup b\u1ea1n s\u1ebd hi\u1ec3u r\u1eb1ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 n\u1ed9i dung c\u1ee7a h\u00e0m Vlookup nh\u00e9. Ch\u1ec9 \u0111\u1ed5i \u0111\u1ea1i l\u01b0\u1ee3ng h\u00e0ng hay v\u00ec c\u1ed9t nh\u01b0 Vlookup.<\/p>\n\n\n\n
\u00dd ngh\u0129a h\u00e0m Vlookup l\u00e0 g\u00ec<\/p>\n\n\n\n
H\u00e0m Vlookup mang \u00fd ngh\u0129a v\u00f4 c\u00f9ng quan tr\u1ecdng trong k\u1ebf to\u00e1n gi\u00fap<\/p>\n\n\n\n
T\u00ecm \u0111\u01a1n gi\u00e1, s\u1ed1 d\u01b0<\/p>\n\n\n\n
T\u00ecm c\u00e1c danh m\u1ee5c d\u1eef li\u1ec7u M\u00e3 h\u00e0ng ho\u00e1, t\u00ean h\u00e0ng ho\u00e1, gi\u00e1 tr\u1ecb h\u00e0ng ho\u00e1<\/p>\n\n\n\n
T\u00ecm h\u00e0ng t\u1ed3n kho<\/p>\n\n\n\n
T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb kh\u1ea5u hao c\u1ee7a th\u00e1ng tr\u01b0\u1edbc so v\u1edbi th\u00e1ng tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n\n\n\n
T\u00ecm ki\u1ebfm s\u1ed1 d\u01b0, n\u1ee3 c\u1ee7a chi ti\u1ebft t\u1eebng kh\u00e1ch h\u00e0ng ph\u1ea3i tr\u1ea3, ph\u1ea3i thu cu\u1ed1i n\u0103m<\/p>\n\n\n\n
\u0110\u1ec3 d\u00f9ng h\u00e0m Vlookup b\u1ea1n c\u1ea7n ghi nh\u1edb c\u00e2u l\u1ec7nh c\u1ee7a h\u00e0m. H\u00e0m Vlookup trong excel c\u00f3 c\u00fa ph\u00e1p l\u1ec7nh nh\u01b0 sau:<\/p>\n\n\n\n
=Vlookup(lookup_value,table_array,col_index_num,[range_lookup])<\/p>\n\n\n\n
Trong \u0111\u00f3:<\/p>\n\n\n\n
Lookup_value: gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. L\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm trong table_array \u0111\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng c\u1ee7a c\u1ed9t \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu excel t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm trong table_array, n\u00f3 s\u1ebd hi\u1ec7n th\u1ecb gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng c\u1ee7a c\u1ed9t \u0111\u00e3 cho c\u00f3 s\u1eb5n. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y ho\u1eb7c kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3, c\u1ed9t nh\u1eadn gi\u00e1 tr\u1ecb s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #N\/A<\/p>\n\n\n\n
Table_array: v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm. V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm c\u1ea7n ch\u1ee9a t\u00ean gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. Hay n\u00f3i c\u00e1ch kh\u00e1c table_array ch\u1ec9 v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm ki\u1ebfm. V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm n\u00ean \u0111\u1ec3 d\u1ea1ng gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i $ ( b\u1ea5m F4 sau khi ch\u1ecdn v\u00f9ng)<\/p>\n\n\n\n
Col_index_num: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1. T\u00ednh t\u1eeb tr\u00e1i sang, c\u1ed9t n\u1eb1m tr\u00ean c\u1ed9t th\u1ee9 m\u1ea5y c\u1ee7a v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n\n\n\n
Range_lookup: \u0111\u1ed9 ch\u00ednh x\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a l\u1ec7nh h\u00e0m.<\/p>\n\n\n\n
Nh\u1eadp 1 n\u1ebfu mu\u1ed1n gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u0111\u1ed1i (TRUE)<\/p>\n\n\n\n
Nh\u1eadp 0 n\u1ebfu mu\u1ed1n gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i (FALSE)<\/p>\n\n\n\n
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup gi\u1eefa 2 sheet<\/p>\n\n\n\n
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup gi\u1eefa 2 sheet c\u0169ng r\u1ea5t \u0111\u01a1n gi\u1ea3n. Ch\u1ec9 \u0111\u1ed5i l\u1ec7nh \u1edf table_array v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm. C\u1ee5 th\u1ec3, sau khi nh\u1eadp l\u1ec7nh gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm lookup_value. B\u1ea1n chuy\u1ec3n sang sheet c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm (c\u00f3 d\u1ea5u tuy\u1ec7t \u0111\u1ed1i F4). Sau \u0111\u00f3 tr\u1edf v\u1ec1 sheet ch\u1ee9a l\u1ec7nh, ti\u1ebfp t\u1ee5c ch\u1ecdn s\u1ed1 c\u1ed9t c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n\n\n\n
Ngo\u00e0i ra, thay v\u00ec s\u1eed d\u1ee5ng h\u00e0m Vlookup ho\u1eb7c Hlookup \u0111\u1ec3 t\u00ecm ki\u1ebfm, nh\u1eadp gi\u00e1 tr\u1ecb v\u1edbi \u0111i\u1ec1u ki\u1ec7n th\u00f4ng th\u01b0\u1eddng. Vlookup, Hlookup c\u00f2n k\u1ebft h\u1ee3p c\u00f9ng nh\u1eefng l\u1ec7nh if, left, right, match, sumif,\u2026 G\u1ecdi l\u00e0 h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n. H\u00e0m vlookup s\u1eed d\u1ee5ng c\u00f9ng l\u00fac th\u00eam t\u1eeb 2 tr\u1edf l\u00ean c\u00e1c l\u1ec7nh tr\u00ean g\u1ecdi l\u00e0 h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n hay g\u1ecdi l\u00e0 h\u00e0m vlookup n\u00e2ng cao. D\u1eef li\u1ec7u t\u00ecm ki\u1ebfm c\u00f3 l\u01b0\u1ee3ng th\u00f4ng tin c\u00e0ng nh\u1ecf, \u00e1p d\u1ee5ng h\u00e0m c\u00e0ng kh\u00f3, c\u00e0ng s\u1eed d\u1ee5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n k\u00e8m. Do \u0111\u00f3, h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n lu\u00f4n c\u00f3 s\u1ef1 ph\u1ee9c t\u1ea1p g\u00e2y kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi m\u1edbi, k\u1ec3 c\u1ea3 nh\u1eefng ng\u01b0\u1eddi \u0111\u00e3 quen s\u1eed d\u1ee5ng.<\/p>\n\n\n\n
Tr\u00ean google c\u00f3 ti\u1ec7n \u00edch l\u00e0m excel tr\u1ef1c tuy\u1ebfn t\u01b0\u01a1ng t\u1ef1 nh\u01b0 ph\u1ea7n m\u1ec1m excel offline g\u1ecdi l\u00e0 google sheet. N\u00ean c\u00e1ch s\u1eed d\u1ee5ng l\u1ec7nh Vlookup trong google sheet c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 trong ph\u1ea7n m\u1ec1m offline Excel.<\/p>\n\n\n\n
Tr\u00ean \u0111\u00e2y, Vietlearn.org \u0111\u00e3 chia s\u1ebb cho b\u1ea1n \u0111\u1ecdc bi\u1ebft H\u00e0m vlookup l\u00e0 g\u00ec? \u00dd ngh\u0129a c\u1ee7a h\u00e0m vlookup v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup. Hi v\u1ecdng nh\u1eefng th\u00f4ng tin c\u1ee7a ch\u00fang t\u00f4i s\u1ebd h\u1eefu \u00edch cho nh\u1eefng ng\u01b0\u1eddi m\u1edbi h\u1ecdc excel.<\/p>\n\n\n\n
<\/p>\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"
Ghi ch\u00fa: T\u00e0i li\u1ec7u tr\u00edch d\u1eabn H\u00e0m Vlookup l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. V\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Vlookup hay h\u00e0m Hlookup t\u01b0\u01a1ng t\u1ef1 l\u00e0 \u0111i\u1ec1u d\u1ec5 d\u00e0ng. Nh\u01b0ng v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi m\u1edbi h\u1ecdc, h\u00e0m n\u00e0y v\u00f4 c\u00f9ng kh\u00f3 hi\u1ec3u, v\u00e0 kh\u00f4ng bi\u1ebft th\u1ef1c h\u00e0nh. H\u00e0m […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_disable_autopaging":false},"categories":[13],"tags":[],"class_list":["post-2965","post","type-post","status-publish","format-standard","hentry","category-tin-hoc"],"_links":{"self":[{"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/posts\/2965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/comments?post=2965"}],"version-history":[{"count":0,"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/posts\/2965\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/media?parent=2965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/categories?post=2965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vietlearn.org\/kien-thuc\/wp-json\/wp\/v2\/tags?post=2965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}