{"id":9248,"date":"2025-01-01T23:06:47","date_gmt":"2025-01-01T23:06:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-ham-cell-tra-cuu-thong-tin-o-trong-excel\/"},"modified":"2025-01-01T23:06:47","modified_gmt":"2025-01-01T23:06:47","slug":"huong-dan-ham-cell-tra-cuu-thong-tin-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-ham-cell-tra-cuu-thong-tin-o-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m CELL tra c\u1ee9u th\u00f4ng tin \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-cell-thong-tin-o.html\"><strong>h\u00e0m CELL<\/strong><\/a>, m\u1ed9t h\u00e0m s\u1ebd gi\u00fap \u00edch khi b\u1ea1n mu\u1ed1n tra c\u1ee9u th\u00f4ng tin trong m\u1ed9t \u00f4.<\/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-6775ca87008d7\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-cell-thong-tin-o.html#Ham_CELL_cong_dung_va_cu_phap\" title=\"H\u00e0m CELL, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m CELL, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-cell-thong-tin-o.html#Cong_dung_ham_CELL\" title=\"C\u00f4ng d\u1ee5ng h\u00e0m CELL\">C\u00f4ng d\u1ee5ng h\u00e0m CELL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-cell-thong-tin-o.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-ham-cell-thong-tin-o.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_CELL_cong_dung_va_cu_phap\"><\/span>H\u00e0m CELL, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung_ham_CELL\"><\/span>C\u00f4ng d\u1ee5ng h\u00e0m CELL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m CELL\u00a0tr\u1ea3 v\u1ec1 th\u00f4ng tin v\u1ec1 \u0111\u1ecbnh d\u1ea1ng, v\u1ecb tr\u00ed hay n\u1ed9i dung c\u1ee7a m\u1ed9t \u00f4 theo c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=CELL(info_type, [reference])<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>info_type:<\/strong>\u00a0Gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n x\u00e1c \u0111\u1ecbnh b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 ki\u1ec3u th\u00f4ng tin \u00f4 n\u00e0o<\/p>\n<p><strong>reference:\u00a0<\/strong>kh\u00f4ng b\u1eaft bu\u1ed9c.\u00a0\u00d4 m\u00e0 b\u1ea1n mu\u1ed1n c\u00f3 th\u00f4ng tin.<\/p>\n<p><strong>L\u01b0u \u00fd:\u00a0<\/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-27.gif\" title=\"ex101_92019-nho-27\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>N\u1ebfu b\u1ecb b\u1ecf qua, th\u00f4ng tin \u0111\u00e3 x\u00e1c \u0111\u1ecbnh trong Info_type \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 cho \u00f4 cu\u1ed1i c\u00f9ng \u0111\u00e3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i.<\/li>\n<li>N\u1ebfu tham chi\u1ebfu m\u1ed9t v\u00f9ng, h\u00e0m CELL ch\u1ec9 tr\u1ea3 v\u1ec1 th\u00f4ng tin cho \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng \u0111\u00f3.<\/li>\n<\/ol>\n<p>V\u00ed d\u1ee5 gi\u00e1 tr\u1ecb\u00a0<strong>info_type<\/strong> nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25145\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-cell-1.png\" width=\"211\" height=\"251\" title=\"ham-cell-1\"><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>address\u00a0<\/strong>\u0111\u01b0a ra tham chi\u1ebfu c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean trong tham chi\u1ebfu, \u1edf d\u1ea1ng v\u0103n b\u1ea3n<\/p>\n<p><strong>col\u00a0<\/strong>tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ed9t c\u1ee7a \u00f4 trong tham chi\u1ebfu<\/p>\n<p><strong>color\u00a0<\/strong>\u0111\u01b0a gi\u00e1 tr\u1ecb 1 n\u1ebfu \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng m\u00e0u cho c\u00e1c gi\u00e1 tr\u1ecb \u00e2m; n\u1ebfu kh\u00f4ng s\u1ebd tr\u1ea3 v\u1ec1 0 (kh\u00f4ng)<\/p>\n<p><strong>contents\u00a0<\/strong>\u0111\u01b0a ra gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu<\/p>\n<p><strong>filename<\/strong> tr\u1ea3 v\u1ec1 t\u00ean file. Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 b\u1eb1ng r\u1ed7ng (\u201c\u201d) n\u1ebfu file ch\u01b0a l\u01b0u<\/p>\n<p><strong>format<\/strong> \u0111\u01b0a ra \u0111\u1ecbnh d\u1ea1ng file theo b\u1ea3ng b\u00ean d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25147\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-cell-2.png\" width=\"442\" height=\"397\" title=\"ham-cell-2\"><\/p>\n<p><strong>parentheses\u00a0<\/strong>tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 1 n\u1ebfu \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u1edbi d\u1ea5u ngo\u1eb7c \u0111\u01a1n cho gi\u00e1 tr\u1ecb d\u01b0\u01a1ng, n\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 0.<\/p>\n<p><strong>prefix\u00a0<\/strong>tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u201cti\u1ec1n t\u1ed1 nh\u00e3n\u201d c\u1ee7a \u00f4. Tr\u1ea3 v\u1ec1 (\u2018) n\u1ebfu \u00f4 ch\u1ee9a v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c canh tr\u00e1i, (\u201c) n\u1ebfu \u00f4 ch\u1ee9a v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c canh ph\u1ea3i, (^) n\u1ebfu \u00f4 ch\u1ee9a v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c canh gi\u1eefa, () n\u1ebfu \u00f4 ch\u1ee9a v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c canh \u0111\u1ec1u hai b\u00ean v\u00e0 (\u201c\u201d) n\u1ebfu \u00f4 ch\u1ee9a b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec kh\u00e1c.<\/p>\n<p><strong>protect<\/strong>\u00a0\u0111\u01b0a gi\u00e1 tr\u1ecb 0 n\u1ebfu \u00f4 kh\u00f4ng b\u1ecb kh\u00f3a; 1 n\u1ebfu \u00f4 b\u1ecb kh\u00f3a.<\/p>\n<p><strong>row\u00a0<\/strong>tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 trong tham chi\u1ebfu<\/p>\n<p><strong>type\u00a0<\/strong>tr\u1ea3 v\u1ec1 \u201cb\u201d n\u1ebfu \u00f4 tr\u1ed1ng, \u201cl\u201d n\u1ebfu \u00f4 ch\u1ee9a\u00a0v\u0103n b\u1ea3n v\u00e0 \u201cv\u201d n\u1ebfu \u00f4 ch\u1ee9a b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec kh\u00e1c.<\/p>\n<p><strong>width\u00a0<\/strong>\u0111\u01b0a ra \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t<\/p>\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>H\u00e0m CELL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tra c\u1ee9u th\u00f4ng tin trong \u00f4 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25148\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-cell-3.png\" width=\"374\" height=\"47\" title=\"ham-cell-3\"><\/p>\n<p>\u00a0<\/p>\n<p><strong>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c t\u1ea1i:<\/strong><\/p>\n<p><span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"http:\/\/blog.ezworkapp.com\/gioi-thieu-ham-address-trong-excel.html\"><strong>H\u00e0m Address<\/strong><\/a><\/span><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-quotient-tra-ve-ket-qua-cua-phep-chia-trong-excel.html\"><strong>H\u00e0m QUOTIENT<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-sumproduct-nang-cao-trong-excel.html\"><strong>S\u1eed d\u1ee5ng h\u00e0m\u00a0SUMPRODUCT n\u00e2ng cao<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du.html\"><strong>C\u00e1c h\u00e0m chia trong Excel<\/strong><\/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\/2025\/01\/ex101_92019-nho-27.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9249,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9248","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\/9248","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=9248"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9248\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9249"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}