{"id":44272,"date":"2022-04-12T18:44:37","date_gmt":"2022-04-12T11:44:37","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=44272"},"modified":"2022-05-09T10:31:42","modified_gmt":"2022-05-09T03:31:42","slug":"ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/","title":{"rendered":"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517729 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg\" alt=\"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n\" width=\"1000\" height=\"563\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Ham_HLOOKUP_la_gi\"><\/span><span id=\"Ham_HLOOKUP_la_gi\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">H\u00e0m HLOOKUP l\u00e0 g\u00ec?<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m HLOOKUP l\u00e0 t\u1eeb vi\u1ebft t\u1eaft c\u1ee7a c\u1ee5m t\u1eeb ti\u1ebfng anh Horizontal Lookup, c\u00f3 ngh\u0129a l\u00e0 d\u00f2 t\u00ecm h\u00e0ng ngang. H\u00e0m n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u00f2 t\u00ecm c\u00e1c d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng theo ph\u1ea1m vi h\u00e0ng ngang, v\u00e0 sau \u0111\u00f3 tr\u1ea3 d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng sang b\u1ea3ng theo ph\u1ea1m vi h\u00e0ng d\u1ecdc. L\u1ec7nh HLOOKUP th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m; t\u00ednh ph\u1ee5 c\u1ea5p theo t\u1eebng ch\u1ee9c v\u1ee5; t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u01a1ng,\u2026 theo m\u00e3 v\u1ea1ch;\u2026<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517730 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a917f2.jpeg\" alt=\"H\u00e0m HLOOKUP l\u00e0 g\u00ec?\" width=\"1000\" height=\"563\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_cua_ham_HLOOKUP_trong_Excel\"><\/span><span id=\"Cong_thuc_cua_ham_HLOOKUP_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m HLOOKUP trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m HLOOKUP trong Excel nh\u01b0 sau:<\/p>\n<p><strong>=HLOOKUP(Lookup_value,Table_array,Row_index_ num,Range_lookup)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>Lookup_value: Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<li>Table_array: B\u1ea3ng gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm, b\u1ea1n c\u1ea7n nh\u1ea5n F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a b\u1ea3ng n\u00e0y khi s\u1eed d\u1ee5ng h\u00e0m.<\/li>\n<li>Row_index_num: S\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi c\u1ee7a b\u1ea3ng gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm.<\/li>\n<li>Range_lookup: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c ho\u1eb7c t\u01b0\u01a1ng \u0111\u1ed1i. N\u1ebfu t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c th\u00ec b\u1ea1n s\u1eed d\u1ee5ng s\u1ed1 0, t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i th\u00ec s\u1eed d\u1ee5ng s\u1ed1 1.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517731 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2bc7f80.jpeg\" alt=\"C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m HLOOKUP trong Excel\" width=\"1000\" height=\"563\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_HLOOKUP_trong_Excel_don_gian\"><\/span><span id=\"Cach_su_dung_ham_HLOOKUP_trong_Excel_don_gian\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel \u0111\u01a1n gi\u1ea3n<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_HLOOKUP_de_xep_loai_hoc_sinh_theo_diem\"><\/span><span id=\"Su_dung_ham_HLOOKUP_de_xep_loai_hoc_sinh_theo_diem\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n c\u1ea7n t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t X\u1ebfp lo\u1ea1i \u1edf b\u1ea3ng 1, t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi gi\u00e1 g\u1ecb d\u00f2 t\u00ecm \u1edf b\u1ea3ng 2 (B17:F18).<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n <strong>nh\u1eadp c\u00f4ng th\u1ee9c<\/strong> nh\u01b0 sau: <strong>=HLOOKUP(C9,$B$17:$F$18,2,1) <\/strong>v\u00e0<strong> nh\u1ea5n Enter. <\/strong>C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n d\u00f2 t\u00ecm \u00f4 C9 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi b\u1ea3ng 2 (B17:F18). B\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1ea3ng d\u00f2 t\u00ecm (b\u1ea3ng 2) b\u1eb1ng c\u00e1ch nh\u1ea5n F4 \u0111\u1ec3 k\u1ebft qu\u1ea3 c\u1ee7a c\u1ed9t X\u1ebfp h\u1ea1ng t\u1ef1 \u0111\u1ed9ng fill m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517732 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2d37ba0.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m - b\u01b0\u1edbc 1\" width=\"1201\" height=\"1030\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, \u0111\u1ec3 chu\u1ed9t v\u00e0o g\u00f3c ph\u1ea3i c\u1ee7a \u00f4 gi\u00e1 tr\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng m\u00e0u \u0111en, b\u1ea1n <strong>nh\u1ea5p \u0111\u00fap v\u00e0o d\u1ea5u c\u1ed9ng<\/strong> \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n gi\u00e1 tr\u1ecb cho c\u1ed9t X\u1ebfp lo\u1ea1i.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517733 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d30639da.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m - b\u01b0\u1edbc 2\" width=\"1201\" height=\"1027\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> <strong>K\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m<\/strong> nh\u01b0 h\u00ecnh sau.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517734 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d3344011.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m - b\u01b0\u1edbc 3\" width=\"1202\" height=\"1030\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_HLOOKUP_de_tinh_phu_cap_theo_chuc_vu\"><\/span><span id=\"Su_dung_ham_HLOOKUP_de_tinh_phu_cap_theo_chuc_vu\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ednh ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n c\u1ea7n t\u00ecm c\u1ed9t Ph\u1ee5 c\u1ea5p \u1edf b\u1ea3ng 1 theo b\u1ea3ng gi\u00e1 tr\u1ecb \u1edf b\u1ea3ng 2 (B17:F18).<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> B\u1ea1n <strong>nh\u1eadp c\u00f4ng th\u1ee9c<\/strong> nh\u01b0 sau: <strong>=HLOOKUP(C9,$B$17:$F$18,2,0)<\/strong> v\u00e0 <strong>nh\u1ea5n Enter<\/strong>. C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 ngh\u0129a l\u00e0 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb \u1edf \u00f4 C9 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi b\u1ea3ng gi\u00e1 tr\u1ecb (B17:F18).<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517735 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d365e037.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ednh ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5 - b\u01b0\u1edbc 1\" width=\"1397\" height=\"1028\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, \u0111\u1ec3 chu\u1ed9t \u1edf g\u00f3c ph\u1ea3i c\u1ee7a \u00f4 gi\u00e1 tr\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y th\u00ec s\u1ebd hi\u1ec7n ra bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng m\u00e0u \u0111en, b\u1ea1n <strong>click \u0111\u00fap v\u00e0o d\u1ea5u c\u1ed9ng<\/strong> \u0111\u1ec3 fill c\u00e1c \u00f4 c\u00f2n l\u1ea1i c\u1ee7a c\u1ed9t Ph\u1ee5 c\u1ea5p.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517737 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d3a63e62.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ednh ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5 - b\u01b0\u1edbc 2\" width=\"1396\" height=\"1030\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u00e2y l\u00e0 <strong>k\u1ebft qu\u1ea3 c\u1ee7a l\u1ec7nh HLOOKUP \u0111\u1ec3 t\u00ecm ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517738 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d3d1a224.jpeg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m HLOOKUP \u0111\u1ec3 t\u00ednh ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5 - b\u01b0\u1edbc 3\" width=\"1397\" height=\"1028\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ham_HLOOKUP_cung_ham_IF\"><\/span><span id=\"Ket_hop_ham_HLOOKUP_cung_ham_IF\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">K\u1ebft h\u1ee3p h\u00e0m HLOOKUP c\u00f9ng h\u00e0m IF<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, s\u1eed d\u1ee5ng l\u1ec7nh HLOOKUP k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF \u0111\u1ec3 t\u00ecm ra K\u1ebft qu\u1ea3 c\u1ee7a t\u1eebng ng\u01b0\u1eddi d\u1ef1a v\u00e0o Nh\u00f3m v\u00e0 Doanh s\u1ed1 c\u1ee7a h\u1ecd.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> B\u1ea1n <strong>nh\u1eadp c\u00f4ng th\u1ee9c<\/strong> nh\u01b0 sau: <strong>=IF(D7&gt;HLOOKUP(C7,$B$17:$F$18,2,0),\u201d\u0110\u1ea1t\u201d,\u201dKh\u00f4ng \u0110\u1ea1t\u201d)<\/strong> v\u00e0 <strong>nh\u1ea5n Enter<\/strong>. C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 D7 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm c\u1ee7a \u00f4 C7 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi b\u1ea3ng 2 (B17:F18) l\u00e0 \u0111\u00fang th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 \u201c\u0110\u1ea1t\u201d, n\u1ebfu sai k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 \u201cKh\u00f4ng \u0110\u1ea1t\u201d.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517740 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d3ec1867.jpeg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m HLOOKUP c\u00f9ng h\u00e0m IF - b\u01b0\u1edbc 1\" width=\"1582\" height=\"1027\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp theo, \u0111\u1ec3 chu\u1ed9t t\u1ea1i v\u1ecb tr\u00ed g\u00f3c ph\u1ea3i nh\u01b0 h\u00ecnh sau s\u1ebd hi\u1ec7n ra bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng m\u00e0u \u0111en, b\u1ea1n <strong>nh\u1ea5p \u0111\u00fap v\u00e0o d\u1ea5u c\u1ed9ng<\/strong>\u00a0\u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng fill c\u00e1c \u00f4 c\u00f2n l\u1ea1i c\u1ee7a c\u1ed9t K\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517741 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d41a7d97.jpeg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m HLOOKUP c\u00f9ng h\u00e0m IF - b\u01b0\u1edbc 2\" width=\"1501\" height=\"1028\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> <strong>K\u1ebft qu\u1ea3 c\u1ee7a s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF<\/strong> nh\u01b0 h\u00ecnh sau.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-517742 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d44df93c.jpeg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m HLOOKUP c\u00f9ng h\u00e0m IF - b\u01b0\u1edbc 3\" width=\"1502\" height=\"1030\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t. Hy v\u1ecdng nh\u1eefng chia s\u1ebb n\u00e0y s\u1ebd gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o h\u01a1n. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<p style=\"text-align: center;\">\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?tag=microsoft\" href=\"https:\/\/divineshop.vn\/search?tag=microsoft\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?tag=microsoft noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png\" alt=\"\" class=\"wp-image-276759\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-container-69e54fc5c348e wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?q=windows\" href=\"https:\/\/divineshop.vn\/search?q=windows\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?q=windows noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png\" alt=\"\" class=\"wp-image-256838\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/p>\n","protected":false},"author":12,"featured_media":44273,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[38,255],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T11:44:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-09T03:31:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg\",\"width\":1000,\"height\":563},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/\",\"name\":\"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage\"},\"datePublished\":\"2022-04-12T11:44:37+00:00\",\"dateModified\":\"2022-05-09T03:31:42+00:00\",\"description\":\"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n\",\"datePublished\":\"2022-04-12T11:44:37+00:00\",\"dateModified\":\"2022-05-09T03:31:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage\"},\"wordCount\":1077,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg\",\"keywords\":[\"divineshop\",\"Th\u1ee7 thu\u1eadt Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#respond\"]}],\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n","og_description":"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","og_url":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T11:44:37+00:00","article_modified_time":"2022-05-09T03:31:42+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg","width":1000,"height":563},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/","name":"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage"},"datePublished":"2022-04-12T11:44:37+00:00","dateModified":"2022-05-09T03:31:42+00:00","description":"N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi th\u01b0\u1eddng th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel b\u1eb1ng m\u00e1y t\u00ednh m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"H\u00e0m HLOOKUP trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c \u0111\u01a1n gi\u1ea3n","datePublished":"2022-04-12T11:44:37+00:00","dateModified":"2022-05-09T03:31:42+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#webpage"},"wordCount":1077,"commentCount":0,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian_623d4d2a009d7.jpeg","keywords":["divineshop","Th\u1ee7 thu\u1eadt Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/divineshop.vn\/tin-tuc\/ham-hlookup-trong-excel-la-gi-cach-su-dung-cuc-don-gian\/#respond"]}],"copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44272"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=44272"}],"version-history":[{"count":3,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44272\/revisions"}],"predecessor-version":[{"id":83971,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44272\/revisions\/83971"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/44273"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=44272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=44272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=44272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}