{"id":8810,"date":"2024-12-29T05:35:40","date_gmt":"2024-12-29T05:35:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel\/"},"modified":"2024-12-29T05:35:40","modified_gmt":"2024-12-29T05:35:40","slug":"huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 g\u1eb7p r\u1eafc r\u1ed1i khi ph\u1ea3i vi\u1ebft h\u00e0m\u00a0IF l\u1ed3ng nhau v\u1edbi qu\u00e1 nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n? B\u1ea1n mu\u1ed1n bi\u1ebft m\u1ed9t c\u00e1ch kh\u00e1c gi\u00fap c\u00f4ng vi\u1ec7c\u00a0\u0111\u00f3 tr\u1edf n\u00ean\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n?\u00a0\u0110\u00e2y l\u00e0 gi\u1ea3i ph\u00e1p cho b\u1ea1n:\u00a0c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau trong Excel. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay n\u00e0o:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6770dfabc39d5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html#Dieu_kien_de_su_dung_ham_VLOOKUP_thay_the_ham_IF_long_nhau\" title=\"\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau\">\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html#Cach_su_dung_ham_VLOOKUP_thay_the_ham_IF_long_nhau\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\u00a0thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\u00a0thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html#Thiet_lap_bang_dieu_kien\" title=\"Thi\u1ebft l\u1eadp b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n\">Thi\u1ebft l\u1eadp b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html#Cach_viet_ham_VLOOKUP\" title=\"C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP\">C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dieu_kien_de_su_dung_ham_VLOOKUP_thay_the_ham_IF_long_nhau\"><\/span>\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng ph\u1ea3i trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta\u00a0\u0111\u1ec1u l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y. Ch\u1ec9 trong m\u1ed9t s\u1ed1\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u1ea5t\u00a0\u0111\u1ecbnh th\u00ec ch\u00fang ta m\u1edbi c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng. C\u1ee5 th\u1ec3:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb trong c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 d\u1ea1ng S\u1ed1<\/li>\n<li>C\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f3 tu\u00e2n th\u1ee7 theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n v\u00e0 c\u00f3 t\u00ednh li\u00ean t\u1ee5c<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 nh\u01b0 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m\u00a0IF l\u1ed3ng d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\">1.\u00a0\u0110\u1ec1 b\u00e0i: X\u00e1c\u00a0\u0111\u1ecbnh m\u1ee9c th\u01b0\u1edfng d\u1ef1a theo\u00a0\u0111i\u1ec3m KPIs\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26653\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-de-bai-1024x279-1.png\" width=\"1024\" height=\"279\" title=\"ham-if-nhieu-dieu-kien-de-bai-1024x279-1\"><\/p>\n<p style=\"padding-left: 30px\">2. K\u1ebft qu\u1ea3: H\u00e0m\u00a0IF l\u1ed3ng nhau<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26654\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-dung-cong-thuc-tren-thanh-formula-1024x228-1.png\" width=\"1024\" height=\"228\" title=\"noi-dung-cong-thuc-tren-thanh-formula-1024x228-1\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-822.gif\" title=\"ex101_92019-nho-822\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau d\u1ec5 hi\u1ec3u d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c h\u00e0m VLOOKUP\u00a0\u0111\u1ec3 thay th\u1ebf cho h\u00e0m\u00a0IF l\u1ed3ng, v\u00ec th\u1ecfa m\u00e3n c\u1ea3 2\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>B\u1ea3ng\u00a0\u0111i\u1ec3m KPIs x\u00e9t th\u01b0\u1edfng ph\u1ea7n\u00a0\u0111i\u1ec3m KPIs l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 (c\u1ed9t I)<\/li>\n<li>C\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t I c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp\u00a0\u0111\u01b0\u1ee3c theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_VLOOKUP_thay_the_ham_IF_long_nhau\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\u00a0thay th\u1ebf h\u00e0m\u00a0IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_bang_dieu_kien\"><\/span>Thi\u1ebft l\u1eadp b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng c\u00f3 s\u1eb5n b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n (nh\u01b0 b\u1ea3ng\u00a0\u0110i\u1ec3m KPIs x\u00e9t th\u01b0\u1edfng) nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean. C\u0169ng kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n c\u0169ng\u00a0\u0111\u1ea3m b\u1ea3o ngay\u00a0\u0111\u01b0\u1ee3c nguy\u00ean t\u1eafc: l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<p>Do\u00a0\u0111\u00f3 vi\u1ec7c\u00a0\u0111\u1ea7u ti\u00ean ch\u00fang ta c\u1ea7n l\u00e0m\u00a0\u0111\u00f3 l\u00e0 thi\u1ebft l\u1eadp l\u1ea1i b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>C\u1ee5 th\u1ec3 nh\u01b0\u00a0\u1edf v\u00ed d\u1ee5 tr\u00ean ta c\u00f3 b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n ban\u00a0\u0111\u1ea7u l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26663\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-thuong-kpis-bang-dieu-kien-ban-dau.png\" width=\"364\" height=\"280\" title=\"tinh-thuong-kpis-bang-dieu-kien-ban-dau\"><\/p>\n<p>\u1ede\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2, ta c\u00f3 \u0110i\u1ec1u ki\u1ec7n:\u00a0T\u1eeb 55 t\u1edbi 60 c\u00f3 ngh\u0129a l\u00e0 <strong>\u0110i\u1ec3m KPIs &gt;= 55 v\u00e0\u00a0\u0110i\u1ec3m KPIs &lt;= 60<\/strong><\/p>\n<p>\u1ede\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 3, ta c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n: Tr\u00ean 60 t\u1edbi 75 c\u00f3 ngh\u0129a l\u00e0\u00a0<strong>\u0110i\u1ec3m KPIs &gt; 60 v\u00e0\u00a0\u0110i\u1ec3m KPIs &lt;=75<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n ch\u01b0a c\u00f3 s\u1ef1 th\u1ed1ng nh\u1ea5t v\u1edbi nhau v\u1ec1 kho\u1ea3ng c\u00e1ch, d\u1ea5u c\u1ee7a c\u00e1c m\u1ed1c\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc v\u00e0 sau cho nh\u1eefng kho\u1ea3ng n\u1ed1i ti\u1ebfp nhau.<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 l\u1eadp l\u1ea1i b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n theo\u00a0\u0111\u00fang ti\u00eau chu\u1ea9n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26664\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-thuong-kpis-bang-dieu-kien-update.png\" width=\"399\" height=\"309\" title=\"tinh-thuong-kpis-bang-dieu-kien-update\"><\/p>\n<p>Trong b\u1ea3ng\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0y, c\u00e1c ti\u00eau ch\u00ed\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i theo\u00a0\u0111\u00fang c\u00e1c m\u1ed1c gi\u00e1 tr\u1ecb theo\u00a0\u0111i\u1ec1u ki\u1ec7n t\u0103ng d\u1ea7n, n\u1ed1i ti\u1ebfp nhau:<\/p>\n<ul>\n<li>D\u01b0\u1edbi 55 c\u00f3 ngh\u0129a l\u00e0 t\u1eeb &gt;=0 v\u00e0 &lt;55<\/li>\n<li>T\u1eeb 55 t\u1edbi 60 c\u00f3 ngh\u0129a l\u00e0 &gt;=55 v\u00e0 &lt;61<\/li>\n<li>Tr\u00ean 60 t\u1edbi 75 c\u00f3 ngh\u0129a l\u00e0 &gt;=61 v\u00e0 &lt;76<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec1u c\u00f9ng ph\u1ea1m vi v\u00e0 c\u00f9ng d\u1ea5u\u00a0\u0111i\u1ec1u ki\u1ec7n. Ch\u00fang ta c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1ee3c t\u00ednh logic c\u1ee7a\u00a0\u0111i\u1ec1u ki\u1ec7n ban\u00a0\u0111\u1ea7u.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_VLOOKUP\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi\u00a0\u0111\u00f3 d\u00f9ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26665\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-vlookup-tham-chieu-tuong-doi-1024x282-1.png\" width=\"1024\" height=\"282\" title=\"ham-vlookup-tham-chieu-tuong-doi-1024x282-1\"><\/p>\n<p>T\u1ea1i \u00f4 E3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/p>\n<p style=\"padding-left: 30px\">=VLOOKUP(D3, $I$3:$J$10, 2, 1)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb\u00a0tham chi\u1ebfu l\u00e0\u00a0\u0111i\u1ec3m KPIs theo c\u1ed9t D, t\u1eeb\u00a0\u00f4 D3<\/li>\n<li>V\u00f9ng b\u1ea3ng tham chi\u1ebfu l\u00e0 b\u1ea3ng\u00a0\u0110i\u1ec3m KPIs, t\u00ednh t\u1eeb c\u1ed9t Gi\u00e1 tr\u1ecb tr\u1edf\u00a0\u0111i (C\u1ed9t gi\u00e1 tr\u1ecb ph\u1ea3i l\u00e0 c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean trong v\u00f9ng b\u1ea3ng tham chi\u1ebfu)<\/li>\n<li>K\u1ebft qu\u1ea3 tham chi\u1ebfu l\u00e0 c\u1ed9t M\u1ee9c th\u01b0\u1edfng, l\u00e0 c\u1ed9t th\u1ee9 2 trong v\u00f9ng b\u1ea3ng tham chi\u1ebfu<\/li>\n<li>Ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm: <strong>Ch\u1ecdn s\u1ed1 1<\/strong> l\u00e0 t\u00ecm ki\u1ebfm t\u01b0\u01a1ng\u00a0\u0111\u1ed1i<\/li>\n<\/ul>\n<blockquote>\n<p>Nguy\u00ean t\u1eafc t\u00ecm ki\u1ebfm t\u01b0\u01a1ng\u00a0\u0111\u1ed1i c\u1ee7a h\u00e0m VLOOKUP: T\u00ecm theo gi\u00e1 tr\u1ecb NH\u1ece H\u01a0N v\u00e0 G\u1ea6N NH\u1ea4T v\u1edbi gi\u00e1 tr\u1ecb tham chi\u1ebfu.<\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5:\u00a0\u0110i\u1ec3m KPIs l\u00e0 82 (\u00f4 D4) th\u00ec gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n n\u00f3 trong b\u1ea3ng\u00a0\u0110i\u1ec3m KPIs l\u00e0 81 (trong kho\u1ea3ng tr\u00ean 80 t\u1edbi 85), gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng l\u00e0 0.25 =&gt; K\u1ebft qu\u1ea3 h\u00e0m VLOOKUP l\u00e0 0.25<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng duy nh\u1ea5t 1 h\u00e0m VLOOKUP l\u00e0 thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng v\u1edbi 7 h\u00e0m\u00a0IF l\u1ed3ng nhau, m\u00e0 k\u1ebft qu\u1ea3 v\u1eabn ch\u00ednh x\u00e1c.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem chi ti\u1ebft h\u01a1n t\u1ea1i file m\u1eabu. T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2TjSpfs\">http:\/\/bit.ly\/2TjSpfs<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 h\u00e0m VLOOKUP theo c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">H\u00e0m Vlookup trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">H\u00e0m vlookup trong Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng n\u00e2ng cao th\u01b0\u1eddng g\u1eb7p<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-excel-co-loi-giai-phan-2.html\">B\u00e0i t\u1eadp\u00a0Excel d\u00f9ng h\u00e0m VLOOKUP c\u00f3 l\u1eddi gi\u1ea3i<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-822.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8810"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8811"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}