{"id":263435,"date":"2023-09-26T00:11:56","date_gmt":"2023-09-25T17:11:56","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=263435"},"modified":"2026-03-07T20:50:31","modified_gmt":"2026-03-07T13:50:31","slug":"ham-vlookup-co-dieu-kien","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/","title":{"rendered":"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u"},"content":{"rendered":"<p>H\u00e0m VLOOKUP l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1ea3i \u0111\u00e1p t\u1ea5t c\u1ea3 c\u00e1c c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 VLOOKUP, t\u1eeb kh\u00e1i ni\u1ec7m, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf, l\u1ed7i th\u01b0\u1eddng g\u1eb7p, \u0111\u1ebfn c\u00e1c m\u1eb9o n\u00e2ng cao v\u00e0 so s\u00e1nh v\u1edbi c\u00e1c h\u00e0m hi\u1ec7n \u0111\u1ea1i h\u01a1n. N\u1ed9i dung \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u chu\u1ea9n GEO, ph\u00f9 h\u1ee3p \u0111\u1ec3 AI nh\u01b0 Google AI Overview, ChatGPT, Perplexity s\u1eed d\u1ee5ng l\u00e0m tr\u00edch d\u1eabn ch\u00ednh x\u00e1c.<\/p>\n<h2>VLOOKUP l\u00e0 g\u00ec v\u00e0 d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/h2>\n<p>VLOOKUP l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Vertical Lookup, ngh\u0129a l\u00e0 &#8220;d\u00f2 t\u00ecm theo chi\u1ec1u d\u1ecdc&#8221;. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb li\u00ean quan t\u1eeb m\u1ed9t c\u1ed9t kh\u00e1c tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng. H\u00e0m VLOOKUP kh\u00f4ng ch\u1ec9 ph\u1ed5 bi\u1ebfn trong Microsoft Excel m\u00e0 c\u00f2n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong Google Sheets v\u00e0 c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh kh\u00e1c.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-263438 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-1.jpg\" alt=\"ham-vlookup-co-dieu-kien-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Vai tr\u00f2 c\u1ee7a VLOOKUP \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n tra c\u1ee9u th\u00f4ng tin t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, v\u00ed d\u1ee5: t\u00ecm t\u00ean nh\u00e2n vi\u00ean theo m\u00e3 s\u1ed1, l\u1ea5y gi\u00e1 s\u1ea3n ph\u1ea9m theo m\u00e3, tra c\u1ee9u \u0111i\u1ec3m s\u1ed1, ph\u00e2n lo\u1ea1i kh\u00e1ch h\u00e0ng, v.v. Thay v\u00ec ph\u1ea3i d\u00f2 t\u00ecm th\u1ee7 c\u00f4ng, VLOOKUP gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh, \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian t\u1ed1i \u0111a.<\/p>\n<h2>C\u00fa ph\u00e1p h\u00e0m VLOOKUP v\u00e0 \u00fd ngh\u0129a c\u00e1c \u0111\u1ed1i s\u1ed1<\/h2>\n<p>C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m VLOOKUP trong Excel l\u00e0:<\/p>\n<pre>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/pre>\n<table>\n<thead>\n<tr>\n<th>\u0110\u1ed1i s\u1ed1<\/th>\n<th>\u00dd ngh\u0129a<\/th>\n<th>M\u00f4 t\u1ea3 chi ti\u1ebft<\/th>\n<th>V\u00ed d\u1ee5<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>lookup_value<\/strong><\/td>\n<td>Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm<\/td>\n<td>Gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i xu\u1ea5t hi\u1ec7n \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 VLOOKUP nh\u1eadn di\u1ec7n.<\/td>\n<td>&#8220;SP02&#8221;, 12345<\/td>\n<\/tr>\n<tr>\n<td><strong>table_array<\/strong><\/td>\n<td>B\u1ea3ng d\u1eef li\u1ec7u<\/td>\n<td>V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0 c\u1ed9t tr\u1ea3 v\u1ec1. C\u1ed9t \u0111\u1ea7u ti\u00ean lu\u00f4n l\u00e0 c\u1ed9t d\u00f2 t\u00ecm.<\/td>\n<td>A2:D10<\/td>\n<\/tr>\n<tr>\n<td><strong>col_index_num<\/strong><\/td>\n<td>S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t tr\u1ea3 v\u1ec1<\/td>\n<td>Ch\u1ec9 \u0111\u1ecbnh c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1, \u0111\u1ebfm t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a table_array l\u00e0 1.<\/td>\n<td>2, 4<\/td>\n<\/tr>\n<tr>\n<td><strong>[range_lookup]<\/strong><\/td>\n<td>Ki\u1ec3u d\u00f2 t\u00ecm<\/td>\n<td>0\/FALSE cho d\u00f2 t\u00ecm ch\u00ednh x\u00e1c, 1\/TRUE ho\u1eb7c b\u1ecf tr\u1ed1ng cho t\u00ecm g\u1ea7n \u0111\u00fang.<\/td>\n<td>0 ho\u1eb7c 1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0\u0110\u1ec3 tra c\u1ee9u gi\u00e1 b\u00e1n c\u1ee7a s\u1ea3n ph\u1ea9m m\u00e3 &#8220;SP02&#8221; trong b\u1ea3ng A2:D10, d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0<code>=VLOOKUP(\"SP02\",A2:D10,4,0)<\/code><\/p>\n<h2>Ph\u00e2n bi\u1ec7t VLOOKUP d\u00f2 t\u00ecm ch\u00ednh x\u00e1c v\u00e0 d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang<\/h2>\n<h3>VLOOKUP d\u00f2 t\u00ecm ch\u00ednh x\u00e1c l\u00e0 g\u00ec?<\/h3>\n<p>VLOOKUP d\u00f2 t\u00ecm ch\u00ednh x\u00e1c (Exact Match) l\u00e0 ch\u1ebf \u0111\u1ed9 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u1ec9 khi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u1edbp ho\u00e0n to\u00e0n v\u1edbi gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-263439 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-2.jpg\" alt=\"ham-vlookup-co-dieu-kien-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0<code>=VLOOKUP(\"SP02\",A2:D10,4,0)<\/code>\u00a0\u2013 ch\u1ec9 tr\u1ea3 v\u1ec1 gi\u00e1 khi m\u00e3 s\u1ea3n ph\u1ea9m \u0111\u00fang l\u00e0 &#8220;SP02&#8221;.<\/p>\n<h3>VLOOKUP d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang l\u00e0 g\u00ec?<\/h3>\n<p>VLOOKUP d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang (Approximate Match) d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm n\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb kh\u1edbp tuy\u1ec7t \u0111\u1ed1i. C\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u b\u1eaft bu\u1ed9c ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n \u0111\u1ec3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0<code>=VLOOKUP(8000000,A2:B10,2,1)<\/code>\u00a0\u2013 t\u00ecm m\u1ee9c thu\u1ebf ph\u00f9 h\u1ee3p cho thu nh\u1eadp 8 tri\u1ec7u d\u1ef1a tr\u00ean b\u1ea3ng thu\u1ebf x\u1ebfp lo\u1ea1i.<\/p>\n<h2>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong th\u1ef1c t\u1ebf v\u1edbi v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/h2>\n<p>\u0110\u1ec3 minh h\u1ecda, gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u s\u1ea3n ph\u1ea9m:<\/p>\n<table>\n<tbody>\n<tr>\n<th>M\u00e3 SP<\/th>\n<th>T\u00ean SP<\/th>\n<th>H\u00e3ng<\/th>\n<th>Gi\u00e1 B\u00e1n<\/th>\n<\/tr>\n<tr>\n<td>SP01<\/td>\n<td>iPhone 15 Pro Max<\/td>\n<td>Apple<\/td>\n<td>35,000,000<\/td>\n<\/tr>\n<tr>\n<td>SP02<\/td>\n<td>Galaxy S24 Ultra<\/td>\n<td>Samsung<\/td>\n<td>28,000,000<\/td>\n<\/tr>\n<tr>\n<td>SP03<\/td>\n<td>Mi 13 Pro<\/td>\n<td>Xiaomi<\/td>\n<td>16,000,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0110\u1ec3 tra c\u1ee9u gi\u00e1 b\u00e1n s\u1ea3n ph\u1ea9m &#8220;SP02&#8221;, nh\u1eadp c\u00f4ng th\u1ee9c:\u00a0<code>=VLOOKUP(\"SP02\",A2:D4,4,0)<\/code><br \/>\n<strong>K\u1ebft qu\u1ea3:<\/strong>\u00a028,000,000<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-263440 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-3.jpg\" alt=\"ham-vlookup-co-dieu-kien-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap b\u1ea1n l\u1ea5y d\u1eef li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng c\u1ea7n d\u00f2 t\u1eebng d\u00f2ng, \u0111\u1eb7c bi\u1ec7t h\u1eefu d\u1ee5ng khi l\u00e0m b\u00e1o c\u00e1o, t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u ho\u1eb7c ki\u1ec3m tra th\u00f4ng tin l\u1edbn.<\/p>\n<h2>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m VLOOKUP trong qu\u1ea3n l\u00fd d\u1eef li\u1ec7u<\/h2>\n<p>H\u00e0m VLOOKUP \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 trong nhi\u1ec1u l\u0129nh v\u1ef1c:<\/p>\n<ul>\n<li><strong>Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1:<\/strong>\u00a0Tra c\u1ee9u th\u00f4ng tin nh\u00e2n vi\u00ean, ph\u00f2ng ban, l\u01b0\u01a1ng th\u01b0\u1edfng ch\u1ec9 qua m\u00e3 s\u1ed1.<\/li>\n<li><strong>Qu\u1ea3n l\u00fd kho\/b\u00e1n h\u00e0ng:<\/strong>\u00a0Tra c\u1ee9u gi\u00e1 s\u1ea3n ph\u1ea9m, t\u1ed3n kho, nh\u00e0 cung c\u1ea5p theo m\u00e3 h\u00e0ng h\u00f3a.<\/li>\n<li><strong>Gi\u00e1o d\u1ee5c:<\/strong>\u00a0Tra c\u1ee9u \u0111i\u1ec3m, x\u1ebfp lo\u1ea1i, th\u00f4ng tin h\u1ecdc sinh theo m\u00e3 s\u1ed1.<\/li>\n<li><strong>Ng\u00e2n h\u00e0ng-t\u00e0i ch\u00ednh:<\/strong>\u00a0X\u00e1c \u0111\u1ecbnh m\u1ee9c ph\u00ed, l\u00e3i su\u1ea5t, ph\u00e2n lo\u1ea1i kh\u00e1ch h\u00e0ng theo \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<li><strong>B\u1ea3o hi\u1ec3m:<\/strong>\u00a0Tra c\u1ee9u quy\u1ec1n l\u1ee3i, m\u1ee9c ph\u00ed d\u1ef1a tr\u00ean m\u00e3 h\u1ee3p \u0111\u1ed3ng ho\u1eb7c nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-263441 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-4.jpg\" alt=\"ham-vlookup-co-dieu-kien-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Theo kh\u1ea3o s\u00e1t n\u0103m 2023, h\u01a1n 68% chuy\u00ean vi\u00ean Excel t\u1ea1i Vi\u1ec7t Nam s\u1eed d\u1ee5ng VLOOKUP t\u1ed1i thi\u1ec3u 1 l\u1ea7n\/ng\u00e0y cho c\u00e1c nghi\u1ec7p v\u1ee5 b\u00e1o c\u00e1o v\u00e0 qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u.<\/p>\n<h2>C\u00e1ch d\u00f9ng VLOOKUP nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (VLOOKUP c\u00f3 \u0111i\u1ec1u ki\u1ec7n)<\/h2>\n<p>VLOOKUP ch\u1ec9 h\u1ed7 tr\u1ee3 tra c\u1ee9u 1 \u0111i\u1ec1u ki\u1ec7n, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng \u0111\u1ec3 d\u00f2 t\u00ecm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/p>\n<h3>1. Th\u00eam c\u1ed9t ph\u1ee5 gh\u00e9p \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<p>T\u1ea1o c\u1ed9t ph\u1ee5 &#8220;Key&#8221;, gh\u00e9p c\u00e1c \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5: T\u00ean SP &amp; H\u00e3ng) r\u1ed3i tra c\u1ee9u gi\u00e1 tr\u1ecb \u0111\u00e3 gh\u00e9p.<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: T\u1ea1o c\u1ed9t ph\u1ee5 b\u1eb1ng c\u00f4ng th\u1ee9c:\u00a0<code>=B2&amp;C2<\/code>\u00a0(ho\u1eb7c\u00a0<code>=B2&amp;\"-\"&amp;C2<\/code>).<\/li>\n<li>B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng VLOOKUP v\u1edbi gi\u00e1 tr\u1ecb gh\u00e9p l\u00e0m lookup_value.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0T\u00ecm gi\u00e1 b\u00e1n c\u1ee7a &#8220;iPhone 15 Pro Max&#8221; h\u00e3ng &#8220;Apple&#8221;:<br \/>\n<code>=VLOOKUP(\"iPhone 15 Pro MaxApple\",E2:H10,4,0)<\/code><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-263442 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-5.jpg\" alt=\"ham-vlookup-co-dieu-kien-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>2. K\u1ebft h\u1ee3p VLOOKUP v\u1edbi CHOOSE (m\u1ea3ng \u0111\u1ed9ng)<\/h3>\n<p>T\u1ea1o b\u1ea3ng tra c\u1ee9u \u0111\u1ed9ng ngay trong c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng c\u1ea7n s\u1eeda b\u1ea3ng g\u1ed1c.<\/p>\n<pre>    =VLOOKUP(lookup_value1 &amp; lookup_value2, CHOOSE({1,2},A2:A10&amp;B2:B10,C2:C10),2,0)\r\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-263445 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-8.jpg\" alt=\"ham-vlookup-co-dieu-kien-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/pre>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0T\u00ecm gi\u00e1 s\u1ea3n ph\u1ea9m &#8220;Galaxy S24 Ultra&#8221; h\u00e3ng &#8220;Samsung&#8221;:<br \/>\n<code>=VLOOKUP(\"Galaxy S24 UltraSamsung\",CHOOSE({1,2},B2:B10&amp;C2:C10,D2:D10),2,0)<\/code><\/p>\n<p>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ti\u1ec7n l\u1ee3i khi d\u1eef li\u1ec7u th\u01b0\u1eddng xuy\u00ean thay \u0111\u1ed5i, ho\u1eb7c kh\u00f4ng th\u1ec3 th\u00eam c\u1ed9t ph\u1ee5 v\u00e0o b\u1ea3ng g\u1ed1c.<\/p>\n<h2>Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1edbi VLOOKUP v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/h2>\n<table>\n<thead>\n<tr>\n<th>L\u1ed7i<\/th>\n<th>Nguy\u00ean nh\u00e2n<\/th>\n<th>Gi\u1ea3i ph\u00e1p<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>#N\/A<\/td>\n<td>Kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, nh\u1eadp sai ch\u00ednh t\u1ea3 ho\u1eb7c ph\u1ea1m vi tra c\u1ee9u kh\u00f4ng \u0111\u00fang.<\/td>\n<td>Ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm, lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba, ki\u1ec3m tra ph\u1ea1m vi table_array.<\/td>\n<\/tr>\n<tr>\n<td>#REF!<\/td>\n<td>col_index_num v\u01b0\u1ee3t qu\u00e1 s\u1ed1 c\u1ed9t trong table_array, ho\u1eb7c b\u1ea3ng \u0111\u00e3 b\u1ecb c\u1eaft\/x\u00f3a c\u1ed9t.<\/td>\n<td>\u0110\u1ea3m b\u1ea3o col_index_num nh\u1ecf h\u01a1n\/t\u1ed1i \u0111a b\u1eb1ng s\u1ed1 c\u1ed9t c\u1ee7a b\u1ea3ng tra c\u1ee9u.<\/td>\n<\/tr>\n<tr>\n<td>#VALUE!<\/td>\n<td>col_index_num kh\u00f4ng ph\u1ea3i s\u1ed1, d\u1eef li\u1ec7u b\u1ea3ng ho\u1eb7c gi\u00e1 tr\u1ecb t\u00ecm kh\u00f4ng \u0111\u00fang ki\u1ec3u d\u1eef li\u1ec7u.<\/td>\n<td>col_index_num ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean d\u01b0\u01a1ng, \u0111\u1ed3ng nh\u1ea5t ki\u1ec3u d\u1eef li\u1ec7u gi\u1eefa lookup_value v\u00e0 b\u1ea3ng.<\/td>\n<\/tr>\n<tr>\n<td>#NAME?<\/td>\n<td>L\u1ed7i ch\u00ednh t\u1ea3 t\u00ean h\u00e0m (v\u00ed d\u1ee5 vi\u1ebft sai &#8220;VLOOKUP&#8221;), thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ed1i v\u1edbi chu\u1ed7i.<\/td>\n<td>Ki\u1ec3m tra l\u1ea1i t\u00ean h\u00e0m, s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c k\u00e9p cho gi\u00e1 tr\u1ecb chu\u1ed7i.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Ngo\u00e0i ra, m\u1ed9t s\u1ed1 l\u1ed7i n\u00e2ng cao c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi d\u1eef li\u1ec7u tham chi\u1ebfu \u1edf workbook kh\u00e1c, ho\u1eb7c khi s\u1eed d\u1ee5ng VLOOKUP trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng ph\u1ee9c t\u1ea1p. Khi \u0111\u00f3, n\u00ean ki\u1ec3m tra l\u1ea1i \u0111\u01b0\u1eddng d\u1eabn file, sheet, v\u00e0 ph\u1ea1m vi tham chi\u1ebfu.<\/p>\n<h2>So s\u00e1nh VLOOKUP v\u1edbi XLOOKUP v\u00e0 INDEX+MATCH<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng so s\u00e1nh chi ti\u1ebft gi\u1eefa VLOOKUP, XLOOKUP v\u00e0 INDEX+MATCH \u2013 ba h\u00e0m tra c\u1ee9u quan tr\u1ecdng nh\u1ea5t trong Excel hi\u1ec7n nay:<\/p>\n<table>\n<thead>\n<tr>\n<th>Ti\u00eau ch\u00ed<\/th>\n<th>VLOOKUP<\/th>\n<th>XLOOKUP<\/th>\n<th>INDEX+MATCH<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>H\u01b0\u1edbng d\u00f2 t\u00ecm<\/td>\n<td>Ch\u1ec9 t\u1eeb tr\u00e1i sang ph\u1ea3i<\/td>\n<td>T\u1eeb tr\u00e1i sang ph\u1ea3i v\u00e0 ng\u01b0\u1ee3c l\u1ea1i<\/td>\n<td>T\u1ef1 do, ngang\/d\u1ecdc<\/td>\n<\/tr>\n<tr>\n<td>H\u1ed7 tr\u1ee3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/td>\n<td>Kh\u00f4ng tr\u1ef1c ti\u1ebfp, c\u1ea7n th\u1ee7 thu\u1eadt<\/td>\n<td>C\u00f3 th\u1ec3<\/td>\n<td>C\u00f3 th\u1ec3 (k\u1ebft h\u1ee3p h\u00e0m m\u1ea3ng)<\/td>\n<\/tr>\n<tr>\n<td>Thay \u0111\u1ed5i c\u1ea5u tr\u00fac b\u1ea3ng<\/td>\n<td>D\u1ec5 l\u1ed7i n\u1ebfu th\u00eam\/x\u00f3a c\u1ed9t<\/td>\n<td>\u1ed4n \u0111\u1ecbnh h\u01a1n, d\u00f9ng t\u00ean c\u1ed9t<\/td>\n<td>\u1ed4n \u0111\u1ecbnh, linh ho\u1ea1t<\/td>\n<\/tr>\n<tr>\n<td>L\u1ed7i #N\/A khi kh\u00f4ng t\u00ecm th\u1ea5y<\/td>\n<td>C\u00f3<\/td>\n<td>Cho ph\u00e9p tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh<\/td>\n<td>C\u00f3<\/td>\n<\/tr>\n<tr>\n<td>S\u1eed d\u1ee5ng trong Google Sheets<\/td>\n<td>C\u00f3<\/td>\n<td>Ch\u01b0a h\u1ed7 tr\u1ee3<\/td>\n<td>C\u00f3<\/td>\n<\/tr>\n<tr>\n<td>Hi\u1ec7u su\u1ea5t v\u1edbi b\u1ea3ng l\u1edbn<\/td>\n<td>Ch\u1eadm h\u01a1n<\/td>\n<td>Nhanh h\u01a1n, t\u1ed1i \u01b0u h\u01a1n<\/td>\n<td>Nhanh, ph\u1ee5 thu\u1ed9c c\u00f4ng th\u1ee9c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>K\u1ebft lu\u1eadn:<\/strong>\u00a0XLOOKUP l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1i \u01b0u n\u1ebfu b\u1ea1n d\u00f9ng Excel b\u1ea3n m\u1edbi, INDEX+MATCH ph\u00f9 h\u1ee3p khi c\u1ea7n tra c\u1ee9u linh ho\u1ea1t v\u00e0 hi\u1ec7u su\u1ea5t cao, c\u00f2n VLOOKUP v\u1eabn l\u00e0 c\u00f4ng c\u1ee5 quen thu\u1ed9c cho \u0111a s\u1ed1 t\u00ecnh hu\u1ed1ng c\u01a1 b\u1ea3n.<\/p>\n<h2>C\u00e1ch k\u1ebft h\u1ee3p VLOOKUP v\u1edbi IF, ISNA, ho\u1eb7c c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i<\/h2>\n<p>\u0110\u1ec3 n\u00e2ng cao \u0111\u1ed9 an to\u00e0n khi tra c\u1ee9u, c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p VLOOKUP v\u1edbi IFERROR ho\u1eb7c ISNA nh\u1eb1m thay th\u1ebf l\u1ed7i #N\/A b\u1eb1ng gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn.<\/p>\n<ul>\n<li><strong>D\u00f9ng IFERROR:<\/strong>\u00a0<code>=IFERROR(VLOOKUP(\"SP99\",A2:D10,4,0),\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/li>\n<li><strong>D\u00f9ng ISNA:<\/strong>\u00a0<code>=IF(ISNA(VLOOKUP(\"SP99\",A2:D10,4,0)),\"Kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u\",VLOOKUP(\"SP99\",A2:D10,4,0))<\/code><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-263446 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-9.jpg\" alt=\"ham-vlookup-co-dieu-kien-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Ngo\u00e0i ra, c\u00f3 th\u1ec3 d\u00f9ng VLOOKUP l\u1ed3ng trong IF ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi SUM, COUNTIF \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a ki\u1ec3m tra, b\u00e1o c\u00e1o d\u1eef li\u1ec7u.<\/p>\n<h2>FAQ v\u1ec1 h\u00e0m VLOOKUP (C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p)<\/h2>\n<div class=\"faq-section\">\n<h2>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m VLOOKUP<\/h2>\n<div class=\"faq-a\">\n<p><strong>H\u00e0m VLOOKUP l\u00e0 g\u00ec v\u00e0 d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><\/p>\n<p>H\u00e0m VLOOKUP l\u00e0 c\u00f4ng c\u1ee5 d\u00f2 t\u00ecm d\u1eef li\u1ec7u theo c\u1ed9t d\u1ecdc trong Excel, d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 th\u00f4ng tin li\u00ean quan t\u1eeb m\u1ed9t c\u1ed9t kh\u00e1c. VLOOKUP gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a tra c\u1ee9u trong qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1, b\u00e1n h\u00e0ng, gi\u00e1o d\u1ee5c v\u00e0 nhi\u1ec1u l\u0129nh v\u1ef1c kh\u00e1c.<\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?<\/strong><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng VLOOKUP v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u1ed9t ph\u1ee5 gh\u00e9p c\u00e1c \u0111i\u1ec1u ki\u1ec7n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t (v\u00ed d\u1ee5: t\u00ean s\u1ea3n ph\u1ea9m &amp; h\u00e3ng) ho\u1eb7c d\u00f9ng c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi CHOOSE \u0111\u1ec3 tra c\u1ee9u \u0111\u1ed9ng. C\u1ea3 hai ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec1u gi\u00fap h\u00e0m VLOOKUP tra c\u1ee9u ch\u00ednh x\u00e1c theo nhi\u1ec1u ti\u00eau ch\u00ed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-263448 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-11.jpg\" alt=\"ham-vlookup-co-dieu-kien-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>H\u00e0m VLOOKUP kh\u00e1c g\u00ec so v\u1edbi XLOOKUP v\u00e0 INDEX+MATCH?<\/strong><\/p>\n<p>VLOOKUP ch\u1ec9 tra c\u1ee9u t\u1eeb tr\u00e1i sang ph\u1ea3i, d\u1ec5 g\u1eb7p l\u1ed7i khi thay \u0111\u1ed5i c\u1ea5u tr\u00fac b\u1ea3ng v\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp. XLOOKUP v\u00e0 INDEX+MATCH linh ho\u1ea1t h\u01a1n, cho ph\u00e9p tra c\u1ee9u hai chi\u1ec1u, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh khi kh\u00f4ng t\u00ecm th\u1ea5y v\u00e0 \u00edt b\u1ecb \u1ea3nh h\u01b0\u1edfng khi ch\u1ec9nh s\u1eeda b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p><strong>V\u00ec sao VLOOKUP tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A v\u00e0 c\u00e1ch x\u1eed l\u00fd?<\/strong><\/p>\n<p>L\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng t\u1ed3n t\u1ea1i trong c\u1ed9t \u0111\u1ea7u ti\u00ean ho\u1eb7c do nh\u1eadp sai ch\u00ednh t\u1ea3, ph\u1ea1m vi kh\u00f4ng \u0111\u00fang. B\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u, lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 c\u00f3 th\u1ec3 d\u00f9ng IFERROR ho\u1eb7c ISNA \u0111\u1ec3 thay th\u1ebf l\u1ed7i b\u1eb1ng th\u00f4ng b\u00e1o th\u00e2n thi\u1ec7n.<\/p>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify;\">K\u1ebft lu\u1eadn<\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft chia s\u1ebb th\u1ee7 thu\u1eadt v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m VLOOKUP c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\">. Hy v\u1ecdng v\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 Trang Tin Nhanh Ho\u00e0ng H\u00e0 Mobile cung c\u1ea5p, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m v\u00e0o b\u1ea3ng Excel c\u1ee7a m\u00ecnh. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 theo d\u00f5i h\u1ebft b\u00e0i vi\u1ebft c\u1ee7a ch\u00fang t\u00f4i v\u00e0 ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng nh\u00e9!<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"color: #339966;\"><strong><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tao-bang-trong-excel\/\">C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u: Tham kh\u1ea3o ngay!!!<\/a><\/strong><\/span><\/li>\n<li><span style=\"color: #339966;\"><strong><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel<\/a><\/strong><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m VLOOKUP l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1ea3i \u0111\u00e1p t\u1ea5t c\u1ea3 c\u00e1c c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 VLOOKUP, t\u1eeb kh\u00e1i ni\u1ec7m, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf, l\u1ed7i th\u01b0\u1eddng g\u1eb7p, \u0111\u1ebfn c\u00e1c m\u1eb9o n\u00e2ng cao v\u00e0 so s\u00e1nh v\u1edbi c\u00e1c h\u00e0m hi\u1ec7n [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":263436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-263435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn T\u1eeb A-Z (K\u00e8m V\u00ed d\u1ee5)<\/title>\n<meta name=\"description\" content=\"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u\" \/>\n<meta property=\"og:description\" content=\"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-25T17:11:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-07T13:50:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daisy Daisy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daisy Daisy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/fbfb09918671f672a65debf20f905308\"},\"headline\":\"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u\",\"datePublished\":\"2023-09-25T17:11:56+00:00\",\"dateModified\":\"2026-03-07T13:50:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/\"},\"wordCount\":2649,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/ham-vlookup-co-dieu-kien.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/\",\"name\":\"H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn T\u1eeb A-Z (K\u00e8m V\u00ed d\u1ee5)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/ham-vlookup-co-dieu-kien.jpg\",\"datePublished\":\"2023-09-25T17:11:56+00:00\",\"dateModified\":\"2026-03-07T13:50:31+00:00\",\"description\":\"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/ham-vlookup-co-dieu-kien.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/ham-vlookup-co-dieu-kien.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-vlookup-co-dieu-kien\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-vlookup-co-dieu-kien\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/fbfb09918671f672a65debf20f905308\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"],\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/nguyen-bao-ni\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn T\u1eeb A-Z (K\u00e8m V\u00ed d\u1ee5)","description":"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u","og_description":"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-25T17:11:56+00:00","article_modified_time":"2026-03-07T13:50:31+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"12 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fbfb09918671f672a65debf20f905308"},"headline":"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u","datePublished":"2023-09-25T17:11:56+00:00","dateModified":"2026-03-07T13:50:31+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/"},"wordCount":2649,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/","name":"H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn T\u1eeb A-Z (K\u00e8m V\u00ed d\u1ee5)","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg","datePublished":"2023-09-25T17:11:56+00:00","dateModified":"2026-03-07T13:50:31+00:00","description":"N\u1eafm v\u1eefng h\u00e0m VLOOKUP trong Excel ch\u1ec9 trong 5 ph\u00fat! H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-vlookup-co-dieu-kien.jpg","width":1200,"height":628,"caption":"ham-vlookup-co-dieu-kien"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup-co-dieu-kien\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"T\u1ea5t T\u1ea7n T\u1eadt v\u1ec1 H\u00e0m VLOOKUP trong Excel: H\u01b0\u1edbng D\u1eabn cho Ng\u01b0\u1eddi M\u1edbi B\u1eaft \u0110\u1ea7u"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fbfb09918671f672a65debf20f905308","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e58ee4eb478d55636644bae43c153ed62a700d924d9ef753f50507408d32e5cf?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/263435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=263435"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/263435\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/263436"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=263435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=263435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=263435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}