{"id":7098,"date":"2024-12-21T16:53:06","date_gmt":"2024-12-21T16:53:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu\/"},"modified":"2024-12-21T16:53:06","modified_gmt":"2024-12-21T16:53:06","slug":"ham-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu\/","title":{"rendered":"H\u00e0m VLOOKUP n\u00e2ng cao, l\u1ed3ng vlookup v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed, tra c\u1ee9u hai chi\u1ec1u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c Vlookup n\u00e2ng cao, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLookup l\u1ed3ng c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ecm ki\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, c\u00e1ch tra c\u1ee9u hai chi\u1ec1u v\u1edbi h\u00e0m VLOOKUP. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u 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-6766f27161703\" 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\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Excel_Vlookup_voi_nhieu_tieu_chi\" title=\"Excel Vlookup v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:\">Excel Vlookup v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Vi_du_1_Tra_cuu_2_tieu_chi_khac_nhau\" title=\"V\u00ed d\u1ee5 1. Tra c\u1ee9u 2 ti\u00eau ch\u00ed kh\u00e1c nhau\">V\u00ed d\u1ee5 1. Tra c\u1ee9u 2 ti\u00eau ch\u00ed kh\u00e1c nhau<\/a><\/li>\n<\/ul>\n<\/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\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Lam_the_nao_su_dung_VLOOKUP_de_lay_2_3_4_vv_gia_tri_phu_hop\" title=\"L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 l\u1ea5y 2, 3, 4,..\u00a0vv gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p:\">L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 l\u1ea5y 2, 3, 4,..\u00a0vv gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p:<\/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\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Lam_the_nao_de_co_duoc_tat_ca_cac_gia_tri_trung_lap_trong_pham_vi_tra_cuu\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong ph\u1ea1m vi tra c\u1ee9u\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong ph\u1ea1m vi tra c\u1ee9u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Lam_the_nao_de_lam_tra_cuu_hai_chieu_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m tra c\u1ee9u hai chi\u1ec1u trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m tra c\u1ee9u hai chi\u1ec1u trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Ham_VLOOKUP_MATCH\" title=\"H\u00e0m VLOOKUP &amp; MATCH\">H\u00e0m VLOOKUP &amp; MATCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Ham_SUMPRODUCT\" title=\"H\u00e0m SUMPRODUCT\">H\u00e0m SUMPRODUCT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Cac_dai_duoc_dat_ten_SPACE_toan_tu_giao_nhau\" title=\"C\u00e1c d\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean &amp; SPACE (to\u00e1n t\u1eed giao nhau)\">C\u00e1c d\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean &amp; SPACE (to\u00e1n t\u1eed giao nhau)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Lam_the_nao_de_lam_nhieu_Vlookups_trong_mot_cong_thuc_Vlookup_long_nhau\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m nhi\u1ec1u Vlookups trong m\u1ed9t c\u00f4ng th\u1ee9c (Vlookup l\u1ed3ng nhau)\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m nhi\u1ec1u Vlookups trong m\u1ed9t c\u00f4ng th\u1ee9c (Vlookup 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-10\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Ham_VLOOKUP_nang_cao_tra_cuu_tra_ve_nhieu_gia_tri\" title=\"H\u00e0m VLOOKUP n\u00e2ng cao, tra c\u1ee9u tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb\">H\u00e0m VLOOKUP n\u00e2ng cao, tra c\u1ee9u tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#Su_dung_VLOOKUP_va_INDIRECT_de_tu_dong_keo_du_lieu_tu_cac_trang_tinh_khac_nhau\" title=\"S\u1eed d\u1ee5ng VLOOKUP v\u00e0 INDIRECT \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng k\u00e9o d\u1eef li\u1ec7u t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau\">S\u1eed d\u1ee5ng VLOOKUP v\u00e0 INDIRECT \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng k\u00e9o d\u1eef li\u1ec7u t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html#INDIRECT_VLOOKUP_%E2%80%93_cach_hoat_dong\" title=\"INDIRECT &amp; VLOOKUP \u2013 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng\">INDIRECT &amp; VLOOKUP \u2013 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Vlookup_voi_nhieu_tieu_chi\"><\/span><strong>Excel <\/strong><strong>V<\/strong><strong>lookup v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><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<\/a><\/strong> th\u1ef1c s\u1ef1 h\u1eefu \u00edch khi t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh tr\u00ean m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u.\u00a0Tuy nhi\u00ean, n\u00f3 c\u00f3 \u0111i\u1ec3m h\u1ea1n ch\u1ebf l\u1edbn \u2013 c\u00fa ph\u00e1p c\u1ee7a n\u00f3 ch\u1ec9 cho ph\u00e9p tra c\u1ee9u m\u1ed9t gi\u00e1 tr\u1ecb.\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec sao?\u00a0Ta c\u00f3 gi\u1ea3i ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Tra_cuu_2_tieu_chi_khac_nhau\"><\/span><strong>V\u00ed d\u1ee5 1. Tra c\u1ee9u 2 ti\u00eau ch\u00ed kh\u00e1c nhau<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm Qty (S\u1ed1 l\u01b0\u1ee3ng) d\u1ef1a tr\u00ean 2 ti\u00eau ch\u00ed \u2013 \u201cName\u201d v\u00e0 \u201cProduct\u201d.\u00a0 Ph\u1ee9c t\u1ea1p \u1edf ch\u1ed7 l\u00e0 m\u1ed7i kh\u00e1ch h\u00e0ng \u0111\u1eb7t h\u00e0ng nhi\u1ec1u s\u1ea3n ph\u1ea9m, nh\u01b0 b\u1ea1n th\u1ea5y trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Look up with 2 criteria in the same worksheet\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-data-multiple-criteria.png\" alt=\"Look up with 2 criteria in the same worksheet\"><\/p>\n<p>M\u1ed9t c\u00f4ng th\u1ee9c VLOOKUP th\u00f4ng th\u01b0\u1eddng s\u1ebd kh\u00f4ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1edfi n\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean ph\u00f9 h\u1ee3p v\u1edbi gi\u00e1 tr\u1ecb tra c\u1ee9u m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.\u00a0V\u00ec v\u1eady, n\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 l\u01b0\u1ee3ng \u201cSweets\u201d \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp b\u1edfi \u201cJeremy Hill\u201d v\u00e0 vi\u1ebft c\u00f4ng th\u1ee9c\u00a0<strong>=VLOOKUP(B1,$A$5:$C$14,3,FALSE)<\/strong>, k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean t\u00ecm th\u1ea5y tr\u1ea3 v\u1ec1 l\u00e0 \u201c15\u201d t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u201cApples\u201d.<\/p>\n<p>Gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n l\u00e0 t\u1ea1o m\u1ed9t c\u1ed9t b\u1ed5 sung n\u1ed1i t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed m\u00e0 b\u1ea1n mu\u1ed1n, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 c\u00e1c\u00a0c\u1ed9t\u00a0<em>Customer<\/em>\u00a0v\u00e0\u00a0<em>Product<\/em>\u00a0.\u00a0H\u00e3y nh\u1edb r\u1eb1ng c\u1ed9t li\u00ean k\u1ebft lu\u00f4n lu\u00f4n l\u00e0 c\u1ed9t\u00a0<strong>ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i <\/strong>trong ph\u1ea1m vi tra c\u1ee9u c\u1ee7a b\u1ea1n v\u00ec \u0111\u00e2y l\u00e0 n\u01a1i m\u00e0 VLOOKUP lu\u00f4n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb tra c\u1ee9u.<\/p>\n<p>V\u00ec v\u1eady, b\u1ea1n th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0o b\u1ea3ng c\u1ee7a b\u1ea1n v\u00e0 sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 th\u1ebf n\u00e0y\u00a0<strong>=B2&amp;C2 <\/strong>qua c\u1ed9t \u0111\u00f3 (ho\u1eb7c\u00a0<strong>=B2&amp;\u201d \u201c&amp;C2 <\/strong>n\u1ebfu b\u1ea1n mu\u1ed1n t\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c n\u1ed1i b\u1eb1ng kho\u1ea3ng tr\u1eafng \u0111\u1ec3 l\u00e0m cho d\u1eef li\u1ec7u d\u1ec5 \u0111\u1ecdc h\u01a1n).<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-284.gif\" title=\"vba101_92019-nho-284\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-639.gif\" title=\"ex101_92019-nho-639\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u00e0 sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c VLOOKUP \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP(\u201cJeremy Hill Sweets\u201d,$A$5:$C$14,3,FALSE)<\/strong><\/p>\n<p>ho\u1eb7c l\u00e0<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP(B1,$A$5:$C$14,3,FALSE)<\/strong><\/p>\n<p>Trong \u0111\u00f3 B1 ch\u1ee9a\u00a0<strong>gi\u00e1 tr\u1ecb tra c\u1ee9u <\/strong>(<em>lookup_value<\/em>) v\u00e0 3 l\u00e0 s\u1ed1 c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm (<em>col_index_num<\/em>).<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"VLOOKUP formula to search by 2 criteria in the same worksheet\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-formula-multiple-criteria.png\" alt=\"VLOOKUP formula to search by 2 criteria in the same worksheet\"><\/p>\n<blockquote>\n<p><strong>Xem th\u00eam<\/strong>: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc excel v\u0103n ph\u00f2ng<span data-sheets-value='{\"1\":2,\"2\":\"h\u1ecdc excel v\u0103n ph\u00f2ng\"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'>\u00a0v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n m\u00e0 hi\u1ec7u qu\u1ea3<\/span><\/a><\/p>\n<\/blockquote>\n<p><strong>V\u00ed d\u1ee5 2. Vlookup v\u1edbi 2 ti\u00eau ch\u00ed t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i c\u1eadp nh\u1eadt b\u1ea3ng ch\u00ednh v\u1edbi d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng kh\u00e1c (b\u1ea3ng ho\u1eb7c trang t\u00ednh kh\u00e1c), th\u00ec b\u1ea1n c\u00f3 th\u1ec3 n\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb tra c\u1ee9u tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n nh\u1eadp v\u00e0o b\u1ea3ng ch\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p>Gi\u1ed1ng v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n c\u1ea7n th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0o b\u1ea3ng tra c\u1ee9u v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb tra c\u1ee9u k\u1ebft n\u1ed1i v\u00e0 n\u00ean t\u1ea1o \u1edf v\u1ecb tr\u00ed ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a d\u00e3y t\u00ecm ki\u1ebfm.<\/p>\n<p>V\u00ec v\u1eady, c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP(B2&amp;\u201d \u201c&amp;C2,Orders!$A&amp;$2:$B$2,4,FALSE)<\/strong>.<\/p>\n<p>Trong \u0111\u00f3 c\u00e1c c\u1ed9t B v\u00e0 C ch\u1ee9a t\u00ean customer v\u00e0 product t\u01b0\u01a1ng \u1ee9ng v\u00e0 <strong>Orders!$A&amp;$2: $B$2<\/strong> l\u00e0 b\u1ea3ng tra c\u1ee9u c\u1ee7a b\u1ea1n trong m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c d\u1ec5 \u0111\u1ecdc h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean cho b\u1ea3ng tra c\u1ee9u, v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n :<strong>=VLOOKUP(B2&amp;\u201d \u201c&amp;C2,Orders,4,FALSE)<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/4-8.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7645\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-8.bmp\" width=\"600\" height=\"334\" title=\"4-8\"><\/a><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>\u0110\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng, c\u1ed9t b\u00ean tr\u00e1i nh\u1ea5t c\u1ee7a b\u1ea3ng tra c\u1ee9u c\u1ee7a b\u1ea1n ph\u1ea3i ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb tra c\u1ee9u gh\u00e9p n\u1ed1i ch\u00ednh x\u00e1c nh\u01b0 trong ti\u00eau ch\u00ed tra c\u1ee9u c\u1ee7a b\u1ea1n.\u00a0Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh tr\u00ean, ch\u00fang ta gh\u00e9p c\u00e1c gi\u00e1 tr\u1ecb b\u1eb1ng m\u1ed9t kho\u1ea3ng tr\u1eafng trong b\u1ea3ng tra c\u1ee9u, v\u00ec v\u1eady ch\u00fang ta ph\u1ea3i l\u00e0m t\u01b0\u01a1ng t\u1ef1 trong c\u00e1c ti\u00eau ch\u00ed tra c\u1ee9u c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP (B2 &amp; \u201c\u201d &amp; C2).<\/p>\n<p>Ngo\u00e0i ra, h\u00e3y nh\u1edb VLOOKUP gi\u1edbi h\u1ea1n trong\u00a0<strong>255 k\u00fd t\u1ef1<\/strong>\u00a0.\u00a0H\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb tra c\u1ee9u c\u00f3 ch\u1ee9a h\u01a1n 255 k\u00fd t\u1ef1.\u00a0V\u00ec v\u1eady, h\u00e3y nh\u1edb \u0111i\u1ec1u n\u00e0y v\u00e0 \u0111\u1ea3m b\u1ea3o t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a ti\u00eau ch\u00ed tra c\u1ee9u c\u1ee7a b\u1ea1n kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_su_dung_VLOOKUP_de_lay_2_3_4_vv_gia_tri_phu_hop\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 l\u1ea5y 2, 3, 4,..\u00a0vv gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Vlookup ch\u1ec9 c\u00f3 th\u1ec3 l\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p, ch\u00ednh x\u00e1c h\u01a1n, l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y.\u00a0Th\u1ebf n\u1ebfu c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb tra c\u1ee9u v\u00e0 b\u1ea1n mu\u1ed1n\u00a0 xu\u1ea5t hi\u1ec7n hai ba l\u1ea7n? Ho\u1eb7c nhi\u1ec1u h\u01a1n n\u1eefa, n\u1ebfu b\u1ea1n mu\u1ed1n k\u00e9o t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p?\u00a0Nghe c\u00f3 v\u1ebb ph\u1ee9c t\u1ea1p, nh\u01b0ng v\u1eabn c\u00f3 c\u00e1ch th\u1ef1c hi\u1ec7n.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 t\u00ean kh\u00e1ch h\u00e0ng trong m\u1ed9t c\u1ed9t v\u00e0 c\u00e1c s\u1ea3n ph\u1ea9m h\u1ecd mua \u1edf m\u1ed9t c\u1ed9t kh\u00e1c.\u00a0V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n mu\u1ed1n t\u00ecm s\u1ea3n th\u1ee9 2 th\u1ee9 3\u00a0ho\u1eb7c th\u1ee9 4 do c\u00f9ng m\u1ed9t kh\u00e1ch h\u00e0ng mua.<\/p>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 th\u00eam c\u1ed9t ph\u1ee5 tr\u01b0\u1edbc c\u1ed9t Customer Names v\u00e0 \u0111i\u1ec1n t\u00ean v\u00e0 th\u00eam s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0o, v\u00ed d\u1ee5 nh\u01b0 \u201cJohn Doe1\u201d, \u201cJohn Doe2\u201d vv <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\">C\u00f4ng\u00a0th\u1ee9c\u00a0COUNTIF<\/a>\u00a0d\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u00e1nh nh\u1ecf \u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y (gi\u1ea3 s\u1eed t\u00ean kh\u00e1ch h\u00e0ng N\u1eb1m trong c\u1ed9t B):<\/p>\n<p><strong>=B2&amp;COUNTIF($B$2:B2,B2)<\/strong><br \/>\n<img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The COUNTIF formula to add the occurrence number to the customer's name.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/name-occurrence.png\" alt=\"The COUNTIF formula to add the occurrence number to the customer's name.\"><\/p>\n<p>Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c VLOOKUP th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 t\u00ecm th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng.\u00a0V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>T\u00ecm\u00a0s\u1ea3n ph\u1ea9m th\u1ee9 hai\u00a0do Dan Brown mua:<\/li>\n<\/ul>\n<p><strong>=VLOOKUP(\u201cDan Brown2\u201d,$A$2:$C$16,3,FALSE)<\/strong><\/p>\n<ul>\n<li>T\u00ecm\u00a0s\u1ea3n ph\u1ea9m th\u1ee9 ba Dan Brown mua:<\/li>\n<\/ul>\n<p><strong>=VLOOKUP(\u201cDan Brown3\u201d,$A$2:$C$16,3,FALSE)<\/strong><\/p>\n<p>\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u1ed9t tham chi\u1ebfu \u00f4 thay v\u00ec v\u0103n b\u1ea3n trong gi\u00e1 tr\u1ecb tra c\u1ee9u, nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"The VLOOKUP formula to find the corresponding order\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-second-occurrence.png\" alt=\"The VLOOKUP formula to find the corresponding order\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm\u00a0l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 2\u00a0, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o c\u1ed9t ph\u1ee5 b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c VLOOKUP ph\u1ee9c t\u1ea1p h\u01a1n:<\/p>\n<p><strong>=IFERROR(VLOOKUP($F$2,INDIRECT(\u201c$B$\u201d&amp;(MATCH($F$2,Table4[Customer Name],0)+2)&amp;\u201d:$C16\u2033),2,FALSE),\u201d\u201d)<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li>$F$2 \u2013 \u00f4 v\u1edbi t\u00ean kh\u00e1ch h\u00e0ng (l\u00e0 h\u1eb1ng s\u1ed1, l\u01b0u \u00fd c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i);<\/li>\n<li>$B$ \u2013 c\u1ed9t \u201cCustomer Names\u201d;<\/li>\n<li>Table 4 [Customer Name] \u2013 tra c\u1ee9u c\u1ed9t trong b\u1ea3ng ho\u1eb7c m\u1ed9t ph\u1ea1m vi tra c\u1ee9u;<\/li>\n<li>$C16 \u2013 \u00f4 cu\u1ed1i c\u00f9ng (d\u01b0\u1edbi c\u00f9ng b\u00ean tr\u00e1i) trong b\u1ea3ng tra c\u1ee9u c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<p>Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\">Ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c trong Excel<\/a><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>C\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 t\u00ecm th\u1ea5y\u00a0<strong>gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p th\u1ee9 hai<\/strong>.\u00a0N\u1ebfu b\u1ea1n c\u1ea7n c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n kh\u00e1c, h\u00e3y quay l\u1ea1i v\u1edbi gi\u1ea3i ph\u00e1p tr\u01b0\u1edbc.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/12-1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7646\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-1.bmp\" width=\"600\" height=\"221\" title=\"12-1\"><\/a><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 \u0111\u01b0\u1ee3c danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p, h\u00e0m VLOOKUP kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c, b\u1edfi v\u00ec n\u00f3 ch\u1ec9 c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i m\u1ed9t gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m.\u00a0Nh\u01b0ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-index-va-ham-match-trong-excel-su-thay-tot-hon-ca-ham-vlookup.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDEX<\/a> c\u1ee7a Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd tr\u01b0\u1eddng h\u1ee3p n\u00e0y v\u00e0 t\u00f4i s\u1ebd cho b\u1ea1n th\u1ea5y c\u00f4ng th\u1ee9c trong v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_duoc_tat_ca_cac_gia_tri_trung_lap_trong_pham_vi_tra_cuu\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong ph\u1ea1m vi tra c\u1ee9u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m VLOOKUP<\/a> kh\u00f4ng th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c b\u1ea3n sao tr\u00f9ng l\u1eb7p c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u.\u00a0\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng ph\u1ee9c t\u1ea1p h\u01a1n bao g\u1ed3m nhi\u1ec1u h\u00e0m Excel nh\u01b0 INDEX, SMALL v\u00e0 ROW.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-large-va-ham-small-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Large v\u00e0 h\u00e0m Small trong Excel 2007, 2010, 2013, 2016, 2019<\/a><\/p>\n<p>V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y t\u00ecm t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ee7a gi\u00e1 tr\u1ecb trong \u00f4 F2 trong ph\u1ea1m vi tra c\u1ee9u B2: B16, v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t C trong c\u00e1c h\u00e0ng t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p><strong>{=IFERROR(INDEX($C$2:$C$16, SMALL(IF($F$2=B2:B16, ROW(C2:C16)-1,\u201d\u201d), ROW()-3)),\u201d\u201d)}<\/strong><\/p>\n<p>Sao ch\u00e9p c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y v\u00e0o m\u1ed9t s\u1ed1 \u00f4 l\u00e2n c\u1eadn, v\u00ed d\u1ee5: c\u00e1c \u00f4 F4:F8 nh\u01b0 th\u1ec3 hi\u1ec7n trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.\u00a0S\u1ed1 l\u01b0\u1ee3ng \u00f4 m\u00e0 b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n s\u1ed1 m\u1ee5c tr\u00f9ng l\u1eb7p t\u1ed1i \u0111a.\u00a0Ngo\u00e0i ra, nh\u1edb nh\u1ea5n\u00a0<strong><em>Ctrl + Shift + Enter<\/em><\/strong>\u00a0\u0111\u1ec3 nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Getting all duplicate occurrences of the lookup value\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-duplicates.png\" alt=\"Getting all duplicate occurrences of the lookup value\"><\/p>\n<p>N\u1ebfu b\u1ea1n t\u00f2 m\u00f2 mu\u1ed1n bi\u1ebft logic c\u1ee7a c\u00f4ng th\u1ee9c, ch\u00fang ta h\u00e3y \u0111i t\u00ecm hi\u1ec3u s\u00e2u m\u1ed9t ch\u00fat:<\/p>\n<p><strong>Ph\u1ea7n 1<\/strong>\u00a0.<strong>IF($F$2=B2:B16,ROW(C2:C16)-1,\u201d\u201d)<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>$F$2=B2:B16<\/strong>\u2013 so s\u00e1nh gi\u00e1 tr\u1ecb trong \u00f4 F2 v\u1edbi m\u1ed7i gi\u00e1 tr\u1ecb trong d\u1ea3i B2: B16.\u00a0N\u1ebfu t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p,\u00a0<strong>ROW(C2:C16)-1 <\/strong>tr\u1ea3 l\u1ea1i s\u1ed1 c\u1ee7a h\u00e0ng t\u01b0\u01a1ng \u1ee9ng (-1 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 kh\u1ea5u tr\u1eeb d\u00f2ng ti\u00eau \u0111\u1ec1).\u00a0N\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb so s\u00e1nh kh\u00f4ng kh\u1edbp, h\u00e0m IF tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng.<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF l\u00e0 m\u1ea3ng sau \u0111\u00e2y: \u00a0{1, \u201c\u201d, 3, \u201c\u201d, 5, \u201c\u201d, \u201c\u201d, \u201c\u201d, \u201c\u201d, \u201c\u201d, \u201c\u201d,12, \u201c\u201d, \u201c\u201d, \u201c\u201d}<\/p>\n<p><strong>Ph\u1ea7n 2<\/strong>\u00a0.<strong>ROW()-3<\/strong><\/p>\n<p style=\"padding-left: 30px\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e0m ROW ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t b\u1ed9 \u0111\u1ebfm th\u00eam.\u00a0V\u00ec c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o \u00f4 F4: F9, ta th\u00eam -3 cho h\u00e0m tr\u1ea3 1 cho \u00f4 F4 (h\u00e0ng 4 tr\u1eeb 3), 2 cho \u00f4 F5 (h\u00e0ng 5 tr\u1eeb 3), vv<\/p>\n<p><strong>Ph\u1ea7n 3<\/strong>\u00a0.<strong>SMALL(IF($F$2=$B$2:$B$16,ROW($C$2:$C$16)-1,\u201d\u201d),ROW()-3))<\/strong><\/p>\n<p style=\"padding-left: 30px\">H\u00e0m SMALL tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t th\u1ee9 k trong m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a n\u00e0y, v\u1ecb tr\u00ed (t\u1eeb nh\u1ecf nh\u1ea5t) tr\u1edf v\u1ec1 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi h\u00e0m ROW (Ph\u1ea7n 2).\u00a0V\u00ec v\u1eady, \u0111\u1ed1i v\u1edbi \u00f4 F4, h\u00e0m SMALL ({array}, 1) tr\u1ea3 v\u1ec1 ph\u1ea7n t\u1eed tr\u01b0\u1edbc ti\u00ean (nh\u1ecf nh\u1ea5t) c\u1ee7a m\u1ea3ng, t\u1ee9c l\u00e0 1. \u0110\u1ed1i v\u1edbi \u00f4 F5, n\u00f3 tr\u1ea3 v\u1ec1 ph\u1ea7n t\u1eed nh\u1ecf th\u1ee9 2 c\u1ee7a m\u1ea3ng, l\u00e0 3, tr\u00ean.<\/p>\n<p><strong>Ph\u1ea7n 4<\/strong>\u00a0.<strong>INDEX($C$2:$C$16, SMALL(IF($F$2=$B$2:$B$16, ROW($C$2:$C$16)-1,\u201d\u201d), ROW()-3))<\/strong><\/p>\n<p style=\"padding-left: 30px\">H\u00e0m INDEX ch\u1ec9 \u0111\u01a1n gi\u1ea3n tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 x\u00e1c \u0111\u1ecbnh trong m\u1ea3ng C2: C16.\u00a0\u0110\u1ed1i v\u1edbi \u00f4 F4,\u00a0<strong>INDEX($C$2:$C$16,1) <\/strong>tr\u1ea3 v\u1ec1 \u201cApples\u201d;\u00a0Cho t\u1ebf b\u00e0o F5,\u00a0<strong>INDEX($C$2:$C$16,3) <\/strong>tr\u1ea3 v\u1ec1 \u201cSweets\u201d, v.v.<\/p>\n<p><strong>Ph\u1ea7n 5<\/strong>\u00a0.<strong>IFERROR()<\/strong><\/p>\n<p style=\"padding-left: 30px\">Cu\u1ed1i c\u00f9ng, ch\u00fang ta l\u1ed3ng c\u00f4ng th\u1ee9c trong h\u00e0m IFERROR b\u1edfi v\u00ec ch\u1eafc b\u1ea1n kh\u00f4ng mu\u1ed1n th\u1ea5y th\u00f4ng b\u00e1o N \/ A trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, khi s\u1ed1 \u00f4 m\u00e0 b\u1ea1n \u0111\u00e3 sao ch\u00e9p c\u00f4ng th\u1ee9c l\u1edbn h\u01a1n s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u00f9ng l\u1eb7p c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_tra_cuu_hai_chieu_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m tra c\u1ee9u hai chi\u1ec1u trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>T\u00ecm ki\u1ebfm 2 chi\u1ec1u<\/strong>\u00a0trong Excel (c\u00f2n g\u1ecdi l\u00e0\u00a0<strong>tra c\u1ee9u ma tr\u1eadn<\/strong>\u00a0ho\u1eb7c\u00a0<strong>tra c\u1ee9u\u00a0hai chi\u1ec1u<\/strong>) t\u00ecm ki\u1ebfm tr\u00ean c\u1ea3\u00a0<strong>h\u00e0ng v\u00e0 c\u1ed9t<\/strong>\u00a0.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb t\u1ea1i giao \u0111i\u1ec3m c\u1ee7a m\u1ed9t h\u00e0ng v\u00e0 c\u1ed9t nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>V\u00ec v\u1eady, h\u00e3y s\u1eed d\u1ee5ng b\u1ea3ng \u201cMonthly Sales\u201d m\u1ed9t l\u1ea7n n\u1eefa v\u00e0 vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP t\u00ecm xem bao nhi\u00eau lemons \u0111\u01b0\u1ee3c b\u00e1n v\u00e0o th\u00e1ng 3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/11-1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7647\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-1.bmp\" width=\"600\" height=\"196\" title=\"11-1\"><\/a><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u hai chi\u1ec1u b\u1eb1ng m\u1ed9t v\u00e0i c\u00e1ch kh\u00e1c nhau.\u00a0V\u00ec v\u1eady, h\u00e3y xem qua c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_MATCH\"><\/span><strong>H\u00e0m VLOOKUP &amp; MATCH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng li\u00ean k\u1ebft c\u1ee7a c\u00e1c h\u00e0m VLOOKUP v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html\">MATCH<\/a> \u0111\u1ec3 tham chi\u1ebfu ch\u00e9o hai tr\u01b0\u1eddng trong c\u01a1 s\u1edf d\u1eef li\u1ec7u, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0\u00a0<em>Product<\/em>\u00a0(h\u00e0ng) v\u00e0\u00a0<em>Month<\/em>\u00a0(c\u1ed9t):<\/p>\n<p><strong>=VLOOKUP(\u201cLemons\u201d,$A$2:$I$9,MATCH(\u201cMar\u201d,$A$1:$I$1,0),FALSE)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf tr\u00ean l\u00e0 m\u1ed9t h\u00e0m Vlookup th\u00f4ng th\u01b0\u1eddng t\u00ecm ki\u1ebfm k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c c\u1ee7a \u201cLemons\u201d trong c\u00e1c \u00f4 t\u1eeb A2 \u0111\u1ebfn I9.\u00a0Tuy nhi\u00ean, v\u00ec b\u1ea1n kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c c\u1ed9t b\u00e1n h\u00e0ng c\u1ee7a th\u00e1ng ba (Mar), b\u1ea1n kh\u00f4ng th\u1ec3 cung c\u1ea5p s\u1ed1 c\u1ed9t trong tham s\u1ed1 th\u1ee9 ba c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n.\u00a0Thay v\u00e0o \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng MATCH \u0111\u1ec3 t\u00ecm c\u1ed9t \u0111\u00f3.<\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<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<\/blockquote>\n<p>H\u00e0m<strong> MATCH(\u201cMar\u201d,$A$1:$I$1,0)<\/strong> c\u00f3 ngh\u0129a l\u00e0:<\/p>\n<ul>\n<li>Tra c\u1ee9u \u201cMar\u201d (tham s\u1ed1 t\u00ecm ki\u1ebfm).<\/li>\n<li>T\u00ecm ki\u1ebfm trong \u00f4 A1 \u0111\u1ebfn I1 (m\u1ea3ng tham s\u1ed1 t\u00ecm ki\u1ebfm).<\/li>\n<li>Tr\u1ea3 l\u1ea1i k\u1ebft h\u1ee3p ch\u00ednh x\u00e1c (lo\u1ea1i tham s\u1ed1 t\u00ecm ki\u1ebfm m\u1ea3ng).\u00a0B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u201c0\u201d trong\u00a0tham s\u1ed1 th\u1ee9 3, h\u00e0m MATCH t\u00ecm gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean ch\u00ednh x\u00e1c b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb tra c\u1ee9u.\u00a0B\u1ea1n c\u00f3 th\u1ec3 coi n\u00f3 nh\u01b0 m\u1ed9t tham s\u1ed1 False\u00a0trong VLOOKUP.<\/li>\n<\/ul>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch b\u1ea1n t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tra c\u1ee9u c\u00f3 hai ti\u00eau ch\u00ed trong Excel, n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 tra c\u1ee9u hai chi\u1ec1u.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMPRODUCT\"><\/span><strong>H\u00e0m SUMPRODUCT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m SUMPRODUCT nh\u00e2n c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00e1c m\u1ea3ng nh\u1ea5t \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a ch\u00fang:<\/p>\n<p><strong>=SUMPRODUCT(($A$2:$A$9=\u201dLemons\u201d)*($A$1:$I$1=\u201dMar\u201d),$A$2:$I$9)<\/strong><\/p>\n<p>H\u00e0m INDEX &amp; MATCH<\/p>\n<p>C\u00f4ng th\u1ee9c l\u00e0:<\/p>\n<p><strong>=INDEX($A$2:$I$9, MATCH(\u201cLemons\u201d,$A$2:$A$9,0), MATCH(\u201cMar\u201d,$A$1:$I$1,0))<\/strong><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">H\u00e0m SUMPRODUCT trong Excel v\u00e0 m\u1ed9t s\u1ed1 v\u00ed v\u1ee5 c\u00f4ng th\u1ee9c<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cac_dai_duoc_dat_ten_SPACE_toan_tu_giao_nhau\"><\/span><strong>C\u00e1c d\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean &amp; SPACE (to\u00e1n t\u1eed giao nhau)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch nh\u1eefng c\u00f4ng th\u1ee9c Excel ph\u1ee9c t\u1ea1p, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch d\u1ec5 nh\u1edb n\u00e0y:<\/p>\n<p>1. Ch\u1ecdn b\u1ea3ng c\u1ee7a b\u1ea1n, chuy\u1ec3n sang\u00a0tab\u00a0<strong><em>Formulas<\/em><\/strong>\u00a0v\u00e0 nh\u1ea5p v\u00e0o\u00a0<strong>Create from Selection<\/strong>.<\/p>\n<p>2. Microsoft Excel s\u1ebd t\u1ea1o ra c\u00e1c t\u00ean t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0ng tr\u00ean c\u00f9ng v\u00e0 c\u1ed9t b\u00ean tr\u00e1i c\u1ee7a l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n, v\u00e0 b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c t\u00ean \u0111\u00f3 tr\u1ef1c ti\u1ebfp thay v\u00ec t\u1ea1o th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c .<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Creating names from the top row and left column of the selection\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-names-from-selection.png\" alt=\"Creating names from the top row and left column of the selection\"><\/p>\n<p>3. Trong b\u1ea5t k\u1ef3 \u00f4 r\u1ed7ng n\u00e0o, g\u00f5 =row_value column_value, v\u00ed d\u1ee5\u00a0<em>=Lemons\u00a0 Mar,<\/em>ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i\u00a0<em>= Mar Lemons.<\/em><\/p>\n<p>H\u00e3y nh\u1edb t\u00e1ch gi\u00e1 tr\u1ecb h\u00e0ng v\u00e0 gi\u00e1 tr\u1ecb c\u1ed9t c\u1ee7a b\u1ea1n v\u1edbi kho\u1ea3ng tr\u1eafng, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang s\u1ebd ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t\u00a0<strong>to\u00e1n t\u1eed giao nhau<\/strong>.<\/p>\n<p>Khi b\u1ea1n g\u00f5, Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t danh s\u00e1ch c\u00e1c t\u00ean ph\u00f9 h\u1ee3p, ch\u00ednh x\u00e1c nh\u01b0 khi b\u1ea1n b\u1eaft \u0111\u1ea7u g\u00f5 m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/10-1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7648\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-1.bmp\" width=\"600\" height=\"328\" title=\"10-1\"><\/a><\/p>\n<ol start=\"4\">\n<li>Nh\u1ea5n ph\u00edm\u00a0<em>Enter<\/em>v\u00e0 xem k\u1ebft qu\u1ea3.<\/li>\n<\/ol>\n<p>T\u1ea5t c\u1ea3 c\u00e1c c\u00e1ch, t\u00f9y theo ph\u01b0\u01a1ng ph\u00e1p b\u1ea1n ch\u1ecdn, k\u1ebft qu\u1ea3 tra c\u1ee9u hai chi\u1ec1u c\u0169ng s\u1ebd gi\u1ed1ng nhau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/9-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7649\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-2.bmp\" width=\"640\" height=\"282\" title=\"9-2\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_nhieu_Vlookups_trong_mot_cong_thuc_Vlookup_long_nhau\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m nhi\u1ec1u Vlookups trong m\u1ed9t c\u00f4ng th\u1ee9c (Vlookup l\u1ed3ng nhau)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00f4i khi b\u1ea3ng ch\u00ednh v\u00e0 b\u1ea3ng tra c\u1ee9u c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 m\u1ed9t c\u1ed9t chung n\u00e0o, \u0111i\u1ec1u n\u00e0y kh\u00f4ng cho b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t Vlookup b\u00ecnh th\u01b0\u1eddng.\u00a0Tuy nhi\u00ean, c\u00f3 m\u1ed9t b\u1ea3ng kh\u00e1c, kh\u00f4ng ch\u1ee9a th\u00f4ng tin b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm nh\u01b0ng c\u00f3 m\u1ed9t c\u1ed9t chung v\u1edbi b\u1ea3ng ch\u00ednh c\u1ee7a b\u1ea1n v\u00e0 m\u1ed9t chung v\u1edbi b\u1ea3ng tra c\u1ee9u c\u1ee7a b\u1ea1n.<\/p>\n<p>H\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y.\u00a0B\u1ea1n c\u00f3 b\u1ea3ng ch\u00ednh v\u1edbi m\u1ed9t c\u1ed9t \u0111\u01a1n,\u00a0<em>New SKU,<\/em>\u00a0v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i k\u00e9o gi\u00e1 t\u01b0\u01a1ng \u1ee9ng t\u1eeb m\u1ed9t b\u1ea3ng kh\u00e1c.\u00a0Ngo\u00e0i ra, b\u1ea1n c\u00f3 2 b\u1ea3ng tra c\u1ee9u \u2013 m\u00e3 \u0111\u1ea7u ti\u00ean ch\u1ee9a m\u00e3 s\u1ed1 New SKU v\u00e0 t\u00ean s\u1ea3n ph\u1ea9m t\u01b0\u01a1ng t\u1ef1, c\u00e1i th\u1ee9 hai li\u1ec7t k\u00ea t\u00ean s\u1ea3n ph\u1ea9m, gi\u00e1 c\u1ea3, nh\u01b0ng c\u00f3 M\u00e3 SKU old.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Nested vlookup in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-vlookup-1.png\" alt=\"Nested vlookup in Excel\">\u0110\u1ec3 k\u00e9o gi\u00e1 t\u1eeb b\u1ea3ng Lookup 2 \u0111\u1ebfn b\u1ea3ng Ch\u00ednh, b\u1ea1n ph\u1ea3i th\u1ef1c hi\u1ec7n c\u00e1i g\u1ecdi l\u00e0 vlookup \u0111\u00f4i c\u1ee7a Excel, ho\u1eb7c vlookup l\u1ed3ng nhau.<\/p>\n<ol>\n<li>T\u1ea1o c\u00f4ng th\u1ee9c VLOOKUP t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m trong \u201d\u00a0<em>Lookup table 1<\/em>\u201c, s\u1eed d\u1ee5ng SKU New l\u00e0m gi\u00e1 tr\u1ecb tra c\u1ee9u:<\/li>\n<\/ol>\n<p><strong>=VLOOKUP(A2,New_SKU,2,FALSE)<\/strong><\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p \u2018New_SKU\u2019 l\u00e0 ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean cho $A:$B trong \u201d\u00a0<em>Lookup table 1 \u201c<\/em>\u00a0v\u00e0 \u201d\u00a0<em>Lookup table 2\u2033<\/em>\u00a0, th\u00ec c\u1ed9t B c\u00f3 ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m (xin xem h\u00ecnh tr\u00ean).<\/p>\n<ol start=\"2\">\n<li>Vi\u1ebft c\u00f4ng th\u1ee9c \u0111\u1ec3 k\u00e9o gi\u00e1 t\u1eeb \u201d\u00a0<em>Lookup table 2 \u201c<\/em>, d\u1ef1a v\u00e0o t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p hai h\u00e0m vlookup \u1edf tr\u00ean trong ti\u00eau ch\u00ed tra c\u1ee9u:<\/li>\n<\/ol>\n<p><strong>=VLOOKUP(VLOOKUP(A2,New_SKU,2,FALSE),Price,3,FALSE)<\/strong><\/p>\n<p>Trong \u0111\u00f3 Price l\u00e0 m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean $A:$C trong b\u1ea3ng tra c\u1ee9u 2, v\u00e0 3 l\u00e0 c\u1ed9t C ch\u1ee9a gi\u00e1.<\/p>\n<p>H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi c\u00f4ng th\u1ee9c vlookup l\u1ed3ng nhau c\u1ee7a ch\u00fang ta:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Doing two vlookups in one formula\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-double-vlookup.png\" alt=\"Doing two vlookups in one formula\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_nang_cao_tra_cuu_tra_ve_nhieu_gia_tri\"><\/span>H\u00e0m VLOOKUP n\u00e2ng cao, tra c\u1ee9u tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y Blog H\u1ecdc Excel Online s\u1ebd k\u1ebft h\u1ee3p m\u1ed9t s\u1ed1 h\u00e0m trong Excel \u0111\u1ec3 t\u1ea1o ra m\u1ed9t h\u00e0m t\u1ed5ng h\u1ee3p c\u00f3 ch\u1ee9c n\u0103ng d\u00f2 t\u00ecm v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u gi\u00e1 tr\u1ecb. Video v\u00e0 b\u00e0i thuy\u1ebft tr\u00ecnh sau \u0111\u00e2y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c m\u1ea3ng t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p n\u00e0y. L\u01b0u \u00fd, sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm CTRL + SHIFT + ENTER \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y.<\/p>\n<p>\u1ee8ng d\u1ee5ng c\u1ee7a c\u00e1ch tra c\u1ee9u ki\u1ec3u n\u00e0y l\u00e0 t\u1ea1o ra phi\u1ebfu xu\u1ea5t kho, \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong video\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/60-%E2%97%8F-cach-tao-phieu-xuat-kho-trong-excel.html\">\u1edf b\u00e0i vi\u1ebft n\u00e0y<\/a><\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Y7NJYbnpXhg\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe>\n<p><strong>Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/strong><\/p>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/nu11ritbxbtsnui\/101-hocexcelonline.xlsx?dl=0\">Download<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_VLOOKUP_va_INDIRECT_de_tu_dong_keo_du_lieu_tu_cac_trang_tinh_khac_nhau\"><\/span><strong>S\u1eed d\u1ee5ng VLOOKUP v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\">INDIRECT<\/a> \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng k\u00e9o d\u1eef li\u1ec7u t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c \u201ck\u00e9o d\u1eef li\u1ec7u \u0111\u1ed9ng t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau\u201d c\u00f3 ngh\u0129a l\u00e0 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t trang.<\/p>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 d\u1eef li\u1ec7u \u1edf c\u00f9ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c chia tr\u00ean nhi\u1ec1u b\u1ea3ng t\u00ednh v\u00e0 m\u1ed7i l\u1ea7n b\u1ea1n mu\u1ed1n k\u00e9o d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p t\u1eeb m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3 t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o m\u1ed9t \u00f4 n\u00e0o.\u00a0M\u1ed9t v\u00ed d\u1ee5 s\u1ebd gi\u00fap ta d\u1ec5 hi\u1ec3u h\u01a1n.<\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Gi\u00e1o tr\u00ecnh\u00a0<span data-sheets-value='{\"1\":2,\"2\":\"Excel n\u00e2ng cao\"}' data-sheets-userformat='{\"2\":6659,\"3\":[null,0],\"4\":[null,2,16777215],\"12\":0,\"14\":[null,2,0],\"15\":\"arial, sans, sans-serif\"}'>Excel n\u00e2ng cao hay nh\u1ea5t m\u1ecdi th\u1eddi \u0111\u1ea1i<\/span><\/a><\/p>\n<\/blockquote>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t v\u00e0i b\u00e1o c\u00e1o b\u00e1n h\u00e0ng khu v\u1ef1c cho c\u00f9ng m\u1ed9t s\u1ea3n ph\u1ea9m \u1edf c\u00f9ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm s\u1ed1 b\u00e1n cho m\u1ed9t khu v\u1ef1c nh\u1ea5t \u0111\u1ecbnh:<\/p>\n<p>\u00a0<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u1ec9 c\u00f3 m\u1ed9t v\u00e0i khu v\u1ef1c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c VLOOKUP kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u1edbi m\u1ed9t\u00a0<strong>H\u00e0m IF<\/strong>\u00a0\u0111\u1ec3 ch\u1ecdn trang cho vlookup:<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP($D$2,IF($D3=\u201dFL\u201d,FL_Sales,CA_Sales),2,FALSE)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>$D$2 l\u00e0 m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a \u201d Product Name\u201d.\u00a0L\u01b0u \u00fd r\u1eb1ng ch\u00fang ta s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u0111\u1ec3 ng\u0103n kh\u00f4ng cho gi\u00e1 tr\u1ecb tra c\u1ee9u thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c.<\/li>\n<li>$D3 l\u00e0 m\u1ed9t \u00f4 v\u1edbi t\u00ean tr\u1ea1ng th\u00e1i (s\u1eed d\u1ee5ng tham chi\u1ebfu c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i n\u1ebfu b\u1ea1n d\u1ef1 \u0111\u1ecbnh sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c trong c\u00f9ng m\u1ed9t c\u1ed9t).<\/li>\n<li>FL_Sales v\u00e0 CA_Sales l\u00e0 c\u00e1c t\u00ean b\u1ea3ng, ho\u1eb7c c\u00e1c ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, cho c\u00e1c b\u00e1o c\u00e1o b\u00e1n h\u00e0ng t\u01b0\u01a1ng \u1ee9ng.\u00a0B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean b\u1ea3ng t\u00ednh v\u00e0 d\u1ea3i \u00f4 th\u00f4ng th\u01b0\u1eddng, v\u00ed d\u1ee5 nh\u01b0 \u2018FL Sheet\u2019! $A$3:$B$10, nh\u01b0ng s\u1eed d\u1ee5ng c\u00e1c ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean thu\u1eadn ti\u1ec7n h\u01a1n nhi\u1ec1u.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A VLOOKUP formula with a nested IF function to find matching data in 2 different worksheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-if.png\" alt=\"A VLOOKUP formula with a nested IF function to find matching data in 2 different worksheets\"><\/p>\n<p>Tuy nhi\u00ean, n\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u b\u1ea3ng tra c\u1ee9u, h\u00e0m IF kh\u00f4ng ph\u1ea3i l\u00e0 gi\u1ea3i ph\u00e1p l\u00fd t\u01b0\u1edfng.\u00a0Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INDIRECT\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 ph\u1ea1m vi tra c\u1ee9u c\u1ea7n thi\u1ebft.<\/p>\n<p>H\u00e0m INDIRECT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00e1n ti\u1ebfp tham kh\u1ea3o m\u1ed9t \u00f4, v\u00e0 \u0111\u00e2y ch\u00ednh x\u00e1c l\u00e0 \u0111i\u1ec1u ch\u00fang ta c\u1ea7n l\u00fac n\u00e0y.\u00a0V\u00ec v\u1eady, h\u00e3y ti\u1ebfp t\u1ee5c v\u00e0 thay th\u1ebf c\u00e2u l\u1ec7nh IF b\u1eb1ng tham chi\u1ebfu INDIRECT\u00a0 theo c\u00f4ng th\u1ee9c tr\u00ean.\u00a0V\u00e0 \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c khi k\u1ebft k\u1ebft h\u1ee3p VLOOKUP v\u00e0 INDIRECT trong v\u00ed d\u1ee5:<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP($D$2,INDIRECT($D3&amp;\u201d_Sales\u201d),2,FALSE)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>$D$2 l\u00e0 \u00f4 c\u00f3 ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m, n\u00f3 lu\u00f4n lu\u00f4n kh\u00f4ng thay \u0111\u1ed5i do c\u00e1c tham chi\u1ebfu c\u1ed9t v\u00e0 c\u1ed9t l\u00e0 tuy\u1ec7t \u0111\u1ed1i.<\/li>\n<li>$D3 l\u00e0 \u00f4 ch\u1ee9a t\u00ean tr\u1ea1ng th\u00e1i \u0111\u1ea7u ti\u00ean, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 FL.<\/li>\n<\/ul>\n<p>\u201c_Sales\u201d l\u00e0 ph\u1ea7n chung c\u1ee7a t\u00ean ph\u1ea1m vi, ho\u1eb7c t\u00ean b\u1ea3ng. K\u1ebft n\u1ed1i v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 D3 n\u00f3 t\u1ea1o t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a d\u00e3y y\u00eau c\u1ea7u. D\u01b0\u1edbi \u0111\u00e2y t\u00f4i s\u1ebd cung c\u1ea5p m\u1ed9t s\u1ed1 chi ti\u1ebft c\u1ee5 th\u1ec3 h\u01a1n cho nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng c\u00f3 nhi\u1ec1u kinh nghi\u1ec7m v\u1edbi h\u00e0m INDIRECT c\u1ee7a Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"INDIRECT_VLOOKUP_%E2%80%93_cach_hoat_dong\"><\/span><strong>INDIRECT &amp; VLOOKUP \u2013 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc h\u1ebft, h\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc cho b\u1ea1n c\u00fa ph\u00e1p c\u1ee7a h\u00e0m INDIRECT: =<strong><em>INDIRECT (ref_text, [a1])<\/em><\/strong><\/p>\n<p>Tham s\u1ed1 \u0111\u1ea7u ti\u00ean c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u00f4 theo ki\u1ec3u A1 ho\u1eb7c ki\u1ec3u R1C1, t\u00ean d\u1ea3i \u00f4, ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.\u00a0Th\u00f4ng s\u1ed1 th\u1ee9 hai x\u00e1c \u0111\u1ecbnh lo\u1ea1i tham chi\u1ebfu \u0111\u01b0\u1ee3c ch\u1ee9a trong ref_text \u2013 ki\u1ec3u A1 (TRUE ho\u1eb7c b\u1ecf qua) ho\u1eb7c ki\u1ec3u R1C1 (FALSE).\u00a0\u0110\u00f3 l\u00e0 A1 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta, v\u00ec v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 b\u1ecf qua tham s\u1ed1 th\u1ee9 hai v\u00e0 ch\u1ec9 t\u1eadp trung v\u00e0o c\u00e1i \u0111\u1ea7u ti\u00ean.<\/p>\n<p>B\u00e2y gi\u1edd, h\u00e3y tr\u1edf l\u1ea1i v\u1edbi b\u00e1o c\u00e1o b\u00e1n h\u00e0ng c\u1ee7a ch\u00fang ta.\u00a0Nh\u01b0 b\u1ea1n th\u1ea5y, m\u1ed7i b\u00e1o c\u00e1o l\u00e0 m\u1ed9t b\u1ea3ng ri\u00eang bi\u1ec7t \u1edf trong m\u1ed9t trang ri\u00eang bi\u1ec7t.\u00a0\u0110\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng, b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1eb7t t\u00ean cho c\u00e1c b\u1ea3ng ho\u1eb7c d\u00e3y c\u1ee7a b\u1ea1n, v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c t\u00ean n\u00ean c\u00f3 m\u1ed9t ph\u1ea7n chung.\u00a0V\u00ed d\u1ee5: b\u00e1o c\u00e1o b\u00e1n h\u00e0ng c\u1ee7a ta c\u00f3 t\u00ean: CA_Sales, FL_Sales, TX_Sales vv Nh\u01b0 b\u1ea1n th\u1ea5y, lu\u00f4n c\u00f3 ph\u1ea7n\u00a0<strong>_Sales<\/strong>.<\/p>\n<p>V\u00ec v\u1eady, H\u00e0m INDIRECT INDIRECT ($D3&amp; \u201c_ Sales\u201d) k\u1ebft n\u1ed1i gi\u00e1 tr\u1ecb trong c\u1ed9t D v\u1edbi t\u1eeb _Sales (v\u1edbi m\u1ed9t g\u1ea1ch d\u01b0\u1edbi), v\u00e0 cho h\u00e0m VLOOKUP bi\u1ebft ch\u00ednh x\u00e1c b\u1ea3ng \u0111\u1ec3 tra c\u1ee9u.\u00a0Ngh\u0129a l\u00e0, n\u1ebfu b\u1ea1n c\u00f3 FL trong \u00f4 D3, c\u00f4ng th\u1ee9c s\u1ebd t\u00ecm ki\u1ebfm trong b\u1ea3ng FL_Sales, n\u1ebfu CA \u2013 th\u00ec trong b\u1ea3ng CA_Sales, v.v \u2026<\/p>\n<p>K\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1edfi h\u00e0m VLOOKUP v\u00e0 INDIRECT c\u1ee7a b\u1ea1n s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A combination of the INDERECT and VLOOKUP functions to dynamically pull data from different sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-indirect-1.png\" alt=\"Merge Tables Wizard - a visual way to do vlookup in Excel\"><\/p>\n<p>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n n\u1eb1m trong c\u00e1c b\u1ea3ng t\u00ednh nhau, b\u1ea1n s\u1ebd ph\u1ea3i th\u00eam m\u1ed9t t\u00ean b\u1ea3ng t\u00ednh tr\u01b0\u1edbc v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean (WorkbookName! NamedRange), v\u00ed d\u1ee5:<\/p>\n<p style=\"padding-left: 30px\"><strong>=VLOOKUP($D$2,INDIRECT($D3&amp;\u201dWorkbook1!_Sales\u201d),2,FALSE)<\/strong><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu h\u00e0m INDIRECT \u0111\u1ec1 c\u1eadp \u0111\u1ebfn m\u1ed9t workbook kh\u00e1c, b\u1ea3ng t\u00ednh \u0111\u00f3 ph\u1ea3i \u0111\u01b0\u1ee3c m\u1edf.\u00a0N\u1ebfu b\u1ea3ng t\u00ednh ngu\u1ed3n kh\u00f4ng m\u1edf, c\u00f4ng th\u1ee9c INDIRECT c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #REF!.<\/p>\n<p>\u0110\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c Excel, b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online.\u00a0Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/G2YpPjLgO9k?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-284.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7099,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7098","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7098","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=7098"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7098\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7099"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}