{"id":2693,"date":"2024-12-02T08:27:01","date_gmt":"2024-12-02T08:27:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vlookup-va-lookup-chung-khac-nhau-nhu-the-nao\/"},"modified":"2024-12-02T08:27:01","modified_gmt":"2024-12-02T08:27:01","slug":"vlookup-va-lookup-chung-khac-nhau-nhu-the-nao","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vlookup-va-lookup-chung-khac-nhau-nhu-the-nao\/","title":{"rendered":"VLOOKUP v\u00e0 LOOKUP: Ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\"><strong>H\u00e0m LOOKUP<\/strong> c\u00f3 ch\u1ee9c n\u0103ng ch\u00e9o c\u00f3 ngh\u0129a l\u00e0 n\u00f3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u1ea3 tra c\u1ee9u d\u1ecdc v\u00e0 tra c\u1ee9u ngang. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n t\u00ecm ra <a href=\"http:\/\/blog.ezworkapp.com\/vlookup-va-lookup-chung-khac-nhau-nhu-the-nao.html\"><strong>\u0111i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa h\u00e0m Vlookup v\u00e0 h\u00e0m Lookup<\/strong><\/a> qua c\u00e1c v\u00ed d\u1ee5; \u0111\u1ed3ng th\u1eddi ch\u1ec9 ra \u0111i\u1ec3m m\u1ea1nh \u0111i\u1ec3m y\u1ebfu \u0111\u1ec3 b\u1ea1n v\u1eadn d\u1ee5ng ch\u00fang trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p.\u00a0<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d6f5472319\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/vlookup-va-lookup-chung-khac-nhau-nhu-the-nao.html#LOOKUP_duoc_gioi_han_o_Doi_sanh_gan_dung\" title=\"LOOKUP \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n \u1edf \u0110\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang\">LOOKUP \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n \u1edf \u0110\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/vlookup-va-lookup-chung-khac-nhau-nhu-the-nao.html#LOOKUP_la_chuc_nang_cheo\" title=\"LOOKUP l\u00e0 ch\u1ee9c n\u0103ng ch\u00e9o\">LOOKUP l\u00e0 ch\u1ee9c n\u0103ng ch\u00e9o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"LOOKUP_duoc_gioi_han_o_Doi_sanh_gan_dung\"><\/span><b>LOOKUP \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n \u1edf \u0110\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">S\u1ef1 kh\u00e1c bi\u1ec7t ch\u00ednh l\u00e0<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>ch\u1ec9 gi\u1edbi h\u1ea1n trong vi\u1ec7c tra c\u1ee9u theo chi\u1ec1u d\u1ecdc c\u00f2n <a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\"><strong>h\u00e0m LOOKUP<\/strong><\/a> c\u00f3 ch\u1ee9c n\u0103ng ch\u00e9o c\u00f3 ngh\u0129a l\u00e0 n\u00f3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u1ea3 tra c\u1ee9u d\u1ecdc v\u00e0 tra c\u1ee9u ngang.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00fa ph\u00e1p h\u00e0m VLOOKUP: <\/span><span style=\"font-weight: 400\">VLOOKUP(Lookup Value, Table Array, Column to Return, Approximate Match [True\/False])<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00fa ph\u00e1p LOOKUP: <\/span><span style=\"font-weight: 400\">LOOKUP(Lookup Value, Lookup Array, Value to Return Array)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng h\u00e0m LOOKUP kh\u00f4ng c\u00f3 t\u00f9y ch\u1ecdn True\/False<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi V\u00ed d\u1ee5 n\u00e0y, h\u00e3y thi\u1ebft l\u1eadp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u1ec3 C\u1ed9t A l\u00e0 m\u1ea3ng tra c\u1ee9u v\u00e0 C\u1ed9t B l\u00e0 m\u1ea3ng Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 E2, nh\u1eadp gi\u00e1 tr\u1ecb tra c\u1ee9u c\u1ee7a b\u1ea1n<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 E3, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y<\/span><span style=\"font-weight: 400\"> \u201c<\/span><span style=\"font-weight: 400\">=LOOKUP(E2,A3:A8,B3:B8)<\/span><span style=\"font-weight: 400\">\u201d<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34771\" aria-describedby=\"caption-attachment-34771\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34771 size-full\" title=\"1- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-14.png\" alt=\"1- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" width=\"480\" height=\"202\"><figcaption id=\"caption-attachment-34771\" class=\"wp-caption-text\">1- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong V\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng c\u00f4ng th\u1ee9c \u0111\u00e3 ch\u1ecdn sai \u201cJohn\u201d do \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang m\u1eb7c \u0111\u1ecbnh. B\u00e2y gi\u1edd, h\u00e3y th\u1eed t\u1ea1o ph\u00e9p t\u00ednh t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng h\u00e0m VLOOKUP.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o \u00f4 E3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\">\u201c<\/span><span style=\"font-weight: 400\">=VLOOKUP(E2,A3:B8,2,FALSE)<\/span><span style=\"font-weight: 400\">\u201d<\/span><\/p>\n<figure id=\"attachment_34772\" aria-describedby=\"caption-attachment-34772\" style=\"width: 504px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34772 size-full\" title=\"2- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-13.png\" alt=\"2- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" width=\"504\" height=\"196\"><figcaption id=\"caption-attachment-34772\" class=\"wp-caption-text\">2- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y t\u1eeb v\u00ed d\u1ee5 VLOOKUP r\u1eb1ng c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i v\u00ec kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c cho \u201c3\u201d trong m\u1ea3ng tra c\u1ee9u.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"LOOKUP_la_chuc_nang_cheo\"><\/span><b>LOOKUP l\u00e0 ch\u1ee9c n\u0103ng ch\u00e9o<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong V\u00ed d\u1ee5 h\u00e0m LOOKUP tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 x\u00e1c \u0111\u1ecbnh kh\u1ea3 n\u0103ng tra c\u1ee9u theo chi\u1ec1u d\u1ecdc c\u1ee7a h\u00e0m LOOKUP. Nh\u01b0ng nh\u01b0 m\u00ecnh \u0111\u00e3 n\u00f3i \u1edf \u0111\u1ea7u b\u00e0i, n\u00f3 c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u theo chi\u1ec1u ngang.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd l\u1ea5y c\u00f9ng m\u1ed9t d\u1eef li\u1ec7u v\u00e0 gi\u1ea3 s\u1eed n\u00f3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u ngang.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong ROW 1, nh\u1eadp m\u1ea3ng tra c\u1ee9u, nh\u1eadp m\u1ea3ng tr\u1ea3 v\u1ec1 trong ROW 2<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp \u201c4\u201d v\u00e0o \u00f4 B4<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 B5, nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y <\/span><span style=\"font-weight: 400\">\u201c<\/span><span style=\"font-weight: 400\">=LOOKUP(B4,B1:G1,B2:G2)<\/span><span style=\"font-weight: 400\">\u201d<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_34773\" aria-describedby=\"caption-attachment-34773\" style=\"width: 559px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34773 size-full\" title=\"3- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-13.png\" alt=\"3- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?\" width=\"559\" height=\"141\"><figcaption id=\"caption-attachment-34773\" class=\"wp-caption-text\">3- VLOOKUP v\u00e0 LOOKUP kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y trong v\u00ed d\u1ee5 n\u00e0y r\u1eb1ng h\u00e0m LOOKUP \u0111\u00e3 tr\u1ea3 v\u1ec1 th\u00f4ng tin ch\u00ednh x\u00e1c t\u1eeb b\u1ea3ng m\u1eb7c d\u00f9 n\u00f3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u ngang.<br \/>\n<em>Qua c\u00e1c v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n ta \u0111\u00e3 c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t c\u01a1 b\u1ea3n gi\u1eefa 2 h\u00e0m tra c\u1ee9u n\u00e0y. Hy v\u1ecdng c\u00e1c b\u1ea1n s\u1ebd v\u1eadn d\u1ee5ng t\u1ed1t ch\u00fang trong th\u1ef1c ti\u1ec5n. <strong>H\u1ecdc Excel Online<\/strong> xin ch\u00e0o v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong c\u00e1c chuy\u00ean m\u1ee5c ti\u1ebfp theo!\u00a0<\/em><\/span><\/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=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/09\/EX101_92019-nho.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2694,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2693","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\/2693","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=2693"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2694"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}