{"id":13682,"date":"2022-04-05T10:47:37","date_gmt":"2022-04-05T03:47:37","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13682"},"modified":"2022-04-05T10:47:37","modified_gmt":"2022-04-05T03:47:37","slug":"ham-vlookup-trong-excel-la-gi","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/","title":{"rendered":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup 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;13682&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? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel&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><span style=\"font-weight: 400;\">Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft, Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap con ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng h\u01a1n v\u1edbi nh\u1eefng trang t\u00ednh kh\u00e1c nhau. N\u1ebfu s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel, \u0111\u00f3 s\u1ebd l\u00e0 m\u1ed9t \u0111i\u1ec3m c\u1ed9ng trong h\u1ed3 s\u01a1 xin vi\u1ec7c c\u1ee7a b\u1ea1n. <\/span><b>H\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.<\/span><\/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\/ham-vlookup-trong-excel-la-gi\/#Ham_Vlookup_trong_Excel_la_gi\" >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-la-gi\/#Cach_su_dung_ham_Vlookup_nhu_the_nao\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup nh\u01b0 th\u1ebf n\u00e0o?<\/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-la-gi\/#Mot_so_luu_y_khi_su_dung_ham_Vlookup_trong_Excel\" >M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/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-la-gi\/#Vi_du_cu_the_ve_cach_dung_ham_Vlookup\" >V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m Vlookup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#Mot_so_loi_thuong_gap_khi_su_dung_ham_VLookup\" >M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLookup<\/a><\/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\/ham-vlookup-trong-excel-la-gi\/#Loi_ket\" >L\u1eddi k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Vlookup_trong_Excel_la_gi\"><\/span><b>H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i ngh\u0129a ra V l\u00e0 Vertical c\u00f3 ngh\u0129a l\u00e0 h\u00e0ng d\u1ecdc, Lookup \u0111\u01b0\u1ee3c hi\u1ec3u theo \u0111\u00fang ngh\u0129a trong ti\u1ebfng anh ngh\u0129a l\u00e0 t\u00ecm ki\u1ec3u. Hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 t\u00ecm ki\u1ebfm theo h\u00e0ng d\u1ecdc.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Vlookup l\u00e0 h\u00e0m v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel gi\u00fap b\u1ea1n d\u00f2 v\u00e0 tr\u1ea3 l\u1ea1i d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. Trong m\u1ed9t b\u1ea3ng, <\/span><b>h\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> s\u1ebd gi\u00fap b\u1ea1n d\u00f2 d\u1eef li\u1ec7u theo h\u00e0ng d\u1ecdc v\u00e0 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u h\u00e0ng ngang t\u01b0\u01a1ng \u1ee9ng. M\u1ed9t trong nh\u1eefng ch\u1ee9c n\u0103ng c\u1ee7a Vlookup l\u00e0 h\u00e0m d\u1eef li\u1ec7u. N\u00f3 s\u1ebd ho\u1ea1t \u0111\u1ed9ng d\u1ef1a tr\u00ean b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u ho\u1eb7c \u0111\u01a1n gi\u1ea3n l\u00e0 danh s\u00e1ch c\u00e1c h\u1ea1ng m\u1ee5c.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>H\u00e0m Vlookup trong Excel<\/b><span style=\"font-weight: 400;\"> c\u1ef1c k\u1ef3 th\u00f4ng minh khi t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m, \u0111\u01a1n gi\u00e1, s\u1ed1 l\u01b0\u1ee3ng,&#8230; d\u1ef1a tr\u00ean m\u00e3 v\u1ea1ch, id,&#8230; ho\u1eb7c t\u00ecm t\u00ean nh\u00e2n vi\u00ean, x\u1ebfp lo\u1ea1i nh\u00e2n vi\u00ean.<\/span><\/p>\n<figure id=\"attachment_13683\" aria-describedby=\"caption-attachment-13683\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13683\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\" alt=\"H\u00e0m Vlookup l\u00e0 g\u00ec\" width=\"512\" height=\"288\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg 512w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi-400x225.jpg 400w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-13683\" class=\"wp-caption-text\">H\u00e0m Vlookup l\u00e0 g\u00ec<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Vlookup_nhu_the_nao\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup nh\u01b0 th\u1ebf n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 th\u1ec3 <\/span><b>s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> th\u00ec tr\u01b0\u1edbc ti\u00ean b\u1ea3ng d\u1eef li\u1ec7u ph\u1ea3i ch\u1ee9a c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb item code ( m\u00e3 s\u1ea3n ph\u1ea9m) ho\u1eb7c id \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean trong c\u1ed9t \u0111\u1ec3 c\u00f3 th\u1ec3 nh\u1eadn bi\u1ebft m\u00e3.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>=&gt; C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Vlookup:<\/b> <i><span style=\"font-weight: 400;\">\u201c=Vlookup(Lookup_Value, Table_Array, Col_index_num, Range_Lookup)\u201d<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><b>Trong \u0111\u00f3 th\u00ec:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Lookup_value: l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 \u0111i\u1ec1n tr\u1ef1c ti\u1ebfp hay tham chi\u1ebfu \u0111\u1ebfn b\u1ea5t k\u1ef3 m\u1ed9t \u00f4 n\u00e0o tr\u00ean b\u1ea3ng t\u00ednh. Hi\u1ec3u \u0111\u01a1n gi\u1ea3n th\u00ec \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Table_array: B\u1ea3ng gi\u1edbi h\u1ea1n \u0111\u1ec3 d\u00f2 t\u00ecm. \u0110\u00e2y l\u00e0 n\u01a1i b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb v\u00e0 t\u00ecm t\u1eeb n\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Col_index_num: l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t l\u1ea5y d\u1eef li\u1ec7u trong b\u1ea3ng c\u1ea7n d\u00f2 t\u00ecm, t\u00ednh t\u1eeb tr\u00e1i qua ph\u1ea3i. Hay s\u1ed1 c\u1ed9t trong d\u1ea3i \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 do b\u1ea1n quy\u1ebft \u0111\u1ecbnh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Range_lookup: t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c ho\u1eb7c t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i v\u1edbi b\u1ea3ng gi\u1edbi h\u1ea1n. Khi b\u1ecf qua th\u00ec m\u1eb7c \u0111\u1ecbnh l\u00e0 1. Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 g\u1ea7n \u0111\u00fang ho\u1eb7c ch\u00ednh x\u00e1c.\u00a0<\/span><\/li>\n<\/ul>\n<p><b>K\u1ebft qu\u1ea3<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu Range_lookup = 1 (TRUE): d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu Range_lookup = 0 (FALSE): d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fang ta <\/span><b>s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 tra c\u1ee9u gi\u00e1 tr\u1ecb trong h\u00e0ng. N\u1ebfu nh\u01b0 b\u1ea1n ph\u1ea3i sao ch\u00e9p c\u00f4ng th\u1ee9c \u1edf \u00f4 gi\u00e1 tr\u1ecb kh\u00e1c th\u00ec b\u1ea1n ph\u1ea3i d\u00f9ng d\u1ea5u $ \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh Table_array \u0111\u1ec3 gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm b\u1eb1ng c\u00e1ch khai b\u00e1o c\u1ed9t ho\u1eb7c s\u1eed d\u1ee5ng n\u00fat F4 khi ch\u1ecdn b\u1ea3ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0: ($C$6:$A$13).<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<figure id=\"attachment_13684\" aria-describedby=\"caption-attachment-13684\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13684\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-su-dung.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Vlookup trong excel\" width=\"512\" height=\"288\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-su-dung.jpg 512w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/cach-su-dung-400x225.jpg 400w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-13684\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Vlookup trong excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup nh\u01b0 th\u1ebf n\u00e0o?<\/span><\/i><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_su_dung_ham_Vlookup_trong_Excel\"><\/span><b>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/b><span style=\"font-weight: 400;\">: Khi copy c\u00f4ng th\u1ee9c, h\u00e3y bi\u1ebfn Table_array ho\u1eb7c Lookup_Value th\u00e0nh tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i b\u1eb1ng c\u00e1ch th\u00eam $ v\u00e0o tr\u01b0\u1edbc c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng \u0111\u1ec3 gi\u00e1 tr\u1ecb kh\u00f4ng b\u1ecb thay \u0111\u1ed5i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 b\u1ecb thay \u0111\u1ed5i d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 b\u1ecb sai l\u1ec7ch.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kh\u00f4ng l\u01b0u tr\u1eef nh\u1eefng gi\u00e1 tr\u1ecb s\u1ed1 d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n:<\/b><span style=\"font-weight: 400;\"> Trong Table_array, d\u1eef li\u1ec7u s\u1ed1 \u0111ang \u1edf d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n m\u00e0 Lookup_Value l\u1ea1i l\u00e0 d\u1ea1ng s\u1ed1 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd b\u1ecb l\u1ed7i #N\/A.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>B\u1ea3ng d\u00f2 t\u00ecm ch\u1ee9a nh\u1eefng gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng:<\/b><span style=\"font-weight: 400;\"> N\u1ebfu gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u c\u00e1i b\u1ecb tr\u00f9ng nhau, khi d\u00f9ng Vlookup s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean m\u00e0 n\u00f3 t\u00ecm th\u1ea5y \u0111\u01b0\u1ee3c trong s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3. Nh\u01b0 v\u1eady s\u1ebd \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn qu\u00e1 tr\u00ecnh l\u1ecdc t\u00ecm d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<p><b>Gi\u1ea3i ph\u00e1p cho v\u1ea5n \u0111\u1ec1 \u0111\u00f3 l\u00e0<\/b><span style=\"font-weight: 400;\">: B\u00f4i \u0111en b\u1ea3ng d\u00f2 t\u00ecm v\u00e0 ch\u1ecdn Data =&gt; Remove Duplicates nh\u01b0 v\u1eady l\u00e0 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ho\u1eb7c b\u1ea1n b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch kh\u00e1c. L\u1ecdc ra danh s\u00e1ch k\u1ebft qu\u1ea3 b\u1eb1ng Pivot Table.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, c\u00f2n m\u1ed9t s\u1ed1 r\u00e0ng bu\u1ed9c c\u1ee7a h\u00e0m Vlookup nh\u01b0: Kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng khi t\u00ecm ki\u1ebfm, Vlookup ch\u1ec9 t\u00ecm t\u1eeb tr\u00e1i sang ph\u1ea3i, C\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm lu\u00f4n \u0111\u1ee9ng \u0111\u1ea7u, Vlookup c\u00f3 2 ki\u1ec3u t\u00ecm ki\u1ebfm, s\u1ed1 c\u1ed9t t\u00ecm ki\u1ebfm ph\u1ea3i nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 c\u1ed9t trong b\u1ea3ng t\u00ecm ki\u1ebfm, ch\u1ec9 t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n trong b\u1ea3ng t\u00ecm ki\u1ebfm, c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m v\u1edbi nhau t\u00f9y v\u00e0o m\u1ee5c \u0111\u00edch t\u00ecm ki\u1ebfm,&#8230;.<\/span><\/p>\n<figure id=\"attachment_13685\" aria-describedby=\"caption-attachment-13685\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13685 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/luu-y-khi-su-dung.jpg\" alt=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel\" width=\"512\" height=\"209\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/luu-y-khi-su-dung.jpg 512w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/luu-y-khi-su-dung-400x163.jpg 400w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-13685\" class=\"wp-caption-text\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_cu_the_ve_cach_dung_ham_Vlookup\"><\/span><b>V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>V\u00ed d\u1ee5 1<\/b><span style=\"font-weight: 400;\">: <\/span><b>C\u00e1ch d\u00f9ng h\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 x\u1ebfp lo\u1ea1i c\u1ee7a h\u1ecdc sinh, nh\u00e2n vi\u00ean<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n c\u00f3 1 b\u1ea3ng \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m v\u00e0 quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i nh\u01b0 sau:<\/span><\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">stt<\/span><\/td>\n<td><span style=\"font-weight: 400;\">H\u1ecd t\u00ean<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110i\u1ec3m tb<\/span><\/td>\n<td><span style=\"font-weight: 400;\">X\u1ebfp lo\u1ea1i\u00a0<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n V\u0103n A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9,1<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n V\u0103n B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8,5<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">33<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n V\u0103n C<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,66<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i nh\u01b0 sau:<\/span><\/p>\n<table style=\"width: 21.1264%;\">\n<tbody>\n<tr>\n<td style=\"width: 54.1667%;\"><span style=\"font-weight: 400;\">&lt;5,5<\/span><\/td>\n<td style=\"width: 124.21%;\"><span style=\"font-weight: 400;\">Y\u1ebfu<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 54.1667%;\"><span style=\"font-weight: 400;\">5,5<\/span><\/td>\n<td style=\"width: 124.21%;\"><span style=\"font-weight: 400;\">Trung B\u00ecnh<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 54.1667%;\"><span style=\"font-weight: 400;\">&gt;7<\/span><\/td>\n<td style=\"width: 124.21%;\"><span style=\"font-weight: 400;\">Kh\u00e1<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 54.1667%;\"><span style=\"font-weight: 400;\">&gt;8<\/span><\/td>\n<td style=\"width: 124.21%;\"><span style=\"font-weight: 400;\">Gi\u1ecfi<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 54.1667%;\"><span style=\"font-weight: 400;\">&gt;8,5<\/span><\/td>\n<td style=\"width: 124.21%;\"><span style=\"font-weight: 400;\">Xu\u1ea5t S\u1eafc<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">B\u00e2y gi\u1edd <\/span><b>s\u1eed d\u1ee5ng H\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> s\u1ebd gi\u00fap b\u1ea1n ph\u00e2n lo\u1ea1i \u0111\u01b0\u1ee3c h\u1ecdc sinh theo th\u1ee9 t\u1ef1 t\u1eeb y\u1ebfu \u0111\u1ebfn gi\u1ecfi theo ph\u01b0\u01a1ng ph\u00e1p d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>V\u00ed d\u1ee5 2<\/b><span style=\"font-weight: 400;\">: H\u00e0m vlookup t\u00ecm k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c True or False<\/span><\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">ID<\/span><\/td>\n<td><span style=\"font-weight: 400;\">H\u1ecc\u00a0<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u00caN<\/span><\/td>\n<td><span style=\"font-weight: 400;\">TI\u00caU \u0110\u1ec0<\/span><\/td>\n<td><span style=\"font-weight: 400;\">NG\u00c0Y SINH<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">123<\/span><\/td>\n<td><span style=\"font-weight: 400;\">nguy\u1ec5n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">a<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ea1i di\u1ec7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">19\/03\/1975<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">124<\/span><\/td>\n<td><span style=\"font-weight: 400;\">l\u00ea<\/span><\/td>\n<td><span style=\"font-weight: 400;\">b<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Ph\u00f3 ch\u1ee7 t\u1ecbch<\/span><\/td>\n<td><span style=\"font-weight: 400;\">24\/01\/1980<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">125<\/span><\/td>\n<td><span style=\"font-weight: 400;\">tr\u1ea7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">c<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ea1i di\u1ec7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">25\/06\/1990<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">126<\/span><\/td>\n<td><span style=\"font-weight: 400;\">H\u00e0<\/span><\/td>\n<td><span style=\"font-weight: 400;\">d<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ea1i di\u1ec7n<\/span><\/td>\n<td><span style=\"font-weight: 400;\">31\/10\/1991<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">127<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u00fd<\/span><\/td>\n<td><span style=\"font-weight: 400;\">e<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Gi\u00e1m \u0111\u1ed1c<\/span><\/td>\n<td><span style=\"font-weight: 400;\">15\/08\/1992<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">128<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Khu\u1ea5t<\/span><\/td>\n<td><span style=\"font-weight: 400;\">g<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ea1i di\u1ec7n\u00a0<\/span><\/td>\n<td><span style=\"font-weight: 400;\">13\/01\/1993<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c: =Vlookup(124, A2;C7,2, FALSE)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: Fontana<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_loi_thuong_gap_khi_su_dung_ham_VLookup\"><\/span><b>M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li aria-level=\"1\"><b>L\u1ed7i #N\/A<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vlookup l\u00e0 h\u00e0m ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00ean c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i trong Table_array. N\u1ebfu kh\u00f4ng s\u1ebd x\u1ea3y ra l\u1ed7i #N\/A. L\u00fac n\u00e0y \u0111\u1ec3 x\u1eed l\u00fd c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m Index k\u1ebft h\u1ee3p v\u1edbi Match.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A do d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 trong Table_array. Khi \u0111\u00f3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span><a href=\"https:\/\/www.dienmayxanh.com\/kinh-nghiem-hay\/cach-su-dung-ham-iferror-de-bat-loi-hieu-qua-trong-1359808\"><span style=\"font-weight: 400;\">h\u00e0m IFERROR<\/span><\/a><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u0111\u1ed5i #N\/A th\u00e0nh gi\u00e1 tr\u1ecb kh\u00e1c.<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>L\u1ed7i #REF<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu Col_index_num l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong Table_array, ch\u00fang ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb <\/span><a href=\"https:\/\/www.dienmayxanh.com\/kinh-nghiem-hay\/loi-ref-trong-excel-1366751\"><span style=\"font-weight: 400;\">l\u1ed7i #REF!<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o Col_index_num b\u1eb1ng ho\u1eb7c &lt; s\u1ed1 c\u1ed9t trong Table_array.<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>L\u1ed7i #VALUE<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu Col_index_num nh\u1ecf h\u01a1n 1 trong c\u00f4ng th\u1ee9c, b\u1ea1n s\u1ebd nh\u1eadn gi\u00e1 tr\u1ecb l\u1ed7i #VALUE!.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Trong Table_array, c\u1ed9t 1 l\u00e0 c\u1ed9t t\u00ecm ki\u1ebfm, c\u1ed9t 2 l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean \u1edf b\u00ean ph\u1ea3i c\u1ed9t t\u00ecm ki\u1ebfm. V\u00ec v\u1eady khi xu\u1ea5t hi\u1ec7n l\u1ed7i n\u00e0y, h\u00e3y ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb Col_index_number trong c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh cho ph\u00f9 h\u1ee3p.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span><b>L\u1eddi k\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 th\u00f4ng tin v\u1ec1 <\/span><b>h\u00e0m Vlookup trong Excel<\/b><span style=\"font-weight: 400;\"> c\u0169ng nh\u01b0 <\/span><b>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/b><span style=\"font-weight: 400;\"> chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 c\u1ee5 th\u1ec3. Vi\u1ec7c n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n l\u00e0 m\u1ed9t \u0111i\u1ec1u v\u00f4 c\u00f9ng t\u1ea5t y\u1ebfu. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd g\u00f3p ph\u1ea7n gi\u00fap c\u00e1c b\u1ea1n tr\u00ean con \u0111\u01b0\u1eddng chinh ph\u1ee5c \u0111\u01b0\u1ee3c Excel.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft, Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap con ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng h\u01a1n v\u1edbi nh\u1eefng trang t\u00ednh kh\u00e1c nhau. N\u1ebfu s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel, \u0111\u00f3 s\u1ebd l\u00e0 m\u1ed9t \u0111i\u1ec3m c\u1ed9ng trong h\u1ed3 s\u01a1 xin vi\u1ec7c c\u1ee7a b\u1ea1n. H\u00e0m Vlookup l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13683,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"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? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel<\/title>\n<meta name=\"description\" content=\"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.\" \/>\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-la-gi\/\" \/>\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? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\" \/>\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=\"2022-04-05T03:47:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"288\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"7 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-la-gi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel\",\"datePublished\":\"2022-04-05T03:47:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\"},\"wordCount\":1873,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\",\"name\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\",\"datePublished\":\"2022-04-05T03:47:37+00:00\",\"description\":\"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg\",\"width\":512,\"height\":288,\"caption\":\"H\u00e0m Vlookup l\u00e0 g\u00ec\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup 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\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel","description":"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.","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-la-gi\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel","og_description":"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/","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":"2022-04-05T03:47:37+00:00","og_image":[{"width":512,"height":288,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg","type":"image\/jpeg"}],"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":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel","datePublished":"2022-04-05T03:47:37+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/"},"wordCount":1873,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/","url":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/","name":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg","datePublished":"2022-04-05T03:47:37+00:00","description":"H\u00e0m Vlookup trong Excle l\u00e0 h\u00e0m Excel v\u00f4 c\u00f9ng h\u1eefu \u00edch nh\u01b0ng l\u1ea1i \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn n\u00f3. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-vlooup-la-gi.jpg","width":512,"height":288,"caption":"H\u00e0m Vlookup l\u00e0 g\u00ec"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup 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\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13682","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=13682"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13682\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13683"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}