{"id":557,"date":"2024-12-02T02:28:12","date_gmt":"2024-12-02T02:28:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-hlookup-trong-excel-dung-hlookup-vlookup-hay-xlookup-trong-truong-hop-nao\/"},"modified":"2024-12-02T02:28:12","modified_gmt":"2024-12-02T02:28:12","slug":"ham-hlookup-trong-excel-dung-hlookup-vlookup-hay-xlookup-trong-truong-hop-nao","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-hlookup-trong-excel-dung-hlookup-vlookup-hay-xlookup-trong-truong-hop-nao\/","title":{"rendered":"H\u00e0m Hlookup trong Excel; d\u00f9ng Hlookup, Vlookup hay Xlookup trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"hlookup-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html?hlookup-trong-excel\">\n<p style=\"text-align: justify\"><em><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft Microsoft c\u00f3 3 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb, LOOKUP,\u00a0 V\u00c0 HLOOKUP, v\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y b\u1ed1i r\u1ed1i khi s\u1eed d\u1ee5ng 3 h\u00e0m n\u00e0y nh\u1ea5t. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd t\u1eadp trung v\u00e0o c\u00e1c \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a<strong> h\u00e0m HLOOKUP trong Excel<\/strong> v\u00e0 \u0111\u01b0a m\u1ed9t v\u00e0i v\u00ed d\u1ee5 minh ho\u1ea1 gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng Hlookup m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/span><\/em><\/p>\n<\/blockquote>\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-674d1b3bc066f\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#HAM_HLOOKUP_TRONG_EXCEL_LA_GI\" title=\"H\u00c0M HLOOKUP TRONG EXCEL L\u00c0 G\u00cc?\">H\u00c0M HLOOKUP TRONG EXCEL L\u00c0 G\u00cc?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#3_DIEU_BAN_CAN_BIET_VE_HAM_HLOOKUP_TRONG_EXCEL\" title=\"3 \u0110I\u1ec0U B\u1ea0N C\u1ea6N BI\u1ebeT V\u1ec0 H\u00c0M HLOOKUP TRONG EXCEL\u00a0\">3 \u0110I\u1ec0U B\u1ea0N C\u1ea6N BI\u1ebeT V\u1ec0 H\u00c0M HLOOKUP TRONG EXCEL\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#SU_KHAC_NHAU_GIUA_VLOOKUP_VA_HLOOKUP\" title=\"S\u1ef0 KH\u00c1C NHAU GI\u1eeeA VLOOKUP V\u00c0 HLOOKUP\">S\u1ef0 KH\u00c1C NHAU GI\u1eeeA VLOOKUP V\u00c0 HLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#Khi_nao_su_dung_VLOOKUP_khi_nao_su_dung_HLOOKUP\" title=\"Khi n\u00e0o s\u1eed d\u1ee5ng VLOOKUP, khi n\u00e0o s\u1eed d\u1ee5ng HLOOKUP\">Khi n\u00e0o s\u1eed d\u1ee5ng VLOOKUP, khi n\u00e0o s\u1eed d\u1ee5ng HLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#UNG_DUNG_CUA_HLOOKUP_TRONG_EXCEL\" title=\"\u1ee8NG D\u1ee4NG C\u1ee6A HLOOKUP TRONG EXCEL\">\u1ee8NG D\u1ee4NG C\u1ee6A HLOOKUP TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#Cach_dung_ham_Hlookup_tu_worksheet_hoac_workbook_khac\" title=\"C\u00e1ch d\u00f9ng h\u00e0m Hlookup t\u1eeb worksheet ho\u1eb7c workbook kh\u00e1c\">C\u00e1ch d\u00f9ng h\u00e0m Hlookup t\u1eeb worksheet ho\u1eb7c workbook kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#O_tham_chieu_tuyet_doi_va_tuong_doi_trong_HLookup\" title=\"\u00d4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong HLookup\">\u00d4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong HLookup<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#INDEXMATCH_MOT_CONG_THUC_HIEU_QUA_KHAC_BEN_CANH_HLOOKUP\" title=\"INDEX\/MATCH,\u00a0M\u1ed8T C\u00d4NG TH\u1ee8C HI\u1ec6U QU\u1ea2 KH\u00c1C B\u00caN C\u1ea0NH HLOOKUP \">INDEX\/MATCH,\u00a0M\u1ed8T C\u00d4NG TH\u1ee8C HI\u1ec6U QU\u1ea2 KH\u00c1C B\u00caN C\u1ea0NH HLOOKUP <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#Cach_su_dung_H-lookup_phan_biet_dang_chu_trong_Excel\" title=\"C\u00e1ch s\u1eed d\u1ee5ng H-lookup ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef trong Excel\">C\u00e1ch s\u1eed d\u1ee5ng H-lookup ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html#10_LY_DO_PHO_BIEN_KHIEN_HLOOKUP_KHONG_CHAY_DUOC\" title=\"10 L\u00dd DO PH\u1ed4 BI\u1ebeN KHI\u1ebeN HLOOKUP KH\u00d4NG CH\u1ea0Y \u0110\u01af\u1ee2C\">10 L\u00dd DO PH\u1ed4 BI\u1ebeN KHI\u1ebeN HLOOKUP KH\u00d4NG CH\u1ea0Y \u0110\u01af\u1ee2C<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_HLOOKUP_TRONG_EXCEL_LA_GI\"><\/span><strong>H\u00c0M HLOOKUP TRONG EXCEL L\u00c0 G\u00cc?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\">H\u00e0m HLOOKUP<\/a> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh trong h\u00e0ng tr\u00ean c\u00f9ng c\u1ee7a b\u1ea3ng v\u00e0 tr\u1ea3 l\u1ea1i m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c trong c\u00f9ng c\u1ed9t t\u1eeb h\u00e0ng m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m HLOOKUP s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c cho Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007 v\u00e0 phi\u00ean b\u1ea3n c\u0169 h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00da PH\u00c1P V\u00c0 C\u00c1CH S\u1eec D\u1ee4NG HLOOKUP<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00fa ph\u00e1p h\u00e0m Hlookup nh\u01b0 sau <\/span><\/p>\n<p style=\"text-align: justify\"><b>HLOOKUP (lookup_value, table array, row_index_num, [range_lookup])<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi<\/span><\/p>\n<p style=\"text-align: justify\"><b>Lookup_value <\/b><span style=\"font-weight: 400\">(b\u1eaft bu\u1ed9c): gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. C\u00f3 th\u1ec3 l\u00e0 \u00f4 tham chi\u1ebfu, m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n. <\/span><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-4.gif\" title=\"vba101_92019-nho-4\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-27.gif\" title=\"ex101_92019-nho-27\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><b>Table_array <\/b><span style=\"font-weight: 400\">(b\u1eaft bu\u1ed9c): b\u1ea3ng t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb g\u1ed3m hai h\u00e0ng d\u1eef li\u1ec7u tr\u1edf l\u00ean. C\u00f3 th\u1ec3 l\u00e0 m\u1ea3ng th\u01b0\u1eddng, \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean ho\u1eb7c b\u1ea3ng Excel. C\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a table_array <\/span><\/p>\n<p style=\"text-align: justify\"><b>Row_index_num <\/b><span style=\"font-weight: 400\">(b\u1eaft bu\u1ed9c): s\u1ed1 h\u00e0ng trong table_array n\u01a1i m\u00e0 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. V\u00ed d\u1ee5, \u0111\u1ec3 tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb tr\u00f9ng kh\u1edbp t\u1eeb h\u00e0ng th\u1ee9 2, \u0111\u1eb7t row_index_num b\u1eb1ng 2.<\/span><\/p>\n<p style=\"text-align: justify\"><b>Range_lookup <\/b><span style=\"font-weight: 400\">(tu\u1ef3 ch\u1ecdn): m\u1ed9t gi\u00e1 tr\u1ecb logic (Boolean) cho bi\u1ebft HLOOKUP c\u1ea7n ph\u1ea3i t\u00ecm k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu TRUE ho\u1eb7c b\u1ecf qua, k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. Ngh\u0129a l\u00e0 n\u1ebfu k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, h\u00e0m Hlookup c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t k\u1ebf ti\u1ebfp nh\u1ecf h\u01a1n look_up value. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu FALSE, ch\u1ec9 k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu kh\u00f4ng gi\u00e1 tr\u1ecb n\u00e0o trong h\u00e0ng ch\u1ec9 \u0111\u1ecbnh \u00a0kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, h\u00e0m Hlookup s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 d\u1ecbch c\u00fa ph\u00e1p HLOOKUP c\u1ee7a Excel sang ti\u1ebfng Vi\u1ec7t nh\u01b0 sau <\/span><\/p>\n<p style=\"text-align: justify\"><b>HLOOKUP (t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb n\u00e0y, trong b\u1ea3ng n\u00e0y, tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb t\u1eeb h\u00e0ng n\u00e0y, [tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c ho\u1eb7c t\u01b0\u01a1ng \u0111\u1ed1i])<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u c\u00e1ch ho\u1ea1t \u0111\u1ed9ng, ch\u00fang ta h\u00e3y c\u00f9ng xem m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng v\u1edbi th\u00f4ng tin c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c h\u00e0nh tinh c\u1ee7a h\u1ec7 M\u1eb7t tr\u1eddi. B\u1ea1n mu\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 \u0111\u01b0\u1eddng k\u00ednh c\u1ee7a h\u00e0nh tinh c\u00f3 t\u00ean trong \u00f4 B5. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong c\u00f4ng th\u1ee9c Hlookup, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 sau <\/span><\/p>\n<p style=\"text-align: justify\"><b>Lookup_value <\/b><span style=\"font-weight: 400\">l\u00e0 B5, \u00f4 ch\u1ee9a t\u00ean c\u1ee7a h\u00e0nh tinh b\u1ea1n mu\u1ed1n t\u00ecm<\/span><\/p>\n<p style=\"text-align: justify\"><b>Table_arrray <\/b><span style=\"font-weight: 400\">l\u00e0 B2:I3, b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/span><\/p>\n<p style=\"text-align: justify\"><b>Row_index_num <\/b><span style=\"font-weight: 400\">l\u00e0 2 v\u00ec \u0110\u01b0\u1eddng k\u00ednh \u1edf h\u00e0ng th\u1ee9 2 trong b\u1ea3ng<\/span><\/p>\n<p style=\"text-align: justify\"><b>Range_lookup <\/b><span style=\"font-weight: 400\">\u00a0l\u00e0 FALSE v\u00ec h\u00e0ng th\u1ee9 nh\u1ea5t c\u1ee7a b\u1ea3ng kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb A \u0111\u1ebfn Z, n\u00ean ch\u00fang ta ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c \u1edf trong v\u00ed d\u1ee5 n\u00e0y<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">B\u00e2y gi\u1edd x\u1ebfp c\u00e1c tham s\u1ed1 v\u00e0o v\u00e0 ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (40, A2:B15, 2)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4953\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-07-46-1024x275-1.png\" width=\"600\" height=\"161\" title=\"screen-shot-2017-05-02-at-20-07-46-1024x275-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_DIEU_BAN_CAN_BIET_VE_HAM_HLOOKUP_TRONG_EXCEL\"><\/span><strong>3 \u0110I\u1ec0U B\u1ea0N C\u1ea6N BI\u1ebeT V\u1ec0 H\u00c0M HLOOKUP TRONG EXCEL\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n t\u00ecm gi\u00e1 tr\u1ecb trong h\u00e0ng, h\u00e3y nh\u1edb nh\u1eefng \u0111i\u1ec1u sau:<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"> H\u00e0m HLOOKUP ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm \u1edf h\u00e0ng tr\u00ean c\u00f9ng c\u1ee7a table_array. N\u1ebfu b\u1ea1n c\u1ea7n t\u00ecm \u1edf nh\u1eefng v\u1ecb tr\u00ed kh\u00e1c, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Index ho\u1eb7c Match <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">HLOOKUP trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef hoa v\u00e0 th\u01b0\u1eddng <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu range_lookup \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u00e0 TRUE ho\u1eb7c b\u1ecf tr\u1ed1ng (k\u1ebft qu\u1ea3 kh\u1edbp <\/span><b>t\u01b0\u01a1ng \u0111\u1ed1i<\/b><span style=\"font-weight: 400\">), c\u00e1c gi\u00e1 tr\u1ecb \u1edf h\u00e0ng \u0111\u1ea7u c\u1ee7a table_array ph\u1ea3i \u0111\u01b0\u1ee3c x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (A-Z) t\u1eeb tr\u00e1i sang ph\u1ea3i. <\/span><\/li>\n<\/ol>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SU_KHAC_NHAU_GIUA_VLOOKUP_VA_HLOOKUP\"><\/span><strong>S\u1ef0 KH\u00c1C NHAU GI\u1eeeA VLOOKUP V\u00c0 HLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u1ea3 hai h\u00e0m HLOOKUP V\u00c0 VLOOKUP d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb. Nh\u01b0ng ch\u00fang kh\u00e1c nhau trong c\u00e1ch ho\u1ea1t \u0111\u1ed9ng. Ch\u00fang ta d\u1ec5 d\u00e0ng nh\u1eadn ra t\u00ean c\u1ee7a hai h\u00e0m kh\u00e1c nhau \u1edf ch\u1eef c\u00e1i \u0111\u1ea7u \u2013 \u201cH\u201d l\u00e0 ngang (horizontal) v\u00e0 \u201cV\u201d l\u00e0 d\u1ecdc (vertical)<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Do \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb theo c\u1ed9t \u1edf ph\u00eda b\u00ean tr\u00e1i c\u1ee7a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm. H\u00e0m HLOOKUP d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb theo h\u00e0ng ngang. N\u00f3 t\u00ecm gi\u00e1 tr\u1ecb \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng v\u00e0 tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb \u1edf h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh \u1edf trong c\u00f9ng m\u1ed9t c\u1ed9t. <\/span><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n s\u1ef1 kh\u00e1c nhau gi\u1eefa hai c\u00f4ng th\u1ee9c Vlookup v\u00e0 Hlookup<\/p>\n<p style=\"text-align: justify\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4954\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-10-04.png\" width=\"600\" height=\"288\" title=\"screen-shot-2017-05-02-at-20-10-04\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4955\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-10-35.png\" width=\"600\" height=\"286\" title=\"screen-shot-2017-05-02-at-20-10-35\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m excel th\u00f4ng d\u1ee5ng<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Khi_nao_su_dung_VLOOKUP_khi_nao_su_dung_HLOOKUP\"><\/span>Khi n\u00e0o s\u1eed d\u1ee5ng VLOOKUP, khi n\u00e0o s\u1eed d\u1ee5ng HLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi n\u00e0o s\u1eed d\u1ee5ng VLOOKUP, khi n\u00e0o s\u1eed d\u1ee5ng HLOOKUP? H\u1eb3n b\u1ea1n r\u1ea5t th\u1eafc m\u1eafc v\u1edbi c\u00e2u h\u1ecfi n\u00e0y. Ch\u00fang ta c\u00f3 1 b\u00ed quy\u1ebft \u0111\u1ec3\u00a0d\u1ec5 d\u00e0ng nh\u1eadn di\u1ec7n n\u00f3, \u0111\u00f3 l\u00e0 C\u0103n c\u1ee9 theo \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0<strong>Lookup_value<\/strong>\u00a0v\u00e0\u00a0<strong>c\u1ea5u tr\u00fac c\u1ee7a v\u00f9ng b\u1ea3ng Table_Array<\/strong>\u00a0(B\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm v\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm)<\/p>\n<ul>\n<li>N\u1ebfu\u00a0<strong>lookup_value<\/strong>\u00a0n\u1eb1m tr\u00ean\u00a0<strong>c\u1ed9t \u0111\u1ea7u ti\u00ean<\/strong>\u00a0c\u1ee7a b\u1ea3ng th\u00ec d\u00f9ng Vlookup<\/li>\n<\/ul>\n<ul>\n<li>N\u1ebfu\u00a0<strong>lookup_value<\/strong>\u00a0n\u1eb1m tr\u00ean\u00a0<strong>d\u00f2ng \u0111\u1ea7u ti\u00ean<\/strong>\u00a0c\u1ee7a b\u1ea3ng th\u00ec d\u00f9ng Hlookup<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"UNG_DUNG_CUA_HLOOKUP_TRONG_EXCEL\"><\/span><strong>\u1ee8NG D\u1ee4NG C\u1ee6A HLOOKUP TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>T\u00ecm gi\u00e1 tr\u1ecb theo h\u00e0ng v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 ch\u00ednh x\u00e1c<\/strong><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m HLOOKUP trong Excel c\u00f3 th\u1ec3 t\u00ecm k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c v\u00e0 kh\u00f4ng ch\u00ednh x\u00e1c d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a tham s\u1ed1 range_lookup<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">TRUE ho\u1eb7c b\u1ecf tr\u1ed1ng: k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">FALSE: k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u00ean nh\u1edb r\u1eb1ng m\u1eb7c d\u00f9 ch\u00fang ta th\u01b0\u1eddng n\u00f3i l\u00e0 k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i, c\u00f4ng th\u1ee9c Hlookup lu\u00f4n t\u00ecm m\u1ed9t k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c \u0111\u1ea7u ti\u00ean. \u0110\u1eb7t tham s\u1ed1 l\u00e0 FALSE cho ph\u00e9p h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i (gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t nh\u1edf h\u01a1n gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm) n\u1ebfu k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c kh\u00f4ng t\u00ecm th\u1ea5y; TRUE ho\u1eb7c b\u1ecb b\u1ecf tr\u1ed1ng s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f9ng xem v\u00ed d\u1ee5 minh ho\u1ea1 d\u01b0\u1edbi \u0111\u00e2y<\/span><\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><span style=\"font-weight: 400\">HLOOKUP v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c h\u00e0nh tinh \u1edf h\u00e0ng 2 (B2:I2) v\u00e0 nhi\u1ec7t \u0111\u1ed9 c\u1ee7a ch\u00fang \u1edf h\u00e0ng 1 (B1:I1). B\u1ea1n mu\u1ed1n t\u00ecm h\u00e0nh tinh c\u00f3 nhi\u1ec7t \u0111\u1ed9 b\u1eb1ng nhi\u1ec7t \u0111\u1ed9 \u1edf \u00f4 B4.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c nhi\u1ec7t \u0111\u1ed9 c\u1ea7n t\u00ecm, b\u1ea1n c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng h\u00e0m Hlookup \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 kh\u1edbp g\u1ea7n nh\u1ea5t n\u1ebfu gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5, \u0111\u1ec3 bi\u1ebft h\u00e0nh tinh n\u00e0o c\u00f3 nhi\u1ec7t \u0111\u1ed9 trung b\u00ecnh v\u00e0o kho\u1ea3ng -340\u00b0F, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Hlookup nh\u01b0 sau (range_lookup \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u00e0 TRUE trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y):<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B4, B1:I2, 2)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e3y nh\u1edb r\u1eb1ng k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i y\u00eau c\u1ea7u s\u1eafp x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t ho\u1eb7c t\u1eeb A \u0111\u1ebfn Z, n\u1ebfu kh\u00f4ng h\u00e0m Hlookup s\u1ebd \u0111\u01b0a ra k\u1ebft qu\u1ea3 sai.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong h\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m tr\u1ea3 v\u1ec1 h\u00e0nh tinh H\u1ea3i V\u01b0\u01a1ng, m\u1ed9t trong nh\u1eefng h\u00e0nh tinh l\u1ea1nh nh\u1ea5t trong h\u1ec7 M\u1eb7t tr\u1eddi lu\u00f4n gi\u1eef nhi\u1ec7t \u0111\u1ed9 trung b\u00ecnh v\u00e0o kho\u1ea3ng -346 \u0111\u1ed9 F.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4956\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-18-06.png\" width=\"600\" height=\"186\" title=\"screen-shot-2017-05-02-at-20-18-06\"><\/p>\n<ul style=\"list-style-type: square;text-align: justify\">\n<li><span style=\"font-weight: 400\">Hlookup v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n bi\u1ebft ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t tham s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a h\u00e0m Hlookup l\u00e0 FALSE:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B4, B1:I2, 2, FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4957\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-18-58.png\" width=\"600\" height=\"174\" title=\"screen-shot-2017-05-02-at-20-18-58\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t m\u1eb7t, k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u1eddng d\u1ed1i d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng h\u01a1n v\u00ec n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u s\u1eafp x\u1ebfp d\u1eef li\u1ec7u \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean. M\u1eb7t kh\u00e1c, n\u1ebfu k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><b>Tip <\/b><span style=\"font-weight: 400\">\u0110\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng c\u1ea3m th\u1ea5y ho\u1ea3ng s\u1ee3 khi nh\u00ecn th\u1ea5y l\u1ed7i N\/A xu\u1ea5t hi\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0a h\u00e0m Hlookup v\u00e0o h\u00e0m INFERROR v\u00e0 g\u1eedi th\u00f4ng \u0111i\u1ec7p c\u1ee7a b\u1ea1n <\/span><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><b>=INFERROR (HLOOKUP (B4, B1:I2, 2, FALSE), \u201cXin l\u1ed7i, kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3\u201d)<\/b><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dung_ham_Hlookup_tu_worksheet_hoac_workbook_khac\"><\/span><strong>C\u00e1ch d\u00f9ng h\u00e0m Hlookup t\u1eeb worksheet ho\u1eb7c workbook kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u00ecn chung, t\u00ecm gi\u00e1 tr\u1ecb theo h\u00e0ng t\u1eeb m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c ngh\u0129a l\u00e0 b\u1ea1n ph\u1ea3i cung c\u1ea5p c\u00e1c tham chi\u1ebfu ngo\u1ea1i tuy\u1ebfn cho h\u00e0m HLOOKUP <\/span><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb kh\u1edbp t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c, b\u1ea1n ph\u1ea3i ch\u1ec9 r\u00f5 t\u00ean c\u1ee7a trang t\u00ednh \u0111\u1eb7t tr\u01b0\u1edbc d\u1ea5u \u201c!\u201d. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B<\/b><b>$<\/b><b>1, Duongkinh! <\/b><b>$B$1:$I2, 2, FALSE<\/b><b>)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4958\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-1.jpeg\" width=\"600\" height=\"309\" title=\"untitled-1\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu t\u00ean trang t\u00ednh ch\u1ee9a d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, \u0111\u1eb7t n\u00f3 trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B<\/b><b>$1, \u2018\u0110\u01b0\u1eddng k\u00ednh\u2019!$B$1:$I$2, 2, FALSE<\/b><b>)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Khi tham chi\u1ebfu t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1c, \u0111\u1eb7t t\u00ean b\u1ea3ng t\u00ednh trong ngo\u1eb7c vu\u00f4ng:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B<\/b><b>$1, [BOOK1.xlsx]\u0110\u01b0\u1eddngk\u00ednh!$B$1:$I$2, 2, FALSE<\/b><b>)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u00f3ng, b\u1ea1n c\u1ea7n ch\u1ec9 ra \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn b\u1ea3ng t\u00ednh:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B<\/b><b>$1, \u2018D:Reports[Book1.xlsx]\u0110\u01b0\u1eddngk\u00ednh\u2019!$B$1:$I$2, 2, FALSE<\/b><b>)<\/b><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><b>Tip: <\/b><span style=\"font-weight: 400\">Thay v\u00ec \u0111\u00e1nh t\u00ean b\u1ea3ng t\u00ednh v\u00e0 trang t\u00ednh b\u1eb1ng tay, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c \u00f4 trong trang t\u00ednh kh\u00e1c v\u00e0 Excel s\u1ebd th\u00eam tham chi\u1ebfu ngo\u1ea1i tuy\u1ebfn v\u00e0o h\u00e0m c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng <\/span><\/p>\n<p style=\"text-align: justify\"><strong>HLOOKUP v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp m\u1ed9t ph\u1ea7n (s\u1eed d\u1ee5ng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n)<\/strong><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/to-chuc-du-lieu-tranh-loi-vlookup.html\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup<\/a>, h\u00e0m HLOOKUP cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n sau cho tham s\u1ed1 lookup_value:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1ea5u h\u1ecfi (?) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u00ec m\u1ed9t k\u00ed t\u1ef1 \u0111\u01a1n n\u00e0o<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1ea5u sao (*) \u0111\u1ec3 kh\u1edbp v\u1edbi m\u1ed9t chu\u1ed7i c\u00e1c k\u00ed t\u1ef1<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n l\u1ea5y th\u00f4ng tin t\u1eeb m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t v\u00e0i \u0111o\u1ea1n v\u0103n b\u1ea3n n\u1eb1m trong n\u1ed9i dung c\u1ee7a \u00f4 t\u00ecm ki\u1ebfm<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean c\u00e1c kh\u00e1ch h\u00e0ng \u1edf h\u00e0ng 1 v\u00e0 s\u1ed1 order \u1edf h\u00e0ng 2. B\u1ea1n mu\u1ed1n t\u00ecm s\u1ed1 order c\u1ee7a m\u1ed9t kh\u00e1ch h\u00e0ng nh\u1ea5t \u0111\u1ecbnh n\u00e0o \u0111\u00f3 nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 nh\u1edb t\u00ean ch\u00ednh x\u00e1c v\u1ecb kh\u00e1ch m\u00e0 ch\u1ec9 nh\u1edb n\u00f3 b\u1eaft \u0111\u1ea7u v\u1edbi ch\u1eef \u201cLa\u201d.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Cho r\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u1edf \u00f4 B1:I2 (table_array) v\u00e0 th\u1ee9 t\u1ef1 c\u00e1c s\u1ed1 \u1edf h\u00e0ng 2 (row_index_num), c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (\u201cLa*\u201d, B1:I2, 2, FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0o m\u1ed9t \u00f4 c\u1ee5 th\u1ec3, v\u00ed d\u1ee5 B4, v\u00e0 g\u1eafn v\u00e0o \u00f4 \u0111\u00f3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B4&amp;\u201c*\u201d, B1:I2, 2, FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4959\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-20-55-47.png\" width=\"600\" height=\"158\" title=\"screen-shot-2017-05-02-at-20-55-47\"><\/p>\n<p style=\"text-align: justify\"><b>L\u01b0u \u00fd<\/b><\/p>\n<ol style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 h\u00e0m HLOOKUP v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u01b0a k\u1ebft qu\u1ea3 \u0111\u00fang, range_lookup ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t ch\u1ebf \u0111\u1ed9 FALSE<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu table_array ch\u1ee9a nhi\u1ec1u h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb kh\u1edbp v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n, gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean t\u00ecm \u0111\u01b0\u1ee3c s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/span><\/li>\n<\/ol>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"O_tham_chieu_tuyet_doi_va_tuong_doi_trong_HLookup\"><\/span><strong>\u00d4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong HLookup<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang vi\u1ebft h\u00e0m Hlookup cho m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n quan t\u00e2m n\u00ean s\u1eed d\u1ee5ng \u00f4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i hay t\u01b0\u01a1ng \u0111\u1ed1i v\u00ec c\u1ea3 hai \u0111\u1ec1u ph\u00f9 h\u1ee3p. Tuy nhi\u00ean, khi sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4 tham chi\u1ebfu, b\u1ea1n c\u1ea7n ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c hai lo\u1ea1i n\u00e0y<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">table_array lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t c\u1ed1 \u0111\u1ecbnh b\u1eb1ng c\u00e1c \u00f4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u1edbi k\u00ed hi\u1ec7u \u201c$\u201d, v\u00ed d\u1ee5 $B$1:$I$2<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">tham chi\u1ebfu lookup_value l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i ho\u1eb7c h\u1ed7n h\u1ee3p d\u1ef1a tr\u00ean logic kinh doanh c\u1ee7a b\u1ea1n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n, ch\u00fang ta c\u00f9ng xem k\u0129 h\u00e0m Hlookup khi l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c <\/span><\/p>\n<p style=\"text-align: justify\"><b>=HLOOKUP (B$1, Duongkinh!$B$1:$I$2, 2, FALSE)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fang ta s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ($B$1:$I$2) trong table_array v\u00ec n\u00f3 c\u1ea7n \u0111\u01b0\u1ee3c gi\u1eef kh\u00f4ng \u0111\u1ed5i khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p t\u1eeb c\u00e1c \u00f4 kh\u00e1c<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi lookup_value (B$1), ch\u00fang ta s\u1eed d\u1ee5ng tham chi\u1ebfu h\u1ed7n h\u1ee3p, c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i v\u00ec c\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (t\u00ean h\u00e0nh tinh) n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng (h\u00e0ng 1) nh\u01b0ng \u1edf c\u00e1c c\u1ed9t kh\u00e1c nhau (t\u1eeb B \u0111\u1ebfn I) v\u00e0 c\u1ed9t tham chi\u1ebfu n\u00ean thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4960\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-21-20-23.png\" width=\"600\" height=\"158\" title=\"screen-shot-2017-05-02-at-21-20-23\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"INDEXMATCH_MOT_CONG_THUC_HIEU_QUA_KHAC_BEN_CANH_HLOOKUP\"><\/span><strong>INDEX\/MATCH,\u00a0M\u1ed8T C\u00d4NG TH\u1ee8C HI\u1ec6U QU\u1ea2 KH\u00c1C B\u00caN C\u1ea0NH HLOOKUP <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m HLOOKUP c\u00f3 m\u1ed9t v\u00e0i h\u1ea1n ch\u1ebf v\u1edbi nh\u01b0\u1ee3c \u0111i\u1ec3m l\u1edbn nh\u1ea5t l\u00e0 kh\u00f4ng th\u1ec3 th\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m ngo\u00e0i h\u00e0ng \u0111\u1ea7u v\u00e0 ph\u1ea3i x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb theo th\u1ee9 t\u1ef1 khi t\u00ecm k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i. May m\u1eafn thay, s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa <a href=\"http:\/\/blog.ezworkapp.com\/53-%e2%97%8f-cach-su-dung-ham-index-va-match-de-loc-du-lieu-nang-cao-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDEX<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html\" target=\"_blank\" rel=\"noopener noreferrer\">MATCH<\/a> s\u1ebd kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c nh\u1eefng \u0111i\u1ec3m n\u00e0y:<\/span><\/p>\n<p style=\"text-align: justify\"><b>INDEX (n\u01a1i ch\u1ee9a gi\u00e1 tr\u1ecb v\u1ec1, MATCH (gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, n\u01a1i t\u00ecm gi\u00e1 tr\u1ecb, 0))<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 B7, b\u1ea1n \u0111ang t\u00ecm m\u1ed9t k\u1ebft qu\u1ea3 kh\u1edbp \u1edf h\u00e0ng 2 (B2:I2), v\u00e0 mu\u1ed1n gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0ng 1 (B1:I1), c\u00f4ng th\u1ee9c nh\u01b0 sau <\/span><\/p>\n<p style=\"text-align: justify\"><b>=INDEX (B1:I1, MATCH (B7, B2:I2, 0))<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong h\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong c\u1ea3 2 tr\u01b0\u1eddng h\u1ee3p INDEX MATCH \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng t\u1ed1t.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4961\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-21-30-34.png\" width=\"600\" height=\"227\" title=\"screen-shot-2017-05-02-at-21-30-34\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_H-lookup_phan_biet_dang_chu_trong_Excel\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng H-lookup ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp l\u00fac \u0111\u1ea7u, h\u00e0m HLOOKUP kh\u00f4ng th\u1ec3 ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng v\u00e0 in hoa. Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p khi d\u1ea1ng ch\u1eef c\u1ee7a k\u00ed t\u1ef1 quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m EXACT \u0111\u1ec3 so s\u00e1nh c\u00e1c \u00f4 v\u00e0 \u0111\u1eb7t b\u00ean trong h\u00e0m INDEX MATCH nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc:<\/span><\/p>\n<p style=\"text-align: justify\"><b>INDEX (h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1, MATCH (TRUE, EXACT (h\u00e0ng t\u00ecm ki\u1ebfm, gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm), 0))<\/b><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n \u1edf \u00f4 B4, m\u1ea3ng t\u00ecm ki\u1ebfm l\u00e0 B1:I1, m\u1ea3ng gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 B2:I2, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><b>=INDEX (B2:I2, MATCH (TRUE, EXACT (B1:I1, B4), 0))<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4962\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-05-02-at-21-34-58.png\" width=\"600\" height=\"153\" title=\"screen-shot-2017-05-02-at-21-34-58\"><\/p>\n<p style=\"text-align: justify\"><b>L\u01b0u \u00fd: <\/b><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng do \u0111\u00f3 b\u1ea1n ph\u1ea3i \u1ea5n t\u1ed5 h\u1ee3p <span style=\"background-color: #99cc00\">Ctrl + Shift + Enter<\/span> sau khi vi\u1ebft c\u00f4ng th\u1ee9c <\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"10_LY_DO_PHO_BIEN_KHIEN_HLOOKUP_KHONG_CHAY_DUOC\"><\/span><strong>10 L\u00dd DO PH\u1ed4 BI\u1ebeN KHI\u1ebeN HLOOKUP KH\u00d4NG CH\u1ea0Y \u0110\u01af\u1ee2C<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m Hlookup l\u00e0 m\u1ed9t h\u00e0m ph\u1ee9c t\u1ea1p b\u1edfi n\u00f3 c\u00f3 r\u1ea5t nhi\u1ec1u th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c khi\u1ebfn c\u00e1c l\u1ed7i #N\/A, #VALUE ho\u1eb7c #REF th\u01b0\u1eddng xuy\u00ean x\u1ea3y ra. N\u1ebfu h\u00e0m HLOOKUP c\u1ee7a b\u1ea1n kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c, nguy\u00ean nh\u00e2n c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t trong c\u00e1c l\u1ed7i d\u01b0\u1edbi \u0111\u00e2y<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">HLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c h\u00e0ng ph\u00eda tr\u00ean <\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">K\u1ec3 c\u1ea3 khi b\u1ea1n qu\u00ean t\u1ea5t c\u1ea3 c\u00e1c chi ti\u1ebft v\u1ec1 t\u00ecm ki\u1ebfm theo h\u00e0ng ngang trong Excel, lu\u00f4n nh\u1edb r\u1eb1ng Hlookup ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng. N\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm n\u1eb1m \u1edf c\u00e1c h\u00e0ng kh\u00e1c, l\u1ed7i N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c INDEX\/MATCH<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><span style=\"font-weight: 400\"> K\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 ch\u00ednh x\u00e1c <\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Khi b\u1ea1n \u0111ang t\u00ecm gi\u00e1 tr\u1ecb trong Excel, theo h\u00e0ng ngang hay d\u1ecdc, \u0111a s\u1ed1 c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u00e0 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 n\u00ean c\u1ea7n k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c. Khi t\u00ecm ki\u1ebfm v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i (range_lookup \u0111\u01b0\u1ee3c \u0111\u1eb7t TRUE ho\u1eb7c b\u1ecf tr\u1ed1ng), c\u00e1c b\u1ea1n n\u00ean nh\u1edb x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><span style=\"font-weight: 400\"> B\u1ea3ng tham chi\u1ebfu thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Khi s\u1eed d\u1ee5ng nhi\u1ec1u HLOOKUP \u0111\u1ec3 l\u1ea5y th\u00f4ng tin v\u1ec1 h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, b\u1ea1n ph\u1ea3i kho\u00e1 tham chi\u1ebfu table_array<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li><span style=\"font-weight: 400\"> Th\u00eam v\u00e0o ho\u1eb7c xo\u00e1 b\u1edbt h\u00e0ng m\u1edbi<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u t\u1ea1i sao th\u00eam m\u1ed9t h\u00e0ng m\u1edbi c\u00f3 th\u1ec3 l\u00e0m h\u1ecfng c\u00f4ng th\u1ee9c Hlookup, b\u1ea1n c\u1ea7n hi\u1ec3u c\u00e1ch HLOOKUP l\u1ea5y th\u00f4ng tin v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u0111\u00f3 l\u00e0 d\u1ef1a tr\u00ean ch\u1ec9 s\u1ed1 c\u1ee7a h\u00e0ng b\u1ea1n ch\u1ec9 \u0111\u1ecbnh<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 li\u1ec7u doanh s\u1ed1 d\u1ef1a tr\u00ean ID s\u1ea3n ph\u1ea9m. Nh\u1eefng s\u1ed1 li\u1ec7u n\u00e0y \u1edf h\u00e0ng 4 n\u00ean b\u1ea1n \u0111\u00e1nh 4 v\u00e0o tham s\u1ed1 row_index_num. Nh\u01b0ng khi m\u1ed9t h\u00e0ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o, n\u00f3 tr\u1edf th\u00e0nh h\u00e0ng th\u1ee9 5 v\u00e0 Hlookup kh\u00f4ng th\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c. V\u1ea5n \u0111\u1ec1 x\u1ea3y ra t\u01b0\u01a1ng t\u1ef1 nh\u01b0 khi b\u1ea1n xo\u00e1 b\u1edbt m\u1ed9t h\u00e0ng trong b\u1ea3ng.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1ch gi\u1ea3i quy\u1ebft l\u00e0 kho\u00e1 b\u1ea3ng \u0111\u1ec3 tr\u00e1nh vi\u1ec7c ng\u01b0\u1eddi s\u1eed d\u1ee5ng th\u00eam m\u1ed9t h\u00e0ng m\u1edbi v\u00e0o ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c INDEX\/MATCH thay cho Hlookup. Trong Index\/Match, b\u1ea1n ph\u1ea3i ch\u1ec9 r\u00f5 c\u00e1c h\u00e0ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 gi\u00e1 tr\u1ecb v\u1ec1 nh\u01b0 m\u1ea3ng tham chi\u1ebfu v\u00e0 Excel c\u00f3 th\u1ec3 t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh c\u00e1c tham chi\u1ebfu n\u00e0y. Nh\u1edd v\u1eady, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i lo l\u1eafng v\u1ec1 v\u1ea5n \u0111\u1ec1 th\u00eam hay xo\u00e1 b\u1edbt h\u00e0ng nh\u01b0 khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Hlookup. <\/span><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li><span style=\"font-weight: 400\"> Tr\u00f9ng l\u1eb7p trong b\u1ea3ng<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m HLOOKUP trong Excel ch\u1ec9 c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong b\u1ea3ng kh\u1edbp v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu c\u00f3 m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb gi\u1ed1ng nhau trong b\u1ea3ng, ch\u1ecdn m\u1ed9t trong c\u00e1c gi\u1ea3i ph\u00e1p m\u00e0 ph\u00f9 h\u1ee3p v\u1edbi b\u1ea1n nh\u1ea5t:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p b\u1eb1ng c\u00e1ch d\u00f9ng c\u00f4ng c\u1ee5 c\u1ee7a Excel <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n tr\u00f9ng l\u1eb7p \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean trong d\u1eef li\u1ec7u, t\u1ea1o PivotTable \u0111\u1ec3 nh\u00f3m v\u00e0 l\u1ecdc c\u00e1c d\u1eef li\u1ec7u theo y\u00eau c\u1ea7u c\u1ee7a m\u00ecnh <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 r\u00fat c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng kh\u1ecfi m\u1ea3ng t\u00ecm ki\u1ebfm <\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify\" start=\"6\">\n<li><span style=\"font-weight: 400\"> Kho\u1ea3ng tr\u1eafng<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Khi c\u00f4ng th\u1ee9c Hlookup c\u1ee7a b\u1ea1n ho\u00e0n to\u00e0n \u0111\u00fang nh\u01b0ng l\u1ed7i #N\/A v\u1eabn b\u1ecb tr\u1ea3 v\u1ec1, h\u00e3y ki\u1ec3m tra l\u1ea1i b\u1ea3ng v\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm xem c\u00f3 k\u00ed t\u1ef1 tr\u1eafng n\u00e0o kh\u00f4ng. B\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-va-cac-ky-tu-dac-biet-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng<\/a> b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TRIM<\/a> trong Excel.<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li><span style=\"font-weight: 400\"> S\u1ed1 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t d\u1ea1ng v\u0103n b\u1ea3n<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Chu\u1ed7i v\u0103n b\u1ea3n gi\u1ed1ng nh\u01b0 s\u1ed1 l\u00e0 m\u1ed9t kh\u00f3 kh\u0103n kh\u00e1c khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel. M\u00f4 t\u1ea3 chi ti\u1ebft c\u1ee7a v\u1ea5n \u0111\u1ec1 n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch trong T\u1ea1i sao c\u00e1c c\u00f4ng th\u1ee9c Excel ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span><\/p>\n<ol style=\"text-align: justify\" start=\"8\">\n<li><span style=\"font-weight: 400\"> Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u01b0\u1ee3t qu\u00e1 255 k\u00ed t\u1ef1 <\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u1ea5t c\u1ea3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-cac-ham-tim-kiem-tren-excel-2007-2010-2013-2016.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm trong Excel<\/a> ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng khi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm d\u01b0\u1edbi 255 k\u00ed t\u1ef1. Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm d\u00e0i h\u01a1n s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i #VALUE!. V\u00ec h\u00e0m INDEX\/MATCH kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 n\u00ean b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y khi s\u1eed d\u1ee5ng INDEX\/MATCH<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"9\">\n<li><span style=\"font-weight: 400\"> \u0110\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c n\u00eau r\u00f5<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n h\u00e0m Hlookup t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, n\u00ean nh\u1edb r\u1eb1ng b\u1ea1n c\u1ea7n ph\u1ea3i cung c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 \u0111\u01b0\u1eddng d\u1eabn t\u1edbi n\u00f3.<\/span><\/p>\n<ol style=\"text-align: justify\" start=\"10\">\n<li><span style=\"font-weight: 400\"> Sai tham s\u1ed1<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1c b\u1ea1n n\u00ean nh\u1edb r\u1eb1ng h\u00e0m Hlookup l\u00e0 m\u1ed9t h\u00e0m ph\u1ee9c t\u1ea1p n\u00ean th\u1eadt c\u1ea9n th\u1eadn khi s\u1eed d\u1ee5ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i l\u1ed7i ph\u1ed5 bi\u1ebfn khi nh\u1eadp sai tham s\u1ed1<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu row_index_num nh\u1ecf h\u01a1n 1, l\u1ed7i #VALUE! s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i <\/span><\/li>\n<li style=\"font-weight: 400;text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu row_index_num l\u1edbn h\u01a1n s\u1ed1 h\u00e0ng trong b\u1ea3ng t\u00ecm ki\u1ebfm, l\u1ed7i #REF! s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i <\/span><\/li>\n<li style=\"font-weight: 400;text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n t\u00ecm ki\u1ebfm v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 lookup_value nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a table_array, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i<\/span><\/li>\n<\/ul>\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<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-4.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":558,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-557","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/557","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=557"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/557\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/558"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}