{"id":10079,"date":"2023-11-23T09:51:51","date_gmt":"2023-11-23T02:51:51","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10079"},"modified":"2023-11-23T16:07:18","modified_gmt":"2023-11-23T09:07:18","slug":"ham-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/","title":{"rendered":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh"},"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;10079&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;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&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;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh&quot;,&quot;width&quot;:&quot;142.5&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: 142.5px;\">\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            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">T\u00ecm hi\u1ec3u v\u1ec1 <strong>h\u00e0m Vlookup trong Excel<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u b\u1edfi n\u00f3 v\u00f4 c\u00f9ng h\u1eefu d\u1ee5ng cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. M\u1eb7c d\u00f9 \u0111\u00e2y l\u00e0 h\u00e0m th\u00f4ng d\u1ee5ng, nh\u01b0ng m\u1ed9t s\u1ed1 ng\u01b0\u1eddi v\u1eabn ch\u01b0a hi\u1ec3u r\u00f5 v\u00e0 ch\u01b0a c\u00f3 c\u00e1ch \u0111\u1ec3 x\u00e0i <strong>h\u00e0m Vlookup excel<\/strong> hi\u1ec7u qu\u1ea3. N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 \u0111\u1ecbnh ngh\u0129a c\u1ee7a h\u00e0m, 4 th\u00e0nh ph\u1ea7n <strong>h\u00e0m Vlookup<\/strong> nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n bao g\u1ed3m nh\u1eefng g\u00ec, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y m\u00e0 ch\u00fang t\u00f4i mang \u0111\u1ebfn ch\u1eafc ch\u1eafn s\u1ebd l\u00e0m cho c\u00e1c b\u1ea1n th\u1ea5y h\u00e0i l\u00f2ng. C\u00f9ng b\u1eaft \u0111\u1ea7u ngay th\u00f4i!<\/span><\/em><\/p>\n<figure id=\"attachment_10081\" aria-describedby=\"caption-attachment-10081\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10081\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/chia-se-ve-ham-vlookup-trong-excel.jpg\" alt=\"Chia s\u1ebb v\u1ec1 h\u00e0m Vlookup trong Excel\" width=\"650\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/chia-se-ve-ham-vlookup-trong-excel.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/chia-se-ve-ham-vlookup-trong-excel-400x246.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-10081\" class=\"wp-caption-text\">Chia s\u1ebb v\u1ec1 h\u00e0m Vlookup trong Excel<\/figcaption><\/figure>\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\/ham-vlookup-trong-excel\/#Dinh_nghia_ham_Vlookup_trong_Excel_la_gi\" >\u0110\u1ecbnh ngh\u0129a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#4_thanh_phan_chinh_cua_ham_Vlookup_trong_Excel_la_gi\" >4 th\u00e0nh ph\u1ea7n ch\u00ednh c\u1ee7a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Nhung_luu_y_can_biet_khi_xay_dung_ham_Vlookup_trong_google_sheet_va_excel\" >Nh\u1eefng l\u01b0u \u00fd c\u1ea7n bi\u1ebft khi x\u00e2y d\u1ef1ng h\u00e0m Vlookup trong google sheet v\u00e0 excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Quy_tac_cua_ham_Vlookup\" >Quy t\u1eafc c\u1ee7a 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-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Quy_tac_cho_ham_Vlookup_su_dung_nhung_ket_hop_chinh_xac\" >Quy t\u1eafc cho h\u00e0m Vlookup s\u1eed d\u1ee5ng nh\u1eefng k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Quy_tac_cho_ham_Vlookup_su_dung_nhung_ket_hop_gan_nhat\" >Quy t\u1eafc cho h\u00e0m Vlookup s\u1eed d\u1ee5ng nh\u1eefng k\u1ebft h\u1ee3p g\u1ea7n nh\u1ea5t<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Y_nghia_cua_ham_Vlookup_trong_Excel_la_gi\" >\u00dd ngh\u0129a c\u1ee7a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Tim_Hieu_Teky_Hoc_Vien_Cong_Nghe_Tre_Hang_Dau_Viet_Nam\" >T\u00ecm Hi\u1ec3u Teky H\u1ecdc Vi\u1ec7n C\u00f4ng Ngh\u1ec7 Tr\u1ebb H\u00e0ng \u0110\u1ea7u Vi\u1ec7t Nam<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><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\/ham-vlookup-trong-excel\/#Day_la_chuong_trinh_khong_chi_trang_bi_kien_thuc_lap_trinh_ma_con_ren_luyen_nhom_ky_nang_4Cs_Tre_se_duoc\" >\u0110\u00e2y l\u00e0 ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng ch\u1ec9 trang b\u1ecb ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh m\u00e0 c\u00f2n r\u00e8n luy\u1ec7n nh\u00f3m k\u1ef9 n\u0103ng 4Cs. Tr\u1ebb s\u1ebd \u0111\u01b0\u1ee3c:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#Lien_he_ngay_hoc_vien_cong_nghe_sang_tao_TEKY_de_duoc_tu_van_khoa_hoc\" >Li\u00ean h\u1ec7 ngay h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 s\u00e1ng t\u1ea1o TEKY \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n kh\u00f3a h\u1ecdc:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dinh_nghia_ham_Vlookup_trong_Excel_la_gi\"><\/span><b>\u0110\u1ecbnh ngh\u0129a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nhi\u1ec1u ng\u01b0\u1eddi ch\u01b0a hi\u1ec3u v\u1ec1 \u0111\u1ecbnh ngh\u0129a c\u1ee7a <strong>h\u00e0m Vlookup<\/strong> l\u00e0 g\u00ec. Tr\u00ean th\u1ef1c t\u1ebf, Vlookup l\u00e0 t\u1eeb vi\u1ebft t\u1eaft c\u1ee7a c\u1ee5m Vertical lookup, hay \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 tra c\u1ee9u theo chi\u1ec1u d\u1ecdc. \u0110i\u1ec1u n\u00e0y kh\u00e1c v\u1edbi h\u00e0m Hlookup (Horizontal lookup) l\u00e0 t\u00ecm ki\u1ebfm theo chi\u1ec1u ngang. Do \u0111\u00f3, nhi\u1ec1u ng\u01b0\u1eddi th\u01b0\u1eddng nh\u1ea7m l\u1eabn h\u00e0m Vlookup v\u00e0 hlookup v\u1edbi nhau.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi <strong>h\u00e0m Vlookup trong Excel<\/strong> n\u00e0y, ch\u00fang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb theo c\u1ed9t, v\u00e0 \u0111\u01b0a ra ph\u01b0\u01a1ng th\u1ee9c theo h\u00e0ng d\u1ecdc. Nh\u1edd h\u00e0m n\u00e0y, ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 t\u1ef1 m\u00ecnh th\u1ed1ng k\u00ea, t\u00ecm ki\u1ebfm c\u00e1c d\u1eef li\u1ec7u \u1edf trong c\u1ed9t m\u1ed9t c\u00e1ch c\u1ef1c k\u1ef3 nhanh ch\u00f3ng, ti\u1ec7n l\u1ee3i v\u00e0 ch\u00ednh x\u00e1c.<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/excel-co-ban-van-phong\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft<\/span><\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"4_thanh_phan_chinh_cua_ham_Vlookup_trong_Excel_la_gi\"><\/span><b>4 th\u00e0nh ph\u1ea7n ch\u00ednh c\u1ee7a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Vlookup l\u00e0: =VLOOKUP(Lookup_value, Table_array, Col_index_num, [Range_lookup])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c th\u00e0nh ph\u1ea7n trong \u0111\u00f3 bao g\u1ed3m:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Lookup_value: Gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Table_array: V\u00f9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00f2, t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. C\u1ed9t \u0111\u1ea7u ti\u00ean trong \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u1ed9t \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Ngo\u00e0i ra, table_array c\u0169ng kh\u00e1c ho\u1eb7c gi\u1ed1ng so v\u1edbi sheet c\u1ee7a Lookup_value, do \u0111\u00f3 n\u00f3 c\u00f3 th\u1ec3 kh\u00e1c file ho\u1eb7c c\u00f9ng file so v\u1edbi Lookup_value. Th\u00f4ng th\u01b0\u1eddng, nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u1ec3 \u1edf d\u1ea1ng \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Col_index_num: \u0110\u01b0\u1ee3c coi l\u00e0 th\u1ee9 t\u1ef1 \u1edf trong c\u1ed9t, c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. Ph\u1ea7n c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Range_lookup: \u0110\u01b0\u1ee3c coi l\u00e0 ki\u1ec3m t\u00ecm ki\u1ebfm, s\u1ebd g\u1ed3m c\u00f3 2 ki\u1ec3u True v\u00e0 False kh\u00e1c nhau. True c\u00f3 ngh\u0129a l\u00e0 t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i, hay c\u00f2n t\u01b0\u01a1ng \u1ee9ng v\u1edbi 1. C\u00f2n False th\u00ec ngh\u0129a l\u00e0 t\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i, hay c\u00f2n t\u01b0\u01a1ng \u1ee9ng v\u1edbi 0. Nh\u1edd c\u00f3 con s\u1ed1 n\u00e0y, h\u00e0m s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb tr\u00f9ng kh\u1edbp d\u1eef li\u1ec7u v\u1edbi nhau.\u00a0<\/span><\/p>\n<figure id=\"attachment_10080\" aria-describedby=\"caption-attachment-10080\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10080\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/dung-ham-nay-nhu-the-nao.jpg\" alt=\"D\u00f9ng h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o\" width=\"650\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/dung-ham-nay-nhu-the-nao.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/dung-ham-nay-nhu-the-nao-400x246.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-10080\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o<\/figcaption><\/figure>\n<p><em><strong>&gt;&gt; Xem th\u00eam:<\/strong> <a href=\"https:\/\/teky.edu.vn\/blog\/excel-co-ban-van-phong\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft<\/span><\/a><\/em><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_luu_y_can_biet_khi_xay_dung_ham_Vlookup_trong_google_sheet_va_excel\"><\/span><b>Nh\u1eefng l\u01b0u \u00fd c\u1ea7n bi\u1ebft khi x\u00e2y d\u1ef1ng h\u00e0m Vlookup trong google sheet v\u00e0 excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh x\u00e2y d\u1ef1ng <strong>h\u00e0m Vlookup trong excel<\/strong>, b\u1ea1n c\u1ea7n ph\u1ea3i ghi nh\u1edb nh\u1eefng \u0111i\u1ec1u sau: Nh\u1eefng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n \u0111ang mu\u1ed1n tra c\u1ee9u, s\u1ebd \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 gi\u00e1 tr\u1ecb tra c\u1ee9u.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n ph\u1ea3i ghi nh\u1edb to\u00e0n b\u1ed9 ph\u1ea1m vi c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb ph\u1ea3i tra c\u1ee9u \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean, \u0111\u1ec3 h\u00e0m Vlookup c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1ed1 c\u1ed9t \u1edf b\u00ean trong ph\u1ea1m vi s\u1ebd ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu nh\u01b0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh cho A2:C12 \u0111\u1ec3 l\u00e0m ph\u1ea1m vi, b\u1ea1n n\u00ean t\u00ednh A l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean, B l\u00e0 c\u1ed9t th\u1ee9 hai.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u1ef1a ch\u1ecdn c\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, b\u1ea1n s\u1ebd c\u1ea7n ch\u1ec9 \u0111\u1ecbnh True n\u1ebfu nh\u01b0 mu\u1ed1n c\u00f3 k\u1ebft qu\u1ea3 kh\u1edbp t\u01b0\u01a1ng \u0111\u1ed1i, ho\u1eb7c b\u1ea1n ch\u1ec9 \u0111\u00ecnh False n\u1ebfu nh\u01b0 mu\u1ed1n k\u1ebft qu\u1ea3 kh\u1edbp m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c so v\u1edbi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. T\u00f9y theo b\u1ea1n ch\u1ec9 \u0111\u1ecbnh b\u1ea5t c\u1ee9 gi\u00e1 tr\u1ecb n\u00e0o, gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u00e0m Vlookup s\u1ebd lu\u00f4n l\u00e0 True, ho\u1eb7c l\u00e0 nh\u1eefng k\u1ebft qu\u1ea3 kh\u1edbp mang t\u00ednh t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/p>\n<figure id=\"attachment_10082\" aria-describedby=\"caption-attachment-10082\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10082\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\" alt=\"N\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y ngay!\" width=\"650\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay-400x246.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-10082\" class=\"wp-caption-text\">N\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y ngay!<\/figcaption><\/figure>\n<p><em><strong>&gt;&gt; Xem th\u00eam:<\/strong> <a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\" target=\"_blank\" rel=\"noopener\">S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3<\/a><\/em><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Quy_tac_cua_ham_Vlookup\"><\/span><b>Quy t\u1eafc c\u1ee7a h\u00e0m Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eafc \u0111\u1ebfn <strong>h\u00e0m Vlookup trong Excel<\/strong>, \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng, b\u1ea1n n\u00ean n\u1eafm r\u00f5 nh\u1eefng quy t\u1eafc c\u1ee7a h\u00e0m. Tr\u00ean th\u1ef1c t\u1ebf, b\u1ea1n c\u1ea7n ph\u1ea3i hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y tr\u01b0\u1edbc khi bi\u1ebft \u0111\u1ebfn nh\u1eefng h\u00e0m Vlookup if ho\u1eb7c h\u00e0m Vlookup ng\u01b0\u1ee3c b\u1edfi \u0111\u00e2y s\u1ebd l\u00e0 n\u1ec1n t\u1ea3ng \u0111\u1ec3 b\u1ea1n am hi\u1ec3u h\u01a1n v\u1ec1 nh\u1eefng ki\u1ebfn th\u1ee9c kh\u00e1c sau. B\u1ea1n n\u00ean ghi nh\u1edb r\u1eb1ng:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>H\u00e0m Vlookup<\/strong> s\u1ebd kh\u00f4ng nh\u1eadn d\u1ea1ng c\u00e1c s\u1ed1 v\u00e0 bi\u1ec3u di\u1ec5n c\u00e1c v\u0103n b\u1ea3n c\u1ee7a c\u00e1c s\u1ed1 l\u00e0 b\u1eb1ng nhau. Do \u0111\u00f3, n\u1ebfu nh\u01b0 c\u00e1c gi\u00e1 tr\u1ecb lookup c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng chu\u1ed7i v\u0103n b\u1ea3n l\u00e0 10, c\u00f2n c\u00e1c gi\u00e1 tr\u1ecb \u1edf trong table_array l\u00e0 m\u1ed9t s\u1ed1, th\u00ec h\u00e0m c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng \u0111\u01b0a ra \u0111\u01b0\u1ee3c nh\u1eefng k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi <strong>h\u00e0m Vlookup<\/strong>, ch\u00fang s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c so s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 v\u1edbi nhau, bao g\u1ed3m c\u1ea3 nh\u1eefng d\u1ea5u c\u00e1ch \u1edf \u0111\u1ea7u v\u00e0 \u1edf cu\u1ed1i trong qu\u00e1 tr\u00ecnh ki\u1ec3m tra, \u0111\u1ec3 xem r\u1eb1ng hai gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 tr\u00f9ng kh\u1edbp v\u1edbi nhau hay l\u00e0 kh\u00f4ng. Th\u1ebf n\u00ean, trong hai chu\u1ed7i v\u0103n b\u1ea3n th\u00ec nh\u1eefng v\u0103n b\u1ea3n kh\u00f4ng ch\u1ee9a d\u1ea5u c\u00e1ch so s\u00e1nh v\u1edbi v\u0103n b\u1ea3n c\u00f3 d\u1ea5u c\u00e1ch \u1edf cu\u1ed1i s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1eefng <strong>h\u00e0m Vlookup<\/strong> s\u1ebd xem v\u0103n b\u1ea3n vi\u1ebft ch\u1eef in th\u01b0\u1eddng v\u00e0 ch\u1eef in hoa l\u00e0 gi\u1ed1ng nhau. C\u00f3 th\u1ec3 hi\u1ec3u r\u1eb1ng vi\u1ec7c tra c\u1ee9u chu\u1ed7i text s\u1ebd c\u1ea7n kh\u1edbp v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, d\u1eef li\u1ec7u c\u1ee7a table_array s\u1ebd c\u1ea7n \u0111\u01b0\u1ee3c cung c\u1ea5p v\u1edbi c\u00e1c s\u1eafp x\u1ebfp theo c\u1ed9t.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Quy_tac_cho_ham_Vlookup_su_dung_nhung_ket_hop_chinh_xac\"><\/span><b>Quy t\u1eafc cho h\u00e0m Vlookup s\u1eed d\u1ee5ng nh\u1eefng k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 \u0111\u1ed5i s\u1ed1 gi\u00e1 tr\u1ecb range_lookup \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u1ea1i th\u00e0nh False th\u00ec trong h\u00e0m Vlookup, ta s\u1ebd t\u00ecm ra \u0111\u01b0\u1ee3c \u0111\u1ed1i s\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t so v\u1edbi Lookup_value. C\u00f2n ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu nh\u01b0 kh\u00f4ng t\u00ecm th\u1ea5y \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, h\u00e0m s\u1ebd tr\u1ea3 l\u1ed7i v\u1ec1 #N \/ A<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Quy_tac_cho_ham_Vlookup_su_dung_nhung_ket_hop_gan_nhat\"><\/span><b>Quy t\u1eafc cho h\u00e0m Vlookup s\u1eed d\u1ee5ng nh\u1eefng k\u1ebft h\u1ee3p g\u1ea7n nh\u1ea5t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong khi \u0111\u1ed5i s\u1ed1 gi\u00e1 tr\u1ecb range_lookup \u0111\u1eb7t l\u1ea1i th\u00e0nh True th\u00ec c\u00f3 ngh\u0129a l\u00e0 lookup_value trong h\u00e0m Vlookup trong excel s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 g\u1ea7n nh\u1ea5t \u1edf b\u00ean d\u01b0\u1edbi, ho\u1eb7c ngang b\u1eb1ng gi\u00e1 tr\u1ecb n\u00e0y.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Y_nghia_cua_ham_Vlookup_trong_Excel_la_gi\"><\/span><b>\u00dd ngh\u0129a c\u1ee7a h\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng <strong>h\u00e0m Vlookup<\/strong> mang \u0111\u1ebfn r\u1ea5t nhi\u1ec1u \u00fd ngh\u0129a tuy\u1ec7t v\u1eddi kh\u00e1c nhau, khi\u1ebfn ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u1ea3m th\u1ea5y c\u1ef1c k\u1ef3 h\u00e0i l\u00f2ng. Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">H\u00e0m Vlookup Excel s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb theo c\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m Vlookup, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ed9c l\u1eadp, ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c nhau nh\u01b0 h\u00e0m If, h\u00e0m Sum\u2026<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_10083\" aria-describedby=\"caption-attachment-10083\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10083\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/ham-vlookup-trong-excel-la-gi.jpg\" alt=\"H\u00e0m Vlookup trong excel l\u00e0 g\u00ec?\" width=\"650\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/ham-vlookup-trong-excel-la-gi.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/ham-vlookup-trong-excel-la-gi-400x246.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-10083\" class=\"wp-caption-text\">H\u00e0m Vlookup trong excel l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin m\u00e0 ch\u00fang t\u00f4i mang \u0111\u1ebfn cho b\u1ea1n \u0111\u1ecdc v\u1ec1 h\u00e0m Vlookup trong Excel. Nh\u1eefng th\u00f4ng tin n\u00e0y c\u1ef1c k\u1ef3 b\u1ed5 \u00edch, ph\u00f9 h\u1ee3p v\u1edbi b\u1ea1n n\u00e0o th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng b\u1ea3ng Excel \u0111\u1ec3 l\u00e0m vi\u1ec7c. Do \u0111\u00f3, b\u1ea1n h\u00e3y b\u1ed5 tr\u1ee3 ngay cho m\u00ecnh nh\u1eefng d\u1eef li\u1ec7u b\u1ed5 \u00edch n\u00e0y \u0111\u1ec3 hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 nh\u1ea5t b\u1ea1n nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><em><strong>M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft m\u1edbi c\u1ee7a Teky:<\/strong> <a href=\"https:\/\/teky.edu.vn\/blog\/nang-cap-win-7-len-win-10\/\">N\u00e2ng c\u1ea5p win 7 l\u00ean win 10<\/a><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tim_Hieu_Teky_Hoc_Vien_Cong_Nghe_Tre_Hang_Dau_Viet_Nam\"><\/span><span style=\"font-size: 20px; color: #339966;\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;C\u00f9ng T\u00ecm Hi\u1ec3u V\u1ec1 Teky H\u1ecdc Vi\u1ec7n 5 sao \u0110\u00e0o T\u1ea1o Tr\u1ebb Em H\u1ecdc L\u1eadp Tr\u00ecnh (4-18 tu\u1ed5i)&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:17153,&quot;3&quot;:{&quot;1&quot;:0},&quot;11&quot;:4,&quot;12&quot;:0,&quot;17&quot;:1}\">T\u00ecm Hi\u1ec3u Teky H\u1ecdc Vi\u1ec7n C\u00f4ng Ngh\u1ec7 Tr\u1ebb H\u00e0ng \u0110\u1ea7u Vi\u1ec7t Nam<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe loading=\"lazy\" title=\"H\u1ecdc l\u1eadp tr\u00ecnh tr\u1ebb em \u1edf \u0111\u00e2u? - Gi\u1edbi thi\u1ec7u h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 TEKY h\u00e0ng \u0111\u1ea7u Vi\u1ec7t Nam\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/kGgr0XJAxFM?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><strong>TEKY l\u00e0 H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7<\/strong> v\u1edbi ch\u01b0\u01a1ng tr\u00ecnh gi\u1ea3ng d\u1ea1y STEAM (Science \u2013 Technology \u2013 Engineering \u2013 Art \u2013 Mathematics) theo chu\u1ea9n M\u1ef9 \u0111\u1ea7u ti\u00ean t\u1ea1i Vi\u1ec7t Nam d\u00e0nh cho tr\u1ebb em t\u1eeb 4 \u0111\u1ebfn 18 tu\u1ed5i.<\/p>\n<p>\u0110\u01b0\u1ee3c th\u00e0nh l\u1eadp v\u00e0o th\u00e1ng 6 n\u0103m 2016, TEKY quy\u1ebft t\u00e2m th\u1ef1c hi\u1ec7n s\u1ee9 m\u1ec7nh mang \u0111\u1ebfn cho th\u1ebf h\u1ec7 tr\u1ebb Vi\u1ec7t Nam ki\u1ebfn th\u1ee9c to\u00e0n di\u1ec7n v\u1ec1 STEAM, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c t\u01b0 duy c\u00f4ng ngh\u1ec7, khoa h\u1ecdc m\u00e1y t\u00ednh v\u00e0 k\u1ef9 n\u0103ng th\u1ebf k\u1ef7 21 \u2013 4Cs (Critical Thinking: T\u01b0 duy ph\u1ea3n bi\u1ec7n \u2013 Communication: Giao ti\u1ebfp \u2013 Creativity: S\u00e1ng t\u1ea1o \u2013 Collaboration: L\u00e0m vi\u1ec7c nh\u00f3m).<\/p>\n<figure id=\"attachment_14828\" aria-describedby=\"caption-attachment-14828\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/teky.edu.vn\/?utm_source=Blog&amp;utm_medium=baiviet\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14828 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi.jpg\" alt=\"Tr\u1ea3i nghi\u1ec7m h\u1ecdc l\u1eadp tr\u00ecnh mi\u1ec5n ph\u00ed\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/03\/Trai-nghiem-hoc-lap-trinh-mien-phi-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><figcaption id=\"caption-attachment-14828\" class=\"wp-caption-text\">Tr\u1ea3i nghi\u1ec7m h\u1ecdc l\u1eadp tr\u00ecnh mi\u1ec5n ph\u00ed<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Day_la_chuong_trinh_khong_chi_trang_bi_kien_thuc_lap_trinh_ma_con_ren_luyen_nhom_ky_nang_4Cs_Tre_se_duoc\"><\/span>\u0110\u00e2y l\u00e0 ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng ch\u1ec9 trang b\u1ecb ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh m\u00e0 c\u00f2n r\u00e8n luy\u1ec7n nh\u00f3m k\u1ef9 n\u0103ng 4Cs. Tr\u1ebb s\u1ebd \u0111\u01b0\u1ee3c:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u00a0H\u1ecdc t\u01b0 duy ph\u1ea3n bi\u1ec7n th\u00f4ng qua vi\u1ec7c ph\u00e2n t\u00edch c\u00e1c v\u1ea5n \u0111\u1ec1.<\/li>\n<li>\u00a0H\u1ecdc t\u00ednh s\u00e1ng t\u1ea1o t\u01b0 duy Logic th\u00f4ng qua vi\u1ec7c l\u1eafp \u0111\u1eb7t v\u00e0 l\u1eadp tr\u00ecnh robot th \u00f4ng qua c\u00e1c m\u00f4 h\u00ecnh Lego Mindstorm, app tr\u00f2 ch\u01a1i. Gi\u00fap con h\u1ecdc gi\u1ecfi m\u00f4n To\u00e1n tr\u00ean l\u1edbp<\/li>\n<li>\u00a0K\u1ef9 n\u0103ng h\u1ee3p t\u00e1c th\u00f4ng qua c\u00e1c tr\u00f2 ch\u01a1i team-building, c\u00e1c d\u1ef1 \u00e1n nh\u00f3m tr\u00ean l\u1edbp.<\/li>\n<li>\u00a0Ph\u00e1t huy kh\u1ea3 n\u0103ng giao ti\u1ebfp hi\u1ec7u qu\u1ea3 b\u1eb1ng nhi\u1ec1u b\u00e0i t\u1eadp v\u00e0 ho\u1ea1t \u0111\u1ed9ng h\u1ea5p d\u1eabn.<\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"Shark Nguy\u1ec5n Ho\u00e0 B\u00ecnh \u0111\u1ed3ng h\u00e0nh c\u00f9ng con h\u1ecdc l\u1eadp tr\u00ecnh t\u1ea1i h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 Teky h\u00e0ng \u0111\u1ea7u Vi\u1ec7t Nam\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/q6QbqIs6ll8?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>C\u00e1c b\u1ed9 m\u00f4n gi\u1ea3ng d\u1ea1y t\u1ea1i Teky g\u1ed3m: <span style=\"font-weight: 400;\">L\u1eadp tr\u00ecnh v\u00e0 ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">l\u1eadp tr\u00ecnh game<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">l\u1eadp tr\u00ecnh web v\u1edbi python<\/span> <span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">L\u1eadp tr\u00ecnh Scratch<\/span> <span style=\"font-weight: 400;\">Robotics<\/span> Engineering, C\u00f4ng ngh\u1ec7 3D v\u00e0 MultiMedia. Ch\u00fang t\u00f4i tin r\u1eb1ng tr\u1ebb em Vi\u1ec7t Nam c\u00f3 c\u01a1 h\u1ed9i ph\u00e1t tri\u1ec3n m\u1ea1nh m\u1ebd trong m\u1ed9t n\u1ec1n kinh t\u1ebf s\u1ed1 v\u00e0 c\u1ea7n \u0111\u01b0\u1ee3c trang b\u1ecb s\u1eb5n s\u00e0ng \u0111\u1ec3 tr\u1edf th\u00e0nh nh\u1eefng doanh nh\u00e2n c\u00f4ng ngh\u1ec7 trong t\u01b0\u01a1ng lai.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lien_he_ngay_hoc_vien_cong_nghe_sang_tao_TEKY_de_duoc_tu_van_khoa_hoc\"><\/span><span style=\"color: #008000;\"><b>Li\u00ean h\u1ec7 ngay h\u1ecdc vi\u1ec7n c\u00f4ng ngh\u1ec7 s\u00e1ng t\u1ea1o TEKY \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n kh\u00f3a h\u1ecdc:<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cam k\u00eat 7 tu\u1ed5i c\u00f3 th\u1ec3 l\u1eadp tr\u00ecnh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Top 10 d\u1ef1 \u00e1n gi\u00e1o d\u1ee5c c\u00f3 t\u1ea7m \u1ea3nh h\u01b0\u1edfng nh\u1ea5t \u0110\u00f4ng Nam \u00c1 2017 &amp; 2018<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Top 3 D\u1ef1 \u00e1n xu\u1ea5t s\u1eafc nh\u1ea5t, NextGen \u2013 Th\u1ee5y S\u0129<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Hotline H\u00e0 N\u1ed9i: 024-7109-6668 | 0975-241-015<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Hotline H\u1ed3 Ch\u00ed Minh: 028-7109 9948 | 097-900-8642<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Website <\/span><a href=\"https:\/\/teky.edu.vn\/\"><span style=\"font-weight: 400;\">https:\/\/teky.edu.vn<\/span><\/a><span style=\"font-weight: 400;\"> | Email: support@teky.edu.vn |<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u b\u1edfi n\u00f3 v\u00f4 c\u00f9ng h\u1eefu d\u1ee5ng cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. M\u1eb7c d\u00f9 \u0111\u00e2y l\u00e0 h\u00e0m th\u00f4ng d\u1ee5ng, nh\u01b0ng m\u1ed9t s\u1ed1 ng\u01b0\u1eddi v\u1eabn ch\u01b0a hi\u1ec3u r\u00f5 v\u00e0 ch\u01b0a c\u00f3 c\u00e1ch \u0111\u1ec3 x\u00e0i h\u00e0m Vlookup excel hi\u1ec7u qu\u1ea3. N\u1ebfu &hellip;<\/p>\n","protected":false},"author":10,"featured_media":10082,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10079","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-cong-nghe"],"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\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh<\/title>\n<meta name=\"description\" content=\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.\" \/>\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\/ham-vlookup-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh\" \/>\n<meta property=\"og:description\" content=\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-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=\"2023-11-23T02:51:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T09:07:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kh\u00e1nh Kim\" \/>\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=\"Kh\u00e1nh Kim\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 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\/ham-vlookup-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\"},\"author\":{\"name\":\"Kh\u00e1nh Kim\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6\"},\"headline\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh\",\"datePublished\":\"2023-11-23T02:51:51+00:00\",\"dateModified\":\"2023-11-23T09:07:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\"},\"wordCount\":2447,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\",\"articleSection\":[\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\",\"name\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\",\"datePublished\":\"2023-11-23T02:51:51+00:00\",\"dateModified\":\"2023-11-23T09:07:18+00:00\",\"description\":\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg\",\"width\":650,\"height\":400,\"caption\":\"N\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y ngay!\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\",\"item\":\"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh\"}]},{\"@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\/8f946d2123e4e2277107e392790a1bd6\",\"name\":\"Kh\u00e1nh Kim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g\",\"caption\":\"Kh\u00e1nh Kim\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/kimkhanh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh","description":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.","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\/ham-vlookup-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh","og_description":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-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":"2023-11-23T02:51:51+00:00","article_modified_time":"2023-11-23T09:07:18+00:00","og_image":[{"width":650,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg","type":"image\/jpeg"}],"author":"Kh\u00e1nh Kim","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Kh\u00e1nh Kim","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/"},"author":{"name":"Kh\u00e1nh Kim","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/8f946d2123e4e2277107e392790a1bd6"},"headline":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh","datePublished":"2023-11-23T02:51:51+00:00","dateModified":"2023-11-23T09:07:18+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/"},"wordCount":2447,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg","articleSection":["C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/","name":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg","datePublished":"2023-11-23T02:51:51+00:00","dateModified":"2023-11-23T09:07:18+00:00","description":"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ef1c k\u1ef3 nhi\u1ec1u, do \u0111\u00f3 h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u th\u00eam nh\u00e9 b\u1ea1n.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/12\/nen-su-dung-ham-nay-ngay.jpg","width":650,"height":400,"caption":"N\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y ngay!"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt","item":"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh"}]},{"@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\/8f946d2123e4e2277107e392790a1bd6","name":"Kh\u00e1nh Kim","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab08c4bbf1d0787f26b32ab04d2cb7e329a3a082ea3dcb6ba78fb27076b856a9?s=96&d=mm&r=g","caption":"Kh\u00e1nh Kim"},"url":"https:\/\/teky.edu.vn\/blog\/author\/kimkhanh\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10079","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10079"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10079\/revisions"}],"predecessor-version":[{"id":23658,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10079\/revisions\/23658"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10082"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}