{"id":872,"date":"2023-08-26T00:55:19","date_gmt":"2023-08-25T17:55:19","guid":{"rendered":"https:\/\/trannghiait.com\/?p=872"},"modified":"2023-08-26T00:55:19","modified_gmt":"2023-08-25T17:55:19","slug":"huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m VLOOKUP cho d\u00e2n v\u0103n ph\u00f2ng"},"content":{"rendered":"\n<p>H\u00e0m VLOOKUP trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh. Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t c\u1ed9t v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb c\u1ed9t kh\u00e1c trong b\u1ea3ng t\u00ednh \u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i s\u00e2u v\u00e0o c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u trong Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong\/#Cu_phap_cua_ham_VLOOKUP\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong\/#Cach_su_dung_ham_VLOOKUP\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong\/#Luu_y_khi_su_dung_ham_VLOOKUP\" title=\"L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_VLOOKUP\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=VLOOKUP(lookup_value, table_array, col_index_num, &#91;range_lookup])<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>lookup_value<\/code>: gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><code>table_array<\/code>: b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n truy xu\u1ea5t.<\/li>\n\n\n\n<li><code>col_index_num<\/code>: s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1.<\/li>\n\n\n\n<li><code>range_lookup<\/code> (t\u00f9y ch\u1ecdn): ch\u1ec9 \u0111\u1ecbnh xem b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c ho\u1eb7c g\u1ea7n \u0111\u00fang. N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp gi\u00e1 tr\u1ecb n\u00e0y, Excel s\u1ebd gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_VLOOKUP\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, ch\u00fang ta s\u1ebd xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n. H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 gi\u00e1 c\u1ee7a ch\u00fang nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>S\u1ea3n ph\u1ea9m<\/th><th>Gi\u00e1<\/th><\/tr><\/thead><tbody><tr><td>S\u1ea3n ph\u1ea9m A<\/td><td>100<\/td><\/tr><tr><td>S\u1ea3n ph\u1ea9m B<\/td><td>200<\/td><\/tr><tr><td>S\u1ea3n ph\u1ea9m C<\/td><td>300<\/td><\/tr><tr><td>S\u1ea3n ph\u1ea9m D<\/td><td>400<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m B. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=VLOOKUP(\"S\u1ea3n ph\u1ea9m B\",A1:B5,2,FALSE)<\/code><\/pre>\n\n\n\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>lookup_value<\/code> l\u00e0 <code>\"S\u1ea3n ph\u1ea9m B\"<\/code>, t\u1ee9c l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><code>table_array<\/code> l\u00e0 <code>A1:B5<\/code>, t\u1ee9c l\u00e0 ph\u1ea1m vi c\u1ee7a b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n truy xu\u1ea5t.<\/li>\n\n\n\n<li><code>col_index_num<\/code> l\u00e0 <code>2<\/code>, t\u1ee9c l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u1ed9t Gi\u00e1).<\/li>\n\n\n\n<li><code>range_lookup<\/code> \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u00e0nh <code>FALSE<\/code>, t\u1ee9c l\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<p>Khi b\u1ea1n nh\u1ea5n Enter, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 <code>200<\/code>, t\u1ee9c l\u00e0 gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m B.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Luu_y_khi_su_dung_ham_VLOOKUP\"><\/span>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>H\u00e0m VLOOKUP ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo c\u1ed9t \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm. N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo c\u1ed9t n\u00e0y, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 th\u1ec3 kh\u00f4ng ch\u00ednh x\u00e1c.<\/li>\n\n\n\n<li>N\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng t\u00ednh, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #N\/A.<\/li>\n\n\n\n<li>N\u1ebfu range_lookup \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u00e0nh TRUE ho\u1eb7c kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp, h\u00e0m VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t. Tuy nhi\u00ean, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra sai s\u00f3t n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n\n\n\n<li>N\u1ebfu range_lookup \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u00e0nh FALSE, h\u00e0m VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm t\u1ed3n t\u1ea1i trong b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u00e0m VLOOKUP trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh. <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-thanh-thao-ham-vlookup-cho-dan-van-phong\/\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m VLOOKUP cho d\u00e2n v\u0103n ph\u00f2ng\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=872"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/872\/revisions"}],"predecessor-version":[{"id":873,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/872\/revisions\/873"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}