{"id":11735,"date":"2024-03-03T17:11:04","date_gmt":"2024-03-03T10:11:04","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11735"},"modified":"2025-04-15T10:56:55","modified_gmt":"2025-04-15T03:56:55","slug":"huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11735&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;6&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.3&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.3\\\/5 - (6 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel&quot;,&quot;width&quot;:&quot;122.2&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 122.2px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.3\/5 - (6 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft<strong> h\u00e0m Vlookup<\/strong> l\u00e0 h\u00e0m chuy\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t. \u0110\u00e2y \u0111\u01b0\u1ee3c xem l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm th\u00f4ng d\u1ee5ng c\u01a1 b\u1ea3n m\u00e0 ai h\u1ecdc excel c\u0169ng c\u1ea7n ph\u1ea3i bi\u1ebft. B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb b\u1edfi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec ch\u00fang ta ph\u1ea3i l\u00e0m nh\u01b0 th\u1ebf n\u00e0o. C\u00f3 nhi\u1ec1u b\u1ea1n ch\u01b0a bi\u1ebft v\u1ec1 v\u1ea5n \u0111\u1ec1 n\u00e0y. H\u00f4m nay, teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> chi ti\u1ebft nh\u1ea5t trong excel qua nh\u1eefng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\" style=\"cursor:inherit\">N\u1ed9i dung <\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Muc_dich_su_dung_va_cu_phap_ham_Vlookup_trong_Excel\" >M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p h\u00e0m Vlookup trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Ham_Vlookup_la_gi\" >H\u00e0m Vlookup l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Muc_dich_su_dung\" >M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Cu_phap_ham_Vlookup_trong_Excel\" >C\u00fa ph\u00e1p h\u00e0m Vlookup trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Vi_du\" >V\u00ed d\u1ee5<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Ham_Vlookup_nhieu_dieu_kien_trong_Excel_la_gi\" >H\u00e0m Vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel l\u00e0 g\u00ec?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Dung_ham_Vlookup_theo_cong_thuc_mang\" >D\u00f9ng h\u00e0m Vlookup theo c\u00f4ng th\u1ee9c m\u1ea3ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Dung_ham_Vlookup_bang_cach_tao_cot_phu\" >D\u00f9ng h\u00e0m Vlookup b\u1eb1ng c\u00e1ch t\u1ea1o c\u1ed9t ph\u1ee5<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Vi_du_1\" >V\u00ed d\u1ee5 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Vi_du_2\" >V\u00ed d\u1ee5 2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#Luu_y\" >L\u01b0u \u00fd<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Muc_dich_su_dung_va_cu_phap_ham_Vlookup_trong_Excel\"><\/span><strong>M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p h\u00e0m Vlookup trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Vlookup_la_gi\"><\/span><strong>H\u00e0m Vlookup l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Vlookup c\u00f3 t\u00ednh n\u0103ng d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i sang ph\u1ea3i v\u00e0 chi\u1ec1u d\u1ecdc. Gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf c\u1ed9t tham chi\u1ebfu c\u00f9ng v\u1edbi h\u00e0ng gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Muc_dich_su_dung\"><\/span><strong>M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Vlookup l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t k\u1ebft qu\u1ea3 n\u00e0o \u0111\u00f3 trong m\u1ed9t b\u1ea3ng t\u00ednh. Gi\u00fap ch\u00fang ta t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u nhanh nh\u1ea5t v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t.<a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cu_phap_ham_Vlookup_trong_Excel\"><\/span><strong>C\u00fa ph\u00e1p h\u00e0m Vlookup trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>=VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUM,[RANGE_LOOKUP])<\/b><\/p>\n<p><iframe loading=\"lazy\" title=\"h\u00e0m vlookup trong excel 2010 \u0111\u1ec3 l\u00e0m g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u00fang\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/VcsVUplSVhE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Lookup_value (gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c): <\/b><span style=\"font-weight: 400;\">L\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm c\u1ee7a h\u00e0m vlookup, n\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb, \u00f4 tham chi\u1ebfu ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Table_array (b\u1eaft bu\u1ed9c):<\/b><span style=\"font-weight: 400;\"> L\u00e0 b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Col_index_num (b\u1eaft bu\u1ed9c):<\/b><span style=\"font-weight: 400;\"> V\u1ecb tr\u00ed th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t <a href=\"https:\/\/www.microsoft.com\/vi-vn\/microsoft-365\/excel\" rel=\"nofollow noreferrer\">Excel<\/a> ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm trong Table_array.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Range_lookup (t\u00f9y ch\u1ecdn):<\/b><span style=\"font-weight: 400;\"> l\u00e0 ph\u1ea1m vi b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm, cho bi\u1ebft h\u00e0m Vlookup trong Excel c\u1ea7n ph\u1ea3i t\u00ecm k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u0111\u1ed1i hay ch\u00ednh x\u00e1c. N\u1ebfu gi\u00e1 tr\u1ecb l\u00e0 0: Ngh\u0129a l\u00e0 d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i. N\u1ebfu l\u00e0 1 d\u00f2 t\u00ecm k\u1ebft qu\u1ea3 tuy\u1ec7t \u0111\u1ed1i.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_11736\" aria-describedby=\"caption-attachment-11736\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11736 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/V1.png\" alt=\"H\u00e0m vlookup trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/V1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/V1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/V1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11736\" class=\"wp-caption-text\">H\u00e0m vlookup trong excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Vlookup_nhieu_dieu_kien_trong_Excel_la_gi\"><\/span><span style=\"font-weight: 400;\">H\u00e0m Vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel l\u00e0 g\u00ec?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, h\u00e0m Vlookup ch\u1ec9 c\u00f3 ch\u1ee9c n\u0103ng d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb v\u00e0 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c v\u1edbi gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb, m\u1ed9t \u00f4 tham chi\u1ebfu, ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. Do v\u1eady, n\u1ebfu b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm nhi\u1ec1u \u0111i\u1ec1u \u0111i\u1ec1u ki\u1ec7n h\u01a1n trong excel ch\u1ec9 b\u1eb1ng h\u00e0m Vlookup l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u1edbi hai c\u00e1ch: d\u00f9ng c\u00f4ng th\u1ee9c m\u1ea3ng ho\u1eb7c d\u00f9ng c\u1ed9t ph\u1ee5.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_Vlookup_theo_cong_thuc_mang\"><\/span><strong>D\u00f9ng h\u00e0m Vlookup theo c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>\u00a0V\u00ed d\u1ee5:<\/strong> T\u00ecm m\u1ee9c gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m d\u1ef1a v\u00e0o h\u00e3ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 C14, ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>=VLOOKUP(B12&amp;B13,CHOOSE({1,2},A2:A10&amp;B2:B10,C2:C10),2,0)<\/b><\/p>\n<figure id=\"attachment_11737\" aria-describedby=\"caption-attachment-11737\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11737 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang1.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11737\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c l\u00e0: 9 tri\u1ec7u &#8211; 20 tri\u1ec7u cho s\u1ea3n ph\u1ea9m Laptop c\u1ee7a h\u00e3ng Asus.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<p style=\"text-align: justify;\"><b>+ B12&amp;B13:<\/b><span style=\"font-weight: 400;\"> L\u00e0 t\u00ean s\u1ea3n ph\u1ea9m (Laptop) v\u00e0 t\u00ean h\u00e3ng(Asus) \u0111\u01b0\u1ee3c gh\u00e9p \u1edf \u00f4 C12 v\u00e0 \u00f4 C13.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+CHOOSE({1,2},A2:A10&amp;B2:B10,C2:C10):<\/b><span style=\"font-weight: 400;\"> L\u00e0 b\u1ea3ng d\u00f2 t\u00ecm \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb m\u1ed9t m\u1ea3ng hai chi\u1ec1u c\u00f3 t\u1eeb hai c\u1ed9t. C\u1ed9t 1 l\u00e0 c\u1ed9t d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu.C\u1ed9t 2 l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+ 2:<\/b><span style=\"font-weight: 400;\"> L\u00e0 v\u1ecb tr\u00ed c\u1ed9t \u201cM\u1ee9c gi\u00e1\u201d trong b\u1ea3ng d\u00f2 t\u00ecm.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+ 0: <\/b><span style=\"font-weight: 400;\">Ch\u1ecdn ki\u1ec3u d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_Vlookup_bang_cach_tao_cot_phu\"><\/span><strong>D\u00f9ng h\u00e0m Vlookup b\u1eb1ng c\u00e1ch t\u1ea1o c\u1ed9t ph\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_1\"><\/span>V\u00ed d\u1ee5 1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><span style=\"font-weight: 400;\"> C\u0169ng v\u1edbi v\u00ed d\u1ee5 tr\u00ean, y\u00eau c\u1ea7u x\u00e1c \u0111\u1ecbnh m\u1ee9c gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m theo t\u1eebng h\u00e3ng \u0111\u00e3 cho s\u1eb5n.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> T\u1ea1o c\u1ed9t ph\u1ee5 \u0111\u1ec3 gh\u00e9p c\u1ed9t t\u00ean s\u1ea3n ph\u1ea9m v\u00e0 t\u00ean h\u00e3ng l\u1ea1i v\u1edbi nhau theo c\u00f4ng th\u1ee9c sau: <\/span><b>=B2&amp;C2<\/b><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 C1, c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m\u00a0 Vlookup \u0111\u1ec3 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb theo c\u1ed9t ph\u1ee5 nh\u01b0 sau: <\/span><b>=VLOOKUP(C12&amp;C13, A2:D10,4,0)<\/b><\/p>\n<figure id=\"attachment_11738\" aria-describedby=\"caption-attachment-11738\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11738 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang2-1.jpg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang2-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang2-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/mang2-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11738\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<p style=\"text-align: justify;\"><b>+ C12&amp;C13:<\/b><span style=\"font-weight: 400;\"> Gh\u00e9p t\u00ean s\u1ea3n ph\u1ea9m v\u00e0 t\u00ean h\u00e3ng t\u1ea1i \u00f4 C12 &amp; C13.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+ A2:D10:<\/b><span style=\"font-weight: 400;\"> D\u1ea3i \u00f4 t\u1eeb A2:D10, trong \u0111\u00f3 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+ 4:<\/b><span style=\"font-weight: 400;\"> V\u1ecb tr\u00ed c\u1ee7a c\u1ed9t M\u1ee9c gi\u00e1.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>+ 0:<\/b><span style=\"font-weight: 400;\"> L\u00e0 ki\u1ec3u d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>L\u01b0u \u00fd:<\/b><span style=\"font-weight: 400;\"> Ngo\u00e0i c\u00e1ch n\u1ed1i chu\u1ed7i k\u1ebft h\u1ee3p b\u1eb1ng d\u1ea5u &amp; nh\u01b0 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m <\/span><span style=\"font-weight: 400;\">TEXTJOIN<\/span><span style=\"font-weight: 400;\"> \u0111\u1ec3 n\u1ed1i chu\u1ed7i nh\u00e9.<a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/span><\/p>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_2\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 2<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">B\u00e2y gi\u1edd ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n k\u00e8m theo \u0111\u00f3 l\u00e0 thao t\u00e1c t\u1ea1o c\u1ed9t ph\u1ee5 trong Excel \u0111\u1ec3 t\u00ednh to\u00e1n. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, teky.edu.vn s\u1ebd t\u1ea1o c\u1ed9t ph\u1ee5 v\u00e0 li\u00ean k\u1ebft 2 gi\u00e1 tr\u1ecb trong b\u1ea3ng l\u1ea1i v\u1edbi nhau. T\u1ea1i c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb li\u00ean k\u1ebft t\u1eeb m\u00e3 s\u1ea3n ph\u1ea9m (c\u1ed9t B) v\u00e0 Ca (c\u1ed9t C).\u00a0 Nh\u1eadp c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t A: =B6&amp;C6 r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11739\" aria-describedby=\"caption-attachment-11739\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11739 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11739\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">Ch\u00fang ta \u0111\u01b0\u1ee3c<\/span> <span style=\"font-weight: 400;\">k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Vlookup b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<figure id=\"attachment_11740\" aria-describedby=\"caption-attachment-11740\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11740 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11740\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 3:<\/b><span style=\"font-weight: 400;\"> B\u00ean c\u1ea1nh \u0111\u00f3, ch\u00fang ta c\u1ea7n t\u1ea1o m\u1ed9t b\u1ea3ng truy v\u1ea5n b\u00ean c\u1ea1nh, \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm s\u1ea3n l\u01b0\u1ee3ng cho m\u1ed9t m\u00e3 s\u1ea3n ph\u1ea9m l\u00e0m trong m\u1ed9t ca n\u00e0o \u0111\u00f3. T\u1ea1i b\u1ea3ng truy v\u1ea5n n\u00e0y, ch\u00fang ta c\u1ea7n nh\u1eadp v\u00e0o \u0111\u00f3 d\u1eef li\u1ec7u Ca v\u00e0 M\u00e3 s\u1ea3n ph\u1ea9m, c\u00f2n ph\u1ea7n s\u1ea3n l\u01b0\u1ee3ng s\u1ebd l\u00e0 n\u01a1i \u0111\u1ec3 ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c.\u00a0<\/span><\/p>\n<figure id=\"attachment_11741\" aria-describedby=\"caption-attachment-11741\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11741 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-3.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-3-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-3-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11741\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Luu_y\"><\/span>L\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 4: <\/b><span style=\"font-weight: 400;\">T\u1ea1i \u0111\u00e2y ch\u00fang ta s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>=Vlookup(G6&amp;G7);$A$6:$D$10;4;0)<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<figure id=\"attachment_11742\" aria-describedby=\"caption-attachment-11742\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11742 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-4.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-4.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-4-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-4-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11742\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 5: <\/b><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1ea1i \u00f4 s\u1ea3n l\u01b0\u1ee3ng l\u00e0 1000, t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u00e3 s\u1ea3n ph\u1ea9m l\u00e0 SA l\u00e0m ca 1. Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ed1i chi\u1ebfu v\u00e0 ki\u1ec3m tra c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch nh\u1eadp b\u1ea5t k\u00ec m\u1ed9t s\u1ea3n ph\u1ea9m kh\u00e1c ho\u1eb7c ca kh\u00e1c \u0111\u1ec3 so s\u00e1nh.<\/span><\/p>\n<figure id=\"attachment_11743\" aria-describedby=\"caption-attachment-11743\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11743 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-5.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-5.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-5-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/VD2-5-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11743\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady teky.edu.vn v\u1eeba h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n chi ti\u1ebft nh\u1ea5t trong excel. H\u00e0m Vlookup trong excel lu\u00f4n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn trong c\u00e1c c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n, \u0111\u00e2y l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u00ean bi\u1ebft \u0111\u1ec3 gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 vi\u1ec7c h\u1ecdc t\u1eadp c\u1ee7a m\u00ecnh. N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc n\u00e0o v\u1ec1 b\u00e0i vi\u1ebft, c\u00e1c b\u1ea1n h\u00e3y comment b\u00ean d\u01b0\u1edbi \u0111\u1ec3 ch\u00fang t\u00f4i gi\u1ea3i \u0111\u00e1p c\u1ee5 th\u1ec3 nh\u00e9.<a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c.<\/strong><\/p>\n<ul>\n<li class=\"c-detail-head__title\" style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\">S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]<\/a><\/li>\n<li class=\"c-detail-head__title\" style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m Vlookup l\u00e0 h\u00e0m chuy\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t. \u0110\u00e2y \u0111\u01b0\u1ee3c xem l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm th\u00f4ng d\u1ee5ng c\u01a1 b\u1ea3n m\u00e0 ai h\u1ecdc excel c\u0169ng c\u1ea7n ph\u1ea3i bi\u1ebft. B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11746,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11735","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel<\/title>\n<meta name=\"description\" content=\"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-03T10:11:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T03:56:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\",\"datePublished\":\"2024-03-03T10:11:04+00:00\",\"dateModified\":\"2025-04-15T03:56:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\"},\"wordCount\":1829,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png\",\"datePublished\":\"2024-03-03T10:11:04+00:00\",\"dateModified\":\"2025-04-15T03:56:55+00:00\",\"description\":\"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png\",\"width\":600,\"height\":400,\"caption\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel","description":"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel","og_description":"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.","og_url":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2024-03-03T10:11:04+00:00","article_modified_time":"2025-04-15T03:56:55+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel","datePublished":"2024-03-03T10:11:04+00:00","dateModified":"2025-04-15T03:56:55+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/"},"wordCount":1829,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png","datePublished":"2024-03-03T10:11:04+00:00","dateModified":"2025-04-15T03:56:55+00:00","description":"H\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel.png","width":600,"height":400,"caption":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel-400x267.png","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11735"}],"version-history":[{"count":3,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11735\/revisions"}],"predecessor-version":[{"id":24910,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11735\/revisions\/24910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11746"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}