{"id":1045,"date":"2024-12-02T03:58:37","date_gmt":"2024-12-02T03:58:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi\/"},"modified":"2024-12-02T03:58:37","modified_gmt":"2024-12-02T03:58:37","slug":"tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi\/","title":{"rendered":"T\u1ea1i sao h\u00e0m LOOKUP l\u1ea1i t\u00ecm 2, v\u00e0 1\/ l\u00e0 g\u00ec? 9.99E+307 l\u00e0 g\u00ec?"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u t\u1ea1i c\u1ed9t A, v\u00e0 c\u00e1c c\u00e2u h\u1ecfi \u0111\u1eb7t ra, l\u00e0m th\u1ebf n\u00e0o d\u00f9ng h\u00e0m \u0111\u1ec3 t\u00ecm th\u1ea5y d\u00f2ng cu\u1ed1i c\u00f9ng trong c\u1ed9t, ho\u1eb7c l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ecm \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a ch\u1eef, ho\u1eb7c t\u00ecm \u00f4 cu\u1ed1i c\u00f9ng l\u00e0 s\u1ed1. B\u1ea1n c\u00f3 th\u1ec3 xem qua b\u1ea3ng minh h\u1ecda b\u00ean d\u01b0\u1edbi. Sau \u0111\u00f3, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 t\u1eebng ph\u1ea7n nh\u00e9.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/lookup-2-1-99E-307-vi-sao.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19665 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-2-1-99e-307-vi-sao.jpg\" width=\"706\" height=\"338\" title=\"lookup-2-1-99e-307-vi-sao\"><\/a><\/p>\n<ul>\n<li>\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-674d306c3a423\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi.html#Ung_dung_cua_ham_LOOKUP_nhu_the_nao\" title=\"\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP nh\u01b0 th\u1ebf n\u00e0o?\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi.html#Ham_LOOKUP_la_gi\" title=\"H\u00e0m LOOKUP l\u00e0 g\u00ec?\">H\u00e0m LOOKUP l\u00e0 g\u00ec?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-ham-lookup-lai-tim-2-va-1-la-gi-9-99e307-la-gi.html#Chu_thich\" title=\"Ch\u00fa th\u00edch\">Ch\u00fa th\u00edch<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_cua_ham_LOOKUP_nhu_the_nao\"><\/span>\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m LOOKUP nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>LOOKUP(2,1\/(A:A&lt;&gt;\u201d\u201d),A:A). V\u00ec sao l\u1ea1i t\u00ecm s\u1ed1 2, v\u00e0 1\/(A:A&lt;&gt;\u201d\u201d) l\u00e0 g\u00ec?<\/strong><\/li>\n<\/ul>\n<p><strong>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/strong> (lookup_value) l\u00e0: 2, <strong>t\u1ea1i sao l\u1ea1i c\u00f3 s\u1ed1 2<\/strong>? \u0110\u01a1n gi\u1ea3n v\u00ec s\u1ed1 2 ho\u1eb7c b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o l\u1edbn h\u01a1n 1 \u0111\u1ec1u \u0111\u01b0\u1ee3c. B\u1ea1n s\u1ebd hi\u1ec3u h\u01a1n \u1edf gi\u1ea3i th\u00edch ti\u1ebfp theo.<\/p>\n<p><strong>V\u00f9ng t\u00ecm ki\u1ebfm<\/strong>, 1\/(A:A&lt;&gt;\u201d\u201d): \u1ede \u0111\u00e2y ch\u00fang ta th\u1ea5y bi\u1ec3u th\u1ee9c logic (A:A&lt;&gt;\u201d\u201d), k\u1ebft qu\u1ea3 n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE. Ti\u1ebfp theo ta l\u1ea5y 1 chia cho k\u1ebft qu\u1ea3 t\u00ecm th\u1ea5y, 1\/TRUE = 1, 1\/FALSE=1\/0 =&gt; #DIV\/0.\u00a0 V\u00ec v\u1eady trong m\u1ea3ng\u00a0v\u00f9ng t\u00ecm ki\u1ebfm l\u00fac n\u00e0y ch\u1ec9 c\u00f3 2 gi\u00e1 tr\u1ecb 1 v\u00e0 DIV\/0. V\u00e0 khi \u0111\u00f3, LOOKUP s\u1ebd t\u00ecm theo gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 1, s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng cu\u1ed1i \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y v\u00f9ng t\u00ecm ki\u1ebfm.<\/p>\n<p>V\u00e0 cu\u1ed1i c\u00f9ng, l\u00e0 <strong>v\u00f9ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4, ho\u1eb7c l\u00e0 v\u1ecb tr\u00ed c\u1ee7a d\u00f2ng \u0111\u00f3 v\u1edbi h\u00e0m ROW(), ho\u1eb7c COLUMN() \u0111\u1ec3 l\u1ea5y ra c\u1ed9t, t\u00f9y theo \u1ee9ng d\u1ee5ng c\u1ee7a b\u1ea1n.<\/p>\n<p>L\u01b0u \u00fd: V\u00f9ng t\u00ecm ki\u1ebfm v\u00e0 v\u00f9ng gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 ph\u1ea3i c\u00f3 c\u00f9ng s\u1ed1 d\u00f2ng, v\u00ed d\u1ee5: A1:A100, th\u00ec v\u00f9ng k\u1ebft qu\u1ea3 c\u0169ng ph\u1ea3i t\u01b0\u01a1ng t\u1ef1 B1:B100.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u r\u00f5 h\u01a1n, xem x\u00e9t chi ti\u1ebft h\u00e0m ho\u1ea1t \u0111\u1ed9ng, ch\u00fang ta c\u00f3 c\u00f4ng c\u1ee5 <strong>Evaluate Formula<\/strong> n\u1eb1m trong tab <strong>Formulas<\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/evaluate-formula.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19667 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/evaluate-formula.jpg\" width=\"718\" height=\"506\" title=\"evaluate-formula\"><\/a><\/p>\n<ul>\n<li><strong>T\u1ea1i sao l\u1ea1i t\u00ecm \u201cZZZZZ\u201d? N\u00f3 \u0111\u1ea1i di\u1ec7n cho c\u00e1i g\u00ec?\u00a0C\u00f3 ai \u0111\u00f3 \u0111ang ng\u1ee7 g\u1ee5c, v\u00e0 ng\u00e1y ch\u0103ng?<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n, n\u00f3 \u0111\u1ea1i di\u1ec7n cho c\u00e1c k\u00fd t\u1ef1 l\u00e0 ch\u1eef. K\u1ebft qu\u1ea3 s\u1ebd t\u00ecm \u0111\u1ebfn c\u00e1c \u00f4 c\u00f3 ch\u1ee9a ch\u1eef.\u00a0N\u1ebfu c\u00f3 c\u1ea3 ch\u1eef v\u00e0 s\u1ed1 trong \u00f4 th\u00ec th\u1ebf n\u00e0o? D\u0129 nhi\u00ean s\u1ebd v\u1eabn t\u00ecm \u0111\u1ebfn,\u00a0v\u00ec \u00f4 c\u00f3 ch\u1ee9a ch\u1eef m\u00e0.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>T\u1ea1i sao l\u1ea1i c\u00f3 s\u1ed1 <strong>9.999E+307<\/strong>? L\u00e0m sao m\u00e0 <em><strong>Ti\u1ec3u \u0111o\u00e0n 307<\/strong>\u00a0<\/em>r\u1ed3i <em><strong>v\u00e0ng 4 s\u1ed1 9<\/strong><\/em>, l\u1ea1i c\u00f3 m\u1eb7t \u1edf trong <strong>E<\/strong>xcel?<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>9.999E+307, th\u1ef1c ra l\u00e0 s\u1ed1 l\u1edbn nh\u1ea5t (largest number) trong Excel b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp v\u00e0o trong \u00f4. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam <a href=\"https:\/\/support.office.com\/en-us\/article\/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3\" target=\"_blank\" rel=\"noopener noreferrer\">Ca\u0301c \u0111\u0103\u0323c ta\u0309 va\u0300 gi\u01a1\u0301i ha\u0323n trong Excel<\/a>.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><strong>LOOKUP c\u00f2n c\u00f3 th\u1ec3 l\u00e0m g\u00ec kh\u00e1c?<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>B\u1ea1n c\u00f3 th\u1ec3 xem v\u00ed d\u1ee5 minh h\u1ecda b\u00ean d\u01b0\u1edbi, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m IF l\u1ed3ng v\u00e0o nhau cho c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng. Tuy nhi\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m \u0111\u01a1n gi\u1ea3n h\u01a1n, l\u00e0 l\u1eadp b\u1ea3ng tham chi\u1ebfu, ho\u1eb7c vi\u1ebft h\u1eb3n trong h\u00e0m nh\u01b0 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 t\u00ecm ki\u1ebfm.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/IF-nested-lookup.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19668 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-nested-lookup.jpg\" width=\"790\" height=\"171\" title=\"if-nested-lookup\"><\/a><\/p>\n<p>C\u00f2n g\u00ec hay ho h\u01a1n? B\u1ea1n c\u00f3 bi\u1ebft LOOKUP c\u00f3 th\u1ec3 d\u00f2 t\u00ecm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng? Trong v\u00ed d\u1ee5, ch\u00fang ta c\u00f3 2 b\u1ea1n c\u00f9ng t\u00ean: Nguy\u1ec5n A, \u1edf 2 ph\u00f2ng ban v\u00e0 \u0111\u1ecba ch\u1ec9 kh\u00e1c nhau. Ch\u00fang ta t\u00ecm ra \u0111\u01b0\u1ee3c \u0111\u1ecba ch\u1ec9 kh\u00f4ng? D\u0129 nhi\u00ean l\u00e0 c\u00f3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/lookup-2-condition.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19669\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-2-condition.jpg\" width=\"688\" height=\"209\" title=\"lookup-2-condition\"><\/a><\/p>\n<p>D\u00f9ng LOOKUP \u0111\u1ec3 t\u00e1ch \u0111\u1ecba danh, t\u00ean t\u1ec9nh th\u00e0nh qu\u1eadn huy\u1ec7n ra kh\u1ecfi chu\u1ed7i:<\/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-72.gif\" title=\"ex101_92019-nho-72\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>B\u1ea1n l\u1eadp danh s\u00e1ch v\u1ecb tr\u00ed s\u1ebd t\u00ecm ki\u1ebfm (th\u1ea3 neo), \u1edf \u0111\u00e2y\u00a0v\u1edbi vi\u1ec7c t\u00e1ch T\u1ec9nh th\u00e0nh, b\u1ea1n s\u1ebd c\u00f3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p: \u201ct\u1ec9nh\u201d, \u201cTp. H\u1ed3 Ch\u00ed Minh\u201d, \u201cTh\u00e0nh ph\u1ed1 \u0110\u00e0 N\u1eb5ng\u201d\u2026 ta l\u1eadp ra danh s\u00e1ch c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t G.<\/li>\n<li>T\u01b0\u01a1ng \u1ee9ng v\u1edbi vi\u1ec7c t\u00e1ch \u0111\u1ecba danh, b\u1ea1n l\u1eadp v\u1ecb tr\u00ed th\u1ea3 neo \u0111\u1ec3 t\u00ecm ra v\u1ecb tr\u00ed sau \u0111\u1ecba ch\u1ec9. L\u00fac n\u00e0y ta c\u00f3: d\u1ea5u ph\u1ea9y, Th\u00e0nh ph\u1ed1 thu\u1ed9c t\u1ec9nh, Qu\u1eadn\/Huy\u1ec7n\/Th\u1ecb x\u00e3, Ph\u01b0\u1eddng\/X\u00e3\/Th\u1ecb tr\u1ea5n, T\u1ed5\/Th\u00f4n\/X\u00f3m\u2026 B\u1ea1n c\u00f3 th\u1eafc m\u1eafc s\u1eafp x\u1ebfp c\u1ee7a n\u00f3 kh\u00f4ng? M\u00ecnh s\u1eafp nh\u01b0 v\u1eady \u0111\u1ec3 khi\u00a0LOOKUP t\u00ecm ki\u1ebfm s\u1ebd \u01b0u ti\u00ean t\u1eeb d\u01b0\u1edbi l\u00ean, g\u1ea7n v\u1edbi \u0111\u1ecba danh nh\u1ea5t c\u00f3 th\u1ec3.<\/li>\n<li>V\u00e0 h\u00e0m SEARCH l\u00fac n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm t\u1eeb c\u00e1c danh s\u00e1ch tr\u00ean v\u1edbi t\u1eebng d\u00f2ng, v\u00ed d\u1ee5 nh\u01b0 B2, ta c\u00f3 k\u1ebft qu\u1ea3 s\u1ebd t\u00ecm th\u1ea5y l\u00e0 s\u1ed1. V\u00e0 LOOKUP s\u1ebd t\u00ecm k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1, l\u1ed7i s\u1ebd b\u1ecf qua, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd tr\u1ea3 v\u1ec1 N\/A.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/cach-dung-lookup-trim-mid-tach-dia-chi-ra-dia-danh-tinh-thanh-phuong-xa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26607 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-dung-lookup-trim-mid-tach-dia-chi-ra-dia-danh-tinh-thanh-phuong-xa.jpg\" width=\"1001\" height=\"331\" title=\"cach-dung-lookup-trim-mid-tach-dia-chi-ra-dia-danh-tinh-thanh-phuong-xa\"><\/a><\/p>\n<p>B\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm \u1edf nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c nhau \u0111\u1ed3ng th\u1eddi, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00f4ng th\u1ee9c sau:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/LOOKUP-multiple-range.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26339\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-multiple-range.jpg\" width=\"917\" height=\"189\" title=\"lookup-multiple-range\"><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/lookup-nhieu-vung.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26942\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-nhieu-vung.jpg\" width=\"1340\" height=\"309\" title=\"lookup-nhieu-vung\"><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/LOOKUP-tracuu-loai-cong-van.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27885\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-tracuu-loai-cong-van.png\" width=\"646\" height=\"205\" title=\"lookup-tracuu-loai-cong-van\"><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/lookup-tach-chuoi-dia-chi-ra-tinh-thanh-quan-huyen-phuong-xa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31294\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-tach-chuoi-dia-chi-ra-tinh-thanh-quan-huyen-phuong-xa.jpg\" width=\"1209\" height=\"692\" title=\"lookup-tach-chuoi-dia-chi-ra-tinh-thanh-quan-huyen-phuong-xa\"><\/a>LOOKUP k\u1ebft h\u1ee3p v\u1edbi ISNUMBER\/SEARCH \u0111\u1ec3 d\u00f2 t\u00ecm v\u00e0 t\u1eeb \u0111\u00f3 t\u00e1ch ra T\u1ec9nh\/Th\u00e0nh, Qu\u1eadn\/Huy\u1ec7n, Ph\u01b0\u1eddng\/X\u00e3 t\u1eeb chu\u1ed7i \u0111\u1ecba ch\u1ec9 cho s\u1eb5n.<\/p>\n<p>D\u1ef1a theo b\u1ea3ng danh m\u1ee5c t\u1ea3i v\u1ec1 t\u1eeb website T\u1ed5ng c\u1ee5c Th\u1ed1ng k\u00ea:\u00a0<a href=\"http:\/\/www.gso.gov.vn\/dmhc2015\/?fbclid=IwAR0t--ieJQeucJ3FzpGIEvAHUy0PMK7hOXT6XKyijnqWArHfNzr_5njFMKw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" data-lynx-mode=\"asynclazy\" data-lynx-uri=\"https:\/\/l.facebook.com\/l.php?u=http%3A%2F%2Fwww.gso.gov.vn%2Fdmhc2015%2F%3Ffbclid%3DIwAR0t--ieJQeucJ3FzpGIEvAHUy0PMK7hOXT6XKyijnqWArHfNzr_5njFMKw&amp;h=AT3QxPL5G0RKsYsHjnbJvVoUH9M_2OItl0PkVDbwW1rOLerCbvR2uFnptUGEVIY1jNq1_whXeWfffzd2q4VZUZ1pp1xY4BGyb5kV_lQW2AoUiq7DRmJtuxpziTvsBAuN6fL_R79YDQ\">http:\/\/www.gso.gov.vn\/dmhc2015\/<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/LOOKUP-tim-kiem-loai-truong-thpt-chuyen-ban-cong.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27879\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-tim-kiem-loai-truong-thpt-chuyen-ban-cong.png\" width=\"1631\" height=\"819\" title=\"lookup-tim-kiem-loai-truong-thpt-chuyen-ban-cong\"><\/a><\/p>\n<p><strong>L\u1eddi K\u1ebft:<\/strong>\u00a0Th\u1ef1c t\u1ebf \u00e1p d\u1ee5ng, ch\u00fang ta s\u1ebd lu\u00f4n linh \u0111\u1ed9ng, c\u00e1c \u00e1p d\u1ee5ng c\u01a1 b\u1ea3n, ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ebfn c\u00e1c h\u00e0m nh\u01b0 VLOOKUP, ho\u1eb7c HLOOKUP c\u1ee5 th\u1ec3 h\u01a1n. V\u00e0 \u0111i\u1ec1u l\u01b0u \u00fd lu\u00f4n ph\u1ea3i nh\u1edb v\u1edbi h\u00e0m n\u00e0y, t\u00ecm g\u1ea7n \u0111\u00fang n\u00ean l\u00e0 khi ch\u00fang ta s\u1eafp x\u1ebfp (SORT) th\u00ec k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 thay \u0111\u1ed5i, n\u00ean ch\u00fang ta c\u1ea7n xem x\u00e9t k\u1ef9 tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 gi\u1edbi thi\u1ec7u c\u1ee7a Microsoft v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\" target=\"_blank\" rel=\"noopener noreferrer\">LOOKUP<\/a><\/strong>, c\u00e1c b\u1ea1n tham kh\u1ea3o nh\u00e9!<\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Ham_LOOKUP_la_gi\"><\/span>H\u00e0m LOOKUP l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<section class=\"ocpSection\">\n<h3 class=\"\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>LOOKUP(lookup_value, lookup_vector, [result_vector])<\/p>\n<p>Cu\u0301 pha\u0301p da\u0323ng vector cu\u0309a ha\u0300m\u00a0<b class=\"ocpLegacyBold\">LOOKUP<\/b>\u00a0co\u0301 ca\u0301c tham \u0111\u1ed1i sau \u0111\u00e2y:<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">lookup_value<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. Gia\u0301 tri\u0323 ma\u0300 ha\u0300m\u00a0<b class=\"ocpLegacyBold\">LOOKUP<\/b>\u00a0ti\u0300m ki\u00ea\u0301m trong vector th\u01b0\u0301 nh\u00e2\u0301t.\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">Lookup_value<\/i><\/b>\u00a0co\u0301 th\u00ea\u0309 la\u0300 s\u00f4\u0301, v\u0103n ba\u0309n, gia\u0301 tri\u0323 logic, t\u00ean ho\u0103\u0323c tham chi\u00ea\u0301u t\u01a1\u0301i m\u00f4\u0323t gia\u0301 tri\u0323.<\/li>\n<li><b class=\"ocpRunInHead\">lookup_vector<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. Pha\u0323m vi chi\u0309 ch\u01b0\u0301a m\u00f4\u0323t ha\u0300ng ho\u0103\u0323c m\u00f4\u0323t c\u00f4\u0323t. Gia\u0301 tri\u0323 trong\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_vector<\/i><\/b>\u00a0co\u0301 th\u00ea\u0309 la\u0300 v\u0103n ba\u0309n, s\u00f4\u0301 ho\u0103\u0323c gia\u0301 tri\u0323 logic.\n<div class=\"ocpAlert\">\n<p class=\"ocpAlertSection\">[alert-success]<b class=\"ocpNote\">Quan tr\u1ecdng:<\/b>\u00a0Ca\u0301c gia\u0301 tri\u0323 trong\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_vector<\/i><\/b>\u00a0pha\u0309i \u0111\u01b0\u01a1\u0323c x\u00ea\u0301p theo th\u01b0\u0301 t\u01b0\u0323 t\u0103ng d\u00e2\u0300n: \u2026, -2, -1, 0, 1, 2, \u2026, A-Z, FALSE, TRUE; n\u00ea\u0301u kh\u00f4ng, ha\u0300m\u00a0<b class=\"ocpLegacyBold\">LOOKUP<\/b>\u00a0co\u0301 th\u00ea\u0309 tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 kh\u00f4ng chi\u0301nh xa\u0301c. V\u0103n b\u1ea3n ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng t\u01b0\u01a1ng \u0111\u01b0\u01a1ng nhau.[\/alert-success]<\/p>\n<\/div>\n<\/li>\n<li>\n<p class=\"\"><b class=\"ocpRunInHead\">result_vector<\/b>\u00a0\u00a0\u00a0\u00a0Tu\u0300y cho\u0323n. Pha\u0323m vi chi\u0309 ch\u01b0\u0301a m\u00f4\u0323t ha\u0300ng hay m\u1ed9t c\u00f4\u0323t. Tham \u0111\u1ed1i\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">result_vector<\/i><\/b>\u00a0pha\u0309i co\u0301 cu\u0300ng ki\u0301ch c\u1ee1 v\u01a1\u0301i\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_vector<\/i><\/b>. N\u00f3 ph\u1ea3i c\u00f9ng m\u1ed9t k\u00edch c\u1ee1.<\/p>\n<\/li>\n<\/ul>\n<\/section>\n<section class=\"ocpSection\">\n<h3><span class=\"ez-toc-section\" id=\"Chu_thich\"><\/span>Ch\u00fa th\u00edch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>N\u00ea\u0301u ha\u0300m\u00a0<b class=\"ocpLegacyBold\">LOOKUP<\/b>\u00a0kh\u00f4ng ti\u0300m th\u00e2\u0301y\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_value<\/i><\/b>, thi\u0300 no\u0301 se\u0303 so kh\u01a1\u0301p gia\u0301 tri\u0323 l\u01a1\u0301n nh\u00e2\u0301t trong\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_vector <\/i><\/b>ma\u0300 gia\u0301 tri\u0323 \u0111o\u0301 nho\u0309 h\u01a1n ho\u0103\u0323c b\u0103\u0300ng\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_value<\/i><\/b>.<\/li>\n<li>N\u00ea\u0301u\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_value<\/i><\/b>\u00a0nho\u0309 h\u01a1n gia\u0301 tri\u0323 nho\u0309 nh\u00e2\u0301t trong\u00a0<b class=\"ocpLegacyBold\"><i class=\"ocpItalic\">lookup_vector<\/i><\/b>, thi\u0300 ha\u0300m\u00a0<b class=\"ocpLegacyBold\">LOOKUP<\/b>\u00a0tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 l\u00f4\u0303i #N\/A.<\/li>\n<\/ul>\n<\/section>\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-72.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1045","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\/1045","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=1045"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1046"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}