{"id":9963,"date":"2025-01-06T07:09:11","date_gmt":"2025-01-06T07:09:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/ham-vlookup-co-ban-huong-dan-tim-hieu-va-su-dung-qua-cac-vi-du\/"},"modified":"2025-01-06T07:09:11","modified_gmt":"2025-01-06T07:09:11","slug":"ham-vlookup-co-ban-huong-dan-tim-hieu-va-su-dung-qua-cac-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/ham-vlookup-co-ban-huong-dan-tim-hieu-va-su-dung-qua-cac-vi-du\/","title":{"rendered":"H\u00e0m VLOOKUP c\u01a1 b\u1ea3n: H\u01b0\u1edbng d\u1eabn t\u00ecm hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng qua c\u00e1c v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>VLOOKUP l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn m\u00e0 b\u1ea5t c\u1ee9 ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel n\u00e0o c\u0169ng n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng thu\u1ea9n th\u1ee5c. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd n\u00f3i v\u1ec1 nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m Vlookup<\/strong><\/a><\/em><\/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-677b81970dcfe\" 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-vlookup-co-ban-cho-nguoi-moi.html#Cau_truc_va_cong_thuc_ham\" title=\"C\u1ea5u tr\u00fac v\u00e0 c\u00f4ng th\u1ee9c h\u00e0m\">C\u1ea5u tr\u00fac v\u00e0 c\u00f4ng th\u1ee9c h\u00e0m<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html#So_do_hoat_dong\" title=\"S\u01a1 \u0111\u1ed3 ho\u1ea1t \u0111\u1ed9ng\">S\u01a1 \u0111\u1ed3 ho\u1ea1t \u0111\u1ed9ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html#Vi_du_ve_ham_vlookup\" title=\"V\u00ed d\u1ee5 v\u1ec1 h\u00e0m vlookup\">V\u00ed d\u1ee5 v\u1ec1 h\u00e0m vlookup<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html#Ket_hop_VLOOKUP_voi_mot_so_ham_co_ban\" title=\"K\u1ebft h\u1ee3p VLOOKUP v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n\">K\u1ebft h\u1ee3p VLOOKUP v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_va_cong_thuc_ham\"><\/span>C\u1ea5u tr\u00fac v\u00e0 c\u00f4ng th\u1ee9c h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m VLOOKUP \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3\u00a0<strong>tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb<\/strong> <strong>n\u1eb1m c\u00f9ng d\u00f2ng<\/strong> <strong>trong c\u1ed9t t\u01b0\u01a1ng \u1ee9ng\u00a0<\/strong>d\u1ef1a theo\u00a0<strong>gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/strong> trong b\u1ea3ng.<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=VLOOKUP(lookup_value, table_array, column_index_num, [range_lookup])<\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>lookup_value\u00a0<\/strong>l\u00e0 gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm. Lookup value ph\u1ea3i n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i c\u1ee7a b\u1eb3ng t\u00ecm ki\u1ebfm v\u00e0 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1 ho\u1eb7c m\u1ed9t tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb n\u1eb1m trong \u00f4 kh\u00e1c.<\/p>\n<p><strong>table_array<\/strong> l\u00e0 m\u1ed9t b\u1ea3ng bao g\u1ed3m c\u00e1c k\u00ed t\u1ef1 ch\u1eef c\u00e1i ho\u1eb7c gi\u00e1 tr\u1ecb logic n\u01a1i t\u1eadp h\u1ee3p th\u00f4ng tin t\u00ecm ki\u1ebfm. L\u01b0u \u00fd:\u00a0<strong>Lu\u00f4n kh\u00f3a b\u1ea3ng b\u1eb1ng d\u1ea5u \u201c$\u201d \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p d\u1ecbch chuy\u1ec3n kh\u00f4ng gian t\u00ecm ki\u1ebfm d\u1eabn \u0111\u1ebfn l\u1ed7i #N\/A<\/strong><\/p>\n<p><strong>col_index_num<\/strong>\u00a0l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong <strong>table_array<\/strong> n\u01a1i ch\u1ee9a <strong>gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm<\/strong>. C\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng l\u00e0 c\u1ed9t 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\/2025\/01\/ex101_92019-nho-115.gif\" title=\"ex101_92019-nho-115\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>range_lookup<\/strong> l\u00e0 gi\u00e1 tr\u1ecb logic t\u00ecm ki\u1ebfm. \u0110\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i, nh\u1eadp\u00a0<strong>FALSE\u00a0<\/strong>ho\u1eb7c 0; \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t, nh\u1eadp\u00a0<strong>TRUE<\/strong> ho\u1eb7c 1. Nh\u1edb l\u00e0 khi t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm ph\u1ea3i\u00a0<strong>s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn<\/strong> nh\u00e9!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_do_hoat_dong\"><\/span>S\u01a1 \u0111\u1ed3 ho\u1ea1t \u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 s\u01a1 \u0111\u1ed3 ho\u1ea1t \u0111\u1ed9ng c\u1ee7a\u00a0<strong>VLOOKUP:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-so-do.png\" width=\"621\" height=\"391\" title=\"vlookup-so-do\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_ve_ham_vlookup\"><\/span>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m vlookup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e3y c\u00f9ng xem hai v\u00ed d\u1ee5 v\u1edbi t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 t\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i:<\/p>\n<p>1.T\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i<\/p>\n<figure id=\"attachment_22286\" aria-describedby=\"caption-attachment-22286\" style=\"width: 617px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22286\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-vi-du-1.png\" width=\"617\" height=\"429\" title=\"vlookup-vi-du-1\"><figcaption id=\"caption-attachment-22286\" class=\"wp-caption-text\">T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c tu\u1ed5i theo t\u00ean<\/figcaption><\/figure>\n<p>2.T\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i<\/p>\n<figure id=\"attachment_22287\" aria-describedby=\"caption-attachment-22287\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-22287\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-vi-du-2-1024x294-1.png\" width=\"1024\" height=\"294\" title=\"vlookup-vi-du-2-1024x294-1\"><figcaption id=\"caption-attachment-22287\" class=\"wp-caption-text\">T\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i gi\u00e1 v\u00e9 theo kho\u1ea3ng \u0111\u1ed9 tu\u1ed5i<\/figcaption><\/figure>\n<p>Ch\u1eafc h\u1eb3n nhi\u1ec1u b\u1ea1n \u0111ang th\u1eafc m\u1eafc s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i ph\u1ea3i kh\u00f4ng? H\u00e3y nh\u00ecn hai v\u00ed d\u1ee5 tr\u00ean, n\u1ebfu \u0111\u1ed5i\u00a0<strong>range_lookup<\/strong> s\u1ebd nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ta s\u1ebd \u0111\u1ed5i t\u1eeb t\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i sang t\u01b0\u01a1ng \u0111\u1ed1i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22288\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-1-vi-du-1.png\" width=\"618\" height=\"424\" title=\"vlookup-1-vi-du-1\"><\/p>\n<p>C\u00e2u h\u1ecfi l\u00e0 t\u1ea1i sao b\u1ea1n Trang l\u1ea1i 19 tu\u1ed5i, trong khi k\u1ebft qu\u1ea3 \u0111\u00fang l\u00e0 17? B\u1edfi khi t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i, Excel s\u1ebd hi\u1ec3u theo m\u1ed9t logic: t\u00ecm t\u1eadp h\u1ee3p ch\u1eef c\u00e1i\u00a0theo th\u1ee9 t\u1ef1\u00a0<strong>t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi<\/strong>, l\u1ea5y ra gi\u00e1 tr\u1ecb\u00a0<strong>gi\u1ed1ng nh\u1ea5t<\/strong> v\u00e0\u00a0<strong>g\u1ea7n nh\u1ea5t<\/strong>, sau \u0111\u00f3 tham chi\u1ebfu sang c\u1ed9t th\u1ee9 3 v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3. \u1ede \u0111\u00e2y, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u00e0 Excel t\u00ecm th\u1ea5y l\u00e0\u00a0<strong>Tr\u1ea7n.<\/strong><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi v\u00ed d\u1ee5 th\u1ee9 hai, ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-22289\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-2-vi-du-2-1024x284-1.png\" width=\"1024\" height=\"284\" title=\"vlookup-2-vi-du-2-1024x284-1\"><\/p>\n<p>V\u1edbi vi\u1ec7c thay \u0111\u1ed5i\u00a0<strong>range_lookup<\/strong> v\u1ec1 t\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i, Excel s\u1ebd ch\u1ec9 tr\u1ea3 v\u1ec1 nh\u1eefng k\u1ebft q\u1ee7a c\u00f3 tham chi\u1ebfu <strong>ho\u00e0n to\u00e0n<\/strong>\u00a0<strong>ch\u00ednh x\u00e1c.\u00a0<\/strong>B\u1edfi v\u1eady b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y ngo\u00e0i gi\u00e1 tr\u1ecb <strong>19<\/strong> tr\u00f9ng kh\u1edbp, c\u00e1c gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 l\u00e0 <strong>#N\/A\u00a0do kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_VLOOKUP_voi_mot_so_ham_co_ban\"><\/span><strong>K\u1ebft h\u1ee3p VLOOKUP v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1.VLOOKUP k\u1ebft h\u1ee3p IF<\/p>\n<p>\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 tr\u00ean, trong tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng kh\u00f4ng xu\u1ea5t hi\u1ec7n trong b\u1ea3ng t\u00ecm ki\u1ebfm, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VLOOKUP v\u1edbi IF v\u00e0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\">h\u00e0m ki\u1ec3m tra l\u1ed7i<\/a>\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22948\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-vi-du-3.png\" width=\"785\" height=\"426\" title=\"vlookup-vi-du-3\"><\/p>\n<p>\u0110\u1ea7u ti\u00ean, ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MATCH \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a \u00f4 A9 trong d\u00e3y A2:A7. B\u1edfi gi\u00e1 tr\u1ecb \u201cQuang\u201d kh\u00f4ng thu\u1ed9c v\u00f9ng n\u00e0y, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 #N\/A. Sau \u0111\u00f3, s\u1eed d\u1ee5ng\u00a0<strong>IFERROR<\/strong> ho\u1eb7c\u00a0<strong>IF\u00a0<\/strong>k\u1ebft h\u1ee3p\u00a0<strong>ISERROR\u00a0<\/strong>\u0111\u1ec3 bi\u1ec7n lu\u1eadn.<\/p>\n<p>2.VLOOKUP k\u1ebft h\u1ee3p MATCH<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-match-trong-excel.html\">H\u00e0m MATCH tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb b\u1ea5t k\u1ef3 trong t\u1eadp h\u1ee3p.<\/a>\u00a0Khi k\u1ebft h\u1ee3p v\u1edbi VLOOKUP, ta s\u1ebd s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00ecm ki\u1ebfm s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t v\u00e0 \u0111i\u1ec1n v\u00e0o\u00a0<strong>col_index_num<\/strong>. C\u1ee5 th\u1ec3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22292\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-vi-du-4.png\" width=\"845\" height=\"422\" title=\"vlookup-vi-du-4\"><\/p>\n<p>B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>MATCH<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ed9t mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u \u1edf \u0111\u00e2u. Ch\u1ec9 c\u1ea7n th\u00eam m\u1ed9t tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi, s\u1eed d\u1ee5ng MATCH v\u00e0o \u0111\u00f3, ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch t\u00ecm ki\u1ebfm m\u00e0 kh\u00f4ng lo thao t\u00e1c l\u1ea1i m\u1ed7i khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u01a1 b\u1ea3n khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m VLOOKUP. Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a>!<\/strong><\/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\/2025\/01\/ex101_92019-nho-115.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9963","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\/9963","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=9963"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9964"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}