{"id":988,"date":"2024-12-02T03:50:23","date_gmt":"2024-12-02T03:50:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003\/"},"modified":"2024-12-02T03:50:23","modified_gmt":"2024-12-02T03:50:23","slug":"ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003\/","title":{"rendered":"H\u00e0m LOOKUP v\u00e0 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 trong Excel 2016 2013 2010 2007 2003"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOOKUP trong Excel, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m LOOKUP c\u00f9ng v\u1edbi c\u00e1c v\u00ed d\u1ee5 c\u1ee7a h\u00e0m LOOKUP t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao trong Excel<\/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-674d2e7eb01e1\" 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\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Ham_LookUp_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m LookUp trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">H\u00e0m LookUp trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/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\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Su_dung_ham_Lookup_trong_Excel_%E2%80%93_kieu_Vector\" title=\"S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u Vector\">S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u Vector<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Tra_cuu_du_lieu_theo_cot_voi_ham_LOOKUP_trong_Excel\" title=\"Tra c\u1ee9u d\u1eef li\u1ec7u theo c\u1ed9t v\u1edbi h\u00e0m LOOKUP trong Excel\">Tra c\u1ee9u d\u1eef li\u1ec7u theo c\u1ed9t v\u1edbi h\u00e0m LOOKUP trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Tra_cuu_du_lieu_theo_hang_voi_ham_LOOKUP_trong_Excel\" title=\"Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng v\u1edbi h\u00e0m LOOKUP trong Excel\">Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng v\u1edbi h\u00e0m LOOKUP trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Luu_y_khi_tra_cuu_su_dung_ham_Lookup_trong_Excel\" title=\"L\u01b0u \u00fd khi tra c\u1ee9u s\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel\">L\u01b0u \u00fd khi tra c\u1ee9u s\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Su_dung_ham_Lookup_trong_Excel_%E2%80%93_kieu_mang\" title=\"S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u m\u1ea3ng\">S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u m\u1ea3ng<\/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\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Ung_dung_cua_ham_LOOKUP_trong_Excel\" title=\"\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP trong Excel:\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP trong Excel:<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Tim_gia_tri_trong_o_cuoi_cung_chua_du_lieu_cua_1_cot\" title=\"T\u00ecm gi\u00e1 tr\u1ecb trong \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a 1 c\u1ed9t\">T\u00ecm gi\u00e1 tr\u1ecb trong \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a 1 c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Tim_gia_tri_cua_o_cuoi_cung_chua_du_lieu_trong_1_hang\" title=\"T\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u trong 1 h\u00e0ng\">T\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u trong 1 h\u00e0ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Thang_co_sales_gan_nhat_cua_nhan_vien_sales\" title=\"Th\u00e1ng c\u00f3 sales g\u1ea7n nh\u1ea5t c\u1ee7a nh\u00e2n vi\u00ean sales\">Th\u00e1ng c\u00f3 sales g\u1ea7n nh\u1ea5t c\u1ee7a nh\u00e2n vi\u00ean sales<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html#Thay_the_ham_IF_long_nhau_trong_Excel\" title=\"Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau trong Excel\">Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_LookUp_trong_Excel_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m LookUp trong Excel \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u1ee7a h\u00e0m Lookup trong Excel l\u00e0 t\u00ecm 1 gi\u00e1 tr\u1ecb trong 1 c\u1ed9t ho\u1eb7c 1 h\u00e0ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf v\u1ecb tr\u00ed t\u01b0\u01a1ng \u1ee9ng trong h\u00e0ng ho\u1eb7c c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1. C\u00f3 2 ki\u1ec3u s\u1eed d\u1ee5ng h\u00e0m Lookup \u0111\u00f3 l\u00e0 ki\u1ec3u Vector v\u00e0 ki\u1ec3u m\u1ea3ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Lookup_trong_Excel_%E2%80%93_kieu_Vector\"><\/span>S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u Vector<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m Lookup, Vector \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 1 h\u00e0ng hay 1 c\u1ed9t trong Excel. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Lookup \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p><strong>=LOOKUP( &lt; gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt;, &lt; vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt;,[ vector ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ] )<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul style=\"list-style-type: square\">\n<li><strong>&lt; gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt;<\/strong> (b\u1eaft bu\u1ed9c): gi\u00e1 tr\u1ecb b\u1ea1n \u0111ang c\u1ea7n t\u00ecm ki\u1ebfm, c\u00f3 th\u1ec3 l\u00e0 d\u1ea1ng s\u1ed1, d\u1ea1ng text, d\u1ea1ng \u0111\u00fang \/ sai ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u01b0a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm.<\/li>\n<li><strong>&lt; vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt; <\/strong>(b\u1eaft bu\u1ed9c): 1 d\u00f2ng ho\u1eb7c 1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm. B\u1eaft bu\u1ed9c ph\u1ea3i \u0111\u01b0\u1ee3c <span style=\"background-color: #ffff00\">s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n<\/span> (A-&gt;Z ho\u1eb7c nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t)<\/li>\n<li><strong>[ vector ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ] <\/strong>(kh\u00f4ng b\u1eaft bu\u1ed9c): 1 d\u00f2ng ho\u1eb7c 1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. Vector n\u00e0y c\u1ea7n c\u00f3 k\u00edch th\u01b0\u1edbc gi\u1ed1ng nh\u01b0 k\u00edch th\u01b0\u1edbc c\u1ee7a vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm, n\u1ebfu kh\u00f4ng c\u00f3 vector n\u00e0y, th\u00ec vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 thay th\u1ebf.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>2 V\u00ed d\u1ee5 sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00fa ph\u00e1p ph\u00eda tr\u00ean c\u1ee7a h\u00e0m Lookup trong Excel<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tra_cuu_du_lieu_theo_cot_voi_ham_LOOKUP_trong_Excel\"><\/span>Tra c\u1ee9u d\u1eef li\u1ec7u theo c\u1ed9t v\u1edbi h\u00e0m LOOKUP trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>=LOOKUP(B2,D2:D5,E2:E5)<\/strong><\/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-66.gif\" title=\"ex101_92019-nho-66\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_4370\" aria-describedby=\"caption-attachment-4370\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/ham-lookup-trong-excel-theo-cot.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4370\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-lookup-trong-excel-theo-cot.png\" alt=\"ham-lookup-trong-excel-theo-cot\" width=\"480\" height=\"211\" title=\"ham-lookup-trong-excel-theo-cot\"><\/a><figcaption id=\"caption-attachment-4370\" class=\"wp-caption-text\">ham-lookup-trong-excel-theo-cot<\/figcaption><\/figure>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 xem h\u00ecnh sau \u0111\u00e2y:<\/p>\n<figure id=\"attachment_4371\" aria-describedby=\"caption-attachment-4371\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/ham-lookup-trong-excel-theo-cot-cong-thuc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4371\" title=\"ham-lookup-trong-excel-theo-cot-cong-thuc\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-lookup-trong-excel-theo-cot-cong-thuc-300x86-1.png\" alt=\"ham-lookup-trong-excel-theo-cot-cong-thuc\" width=\"480\" height=\"137\"><\/a><figcaption id=\"caption-attachment-4371\" class=\"wp-caption-text\">ham-lookup-trong-excel-theo-cot-cong-thuc<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Tra_cuu_du_lieu_theo_hang_voi_ham_LOOKUP_trong_Excel\"><\/span>Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng v\u1edbi h\u00e0m LOOKUP trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>=LOOKUP(B2,B6:E6,B7:E7)<\/strong><\/p>\n<figure id=\"attachment_4372\" aria-describedby=\"caption-attachment-4372\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/ham-lookup-trong-excel-theo-hang.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4372\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-lookup-trong-excel-theo-hang-300x122-1.png\" alt=\"ham-lookup-trong-excel-theo-hang\" width=\"480\" height=\"196\" title=\"ham-lookup-trong-excel-theo-hang-300x122-1\"><\/a><figcaption id=\"caption-attachment-4372\" class=\"wp-caption-text\">ham-lookup-trong-excel-theo-hang<\/figcaption><\/figure>\n<p>Xem th\u00eam: t\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2003\">h\u1ecdc excel c\u01a1 b\u1ea3n 2003<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Luu_y_khi_tra_cuu_su_dung_ham_Lookup_trong_Excel\"><\/span>L\u01b0u \u00fd khi tra c\u1ee9u s\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb \u0111i\u1ec3n (A \u0111\u1ebfn Z) ho\u1eb7c s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf t\u1edbi l\u1edbn, n\u1ebfu kh\u00f4ng c\u00f4ng th\u1ee9c Lookup s\u1ebd b\u1ecb l\u1ed7i ho\u1eb7c k\u1ebft qu\u1ea3 s\u1ebd b\u1ecb sai. N\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o \u0111\u00f3 b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u m\u00e0 v\u1eabn c\u1ea7n tra c\u1ee9u, h\u00e3y <a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">s\u1eed d\u1ee5ng h\u00e0m Index k\u1ebft h\u1ee3p v\u1edbi Match<\/a><\/li>\n<li>Vector ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u v\u00e0 vector k\u1ebft qu\u1ea3 l\u00e0 h\u00e0ng ho\u1eb7c c\u1ed9t c\u00f3 k\u00edch th\u01b0\u1edbc gi\u1ed1ng nhau<\/li>\n<li>H\u00e0m Lookup trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng khi tra c\u1ee9u<\/li>\n<li>H\u00e0m Lookup s\u1eed d\u1ee5ng ch\u1ebf \u0111\u1ed9 t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb \u0111\u00fang 100% nh\u01b0 gi\u00e1 tr\u1ecb \u0111ang c\u1ea7n t\u00ecm ki\u1ebfm, n\u00f3 s\u1ebd t\u00ecm \u0111\u1ebfn gi\u00e1 tr\u1ecb X l\u1edbn nh\u1ea5t trong vector ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u1edbi \u0111i\u1ec1u ki\u1ec7n X nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm. V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n t\u00ecm gi\u00e1 tr\u1ecb 5 m\u00e0 5 kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, Lookup s\u1ebd t\u00ecm ti\u1ebfp gi\u00e1 tr\u1ecb 4, n\u1ebfu 4 kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, Lookup s\u1ebd t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n ti\u1ebfp theo.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong vector ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, h\u00e0m Lookup s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_Lookup_trong_Excel_%E2%80%93_kieu_mang\"><\/span>S\u1eed d\u1ee5ng h\u00e0m Lookup trong Excel \u2013 ki\u1ec3u m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Lookup theo ki\u1ec3u m\u1ea3ng s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf v\u1ecb tr\u00ed t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t cu\u1ed1i c\u00f9ng c\u1ee7a m\u1ea3ng \u0111\u00f3. C\u00fa ph\u00e1p:<\/p>\n<p><strong>=LOOKUP(&lt; gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt;, \u00a0&lt; m\u1ea3ng d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm &gt;)<\/strong><\/p>\n<p>v\u1edbi:<\/p>\n<ul style=\"list-style-type: square\">\n<li><strong>&lt; gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm &gt;<\/strong> (b\u1eaft bu\u1ed9c): gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong m\u1ea3ng<\/li>\n<li><strong>&lt; m\u1ea3ng d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm &gt;<\/strong> (b\u1eaft bu\u1ed9c): m\u1ea3ng ch\u01b0a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm v\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. Gi\u00e1 tr\u1ecb trong m\u1ea3ng c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n<\/li>\n<\/ul>\n<figure id=\"attachment_4379\" aria-describedby=\"caption-attachment-4379\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/ham-lookup-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4379\" title=\"ham-lookup-trong-excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-lookup-trong-excel-300x131-1.png\" alt=\"ham-lookup-trong-excel\" width=\"480\" height=\"210\"><\/a><figcaption id=\"caption-attachment-4379\" class=\"wp-caption-text\">ham-lookup-trong-excel<\/figcaption><\/figure>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ol>\n<li>N\u1ebfu m\u1ea3ng d\u00f9ng \u0111\u1ec3 tra c\u1ee9u c\u00f3 s\u1ed1 d\u00f2ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 c\u1ed9t (nh\u01b0 \u1ea3nh ph\u00eda tr\u00ean) th\u00ec h\u00e0m Lookup s\u1ebd tra c\u1ee9u theo c\u1ed9t<\/li>\n<li>N\u1ebfu m\u1ea3ng d\u00f9ng \u0111\u1ec3 tra c\u1ee9u c\u00f3 s\u1ed1 d\u00f2ng nh\u1ecf h\u01a1n s\u1ed1 c\u1ed9t, th\u00ec h\u00e0m Lookup s\u1ebd tra c\u1ee9u theo d\u00f2ng<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, Lookup s\u1ebd d\u00f9ng gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ea3ng m\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong h\u00e0ng \u0111\u1ea7u ti\u00ean ho\u1eb7c c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ea3ng, l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/li>\n<li>H\u1ecdc Excel Online kh\u00f4ng khuy\u00ean d\u00f9ng h\u00e0m Lookup \u1edf d\u1ea1ng m\u1ea3ng n\u00e0y. B\u1ea1n h\u00e3y 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\">h\u00e0m VLOOKUP<\/a> ho\u1eb7c HLOOKUP<\/li>\n<\/ol>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2010<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_cua_ham_LOOKUP_trong_Excel\"><\/span>\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tim_gia_tri_trong_o_cuoi_cung_chua_du_lieu_cua_1_cot\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb trong \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a 1 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n thay \u0111\u1ed5i th\u01b0\u1eddng xuy\u00ean v\u00e0 b\u1ea1n c\u1ea7n tham chi\u1ebfu t\u1edbi gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong 1 c\u1ed9t \u1edf b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00f3, \u0111\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p m\u00e0 h\u00e0m LOOKUP d\u1ea1ng vector s\u1ebd to\u1ea3 s\u00e1ng. V\u00ed d\u1ee5: T\u00ecm gi\u00e1 tr\u1ecb trong \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u \u1edf c\u1ed9t A:<\/p>\n<p><strong>=LOOKUP(2,1\/(A:A&lt;&gt;\u201d\u201d), A:A)<\/strong><\/p>\n<p>V\u00ed d\u1ee5 ti\u1ebfp theo:<\/p>\n<figure id=\"attachment_4381\" aria-describedby=\"caption-attachment-4381\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/vi-du-ham-lookup-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4381\" title=\"vi-du-ham-lookup-trong-excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-ham-lookup-trong-excel-300x74-1.png\" alt=\"vi-du-ham-lookup-trong-excel\" width=\"480\" height=\"118\"><\/a><figcaption id=\"caption-attachment-4381\" class=\"wp-caption-text\">vi-du-ham-lookup-trong-excel<\/figcaption><\/figure>\n<p>Di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c:<\/p>\n<ol>\n<li>Ph\u1ea7n <strong>(A:A&lt;&gt;\u201d\u201d)<\/strong> s\u1ebd so s\u00e1nh m\u1ed7i \u00f4 trong c\u1ed9t A v\u1edbi chu\u1ed7i r\u1ed7ng \u2013 \u201c\u201d. S\u1ef1 so s\u00e1nh n\u00e0y c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 TRUE n\u1ebfu \u00f4 kh\u00f4ng r\u1ed7ng v\u00e0 ng\u01b0\u1ee3c l\u00e0 l\u00e0 FALSE n\u1ebfu \u00f4 r\u1ed7ng. Trong h\u00ecnh tr\u00ean, k\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau: {TRUE; TRUE; TRUE; TRUE; FALSE; \u2026}<\/li>\n<li>Ti\u1ebfp theo <strong>1\/(A:A&lt;&gt;\u201d\u201d)\u00a0<\/strong>s\u1ebd cho ch\u00fang ta k\u1ebft qu\u1ea3 l\u00e0 {1;1;1;1;#DIV\/0;\u2026}<\/li>\n<li>S\u1ed1 2 ch\u1eafc ch\u1eafn s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong m\u1ea3ng k\u1ebft qu\u1ea3 c\u1ee7a 1\/(A:A&lt;&gt;\u201d\u201d), v\u00ec logic c\u1ee7a Lookup l\u00e0 n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb s\u1ebd chuy\u1ec3n sang ki\u1ec3u t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00f9ng n\u00e0y s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong c\u00e1c s\u1ed1 1 \u1edf v\u00ed d\u1ee5 tr\u00ean, t\u01b0\u01a1ng \u1ee9ng v\u1edbi v\u1ecb tr\u00ed s\u1ed1 1 n\u00e0y \u1edf vector k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb \u1edf trong \u00f4 d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng c\u1ee7a c\u1ed9t A<\/li>\n<\/ol>\n<p>=&gt; N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y d\u00f2ng cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong 1 c\u1ed9t v\u1edbi h\u00e0m Lookup, c\u00f4ng th\u1ee9c r\u1ea5t \u0111\u01a1n gi\u1ea3n s\u1ebd l\u00e0:<\/p>\n<p><strong>=LOOKUP(2,1\/(A:A&lt;&gt;\u201d\u201d), ROW(A:A))<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tim_gia_tri_cua_o_cuoi_cung_chua_du_lieu_trong_1_hang\"><\/span>T\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 cu\u1ed1i c\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u trong 1 h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng v\u1edbi logic nh\u01b0 tr\u00ean, c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u00f4 cu\u1ed1i c\u00f9ng ch\u01b0a d\u1eef li\u1ec7u trong 1 h\u00e0ng nh\u01b0 sau:<\/p>\n<p><strong>=LOOKUP(2,1\/(1:1&lt;&gt;\u201d\u201d),1:1)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong h\u00e0ng s\u1ed1 1, \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 cu\u1ed1i c\u00f9ng ch\u01b0a d\u1eef li\u1ec7u trong h\u00e0ng n, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><strong>=LOOKUP(2,1\/(n:n&lt;&gt;\u201d\u201d),n:n)<\/strong><\/p>\n<blockquote>\n<p>Xem ngay: B\u1ed9 t\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">h\u1ecdc Excel 2016<\/a> hi\u1ec7u qu\u1ea3<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Thang_co_sales_gan_nhat_cua_nhan_vien_sales\"><\/span>Th\u00e1ng c\u00f3 sales g\u1ea7n nh\u1ea5t c\u1ee7a nh\u00e2n vi\u00ean sales<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean v\u1ec1 Lookup, ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00e2u h\u1ecfi b\u1eb1ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<p><strong>=LOOKUP(2,1\/(B2:G2=\u201dx\u201d),$B$1:$G$1)<\/strong><\/p>\n<figure id=\"attachment_4383\" aria-describedby=\"caption-attachment-4383\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/ham-lookup-trong-excel-hoc-excel-online.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4383\" title=\"ham-lookup-trong-excel-hoc-excel-online\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-lookup-trong-excel-hoc-excel-online-300x106-1.png\" alt=\"ham-lookup-trong-excel-hoc-excel-online\" width=\"480\" height=\"170\"><\/a><figcaption id=\"caption-attachment-4383\" class=\"wp-caption-text\">ham-lookup-trong-excel-hoc-excel-online<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Thay_the_ham_IF_long_nhau_trong_Excel\"><\/span>Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t \u1ee9ng d\u1ee5ng th\u00fa v\u1ecb kh\u00e1c n\u1eefa c\u1ee7a h\u00e0m LOOKUP \u0111\u00f3 ch\u00ednh l\u00e0 vi\u1ec7c thay th\u1ebf <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">h\u00e0m IF<\/a> l\u1ed3ng nhau trong tr\u01b0\u1eddng h\u1ee3p sau \u0111\u00e2y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/thay-the-ham-if.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-4384\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thay-the-ham-if-300x151-1.png\" width=\"300\" height=\"151\" title=\"thay-the-ham-if-300x151-1\"><\/a><\/p>\n<p><strong>B2 =\u00a0LOOKUP(A2,{\u201cc\u201d;\u201dd\u201d;\u201dt\u201d},{\u201cContemporary\u201d;\u201dDiscontinue\u201d;\u201dTemporary\u201d})<\/strong><\/p>\n<p><strong>C2 =\u00a0IF(A2=\u201dC\u201d,\u201dContemporary\u201d,IF(A2=\u201dD\u201d,\u201dDiscontinue\u201d,IF(A2=\u201dT\u201d,\u201dTemporary\u201d,\u201d\u201d)))<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 qua b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c 1 h\u00e0m r\u1ea5t th\u00fa v\u1ecb c\u1ee7a Excel v\u00e0 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng linh ho\u1ea1t trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/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-66.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":989,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-988","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\/988","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=988"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/988\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/989"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}