{"id":5284,"date":"2024-12-10T11:08:44","date_gmt":"2024-12-10T11:08:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the\/"},"modified":"2024-12-10T11:08:44","modified_gmt":"2024-12-10T11:08:44","slug":"ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the\/","title":{"rendered":"H\u00e0m Vlookup trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Nhi\u1ec1u b\u1ea1n h\u1ecfi v\u1ec1<strong> c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/strong> v\u00e0 h\u00e0m Hlookup trong excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1ch ph\u00e2n bi\u1ec7t khi n\u00e0o th\u00ec s\u1eed d\u1ee5ng h\u00e0m Vlookup khi n\u00e0o th\u00ec d\u00f9ng h\u00e0m Hlookup, h\u00f4m nay <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup, c\u00e1ch ph\u00e2n bi\u1ec7t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3. \u0110\u1eebng b\u1ecf qua b\u1ea1n nh\u00e9!<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6758213b94e24\" 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-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Huong_dan_cach_su_dung_ham_Vlookup_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/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-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Vi_du_cach_su_dung_ham_Vlookup_trong_Excel\" title=\"V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel\">V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Cach_tinh_thue_nhap_khau_theo_doi_tuong\" title=\"C\u00e1ch t\u00ednh thu\u1ebf nh\u1eadp kh\u1ea9u theo \u0111\u1ed1i t\u01b0\u1ee3ng\">C\u00e1ch t\u00ednh thu\u1ebf nh\u1eadp kh\u1ea9u theo \u0111\u1ed1i t\u01b0\u1ee3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Cach_dung_ham_VLOOKUP_de_tim_kiem_gan_dung\" title=\"C\u00e1ch d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang\">C\u00e1ch d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Cach_su_dung_ham_VLOOKUP_ket_hop_voi_Data_Validation_trong_Excel\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi Data Validation trong Excel\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi Data Validation trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Tim_ma_nganh_hoc_su_dung_ham_VLOOKUP\" title=\"T\u00ecm m\u00e3 ng\u00e0nh h\u1ecdc s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\">T\u00ecm m\u00e3 ng\u00e0nh h\u1ecdc s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Su_dung_ham_VLOOKUP_tra_cuu_o_1_file_Excel_khac\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u \u1edf 1 file Excel kh\u00e1c\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u \u1edf 1 file Excel kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Su_dung_ham_VLOOKUP_trong_excel_va_ky_tu_dai_dien\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel v\u00e0 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n *\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel v\u00e0 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n *<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Vi_du_tim_kiem_ma_san_pham_bat_dau_hoac_ket_thuc_boi_mot_chuoi\" title=\"V\u00ed d\u1ee5 t\u00ecm ki\u1ebfm m\u00e3 s\u1ea3n ph\u1ea9m b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1edfi m\u1ed9t chu\u1ed7i\">V\u00ed d\u1ee5 t\u00ecm ki\u1ebfm m\u00e3 s\u1ea3n ph\u1ea9m b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1edfi m\u1ed9t chu\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#5_chu_y_khi_su_dung_ham_VLOOKUP_trong_Excel\" title=\"5 ch\u00fa \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel\">5 ch\u00fa \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Xu_ly_loi_khi_ham_VLOOKUP_khong_tim_thay_gia_tri_can_tra_cuu_loi_NA\" title=\"X\u1eed l\u00fd l\u1ed7i khi h\u00e0m VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u, l\u1ed7i #N\/A\">X\u1eed l\u00fd l\u1ed7i khi h\u00e0m VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u, l\u1ed7i #N\/A<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#5_diem_han_che_cua_ham_Vlookup\" title=\"5 \u0111i\u1ec3m h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m Vlookup\">5 \u0111i\u1ec3m h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m Vlookup<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Chi_ho_tro_tham_chieu_tu_trai_sang_phai\" title=\"Ch\u1ec9 h\u1ed7 tr\u1ee3 tham chi\u1ebfu t\u1eeb tr\u00e1i sang ph\u1ea3i\">Ch\u1ec9 h\u1ed7 tr\u1ee3 tham chi\u1ebfu t\u1eeb tr\u00e1i sang ph\u1ea3i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Chi_hoat_dong_hieu_qua_voi_cac_gia_tri_rieng_biet\" title=\"Ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t\">Ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#So_thu_tu_cot_tham_chieu_luon_co_dinh\" title=\"S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tham chi\u1ebfu lu\u00f4n c\u1ed1 \u0111\u1ecbnh\">S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tham chi\u1ebfu lu\u00f4n c\u1ed1 \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Mac_dinh_thiet_lap_%E2%80%9Capproximate_match%E2%80%9D\" title=\"M\u1eb7c \u0111\u1ecbnh thi\u1ebft l\u1eadp \u201capproximate match\u201d\">M\u1eb7c \u0111\u1ecbnh thi\u1ebft l\u1eadp \u201capproximate match\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html#Lam_toc_do_phan_hoi_cua_bang_tinh_bi_cham_di\" title=\"L\u00e0m t\u1ed1c \u0111\u1ed9 ph\u1ea3n h\u1ed3i c\u1ee7a b\u1ea3ng t\u00ednh b\u1ecb ch\u1eadm \u0111i\">L\u00e0m t\u1ed1c \u0111\u1ed9 ph\u1ea3n h\u1ed3i c\u1ee7a b\u1ea3ng t\u00ednh b\u1ecb ch\u1eadm \u0111i<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_su_dung_ham_Vlookup_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><em>Theo Micorsoft th\u00ec h\u00e0m Vlookup c\u00f3 c\u1ea5u tr\u00fac c\u00fa ph\u00e1p nh\u01b0 sau:<\/em><\/p>\n<div class=\"page\" title=\"Page 205\">\n<div class=\"layoutArea\">\n<div class=\"column\">\n<p style=\"text-align: justify\"><strong>=VLOOKUP(Lookup_value, Table_array, Col_index_ num, [Range_lookup])<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i th\u00edch:<\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Lookup_value:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm. B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 tr\u00ean b\u1ea3ng t\u00ednh Excel.<\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Table_array:<\/strong> B\u1ea3ng gi\u1edbi h\u1ea1n \u0111\u1ec3 d\u00f2 t\u00ecm, b\u1ea1n c\u1ea7n F4 \u0111\u1ec3 Fix c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb cho m\u1ee5c \u0111\u00edch copy c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng laptop, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd c\u1ea7n b\u1ea5m ph\u00edm FN+F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu cho v\u00f9ng b\u1ea3ng t\u00ednh n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Col_index_num<\/strong>: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t l\u1ea5y d\u1eef li\u1ec7u trong b\u1ea3ng c\u1ea7n d\u00f2 t\u00ecm, t\u00ednh t\u1eeb tr\u00e1i qua ph\u1ea3i.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-453.gif\" title=\"ex101_92019-nho-453\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>\u2013 Range_lookup<\/strong>: L\u00e0 gi\u00e1 tr\u1ecb Logic (TRUE=1, FALSE=0) quy\u1ebft \u0111\u1ecbnh so s\u00e1nh, t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c hay so s\u00e1nh, t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i v\u1edbi b\u1ea3ng gi\u1edbi h\u1ea1n.<\/p>\n<p style=\"text-align: justify\">+ N\u1ebfu <strong>Range_lookup = 1 (TRUE)<\/strong>: So s\u00e1nh t\u01b0\u01a1ng \u0111\u1ed1i.<br \/>\n+ N\u1ebfu <strong>Range_lookup = 0 (FALSE)<\/strong>: So s\u00e1nh ch\u00ednh x\u00e1c.<br \/>\n+ N\u1ebfu b\u1ecf qua \u0111\u1ed1i n\u00e0y th\u00ec Excel hi\u1ec3u l\u00e0 <strong>Range_lookup = 1\u00a0<\/strong>m\u1ed9t c\u00e1ch m\u1eb7c \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">V\u1eady khi n\u00e0o th\u00ec s\u1eed d\u1ee5ng h\u00e0m Vlookup v\u00e0 khi n\u00e0o d\u00f9ng h\u00e0m Hlookup?<\/p>\n<p style=\"text-align: justify\">\u0110\u01a1n gi\u1ea3n th\u00f4i, n\u1ebfu b\u1ea3ng gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm x\u1ebfp d\u1ecdc nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y th\u00ec ta d\u00f9ng h\u00e0m Vlookup, c\u00f2n b\u1ea3ng gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm l\u00e0 ngang th\u00ec ta d\u00f9ng h\u00e0m Hlookup, v\u1eady b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb V \u2013 d\u1ecdc, H \u2013 ngang (Trong ti\u1ebfng Anh, V \u2013 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Vertical, c\u00f2n H \u2013 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Horizontal)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_cach_su_dung_ham_Vlookup_trong_Excel\"><\/span><strong>V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_thue_nhap_khau_theo_doi_tuong\"><\/span><strong>C\u00e1ch t\u00ednh thu\u1ebf nh\u1eadp kh\u1ea9u theo \u0111\u1ed1i t\u01b0\u1ee3ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5. B\u1ea1n h\u00e3y t\u00ednh thu\u1ebf nh\u1eadp kh\u1ea5u theo \u0110\u1ed1i t\u01b0\u1ee3ng c\u1ee7a c\u00e1c m\u1eb7t h\u00e0ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<figure id=\"attachment_32795\" aria-describedby=\"caption-attachment-32795\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32795 size-large\" title=\"H\u00e0m Vlookup trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-1024x489-1.png\" alt=\"H\u00e0m vlookup v\u00e0 nhi\u1ec1u v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng\" width=\"1024\" height=\"489\"><figcaption id=\"caption-attachment-32795\" class=\"wp-caption-text\"><em>V\u00ed d\u1ee5 tra c\u1ee9u v\u1edbi h\u00e0m vlookup<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u00ean, t\u1ea1i \u00f4 G5 ta g\u00f5 c\u00f4ng th\u1ee9c:\u00a0<strong>=VLOOKUP(D5,$D$17:$F$20,2,0)*E5<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Vlookup:<\/strong> l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm ra thu\u1ebf nh\u1eadp kh\u1ea9u t\u1ea1i B\u1ea3ng quy \u0111\u1ecbnh thu\u1ebf.<\/li>\n<li><strong>D5:<\/strong> Gi\u00e1 tr\u1ecb l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm \u1edf \u0111\u00e2y l\u00e0 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng t\u1eeb 1,2,3,4.<\/li>\n<li><strong>$D$17:$F$20:<\/strong> B\u1ea3ng gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm, ch\u00ednh l\u00e0 D17:F20 nh\u01b0ng \u0111\u01b0\u1ee3c F4 \u0111\u1ec3 Fix c\u1ed1 \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 \u0111\u1ec3 Copy c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 G6-&gt;G12 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng b\u1ecb thay \u0111\u1ed5i.<\/li>\n<li><strong>2:<\/strong> Th\u1ee9 t\u1ef1 c\u1ed9t gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00ednh l\u00e0 c\u1ed9t Thu\u1ebf nh\u1eadp kh\u1ea9u<\/li>\n<li><strong>0<\/strong>: Tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta l\u1ea5y gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i n\u00ean ch\u1ecdn l\u00e0 0 ho\u1eb7c False<\/li>\n<li><strong>E5<\/strong>: Ch\u00ednh l\u00e0 \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m \u0111\u1ec3 t\u00ednh ra thu\u1ebf nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<figure id=\"attachment_32796\" aria-describedby=\"caption-attachment-32796\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32796 size-large\" title=\"Chi ti\u1ebft c\u00f4ng th\u1ee9c VLOOKUP\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-02-1024x739-1.png\" alt=\"V\u00ed d\u1ee5 h\u00e0m VLOOKUP trong Excel\" width=\"1024\" height=\"739\"><figcaption id=\"caption-attachment-32796\" class=\"wp-caption-text\"><em>Chi ti\u1ebft c\u00f4ng th\u1ee9c VLOOKUP<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify\">V\u1edbi c\u00f4ng th\u1ee9c tr\u00ean, k\u1ebft qu\u1ea3 ta \u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<figure id=\"attachment_32797\" aria-describedby=\"caption-attachment-32797\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-32797\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-03-1024x721-1.png\" alt=\"K\u1ebft qu\u1ea3 khi k\u00e9o c\u00f4ng th\u1ee9c vlookup cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i\" width=\"1024\" height=\"721\" title=\"vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-03-1024x721-1\"><figcaption id=\"caption-attachment-32797\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 khi k\u00e9o c\u00f4ng th\u1ee9c vlookup cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Copy c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 G6-&gt;G12 ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 \u1ea3nh tr\u00ean.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_dung_ham_VLOOKUP_de_tim_kiem_gan_dung\"><\/span>C\u00e1ch d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">S\u1ebd c\u00f3 b\u1ea1n h\u1ecfi m\u00ecnh, l\u00e0m th\u1ebf n\u00e0o x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c\u00a0<strong>Range_lookup=1 hay\u00a0Range_lookup=0?<\/strong><\/p>\n<p style=\"text-align: justify\">Theo \u0111\u00fang \u0111\u1ecbnh ngh\u0129a c\u1ee7a Microsoft Office\u00a0<strong>Range_lookup=1\u00a0<\/strong>khi ch\u00fang ta c\u1ea7n t\u00ecm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i ngh\u0129a l\u00e0 g\u1ea7n \u0111\u00fang hay gi\u00e1 tr\u1ecb h\u1ee3p l\u00fd nh\u1ea5t khi kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0110\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh d\u1ef1a tr\u00ean \u0111i\u1ec3m trung b\u00ecnh trong tr\u01b0\u1eddng h\u1ee3p d\u01b0\u1edbi \u0111\u00e2y th\u00ec\u00a0<strong>Range_lookup=1<\/strong>, v\u00ec \u0111\u1ec3 x\u1ebfp lo\u1ea1i theo b\u1ea3ng tham chi\u1ebfu th\u00ec ta b\u1eaft bu\u1ed9c ph\u1ea3i l\u1ea5y gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i ngh\u0129a l\u00e0 g\u1ea7n \u0111\u00fang, 9.1 g\u1ea7n v\u1edbi 9, 5.3 g\u1ea7n v\u1edbi 5 \u2026 hay di\u1ec5n \u0111\u1ea1t theo m\u1ed9t c\u00e1ch kh\u00e1c, ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u01b0a ra ti\u00eau ch\u00ed x\u1ebfp lo\u1ea1i nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1eeb 9: x\u1ebfp lo\u1ea1i gi\u1ecfi ( l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 9,\u00a0 9 &lt;= x)<\/li>\n<li>T\u1eeb 6.5 \u0111\u1ebfn d\u01b0\u1edbi 9: x\u1ebfp lo\u1ea1i kh\u00e1 (6.5 &lt;= x &lt; 9)<\/li>\n<li>T\u1eeb 5 \u0111\u1ebfn d\u01b0\u1edbi 6.5: x\u1ebfp lo\u1ea1i trung b\u00ecnh (5 &lt;= x &lt; 6.5)<\/li>\n<\/ul>\n<p>\u0110\u1ec3 \u0111i\u1ec1n v\u00e0o c\u1ed9t X\u1ebfp lo\u1ea1i (c\u1ed9t D), ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m VLOOKUP nh\u01b0 sau trong \u00f4 D4:<br \/>\n<code>=VLOOKUP(C4,$B$10:$C$12,2,TRUE)<\/code><\/p>\n<p>ho\u1eb7c<\/p>\n<p><code>=VLOOKUP(C4,$B$10:$C$12,2,1)<\/code><\/p>\n<p><strong>L\u01b0u \u00fd:\u00a0<\/strong>Khi s\u1eed d\u1ee5ng <strong>h\u00e0m VLOOKUP trong Excel<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u g\u1ea7n \u0111\u00fang, b\u1ea3ng tra c\u1ee9u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf t\u1edbi l\u1edbn. N\u1ebfu b\u1ea1n kh\u00f4ng s\u1eafp x\u1ebfp b\u1ea3ng tra c\u1ee9u theo th\u1ee9 t\u1ef1 n\u00e0y, k\u1ebft qu\u1ea3 tra c\u1ee9u d\u00f9ng<strong> h\u00e0m VLOOKUP<\/strong> s\u1ebd b\u1ecb sai.<\/p>\n<figure id=\"attachment_32803\" aria-describedby=\"caption-attachment-32803\" style=\"width: 714px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-32803\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-04.png\" alt=\"V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m vlookup tra c\u1ee9u g\u1ea7n \u0111\u00fang\" width=\"714\" height=\"500\" title=\"vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-04\"><figcaption id=\"caption-attachment-32803\" class=\"wp-caption-text\">V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m vlookup tra c\u1ee9u g\u1ea7n \u0111\u00fang<\/figcaption><\/figure>\n<p>C\u0169ng v\u1edbi v\u00ed d\u1ee5 tra c\u1ee9u x\u1ebfp lo\u1ea1i d\u1ef1a tr\u00ean \u0111i\u1ec3m s\u1ed1 tr\u00ean s\u1eed d\u1ee5ng <strong>h\u00e0m VLOOKUP<\/strong>, khi b\u1ea3ng \u0111i\u1ec3m c\u00f3 m\u1ed9t b\u1ea1n \u0111\u01b0\u1ee3c 4 \u0111i\u1ec3m, th\u00ec ch\u00fang ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c l\u1ed7i #N\/A khi s\u1eed d\u1ee5ng<strong> h\u00e0m VLOOKUP<\/strong>. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y c\u1ee7a <strong>h\u00e0m VLOOKUP<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam v\u00e0o b\u1ea3ng tra c\u1ee9u m\u1ed9t d\u00f2ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi<\/p>\n<figure id=\"attachment_32804\" aria-describedby=\"caption-attachment-32804\" style=\"width: 828px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-32804\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-05.png\" alt=\"V\u00ed d\u1ee5 kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A trong c\u00f4ng th\u1ee9c VLOOKUP\" width=\"828\" height=\"528\" title=\"vi-du-ham-vlookup-va-nhieu-ung-dung-thu-vi-05\"><figcaption id=\"caption-attachment-32804\" class=\"wp-caption-text\">V\u00ed d\u1ee5 kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A trong c\u00f4ng th\u1ee9c VLOOKUP<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_VLOOKUP_ket_hop_voi_Data_Validation_trong_Excel\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi Data Validation trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng h\u00e0m VLOOKUP n\u00e0y, ch\u00fang ta s\u1ebd tham chi\u1ebfu t\u1edbi \u00f4 c\u00f3 Data Validation, \u0111\u1ec3 khi thay \u0111\u1ed5i gi\u00e1 tr\u1ecb trong danh s\u00e1ch dropdown validation n\u00e0y, th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m VLOOKUP c\u0169ng \u0111\u01b0\u1ee3c thay \u0111\u1ed5i m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng.<\/p>\n<p>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean, ch\u00fang ta s\u1ebd \u0111i chu\u1ea9n b\u1ecb Data Validation b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4 C10, sau \u0111\u00f3 b\u1ea5m v\u00e0o th\u1ebb Data \/ Data Validation:<\/p>\n<figure id=\"attachment_32871\" class=\"wp-caption aligncenter\" style=\"width: 584px\" aria-describedby=\"caption-attachment-32871\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32871\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tacca3o-data-validation-c491ecc82cc89-kecc82cc81t-hocc9bcca3p-vocc9bcc81i-hacc80m-vlookup-1.png\" alt=\"Ta\u0323o-Data-Validation-\u0111e\u0302\u0309-ke\u0302\u0301t-ho\u031b\u0323p-vo\u031b\u0301i-ha\u0300m-VLOOKUP\" width=\"584\" height=\"359\" title=\"tacca3o-data-validation-c491ecc82cc89-kecc82cc81t-hocc9bcca3p-vocc9bcc81i-hacc80m-vlookup-1\"><figcaption id=\"caption-attachment-32871\" class=\"wp-caption-text\">T\u1ea1o Data Validation \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m VLOOKUP<\/figcaption><\/figure>\n<p>Trong h\u1ed9p tho\u1ea1i Data Validation, ch\u00fang ta s\u1ebd ch\u1ecdn th\u1ebb Settings (1), sau \u0111\u00f3 trong m\u1ee5c Allow, ch\u1ecdn List (2) v\u00e0 cu\u1ed1i c\u00f9ng ch\u1ecdn Source (3) l\u00e0 v\u00f9ng B4:B7<\/p>\n<figure id=\"attachment_32872\" class=\"wp-caption aligncenter\" style=\"width: 620px\" aria-describedby=\"caption-attachment-32872\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32872\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiecc82cc81t-lacca3cc82p-data-validation-cho-socc82cc81-bacc81o-danh-1.png\" alt=\"Thi\u1ebft l\u1eadp v\u00f9ng d\u1eef li\u1ec7u cho Data Validation\" width=\"620\" height=\"332\" title=\"thiecc82cc81t-lacca3cc82p-data-validation-cho-socc82cc81-bacc81o-danh-1\"><figcaption id=\"caption-attachment-32872\" class=\"wp-caption-text\">Thi\u1ebft l\u1eadp v\u00f9ng d\u1eef li\u1ec7u cho Data Validation<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3, ch\u00fang ta s\u1ebd ho\u00e0n th\u00e0nh h\u00e0m VLOOKUP tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a Data Validation nh\u01b0 h\u00ecnh<\/p>\n<p>\u00a0<\/p>\n<div class=\"oembed-gist\">\n<div id=\"gist107106363\" class=\"gist\">\n<div class=\"gist-file\">\n<div class=\"gist-data\">\n<div class=\"js-gist-file-update-container js-task-list-container file-box\">\n<div id=\"file-vd1_vlookup-md\" class=\"file my-2\">\n<div id=\"file-vd1_vlookup-md-readme\" class=\"Box-body readme blob js-code-block-container p-5 p-xl-6 \">\n<article class=\"markdown-body entry-content container-lg\">\n<pre><code>=VLOOKUP(C10,B4:D7,2,0)\r\n=VLOOKUP(C10,B4:D7,3,0)\r\n<\/code><\/pre>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"gist-meta\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<figure id=\"attachment_32873\" class=\"wp-caption aligncenter\" style=\"width: 718px\" aria-describedby=\"caption-attachment-32873\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32873\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hoacc80n-thacc80nh-hacc80m-vlookup-tham-chiecc82cc81u-c491ecc82cc81n-occ82-cocc81-data-validation-1.png\" alt=\"Ho\u00e0n th\u00e0nh h\u00e0m VLOOKUP tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a Data validation\" width=\"718\" height=\"406\" title=\"hoacc80n-thacc80nh-hacc80m-vlookup-tham-chiecc82cc81u-c491ecc82cc81n-occ82-cocc81-data-validation-1\"><figcaption id=\"caption-attachment-32873\" class=\"wp-caption-text\">Ho\u00e0n th\u00e0nh h\u00e0m VLOOKUP tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a Data validation<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Tim_ma_nganh_hoc_su_dung_ham_VLOOKUP\"><\/span><strong>T\u00ecm m\u00e3 ng\u00e0nh h\u1ecdc s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Y\u00eau c\u1ea7u c\u1ee7a b\u00e0i l\u1ea7n n\u00e0y c\u1ee7a ch\u00fang ta l\u00e0 d\u1ef1a v\u00e0o b\u1ea3ng m\u00e3 ng\u00e0nh \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ra t\u00ean ng\u00e0nh h\u1ecdc c\u1ee7a sinh vi\u00ean d\u1ef1a tr\u00ean k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a s\u1ed1 b\u00e1o danh<\/p>\n<div class=\"code-block code-block-2\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tra-cucc9bcc81u-macc83-ngacc80nh-hocca3c-vocc9bcc81i-vlookup-1.png\" alt=\"Tra c\u1ee9u m\u00e3 ng\u00e0nh h\u1ecdc v\u1edbi h\u00e0m VLOOKUP\" title=\"tra-cucc9bcc81u-macc83-ngacc80nh-hocca3c-vocc9bcc81i-vlookup-1\"><\/div>\n<figure id=\"attachment_32875\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-32875\"><figcaption id=\"caption-attachment-32875\" class=\"wp-caption-text\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Tra c\u1ee9u m\u00e3 ng\u00e0nh h\u1ecdc v\u1edbi h\u00e0m VLOOKUP<\/figcaption><\/figure>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m LEFT nh\u01b0 sau<\/p>\n<div class=\"oembed-gist\">\n<div id=\"gist107106460\" class=\"gist\">\n<div class=\"gist-file\">\n<div class=\"gist-data\">\n<div class=\"js-gist-file-update-container js-task-list-container file-box\">\n<div id=\"file-vd2_vlookup_with_left-md\" class=\"file my-2\">\n<div id=\"file-vd2_vlookup_with_left-md-readme\" class=\"Box-body readme blob js-code-block-container p-5 p-xl-6 \">\n<article class=\"markdown-body entry-content container-lg\">\n<pre>=VLOOKUP(<b>LEFT(C10)<\/b>,F4:G5,2,0)<\/pre>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"gist-meta\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Trong \u0111\u00f3,\u00a0<strong>LEFT(C10)<\/strong>\u00a0s\u1ebd l\u1ea5y ra k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong s\u1ed1 b\u00e1o danh \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 C10, v\u00e0 h\u00e0m VLOOKUP s\u1ebd s\u1eed d\u1ee5ng k\u00fd t\u1ef1 n\u00e0y cho vi\u1ec7c tra c\u1ee9u trong b\u1ea3ng m\u00e3 ng\u00e0nh.<\/p>\n<figure id=\"attachment_32877\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-32877\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-32877\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/kecc82cc81t-hocc9bcca3p-hacc80m-vlookup-vocc9bcc81i-hacc80m-left-1.png\" alt=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m LEFT\" width=\"748\" height=\"394\" title=\"kecc82cc81t-hocc9bcca3p-hacc80m-vlookup-vocc9bcc81i-hacc80m-left-1\"><figcaption id=\"caption-attachment-32877\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m LEFT<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP_tra_cuu_o_1_file_Excel_khac\"><\/span>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u \u1edf 1 file Excel kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_31411\" aria-describedby=\"caption-attachment-31411\" style=\"width: 2560px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31411\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-04.png\" alt=\"Tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb file Excel kh\u00e1c\" width=\"2560\" height=\"1046\" title=\"cach-su-dung-ham-vlookup-trong-excel-04\"><\/a><figcaption id=\"caption-attachment-31411\" class=\"wp-caption-text\">Tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb file Excel kh\u00e1c<\/figcaption><\/figure>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb m\u1ed9t file Excel kh\u00e1c, ch\u00fang ta l\u1ea1i b\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c vi\u1ebft h\u00e0m VLOOKUP \u1edf file\/Workbook ch\u00fang ta mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u, trong \u1ea3nh minh ho\u1ea1 l\u00e0 sheet\u00a0<em>V\u00ed d\u1ee5 03\u00a0<\/em>trong file\u00a0<em>Book1.xlsx.\u00a0<\/em>Sau khi vi\u1ebft gi\u00e1 tr\u1ecb mu\u1ed1n t\u00ecm ki\u1ebfm l\u00e0 SP002 \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 A2, <strong>l\u01b0u \u00fd\u00a0<\/strong>b\u1ea1n c\u1ea7n b\u1ea5m d\u1ea5u ph\u1ea9y, sau \u0111\u00f3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u trong file\u00a0<em>wb kh\u00e1c.xlsx.\u00a0<\/em>Excel s\u1ebd vi\u1ebft c\u00f4ng th\u1ee9c \u0111\u00fang cho ch\u00fang ta, v\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(A2,'[wb kh\u00e1c.xlsx]V\u00ed d\u1ee5 02'!$A$2:$C$7,2,FALSE)<\/code><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p\u00a0<em>wb kh\u00e1c.xlsx\u00a0<\/em>\u0111\u00f3ng, th\u00ec c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a ch\u00fang ta v\u1eabn s\u1ebd ho\u1ea1t \u0111\u1ed9ng, nh\u01b0ng Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u201cvi\u1ebft l\u1ea1i\u201d c\u00f4ng th\u1ee9c VLOOKUP v\u1edbi \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(A2,'C:UsersthanhnguyenDesktop[wb kh\u00e1c.xlsx]V\u00ed d\u1ee5 02'!$A$2:$C$7,2,FALSE)<\/code><\/p>\n<figure id=\"attachment_31413\" aria-describedby=\"caption-attachment-31413\" style=\"width: 1666px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31413\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-05.png\" alt=\"Tra c\u1ee9u vlookup t\u1eeb m\u1ed9t workbook kh\u00e1c\" width=\"1666\" height=\"706\" title=\"cach-su-dung-ham-vlookup-trong-excel-05\"><\/a><figcaption id=\"caption-attachment-31413\" class=\"wp-caption-text\">Tra c\u1ee9u vlookup t\u1eeb m\u1ed9t workbook kh\u00e1c<\/figcaption><\/figure>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html\">C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP GI\u1eeeA 2 SHEET<\/a> TRONG EXCEL<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP_trong_excel_va_ky_tu_dai_dien\"><\/span>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel v\u00e0 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n *<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Gi\u1ed1ng nh\u01b0 nhi\u1ec1u h\u00e0m Excel kh\u00e1c,<strong> h\u00e0m VLOOKUP<\/strong> h\u1ed7 tr\u1ee3 b\u1ea1n s\u1eed d\u1ee5ng k\u00fd t\u1ef1 thay th\u1ebf nh\u01b0<\/p>\n<ul style=\"list-style-type: square\">\n<li>D\u1ea5u * \u0111\u1ec3 thay th\u1ebf cho b\u1ea5t k\u00ec s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 n\u00e0o trong tham s\u1ed1 <em>lookup_value<\/em><\/li>\n<li>D\u1ea5u ? \u0111\u1ec3 thay th\u1ebf cho 1 v\u00e0 ch\u1ec9 1 k\u00fd t\u1ef1 trong tham s\u1ed1\u00a0<em>lookup_value<\/em><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_tim_kiem_ma_san_pham_bat_dau_hoac_ket_thuc_boi_mot_chuoi\"><\/span>V\u00ed d\u1ee5 t\u00ecm ki\u1ebfm m\u00e3 s\u1ea3n ph\u1ea9m b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1edfi m\u1ed9t chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_31415\" aria-describedby=\"caption-attachment-31415\" style=\"width: 1230px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31415\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-06.png\" alt=\"Tra c\u1ee9u v\u1edbi d\u1ea5u * trong VLOOKUP\" width=\"1230\" height=\"850\" title=\"cach-su-dung-ham-vlookup-trong-excel-06\"><\/a><figcaption id=\"caption-attachment-31415\" class=\"wp-caption-text\">Tra c\u1ee9u v\u1edbi d\u1ea5u * trong VLOOKUP<\/figcaption><\/figure>\n<p><code class=\"excel-formula\">=VLOOKUP(\"*AX\",A2:B7,2,FALSE)<\/code><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, d\u1ea5u * thay th\u1ebf cho c\u1ea3 \u0111o\u1ea1n \u201cSP001-ABC-\u201d trong d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n tra c\u1ee9u chu\u1ed7i c\u00f3 ch\u1ee9a ch\u1eef \u201cGFC\u201d \u1edf kho\u1ea3ng gi\u1eefa, th\u00ec c\u00f4ng th\u1ee9c VLOOKUP ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(\"*GFC*\",A2:B7,2,FALSE)<\/code><\/p>\n<p>\u0110\u1ec3 c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1ch ph\u1ea7n \u201cGFC\u201d ra 1 \u00f4 ri\u00eang \u2013 \u00f4 G1 ch\u1eb3ng h\u1ea1n, th\u00ec c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a ch\u00fang ta s\u1ebd nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(\"*\" &amp; G1 &amp; \"*\",A2:B7,2,FALSE)<\/code><\/p>\n<figure id=\"attachment_31416\" aria-describedby=\"caption-attachment-31416\" style=\"width: 1202px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31416\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-07.png\" alt=\"Tra c\u1ee9u VLOOKUP v\u1edbi d\u1ea5u *\" width=\"1202\" height=\"846\" title=\"cach-su-dung-ham-vlookup-trong-excel-07\"><\/a><figcaption id=\"caption-attachment-31416\" class=\"wp-caption-text\">Tra c\u1ee9u VLOOKUP v\u1edbi d\u1ea5u *<\/figcaption><\/figure>\n<p><code class=\"excel-formula\">=VLOOKUP(\"ZZ*\",A2:B7,2,FALSE)<\/code><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng \u201cZZ*\u201d \u0111\u1ec3 tra c\u1ee9u v\u00e0 t\u00ecm ki\u1ebfm \u00f4 d\u1eef li\u1ec7u b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cZZ\u201d<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/VLOOKUP_dtnguyen.zip\">Download file v\u00ed d\u1ee5 (33KB)<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_chu_y_khi_su_dung_ham_VLOOKUP_trong_Excel\"><\/span>5 ch\u00fa \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 khi c\u1ed9t l\u1ea5y k\u1ebft qu\u1ea3 n\u1eb1m v\u1ec1 ph\u00eda b\u00ean tr\u00e1i c\u1ee7a c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u. Ph\u01b0\u01a1ng \u00e1n x\u1eed l\u00fd:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-index-va-ham-match-trong-excel-su-thay-tot-hon-ca-ham-vlookup.html\">s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Index v\u00e0 Match<\/a><\/li>\n<li>H\u00e0m VLOOKUP tra c\u1ee9u kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa \/ ch\u1eef th\u01b0\u1eddng.<\/li>\n<li>Ch\u00fa \u00fd tham s\u1ed1 cu\u1ed1i c\u00f9ng\u00a0<em>[range_lookup]\u00a0<\/em>\u0111\u1ec3 ch\u1ecdn \u0111\u00fang TRUE hay FALSE trong tr\u01b0\u1eddng h\u1ee3p tra c\u1ee9u g\u1ea7n \u0111\u00fang ho\u1eb7c tra c\u1ee9u ch\u00ednh x\u00e1c.<\/li>\n<li>Khi tra c\u1ee9u g\u1ea7n \u0111\u00fang, ch\u00fa \u00fd d\u1eef li\u1ec7u trong c\u1ed9t tra c\u1ee9u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/li>\n<li>Khi gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NA.<\/li>\n<\/ol>\n<p>N\u1ebfu nh\u1eefng v\u00ed d\u1ee5 tr\u00ean ch\u01b0a \u0111\u00e1p \u1ee9ng h\u1ebft nh\u1eefng th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n v\u1ec1 h\u00e0m Vlookup th\u00ec \u0111\u1eebng b\u1ecf qua: <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-vlookup-trong-excel-vi-du-ve-cong-thuc-nang-cao.html\">V\u00cd D\u1ee4 H\u00c0M VLOOKUP N\u00c2NG CAO<\/a><\/strong>\n<\/p>\n<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Xu_ly_loi_khi_ham_VLOOKUP_khong_tim_thay_gia_tri_can_tra_cuu_loi_NA\"><\/span><span id=\"Vi_du_3_Xu_ly_loi_khi_ham_VLOOKUP_khong_tim_thay_gia_tri_can_tra_cuu_loi_NA\" class=\"ez-toc-section\"><\/span>X\u1eed l\u00fd l\u1ed7i khi h\u00e0m VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u, l\u1ed7i #N\/A<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong b\u1ea3ng tra c\u1ee9u, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n<figure id=\"attachment_32879\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-32879\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-32879\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hacc80m-vlookup-khocc82ng-ticc80m-thacc82cc81y-giacc81-tricca3-tra-cucc9bcc81u-locc82cc83i-na-1.png\" alt=\"H\u00e0m VLOOKUP v\u00e0 l\u1ed7i #N\/A\" width=\"656\" height=\"316\" title=\"hacc80m-vlookup-khocc82ng-ticc80m-thacc82cc81y-giacc81-tricca3-tra-cucc9bcc81u-locc82cc83i-na-1\"><figcaption id=\"caption-attachment-32879\" class=\"wp-caption-text\">H\u00e0m VLOOKUP v\u00e0 l\u1ed7i #N\/A<\/figcaption><\/figure>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01b0a ra m\u1ed9t th\u00f4ng b\u00e1o r\u00f5 r\u00e0ng h\u01a1n, c\u00f3 \u00fd ngh\u0129a h\u01a1n, v\u00ed d\u1ee5 \u201cKh\u00f4ng t\u00ecm th\u1ea5y s\u1ed1 b\u00e1o danh\u201d, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR trong \u00f4 C12 nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<div class=\"oembed-gist\">\n<div id=\"gist107106591\" class=\"gist\">\n<div class=\"gist-file\">\n<div class=\"gist-data\">\n<div class=\"js-gist-file-update-container js-task-list-container file-box\">\n<div id=\"file-vd3_vlookup_na-md\" class=\"file my-2\">\n<div id=\"file-vd3_vlookup_na-md-readme\" class=\"Box-body readme blob js-code-block-container p-5 p-xl-6 \">\n<article class=\"markdown-body entry-content container-lg\">\n<pre>=<b>IFERROR(<\/b>VLOOKUP(C10,B4:D7,2,0)<b>,\"Kh\u00f4ng t\u00ecm th\u1ea5y SB\u0110\")<\/b>\r\n<\/pre>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"gist-meta\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>H\u00e0m IFERROR s\u1ebd ph\u00e1t hi\u1ec7n l\u1ed7i #N\/A trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ch\u00fang ta \u0111\u01b0a ra l\u00e0 \u201cKh\u00f4ng t\u00ecm th\u1ea5y SB\u0110\u201d.<\/p>\n<p>\u0110\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p l\u1ed7i ph\u1ed5 bi\u1ebfn khi b\u1ea1n s\u1eed d\u1ee5ng H\u00e0m Vlookup \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c. \u0110\u1ec3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eeda nh\u1eefng l\u1ed7i kh\u00e1c khi s\u1eed d\u1ee5ng h\u00e0m Vlookup nh\u01b0 l\u1ed7i L\u1ed7i #REF!, L\u00f4\u0303i #VALUE!, L\u1ed7i #NAME? th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n nh\u00e9! <strong>C\u00e1c<a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao-xu-ly-loi-na-vlookup.html\"> l\u1ed7i h\u00e0m Vlookup<\/a> th\u01b0\u1eddng g\u1eb7p nh\u1ea5t \u0111\u1ecbnh b\u1ea1n ph\u1ea3i bi\u1ebft \u0111\u1ec3 tr\u00e1nh<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_diem_han_che_cua_ham_Vlookup\"><\/span><strong>5 \u0111i\u1ec3m h\u1ea1n ch\u1ebf c\u1ee7a h\u00e0m Vlookup<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9966 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-drawbacks.jpeg\" width=\"598\" height=\"412\" title=\"vlookup-drawbacks\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chi_ho_tro_tham_chieu_tu_trai_sang_phai\"><\/span>Ch\u1ec9 h\u1ed7 tr\u1ee3 tham chi\u1ebfu t\u1eeb tr\u00e1i sang ph\u1ea3i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng cho r\u1eb1ng Vlookup ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng theo chi\u1ec1u t\u1eeb tr\u00e1i sang ph\u1ea3i, ch\u1ee9 kh\u00f4ng c\u00f3 chi\u1ec1u \u00a0ng\u01b0\u1ee3c l\u1ea1i. M\u1ed9t s\u1ed1 kh\u00e1c cho r\u1eb1ng \u0111\u1ec3 c\u00f3 th\u1ec3 d\u00f9ng Vlookup tham chi\u1ebfu t\u1eeb ph\u1ea3i sang th\u00ec b\u1eaft bu\u1ed9c ph\u1ea3i k\u1ebft h\u1ee3p nhi\u1ec1u c\u00f4ng th\u1ee9c l\u1ea1i v\u1edbi nhau.<\/p>\n<p>Th\u1ef1c t\u1ebf m\u00e0 n\u00f3i, vi\u1ec7c k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t thao t\u00e1c kh\u00e1 l\u00e0 r\u1eafc r\u1ed1i v\u00e0 kh\u00f4ng h\u1ec1 d\u1ec5 d\u00e0ng g\u00ec. V\u00ec th\u1ebf \u0111\u00e2y v\u1eabn \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t h\u1ea1n ch\u1ebf l\u1edbn c\u1ee7a Vlookup<\/p>\n<p>Gi\u1ea3i ph\u00e1p: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Match &amp; Index<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chi_hoat_dong_hieu_qua_voi_cac_gia_tri_rieng_biet\"><\/span>Ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vlookup c\u00f3 xu h\u01b0\u1edbng ch\u1ec9 quan t\u00e2m \u0111\u1ebfn gi\u00e1 tr\u1ecb tham chi\u1ebfu \u0111\u1ea7u v\u00e0 b\u1ecf qu\u00ean c\u00e1c d\u00f2ng kh\u00e1c ch\u1ee9a gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1. N\u1ebfu nh\u01b0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 qu\u00e1 nhi\u1ec1u s\u1ef1 ph\u00e2n h\u00f3a th\u00ec b\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e1ch lu\u1eadt m\u1ed9t ch\u00fat \u0111\u1ec3 Vlookup c\u00f3 th\u1ec3 tham chi\u1ebfu \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n.<\/p>\n<p>Gi\u1ea3i ph\u00e1p: T\u1ea1o m\u1ed9t b\u1ea3ng Pivot ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Vlookup m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_thu_tu_cot_tham_chieu_luon_co_dinh\"><\/span>S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tham chi\u1ebfu lu\u00f4n c\u1ed1 \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t tham chi\u1ebfu \u0111\u01b0\u1ee3c \u0111i\u1ec1n th\u1ee7 c\u00f4ng v\u00e0o n\u1ed9i dung c\u1ee7a c\u00f4ng th\u1ee9c khi\u1ebfn cho thao t\u00e1c sao ch\u00e9p sang \u00f4 t\u00ednh kh\u00e1c g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n v\u00e0 b\u1ea5t ti\u1ec7n.<\/p>\n<p>Gi\u1ea3i ph\u00e1p: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng s\u1ed1 th\u1ee9 t\u1ef1 bi\u1ebfn \u0111\u1ed5i li\u00ean t\u1ee5c th\u00f4ng qua h\u00e0m Match<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mac_dinh_thiet_lap_%E2%80%9Capproximate_match%E2%80%9D\"><\/span>M\u1eb7c \u0111\u1ecbnh thi\u1ebft l\u1eadp \u201capproximate match\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu \u0111\u1ec3 \u00fd k\u1ef9, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m duy\u1ec7t tham chi\u1ebfu \u1edf trong n\u1ed9i dung h\u00e0m Vlookup l\u00e0 y\u1ebfu t\u1ed1 t\u00f9y ch\u1ecdn (\u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u b\u1eb1ng hai d\u1ea5u ngo\u1eb7c vu\u00f4ng []) n\u00ean n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng \u0111i\u1ec1n n\u1ed9i dung g\u00ec v\u00e0o \u0111\u00f3 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 m\u1eb7c \u0111\u1ecbnh l\u00e0 \u201capproximate match\u201d<\/p>\n<p>B\u1ea1n th\u1eadt s\u1ef1 c\u1ea7n ph\u1ea3i ch\u00fa \u00fd n\u1ebfu nh\u01b0 kh\u00f4ng mu\u1ed1n k\u1ebft qu\u1ea3 tham chi\u1ebfu tr\u1edf n\u00ean sai l\u1ec7ch<\/p>\n<p>Gi\u1ea3i ph\u00e1p: Lu\u00f4n ch\u00fa \u00fd ph\u1ea3i thi\u1ebft l\u1eadp l\u00e0 \u201cexact match\u201d \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 tham chi\u1ebfu ch\u00ednh x\u00e1c nh\u1ea5t, tuy nhi\u00ean n\u1ebfu b\u1ea1n v\u1eabn mu\u1ed1n ch\u1ecdn thi\u1ebft l\u1eadp m\u1eb7c \u0111\u1ecbnh \u201capproximate match\u201d th\u00ec ph\u1ea3i th\u1eadt s\u1ef1 c\u1ea9n th\u1eadn<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_toc_do_phan_hoi_cua_bang_tinh_bi_cham_di\"><\/span>L\u00e0m t\u1ed1c \u0111\u1ed9 ph\u1ea3n h\u1ed3i c\u1ee7a b\u1ea3ng t\u00ednh b\u1ecb ch\u1eadm \u0111i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t v\u00e0i \u00fd ki\u1ebfn cho r\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u h\u00e0m Vlookup \u0111\u1ec3 tham chi\u1ebfu s\u1ebd l\u00e0m gi\u1ea3m hi\u1ec7u n\u0103ng c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh, th\u1eadm ch\u00ed g\u00e2y ra hi\u1ec7n t\u01b0\u1ee3ng crash.<\/p>\n<p>Gi\u1ea3i ph\u00e1p: B\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng h\u00e0m Vlookup c\u1ea7n d\u00f9ng, tuy nhi\u00ean c\u1ed1 g\u1eafng thay th\u1ebf ch\u00fang b\u1eb1ng l\u1ec7nh Paste Special \u0111\u1ec3 thay th\u1ebf c\u00e1c h\u00e0m b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh, \u0111i\u1ec1u \u0111\u00f3 s\u1ebd gi\u00fap ch\u01b0\u01a1ng tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u k\u0129 h\u01a1n v\u1ec1 c\u00e1ch tra c\u1ee9u g\u1ea7n \u0111\u00fang, tra c\u1ee9u v\u1edbi k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n d\u1ea5u sao * trong<strong> h\u00e0m VLOOKUP<\/strong>, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i b\u00e0i vi\u1ebft c\u1eadp nh\u1eadt:<\/p>\n<p>T\u1ea5t c\u1ea3 v\u1ec1<strong> h\u00e0m VLOOKUP trong excel<\/strong> c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/p>\n<p>Ngo\u00e0i ra, n\u1ebfu b\u1ea1n th\u00edch xem video h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m VLOOKUP c\u0169ng nh\u01b0 nh\u1eefng h\u00e0m tra c\u1ee9u kh\u00e1c nh\u01b0 Index v\u00e0 Match, th\u00ec Thanh c\u00f3 chu\u1ea9n b\u1ecb s\u1eb5n video sau \u0111\u00e2y \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/_LkdkZjO2zY\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p style=\"text-align: justify\">Hi v\u1ecdng v\u1edbi b\u00e0i vi\u1ebft chia s\u1ebb n\u00e0y c\u00e1c b\u1ea1n s\u1ebd n\u1eafm \u0111\u01b0\u1ee3c chi ti\u1ebft v\u1ec1<strong> h\u00e0m Vlookup trong excel<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng. Trong th\u1eddi gian t\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd chia s\u1ebb th\u00eam v\u1ec1 h\u00e0m Hlookup v\u00e0 c\u00e1c h\u00e0m k\u1ebft h\u1ee3p v\u1edbi <strong>h\u00e0m Vlookup<\/strong> v\u00e0 Hlookup hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c.<\/p>\n<p style=\"text-align: justify\">B\u00ean c\u1ea1nh \u0111\u00f3, \u0111\u1ec3 gi\u00fap c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o, ti\u1ebft ki\u1ec7m th\u1eddi gian tra c\u1ee9u, \u1ee9ng d\u1ee5ng linh ho\u1ea1t, ph\u00e1t tri\u1ec3n k\u1ef9 n\u0103ng s\u1eed d\u1ee5ng h\u00e0m v\u00e0 l\u1ed3ng gh\u00e9p h\u00e0m, H\u1ecdc Excel Online \u0111\u00e3 thi\u1ebft k\u1ebf ra ch\u01b0\u01a1ng tr\u00ecnh Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao, \u0111\u00e2y l\u00e0 ch\u01b0\u01a1ng tr\u00ecnh h\u1ecdc tr\u1ef1c tuy\u1ebfn \u0111\u1ea7y \u0111\u1ee7 c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf, c\u00f3 s\u1ef1 h\u1ed7 tr\u1ee3 gi\u1ea3i \u0111\u00e1p c\u1ee7a gi\u1ea3ng vi\u00ean v\u00e0 chuy\u00ean gia Nguy\u1ec5n \u0110\u1ee9c Thanh trong su\u1ed1t qu\u00e1 tr\u00ecnh h\u1ecdc, h\u1ecdc vi\u00ean c\u00f3 th\u1ec3 h\u1ecdc \u0111i h\u1ecdc l\u1ea1i nhi\u1ec1u l\u1ea7n, h\u1ecdc linh ho\u1ea1t b\u1ea5t k\u1ef3 th\u1eddi \u0111i\u1ec3m n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><em>Chi ti\u1ebft v\u1ec1 kho\u00e1 h\u1ecdc, b\u1ea1n vui l\u00f2ng tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\"><strong>EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/strong><\/a><\/em><\/p>\n<p style=\"text-align: justify\">\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 tr\u00ean.\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-453.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5285,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5284","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=5284"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5285"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}