{"id":7298,"date":"2024-12-21T17:15:32","date_gmt":"2024-12-21T17:15:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau\/"},"modified":"2024-12-21T17:15:32","modified_gmt":"2024-12-21T17:15:32","slug":"ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau\/","title":{"rendered":"H\u00e0m VLOOKUP trong Excel, h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng<a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.html\"> <strong>h\u00e0m VLOOKUP trong Excel<\/strong> <\/a>v\u1edbi nhi\u1ec1u v\u00ed d\u1ee5 c\u01a1 b\u1ea3n c\u1ee5 th\u1ec3, gi\u1ea3i th\u00edch vi\u1ec7c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m VLOOKUP<\/strong><\/a> t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh trong worksheet kh\u00e1c ho\u1eb7c t\u1eeb m\u1ed9t file Excel kh\u00e1c, t\u00ecm ki\u1ebfm s\u1eed d\u1ee5ng VLOOKUP v\u00e0 k\u00fd t\u1ef1 * \u2026<\/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-6766f7b310c08\" 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-chi-tiet-cho-nguoi-moi-bat-dau.html#Ham_VLOOKUP_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung_co_ban\" title=\"H\u00e0m VLOOKUP trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n\">H\u00e0m VLOOKUP trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.html#Cu_phap_cua_ham_VLOOKUP\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP\">C\u00fa ph\u00e1p c\u1ee7a 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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.html#Lam_the_nao_de_su_dung_ham_VLOOKUP_trong_thuc_te\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong th\u1ef1c t\u1ebf\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong th\u1ef1c t\u1ebf<\/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-chi-tiet-cho-nguoi-moi-bat-dau.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-5\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.html#Su_dung_ham_VLOOKUP_trong_excel_tra_cuu_o_1_sheet_khac\" title=\"S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel: tra c\u1ee9u \u1edf 1 sheet kh\u00e1c\">S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel: tra c\u1ee9u \u1edf 1 sheet kh\u00e1c<\/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-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.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-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.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>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"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-chi-tiet-cho-nguoi-moi-bat-dau.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<\/ul>\n<\/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-vlookup-trong-excel-huong-dan-chi-tiet-cho-nguoi-moi-bat-dau.html#Tra_cuu_gan_dung_voi_ham_VLOOKUP_trong_Excel\" title=\"Tra c\u1ee9u g\u1ea7n \u0111\u00fang v\u1edbi h\u00e0m VLOOKUP trong Excel\">Tra c\u1ee9u g\u1ea7n \u0111\u00fang v\u1edbi h\u00e0m VLOOKUP trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung_co_ban\"><\/span>H\u00e0m VLOOKUP trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m VLOOKUP l\u00e0 g\u00ec? \u0110\u1ea7u ti\u00ean, h\u00e0m VLOOKUP l\u00e0 m\u1ed9t h\u00e0m t\u00ecm ki\u1ebfm trong Microsoft Excel. H\u00e0m VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb b\u1ea1n \u0111\u01b0a v\u00e0o v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u00f9ng d\u00f2ng \u1edf m\u1ed9t c\u1ed9t kh\u00e1c trong b\u1ea3ng.<\/p>\n<p>H\u00e0m VLOOKUP c\u00f3 m\u1eb7t trong c\u00e1c phi\u00ean b\u1ea3n Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_VLOOKUP\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/code><\/p>\n<p>H\u00e0m VLOOKUP c\u00f3 4 tham s\u1ed1, 3 tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, tham s\u1ed1 th\u1ee9 4 \u1edf trong ngo\u1eb7c vu\u00f4ng [range_lookup] l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c. Tr\u01b0\u1edbc khi \u0111i t\u00ecm hi\u1ec3u m\u1ed7i tham s\u1ed1 c\u00f3 \u00fd ngh\u0129a th\u1ebf n\u00e0o, ch\u00fang ta h\u00e3y c\u00f9ng nhau xem v\u00ed d\u1ee5 sau \u0111\u00e2y:<\/p>\n<figure id=\"attachment_31396\" aria-describedby=\"caption-attachment-31396\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31396\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-01.png\" alt=\"cach-su-dung-ham-vlookup-trong-excel-01\" width=\"653\" height=\"334\" title=\"cach-su-dung-ham-vlookup-trong-excel-01\"><\/a><figcaption id=\"caption-attachment-31396\" class=\"wp-caption-text\">V\u00ed d\u1ee5 01<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u1ea7n ph\u1ea3i t\u00ecm \u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 s\u1ea3n ph\u1ea9m l\u00e0\u00a0<em>SP004,\u00a0<\/em>c\u00f4ng th\u1ee9c VLOOKUP \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u00f4 <em>F2\u00a0<\/em>l\u00e0<\/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-657.gif\" title=\"ex101_92019-nho-657\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><code class=\"excel-formula\">=VLOOKUP(\"SP004\",A2:C7,3,FALSE)<\/code><\/p>\n<ul style=\"list-style-type: square\">\n<li><code class=\"excel-formula-args\">lookup_value<\/code>l\u00e0 gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 thu\u1ed9c ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c ki\u1ec3u chu\u1ed7i, ki\u1ec3u tham chi\u1ebfu ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ra b\u1edfi m\u1ed9t h\u00e0m kh\u00e1c. Trong c\u00f4ng th\u1ee9c tr\u00ean, chu\u1ed7i \u201cSP004\u201d l\u00e0\u00a0<em>lookup_value.<\/em><\/li>\n<li><code class=\"excel-formula-args\">table_array<\/code>v\u00f9ng d\u1eef li\u1ec7u g\u1ed3m \u00edt nh\u1ea5t 2 c\u1ed9t. H\u00e0m VLOOKUP lu\u00f4n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm \u2013\u00a0<em>lookup_value<\/em> trong <strong>c\u1ed9t \u0111\u1ea7u ti\u00ean.\u00a0<\/strong>Trong c\u00f4ng th\u1ee9c tr\u00ean, v\u00f9ng <em>A2:C7<\/em> l\u00e0 <em>table_array<\/em> bao g\u1ed3m 3 c\u1ed9t, h\u00e0m VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm chu\u1ed7i \u201cSP004\u201d trong c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t A.<\/li>\n<li><code class=\"excel-formula-args\">col_index_num<\/code>l\u00e0 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong b\u1ea3ng <em>table_array<\/em> . Trong v\u00ed d\u1ee5 tr\u00ean, <em>table_array<\/em> l\u00e0 A2:C7, c\u1ed9t C l\u00e0 c\u1ed9t th\u1ee9 3 trong b\u1ea3ng n\u00e0y.<\/li>\n<li><code class=\"excel-formula-args\">[range_lookup]<\/code> tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c, nh\u1eadn gi\u00e1 tr\u1ecb TRUE ho\u1eb7c 1 (t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang) ho\u1eb7c FALSE ho\u1eb7c 0 (t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c)\n<ul style=\"list-style-type: square\">\n<li><em>FALSE\u00a0<\/em>tham s\u1ed1 <em>range_lookup<\/em> khi nh\u1eadn gi\u00e1 tr\u1ecb FALSE s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c cho\u00a0<em>lookup_value.\u00a0<\/em>Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, VLOOKUP s\u1ebd t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c chu\u1ed7i \u201cSP004\u201d trong c\u1ed9t A, trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i <code class=\"excel-formula-err\">#N\/A<\/code><\/li>\n<li>TRUE tham s\u1ed1\u00a0<em>range_lookup\u00a0<\/em>khi nh\u1eadn gi\u00e1 tr\u1ecb TRUE s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0ng nh\u1ecf h\u01a1n\u00a0<em>lookup_value.\u00a0<\/em>\u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 s\u1eed d\u1ee5ng t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang c\u1ee7a h\u00e0m VLOOKUP l\u00e0 c\u1ed9t t\u00ecm ki\u1ebfm c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, n\u1ebfu ch\u00fang ta vi\u1ebft chu\u1ed7i c\u1ea7n t\u00ecm ki\u1ebfm l\u00e0 \u201cSP004\u201d v\u00e0o trong c\u00f4ng th\u1ee9c VLOOKUP, th\u00ec m\u1ed7i l\u1ea7n c\u1ea7n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb m\u1edbi s\u1ebd r\u1ea5t m\u1ea5t c\u00f4ng s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c, v\u1eady n\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft l\u1ea1i c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(F1,A2:C7,3,FALSE)<\/code><\/p>\n<p>V\u1eady l\u00e0 m\u1ed7i khi ch\u00fang ta c\u1ea7n thay \u0111\u1ed5i m\u00e3 s\u1ea3n ph\u1ea9m, b\u1ea1n ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i trong \u00f4 F1, ho\u1eb7c n\u1ebfu b\u1ea1n \u0111\u00e3 thi\u1ebft l\u1eadp <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box.html\">Data Validation<\/a> cho \u00f4 F1, th\u00ec b\u1ea1n ch\u1ec9 vi\u1ec7c ch\u1ecdn \u1edf danh s\u00e1ch Data Validation n\u00e0y.<\/p>\n<figure id=\"attachment_31405\" aria-describedby=\"caption-attachment-31405\" style=\"width: 1296px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31405\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-02.png\" alt=\"S\u1eed d\u1ee5ng VLOOKUP v\u1edbi Data Validation List\" width=\"1296\" height=\"664\" title=\"cach-su-dung-ham-vlookup-trong-excel-02\"><\/a><figcaption id=\"caption-attachment-31405\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng VLOOKUP v\u1edbi Data Validation List<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_ham_VLOOKUP_trong_thuc_te\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c, m\u1ed9t \u0111i\u1ec1u b\u1ea1n lu\u00f4n lu\u00f4n n\u00ean ch\u00fa \u00fd \u0111\u00f3 ch\u00ednh l\u00e0 kho\u00e1 tham chi\u1ebfu \u0111\u1ed1i v\u1edbi b\u1ea3ng tra c\u1ee9u. H\u00e3y c\u00f9ng nhau t\u00ecm hi\u1ec3u v\u00ed d\u1ee5 sau \u0111\u00e2y<\/p>\n<figure id=\"attachment_31406\" aria-describedby=\"caption-attachment-31406\" style=\"width: 1440px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31406\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-03.png\" alt=\"Kho\u00e1 tham chi\u1ebfu khi s\u1eed d\u1ee5ng VLOOKUP\" width=\"1440\" height=\"664\" title=\"cach-su-dung-ham-vlookup-trong-excel-03\"><\/a><figcaption id=\"caption-attachment-31406\" class=\"wp-caption-text\">Kho\u00e1 tham chi\u1ebfu khi s\u1eed d\u1ee5ng VLOOKUP<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u1ea7n ph\u1ea3i ho\u00e0n thi\u1ec7n vi\u1ec7c tra c\u1ee9u S\u1ed1 l\u01b0\u1ee3ng v\u00e0 \u0110\u01a1n gi\u00e1 \u1edf c\u1ed9t F v\u00e0 c\u1ed9t G, n\u1ebfu ch\u00fang ta kh\u00f4ng kho\u00e1 tham chi\u1ebfu t\u1edbi b\u1ea3ng tra c\u1ee9u <strong>$A$2:$C$7<\/strong> \u00a0th\u00ec khi k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb F2 xu\u1ed1ng cho F3 v\u00e0 F4 v\u00f9ng tham chi\u1ebfu n\u00e0y s\u1ebd b\u1ecb l\u1ec7ch v\u00e0 d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VLOOKUP kh\u00f4ng ch\u00ednh x\u00e1c.<\/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: <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<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_VLOOKUP_trong_excel_tra_cuu_o_1_sheet_khac\"><\/span>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong excel: tra c\u1ee9u \u1edf 1 sheet kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_31409\" aria-describedby=\"caption-attachment-31409\" style=\"width: 1474px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-03-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31409\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-03-1.png\" alt=\"VLOOKUP b\u1ea3ng tra c\u1ee9u \u1edf sheet kh\u00e1c\" width=\"1474\" height=\"1172\" title=\"cach-su-dung-ham-vlookup-trong-excel-03-1\"><\/a><figcaption id=\"caption-attachment-31409\" class=\"wp-caption-text\">VLOOKUP b\u1ea3ng tra c\u1ee9u \u1edf sheet kh\u00e1c<\/figcaption><\/figure>\n<p><code class=\"excel-formula\">=VLOOKUP(A2,'V\u00ed d\u1ee5 02'!$A$2:$C$7,2,FALSE)<\/code><\/p>\n<p>\u0110\u1ec3 tra c\u1ee9u s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a s\u1ea3n ph\u1ea9m v\u1edbi m\u00e3\u00a0<em>SP002\u00a0<\/em>tr\u00ean sheet\u00a0<em>V\u00ed d\u1ee5 03,\u00a0<\/em>b\u1ea1n b\u1eaft \u0111\u1ea7u t\u1eeb sheet\u00a0<em>V\u00ed d\u1ee5 03\u00a0<\/em>b\u1eaft \u0111\u1ea7u vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP trong \u00f4 B2 nh\u01b0 b\u00ecnh th\u01b0\u1eddng, khi c\u1ea7n ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u, ch\u00fang ta ch\u1ec9 c\u1ea7n b\u1ea5m sang sheet\u00a0<em>V\u00ed d\u1ee5 02,\u00a0<\/em>sau \u0111\u00f3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u nh\u01b0 b\u00ecnh th\u01b0\u1eddng, Excel s\u1ebd \u0111\u1ee7 th\u00f4ng minh \u0111\u1ec3 c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 ch\u00fang ta vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP t\u1ef1 \u0111\u1ed9ng \u0111\u00fang nh\u01b0 tr\u00ean h\u00ecnh minh ho\u1ea1.<\/p>\n<h2><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><\/h2>\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-1.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-1\"><\/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-1.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-1\"><\/a><figcaption id=\"caption-attachment-31413\" class=\"wp-caption-text\">Tra c\u1ee9u vlookup t\u1eeb m\u1ed9t workbook kh\u00e1c<\/figcaption><\/figure>\n<h2><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><\/h2>\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-1.png\" alt=\"Tra c\u1ee9u v\u1edbi d\u1ea5u * trong VLOOKUP\" width=\"1230\" height=\"850\" title=\"cach-su-dung-ham-vlookup-trong-excel-06-1\"><\/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-1.png\" alt=\"Tra c\u1ee9u VLOOKUP v\u1edbi d\u1ea5u *\" width=\"1202\" height=\"846\" title=\"cach-su-dung-ham-vlookup-trong-excel-07-1\"><\/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<h2><span class=\"ez-toc-section\" id=\"Tra_cuu_gan_dung_voi_ham_VLOOKUP_trong_Excel\"><\/span>Tra c\u1ee9u g\u1ea7n \u0111\u00fang v\u1edbi h\u00e0m VLOOKUP trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e2y gi\u1edd s\u1ebd l\u00e0 l\u00fac ch\u00fang ta nh\u00ecn k\u1ef9 h\u01a1n v\u00e0o tham s\u1ed1 th\u1ee9 4 trong h\u00e0m VLOOKUP<\/p>\n<p><code class=\"excel-formula\">=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/code><\/p>\n<p><em>[range_lookup] <\/em>nh\u1eadn gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE.<\/p>\n<ul style=\"list-style-type: square\">\n<li>FALSE cho tr\u01b0\u1eddng h\u1ee3p tra c\u1ee9u ch\u00ednh x\u00e1c m\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p v\u00ed d\u1ee5 trong b\u00e0i vi\u1ebft n\u00e0y, n\u1ebfu b\u1ea1n ng\u1ea1i vi\u1ebft FALSE h\u01a1i d\u00e0i th\u00ec ta c\u00f3 th\u1ec3 thay b\u1eb1ng s\u1ed1 0 v\u1edbi t\u00e1c d\u1ee5ng t\u01b0\u01a1ng t\u1ef1.<\/li>\n<li>TRUE cho tr\u01b0\u1eddng h\u1ee3p tra c\u1ee9u g\u1ea7n \u0111\u00fang, thay v\u00ec g\u00f5 TRUE, ch\u00fang ta c\u00f3 th\u1ec3 g\u00f5 s\u1ed1 1.<\/li>\n<\/ul>\n<figure id=\"attachment_31419\" aria-describedby=\"caption-attachment-31419\" style=\"width: 1484px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-08.png\" alt=\"Tra c\u1ee9u g\u1ea7n \u0111\u00fang VLOOKUP trong Excel\" width=\"1484\" height=\"618\" title=\"cach-su-dung-ham-vlookup-trong-excel-08\"><\/a><figcaption id=\"caption-attachment-31419\" class=\"wp-caption-text\">Tra c\u1ee9u g\u1ea7n \u0111\u00fang VLOOKUP trong Excel<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5 tra c\u1ee9u g\u1ea7n \u0111\u00fang v\u1edbi VLOOKUP nh\u01b0 sau, b\u1ea1n l\u00e0m qu\u1ea3n l\u00fd v\u00e0 \u0111\u01b0a ra KPI cho c\u00e1c nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng, t\u1edbi cu\u1ed1i th\u00e1ng, b\u1ea1n s\u1ebd c\u1ea7n t\u00ednh hoa h\u1ed3ng d\u1ef1a tr\u00ean t\u1eebng b\u1eadc doanh thu cho c\u00e1c b\u1ea1n Sales n\u00e0y, r\u00f5 r\u00e0ng vi\u1ec7c s\u1eed d\u1ee5ng tra c\u1ee9u ch\u00ednh x\u00e1c v\u1edbi VLOOKUP s\u1ebd kh\u00f4ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1, c\u00f2n c\u00e1ch gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch vi\u1ebft r\u1ea5t nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau s\u1ebd gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 n\u00e0y nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ef1 t\u1ed1i \u01b0u, \u0111\u00f3 ch\u00ednh l\u00e0 l\u00fd do b\u1ea1n \u0111ang \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y t\u1edbi t\u1eadn b\u00e2y gi\u1edd. Ch\u00fang ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">F2=VLOOKUP(E2,$A$2:$B$7,2,TRUE)<\/code><\/p>\n<p><strong>L\u01b0u \u00fd<\/strong> khi ch\u00fang ta s\u1eed d\u1ee5ng VLOOKUP \u1edf d\u1ea1ng n\u00e0y l\u00e0: <strong>s\u1eafp x\u1ebfp c\u1ed9t d\u1eef li\u1ec7u<\/strong> (C\u1ed9t A trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y) theo <strong>th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf t\u1edbi l\u1edbn<\/strong>. B\u1edfi v\u00ec, VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t v\u00e0 nh\u1ecf h\u01a1n\u00a0<em>lookup_value \u2013 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm.\u00a0<\/em>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 #N\/A ch\u00fang ta \u0111ang g\u1eb7p ph\u1ea3i trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 ho\u00e0n to\u00e0n \u0111\u00fang v\u1edbi c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a VLOOKUP, b\u1edfi v\u00ec trong c\u1ed9t A \u2013 Doanh thu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o nh\u1ecf h\u01a1n 96 c\u1ea3. \u0110\u1ec3 x\u1eed l\u00fd l\u1ed7i #N\/A trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m IFNA ho\u1eb7c IFERROR nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">F2=IFNA(VLOOKUP(E2,$A$2:$B$7,2,TRUE),\"Kh\u00f4ng c\u00f3 hoa h\u1ed3ng\")<\/code><\/p>\n<p><code class=\"excel-formula\">F2=IFERROR(VLOOKUP(E2,$A$2:$B$7,2,TRUE),\"Kh\u00f4ng c\u00f3 hoa h\u1ed3ng\")<\/code><\/p>\n<figure id=\"attachment_31420\" aria-describedby=\"caption-attachment-31420\" style=\"width: 1772px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-ham-vlookup-trong-excel-09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-vlookup-trong-excel-09.png\" alt=\"X\u1eed l\u00fd l\u1ed7i #N\/A khi d\u00f9ng VLOOKUP\" width=\"1772\" height=\"666\" title=\"cach-su-dung-ham-vlookup-trong-excel-09\"><\/a><figcaption id=\"caption-attachment-31420\" class=\"wp-caption-text\">X\u1eed l\u00fd l\u1ed7i #N\/A khi d\u00f9ng VLOOKUP<\/figcaption><\/figure>\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<p>C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc t\u1edbi \u0111\u00e2y. Ch\u00fac th\u00e0nh c\u00f4ng.<\/p>\n<p>\u0110T Nguy\u1ec5n.<\/p>\n<p>P.S: Nh\u1eefng ki\u1ebfn th\u1ee9c trong b\u00e0i n\u00e0y s\u1ebd l\u00e0 n\u1ec1n t\u1ea3ng c\u01a1 b\u1ea3n \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc ti\u1ebfp b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/p>\n<ul style=\"list-style-type: square\">\n<li><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi.html\">\u1ee8ng d\u1ee5ng h\u00e0m LOOKUP trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-bi-loi-na-loi-name-loi-value-va-cach-khac-phuc.html\">X\u1eed l\u00fd l\u1ed7i NA, l\u1ed7i NAME, l\u1ed7i VALUE trong c\u00f4ng th\u1ee9c VLOOKUP<\/a><\/li>\n<\/ul>\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-657.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7298","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\/7298","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=7298"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7299"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}