{"id":2600,"date":"2024-12-02T08:12:00","date_gmt":"2024-12-02T08:12:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du\/"},"modified":"2024-12-02T08:12:00","modified_gmt":"2024-12-02T08:12:00","slug":"ham-vlookup-trong-google-trang-tinh-va-cac-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du\/","title":{"rendered":"H\u00c0M VLOOKUP TRONG GOOGLE TRANG T\u00cdNH V\u00c0 C\u00c1C V\u00cd D\u1ee4"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch h\u00e0m VLOOKUP trong Google trang t\u00ednh v\u00e0 h\u01b0\u1edbng d\u1eabn \u1ee9ng \u1ee9ng d\u1ee5ng v\u00ed d\u1ee5 <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m VLOOKUP<\/strong><\/a> \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c nhi\u1ec7m v\u1ee5 th\u1ef1c t\u1ebf.\u00a0<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Khi x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn nhau, m\u1ed9t trong nh\u1eefng kh\u00f3 kh\u0103n ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 t\u00ecm ki\u1ebfm th\u00f4ng tin tr\u00ean nhi\u1ec1u trang t\u00ednh. Trong cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y b\u1ea1n c\u0169ng s\u1ebd th\u1ef1c hi\u1ec7n nh\u1eefng c\u00f4ng vi\u1ec7c nh\u01b0 qu\u00e9t b\u1ea3ng l\u1ecbch tr\u00ecnh chuy\u1ebfn bay \u0111\u1ec3 bi\u1ebft th\u1eddi gian kh\u1edfi h\u00e0nh v\u00e0 tr\u1ea1ng th\u00e1i kh\u1edfi h\u00e0nh. Google Sheet Vlookup ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady \u2013 tra c\u1ee9u v\u00e0 truy xu\u1ea5t d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p t\u1eeb m\u1ed9t b\u1ea3ng kh\u00e1c tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh ho\u1eb7c t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi cho r\u1eb1ng h\u00e0m Vlookup l\u00e0 h\u00e0m kh\u00f3 v\u00e0 \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. Nh\u01b0ng tr\u00ean th\u1ef1c t\u1ebf r\u1ea5t d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n h\u00e0m Vlookup trong Google trang t\u00ednh v\u00e0 b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/span><\/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-674d6bcf9cb91\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Google_Sheets_Vlookup_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"Google Sheets Vlookup \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">Google Sheets Vlookup \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/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\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Cach_su_dung_ham_VLOOKUP_trong_Google_Trang_tinh_%E2%80%93_vi_du_ve_cong_thuc\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Google Trang t\u00ednh \u2013 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Google Trang t\u00ednh \u2013 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Cach_tham_chieu_Vlookup_tu_mot_trang_tinh_khac\" title=\"C\u00e1ch tham chi\u1ebfu Vlookup t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c\">C\u00e1ch tham chi\u1ebfu Vlookup t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c<\/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\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Google_Trang_tinh_Vlookup_voi_cac_ky_tu_dai_dien\" title=\"Google Trang t\u00ednh Vlookup v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\">Google Trang t\u00ednh Vlookup v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Cong_thuc_Index_Match_trong_Google_Trang_tinh_thay_cho_Vlookup_ben_trai\" title=\"C\u00f4ng th\u1ee9c Index Match trong Google Trang t\u00ednh thay cho Vlookup b\u00ean tr\u00e1i\">C\u00f4ng th\u1ee9c Index Match trong Google Trang t\u00ednh thay cho Vlookup b\u00ean tr\u00e1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Vlookup_phan_biet_chu_hoa_chu_thuong_trong_Google_Trang_tinh\" title=\"Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Google Trang t\u00ednh\">Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Google Trang t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-vlookup-trong-google-trang-tinh-va-cac-vi-du.html#Hop_nhat_Trang_tinh_Merge_Sheets_thay_the_khong_can_cong_thuc_cho_Google_Trang_tinh_Vlookup\" title=\"H\u1ee3p nh\u1ea5t Trang t\u00ednh (Merge Sheets): thay th\u1ebf kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c cho Google Trang t\u00ednh Vlookup\">H\u1ee3p nh\u1ea5t Trang t\u00ednh (Merge Sheets): thay th\u1ebf kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c cho Google Trang t\u00ednh Vlookup<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Google_Sheets_Vlookup_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span><b>Google Sheets Vlookup \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m VLOOKUP trong Google Sheets \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf th\u1ef1c hi\u1ec7n tra c\u1ee9u theo chi\u1ec1u d\u1ecdc (vertical lookup). Vlookup c\u00f3 ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb kh\u00f3a (m\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t) xu\u1ed1ng c\u1ed9t \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb trong c\u00f9ng m\u1ed9t h\u00e0ng t\u1eeb c\u1ed9t kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p cho h\u00e0m Vlookup c\u1ee7a Google Trang t\u00ednh nh\u01b0 sau:<\/span><\/p>\n<p><strong><i>VLOOKUP(search_key, range, index, [is_sorted])<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng l\u00e0 t\u00f9y ch\u1ecdn:<\/span><\/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-201.gif\" title=\"ex101_92019-nho-201\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><b><i>Search_key<\/i><\/b><span style=\"font-weight: 400\"> \u2013 l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm (gi\u00e1 tr\u1ecb tra c\u1ee9u ho\u1eb7c m\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t). V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm t\u1eeb \u201capple\u201d, s\u1ed1 10 hay l\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 A2.<\/span><\/p>\n<p><b><i>Range<\/i><\/b><span style=\"font-weight: 400\"> (ph\u1ea1m vi): hai ho\u1eb7c nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u cho t\u00ecm ki\u1ebfm. H\u00e0m Vlookup c\u1ee7a google trang t\u00ednh lu\u00f4n t\u00ecm ki\u1ebfm trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a Range.<\/span><\/p>\n<p><b><i>Index:<\/i><\/b> <span style=\"font-weight: 400\">s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong <\/span><i><span style=\"font-weight: 400\">ph\u1ea1m vi<\/span><\/i><span style=\"font-weight: 400\"> m\u00e0 t\u1eeb \u0111\u00f3 gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p (gi\u00e1 tr\u1ecb trong c\u00f9ng h\u00e0ng v\u1edbi <\/span><i><span style=\"font-weight: 400\">Search_ key<\/span><\/i><span style=\"font-weight: 400\">) s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u1ed9t \u0111\u1ea7u ti\u00ean trong Range v\u00e0 c\u00f3 Index 1. N\u1ebfu Index nh\u1ecf h\u01a1n 1, c\u00f4ng th\u1ee9c Vlookup tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE! L\u1ed7i. N\u1ebfu n\u00f3 l\u1edbn s\u1ed1 c\u1ed9t trong ph\u1ea1m vi, h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #REF! l\u1ed7i.<\/span><\/p>\n<p><b><i>Is_Sorted:<\/i><\/b><span style=\"font-weight: 400\"> cho bi\u1ebft c\u1ed9t tra c\u1ee9u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp (TRUE) hay (False). Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p th\u00ec FALSE \u0111\u01b0\u1ee3c khuy\u1ebfn ngh\u1ecb.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu is_sorted l\u00e0 TRUE ho\u1eb7c b\u1ecb b\u1ecf qua (m\u1eb7c \u0111\u1ecbnh), c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea1m vi ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, t\u1ee9c l\u00e0 t\u1eeb A \u0111\u1ebfn Z ho\u0103c t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c Vlookup tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3 g\u1ea7n \u0111\u00fang (t\u01b0\u01a1ng \u0111\u1ed1i) . Ch\u00ednh x\u00e1c h\u01a1n, n\u00f3 t\u00ecm ki\u1ebfm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p ch\u00ednh x\u00e1c tr\u01b0\u1edbc ti\u00ean. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c, c\u00f4ng th\u1ee9c s\u1ebd t\u00ecm ki\u1ebfm \u0111\u1ed1i s\u00e1nh g\u1ea7n nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng Search_ key . N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t tra c\u1ee9u l\u1edbn h\u01a1n kh\u00f3a t\u00ecm ki\u1ebfm, th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i # N \/ A.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu <\/span><i><span style=\"font-weight: 400\">is_sorted<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh FALSE, kh\u00f4ng c\u1ea7n s\u1eafp x\u1ebfp. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c Vlookup t\u00ecm ki\u1ebfm k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p ch\u00ednh x\u00e1c . N\u1ebfu c\u1ed9t tra c\u1ee9u ch\u1ee9a 2 ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c b\u1eb1ng kh\u00f3a t\u00ecm ki\u1ebfm, gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean t\u00ecm th\u1ea5y s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Tho\u1ea1t nh\u00ecn, c\u00fa ph\u00e1p c\u00f3 v\u1ebb h\u01a1i ph\u1ee9c t\u1ea1p, nh\u01b0ng v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c Vlookup c\u1ee7a Google Trang t\u00ednh d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap m\u1ecdi th\u1ee9 d\u1ec5 hi\u1ec3u h\u01a1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai b\u1ea3ng: b\u1ea3ng ch\u00ednh v\u00e0 b\u1ea3ng tra c\u1ee9u nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi. C\u00e1c b\u1ea3ng c\u00f3 m\u1ed9t c\u1ed9t chung (order ID) l\u00e0 m\u1ed9t m\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t. M\u1ee5c \u0111\u00edch l\u00e0 k\u00e9o tr\u1ea1ng th\u00e1i c\u1ee7a t\u1eebng \u0111\u01a1n h\u00e0ng t\u1eeb b\u1ea3ng tra c\u1ee9u sang b\u1ea3ng ch\u00ednh.<\/span><\/p>\n<figure style=\"width: 556px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Google Sheets Vlookup \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-table-1.png\" alt=\"Source data: main table and Lookup table\" width=\"556\" height=\"193\"><figcaption class=\"wp-caption-text\">Google Sheets Vlookup \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Google Trang t\u00ednh Vlookup \u0111\u1ec3 ho\u00e0n th\u00e0nh nhi\u1ec7m v\u1ee5? \u0110\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111\u1ed1i s\u1ed1 cho c\u00f4ng th\u1ee9c Vlookup:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Search_key<\/span><\/i><span style=\"font-weight: 400\"> \u2013 ID \u0111\u01a1n h\u00e0ng (A3), gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm ki\u1ebfm trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng Tra c\u1ee9u.<\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Range (V\u00f9ng d\u1eef li\u1ec7u)<\/span><\/i><span style=\"font-weight: 400\"> \u2013 b\u1ea3ng Tra c\u1ee9u ($F$3:$G$8). L\u01b0u \u00fd kh\u00f3a ph\u1ea1m vi b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i n\u1ebfu d\u1ef1 \u0111\u1ecbnh sao ch\u00e9p c\u00f4ng th\u1ee9c sang nhi\u1ec1u \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Index: <\/span><\/i><span style=\"font-weight: 400\">Index \u2013 2 t\u1eeb c\u1ed9t Status s\u1ebd\u00a0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp l\u00e0 c\u1ed9t th\u1ee9 2 trong ph\u1ea1m vi.<\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">\u00a0Is_sorted: <\/span><\/i><span style=\"font-weight: 400\">\u00a0FALSE v\u00ec c\u1ed9t t\u00ecm ki\u1ebfm c\u1ee7a ch\u00fang ta (F) kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u0110\u1eb7t t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 l\u1ea1i v\u1edbi nhau, ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">=VLOOKUP(A3,$F$3:$G$8,2,false)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1eadp n\u00f3 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean (D3) c\u1ee7a b\u1ea3ng ch\u00ednh, sao ch\u00e9p xu\u1ed1ng c\u1ed9t v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><\/p>\n<figure style=\"width: 554px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Google Sheets Vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-google-sheets.png\" alt=\"Vlookup in Google Sheets\" width=\"554\" height=\"219\"><figcaption class=\"wp-caption-text\">Google Sheets Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c Vlookup c\u00f3 c\u00f2n kh\u00f3 hi\u1ec3u \u0111\u1ed1i v\u1edbi b\u1ea1n kh\u00f4ng? Sau \u0111\u00f3, h\u00e3y nh\u00ecn n\u00f3 theo c\u00e1ch n\u00e0y:<\/span><\/p>\n<figure style=\"width: 634px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 Google Sheets Vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-vlookup-formula.png\" alt=\"Google Sheets Vlookup formula\" width=\"634\" height=\"64\"><figcaption class=\"wp-caption-text\"><em>V\u00ed d\u1ee5 Google Sheets Vlookup<\/em><\/figcaption><\/figure>\n<p><b><i>5 \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 Google Sheets VLOOKUP<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u00e1nh g\u1eb7p r\u1eafc r\u1ed1i v\u00e0 h\u1ea1n ch\u1ebf nh\u1eefng l\u1ed7i c\u00f3 th\u1ec3 m\u1eafc ph\u1ea3i trong Vlookup th\u00ec n\u00ean ghi nh\u1edb n\u0103m \u0111i\u1ec1u \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Google Sheets VLOOKUP kh\u00f4ng th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u b\u00ean tr\u00e1i c\u1ee7a n\u00f3, n\u00f3 lu\u00f4n t\u00ecm ki\u1ebfm \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean (ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i) c\u1ee7a ph\u1ea1m vi. \u0110\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t Vlookup b\u00ean tr\u00e1i , h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Index &amp; Match c\u1ee7a Google Trang t\u00ednh .<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">VLOOKUP trong Google Sheets l\u00e0<\/span><i><span style=\"font-weight: 400\"> case-insensitive,<\/span><\/i><span style=\"font-weight: 400\"> c\u00f3 ngh\u0129a l\u00e0 n\u00f3 kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng v\u00e0 ch\u1eef in hoa. \u0110\u1ec3 tra c\u1ee9u ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng , h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c, h\u00e3y \u0111\u1eb7t \u0111\u1ed1i s\u1ed1 <\/span><i><span style=\"font-weight: 400\">is_sorted<\/span><\/i><span style=\"font-weight: 400\"> th\u00e0nh FALSE \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Khi <\/span><i><span style=\"font-weight: 400\">is_sorte<\/span><\/i><span style=\"font-weight: 400\">d \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh TRUE ho\u1eb7c b\u1ecb b\u1ecf qua, b\u1ea1n n\u00ean nh\u1edb s\u1eafp x\u1ebfp c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea1m vi theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e0m VLOOKUP s\u1ebd s\u1eed d\u1ee5ng thu\u1eadt to\u00e1n t\u00ecm ki\u1ebfm nh\u1ecb ph\u00e2n nhanh h\u01a1n v\u00e0 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Google Sheets VLOOKUP c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm <\/span><b><i>kh\u1edbp m\u1ed9t ph\u1ea7n (<\/i><\/b><b><i>partial match)<\/i><\/b><span style=\"font-weight: 400\"> d\u1ef1a tr\u00ean c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n : d\u1ea5u h\u1ecfi (?) v\u00e0 d\u1ea5u hoa th\u1ecb (*). Vui l\u00f2ng xem v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c Vlookup d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft.<\/span><\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_VLOOKUP_trong_Google_Trang_tinh_%E2%80%93_vi_du_ve_cong_thuc\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Google Trang t\u00ednh \u2013 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Vlookup tr\u00ean \u0111\u00e2y, b\u00e2y gi\u1edd ch\u00fang ta s\u1ebd th\u1eed t\u1ea1o m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c. \u0110\u1ec3 l\u00e0m theo c\u00e1c v\u00ed d\u1ee5 Vlookup d\u01b0\u1edbi \u0111\u00e2y d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec3u r\u00f5 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf trang t\u00ednh Vlookup \u0111\u1ec3 l\u00e0m theo.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tham_chieu_Vlookup_tu_mot_trang_tinh_khac\"><\/span><b>C\u00e1ch tham chi\u1ebfu Vlookup t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong th\u1ef1c t\u1ebf, b\u1ea3ng ch\u00ednh v\u00e0 b\u1ea3ng tra c\u1ee9u th\u01b0\u1eddng n\u1eb1m tr\u00ean c\u00e1c trang t\u00ednh kh\u00e1c nhau. \u0110\u1ec3 tham chi\u1ebfu c\u00f4ng th\u1ee9c Vlookup \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh, h\u00e3y \u0111\u1eb7t t\u00ean b\u1ea3ng t\u00ednh theo sau l\u00e0 d\u1ea5u ch\u1ea5m than (!) tr\u01b0\u1edbc tham chi\u1ebfu ph\u1ea1m vi. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong><i>=VLOOKUP(A2,Sheet4!$A$2:$B$7,2,false)<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong A2 trong ph\u1ea1m vi A2: A7 tr\u00ean trang t\u00ednh 4 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u1edbp t\u1eeb c\u1ed9t B ( c\u1ed9t th\u1ee9 2 trong ph\u1ea1m vi ).<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu t\u00ean trang t\u00ednh bao g\u1ed3m kho\u1ea3ng tr\u1eafng ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, h\u00e3y \u0111\u1ea3m b\u1ea3o \u0111\u1eb7t n\u00f3 trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong><i>=VLOOKUP(A2,\u2019Lookup table\u2019!$A$2:$B$7,2,false)<\/i><\/strong><\/p>\n<figure style=\"width: 631px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch tham chi\u1ebfu Vlookup t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-vlookup-different-sheet.png\" alt=\"Vlookup from a different sheet\" width=\"631\" height=\"240\"><figcaption class=\"wp-caption-text\">C\u00e1ch tham chi\u1ebfu Vlookup t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\"><em><strong>Ch\u00fa \u00fd:<\/strong><\/em> Thay v\u00ec nh\u1eadp tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t trang t\u00ednh kh\u00e1c theo c\u00e1ch th\u1ee7 c\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Google sheet \u0111\u1ec3 ch\u00e8n n\u00f3 m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c Vlookup c\u1ee7a b\u1ea1n v\u00e0 khi \u0111\u1ebfn \u0111\u1ed1i s\u1ed1 ph\u1ea1m vi(range) th\u00ec chuy\u1ec3n sang trang t\u00ednh tra c\u1ee9u v\u00e0 ch\u1ecdn ph\u1ea1m vi b\u1eb1ng chu\u1ed9t. Thao t\u00e1c n\u00e0y s\u1ebd th\u00eam tham chi\u1ebfu ph\u1ea1m vi v\u00e0o c\u00f4ng th\u1ee9c v\u00e0 b\u1ea1n s\u1ebd ch\u1ec9 ph\u1ea3i thay \u0111\u1ed5i tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (m\u1eb7c \u0111\u1ecbnh) th\u00e0nh tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i . \u0110\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, b\u1ea1n nh\u1eadp d\u1ea5u $ tr\u01b0\u1edbc k\u00fd t\u1ef1 c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng, ho\u1eb7c ch\u1ecdn tham chi\u1ebfu v\u00e0 nh\u1ea5n F4 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c lo\u1ea1i tham chi\u1ebfu kh\u00e1c nhau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Google_Trang_tinh_Vlookup_voi_cac_ky_tu_dai_dien\"><\/span><b>Google Trang t\u00ednh Vlookup v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng bi\u1ebft to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb tra c\u1ee9u (search_ key), v\u00e0 b\u1ea1n ch\u1ec9 bi\u1ebft m\u1ed9t ph\u1ea7n c\u1ee7a gi\u00e1 tr\u1ecb th\u00ec c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D\u1ea5u ch\u1ea5m h\u1ecfi (?) \u0110\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u01a1n .<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D\u1ea5u hoa th\u1ecb (*) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 chu\u1ed7i .<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n truy xu\u1ea5t th\u00f4ng tin v\u1ec1 m\u1ed9t \u0111\u01a1n \u0111\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3 t\u1eeb b\u1ea3ng b\u00ean d\u01b0\u1edbi. B\u1ea1n kh\u00f4ng th\u1ec3 nh\u1edb l\u1ea1i \u0111\u1ea7y \u0111\u1ee7 ID th\u1ee9 t\u1ef1, nh\u01b0ng b\u1ea1n nh\u1edb r\u1eb1ng k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean l\u00e0 \u201cA\u201d. V\u00ec v\u1eady, b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u hoa th\u1ecb (*) \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o ph\u1ea7n c\u00f2n thi\u1ebfu, nh\u01b0 sau:<\/span><\/p>\n<p><strong>=VLOOKUP(\u201ca*\u201d,$A$2:$C$7,2,false)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp ph\u1ea7n \u0111\u00e3 bi\u1ebft c\u1ee7a kh\u00f3a t\u00ecm ki\u1ebfm v\u00e0o m\u1ed9t s\u1ed1 \u00f4 v\u00e0 n\u1ed1i ch\u00fang v\u1edbi \u201c*\u201d \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c Vlookup linh ho\u1ea1t h\u01a1n:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u0110\u1ec3 k\u00e9o m\u1ee5c: <strong>=VLOOKUP($F$1&amp;\u201d*\u201d,$A$2:$C$7,2,false).<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400\">\u2013\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u0110\u1ec3 k\u00e9o s\u1ed1 ti\u1ec1n: <strong>=VLOOKUP($F$1&amp;\u201d*\u201d,$A$2:$C$7,3,false).<\/strong><\/span><\/p>\n<figure style=\"width: 529px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Google Trang t\u00ednh Vlookup v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-vlookup-wildcards.png\" alt=\"Google Sheets Vlookup with a wildcard character\" width=\"529\" height=\"196\"><figcaption class=\"wp-caption-text\">Google Trang t\u00ednh Vlookup v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fa \u00fd: N\u1ebfu b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm m\u1ed9t d\u1ea5u ch\u1ea5m h\u1ecfi ho\u1eb7c k\u00fd t\u1ef1 d\u1ea5u hoa th\u1ecb, h\u00e3y \u0111\u1eb7t d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc k\u00fd t\u1ef1, v\u00ed d\u1ee5: \u201c~ *\u201d.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_Index_Match_trong_Google_Trang_tinh_thay_cho_Vlookup_ben_trai\"><\/span><b>C\u00f4ng th\u1ee9c Index Match trong Google Trang t\u00ednh thay cho Vlookup b\u00ean tr\u00e1i<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 nh\u1ea5t c\u1ee7a h\u00e0m VLOOKUP (c\u1ea3 trong Excel v\u00e0 Google Trang t\u00ednh) l\u00e0 n\u00f3 kh\u00f4ng th\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u00ean tr\u00e1i. T\u1ee9c l\u00e0, n\u1ebfu c\u1ed9t t\u00ecm ki\u1ebfm kh\u00f4ng ph\u1ea3i l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng tra c\u1ee9u, Google Sheets Vlookup s\u1ebd b\u1ecb l\u1ed7i. Trong nh\u1eefng t\u00ecnh hu\u1ed1ng nh\u01b0 v\u1eady, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Index Match:<\/span><\/p>\n<p><strong><i>INDEX ( return_range , MATCH ( search_key , lookup_range , 0)<\/i>)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 tra c\u1ee9u gi\u00e1 tr\u1ecb A3 (ph\u00edm t\u00ecm ki\u1ebfm) trong G3: G8 (lookup_range) v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp t\u1eeb F3: F8 (return_range), ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><strong><i>=INDEX($F$3:$F$8, MATCH (A3, $G$3:$G$8, 0))<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<figure style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c Index Match trong Google Trang t\u00ednh thay cho Vlookup b\u00ean tr\u00e1i\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/index-match-google-sheets.png\" alt=\"Google Sheets Index Match formula for left Vlookup\" width=\"640\" height=\"218\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c Index Match trong Google Trang t\u00ednh thay cho Vlookup b\u00ean tr\u00e1i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1ed9t \u01b0u \u0111i\u1ec3m kh\u00e1c c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y so v\u1edbi Vlookup l\u00e0 n\u00f3 kh\u00f4ng b\u1ecb t\u00e1c \u0111\u1ed9ng b\u1edfi nh\u1eefng thay \u0111\u1ed5i c\u1ea5u tr\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n trong trang t\u00ednh v\u00ec n\u00f3 tham chi\u1ebfu tr\u1ef1c ti\u1ebfp \u0111\u1ebfn c\u1ed9t tr\u1ea3 v\u1ec1. \u0110\u1eb7c bi\u1ec7t, vi\u1ec7c ch\u00e8n ho\u1eb7c x\u00f3a m\u1ed9t c\u1ed9t trong b\u1ea3ng tra c\u1ee9u s\u1ebd ph\u00e1 v\u1ee1 c\u00f4ng th\u1ee9c Vlookup v\u00ec s\u1ed1 ch\u1ec9 m\u1ee5c (Index) \u201c\u0111\u01b0\u1ee3c m\u00e3 h\u00f3a c\u1ee9ng\u201dkh\u00f4ng h\u1ee3p l\u1ec7, trong khi c\u00f4ng th\u1ee9c tr\u00ean v\u1eabn an to\u00e0n v\u00e0 h\u1ee3p l\u00fd.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin v\u1ec1 INDEX MATCH, vui l\u00f2ng xem T\u1ea1i sao INDEX &amp; MATCH l\u00e0 gi\u1ea3i ph\u00e1p thay th\u1ebf t\u1ed1t h\u01a1n cho VLOOKUP . M\u1eb7c d\u00f9 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean nh\u1eafm m\u1ee5c ti\u00eau \u0111\u1ebfn Excel, INDEX MATCH trong Google Trang t\u00ednh ho\u1ea1t \u0111\u1ed9ng theo c\u00f9ng m\u1ed9t c\u00e1ch, ngo\u1ea1i tr\u1eeb c\u00e1c t\u00ean kh\u00e1c nhau c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vlookup_phan_biet_chu_hoa_chu_thuong_trong_Google_Trang_tinh\"><\/span><b>Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Google Trang t\u00ednh<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p v\u0103n b\u1ea3n quan tr\u1ecdng, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m INDEX MATCH k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m TRUE v\u00e0 EXACT \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c m\u1ea3ng Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng :<\/span><\/p>\n<p><strong><i>ArrayFormula (INDEX ( return_range , MATCH (TRUE, EXACT ( lookup_range , search_key ), 0)))<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed kh\u00f3a t\u00ecm ki\u1ebfm n\u1eb1m trong \u00f4 A3, ph\u1ea1m vi tra c\u1ee9u l\u00e0 G3: G8 v\u00e0 ph\u1ea1m vi tr\u1ea3 v\u1ec1 l\u00e0 F3: F8, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><strong><i>=ArrayFormula(INDEX($F$3:$F$8, MATCH (TRUE,EXACT($G$3:$G$8, A3),0)))<\/i>\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec v\u1edbi vi\u1ec7c ph\u00e2n bi\u1ec7t c\u00e1c k\u00fd t\u1ef1 vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng nh\u01b0 A-1001 v\u00e0 a-1001:<\/span><\/p>\n<figure style=\"width: 622px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Google Trang t\u00ednh\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/case-sensitive-google-sheets-vlookup.png\" alt=\"Case-sensitive Vlookup in Google Sheets\" width=\"622\" height=\"229\"><figcaption class=\"wp-caption-text\"><em>Vlookup ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Google Trang t\u00ednh<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u00fa \u00fd:\u00a0 Nh\u1ea5n <strong>Ctrl + Shift + Enter<\/strong> s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n h\u00e0m ARRAYFORMULA v\u00e0o \u0111\u1ea7u c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c Vlookup l\u00e0 c\u00e1ch ph\u1ed5 bi\u1ebfn nh\u1ea5t nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch duy nh\u1ea5t \u0111\u1ec3 tra c\u1ee9u trong Google Trang t\u00ednh. Ph\u1ea7n ti\u1ebfp theo v\u00e0 ph\u1ea7n cu\u1ed1i c\u00f9ng c\u1ee7a h\u01b0\u1edbng d\u1eabn n\u00e0y tr\u00ecnh b\u00e0y m\u1ed9t gi\u1ea3i ph\u00e1p thay th\u1ebf.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Hop_nhat_Trang_tinh_Merge_Sheets_thay_the_khong_can_cong_thuc_cho_Google_Trang_tinh_Vlookup\"><\/span><b>H\u1ee3p nh\u1ea5t Trang t\u00ednh (Merge Sheets): thay th\u1ebf kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c cho Google Trang t\u00ednh Vlookup<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch kh\u00e1c \u0111\u1ec3 h\u1ee3p nh\u1ea5t trang t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c Vlookup th\u00ec h\u00e3y c\u00e2n nh\u1eafc s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i mi\u1ec5n ph\u00ed t\u1eeb c\u1eeda h\u00e0ng ti\u1ec7n \u00edch b\u1ed5 sung c\u1ee7a Google Trang t\u00ednh .<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau khi ti\u1ec7n \u00edch b\u1ed5 sung \u0111\u01b0\u1ee3c th\u00eam v\u00e0o Google Trang t\u00ednh c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y n\u00f3 trong tab Ti\u1ec7n \u00edch b\u1ed5 sung :<\/span><\/p>\n<figure style=\"width: 352px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u1ee3p nh\u1ea5t Trang t\u00ednh (Merge Sheets)\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-sheets.png\" alt=\"Merge Sheets add-on\" width=\"352\" height=\"159\"><figcaption class=\"wp-caption-text\">H\u1ee3p nh\u1ea5t Trang t\u00ednh (Merge Sheets)<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd th\u1eed nghi\u1ec7m v\u1edbi v\u00ed d\u1ee5 ban \u0111\u1ea7u: ch\u00fang ta s\u1ebd l\u1ea5y th\u00f4ng tin t\u1eeb c\u1ed9t Tr\u1ea1ng th\u00e1i d\u1ef1a tr\u00ean ID \u0111\u01a1n \u0111\u1eb7t h\u00e0ng :<\/span><\/p>\n<figure style=\"width: 598px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Thay th\u1ebf kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c cho Google Trang t\u00ednh Vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-sheets-data.png\" alt=\"Source data to merge sheets based on the key column\" width=\"598\" height=\"211\"><figcaption class=\"wp-caption-text\">Thay th\u1ebf kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c cho Google Trang t\u00ednh Vlookup<\/figcaption><\/figure>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o c\u00f3 d\u1eef li\u1ec7u trong Trang t\u00ednh ch\u00ednh v\u00e0 nh\u1ea5p v\u00e0o Ti\u1ec7n \u00edch b\u1ed5 sung &gt; H\u1ee3p nh\u1ea5t Trang t\u00ednh &gt; B\u1eaft \u0111\u1ea7u .<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, ti\u1ec7n \u00edch b\u1ed5 sung s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng cho b\u1ea1n. N\u1ebfu kh\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o n\u00fat T\u1ef1 \u0111\u1ed9ng ch\u1ecdn ho\u1eb7c ch\u1ecdn ph\u1ea1m vi trong trang t\u00ednh ch\u00ednh c\u1ee7a b\u1ea1n theo c\u00e1ch th\u1ee7 c\u00f4ng, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Ti\u1ebfp theo.<\/span><\/p>\n<figure style=\"width: 636px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 1: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/main-sheet.png\" alt=\"Select the range in the main sheet.\" width=\"636\" height=\"597\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 1: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">2. Ch\u1ecdn ph\u1ea1m vi trong B\u1ea3ng tra c\u1ee9u . Ph\u1ea1m vi kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi ph\u1ea1m vi trong trang t\u00ednh ch\u00ednh. Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea3ng tra c\u1ee9u c\u00f3 nhi\u1ec1u h\u00e0ng h\u01a1n b\u1ea3ng ch\u00ednh 2 h\u00e0ng.<\/span><\/p>\n<figure style=\"width: 636px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 2: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-sheet.png\" alt=\"Select the range in the lookup sheet.\" width=\"636\" height=\"597\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 2: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">3. Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t ch\u00ednh (s\u1ed1 nh\u1eadn d\u1ea1ng duy nh\u1ea5t) \u0111\u1ec3 so s\u00e1nh. V\u00ec ch\u00fang ta \u0111ang so s\u00e1nh c\u00e1c trang t\u00ednh theo ID \u0111\u1eb7t h\u00e0ng , ch\u00fang ta ch\u1ec9 ch\u1ecdn c\u1ed9t n\u00e0y:<\/span><\/p>\n<figure style=\"width: 636px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 3: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/key-colulumn.png\" alt=\"Select one or more key columns to compare.\" width=\"636\" height=\"597\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 3: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">4. Trong C\u1ed9t tra c\u1ee9u , h\u00e3y ch\u1ecdn (c\u00e1c) c\u1ed9t trong Trang t\u00ednh tra c\u1ee9u m\u00e0 b\u1ea1n mu\u1ed1n truy xu\u1ea5t d\u1eef li\u1ec7u. Trong C\u1ed9t ch\u00ednh, h\u00e3y ch\u1ecdn c\u00e1c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng trong trang t\u00ednh ch\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p d\u1eef li\u1ec7u v\u00e0o.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang k\u00e9o th\u00f4ng tin t\u1eeb c\u1ed9t tr\u1ea1ng th\u00e1i tr\u00ean trang t\u00ednh tra c\u1ee9u v\u00e0o c\u1ed9t tr\u1ea1ng th\u00e1i tr\u00ean trang t\u00ednh ch\u00ednh:<\/span><\/p>\n<figure style=\"width: 636px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 4: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/columns-update.png\" alt=\"Select the column(s) to be updated.\" width=\"636\" height=\"597\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 4: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">5. Theo t\u00f9y ch\u1ecdn, h\u00e3y ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u00e0nh \u0111\u1ed9ng b\u1ed5 sung. Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n mu\u1ed1n th\u00eam c\u00e1c h\u00e0ng kh\u00f4ng kh\u1edbp v\u00e0o cu\u1ed1i b\u1ea3ng ch\u00ednh, t\u1ee9c l\u00e0 sao ch\u00e9p c\u00e1c h\u00e0ng ch\u1ec9 t\u1ed3n t\u1ea1i trong b\u1ea3ng tra c\u1ee9u v\u00e0o cu\u1ed1i b\u1ea3ng ch\u00ednh:<\/span><\/p>\n<figure style=\"width: 636px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 5: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/additional-options.png\" alt=\"Select one or more additional options.\" width=\"636\" height=\"597\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 5: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o Ho\u00e0n t\u1ea5t , cho ph\u00e9p ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets \u0111\u01b0\u1ee3c x\u1eed l\u00fd trong gi\u00e2y l\u00e1t v\u00e0 b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng!<\/span><\/p>\n<figure style=\"width: 637px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u01b0\u1edbc 6: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-sheets-result.png\" alt=\"The Merge Sheets results\" width=\"637\" height=\"769\"><figcaption class=\"wp-caption-text\">B\u01b0\u1edbc 6: C\u00e1ch s\u1eed d\u1ee5ng ti\u1ec7n \u00edch b\u1ed5 sung Merge Sheets<\/figcaption><\/figure>\n<p><b>K\u1ebft h\u1ee3p nhi\u1ec1u Vlookup (Vlookup multiple matches)\u00a0 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng<\/b><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p nhi\u1ec1u Vlookup l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Google Trang t\u00ednh \u0111\u1ec3 tra c\u1ee9u n\u00e2ng cao. Theo gi\u1ed1ng nh\u01b0 t\u00ean g\u1ecdi, n\u00f3 c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p, kh\u00f4ng ch\u1ec9 l\u00e0 k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean nh\u01b0 h\u00e0m VLOOKUP. H\u01a1n n\u1eefa, n\u00f3 c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, tra c\u1ee9u theo b\u1ea5t k\u1ef3 h\u01b0\u1edbng n\u00e0o v\u00e0 tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 ho\u1eb7c s\u1ed1 l\u01b0\u1ee3ng k\u1ebft h\u1ee3p \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c .<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng th\u1ef1c t\u1ebf c\u1ee7a ti\u1ec7n \u00edch n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? Gi\u1ea3 s\u1eed, m\u1ed9t s\u1ed1 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng trong b\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang t\u00f4i ch\u1ee9a m\u1ed9t s\u1ed1 m\u1ee5c v\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c c\u1ee7a m\u1ed9t \u0111\u01a1n \u0111\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3. M\u1ed9t c\u00f4ng th\u1ee9c Vlookup kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, trong khi m\u1ed9t h\u00e0m QUERY m\u1ea1nh h\u01a1n c\u00f3 th\u1ec3. V\u1ea5n \u0111\u1ec1 l\u00e0 ch\u1ee9c n\u0103ng n\u00e0y y\u00eau c\u1ea7u ki\u1ebfn \u200b\u200bth\u1ee9c v\u1ec1 ng\u00f4n ng\u1eef truy v\u1ea5n ho\u1eb7c \u00edt nh\u1ea5t l\u00e0 c\u00fa ph\u00e1p SQL. B\u1ea1n kh\u00f4ng mu\u1ed1n d\u00e0nh nhi\u1ec1u ng\u00e0y \u0111\u1ec3 nghi\u00ean c\u1ee9u \u0111i\u1ec1u n\u00e0y? C\u00e0i \u0111\u1eb7t ti\u1ec7n \u00edch b\u1ed5 sung Multiple VLOOKUP Matches v\u00e0 nh\u1eadn m\u1ed9t c\u00f4ng th\u1ee9c ho\u00e0n h\u1ea3o trong v\u00e0i gi\u00e2y!<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong Google Trang t\u00ednh c\u1ee7a b\u1ea1n, nh\u1ea5p v\u00e0o Ti\u1ec7n \u00edch b\u1ed5 sung &gt; Nhi\u1ec1u tr\u1eadn \u0111\u1ea5u VLOOKUP &gt; B\u1eaft \u0111\u1ea7u v\u00e0 x\u00e1c \u0111\u1ecbnh ti\u00eau ch\u00ed tra c\u1ee9u:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn ph\u1ea1m vi v\u1edbi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n (A1: D9).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ec9 \u0111\u1ecbnh c\u00f3 bao nhi\u00eau k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p \u0111\u1ec3 tr\u1ea3 v\u1ec1 (t\u1ea5t c\u1ea3 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang t\u00f4i).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn c\u00e1c c\u1ed9t \u0111\u1ec3 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u ( M\u1ee5c , S\u1ed1 l\u01b0\u1ee3ng v\u00e0 Tr\u1ea1ng th\u00e1i ).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1eb7t m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Ch\u00fang ta mu\u1ed1n l\u1ea5y th\u00f4ng tin v\u1ec1 \u0111\u1ea7u v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 trong F2, v\u00ec v\u1eady ch\u00fang ta ch\u1ec9 \u0111\u1ecbnh c\u1ea5u h\u00ecnh m\u1ed9t \u0111i\u1ec1u ki\u1ec7n: ID \u0111\u01a1n h\u00e0ng = F2.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i cho k\u1ebft qu\u1ea3.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o Xem tr\u01b0\u1edbc k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c nh\u1eefng g\u00ec b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu t\u1ea5t c\u1ea3 \u0111\u1ec1u OK, h\u00e3y nh\u1ea5p v\u00e0o Ch\u00e8n c\u00f4ng th\u1ee9c ho\u1eb7c D\u00e1n k\u1ebft qu\u1ea3 .<\/span>\n<p><figure style=\"width: 633px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"K\u1ebft h\u1ee3p nhi\u1ec1u Vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-vlookup-multiple-matches.png\" alt=\"Vlookup multiple matches in Google Sheets\" width=\"633\" height=\"762\"><figcaption class=\"wp-caption-text\">K\u1ebft h\u1ee3p nhi\u1ec1u Vlookup<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y th\u00ec s\u1ebd l\u00e0 ch\u1ecdn tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c. V\u00ec v\u1eady, b\u00e2y gi\u1edd ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp b\u1ea5t k\u1ef3 s\u1ed1 th\u1ee9 t\u1ef1 n\u00e0o v\u00e0o F2 v\u00e0 c\u00f4ng th\u1ee9c hi\u1ec3n th\u1ecb trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i:<\/span><\/p>\n<figure style=\"width: 612px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch k\u1ebft h\u1ee3p nhi\u1ec1u Vlookup\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-return-multiple-matches.png\" alt=\"The formula to return multiple matches in Google Sheets\" width=\"612\" height=\"240\"><figcaption class=\"wp-caption-text\">C\u00e1ch k\u1ebft h\u1ee3p nhi\u1ec1u Vlookup<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 ti\u1ec7n \u00edch b\u1ed5 sung, h\u00e3y truy c\u1eadp trang ch\u1ee7 VLOOKUP Multiple ho\u1eb7c t\u1ea3i xu\u1ed1ng ngay b\u00e2y gi\u1edd t\u1eeb G Suite Marketplace.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u Google Trang t\u00ednh. Hy v\u1ecdng nh\u1eefng th\u00f4ng tin tr\u00ean s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u00eam nh\u1eefng kinh nghi\u1ec7m b\u1ed5 \u00edch v\u1ec1 Google trang t\u00ednh.<\/span><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-201.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2600","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\/2600","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=2600"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2601"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}