{"id":12368,"date":"2025-01-15T08:25:33","date_gmt":"2025-01-15T08:25:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-cac-ham-tim-kiem-tren-excel-2007-2010-2013-2016\/"},"modified":"2025-01-15T08:25:33","modified_gmt":"2025-01-15T08:25:33","slug":"huong-dan-su-dung-cac-ham-tim-kiem-tren-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-cac-ham-tim-kiem-tren-excel-2007-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm tr\u00ean Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>V\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u th\u1ed1ng k\u00ea l\u1edbn, s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm c\u01a1 b\u1ea3n tr\u00ean Excel c\u00e0ng tr\u1edf n\u00ean c\u1ea7n thi\u1ebft. \u0110\u1ec3 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c d\u1ec5 d\u00e0ng h\u01a1n c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m sau \u0111\u00e2y.\u00a0 \u00a0<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>1. H\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t tr\u00ean Excel\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ee5c \u0111\u00edch l\u00e0 t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 k trong d\u00e3y gi\u00e1 tr\u1ecb l\u1ef1a ch\u1ecdn ho\u1eb7c t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 k trong d\u00e3y gi\u00e1 tr\u1ecb l\u1ef1a ch\u1ecdn. C\u00f3 t\u1ea5t c\u1ea3 4 h\u00e0m t\u00ecm ki\u1ebfm gi\u00fap b\u1ea1n \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch tr\u00ean. Bao g\u1ed3m h\u00e0m: Large, Small, Max v\u00e0 Min.<\/p>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng 4 h\u00e0m t\u00ecm ki\u1ebfm c\u01a1 b\u1ea3n tr\u00ean \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft<a href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html\"> t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<p style=\"text-align: justify\"><strong>2. \u00a0H\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng<\/strong><\/p>\n<p style=\"text-align: justify\"><em>\u0110\u1ecbnh ngh\u0129a:<\/em> B\u1eb1ng v\u1ecb tr\u00ed giao nhau gi\u1eefa d\u00f2ng v\u00e0 c\u1ed9t \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh, th\u00f4ng qua<strong> h\u00e0m INDEX<\/strong>, Excel s\u1ebd \u0111\u01b0a ra gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi quy chi\u1ebfu.<\/p>\n<p style=\"text-align: justify\">Kh\u00e1c v\u1edbi h\u00e0m t\u00ecm ki\u1ebfm VLOOKUP ch\u1ec9 c\u00f3 th\u1ec3 qu\u00e9t t\u00ecm t\u1eeb tr\u00e1i qua ph\u1ea3i, h\u00e0m t\u00ecm ki\u1ebfm INDEX c\u00f3 kh\u1ea3 n\u0103ng t\u00ecm ki\u1ebfm r\u1ed9ng h\u01a1n v\u00e0 ch\u1eafc ch\u1eafn thu\u1eadn ti\u1ec7n h\u01a1n.<\/p>\n<p style=\"text-align: justify\">H\u00e0m INDEX c\u00f3 hai ph\u01b0\u01a1ng th\u1ee9c th\u1ec3 hi\u1ec7n:<\/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-389.gif\" title=\"ex101_92019-nho-389\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li>c\u00e1ch 1: <em><strong>=INDEX(Array, Row_num, [Column_num])<\/strong><\/em><\/li>\n<li>c\u00e1ch 2: <em><strong>=INDEX(Reference, Row_num, [Column_num], [Area_num])\u00a0<\/strong><\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong c\u00e1c ho\u00e0n c\u1ea3nh t\u01b0\u01a1ng th\u00edch, c\u00e1c b\u1ea1n t\u00f9y \u00fd s\u1eed d\u1ee5ng m\u1ed9t trong hai ph\u01b0\u01a1ng th\u1ee9c tr\u00ean. V\u00ed d\u1ee5 sau \u0111\u00e2y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00e1ch 1 \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n<figure id=\"attachment_3301\" aria-describedby=\"caption-attachment-3301\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3301\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-27.png\" width=\"600\" height=\"247\" title=\"1-27\"><figcaption id=\"caption-attachment-3301\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng b\u1ea3ng th\u1ed1ng k\u00ea m\u00e3 h\u00e0ng l\u00e0m v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1:<\/strong> S\u1eed d\u1ee5ng h\u00e0m MAX \u0111\u1ec3 t\u00ecm ra l\u01b0\u1ee3ng ti\u00eau th\u1ee5 l\u1edbn nh\u1ea5t v\u00e0 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn nh\u1ea5t (h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t <a href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html\">t\u1ea1i \u0111\u00e2y<\/a>) Trong v\u00ed d\u1ee5,<em><strong> h\u00e0m MAX<\/strong><\/em> \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>L\u01b0\u1ee3ng ti\u00eau thu l\u1edbn nh\u1ea5t: <em><strong>=MAX(B3:B11)<\/strong><\/em><\/li>\n<li>L\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn nh\u1ea5t: <em><strong>=MAX(C3:C11)\u00a0<\/strong><\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\">D\u00f5i theo h\u00ecnh \u0111\u1ed9ng n\u00e0y \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch th\u1ef1c hi\u1ec7n c\u1ee7a h\u00e0m t\u00ecm ki\u1ebfm MAX.<\/p>\n<figure id=\"attachment_3302\" aria-describedby=\"caption-attachment-3302\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3302\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/c1-1.gif\" width=\"600\" height=\"259\" title=\"c1-1\"><figcaption id=\"caption-attachment-3302\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t MAX<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2:<\/strong> S\u1eed d\u1ee5ng h\u00e0m <strong>INDEX<\/strong> \u0111\u1ec3 t\u00ecm m\u00e3 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 h\u00e0ng n\u00e0o c\u00f3 l\u01b0\u1ee3ng ti\u00eau th\u1ee5 l\u1edbn nh\u1ea5t v\u00e0 m\u00e3 h\u00e0ng n\u00e0o c\u00f3 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn nh\u1ea5t:<\/p>\n<ul style=\"text-align: justify\">\n<li>M\u00e3 h\u00e0ng c\u00f3 l\u01b0\u1ee3ng ti\u00eau th\u1ee5 l\u1edbn nh\u1ea5t: <em><strong>=INDEX(A3:A11, MATCH(H2,B3:B11,0))<\/strong><\/em><\/li>\n<li>M\u00e3 h\u00e0ng c\u00f3 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn nh\u1ea5t: <em><strong>=INDEX(A3:A11, MATCH(H4,C3:C11,0))<\/strong><\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li>A3:A11 x\u00e1c \u0111\u1ecbnh v\u00f9ng t\u00ecm m\u00e3 h\u00e0ng<\/li>\n<li>MATCH(v\u1ecb tr\u00ed gi\u00e1 tr\u1ecb l\u01b0\u1ee3ng ti\u00eau th\u1ee5 l\u1edbn nh\u1ea5t v\u1eeba t\u00ecm \u0111\u01b0\u1ee3c, gi\u00e1 tr\u1ecb l\u01b0\u1ee3ng ti\u00eau th\u1ee5 l\u1edbn nh\u1ea5t t\u00ecm th\u1ea5y trong v\u00f9ng B3:B11, 0) \u2014 t\u01b0\u01a1ng t\u1ef1 v\u1edbi l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn nh\u1ea5t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Quan s\u00e1t h\u00ecnh \u0111\u1ed9ng sau \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch th\u1ef1c hi\u1ec7n c\u1ee7a h\u00e0m t\u00ecm ki\u1ebfm INDEX n\u00e0y.<\/p>\n<figure id=\"attachment_3305\" aria-describedby=\"caption-attachment-3305\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3305\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/c2.gif\" width=\"600\" height=\"258\" title=\"c2\"><figcaption id=\"caption-attachment-3305\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m t\u00ecm ki\u1ebfm INDEX<\/figcaption><\/figure>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/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-389.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12369,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12368","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\/12368","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=12368"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12368\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12369"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}