{"id":1321,"date":"2024-12-02T04:43:01","date_gmt":"2024-12-02T04:43:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-hyperlink-de-tao-nhieu-lien-ket-khac-nhau\/"},"modified":"2024-12-02T04:43:01","modified_gmt":"2024-12-02T04:43:01","slug":"cach-su-dung-ham-hyperlink-de-tao-nhieu-lien-ket-khac-nhau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-hyperlink-de-tao-nhieu-lien-ket-khac-nhau\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HYPERLINK \u0111\u1ec3 t\u1ea1o nhi\u1ec1u li\u00ean k\u1ebft kh\u00e1c nhau"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn nh\u1eefng ph\u1ea7n c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/use-excel-hyperlink-function-create-different-link-types.html\" target=\"_blank\" rel=\"noopener noreferrer\">HYPERLINK<\/a> c\u1ee7a Excel v\u00e0 nh\u1eefng l\u1eddi khuy\u00ean c\u0169ng nh\u01b0 v\u00ed d\u1ee5 \u0111\u1ec3 s\u1eed d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/em><br \/>\nC\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 ch\u00e8n m\u1ed9t li\u00ean k\u1ebft trong Excel. \u0110\u1ec3 li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang web, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp URL v\u00e0o \u00f4 t\u00ednh, \u1ea5n Enter v\u00e0 Microsoft Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n d\u00f2ng \u0111\u00f3 sang d\u1ea1ng li\u00ean k\u1ebft. \u0110\u1ec3 li\u00ean k\u1ebft sang m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c m\u1ed9t \u0111\u1ecba ch\u1ec9 c\u1ee5 th\u1ec3 trong m\u1ed9t t\u1ec7p Excel kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Hyperlink ho\u1eb7c t\u1ed5 h\u1ee3p ph\u00edm Ctrl+K. N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam nhi\u1ec1u li\u00ean k\u1ebft gi\u1ed1ng h\u1ec7t ho\u1eb7c t\u01b0\u01a1ng t\u1ef1 nhau, s\u1eed d\u1ee5ng h\u00e0m Hyperlink l\u00e0 c\u00e1ch nhanh nh\u1ea5t v\u00e0 c\u0169ng \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u1ea1o m\u1edbi, sao ch\u00e9p v\u00e0 ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft 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-674d3ad3ea72a\" 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\/use-excel-hyperlink-function-create-different-link-types.html#Ham_Excel-_cu_phap_va_cach_su_dung_can_ban\" title=\"H\u00e0m Excel- c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u0103n b\u1ea3n:\">H\u00e0m Excel- c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u0103n b\u1ea3n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/use-excel-hyperlink-function-create-different-link-types.html#Cach_su_dung_ham_HYPERLINK_trong_Excel_%E2%80%93_Vi_du\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HYPERLINK trong Excel \u2013 V\u00ed d\u1ee5:\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HYPERLINK trong Excel \u2013 V\u00ed d\u1ee5:<\/a><\/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\/use-excel-hyperlink-function-create-different-link-types.html#Cach_chinh_sua_nhieu_lien_ket_mot_luc\" title=\"C\u00e1ch ch\u1ec9nh s\u1eeda nhi\u1ec1u li\u00ean k\u1ebft m\u1ed9t l\u00fac:\">C\u00e1ch ch\u1ec9nh s\u1eeda nhi\u1ec1u li\u00ean k\u1ebft m\u1ed9t l\u00fac:<\/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\/use-excel-hyperlink-function-create-different-link-types.html#Nguyen_nhan_va_giai_phap_doi_voi_ham_Hyperlink_khong_hoat_dong\" title=\"Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p \u0111\u1ed1i v\u1edbi h\u00e0m Hyperlink kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng:\">Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p \u0111\u1ed1i v\u1edbi h\u00e0m Hyperlink kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Excel-_cu_phap_va_cach_su_dung_can_ban\"><\/span><strong>H\u00e0m Excel- c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u0103n b\u1ea3n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m Hypelink trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o m\u1ed9t \u0111\u01b0\u1eddng t\u1eaft t\u1edbi m\u1ed9t \u0111\u1ecba ch\u1ec9 c\u1ee5 th\u1ec3 trong c\u00f9ng m\u1ed9t v\u0103n b\u1ea3n ho\u1eb7c \u0111\u1ec3 m\u1edf m\u1ed9t v\u0103n b\u1ea3n hay kh\u00e1c web kh\u00e1c. Nh\u1edd c\u00f3 h\u00e0m Hyperlink b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi c\u00e1c ITEMS sau:<br \/>\n\u2022 M\u1ed9t \u00f4 t\u00ednh ho\u1eb7c m\u1ed9t mi\u1ec1n c\u00f3 t\u00ean trong t\u1ec7p tin Excel ( trong m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t trang t\u00ednh kh\u00e1c)<br \/>\n\u2022 Word, PowerPoint ho\u1eb7c m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong \u1ed5 c\u1ee9ng, m\u1ea1ng n\u1ed9i b\u1ed9 ho\u1eb7c tr\u1ef1c tuy\u1ebfn.<br \/>\n\u2022 D\u1ea5u trang trong v\u0103n b\u1ea3n Word<br \/>\n\u2022 Trang web tr\u00ean Internet ho\u1eb7c m\u1ea1ng n\u1ed9i b\u1ed9<br \/>\n\u2022 \u0110\u1ecba ch\u1ec9 email \u0111\u1ec3 vi\u1ebft mail m\u1edbi<\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn t\u1ea1o <a href=\"http:\/\/blog.ezworkapp.com\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink.html\">li\u00ean k\u1ebft sheet trong excel<\/a> b\u1eb1ng h\u00e0m Hyperlink<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi Excel tr\u1ef1c tuy\u1ebfn, h\u00e0m HYPERLINK ch\u1ec9 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c \u0111\u1ed1i v\u1edbi \u0111\u1ecba ch\u1ec9 trang web (URLs).<br \/>\nC\u00fa ph\u00e1p h\u00e0m HYPERLINK nh\u01b0 sau:<br \/>\n<em><strong>HYPERLINK(link_location, [friendly_name])<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<br \/>\n\u2022 Link_location (b\u1eaft bu\u1ed9c) l\u00e0 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn trang web hay t\u1ec7p tin \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf s\u1eb5n.<br \/>\nLink_location c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft ho\u1eb7c m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c bao g\u1ed3m trong c\u00e1c d\u1ea5u ngo\u1eb7c k\u00e9p c\u00f3 ch\u1ee9a m\u1ed9t \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn m\u1ed9t t\u1ec7p tin \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef tr\u00ean \u1ed5 c\u1ee9ng, \u0111\u01b0\u1eddng d\u1eabn UNC tr\u00ean m\u00e1y ch\u1ee7, \u0111\u01b0\u1eddng d\u1eabn UNC tr\u00ean internet ho\u1eb7c m\u1ea1ng n\u1ed9i b\u1ed9.<br \/>\nN\u1ebfu \u0111\u01b0\u1eddng d\u1eabn li\u00ean k\u1ebft kh\u00f4ng t\u1ed3n t\u1ea1i ho\u1eb7c b\u1ecb h\u1ecfng, h\u00e0m Hyperlink s\u1ebd b\u00e1o l\u1ed7i khi b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 t\u00ednh.<br \/>\n\u2022 Friendly_name (optional) l\u00e0 n\u1ed9i dung li\u00ean k\u1ebft ( c\u0169ng ch\u00ednh l\u00e0 jump text or anchor text) \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 t\u00ednh. N\u1ebfu b\u1ea1n b\u1ecf qua th\u00ec \u0111\u1ed1i s\u1ed1 link_location s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb l\u00e0 n\u1ed9i dung li\u00ean k\u1ebft lu\u00f4n.<br \/>\nFriendly_name c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1, chu\u1ed7i v\u0103n b\u1ea3n k\u00e8m theo d\u1ea5u ngo\u1eb7c k\u00e9p, t\u00ean ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a v\u0103n b\u1ea3n li\u00ean k\u1ebft.<\/p>\n<p style=\"text-align: justify\">Khi nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 t\u00ednh c\u00f3 h\u00e0m Hyperlink \u0111\u1ec3 m\u1edf t\u1ec7p tin ho\u1eb7c trang web \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong \u0111\u1ed1i s\u1ed1 link_location.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hyperlink, trong \u0111\u1ed1 \u00f4 A2 l\u00e0 ch\u1ee9a \u0111\u1ed1i s\u1ed1 friendly_name v\u00e0 \u00f4 B2 l\u00e0 link_location:<br \/>\n<strong><em>=HYPERLINK(B2, A2)<\/em><\/strong><br \/>\nK\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c s\u1ebd t\u01b0\u01a1ng t\u01b0 nh\u01b0 sau:<\/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-35.gif\" title=\"vba101_92019-nho-35\"><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-95.gif\" title=\"ex101_92019-nho-95\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-hyperlink-function.png\" alt=\"Examples of using the HYPERLINK function in Excel\" title=\"excel-hyperlink-function\"><\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00ed d\u1ee5 kh\u00e1c h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hyperlink trong Excel s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_HYPERLINK_trong_Excel_%E2%80%93_Vi_du\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HYPERLINK trong Excel \u2013 V\u00ed d\u1ee5:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y c\u00f9ng xem c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m HYPERLINK \u0111\u1ec3 m\u1edf nhi\u1ec1u v\u0103n b\u1ea3n tr\u1ef1c ti\u1ebfp t\u1eeb b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n trong th\u1ef1c h\u00e0nh nh\u01b0 th\u1ebf n\u00e0o. Ngo\u00e0i ra, ch\u00fang ta c\u0169ng s\u1ebd c\u00f9ng th\u1ea3o lu\u1eadn v\u1ec1 nh\u1eefng h\u00e0m ph\u1ee9c h\u01a1n, trong \u0111\u00f3 h\u00e0m HYPERLINK \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng nhi\u1ec7m v\u1ee5 kh\u00f3 h\u01a1n.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch li\u00ean k\u1ebft t\u1edbi c\u00e1c trang t\u00ednh, c\u00e1c t\u1ec7p tin, trang web\u2026<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m HYPERLINK trong Excel cho ph\u00e9p b\u1ea1n ch\u00e8n m\u1ed9t \u0111\u01b0\u1eddng li\u00ean k\u1ebft c\u00f3 th\u1ec3 di chuy\u1ec3n \u0111\u1ebfn c\u00e1c ph\u1ea7n kh\u00e1c nhau, ph\u1ee5 thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb b\u1ea1n \u0111i\u1ec1n v\u00e0o \u0111\u1ed1i s\u1ed1<em> link_location<\/em>.<\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft \u0111\u1ebfn c\u00e1c trang t\u00ednh kh\u00e1c<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u00e8n li\u00ean k\u1ebft \u0111\u1ebfn c\u00e1c trang t\u00ednh kh\u00e1c trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh, c\u1ea7n nh\u1eadp t\u00ean c\u00e1c trang t\u00ednh m\u1ee5c ti\u00eau \u0111\u1eb1ng sau d\u1ea5u th\u0103ng (#), ti\u1ebfp theo l\u00e0 d\u1ea5u ch\u1ea5m than v\u00e0 tham chi\u1ebfu \u00f4 m\u1ee5c ti\u00eau, v\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c#Sheet2!A1\u201d, \u201cSheet2\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m tr\u00ean t\u1ea1o li\u00ean k\u1ebft v\u1edbi d\u00f2ng v\u0103n b\u1ea3n \u201cSheet2\u201d \u0111\u1ec3 m\u1edf trang t\u00ednh 2 trong b\u1ea3ng t\u00ednh hi\u1ec7n h\u00e0nh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu trong t\u00ean b\u1ea3ng t\u00ednh c\u00f3 bao g\u1ed3m c\u00e1c kho\u1ea3ng c\u00e1ch ho\u1eb7c c\u00e1c k\u00fd t\u1ef1, c\u1ea7n ph\u1ea3i \u0111\u1eb7t trong d\u1ea5u nh\u00e1y \u0111\u01a1n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c#\u2019Price list\u2019!A1\u201d, \u201cPrice list\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u00f4 t\u00ednh kh\u00e1c trong c\u00f9ng m\u1ed9t trang t\u00ednh. V\u00ed d\u1ee5, \u0111\u1ec3 ch\u00e8n li\u00ean k\u1ebft t\u1edbi \u00f4 t\u00ednh A1 trong c\u00f9ng b\u1ea3ng t\u00ednh, s\u1eed d\u1ee5ng h\u00e0m sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c#A1\u201d, \u201cGo to cell A1\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, c\u1ea7n x\u00e1c \u0111\u1ecbnh r\u00f5 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi b\u1ea3ng t\u00ednh m\u1ee5c ti\u00eau theo \u0111\u1ecbnh d\u1ea1ng sau<\/p>\n<p style=\"text-align: justify\"><em>\u201cDrive:FolderWorkbook.xlsx\u201d<\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201cD:Source dataBook3.xlsx\u201d, \u201cBook3\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1eb1m trong m\u1ed9t trang c\u1ee5 th\u1ec3 ho\u1eb7c trong m\u1ed9t \u00f4 t\u00ednh th\u00ec s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng:<\/p>\n<p style=\"text-align: justify\"><em>\u201c[Drive:FolderWorkbook.xlsx]Sheet!Cell\u201d<\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 th\u00eam li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 \u201cBook3\u2033\u0111\u1ec3 m\u1edf trang t\u00ednh 2 trong b\u1ea3ng t\u00ednh 3, l\u01b0u tr\u1eef trong th\u01b0 m\u1ee5c\u00a0<em>Source data<\/em>\u00a0\u1edf \u1ed5 D, s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c[D:Source dataBook3.xlsx]Sheet2!A1\u201d, \u201cBook3\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n di chuy\u1ec3n b\u1ea3ng t\u00ednh t\u1edbi m\u1ed9t \u0111\u1ecba ch\u1ec9 kh\u00e1c, c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t li\u00ean k\u1ebft thay th\u1ebf nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201cSource dataBook3.xlsx\u201d, \u201cBook3\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu di chuy\u1ec3n c\u00e1c th\u01b0 m\u1ee5c, li\u00ean k\u1ebft thay th\u1ebf c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c ho\u1ea1t \u0111\u1ed9ng mi\u1ec5n l\u00e0 \u0111\u01b0\u1eddng d\u1eabn thay th\u1ebf t\u1edbi b\u1ea3ng t\u00ednh m\u1ee5c <a href=\"http:\/\/armodexperiment.com\/\">http:\/\/armodexperiment.com\/<\/a> ti\u00eau kh\u00f4ng thay \u0111\u1ed5i. C\u1ee5 th\u1ec3 h\u01a1n, m\u1eddi b\u1ea1n tham kh\u1ea3o <strong><em>Li\u00ean k\u1ebft tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong Excel<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft t\u1edbi m\u1ed9t mi\u1ec1n t\u00ean<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n t\u1ea1o li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t v\u00f9ng t\u00ean trong b\u1ea3ng t\u00ednh, c\u1ea7n th\u00eam c\u1ea3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi mujv ti\u00eau:<\/p>\n<p style=\"text-align: justify\"><em>\u201c[Drive:FolderWorkbook.xlsx]Sheet!Name\u201d<\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 ch\u00e8n m\u1ed9t li\u00ean k\u1ebft t\u1edbi v\u00f9ng c\u00f3 t\u00ean \u201cSource_data\u201d l\u01b0u tr\u1eef tr\u00ean trang t\u00ednh 1, thu\u1ed9c b\u1ea3ng t\u00ednh 1, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c[D:Excel filesBook1.xlsx]Sheet1!Source_data\u201d,\u201dSource data\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t v\u00f9ng t\u00ean thu\u1ed9c b\u1ea3ng t\u00ednh th\u00ec kh\u00f4ng c\u1ea7n th\u00eam t\u00ean c\u1ee7a trang t\u00ednh v\u00e0o, v\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c[D:Excel filesBook1.xlsx]Source_data\u201d,\u201dSource data\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft \u0111\u1ec3 m\u1edf t\u1ec7p tin l\u01b0u tr\u1eef trong \u1ed5 c\u1ee9ng:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t li\u00ean k\u1ebft m\u1edf c\u00e1c v\u0103n b\u1ea3n kh\u00e1c, c\u1ea7n x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi c\u00e1c v\u0103n b\u1ea3n \u0111\u00f3 theo \u0111\u1ecbnh d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\">\u201cDrive:FolderFile_name.extension\u201d<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 m\u1edf m\u1ed9t v\u0103n b\u1ea3n Word c\u00f3 t\u00ean\u00a0<em>Price list <\/em>\u00a0\u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong th\u01b0 m\u1ee5c\u00a0<em>Word files<\/em>\u00a0\u1edf \u1ed5 D, s\u1eed d\u1ee5ng h\u00e0m sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201cD:Word filesPrice list.docx\u201d,\u201dPrice list\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft t\u1edbi m\u1ed9t d\u1ea5u trang trong Word<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t v\u00f9ng c\u1ee5 th\u1ec3 trong Word, \u0111i\u1ec1n \u0111\u01b0\u1eddng d\u1eabn c\u1ee7a v\u0103n b\u1ea3n trong [d\u1ea5u ngo\u1eb7c vu\u00f4ng] v\u00e0 s\u1eed d\u1ee5ng m\u1ed9t d\u1ea5u trang \u0111\u1ec3 t\u00ecm ra \u0111\u1ecba \u0111i\u1ec3m c\u1ea7n \u0111\u1ecbnh v\u1ecb t\u1edbi.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, h\u00e0m sau th\u00eam li\u00ean k\u1ebft t\u1edbi d\u1ea5u trang c\u00f3 t\u00ean Subscription_prices trong v\u0103n b\u1ea3n Price list.docx:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c[D:Word filesPrice list.docx]Subscription_prices\u201d,\u201dPrice list\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t t\u1ec7p tin trong m\u1ea1ng li\u00ean k\u1ebft<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 m\u1edf m\u1ed9t t\u1ec7p tin \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong m\u1ea1ng c\u1ee5c b\u1ed9, \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn t\u1ec7p tin c\u00f3 d\u1ea1ng UNC (Universal Naming Convention- \u00a0\u0110\u1ecbnh d\u1ea1ng C\u00f4ng \u01b0\u1edbc Nam \u0110\u1ecbnh Qu\u1ed1c t\u1ebf ) s\u1eed d\u1ee5ng d\u1ea5u g\u1ea1ch ch\u00e9o ng\u01b0\u1ee3c g\u1ea5p \u0111\u00f4i tr\u01b0\u1edbc t\u00ean c\u1ee7a m\u00e1y ch\u1ee7, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\u201c\\Server_nameFolderFile_name.extension\u201d<\/p>\n<p style=\"text-align: justify\">H\u00e0m d\u01b0\u1edbi \u0111\u00e2y t\u1ea1o m\u1ed9t li\u00ean k\u1ebft c\u00f3 t\u00ean \u201cPrice list\u201d \u0111\u1ec3 m\u1edf b\u1ea3ng t\u00ednh\u00a0<em>Price list.xlsx<\/em>\u00a0\u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong\u00a0<em>SERVER1<\/em>, th\u01b0 m\u1ee5c\u00a0<em>Svetlana<\/em>\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c\\SERVER1SvetlanaPrice list.xlsx\u201d, \u201cPrice list\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 m\u1edf m\u1ed9t t\u1ec7p tin Excel t\u1ea1i m\u1ed9t b\u1ea3ng t\u00ednh c\u1ed1 \u0111\u1ecbnh, \u0111i\u1ec1n t\u00ean \u0111\u01b0\u1eddng d\u1eabn t\u1edbi t\u1ec7p tin trong ngo\u1eb7c vu\u00f4ng [ ], c\u00f3 bao g\u1ed3m t\u00ean trang t\u00ednh k\u00e8m d\u1ea5u ch\u1ea5m than \u0111\u1eb1ng sau v\u00e0 \u00f4 tham chi\u1ebfu:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201c[\\SERVER1SvetlanaPrice list.xlsx]Sheet4!A1\u201d, \u201cPrice list\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang web<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t trang web trong Internet hay m\u1ea1ng n\u1ed9i b\u1ed9, \u0111i\u1ec1n URL trong d\u1ea5u ngo\u1eb7c k\u00e9p, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201chttps:\/\/www.ablebits.com\u201d,\u201dGo to Ablebits.com\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m tr\u00ean ch\u00e8n m\u1ed9t li\u00ean k\u1ebft c\u00f3 t\u00ean \u201cGo to Ablebits.com\u201d, s\u1ebd m\u1edf trang ch\u1ee7 c\u1ee7a trang web.<\/p>\n<p style=\"text-align: justify\"><strong>Li\u00ean k\u1ebft \u0111\u1ec3 g\u1eedi email<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 vi\u1ebft email m\u1edbi t\u1edbi m\u1ed9t ng\u01b0\u1eddi nh\u1eadn c\u1ee5 th\u1ec3, c\u1ea7n \u0111\u1ec3 \u0111\u1ecba ch\u1ec9 email theo d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\">\u201cmailto:email_address\u201d<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\"><strong>=HYPERLINK(\u201cmailto:support@ablebits.com\u201d,\u201dDrop us an email\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m tr\u00ean ch\u00e8n li\u00ean k\u1ebft c\u00f3 ti\u00eau \u0111\u1ec1 \u201cDrop us an email\u201d, v\u00e0 nh\u1ea5p chu\u1ed9t \u0111\u1ec3 t\u1ea1o m\u1ed9t tin nh\u1eafn m\u1edbi t\u1edbi t\u1ed5 h\u1ed7 tr\u1ee3 c\u1ee7a ch\u00fang ta.<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m Vlookup v\u00e0 li\u00ean k\u1ebft \u0111\u1ebfn k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean t\u00ecm \u0111\u01b0\u1ee3c<\/strong><\/p>\n<p style=\"text-align: justify\">Khi ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t t\u1ec7p d\u1eef li\u1ec7u l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p tr\u01b0\u1eddng h\u1ee3p khi c\u1ea7n t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3, sau \u0111\u00f3 l\u1ea1i l\u1ea1i tr\u1ea3 v\u1ec1 m\u1ee5c d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng \u1edf m\u1ed9t c\u1ed9t kh\u00e1c. L\u00fac n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/to-chuc-du-lieu-tranh-loi-vlookup.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m VLOOKUP<\/a> s\u1ebd tr\u1edf n\u00ean thi\u1ebft y\u1ebfu hay th\u1eadm ch\u00ed c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi<a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"> INDEX MATCH<\/a> \u0111\u1ec3 t\u00ecm<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n v\u1eeba mu\u1ed1n t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p, l\u1ea1i v\u1eeba mu\u1ed1n \u0111i t\u1edbi v\u1ecb tr\u00ed \u0111\u00f3 trong t\u1ec7p d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u1ec3 xem c\u00e1c chi ti\u1ebft kh\u00e1c trong c\u00f9ng m\u1ed9t h\u00e0ng th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? R\u1ea5t \u0111\u01a1n gi\u1ea3n, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c b\u1eb1ng h\u00e0m HYPERLINK trong Excel k\u1ebft h\u1ee3p v\u1edbi CELL, INDEX v\u00e0 MATCH.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t \u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft s\u1ebd \u0111\u01b0a ra k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>HYPERLINK(\u201c#\u201d&amp;CELL(\u201caddress\u201d, INDEX(<\/strong><strong>return_range<\/strong><strong>, MATCH(<\/strong><strong>lookup_value<\/strong><strong>,\u00a0<\/strong><strong>lookup_range<\/strong><strong>,0))), INDEX(<\/strong><strong>return_range<\/strong><strong>, MATCH(<\/strong><strong>lookup_value, lookup_range<\/strong><strong>,0)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">H\u00e3y tham kh\u1ea3o th\u00eam c\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00f4ng th\u1ee9c tr\u00ean,<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xem c\u00f4ng th\u1ee9c tr\u00ean c\u00f3 ho\u1ea1t \u0111\u1ed9ng, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c nh\u00e0 cung c\u1ea5p trong c\u1ed9t A, v\u00e0 c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c b\u00e1n ra trong c\u1ed9t C. B\u1ea1n mu\u1ed1n k\u00e9o s\u1ea3n ph\u1ea9m \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c b\u00e1n b\u1edfi m\u1ed9t nh\u00e0 cung c\u1ea5p nh\u1ea5t \u0111\u1ecbnh v\u00e0 t\u1ea1o m\u1ed9t li\u00ean k\u1ebft t\u1edbi m\u1ed9t s\u1ed1 \u00f4 trong c\u00f9ng h\u00e0ng \u0111\u00f3 \u0111\u1ec3 c\u00f3 th\u1ec3 xem l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c chi ti\u1ebft kh\u00e1c li\u00ean quan theo th\u1ee9 t\u1ef1 c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">V\u1edbi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 E2, danh s\u00e1ch c\u00e1c nh\u00e0 cung c\u1ea5p ( h\u00e0ng t\u00ecm ki\u1ebfm) \u1edf v\u00f9ng A2 \u0111\u1ebfn A10 v\u00e0 danh s\u00e1ch c\u00e1c s\u1ea3n ph\u1ea9m ( d\u00f2ng tr\u1ea3 v\u1ec1) n\u1eb1m \u1edf v\u00f9ngC2 \u0111\u1ebfn C10, h\u00e0m c\u00f3 d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=HYPERLINK(\u201c#\u201d&amp;CELL(\u201caddress\u201d, INDEX($C$2:$C$10, MATCH($E2,$A$2:$A$10,0))), INDEX($C$2:$C$10, MATCH($E2,$A$2:$A$10,0)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c s\u1ebd k\u00e9o gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p v\u00e0 chuy\u1ec3n n\u00f3 th\u00e0nh m\u1ed9t li\u00ean k\u1ebft c\u00f3 th\u1ec3 nh\u1ea5p \u0111\u1ec3 h\u01b0\u1edbng ng\u01b0\u1eddi d\u00f9ng \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ee7a k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm \u0111\u1ea7u ti\u00ean trong s\u1ed1 li\u1ec7u ban \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-hyperlink-first-match.png\" alt=\"Vlookup and create a hyperlink to the first match\" title=\"excel-hyperlink-first-match\"><\/p>\n<p style=\"text-align: justify\">Khi x\u1eed l\u00fd m\u1ed9t d\u00f2ng d\u1eef li\u1ec7u d\u00e0i, c\u00f4ng vi\u1ec7c s\u1ebd tr\u1edf n\u00ean ti\u1ec7n l\u1ee3i h\u01a1n khi c\u00f3 li\u00ean k\u1ebft \u0111\u01b0ua b\u1ea1n \u0111\u1ec3 \u00f4 \u0111\u1ea7u ti\u00ean trong d\u00f2ng c\u00f3 k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm ph\u00f9 h\u1ee3p. \u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1eb7t ph\u1ea1m vi tr\u1ea3 k\u1ebft qu\u1ea3 trong INDEX MATCH \u0111\u1ea7u ti\u00ean \u1edf c\u1ed9t A ( trong v\u00ed d\u1ee5 n\u00e0y l\u00e0: ($A$2:$A$10)<\/p>\n<p style=\"text-align: justify\"><em><strong>=HYPERLINK(\u201c#\u201d&amp;CELL(\u201caddress\u201d, INDEX($A$2:$A$10, MATCH($E2,$A$2:$A$10,0))), INDEX($C$2:$C$10, MATCH($E2,$A$2:$A$10,0)))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">H\u00e0m n\u00e0y s\u1ebd \u0111\u01b0a b\u1ea1n \u0111\u1ebfn v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u00f3 k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm (\u201cAdam\u201d) trong d\u1eef li\u1ec7u:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/excel-hyperlink-first-match2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23020\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-hyperlink-first-match2.png\" width=\"526\" height=\"287\" title=\"excel-hyperlink-first-match2\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi nh\u1eefng b\u1ea1n \u0111\u00e3 quen s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH nh\u01b0 m\u1ed9t s\u1ef1 thay th\u1ebf linh ho\u1ea1t cho h\u00e0m VLOOKUP, c\u00f3 th\u1ec3 nh\u00ecn ra \u0111\u01b0\u1ee3c t\u1ed5ng th\u1ec3 logic t\u1ed5ng th\u1ec3.<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m c\u1ed1t l\u00f5i n\u1eb1m \u1edf vi\u1ec7c b\u1ea1n s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p INDEX MATCH\u00a0\u0111\u1ec3 t\u00ecm ra k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi t\u00ecm ki\u1ebfm:<\/p>\n<p style=\"text-align: justify\"><strong>INDEX(<\/strong><strong><em>return_range<\/em><\/strong><strong>, MATCH(<\/strong><strong><em>lookup_value<\/em><\/strong><strong>,\u00a0<\/strong><strong><em>lookup_range<\/em><\/strong><strong>, 0))<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft v\u1ec1 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y trong li\u00ean k\u1ebft \u1edf tr\u00ean. \u1ede b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd \u0111\u01b0a ra cho b\u1ea1n c\u00e1c \u0111i\u1ec3m ch\u00ednh:<\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m MATCH d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u2013 \u201cAdam\u201d trong kho\u1ea3ng t\u1eeb A2 \u0111\u1ebfn A10 ( ph\u1ea1m vi t\u00ecm ki\u1ebfm), sau \u0111\u00f3 quay tr\u1edf l\u1ea1i 3.<\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ee7a MATCH \u0111\u01b0\u1ee3c \u0111\u01b0a \u0111\u1ebfn \u0111\u1ed1i s\u1ed1\u00a0<em>row_num <\/em>trong h\u00e0m INDEX \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn quay tr\u1edf l\u1ea1i d\u00f2ng th\u1ee9 3 trong v\u00f9ng t\u1eeb C2 \u0111\u1ebfn C10 ( v\u00f9ng tr\u1edf l\u1ea1i). V\u00e0 h\u00e0m INDEX tr\u1edf l\u1ea1i v\u1edbi \u201c<em>Lemons<\/em>\u201c.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ed1i s\u1ed1\u00a0<em>friendly_name<\/em>\u00a0trong c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Hyperlink.<\/p>\n<p style=\"text-align: justify\">C\u00f2n b\u00e2y gi\u1edd, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u \u0111\u1ed1i s\u1ed1 <em>link_location, <\/em>t\u1ee9c l\u00e0 \u00f4 m\u00e0 li\u00ean k\u1ebft ch\u1ec9 t\u1edbi. \u0110\u1ec3 l\u1ea5y \u0111\u1ecba ch\u1ec9 \u00f4, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m CELL(\u201caddress\u201d, [reference]) v\u1edbi tham chi\u1ebfu INDEX MATCH. \u0110\u1ed1i v\u1edbi h\u00e0m HYPERLINL \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 m\u1ee5c ti\u00eau trong trang t\u00ednh hi\u1ec7n t\u1ea1i, n\u1ed1i c\u00e1c \u0111\u1ecba ch\u1ec9 b\u1eb1ng k\u00fd t\u1ef1 (\u201c#\u201d).<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd. C\u1ea7n l\u01b0u \u00fd vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 s\u1eeda t\u00ecm ki\u1ebfm v\u00e0 v\u00f9ng tr\u1edf l\u1ea1i. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng n\u1ebfu b\u1ea1n mu\u1ed1n ch\u00e8n nhi\u1ec1u li\u00ean k\u1ebft b\u1eb1ng c\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-excel-co-ban-hoc-excel-trong-vong-1-gio.html\">B\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u2013 h\u1ecdc Excel trong v\u00f2ng 1 gi\u1edd<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chinh_sua_nhieu_lien_ket_mot_luc\"><\/span><strong>C\u00e1ch ch\u1ec9nh s\u1eeda nhi\u1ec1u li\u00ean k\u1ebft m\u1ed9t l\u00fac:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 n\u00f3i t\u1eeb \u0111\u1ea7u, m\u1ed9t trong nh\u1eefng l\u1ee3i \u00edch h\u1eefu d\u1ee5ng nh\u1ea5t c\u1ee7a h\u00e0m Hyperlonk \u0111\u00f3 l\u00e0 kh\u1ea3 n\u0103ng ch\u1ec9nh s\u1eeda nhi\u1ec1u h\u00e0m Hyperlink m\u1ed9t l\u00fac ch\u1ec9 b\u1eb1ng t\u00ednh n\u0103ng <em>Replace All <\/em>c\u1ee7a Excel<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n thay c\u00e1c URL c\u1ee7a c\u00e1c c\u00f4ng ty c\u0169 (old- website.com) th\u00e0nh c\u00e1c URL m\u1edbi ( new- website.com) trong t\u1ea5t c\u1ea3 c\u00e1c li\u00ean k\u1ebft trong trang t\u00ednh hi\u1ec7n t\u1ea1i ho\u1eb7c trong to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh, c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm\u00a0Ctrl + H\u0111\u1ec3 m\u1edf thanh\u00a0<strong>Replace<\/strong>\u00a0tr\u00ean h\u1ed9p tho\u1ea1i\u00a0<em>Find and Replace<\/em>\u00a0.<\/li>\n<li>B\u00ean ph\u1ea3i h\u1ed9p tho\u1ea1i, nh\u1eadp chu\u1ed9t v\u00e0o n\u00fat\u00a0<strong>Options<\/strong>.<\/li>\n<li>Trong \u00f4\u00a0<em>Find what<\/em>, nh\u1eadp \u0111o\u1ea1n v\u0103n b\u1ea3n mu\u1ed1n thay \u0111\u1ed5i (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u201cold-website.com\u201d).<\/li>\n<li>Trong danh s\u00e1ch cu\u1ed9n\u00a0<em>Within<\/em>, ch\u1ecdn <strong>Sheet<\/strong>ho\u1eb7c\u00a0<strong>Workbook<\/strong>\u00a0ph\u1ee5 thu\u1ed1c v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft trong trang t\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i hay \u00e1p d\u1ee5ng chung cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh.<\/li>\n<li>Trong danh s\u00e1ch cu\u1ed9n\u00a0<em>Look in<\/em>, ch\u1ecdn <strong>Formulas<\/strong>.<\/li>\n<li>\u0110\u1ec3 ch\u1eafc ch\u1eafn, tr\u01b0\u1edbc ti\u00ean h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>Find All<\/strong>, v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch c\u1ee7a t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a \u0111o\u1ea1n v\u0103n b\u1ea3n t\u00ecm ki\u1ebfm:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/find-all-hyperlink-formulas-06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32329\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-all-hyperlink-formulas-06.png\" width=\"555\" height=\"386\" title=\"find-all-hyperlink-formulas-06\"><\/a><\/li>\n<li>H\u00e3y xem qua c\u00e1c k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c t\u00ecm \u0111\u01b0\u1ee3c. N\u1ebfu kh\u00f4ng, h\u00e3y \u0111i \u0111\u1ebfn b\u01b0\u1edbc ti\u1ebfp theo, ho\u1eb7c c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm l\u1ea1i.<\/li>\n<li>Trong h\u1ed9p\u00a0<em>Replace with<\/em>, nh\u1eadp \u0111o\u1ea1n v\u0103n b\u1ea3n m\u1edbi (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0\u201dnew-website.com\u201d).<\/li>\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat\u00a0<strong>Replace All<\/strong>\u00a0. Excel s\u1ebd thay th\u1ebf v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong t\u1ea5t c\u1ea3 c\u00e1c li\u00ean k\u1ebft v\u00e0 th\u00f4ng b\u00e1o v\u1edbi b\u1ea1n c\u00f3 bao nhi\u00eau thay \u0111\u1ed5i \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/edit-multiple-hyperlink-formulas-09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32330\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-multiple-hyperlink-formulas-09.png\" width=\"618\" height=\"370\" title=\"edit-multiple-hyperlink-formulas-09\"><\/a><\/li>\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat\u00a0<strong>Close.\u00a0<\/strong>V\u1eady l\u00e0 xong!<\/li>\n<\/ol>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda v\u0103n b\u1ea3n li\u00ean k\u1ebft (friendly_name) trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m Hyperlink m\u1ed9t l\u00fac. Khi l\u00e0m nh\u01b0 v\u1eady, h\u00e3y ch\u1eafc ch\u1eafn \u0111\u1ec3 ki\u1ec3m tra xem v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c thay th\u1ebf trong friendly_name kh\u00f4ng xu\u1ea5t hi\u1ec7n b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o trong link_location \u0111\u1ec3 b\u1ea1n s\u1ebd kh\u00f4ng ph\u00e1 v\u1ee1 c\u00e1c c\u00f4ng th\u1ee9c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nguyen_nhan_va_giai_phap_doi_voi_ham_Hyperlink_khong_hoat_dong\"><\/span><strong>Nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p \u0111\u1ed1i v\u1edbi h\u00e0m Hyperlink kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">L\u00fd do ph\u1ed5 bi\u1ebfn nh\u1ea5t khi\u1ebfn h\u00e0m Hyperlink kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng (v\u00e0 \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean c\u1ea7n ki\u1ec3m tra!) \u0111\u00f3 l\u00e0 \u0111\u01b0\u1eddng d\u1eabn kh\u00f4ng t\u1ed3n t\u1ea1i ho\u1eb7c b\u1ecb h\u1ecfng trong \u0111\u1ed1i s\u1ed1 link_location. N\u1ebfu kh\u00f4ng, h\u00e3y ki\u1ec3m tra hai \u0111i\u1ec1u sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>N\u1ebfu \u0111\u1ecba ch\u1ec9 \u0111\u1ebfn c\u1ee7a li\u00ean k\u1ebft kh\u00f4ng m\u1edf khi b\u1ea1n nh\u1ea5p v\u00e0o , \u0111\u1ea3m b\u1ea3o r\u1eb1ng v\u1ecb tr\u00ed li\u00ean k\u1ebft \u0111\u01b0\u1ee3c cung c\u1ea5p theo \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o ra c\u00e1c ki\u1ec3u li\u00ean k\u1ebft kh\u00e1c nhau c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y \u1edf \u0111\u00e2y.<\/li>\n<li>N\u1ebfu thay v\u00ec li\u00ean k\u1ebft v\u0103n b\u1ea3n m\u1ed9t l\u1ed7i nh\u01b0 VALUE! Ho\u1eb7c N \/ A xu\u1ea5t hi\u1ec7n trong m\u1ed9t \u00f4, r\u1ea5t c\u00f3 th\u1ec3 v\u1ea5n \u0111\u1ec1 l\u00e0 v\u1edbi \u0111\u1ed1i s\u1ed1 friendly_name trong h\u00e0m Hyperlink c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, c\u00e1c l\u1ed7i nh\u01b0 v\u1eady x\u1ea3y ra khi friendly_name \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c, nh\u01b0 trong Vlookup c\u1ee7a ch\u00fang ta v\u00e0 li\u00ean k\u1ebft \u0111\u1ebfn k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm \u0111\u1ea7u ti\u00ean (Vlookup and hyperlink to the first match<u>)<\/u>. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, l\u1ed7i # N \/ A s\u1ebd hi\u1ec3n th\u1ecb trong \u00f4 c\u00f4ng th\u1ee9c n\u1ebfu gi\u00e1 tr\u1ecb tra c\u1ee9u kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong b\u1ea3ng tra c\u1ee9u. \u0110\u1ec3 ng\u0103n c\u00e1c l\u1ed7i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 xem x\u00e9t s\u1eed d\u1ee5ng h\u00e0m\u00a0<u>IFERROR <\/u>\u0111\u1ec3 hi\u1ec3n th\u1ecb m\u1ed9t chu\u1ed7i r\u1ed7ng ho\u1eb7c m\u1ed9t s\u1ed1 v\u0103n b\u1ea3n th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi s\u1eed d\u1ee5ng thay v\u00ec gi\u00e1 tr\u1ecb l\u1ed7i.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch t\u1ea1o li\u00ean k\u1ebft b\u1eb1ng s\u1eed d\u1ee5ng h\u00e0m HYPERLINK. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i trong b\u00e0i vi\u1ebft tu\u1ea7n sau!<\/p>\n<p style=\"text-align: justify\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">ho\u0323c Excel c\u01a1 ba\u0309n<\/a>\u00a0cho \u0111\u00ea\u0301n n\u00e2ng cao v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u01b0\u0300ng tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p>\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\/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-35.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1321","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\/1321","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=1321"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1321\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1322"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}