{"id":12176,"date":"2025-01-15T07:29:49","date_gmt":"2025-01-15T07:29:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-dget-ham-trich-mot-gia-tri-tu-co-so-du-lieu-khop-voi-dieu-kien-trong-excel\/"},"modified":"2025-01-15T07:29:49","modified_gmt":"2025-01-15T07:29:49","slug":"ham-dget-ham-trich-mot-gia-tri-tu-co-so-du-lieu-khop-voi-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-dget-ham-trich-mot-gia-tri-tu-co-so-du-lieu-khop-voi-dieu-kien-trong-excel\/","title":{"rendered":"H\u00e0m DGET \u2013 H\u00e0m tr\u00edch m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1edbp v\u1edbi \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m DGET trong excel l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n tr\u00edch m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb trong m\u1ed9t c\u1ed9t danh s\u00e1ch hay trong 1 c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1edbp v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/strong><\/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-678763eae21d4\" 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-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-dget-ham-trich-mot-gia-tri-tu-co-du-lieu-khop-voi-dieu-kien-trong-excel.html#Cu_phap_DGETdatabase_field_criteria\" title=\"C\u00fa ph\u00e1p: =DGET(database, field, criteria).\">C\u00fa ph\u00e1p: =DGET(database, field, criteria).<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-dget-ham-trich-mot-gia-tri-tu-co-du-lieu-khop-voi-dieu-kien-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Cu_phap_DGETdatabase_field_criteria\"><\/span>C\u00fa ph\u00e1p: =<strong>DGET(database, field, criteria)<\/strong>.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><em>Trong \u0111\u00f3<\/em>:<\/p>\n<p>\u2013 <strong><em>database:<\/em> <\/strong>L\u00e0 danh s\u00e1ch hay c\u01a1 s\u1edf d\u1eef li\u1ec7u, v\u1edbi c\u00e1c h\u00e0ng l\u00e0 th\u00f4ng tin c\u00e1c b\u1ea3n ghi, c\u00e1c c\u1ed9t d\u1eef li\u1ec7u l\u00e0 c\u00e1c tr\u01b0\u1eddng v\u00e0 h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch ph\u1ea3i ch\u1ee9a ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t.<\/p>\n<p>\u2013<strong><em> field:<\/em> <\/strong>T\u00ean tr\u01b0\u1eddng (c\u1ed9t) d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c d\u00f9ng trong h\u00e0m, c\u00f3 th\u1ec3 nh\u1eadp t\u00ean c\u1ed9t, v\u1ecb tr\u00ed c\u1ed9t ho\u1eb7c th\u1ee9 t\u1ef1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>\u2013 <strong><em>criteria:<\/em> <\/strong>L\u00e0 ph\u1ea1m vi \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh. Ph\u1ea1m vi \u00f4 ph\u1ea3i ch\u1ee9a ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 ch\u1ee9a \u00edt nh\u1ea5t 1 gi\u00e1 tr\u1ecb n\u1eb1m trong ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/p>\n<p><em><strong>L\u01b0u \u00fd:<\/strong><\/em><\/p>\n<p>\u2013 Tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n =&gt; h\u00e0m tr\u1ea3 v\u1ec1 l\u1ed7i <strong>#VALUE!<\/strong><\/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-363.gif\" title=\"ex101_92019-nho-363\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2013 Tr\u01b0\u1eddng h\u1ee3p c\u00f3 qu\u00e1 nhi\u1ec1u b\u1ea3n ghi ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n =&gt; h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i <strong>#NUM!<\/strong><\/p>\n<p>\u2013 C\u00f3 th\u1ec3 d\u00f9ng b\u1ea5t k\u00ec ph\u1ea1m vi n\u00e0o cho \u0111\u1ed1i s\u1ed1 <em><strong>criteria<\/strong> <\/em>sao cho n\u00f3 c\u00f3 ch\u1ee9a ti\u00eau \u0111\u1ec3 c\u1ed9t v\u00e0 \u00edt nh\u1ea5t 1 gi\u00e1 tr\u1ecb n\u1eb1m trong ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/p>\n<blockquote>\n<p>N\u00ean xem: <a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">H\u00e0m Excel c\u01a1 b\u1ea3n <\/a><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Cho b\u1ea3ng s\u1ed1 li\u1ec7u sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3887 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dget.png\" width=\"600\" height=\"418\" title=\"ham-dget\"><\/p>\n<p><strong>1<\/strong>\/ V\u1edbi \u0111i\u1ec1u ki\u1ec7n: \u201c<em><strong>Gi\u1ea3m gi\u00e1 5%<\/strong><\/em>\u201c, d\u00f9ng h\u00e0m DGET v\u1edbi c\u00f4ng th\u1ee9c: <strong>=DGET(A7:G15;G7;G2:G3) <\/strong>tr\u00edch \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3888 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dget-1.png\" width=\"600\" height=\"321\" title=\"ham-dget-1\"><\/p>\n<p><strong>2<\/strong>\/ \u0110i\u1ec1u ki\u1ec7n \u201c<strong>*<em>?%\u201d ,<\/em>\u00a0<\/strong>c\u00f4ng th\u1ee9c<em>\u00a0<\/em><strong>=DGET(A7:G15;G7;G2:G3)\u00a0<\/strong>\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0\u00a0 <strong>#NUM!\u00a0\u00a0<\/strong>v\u00ec c\u00f3 qu\u00e1 nhi\u1ec1u k\u1ebft qu\u1ea3 \u00a0ph\u00f9 h\u1ee3p trong b\u1ea3ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3889 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dget-2.png\" width=\"600\" height=\"308\" title=\"ham-dget-2\"><\/p>\n<p><strong>3<\/strong>\/\u00a0\u0110i\u1ec1u ki\u1ec7n \u201c<strong>*2%<em>\u201d ,\u00a0<\/em><\/strong>c\u00f4ng th\u1ee9c<strong>\u00a0=DGET(A7:G15;G7;G2:G3)\u00a0<\/strong>\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0\u00a0 <strong>#VALUE!\u00a0<\/strong>v\u00ec kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 n\u00e0o th\u00f5a m\u00e3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3890 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-dget-3.png\" width=\"600\" height=\"306\" title=\"ham-dget-3\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\">L\u1edbp h\u1ecdc Excel \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\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-363.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12176","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\/12176","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=12176"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12177"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}