{"id":8921,"date":"2024-12-29T17:06:26","date_gmt":"2024-12-29T17:06:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-tim-don-gia-cua-ma-hang-duoc-tao-boi-cac-ky-tu-ghep-lai-bang-ham-vlookup\/"},"modified":"2024-12-29T17:06:26","modified_gmt":"2024-12-29T17:06:26","slug":"huong-dan-tim-don-gia-cua-ma-hang-duoc-tao-boi-cac-ky-tu-ghep-lai-bang-ham-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-tim-don-gia-cua-ma-hang-duoc-tao-boi-cac-ky-tu-ghep-lai-bang-ham-vlookup\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00ecm \u0111\u01a1n gi\u00e1 c\u1ee7a m\u00e3 h\u00e0ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c k\u00fd t\u1ef1 gh\u00e9p l\u1ea1i b\u1eb1ng h\u00e0m VLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong\u00a0vi\u1ec7c qu\u1ea3n l\u00fd h\u00e0ng h\u00f3a, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng qu\u1ea3n l\u00fd chi ti\u1ebft t\u1edbi t\u1eebng\u00a0m\u00e3 h\u00e0ng ri\u00eang. Nh\u1eefng m\u1eb7t h\u00e0ng c\u00f3 m\u00e3 ch\u1ee9a m\u1ed9t s\u1ed1\u00a0k\u00fd t\u1ef1 gi\u1ed1ng nhau c\u00f3 th\u1ec3 v\u1eabn l\u00e0 1 m\u1eb7t h\u00e0ng, ch\u1ec9 kh\u00e1c v\u1ec1 ki\u1ec3u d\u00e1ng, m\u00e0u s\u1eafc. Do\u00a0\u0111\u00f3 l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3\u00a0t\u00ecm \u0111\u01a1n gi\u00e1 c\u1ee7a m\u00e3 h\u00e0ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c k\u00fd t\u1ef1 gh\u00e9p\u00a0l\u1ea1i b\u1eb1ng h\u00e0m VLOOKUP? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n h\u00ecnh dung\u00a0\u0111\u01b0\u1ee3 y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26447\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-tim-don-gia-theo-ma-ghep-1024x309-1.png\" width=\"800\" height=\"241\" title=\"de-bai-tim-don-gia-theo-ma-ghep-1024x309-1\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u00f3 1 b\u1ea3ng theo d\u00f5i b\u00e1n h\u00e0ng. M\u1ed7i m\u00e3 h\u00e0ng g\u1ed3m nhi\u1ec1u k\u00fd t\u1ef1. Nh\u01b0ng trong B\u1ea3ng gi\u00e1, c\u00e1c m\u00e3 h\u00e0ng ch\u1ec9 l\u00e0 c\u00e1c k\u00fd t\u1ef1\u00a0\u0111\u1ea1i gh\u00e9p gi\u1eefa 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u v\u1edbi 2 k\u00fd t\u1ef1 cu\u1ed1i c\u1ee7a m\u1ed7i m\u00e3 h\u00e0ng, ch\u1ee9 kh\u00f4ng ph\u1ea3i to\u00e0n b\u1ed9 chi ti\u1ebft t\u1eebng m\u00e3 h\u00e0ng.<\/p>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng trong b\u1ea3ng theo d\u00f5i b\u00e1n h\u00e0ng?<\/p>\n<h3>C\u00e1ch t\u00ecm \u0111\u01a1n gi\u00e1 c\u1ee7a m\u00e3 h\u00e0ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c k\u00fd t\u1ef1 gh\u00e9p l\u1ea1i b\u1eb1ng h\u00e0m VLOOKUP<\/h3>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh m\u00e3 gh\u00e9p d\u1ef1a v\u00e0o m\u1ed7i m\u00e3 h\u00e0ng <\/strong>(m\u00f4 t\u1ea3 tr\u00ean 1 b\u1ea3ng ri\u00eang)<\/p>\n<p>\u0110\u1ec3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u c\u1ee7a m\u1ed7i m\u00e3 h\u00e0ng, ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\">h\u00e0m LEFT<\/a>, l\u1ea5y theo 2 k\u00fd t\u1ef1<\/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\/2024\/12\/ex101_92019-nho-838.gif\" title=\"ex101_92019-nho-838\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c 2 k\u00fd t\u1ef1 cu\u1ed1i c\u1ee7a m\u1ed7i m\u00e3 h\u00e0ng, ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">h\u00e0m RIGHT<\/a>, l\u1ea5y theo 2 k\u00fd t\u1ef1<\/p>\n<p>\u0110\u1ec3 n\u1ed1i k\u1ebft qu\u1ea3 t\u1ea1o\u00a0\u0111\u01b0\u1ee3c b\u1edfi h\u00e0m LEFT v\u00e0 h\u00e0m RIGHT\u00a0\u1edf tr\u00ean, ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\">h\u00e0m CONCAT<\/a> nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26449\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cat-ghep-ky-tu.png\" width=\"664\" height=\"289\" title=\"cat-ghep-ky-tu\"><\/p>\n<p>D\u1ef1a v\u00e0o logic tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 c\u00f3 1 h\u00e0m t\u1ed5ng h\u1ee3p\u00a0\u0111\u1ec3 l\u1ea5y 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u gh\u00e9p v\u1edbi 2 k\u00fd t\u1ef1 cu\u1ed1i c\u1ee7a m\u1ed7i m\u00e3 h\u00e0ng l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">=CONCAT(LEFT(A2, 2), RIGHT(A2, 2))<\/p>\n<p><strong>B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 h\u00e0m CONCAT trong h\u00e0m VLOOKUP<\/strong><\/p>\n<p>M\u00e3 t\u1ea1o b\u1edfi h\u00e0m CONCAT ch\u00ednh l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 tham chi\u1ebfu t\u1edbi b\u1ea3ng gi\u00e1. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Lookup_value<\/strong>: gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m CONCAT<\/li>\n<li><strong>Lookup_array<\/strong>: v\u00f9ng b\u1ea3ng tham chi\u1ebfu l\u00e0 b\u1ea3ng gi\u00e1 (I3:K6)<\/li>\n<li><strong>Col_index_num<\/strong>: c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 l\u00e0 c\u1ed9t\u00a0\u0110\u01a1n gi\u00e1 (c\u1ed9t th\u1ee9 3 trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1)<\/li>\n<li><strong>Range_lookup<\/strong>: ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm l\u00e0 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo m\u00e3 h\u00e0ng, s\u1eed d\u1ee5ng s\u1ed1 0<\/li>\n<\/ul>\n<p>ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26455\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-ham-vlookup-ket-hop-concat-1024x353-1.png\" width=\"1024\" height=\"353\" title=\"ket-qua-ham-vlookup-ket-hop-concat-1024x353-1\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a c\u00e1c m\u1eb7t h\u00e0ng d\u1ef1a theo vi\u1ec7c gh\u00e9p 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u v\u00e0 cu\u1ed1i c\u1ee7a m\u00e3 h\u00e0ng r\u1ed3i.<\/p>\n<p>Qua v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam\u00a0\u0111\u01b0\u1ee3c c\u00e1ch l\u1ed3ng gh\u00e9p c\u00e1c c\u00f4ng th\u1ee9c trong c\u00f9ng 1 h\u00e0m\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n cho nh\u1eefng y\u00eau c\u1ea7u ph\u1ee9c t\u1ea1p trong\u00a0Excel.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f3 ch\u1ee7\u00a0\u0111\u1ec1 t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">H\u00e0m vlookup trong Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng n\u00e2ng cao th\u01b0\u1eddng g\u1eb7p<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html\">H\u00e0m VLOOKUP n\u00e2ng cao, l\u1ed3ng vlookup v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed, tra c\u1ee9u hai chi\u1ec1u<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn 4 c\u00e1ch x\u00e1c \u0111\u1ecbnh \u0111\u01a1n gi\u00e1 theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/a><\/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\/2024\/12\/ex101_92019-nho-838.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8922,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8921","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\/8921","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=8921"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8921\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8922"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}