{"id":11125,"date":"2025-01-15T01:43:53","date_gmt":"2025-01-15T01:43:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup\/"},"modified":"2025-01-15T01:43:53","modified_gmt":"2025-01-15T01:43:53","slug":"huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1eeb \u0111\u1ea7u \u0111\u1ebfn cu\u1ed1i v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y,<strong> <a href=\"https:\/\/www.hocexcel.online\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u1ee5 th\u1ec3 v\u00e0 chi ti\u1ebft c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m Vlookup<\/strong><\/a> m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9958 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-tutorial.jpeg\" width=\"693\" height=\"320\" title=\"vlookup-tutorial\"><\/p>\n<p style=\"text-align: justify\"><strong>\u0110\u1ecbnh ngh\u0129a c\u01a1 b\u1ea3n v\u1ec1 Vlookup.<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup.html\">Vlookup l\u00e0 h\u00e0m ch\u1ee9c n\u0103ng trong Excel<\/a> c\u00f3 t\u00e1c d\u1ee5ng tham chi\u1ebfu gi\u00e1 tr\u1ecb t\u1eeb tr\u00e1i sang ph\u1ea3i d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb g\u1ed1c.<\/p>\n<p style=\"text-align: justify\">C\u1ea5u tr\u00fac c\u1ee7a l\u1ec7nh nh\u01b0 sau: VLOOKUP(<em>lookup_value, table_array, col_index_num, [range_lookup]<\/em>)<\/p>\n<ul style=\"text-align: justify\">\n<li>Lookup_value: gi\u00e1 tr\u1ecb c\u1ea7n tham chi\u1ebfu, hay c\u00f2n g\u1ecdi l\u00e0 gi\u00e1 tr\u1ecb g\u1ed1c. B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n b\u1ea5t c\u1ee9 k\u00fd t\u1ef1 ch\u1eef hay s\u1ed1 n\u00e0o v\u00e0o m\u1ee5c n\u00e0y (l\u01b0u \u00fd l\u00e0 b\u1ea1n n\u00ean ch\u1ecdn 1 gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 tham chi\u1ebfu ch\u00ednh x\u00e1c nh\u1ea5t)<\/li>\n<li>Table_array: L\u00e0 t\u1eadp h\u1ee3p b\u1ea3ng d\u1eef li\u1ec7u n\u01a1i b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n thao t\u00e1c tham chi\u1ebfu \u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u c\u1ea7n t\u00ecm trong to\u00e0n b\u1ed9 d\u1eef li\u1ec7u g\u1ed1c.<\/li>\n<li>Col_index_num: S\u1ed1 l\u01b0\u1ee3ng c\u1ed9t t\u00ednh t\u1eeb gi\u00e1 tr\u1ecb g\u1ed1c (gi\u00e1 tr\u1ecb tham chi\u1ebfu) trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>[range_lookup]\u2013 \u1ede \u0111\u00e2y quy \u0111\u1ecbnh ch\u1ea5t l\u01b0\u1ee3ng tham chi\u1ebfu, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn Approximate match \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 tham chi\u1ebfu ch\u00ednh x\u00e1c \u1edf m\u1ee9c t\u01b0\u01a1ng \u0111\u1ed1i, ho\u1eb7c ch\u1ecdn Exact match \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 tham chi\u1ebfu \u0111\u00fang tuy\u1ec7t \u0111\u1ed1i (trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p ph\u1ea7n l\u1edbn ta s\u1ebd s\u1eed d\u1ee5ng exact match)<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Vlookup c\u0103n b\u1ea3n<\/a>:<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 #1:<\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y ta c\u00f3 2 b\u1ea3ng d\u1eef li\u1ec7u, m\u1ed9t b\u1ea3ng ch\u1ec9 ch\u1ee9a m\u00e3 qu\u1ed1c gia v\u00e0 m\u1ed9t b\u1ea3ng ch\u1ee9a c\u1ea3 m\u00e3 qu\u1ed1c gia l\u1eabn t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a qu\u1ed1c gia \u0111\u00f3.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-260.gif\" title=\"ex101_92019-nho-260\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9959 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup1-1.png\" width=\"436\" height=\"146\" title=\"vlookup1-1\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: Ta \u0111i\u1ec1n l\u1ec7nh \u201c=Vlookup\u201d v\u00e0o \u00f4 C2<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: \u0110i\u1ec1n v\u00e0o n\u1ed9i dung h\u00e0m Vlookup gi\u00e1 tr\u1ecb c\u1ea7n tham chi\u1ebfu, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 gi\u00e1 tr\u1ecb \u201cAU\u201d c\u1ee7a \u00f4 B2 v\u00e0 th\u00eam m\u1ed9t d\u1ea5u ph\u1ea9y<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: \u0110i\u1ec1n ti\u1ebfp t\u00ean b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n tham chi\u1ebfu, c\u1ee5 th\u1ec3 l\u00e0 E:F v\u00e0 th\u00eam m\u1ed9t d\u1ea5u ph\u1ea9y<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: \u0110i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t c\u1ea7n tham chi\u1ebfu, c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y ta \u0111ang c\u1ea7n t\u00ecm t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a qu\u1ed1c gia trong b\u1ea3ng d\u1eef li\u1ec7u E:F, v\u00ec th\u1ebf c\u1ed9t d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c t\u00ean \u0111\u00f3 s\u1ebd l\u00e0 c\u1ed9t F, v\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 2<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 5: \u0110i\u1ec1u ki\u1ec7n tham chi\u1ebfu. \u1ede \u0111\u00e2y ta c\u1ea7n tham chi\u1ebfu t\u00ean ch\u00ednh x\u00e1c, v\u00ec v\u1eady ta s\u1ebd \u0111i\u1ec1n l\u00e0 \u201cFALSE\u201d, t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi l\u1ef1a ch\u1ecdn \u201cexact match\u201d<\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9960 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup1-1-1.png\" width=\"666\" height=\"147\" title=\"vlookup1-1-1\"><\/p>\n<p style=\"text-align: justify\">Sau khi ho\u00e0n th\u00e0nh c\u00e1c b\u01b0\u1edbc n\u00f3i tr\u00ean, b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 \u1edf \u00f4 C2 s\u1ebd xu\u1ea5t hi\u1ec7n c\u1ee5m t\u1eeb \u201cAustralia\u201d.<\/p>\n<p style=\"text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Vlookup n\u00e2ng cao<\/a>:<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 #2:<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ta c\u00f3 2 b\u1ea3ng d\u1eef li\u1ec7u kh\u00e1c nhau nh\u01b0ng c\u00f3 chung n\u1ed9i dung, nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 ph\u1ea3i vi\u1ebft m\u1ed9t c\u00e2u l\u1ec7nh s\u1eed d\u1ee5ng h\u00e0m Vlookup \u0111\u1ec3 tham chi\u1ebfu t\u1eeb c\u1ea3 2 b\u1ea3ng n\u00f3i tr\u00ean sao cho t\u00ecm \u0111\u01b0\u1ee3c \u0111\u00fang t\u1eeb kh\u00f3a.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9963 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup2.png\" width=\"630\" height=\"143\" title=\"vlookup2\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: \u0110i\u1ec1n c\u00e2u l\u1ec7nh c\u1ee7a Vlookup theo v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3 v\u00e0o \u00f4 B2. L\u00fac n\u00e0y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u1edf \u00f4 B5 s\u1ebd l\u00e0 #N\/A, \u0111i\u1ec1u n\u00e0y ho\u00e0n to\u00e0n b\u00ecnh th\u01b0\u1eddng b\u1edfi v\u00ec t\u1eeb kh\u00f3a vi\u1ebft t\u1eaft \u201cBE\u201d th\u1ef1c ra n\u1eb1m \u1edf b\u1ea3ng d\u1eef li\u1ec7u th\u1ee9 2.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: M\u1ed9t khi b\u1ea1n nh\u00ecn th\u1ea5y l\u1ed7i #N\/A, \u0111i\u1ec1u \u0111\u00f3 ch\u1ee9ng t\u1ecf t\u1eeb kh\u00f3a \u201cBE\u201d m\u00e0 b\u1ea1n c\u1ea7n t\u00ecm kh\u00f4ng c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u 1. V\u00ec v\u1eady b\u1eaft bu\u1ed9c ta ph\u1ea3i ti\u1ebfp t\u1ee5c thao t\u00e1c tham chi\u1ebfu sang b\u1ea3ng d\u1eef li\u1ec7u th\u1ee9 2.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: \u0110i\u1ec1n th\u00eam h\u00e0m IFERROR l\u00ean tr\u01b0\u1edbc h\u00e0m Vlookup ban \u0111\u1ea7u \u0111\u1ec3 h\u1ec7 th\u1ed1ng t\u1ef1 ph\u00e1t hi\u1ec7n l\u1ed7i v\u00e0 \u0111\u1ec1 xu\u1ea5t c\u00e1ch gi\u1ea3i quy\u1ebft<\/p>\n<p style=\"text-align: justify\"><strong>=IFERROR(VLOOKUP(A2,D:E,2,FALSE),0)<\/strong><\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y gi\u1ea3 s\u1eed n\u1ebfu h\u00e0m Vlookup cho ra k\u1ebft qu\u1ea3 l\u1ed7i th\u00ec h\u00e0m IFERROR s\u1ebd t\u1ef1 \u0111\u1ed9ng g\u00e1n gi\u00e1 tr\u1ecb 0 cho k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Ti\u1ebfp theo ta s\u1ebd thay th\u1ebf ch\u1eef s\u1ed1 0 trong h\u00e0m IFERROR tr\u00ean b\u1eb1ng 1 h\u00e0m Vlookup kh\u00e1c d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu sang b\u1ea3ng d\u1eef li\u1ec7u th\u1ee9 2:<\/p>\n<p style=\"text-align: justify\"><strong>=IFERROR(VLOOKUP(A2,D:E,2,FALSE),VLOOKUP(A2,G:H,2,FALSE))<\/strong><\/p>\n<p style=\"text-align: justify\">Sau khi b\u1ea5m Enter, b\u1ea1n s\u1ebd th\u1ea5y l\u00e0 c\u00e1c d\u00f2ng k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec7n t\u01b0\u01a1ng \u1ee9ng nh\u1eefng t\u00ean qu\u1ed1c gia n\u1eb1m l\u1eabn l\u1ed9n \u1edf c\u1ea3 2 b\u1ea3ng d\u1eef li\u1ec7u<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9962 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-vlookup-2-1-1.png\" width=\"829\" height=\"174\" title=\"excel-vlookup-2-1-1\"><\/p>\n<p style=\"text-align: justify\">Ch\u1eb3ng h\u1ea1n, m\u1eb7c d\u00f9 t\u1eeb kh\u00f3a \u201cBE\u201d v\u00e0 \u201cUS\u201d \u0111\u1ec1u n\u1eb1m \u1edf b\u1ea3ng th\u1ee9 2 nh\u01b0ng nh\u1edd c\u00f3 c\u00f4ng th\u1ee9c tr\u00ean m\u00e0 ta v\u1eabn c\u00f3 th\u1ec3 tham chi\u1ebfu \u0111\u01b0\u1ee3c ch\u00fang m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup.html\"><strong>H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m Vlookup \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p to\u00e1n<\/strong><\/a><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 #3<\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y ta c\u00f3 2 b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea3ng \u0111\u1ea7u ti\u00ean th\u1ec3 hi\u1ec7n t\u00ean c\u00e1c m\u1eb7t h\u00e0ng v\u00e0 doanh s\u1ed1 t\u01b0\u01a1ng \u1ee9ng c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng, b\u1ea3ng th\u1ee9 hai l\u00e0 b\u1ea3ng gi\u00e1 c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c t\u1ed5ng doanh thu c\u1ee7a 3 m\u1eb7t h\u00e0ng \u0111\u1ea7u ta ch\u1ec9 c\u1ea7n nh\u00e2n doanh s\u1ed1 v\u1edbi gi\u00e1 ti\u1ec1n c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng m\u1ed9t l\u00e0 xong, nh\u01b0ng n\u1ebfu thay v\u00ec ch\u1ec9 c\u00f3 3 m\u1eb7t h\u00e0ng b\u1ea1n c\u00f3 \u0111\u1ebfn 20 hay 50 m\u1eb7t h\u00e0ng th\u00ec sao?<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9964 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/example-3.png\" width=\"803\" height=\"463\" title=\"example-3\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: T\u1ea1o l\u1eadp 1 b\u1ea3ng m\u1edbi, li\u1ec7t k\u00ea t\u1eebng s\u1ea3n ph\u1ea9m ri\u00eang bi\u1ec7t ra c\u00f9ng 1 c\u1ed9t<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: \u0110\u1ec3 tham chi\u1ebfu doanh s\u1ed1 h\u00e0ng \u0111\u01b0\u1ee3c b\u00e1n ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=VLOOKUP(B13,B2:C8,2,FALSE)<\/strong><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: Sau b\u01b0\u1edbc tham chi\u1ebfu \u0111\u1ea7u ti\u00ean, k\u1ebft qu\u1ea3 tham chi\u1ebfu s\u1ebd \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y th\u00e0nh c\u00e1c \u00f4 t\u00e1ch bi\u1ec7t, nhi\u1ec7m v\u1ee5 ti\u1ebfp theo l\u00e0 t\u1ea1o ph\u00e9p to\u00e1n nh\u00e2n b\u1eb1ng c\u00e1ch th\u00eam d\u1ea5u \u201c*\u201d v\u00e0 sau \u0111\u00f3 l\u00e0 m\u1ed9t l\u1ec7nh Vlookup tham chi\u1ebfu gi\u00e1 th\u00e0nh t\u1eebng m\u1eb7t h\u00e0ng m\u1ed9t. C\u1ee5 th\u1ec3 c\u00e2u l\u1ec7nh s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><strong>VLOOKUP(B13,B3:C8,2,FALSE)<\/strong><strong>\u00a0<\/strong><strong>*VLOOKUP(B13,E3:F5,2,FALSE)<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd cho ra doanh thu \u0111\u1ea1t m\u1ee9c 1000.<\/p>\n<p style=\"text-align: justify\"><strong>H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m Vlookup \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p to\u00e1n n\u00e2ng cao<\/strong><\/p>\n<p style=\"text-align: justify\">Vlookup th\u01b0\u1eddng ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 n\u1ebfu nh\u01b0 danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng l\u00e0 ri\u00eang r\u1ebd. N\u1ebfu nh\u01b0 danh s\u00e1ch ch\u1ec9 to\u00e0n ch\u1ee9a duy nh\u1ea5t 1 m\u1eb7t h\u00e0ng th\u00ec Vlookup s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ec9 tham chi\u1ebfu \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 b\u1ecf qua t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 #4<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 n\u00e0y s\u1ebd l\u1eb7p l\u1ea1i v\u00ed d\u1ee5 3 tr\u01b0\u1edbc \u0111\u00f3, nh\u01b0ng c\u00f3 1 ch\u00fat thay \u0111\u1ed5i. Thay v\u00ec b\u00e1n c\u00e1c m\u1eb7t h\u00e0ng kh\u00e1c nhau, ta s\u1ebd ch\u1ec9 b\u00e1n duy nh\u1ea5t 1 m\u1eb7t h\u00e0ng qua c\u00e1c ng\u00e0y kh\u00e1c nhau. \u0110i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 m\u1ed9t m\u1eb7t h\u00e0ng c\u00f3 th\u1ec3 b\u1ecb l\u1eb7p \u0111i l\u1eb7p l\u1ea1i nhi\u1ec1u l\u1ea7n. Ch\u1eb3ng h\u1ea1n, h\u00f4m nay b\u1ea1n c\u00f3 th\u1ec3 b\u00e1n Web Hosting, v\u00e0 ti\u1ebfp t\u1ee5c b\u00e1n sang ng\u00e0y mai ho\u1eb7c ng\u00e0y kia n\u1eefa.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean ta \u0111i t\u00ecm t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a t\u1eebng s\u1ea3n ph\u1ea9m, th\u00f4ng qua h\u00e0m SUMIF nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><strong>SUMIF(B3:B8,B13,C3:C8)<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd cho ra l\u00e0 15. Trong c\u00e2u l\u1ec7nh tr\u00ean<\/p>\n<ul style=\"text-align: justify\">\n<li>B3:B8 l\u00e0 d\u1ea3i \u00f4 ch\u1ee9a c\u00e1c m\u1eb7t h\u00e0ng<\/li>\n<li>B13 l\u00e0 ti\u00eau ch\u00ed x\u00e9t duy\u1ec7t, \u1edf \u0111\u00e2y ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm \u201cWeb Hosting\u201d<\/li>\n<li>C3:C8 l\u00e0 d\u1ea3i \u00f4 ch\u1ee9a t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a n\u00f3 qua t\u1eebng ng\u00e0y<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: Sau khi t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng b\u1ea5t lu\u1eadn c\u00f3 b\u1ecb tr\u00f9ng l\u1eb7p v\u1ec1 m\u1eb7t s\u1ed1 li\u1ec7u hay kh\u00f4ng, ti\u1ebfp theo ta s\u1ebd x\u00e1c \u0111\u1ecbnh gi\u00e1 th\u00e0nh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh \u0111\u01a1n gi\u1ea3n sau:<\/p>\n<p style=\"text-align: justify\"><strong>VLOOKUP(B13,E2:F5,2,FALSE)<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd cho ra l\u00e0 100. Trong c\u00e2u l\u1ec7nh tr\u00ean<\/p>\n<ul style=\"text-align: justify\">\n<li>Web Hosting l\u00e0 gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/li>\n<li>E2:F5 l\u00e0 d\u1ea3i \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb li\u00ean quan \u0111\u1ebfn gi\u00e1 th\u00e0nh s\u1ea3n ph\u1ea9m<\/li>\n<li>2 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tham chi\u1ebfu<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n x\u00e9t duy\u1ec7t l\u00e0 \u201cexact match\u201d<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: Ta s\u1ebd d\u1ee5ng ph\u00e9p nh\u00e2n \u0111\u1ec3 t\u00ednh doanh thu cho t\u1eebng s\u1ea3n ph\u1ea9m<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><strong>SUMIF(B3:B8,B13,C3:C8)*<\/strong> <strong>VLOOKUP(B13,E2:F5,2,FALSE)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9965 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/advancd-vlookup-example.png\" width=\"808\" height=\"484\" title=\"advancd-vlookup-example\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>5 \u0111i\u1ec3m h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m Vlookup<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9966 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-drawbacks.jpeg\" width=\"598\" height=\"412\" title=\"vlookup-drawbacks\"><\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ec9 h\u1ed7 tr\u1ee3 tham chi\u1ebfu t\u1eeb tr\u00e1i sang ph\u1ea3i<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Ph\u1ea7n nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng cho r\u1eb1ng Vlookup ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng theo chi\u1ec1u t\u1eeb tr\u00e1i sang ph\u1ea3i, ch\u1ee9 kh\u00f4ng c\u00f3 chi\u1ec1u \u00a0ng\u01b0\u1ee3c l\u1ea1i. M\u1ed9t s\u1ed1 kh\u00e1c cho r\u1eb1ng \u0111\u1ec3 c\u00f3 th\u1ec3 d\u00f9ng Vlookup tham chi\u1ebfu t\u1eeb ph\u1ea3i sang th\u00ec b\u1eaft bu\u1ed9c ph\u1ea3i k\u1ebft h\u1ee3p nhi\u1ec1u c\u00f4ng th\u1ee9c l\u1ea1i v\u1edbi nhau.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c t\u1ebf m\u00e0 n\u00f3i, vi\u1ec7c k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t thao t\u00e1c kh\u00e1 l\u00e0 r\u1eafc r\u1ed1i v\u00e0 kh\u00f4ng h\u1ec1 d\u1ec5 d\u00e0ng g\u00ec. V\u00ec th\u1ebf \u0111\u00e2y v\u1eabn \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t h\u1ea1n ch\u1ebf l\u1edbn c\u1ee7a Vlookup<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Match &amp; Index<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Vlookup c\u00f3 xu h\u01b0\u1edbng ch\u1ec9 quan t\u00e2m \u0111\u1ebfn gi\u00e1 tr\u1ecb tham chi\u1ebfu \u0111\u1ea7u v\u00e0 b\u1ecf qu\u00ean c\u00e1c d\u00f2ng kh\u00e1c ch\u1ee9a gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1. N\u1ebfu nh\u01b0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 qu\u00e1 nhi\u1ec1u s\u1ef1 ph\u00e2n h\u00f3a th\u00ec b\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e1ch lu\u1eadt m\u1ed9t ch\u00fat \u0111\u1ec3 Vlookup c\u00f3 th\u1ec3 tham chi\u1ebfu \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p: T\u1ea1o m\u1ed9t b\u1ea3ng Pivot ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Vlookup m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tham chi\u1ebfu lu\u00f4n c\u1ed1 \u0111\u1ecbnh<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Vi\u1ec7c s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t tham chi\u1ebfu \u0111\u01b0\u1ee3c \u0111i\u1ec1n th\u1ee7 c\u00f4ng v\u00e0o n\u1ed9i dung c\u1ee7a c\u00f4ng th\u1ee9c khi\u1ebfn cho thao t\u00e1c sao ch\u00e9p sang \u00f4 t\u00ednh kh\u00e1c g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n v\u00e0 b\u1ea5t ti\u1ec7n.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng s\u1ed1 th\u1ee9 t\u1ef1 bi\u1ebfn \u0111\u1ed5i li\u00ean t\u1ee5c th\u00f4ng qua h\u00e0m Match<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>M\u1eb7c \u0111\u1ecbnh thi\u1ebft l\u1eadp \u201capproximate match\u201d<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u1ec3 \u00fd k\u1ef9, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m duy\u1ec7t tham chi\u1ebfu \u1edf trong n\u1ed9i dung h\u00e0m Vlookup l\u00e0 y\u1ebfu t\u1ed1 t\u00f9y ch\u1ecdn (\u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u b\u1eb1ng hai d\u1ea5u ngo\u1eb7c vu\u00f4ng []) n\u00ean n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng \u0111i\u1ec1n n\u1ed9i dung g\u00ec v\u00e0o \u0111\u00f3 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 m\u1eb7c \u0111\u1ecbnh l\u00e0 \u201capproximate match\u201d<\/p>\n<p style=\"text-align: justify\">B\u1ea1n th\u1eadt s\u1ef1 c\u1ea7n ph\u1ea3i ch\u00fa \u00fd n\u1ebfu nh\u01b0 kh\u00f4ng mu\u1ed1n k\u1ebft qu\u1ea3 tham chi\u1ebfu tr\u1edf n\u00ean sai l\u1ec7ch<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p: Lu\u00f4n ch\u00fa \u00fd ph\u1ea3i thi\u1ebft l\u1eadp l\u00e0 \u201cexact match\u201d \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 tham chi\u1ebfu ch\u00ednh x\u00e1c nh\u1ea5t, tuy nhi\u00ean n\u1ebfu b\u1ea1n v\u1eabn mu\u1ed1n ch\u1ecdn thi\u1ebft l\u1eadp m\u1eb7c \u0111\u1ecbnh \u201capproximate match\u201d th\u00ec ph\u1ea3i th\u1eadt s\u1ef1 c\u1ea9n th\u1eadn<\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>L\u00e0m t\u1ed1c \u0111\u1ed9 ph\u1ea3n h\u1ed3i c\u1ee7a b\u1ea3ng t\u00ednh b\u1ecb ch\u1eadm \u0111i<\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1ed9t v\u00e0i \u00fd ki\u1ebfn cho r\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u h\u00e0m Vlookup \u0111\u1ec3 tham chi\u1ebfu s\u1ebd l\u00e0m gi\u1ea3m hi\u1ec7u n\u0103ng c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh, th\u1eadm ch\u00ed g\u00e2y ra hi\u1ec7n t\u01b0\u1ee3ng crash.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p: B\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng h\u00e0m Vlookup c\u1ea7n d\u00f9ng, tuy nhi\u00ean c\u1ed1 g\u1eafng thay th\u1ebf ch\u00fang b\u1eb1ng l\u1ec7nh Paste Special \u0111\u1ec3 thay th\u1ebf c\u00e1c h\u00e0m b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh, \u0111i\u1ec1u \u0111\u00f3 s\u1ebd gi\u00fap ch\u01b0\u01a1ng tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-260.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11126,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11125","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\/11125","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=11125"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11125\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11126"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}