{"id":99146,"date":"2024-09-24T09:06:54","date_gmt":"2024-09-24T02:06:54","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=99146"},"modified":"2025-04-01T16:37:32","modified_gmt":"2025-04-01T09:37:32","slug":"huong-dan-su-dung-ham-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel k\u00e8m v\u00ed d\u1ee5"},"content":{"rendered":"\n<p>B\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel v\u00e0 c\u1ea3m th\u1ea5y vi\u1ec7c t\u00ecm ki\u1ebfm th\u00f4ng tin qu\u00e1 m\u1ea5t th\u1eddi gian? H\u00e0m VLOOKUP ch\u00ednh l\u00e0 th\u1ee7 thu\u1eadt gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c \u0111\u00e1ng k\u1ec3. V\u1edbi h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng l\u1edbn ch\u1ec9 v\u1edbi v\u00e0i c\u00fa click chu\u1ed9t. C\u00f9ng <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\" target=\"_blank\" rel=\"noreferrer noopener\">Phong V\u0169 Tech News<\/a> kh\u00e1m ph\u00e1 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m VLOOKUP v\u00e0 nh\u1eefng \u1ee9ng d\u1ee5ng th\u1ef1c ti\u1ec5n c\u1ee7a n\u00f3 trong c\u00f4ng vi\u1ec7c nh\u00e9!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/\" target=\"_blank\" rel=\"noreferrer noopener\">H\u01b0\u1edbng d\u1eabn xu\u1ed1ng d\u00f2ng trong Excel v\u00e0 Google Sheets \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-tron-excel-don-gian-nhat\/\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 Excel c\u01a1 b\u1ea3n, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a19f277122e5\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a19f277122e5\"  type=\"checkbox\" id=\"item-6a19f277122e5\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Cong_thuc_ham_VLOOKUP\" title=\"C\u00f4ng th\u1ee9c h\u00e0m VLOOKUP\">C\u00f4ng th\u1ee9c h\u00e0m VLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_ve_ham_VLOOKUP\" title=\"V\u00ed d\u1ee5 v\u1ec1 h\u00e0m VLOOKUP\">V\u00ed d\u1ee5 v\u1ec1 h\u00e0m VLOOKUP<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_1_Tim_kiem_diem_so_cua_hoc_sinh\" title=\"V\u00ed d\u1ee5 1: T\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh\">V\u00ed d\u1ee5 1: T\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_2_Tim_ten_san_pham_dua_tren_ma_san_pham\" title=\"V\u00ed d\u1ee5 2: T\u00ecm t\u00ean s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m\">V\u00ed d\u1ee5 2: T\u00ecm t\u00ean s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_3_Tim_muc_luong_dua_tren_cap_bac\" title=\"V\u00ed d\u1ee5 3: T\u00ecm m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean c\u1ea5p b\u1eadc\">V\u00ed d\u1ee5 3: T\u00ecm m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean c\u1ea5p b\u1eadc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_4_Tinh_tong_tien_hang\" title=\"V\u00ed d\u1ee5 4: T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng\">V\u00ed d\u1ee5 4: T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Vi_du_5_Kiem_tra_dieu_kien_va_tra_ve_ket_qua\" title=\"V\u00ed d\u1ee5 5: Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\">V\u00ed d\u1ee5 5: Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Mot_so_loi_thuong_gap_ve_ham_VLOOKUP\" title=\"M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m VLOOKUP\">M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m VLOOKUP<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Loi_NA\" title=\"L\u1ed7i #N\/A\">L\u1ed7i #N\/A<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Loi_REF\" title=\"L\u1ed7i #REF!\">L\u1ed7i #REF!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Loi_VALUE\" title=\"L\u1ed7i #VALUE!\">L\u1ed7i #VALUE!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Loi_NAME\" title=\"L\u1ed7i #NAME?\">L\u1ed7i #NAME?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Cac_loi_khac_va_cach_khac_phuc_chung\" title=\"C\u00e1c l\u1ed7i kh\u00e1c v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c chung\">C\u00e1c l\u1ed7i kh\u00e1c v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c chung<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Mot_so_luu_y_khi_dung_ham_VLOOKUP\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VLOOKUP\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VLOOKUP<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Cot_tra_cuu_luon_phai_o_vi_tri_dau_tien\" title=\"C\u1ed9t tra c\u1ee9u lu\u00f4n ph\u1ea3i \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean\">C\u1ed9t tra c\u1ee9u lu\u00f4n ph\u1ea3i \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Kieu_so_sanh_chinh_xac_hay_tuong_doi\" title=\"Ki\u1ec3u so s\u00e1nh: ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i\">Ki\u1ec3u so s\u00e1nh: ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#So_cot_tra_ve\" title=\"S\u1ed1 c\u1ed9t tr\u1ea3 v\u1ec1\">S\u1ed1 c\u1ed9t tr\u1ea3 v\u1ec1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Khoa_bang_du_lieu_table_array\" title=\"Kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u (table_array)\">Kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u (table_array)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Kieu_du_lieu_cua_gia_tri_tra_cuu\" title=\"Ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u\">Ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/phongvu.vn\/cong-nghe\/huong-dan-su-dung-ham-vlookup-trong-excel\/#Tong_ket\" title=\"T\u1ed5ng k\u1ebft\">T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_VLOOKUP\"><\/span><strong>C\u00f4ng th\u1ee9c h\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u01b0ng v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng. H\u00e3y h\u00ecnh dung b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch s\u1ea3n ph\u1ea9m v\u1edbi c\u00e1c th\u00f4ng tin nh\u01b0 m\u00e3 s\u1ea3n ph\u1ea9m, t\u00ean s\u1ea3n ph\u1ea9m, gi\u00e1 b\u00e1n, v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 b\u00e1n c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3. Thay v\u00ec ph\u1ea3i l\u01b0\u1edbt qua t\u1eebng d\u00f2ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, h\u00e0m VLOOKUP s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-1024x640.jpg\" alt=\"H\u00e0m VLOOKUP l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm th\u00f4ng tin c\u1ea7n t\u00ecm trong b\u1ea3ng\" class=\"wp-image-99147\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">H\u00e0m VLOOKUP l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm th\u00f4ng tin c\u1ea7n t\u00ecm trong b\u1ea3ng<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m VLOOKUP nh\u01b0 sau:<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\">=VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/p>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>lookup_value:<\/strong> Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm. \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u00f3.&nbsp;&nbsp;&nbsp;<\/li>\n\n\n\n<li><strong>table_array: <\/strong>Ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm. \u0110\u00e2y l\u00e0 m\u1ed9t b\u1ea3ng ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4.<\/li>\n\n\n\n<li><strong>col_index_num:<\/strong> S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1. C\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng lu\u00f4n c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 1.<\/li>\n\n\n\n<li><strong>range_lookup:<\/strong> (T\u00f9y ch\u1ecdn) M\u1ed9t gi\u00e1 tr\u1ecb logic (TRUE ho\u1eb7c FALSE) ch\u1ec9 \u0111\u1ecbnh ki\u1ec3u t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n\n\n\n<p>N\u1ebfu Range_lookup = 1 (TRUE): d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/p>\n\n\n\n<p>N\u1ebfu Range_lookup = 0 (FALSE): d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-1024x640.jpg\" alt=\"=VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)\" class=\"wp-image-99148\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">=VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_ve_ham_VLOOKUP\"><\/span><strong>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u00e2y gi\u1edd, ch\u00fang ta s\u1ebd c\u00f9ng nhau kh\u00e1m ph\u00e1 nh\u1eefng v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 th\u1ea5y r\u00f5 h\u01a1n v\u1ec1 s\u1ee9c m\u1ea1nh c\u1ee7a h\u00e0m VLOOKUP trong vi\u1ec7c t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u. Th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n s\u1ebd n\u1eafm v\u1eefng c\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c VLOOKUP hi\u1ec7u qu\u1ea3 v\u00e0 \u00e1p d\u1ee5ng n\u00f3 v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng l\u00e0m vi\u1ec7c kh\u00e1c nhau. H\u00e3y c\u00f9ng b\u1eaft \u0111\u1ea7u nh\u00e9!<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_1_Tim_kiem_diem_so_cua_hoc_sinh\"><\/span><strong>V\u00ed d\u1ee5 1: T\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m c\u1ee7a m\u1ed9t l\u1edbp h\u1ecdc nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-1024x640.jpg\" alt=\"T\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh\" class=\"wp-image-99149\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n t\u00ecm \u0111i\u1ec3m To\u00e1n c\u1ee7a h\u1ecdc sinh c\u00f3 t\u00ean \u201cNguy\u1ec5n V\u0103n A\u201d. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/p>\n\n\n\n<p>=VLOOKUP(\u201cNguy\u1ec5n V\u0103n A\u201d; A2:D5; 3; FALSE)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=0#gid=0\" target=\"_blank\" rel=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=0#gid=0 noreferrer noopener nofollow\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-1024x640.jpg\" alt=\"T\u00ecm \u0111i\u1ec3m To\u00e1n c\u1ee7a h\u1ecdc sinh c\u00f3 t\u00ean \u201cNguy\u1ec5n V\u0103n A\u201d\" class=\"wp-image-99150\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><figcaption class=\"wp-element-caption\">T\u00ecm \u0111i\u1ec3m To\u00e1n c\u1ee7a h\u1ecdc sinh c\u00f3 t\u00ean \u201cNguy\u1ec5n V\u0103n A\u201d<\/figcaption><\/figure>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li>Nguy\u1ec5n V\u0103n A: L\u00e0 t\u00ean h\u1ecdc sinh c\u1ea7n t\u00ecm.<\/li>\n\n\n\n<li>A2:D5: L\u00e0 ph\u1ea1m vi b\u1ea3ng \u0111i\u1ec3m.<\/li>\n\n\n\n<li>3: L\u00e0 c\u1ed9t th\u1ee9 3 (c\u1ed9t \u0110i\u1ec3m To\u00e1n) m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n\n\n\n<li>FALSE: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_2_Tim_ten_san_pham_dua_tren_ma_san_pham\"><\/span><strong>V\u00ed d\u1ee5 2: T\u00ecm t\u00ean s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng danh s\u00e1ch s\u1ea3n ph\u1ea9m nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-1024x640.jpg\" alt=\"T\u00ecm t\u00ean s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m\" class=\"wp-image-99151\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm t\u00ean s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n bi\u1ebft t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 l\u00e0 SP002. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/p>\n\n\n\n<p>=VLOOKUP(&#8220;SP002&#8221;; A2:D4; 2; FALSE)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=270165837#gid=270165837\" target=\"_blank\" rel=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=270165837#gid=270165837 noreferrer noopener nofollow\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-1024x640.jpg\" alt=\"T\u00ecm t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 l\u00e0 SP002\" class=\"wp-image-99152\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><figcaption class=\"wp-element-caption\">T\u00ecm t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 l\u00e0 SP002<\/figcaption><\/figure>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li>SP002: L\u00e0 m\u00e3 s\u1ea3n ph\u1ea9m c\u1ea7n t\u00ecm.<\/li>\n\n\n\n<li>A2:D4: L\u00e0 ph\u1ea1m vi b\u1ea3ng \u0111i\u1ec3m.<\/li>\n\n\n\n<li>2: L\u00e0 c\u1ed9t th\u1ee9 2 (c\u1ed9t T\u00ean s\u1ea3n ph\u1ea9m) m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n\n\n\n<li>FALSE: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_3_Tim_muc_luong_dua_tren_cap_bac\"><\/span><strong>V\u00ed d\u1ee5 3: T\u00ecm m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean c\u1ea5p b\u1eadc<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng l\u01b0\u01a1ng nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-1024x640.jpg\" alt=\"T\u00ecm m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean c\u1ea5p b\u1eadc\" class=\"wp-image-99153\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm m\u1ee9c l\u01b0\u01a1ng d\u1ef1a tr\u00ean c\u1ea5p b\u1eadc<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n bi\u1ebft m\u1ee9c l\u01b0\u01a1ng c\u01a1 b\u1ea3n c\u1ee7a nh\u00e2n vi\u00ean c\u1ea5p b\u1eadc 2. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/p>\n\n\n\n<p>=VLOOKUP(2; A2:D4; 2; FALSE)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=961570361#gid=961570361\" target=\"_blank\" rel=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=961570361#gid=961570361 noreferrer noopener nofollow\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-1024x640.jpg\" alt=\"T\u00ednh m\u1ee9c l\u01b0\u01a1ng c\u01a1 b\u1ea3n c\u1ee7a nh\u00e2n vi\u00ean c\u1ea5p b\u1eadc 2\" class=\"wp-image-99154\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><figcaption class=\"wp-element-caption\">T\u00ednh m\u1ee9c l\u01b0\u01a1ng c\u01a1 b\u1ea3n c\u1ee7a nh\u00e2n vi\u00ean c\u1ea5p b\u1eadc 2<\/figcaption><\/figure>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li>2: L\u00e0 m\u00e3 nh\u00e2n vi\u00ean c\u1ea5p b\u1eadc c\u1ea7n t\u00ecm.<\/li>\n\n\n\n<li>A2:D4: L\u00e0 ph\u1ea1m vi b\u1ea3ng \u0111i\u1ec3m.<\/li>\n\n\n\n<li>2: L\u00e0 c\u1ed9t th\u1ee9 2 (c\u1ed9t M\u1ee9c l\u01b0\u01a1ng c\u01a1 b\u1ea3n) m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n\n\n\n<li>FALSE: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_4_Tinh_tong_tien_hang\"><\/span><strong>V\u00ed d\u1ee5 4: T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111\u01a1n h\u00e0ng nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-1024x640.jpg\" alt=\"T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng\" class=\"wp-image-99156\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng<\/figcaption><\/figure>\n\n\n\n<p>V\u1edbi b\u1ea3ng gi\u00e1 s\u1ea3n ph\u1ea9m nh\u01b0 v\u00ed d\u1ee5 tr\u00ean. B\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng ti\u1ec1n cho m\u1ed7i \u0111\u01a1n h\u00e0ng.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1o th\u00eam m\u1ed9t c\u1ed9t <strong>Th\u00e0nh ti\u1ec1n <\/strong>trong b\u1ea3ng \u0111\u01a1n h\u00e0ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2<\/strong>: \u1ede \u00f4 t\u00ednh t\u1ed5ng ti\u1ec1n c\u1ee7a \u0111\u01a1n h\u00e0ng \u0111\u1ea7u ti\u00ean, nh\u1eadp c\u00f4ng th\u1ee9c:<\/li>\n<\/ul>\n\n\n\n<p>=VLOOKUP(A2; A2:C9; 3; FALSE) * B2<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=746350263#gid=746350263\" target=\"_blank\" rel=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=746350263#gid=746350263 noreferrer noopener nofollow\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-1024x640.jpg\" alt=\"H\u00e0m n\u00e0y s\u1ebd t\u00ecm gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 SP001\" class=\"wp-image-99157\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><figcaption class=\"wp-element-caption\">H\u00e0m n\u00e0y s\u1ebd t\u00ecm gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 SP001<\/figcaption><\/figure>\n\n\n\n<p>Trong \u0111\u00f3:&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>VLOOKUP(A2, A7:C9, 3, FALSE)<\/strong>: H\u00e0m n\u00e0y s\u1ebd t\u00ecm gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 SP001 trong b\u1ea3ng gi\u00e1 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 5000.<\/li>\n\n\n\n<li><strong>* B2:<\/strong> Nh\u00e2n k\u1ebft qu\u1ea3 tr\u00ean (5000) v\u1edbi s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m (2) \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng ti\u1ec1n l\u00e0 10000.<\/li>\n<\/ul>\n\n\n\n<p>Sau khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Enter, \u00f4 D2 s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 l\u00e0 10000. \u0110\u1ec3 t\u00ednh t\u1ed5ng ti\u1ec1n cho c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f2n l\u1ea1i, b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c \u1edf \u00f4 D2 xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_5_Kiem_tra_dieu_kien_va_tra_ve_ket_qua\"><\/span><strong>V\u00ed d\u1ee5 5: Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m nh\u01b0 h\u00ecnh v\u00e0 mu\u1ed1n ki\u1ec3m tra h\u1ecdc sinh \u0111\u1ea1t hay kh\u00f4ng \u0111\u1ea1t.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-1024x640.jpg\" alt=\"Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\" class=\"wp-image-99158\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-11.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1o th\u00eam m\u1ed9t c\u1ed9t &#8220;K\u1ebft qu\u1ea3&#8221;.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2<\/strong>: \u1ede \u00f4 k\u1ebft qu\u1ea3 c\u1ee7a h\u1ecdc sinh \u0111\u1ea7u ti\u00ean, nh\u1eadp c\u00f4ng th\u1ee9c:<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-left\">=IF(VLOOKUP(&#8220;Nguy\u1ec5n V\u0103n A&#8221;; A2:C4; 3; FALSE) &gt;= 5; &#8220;\u0110\u1ea1t&#8221;; &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=1021997634#gid=1021997634\" target=\"_blank\" rel=\"https:\/\/docs.google.com\/spreadsheets\/d\/1KpZSA-Hl0m3QtQf9d05hyjYRuA4vHaFkBPIbTXFyRLo\/edit?gid=1021997634#gid=1021997634 noreferrer noopener nofollow\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-1024x640.jpg\" alt=\"Mu\u1ed1n ki\u1ec3m tra h\u1ecdc sinh \u0111\u1ea1t hay kh\u00f4ng \u0111\u1ea1t theo \u0111i\u1ec3m to\u00e1n\" class=\"wp-image-99159\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><figcaption class=\"wp-element-caption\">Mu\u1ed1n ki\u1ec3m tra h\u1ecdc sinh \u0111\u1ea1t hay kh\u00f4ng \u0111\u1ea1t theo \u0111i\u1ec3m to\u00e1n<\/figcaption><\/figure>\n\n\n\n<p>C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd ki\u1ec3m tra xem \u0111i\u1ec3m To\u00e1n c\u1ee7a h\u1ecdc sinh c\u00f3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 kh\u00f4ng. N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 &#8220;\u0110\u1ea1t&#8221;, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_loi_thuong_gap_ve_ham_VLOOKUP\"><\/span><strong>M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m VLOOKUP l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel. Tuy nhi\u00ean, khi s\u1eed d\u1ee5ng n\u00f3, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loi_NA\"><\/span><strong>L\u1ed7i #N\/A<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng t\u1ed3n t\u1ea1i<\/strong>: Gi\u00e1 tr\u1ecb b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm kh\u00f4ng c\u00f3 trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Sai ki\u1ec3u d\u1eef li\u1ec7u<\/strong>: Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau (v\u00ed d\u1ee5: s\u1ed1 v\u00e0 v\u0103n b\u1ea3n).<\/li>\n\n\n\n<li><strong>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u sai<\/strong>: N\u1ebfu s\u1eed d\u1ee5ng t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang (TRUE), c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-1024x640.jpg\" alt=\"L\u1ed7i #N\/A\" class=\"wp-image-99160\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-13.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ed7i #N\/A<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng gi\u00e1 tr\u1ecb b\u1ea1n nh\u1eadp ch\u00ednh x\u00e1c v\u00e0 t\u1ed3n t\u1ea1i trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra ki\u1ec3u d\u1eef li\u1ec7u<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 gi\u1ed1ng nhau.<\/li>\n\n\n\n<li><strong>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/strong>: N\u1ebfu s\u1eed d\u1ee5ng t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang, h\u00e3y s\u1eafp x\u1ebfp c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loi_REF\"><\/span><strong>L\u1ed7i #REF!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Tham chi\u1ebfu \u00f4 kh\u00f4ng h\u1ee3p l\u1ec7:<\/strong> Ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u (table_array) ho\u1eb7c s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t (col_index_num) kh\u00f4ng \u0111\u00fang.<\/li>\n\n\n\n<li><strong>B\u1ea3ng d\u1eef li\u1ec7u b\u1ecb x\u00f3a ho\u1eb7c di chuy\u1ec3n<\/strong>: Ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 b\u1ecb thay \u0111\u1ed5i.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-1024x640.jpg\" alt=\"L\u1ed7i #REF!\" class=\"wp-image-99161\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-14.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ed7i #REF!<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c:<\/strong> \u0110\u1ea3m b\u1ea3o r\u1eb1ng ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t \u0111\u01b0\u1ee3c nh\u1eadp ch\u00ednh x\u00e1c.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea3ng d\u1eef li\u1ec7u v\u1eabn t\u1ed3n t\u1ea1i v\u00e0 kh\u00f4ng b\u1ecb di chuy\u1ec3n.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loi_VALUE\"><\/span><strong>L\u1ed7i #VALUE!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t kh\u00f4ng h\u1ee3p l\u1ec7<\/strong>: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t (col_index_num) kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean d\u01b0\u01a1ng ho\u1eb7c l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 m\u1ed9t m\u1ea3ng<\/strong>: B\u1ea1n \u0111ang c\u1ed1 g\u1eafng t\u00ecm ki\u1ebfm m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb thay v\u00ec m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-1024x640.jpg\" alt=\"L\u1ed7i #VALUE!\" class=\"wp-image-99162\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-15.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ed7i #VALUE!<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Ki\u1ec3m tra l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean d\u01b0\u01a1ng v\u00e0 n\u1eb1m trong ph\u1ea1m vi c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ch\u1ec9 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME\"><\/span><strong>L\u1ed7i #NAME?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>T\u00ean h\u00e0m vi\u1ebft sai:<\/strong> T\u00ean h\u00e0m VLOOKUP b\u1ecb vi\u1ebft sai ho\u1eb7c c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba.<\/li>\n\n\n\n<li><strong>Tham s\u1ed1 kh\u00f4ng h\u1ee3p l\u1ec7<\/strong>: M\u1ed9t trong c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m kh\u00f4ng h\u1ee3p l\u1ec7 (v\u00ed d\u1ee5: d\u1ea5u ngo\u1eb7c \u0111\u01a1n kh\u00f4ng \u0111\u00f3ng \u0111\u00fang).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-1024x640.jpg\" alt=\"L\u1ed7i #NAME?\" class=\"wp-image-99163\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-16.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ed7i #NAME?<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u00ean h\u00e0m v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m \u0111\u01b0\u1ee3c vi\u1ebft ch\u00ednh x\u00e1c.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra c\u00e1c tham s\u1ed1: <\/strong>Ki\u1ec3m tra l\u1ea1i t\u1eebng tham s\u1ed1 c\u1ee7a h\u00e0m \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u00fang h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cac_loi_khac_va_cach_khac_phuc_chung\"><\/span><strong>C\u00e1c l\u1ed7i kh\u00e1c v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c chung<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>K\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u trong b\u1ea3ng ch\u00ednh x\u00e1c v\u00e0 kh\u00f4ng c\u00f3 l\u1ed7i.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c<\/strong>: \u0110\u1ecdc k\u1ef9 c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 th\u1ef1c hi\u1ec7n \u0111\u00fang ch\u1ee9c n\u0103ng mong mu\u1ed1n.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i v\u00e0 kh\u00f3 hi\u1ec3u:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>S\u1eed d\u1ee5ng c\u00e1c \u00f4 trung gian<\/strong>: Chia nh\u1ecf c\u00f4ng th\u1ee9c th\u00e0nh c\u00e1c ph\u1ea7n nh\u1ecf h\u01a1n v\u00e0 s\u1eed d\u1ee5ng c\u00e1c \u00f4 trung gian \u0111\u1ec3 l\u01b0u tr\u1eef k\u1ebft qu\u1ea3 trung gian.<\/li>\n\n\n\n<li><strong>\u0110\u1eb7t t\u00ean cho ph\u1ea1m vi: <\/strong>\u0110\u1eb7t t\u00ean cho c\u00e1c ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/li>\n<\/ul>\n\n\n\n<div class=\"pv-products-card\"><div class=\"pv-products-title\"><div>Tham kh\u1ea3o ngay m\u1ed9t s\u1ed1 Laptop khuy\u1ebfn m\u00e3i t\u1ed1t nh\u1ea5t t\u1ea1i Phong V\u0169:<\/div><\/div><div class=\"pv-products\" data-type=\"carousel\" data-key=\"product-area\" data-skus=\"201201617,211208142,220202624,220802884,230300147,230302704,230400582,230402849,231004203,231004204\"><\/div><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_dung_ham_VLOOKUP\"><\/span><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m VLOOKUP l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel, nh\u01b0ng \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3, ch\u00fang ta c\u1ea7n n\u1eafm r\u00f5 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec3m b\u1ea1n c\u1ea7n ghi nh\u1edb:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cot_tra_cuu_luon_phai_o_vi_tri_dau_tien\"><\/span><strong>C\u1ed9t tra c\u1ee9u lu\u00f4n ph\u1ea3i \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u0110\u00e2y l\u00e0 quy t\u1eafc b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m VLOOKUP. Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm (lookup_value) ph\u1ea3i n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u.N\u1ebfu kh\u00f4ng tu\u00e2n th\u1ee7 quy t\u1eafc n\u00e0y, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 #N\/A (kh\u00f4ng t\u00ecm th\u1ea5y). V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm th\u00f4ng tin v\u1ec1 m\u1ed9t s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean m\u00e3 s\u1ea3n ph\u1ea9m, th\u00ec c\u1ed9t &#8220;M\u00e3 s\u1ea3n ph\u1ea9m&#8221; ph\u1ea3i l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-1024x640.jpg\" alt=\"C\u1ed9t tra c\u1ee9u lu\u00f4n ph\u1ea3i \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean\" class=\"wp-image-99164\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-17.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u1ed9t tra c\u1ee9u lu\u00f4n ph\u1ea3i \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Kieu_so_sanh_chinh_xac_hay_tuong_doi\"><\/span><strong>Ki\u1ec3u so s\u00e1nh: ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Tham s\u1ed1 range_lookup l\u00e0 tham s\u1ed1 quy\u1ebft \u0111\u1ecbnh ki\u1ec3u so s\u00e1nh.<\/p>\n\n\n\n<ul>\n<li><strong>FALSE (0)<\/strong>: So s\u00e1nh ch\u00ednh x\u00e1c. Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ph\u1ea3i tr\u00f9ng kh\u1edbp ho\u00e0n to\u00e0n v\u1edbi gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/li>\n\n\n\n<li><strong>TRUE (1)<\/strong>: So s\u00e1nh t\u01b0\u01a1ng \u0111\u1ed1i. Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ch\u1ec9 c\u1ea7n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-1024x640.jpg\" alt=\"Ki\u1ec3u so s\u00e1nh: ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i\" class=\"wp-image-99165\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-18.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ki\u1ec3u so s\u00e1nh: ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i<\/figcaption><\/figure>\n\n\n\n<p>Khi s\u1eed d\u1ee5ng so s\u00e1nh t\u01b0\u01a1ng \u0111\u1ed1i, c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n. Ph\u00e9p so s\u00e1nh n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb g\u1ea7n \u0111\u00fang ho\u1eb7c khi d\u1eef li\u1ec7u kh\u00f4ng ho\u00e0n to\u00e0n ch\u00ednh x\u00e1c.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"So_cot_tra_ve\"><\/span><strong>S\u1ed1 c\u1ed9t tr\u1ea3 v\u1ec1<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Tham s\u1ed1 column_index_num: Ch\u1ec9 \u0111\u1ecbnh c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1, t\u00ednh t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. Tuy nhi\u00ean, s\u1ed1 c\u1ed9t tr\u1ea3 v\u1ec1 ph\u1ea3i nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 c\u1ed9t c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. V\u00ed d\u1ee5, n\u1ebfu c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 &#8220;M\u00e3 s\u1ea3n ph\u1ea9m&#8221;, c\u1ed9t th\u1ee9 hai l\u00e0 &#8220;T\u00ean s\u1ea3n ph\u1ea9m&#8221; v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m, th\u00ec column_index_num s\u1ebd l\u00e0 2.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Khoa_bang_du_lieu_table_array\"><\/span><strong>Kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u (table_array)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Khi sao ch\u00e9p c\u00f4ng th\u1ee9c, b\u1ea3ng d\u1eef li\u1ec7u (table_array) th\u01b0\u1eddng kh\u00f4ng thay \u0111\u1ed5i. \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111i\u1ec1u n\u00e0y, b\u1ea1n n\u00ean kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng d\u1ea5u &#8220;$&#8221;. L\u01b0u \u00fd n\u00e0y s\u1ebd tr\u00e1nh l\u1ed7i khi sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3. V\u00ed d\u1ee5: =VLOOKUP(A2,$B$2:$C$10,2,FALSE)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-1024x640.jpg\" alt=\"Kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u (table_array)\" class=\"wp-image-99166\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/ham-vlookup-19.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Kh\u00f3a b\u1ea3ng d\u1eef li\u1ec7u (table_array)<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Kieu_du_lieu_cua_gia_tri_tra_cuu\"><\/span><strong>Ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>N\u1ebfu gi\u00e1 tr\u1ecb tra c\u1ee9u l\u00e0 s\u1ed1 nh\u01b0ng trong b\u1ea3ng d\u1eef li\u1ec7u l\u1ea1i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 v\u0103n b\u1ea3n, h\u00e0m VLOOKUP s\u1ebd kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3. L\u00fac n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra v\u00e0 \u0111\u1ea3m b\u1ea3o ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u v\u00e0 trong b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 gi\u1ed1ng nhau. Ho\u1eb7c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n sang s\u1ed1 n\u1ebfu c\u1ea7n.<\/p>\n\n\n\n<p>Hi\u1ec3u r\u00f5 nh\u1eefng l\u01b0u \u00fd tr\u00ean s\u1ebd gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 tr\u00e1nh nh\u1eefng l\u1ed7i kh\u00f4ng \u0111\u00e1ng c\u00f3. Ngo\u00e0i ra, \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng Excel, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p VLOOKUP v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 INDEX, MATCH \u0111\u1ec3 gi\u1ea3i quy\u1ebft nh\u1eefng b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><strong>T\u1ed5ng k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>V\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn, v\u00ed d\u1ee5 chi ti\u1ebft v\u00e0 nh\u1eefng l\u01b0u \u00fd quan tr\u1ecdng m\u00e0 ch\u00fang ta v\u1eeba t\u00ecm hi\u1ec3u, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 tin s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel. H\u00e0m VLOOKUP kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n t\u0103ng t\u00ednh ch\u00ednh x\u00e1c cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. H\u00e3y t\u1eadn d\u1ee5ng t\u1ed1i \u0111a c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd n\u00e0y \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c v\u1edbi Excel nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel v\u00e0 c\u1ea3m th\u1ea5y vi\u1ec7c t\u00ecm ki\u1ebfm th\u00f4ng tin qu\u00e1 m\u1ea5t th\u1eddi gian? H\u00e0m VLOOKUP ch\u00ednh l\u00e0 th\u1ee7 thu\u1eadt gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c \u0111\u00e1ng k\u1ec3. V\u1edbi h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":122833,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24,1029],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/99146"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=99146"}],"version-history":[{"count":4,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/99146\/revisions"}],"predecessor-version":[{"id":122834,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/99146\/revisions\/122834"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/122833"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=99146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=99146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=99146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}