{"id":13490,"date":"2015-09-17T09:10:29","date_gmt":"2015-09-17T09:10:29","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13490"},"modified":"2015-09-29T09:21:48","modified_gmt":"2015-09-29T09:21:48","slug":"cach-su-dung-ham-hlookup-trong-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13490","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m HLOOKUP trong k\u1ebf to\u00e1n Excel"},"content":{"rendered":"<h2><img decoding=\"async\" loading=\"lazy\" class=\"alignright  wp-image-13495\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup_040354.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m HLOOKUP trong k\u1ebf to\u00e1n Excel\" width=\"302\" height=\"143\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup_040354.png 350w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup_040354-300x142.png 300w\" sizes=\"(max-width: 302px) 100vw, 302px\" \/><\/h2>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">H\u00e0m HLOOKUP l\u00e0 m\u1ed9t trong hai h\u00e0m t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong Excel. N\u1ebfu c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft v\u1ec1 h\u00e0m VLOOKUP th\u00ec ta s\u1ebd th\u1ea5y h\u00e0m HLOOKUP n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m VLOOKUP. VLOOKUP d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 theo c\u1ed9t, c\u00f2n HLOOKUP d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 theo h\u00e0ng.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0<strong><a href=\"https:\/\/centax.dsoftware.vn\/\" target=\"_blank\">K\u1ebf to\u00e1n Centax<\/a><\/strong> xin chia s\u1ebb c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif; font-size: 14pt; color: #000000;\">1. \u00dd ngh\u0129a h\u00e0m HLOOKUP<\/span><\/h2>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">H\u00e0m HLOOKUP l\u00e0 h\u00e0m d\u00f2 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u. N\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf c\u00f9ng tr\u00ean c\u1ed9t v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y tr\u00ean h\u00e0ng m\u00e0 ch\u00fang ta ch\u1ec9 \u0111\u1ecbnh. H\u00e0m HLOOPUP th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 \u0111i\u1ec1n th\u00f4ng tin v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u l\u1ea5y t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee5.<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif; font-size: 14pt; color: #000000;\">2. C\u00e1ch d\u00f9ng h\u00e0m HLOOKUP<\/span><\/h2>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter  wp-image-13497\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/c\u00fa-ph\u00e1p-hlookup.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m HLOOKUP trong k\u1ebf to\u00e1n Excel_c\u00fa ph\u00e1p hlookup\" width=\"712\" height=\"167\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/c\u00fa-ph\u00e1p-hlookup.jpg 682w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/c\u00fa-ph\u00e1p-hlookup-300x70.jpg 300w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/><\/p>\n<p><strong><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Gi\u1ea3i th\u00edch:<\/span><\/strong><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><em>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm:<\/em> gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1, m\u1ed9t tham chi\u1ebfu, m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 c\u1ee7a b\u1ea3ng ch\u00ednh. Gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i c\u00f3 t\u00ean trong v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><em>V\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm:<\/em> V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm. V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm n\u00e0y th\u01b0\u1eddng n\u1eb1m \u1edf b\u1ea3ng ph\u1ee5. L\u01b0u \u00fd: trong v\u00f9ng d\u1eef ki\u1ec7u t\u00ecm ki\u1ebfm n\u00e0y ph\u1ea3i ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><em>H\u00e0ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm:<\/em> gi\u00e1 tr\u1ecb l\u1ea5y \u1edf h\u00e0ng th\u1ee9 m\u1ea5y trong b\u1ea3ng ph\u1ee5<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><em>Tham s\u1ed1:<\/em> mu\u1ed1n t\u00ecm ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i. Tham s\u1ed1 n\u00e0y \u0111i\u1ec1n \u201c0\u201d n\u1ebfu b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm ch\u00ednh x\u00e1c, \u0111i\u1ec1n s\u1ed1 \u201c1\u201d n\u1ebfu mu\u1ed1n d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif; font-size: 14pt; color: #000000;\">3. V\u00ed d\u1ee5:<\/span><\/h2>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-13498\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m HLOOKUP trong k\u1ebf to\u00e1n Excel_2\" width=\"785\" height=\"317\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup.jpg 785w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/hlookup-300x121.jpg 300w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m HLOOKUP trong k\u1ebf to\u00e1n Excel, m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n. M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1695],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13490"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13490"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13490\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13500"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13490"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}