{"id":12969,"date":"2022-11-21T20:37:54","date_gmt":"2022-11-21T13:37:54","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12969"},"modified":"2022-12-07T14:25:27","modified_gmt":"2022-12-07T07:25:27","slug":"su-dung-ham-if-ket-hop-vlookup","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3"},"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;12969&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;S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3&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;\"><strong>H\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/strong> l\u00e0 c\u00e1ch t\u00ednh to\u00e1n quen thu\u1ed9c trong Excel \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. Tuy nhi\u00ean \u0111\u1ed1i v\u1edbi sinh vi\u00ean m\u1edbi ra tr\u01b0\u1eddng ho\u1eb7c ng\u01b0\u1eddi ch\u01b0a th\u00e0nh t\u1ea1o tin h\u1ecdc th\u00ec ph\u00e2n v\u00e2n kh\u00f4ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng hai lo\u1ea1i h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? C\u00f9ng Teky kh\u00e1m ph\u00e1 chi ti\u1ebft trong b\u00e0i vi\u1ebft sau 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\/su-dung-ham-if-ket-hop-vlookup\/#Tong_quan_ve_ham_If_va_ham_Vlookup_trong_Excel\" >T\u1ed5ng quan v\u1ec1 h\u00e0m If v\u00e0 h\u00e0m Vlookup trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#Cong_thuc_ham_If\" >C\u00f4ng th\u1ee9c h\u00e0m If<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#Cong_thuc_ham_Vlookup\" >C\u00f4ng th\u1ee9c h\u00e0m Vlookup<\/a><\/li><\/ul><\/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\/su-dung-ham-if-ket-hop-vlookup\/#Cac_truong_hop_ket_hop_ham_If_va_Vlookup_don_gian\" >C\u00e1c tr\u01b0\u1eddng h\u1ee3p k\u1ebft h\u1ee3p h\u00e0m If v\u00e0 Vlookup \u0111\u01a1n gi\u1ea3n<\/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\/su-dung-ham-if-ket-hop-vlookup\/#Truong_hop_1_Dung_ham_If_va_Vlookup_de_so_sanh_ket_qua_cua_Vlookup\" >Tr\u01b0\u1eddng h\u1ee3p 1: D\u00f9ng h\u00e0m If v\u00e0 Vlookup \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a Vlookup<\/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\/su-dung-ham-if-ket-hop-vlookup\/#Truong_hop_2_Ham_If_ket_hop_Vlookup_ket_hop_de_xu_ly_loi\" >Tr\u01b0\u1eddng h\u1ee3p 2: H\u00e0m If k\u1ebft h\u1ee3p Vlookup k\u1ebft h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#Truong_hop_3_Tra_cuu_dua_tren_hai_gia_tri\" >Tr\u01b0\u1eddng h\u1ee3p 3: Tra c\u1ee9u d\u1ef1a tr\u00ean hai gi\u00e1 tr\u1ecb<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#Luu_y_co_ban_khi_su_dung_ham_If_ket_hop_Vlookup\" >L\u01b0u \u00fd c\u01a1 b\u1ea3n khi s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tong_quan_ve_ham_If_va_ham_Vlookup_trong_Excel\"><\/span><b>T\u1ed5ng quan v\u1ec1 h\u00e0m If v\u00e0 h\u00e0m Vlookup trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m If trong Excel d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u00f3 s\u1eb5n \u0111\u01b0\u1ee3c \u0111\u01b0a ra. If l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t d\u1ec5 s\u1eed d\u1ee5ng. Khi ch\u1ec9 c\u1ea7n th\u1ecfa m\u00e3n m\u1ed9t trong hai \u0111i\u1ec1u ki\u1ec7n l\u00e0 b\u1ea1n c\u00f3 \u00e1p d\u1ee5ng h\u00e0m t\u00ednh to\u00e1n n\u00e0y. Tr\u00ean th\u1ef1c t\u1ebf, n\u00f3 th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00e1c t\u00ednh to\u00e1n c\u00f3 li\u00ean quan \u0111\u1ebfn gi\u00e1 tr\u1ecb \u0111\u00fang sai c\u01a1 b\u1ea3n.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"6. H\u01b0\u1edbng d\u1eabn b\u00e0i t\u1eadp excel. H\u00e0m Vlookup, h\u00e0m if K\u1ebft h\u1ee3p if v\u00e0 vlookup. Update\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/6LLJKDp0ZSc?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<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_If\"><\/span><strong>C\u00f4ng th\u1ee9c h\u00e0m If<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>IF (Logical_test, Value_If_True, Value_If_False) <\/b><span style=\"font-weight: 400;\">trong \u0111\u00f3 :<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Logical_test<\/b><span style=\"font-weight: 400;\"> : l\u00e0 c\u00e1c bi\u1ec3u th\u1ee9c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh v\u1ecb, v\u00ed d\u1ee5 l\u00e0 True ho\u1eb7c False<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Value_If_True<\/b><span style=\"font-weight: 400;\"> : \u0111\u00e2y l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 trong tr\u01b0\u1eddng h\u1ee3p \u0111\u1ed1i s\u1ed1 Logical_test \u00e0 True.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Value_If_False :<\/b><span style=\"font-weight: 400;\"> ng\u01b0\u1ee3c l\u1ea1i v\u1edbi Value_If_True th\u00ec \u0111\u00e2y l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 trong tr\u01b0\u1eddng h\u1ee3p \u0111\u1ed1i s\u1ed1 Logical_test l\u00e0 False.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12970\" aria-describedby=\"caption-attachment-12970\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12970 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-1.jpg\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m If\" width=\"600\" height=\"342\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-1-400x228.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12970\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c h\u00e0m If<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 Value_If_True th\u00ec h\u00e0m Logical_test \u0111\u00e3 ch\u00ednh x\u00e1c ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 Value_If_False th\u00ec h\u00e0m \u0111\u00e3 b\u1ecb sai.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m Vlookup \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n thi\u1ebft trong m\u1ed9t c\u1ed9t. H\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 tra c\u1ee9u c\u00e1c th\u00f4ng tin \u0111\u1ec3 th\u1ecfa m\u00e3n h\u00e0ng v\u00e0 c\u1ed9t. Trong th\u1ef1c t\u1ebf th\u00ec h\u00e0m Vlookup r\u1ea5t th\u00f4ng d\u1ee5ng khi t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u1ee3ng hay c\u00e1c \u0111\u01a1n gi\u00e1 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u c\u00f3 s\u1eb5n tr\u00ean m\u00e3 v\u1ea1ch hay m\u00e3 s\u1ea3n ph\u1ea9m,\u2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Vlookup\"><\/span><strong>C\u00f4ng th\u1ee9c h\u00e0m Vlookup<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Vlookup (lookup_value,table_array,col_index_num,[range_lookup])<\/b><span style=\"font-weight: 400;\"> trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Lookup_value: \u0111\u00e2y l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n ph\u1ea3i t\u00ecm trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Table: l\u00e0 b\u1ea3ng\u00a0 trong \u0111\u00f3 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb s\u1eb5n d\u00f9ng \u0111\u1ec3 truy xu\u1ea5t m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Col_index: c\u1ed9t trong b\u1ea3ng d\u00f9ng \u0111\u1ec3 truy xu\u1ea5t m\u1ed9t \u00f4 gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range_lookup: tr\u01b0\u1eddng h\u1ee3p l\u00e0 True: \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang, c\u00f2n False l\u00e0 \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12971\" aria-describedby=\"caption-attachment-12971\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12971 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-2.jpg\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m Vlookup\" width=\"600\" height=\"411\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-2-400x274.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12971\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c h\u00e0m Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">T\u1eeb \u0111\u00f3 ta c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m If k\u1ebft h\u1ee3p Vlookup:<\/span><\/p>\n<p><b>If<\/b><span style=\"font-weight: 400;\">(<\/span><b>Vlookup(lookup_value, table_array, col, index_num, [range_lookup])<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_truong_hop_ket_hop_ham_If_va_Vlookup_don_gian\"><\/span><b>C\u00e1c tr\u01b0\u1eddng h\u1ee3p k\u1ebft h\u1ee3p h\u00e0m If v\u00e0 Vlookup \u0111\u01a1n gi\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_1_Dung_ham_If_va_Vlookup_de_so_sanh_ket_qua_cua_Vlookup\"><\/span><b>Tr\u01b0\u1eddng h\u1ee3p 1: D\u00f9ng h\u00e0m If v\u00e0 Vlookup \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: D\u1ef1a v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 trong \u00f4 B3:C9, h\u00e3y t\u00ecm xem t\u00ean James trong \u00f4 E3 c\u00f3 ph\u1ea7n th\u01b0\u1edfng d\u1ef1a tr\u00ean doanh s\u1ed1 l\u1edbn h\u01a1n 2,000,000 l\u00e0 \u0111\u00fang hay sai?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean b\u1ea1n b\u1ea5m chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ecba ch\u1ec9 F3 trong b\u00e0i<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo \u0111\u00f3 b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m k\u1ebft h\u1ee3p gi\u1eefa If v\u00e0 Vlookup:<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00a0<\/span><i><span style=\"font-weight: 400;\">IF( Vlookup ( E3, B3:C9, 2, False ) &gt;gi\u00e1 tr\u1ecb c\u1ea7n ki\u1ec3m tra, \u201cYes\u201d, \u201cNo\u201d)<\/span><\/i><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 nh\u01b0 tr\u00ean h\u00ecnh.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12972\" aria-describedby=\"caption-attachment-12972\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12972 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-3.jpg\" alt=\"D\u00f9ng h\u00e0m If v\u00e0 Vlookup \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a Vlookup\" width=\"600\" height=\"307\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-3-400x205.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12972\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m If v\u00e0 Vlookup \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: \u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00e1c b\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed b\u1ea3ng B3: C9\u00a0 \u0111\u1ec3 sao ch\u00e9p khi s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m t\u01b0\u01a1ng t\u1ef1 ti\u1ebfp theo th\u00ec sau khi c\u00e1c b\u1ea1n k\u00e9o th\u1ea3 v\u00f9ng c\u1ee7a b\u1ea3ng c\u00e1c b\u1ea1n nh\u1ea5n ph\u00edm F4 tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 ti\u1ebfn h\u00e0nh c\u1ed1 \u0111\u1ecbnh, khi \u0111\u00f3 trong h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i bi\u1ec3u t\u01b0\u1ee3ng l\u00e0 $B$3:C$9. Tuy nhi\u00ean \u0111\u1ed1i v\u1edbi m\u1ed7i d\u00f2ng m\u00e1y s\u1ebd c\u00f3 c\u00e1ch c\u1ed1 \u0111\u1ecbnh kh\u00e1c nhau, n\u1ebfu nh\u01b0 c\u00e1ch tr\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm\u201d Fn + F4\u201d tr\u00ean b\u00e0n ph\u00edm.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_2_Ham_If_ket_hop_Vlookup_ket_hop_de_xu_ly_loi\"><\/span><b>Tr\u01b0\u1eddng h\u1ee3p 2: H\u00e0m If k\u1ebft h\u1ee3p Vlookup k\u1ebft h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u0169ng s\u1ebd g\u00e1n gi\u00e1 tr\u1ecb James cho \u00f4 F3 gi\u1ed1ng nh\u01b0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n s\u1ebd \u0111\u00e1nh c\u00f4ng th\u1ee9c t\u00ednh nh\u01b0 sau v\u00e0o \u00f4 F3:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">Vlookup( E3, B3:C9, 2, False)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi th\u1ef1c hi\u1ec7n th\u00ec b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 l\u1ed7i l\u00e0 #N\/A \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c trong c\u00e1c \u00f4 B3:C9 James kh\u00f4ng h\u1ec1 t\u1ed3n t\u1ea1i. Khi \u0111\u00f3, b\u1ea1n s\u1ebd ph\u1ea3i x\u1eed l\u00ed l\u1ed7i n\u00e0y b\u1eb1ng c\u00e1ch l\u1ed3ng hai h\u00e0m Vlookup v\u00e0 h\u00e0m If v\u00e0o v\u1edbi nhau k\u1ebft h\u1ee3p ISNA \u0111\u1ec3 cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m ISNA s\u1ebd gi\u00fap b\u1ea1n ki\u1ec3m tra k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Vlookup c\u00f3 \u0111ang b\u1ecb l\u1ed7i hay kh\u00f4ng. C\u00e1ch ki\u1ec3m tra l\u1ed7i sai \u0111\u01b0\u1ee3c tri\u1ec3n khai nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean b\u1ea1n c\u0169ng s\u1ebd k\u00edch chu\u1ed9t v\u00e0o \u00f4 F3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 F3:<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF ( ISNA ( Vlookup( E3, B3:C9,2, False)), \u201ct\u00ean kh\u00f4ng hi\u1ec3n th\u1ecb\u201d, Vlookup ( E3, B3:C9, 2, False )<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc cu\u1ed1i c\u00f9ng b\u1ea1n \u0111\u00fap chu\u1ed9t v\u00e0o ph\u00edm Enter \u0111\u1ec3 ki\u1ec3m tra.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12973\" aria-describedby=\"caption-attachment-12973\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12973 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-4.jpg\" alt=\"H\u00e0m If k\u1ebft h\u1ee3p Vlookup k\u1ebft h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i\" width=\"600\" height=\"373\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-If-ket-hop-Vlookup-4-400x249.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12973\" class=\"wp-caption-text\">H\u00e0m If k\u1ebft h\u1ee3p Vlookup k\u1ebft h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_3_Tra_cuu_dua_tren_hai_gia_tri\"><\/span><b>Tr\u01b0\u1eddng h\u1ee3p 3: Tra c\u1ee9u d\u1ef1a tr\u00ean hai gi\u00e1 tr\u1ecb<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 F3, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m If v\u00e0 Vlookup \u0111\u1ec3 tra c\u1ee9u d\u1ef1a tr\u00ean hai gi\u00e1 tr\u1ecb. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n \u0111\u00fap chu\u1ed9t v\u00e0o \u00f4 F3 trong b\u1ea3ng t\u00ednh<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau trong \u00f4 H3:<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF ( G3= \u201cShop1\u201d, Vlookup ( F3, B2:D7, False ), Vlookup (F3, B2:D7, 3, False ))<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u0110\u1ec3 ho\u00e0n th\u00e0nh vi\u1ec7c tra c\u1ee9u, b\u1ea1n nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ki\u1ec3m tra<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y_co_ban_khi_su_dung_ham_If_ket_hop_Vlookup\"><\/span><b>L\u01b0u \u00fd c\u01a1 b\u1ea3n khi s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng ch\u1ec9 d\u00f9ng Vlookup v\u00e0 If \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 ki\u1ec3m tra m\u00e0 b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ch\u00fang \u0111\u1ec3 s\u1eeda c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 cho h\u00e0m Vlookup c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng th\u00ec c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a \u201c lookup\u201d ph\u1ea3i \u0111\u01b0\u1ee3c n\u1eb1m trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta d\u00f9ng \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<p><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li>\n<p class=\"c-detail-head__title\"><a href=\"https:\/\/teky.edu.vn\/blog\/chuyen-word-sang-excel\/\"><strong>Chuy\u1ec3n word sang excel trong gi\u00e2y l\u00e1t ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c<\/strong><\/a><\/p>\n<\/li>\n<li>\n<p class=\"c-detail-head__title\"><strong><a href=\"https:\/\/teky.edu.vn\/blog\/cach-chuyen-file-word-sang-file-anh\/\">C\u00e1ch chuy\u1ec3n file word sang file \u1ea3nh \u0111\u01a1n gi\u1ea3n<\/a><\/strong><\/p>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t t\u1ea7n t\u1eadt nh\u1eefng c\u00e1ch th\u1ee9c v\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t khi s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup. Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u00f3 th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u00e0 b\u1ecf t\u00fai \u0111\u01b0\u1ee3c nhi\u1ec1u tip hay \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c h\u1ecdc v\u00e0 l\u00e0m vi\u1ec7c. H\u00e3y theo d\u00f5i ch\u00fang t\u00f4i \u0111\u1ec3 c\u1eadp nh\u1eadt th\u1eadt nhi\u1ec1u nh\u1eefng th\u00f4ng tin hay v\u00e0 h\u1ea5p d\u1eabn v\u1ec1 Excel m\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 b\u1ecf l\u1ee1 !<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-vlookup-nhieu-dieu-kien-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel-la-gi\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Excel<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-if-nhieu-dieu-kien\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m If nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng trong Excel d\u1ec5 hi\u1ec3u<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m If k\u1ebft h\u1ee3p Vlookup l\u00e0 c\u00e1ch t\u00ednh to\u00e1n quen thu\u1ed9c trong Excel \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. Tuy nhi\u00ean \u0111\u1ed1i v\u1edbi sinh vi\u00ean m\u1edbi ra tr\u01b0\u1eddng ho\u1eb7c ng\u01b0\u1eddi ch\u01b0a th\u00e0nh t\u1ea1o tin h\u1ecdc th\u00ec ph\u00e2n v\u00e2n kh\u00f4ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng hai lo\u1ea1i h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? C\u00f9ng Teky kh\u00e1m ph\u00e1 chi ti\u1ebft &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12969","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>S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!\" \/>\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\/su-dung-ham-if-ket-hop-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\" \/>\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-11-21T13:37:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T07:25:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"301\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/su-dung-ham-if-ket-hop-vlookup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2022-11-21T13:37:54+00:00\",\"dateModified\":\"2022-12-07T07:25:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\"},\"wordCount\":1719,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\",\"name\":\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png\",\"datePublished\":\"2022-11-21T13:37:54+00:00\",\"dateModified\":\"2022-12-07T07:25:27+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png\",\"width\":600,\"height\":301,\"caption\":\"H\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 trong t\u00edch t\u1eafc\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3\"}]},{\"@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":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3","description":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!","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\/su-dung-ham-if-ket-hop-vlookup\/","og_locale":"vi_VN","og_type":"article","og_title":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3","og_description":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!","og_url":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/","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-11-21T13:37:54+00:00","article_modified_time":"2022-12-07T07:25:27+00:00","og_image":[{"width":600,"height":301,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3","datePublished":"2022-11-21T13:37:54+00:00","dateModified":"2022-12-07T07:25:27+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/"},"wordCount":1719,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/","url":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/","name":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png","datePublished":"2022-11-21T13:37:54+00:00","dateModified":"2022-12-07T07:25:27+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u1edbi h\u01b0\u1edbng d\u1eabn sau. C\u00f9ng TEKY kh\u00e1m ph\u00e1 ngay th\u00f4i n\u00e0o, \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/ham-if-ket-hop-vlookup.png","width":600,"height":301,"caption":"H\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 trong t\u00edch t\u1eafc"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3"}]},{"@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\/12969","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=12969"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12974"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}