{"id":2678,"date":"2024-12-02T08:22:12","date_gmt":"2024-12-02T08:22:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel\/"},"modified":"2024-12-02T08:22:12","modified_gmt":"2024-12-02T08:22:12","slug":"cach-dung-ham-vlookup-giua-2-sheet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel\/","title":{"rendered":"C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP GI\u1eeeA 2 SHEET TRONG EXCEL"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft n\u00e0y, <\/span><a href=\"http:\/\/blog.ezworkapp.com\/\"><b>H\u1ecdc Excel Online<\/b><\/a><span style=\"font-weight: 400\"> s\u1ebd gi\u1edbi thi\u1ec7u b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP gi\u1eefa 2 sheet trong excel <\/strong><\/a>\u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh ho\u1eb7c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c, VLOOKUP trong nhi\u1ec1u trang t\u00ednh v\u00e0 tra c\u1ee9u m\u1ed9t c\u00e1ch linh \u0111\u1ed9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Khi tra c\u1ee9u m\u1ed9t s\u1ed1 trang th\u00f4ng tin trong Excel, r\u1ea5t hi\u1ebfm khi t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh. B\u1ea1n s\u1ebd ph\u1ea3i t\u00ecm ki\u1ebfm tr\u00ean nhi\u1ec1u trang t\u00ednh ho\u1eb7c nhi\u1ec1u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c nhau. Tin t\u1ed1t l\u00e0 Microsoft Excel cung c\u1ea5p nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y v\u00e0 tin x\u1ea5u l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c c\u00e1ch \u0111\u1ec1u ph\u1ee9c t\u1ea1p so v\u1edbi <\/span><b>c\u00f4ng th\u1ee9c VLOOKUP<\/b><span style=\"font-weight: 400\">. Nh\u01b0ng b\u1ea1n ch\u1ec9 c\u1ea7n m\u1ed9t ch\u00fat ki\u00ean nh\u1eabn, ch\u00fang ta s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c.<\/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-674d6e32f0e69\" 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\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Cach_tim_kiem_du_lieu_bang_ham_VLOOKUP_giua_2_Sheet\" title=\"C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa 2 Sheet\">C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa 2 Sheet<\/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\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_tu_mot_cua_so_lam_viec_khac\" title=\"H\u00e0m VLOOKUP t\u1eeb m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c\">H\u00e0m VLOOKUP t\u1eeb m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_tren_nhieu_trang_tinh_ket_hop_voi_ham_IFERROR\" title=\"H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR\">H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_trong_nhieu_cua_so_lam_viec\" title=\"H\u00e0m VLOOKUP trong nhi\u1ec1u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c\u00a0\">H\u00e0m VLOOKUP trong nhi\u1ec1u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c\u00a0<\/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\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Lam_cho_dia_chi_cot_thanh_Vlookup_nhieu_cot\" title=\"L\u00e0m cho \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh Vlookup nhi\u1ec1u c\u1ed9t\">L\u00e0m cho \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh Vlookup nhi\u1ec1u c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_tren_nhieu_trang_tinh_ket_hop_voi_ham_INDIRECT\" title=\"H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDIRECT\">H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDIRECT<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Cach_su_dung_cong_thuc_de_VLOOKUP_tren_cac_trang_tinh\" title=\"C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 VLOOKUP tr\u00ean c\u00e1c trang t\u00ednh\">C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 VLOOKUP tr\u00ean c\u00e1c trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#VLOOKUP_nhieu_trang_tinh_giua_cac_cua_so_lam_viec\" title=\"VLOOKUP nhi\u1ec1u trang t\u00ednh gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c\">VLOOKUP nhi\u1ec1u trang t\u00ednh gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_giua_2_sheet_va_tra_ve_nhieu_cot\" title=\"H\u00e0m VLOOKUP gi\u1eefa 2 sheet v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u c\u1ed9t\">H\u00e0m VLOOKUP gi\u1eefa 2 sheet v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#COUNTIF_va_INDIRECT\" title=\"COUNTIF v\u00e0 INDIRECT\">COUNTIF v\u00e0 INDIRECT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#INDEX_va_MATCH\" title=\"INDEX v\u00e0 MATCH\">INDEX v\u00e0 MATCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#VLOOKUP_va_INDIRECT\" title=\"VLOOKUP v\u00e0 INDIRECT\u00a0\">VLOOKUP v\u00e0 INDIRECT\u00a0<\/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-13\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ham_VLOOKUP_dong_tra_ve_du_lieu_tu_nhieu_trang_tinh_vao_cac_o_khac_nhau\" title=\"H\u00e0m VLOOKUP \u0111\u1ed9ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau\">H\u00e0m VLOOKUP \u0111\u1ed9ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#Ket_hop_ham_VLOOKUP_va_ham_IF\" title=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html#INDIRECT_VLOOKUP\" title=\"INDIRECT VLOOKUP\">INDIRECT VLOOKUP<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tim_kiem_du_lieu_bang_ham_VLOOKUP_giua_2_Sheet\"><\/span><b>C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa 2 Sheet<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, h\u00e3y nghi\u00ean c\u1ee9u tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u2013\u00a0 c\u00e1ch d\u00f9ng<strong>\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-vlookup-giua-2-sheet-trong-excel.html\">h\u00e0m VLOOKUP gi\u1eefa 2 sheet<\/a><\/strong> \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u. N\u00f3 r\u1ea5t gi\u1ed1ng v\u1edbi <em><strong>c\u00f4ng th\u1ee9c VLOOKUP<\/strong> <\/em>th\u00f4ng th\u01b0\u1eddng khi t\u00ecm ki\u1ebfm tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh. S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 bao g\u1ed3m t\u00ean trang t\u00ednh trong tham s\u1ed1 table_array \u0111\u1ec3 cho c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n bi\u1ebft ph\u1ea1m vi tra c\u1ee9u n\u1eb1m trong trang n\u00e0o.<\/span><\/p>\n<p><em><strong>C\u00f4ng th\u1ee9c chung cho<a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"> h\u00e0m VLOOKUP<\/a> t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c nh\u01b0 sau:<\/strong><\/em><\/p>\n<p><strong>VLOOKUP(lookup_value, Sheet!range, col_index_num, [range_lookup])<\/strong><\/p>\n<p><em><span style=\"font-weight: 400\">V\u00ed d\u1ee5: Ch\u00fang ta h\u00e3y k\u00e9o s\u1ed1 li\u1ec7u b\u00e1n h\u00e0ng t\u1eeb b\u00e1o c\u00e1o th\u00e1ng 1 (Jan) sang trang T\u00f3m t\u1eaft (Summary). \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, ch\u00fang ta x\u00e1c \u0111\u1ecbnh c\u00e1c tham s\u1ed1 sau:<\/span><\/em><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lookup_values n\u1eb1m trong c\u1ed9t A tr\u00ean trang T\u00f3m t\u1eaft v\u00e0 ch\u00fang ta tham chi\u1ebfu \u0111\u1ebfn \u00f4 d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean l\u00e0 A2.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Table_array l\u00e0 ph\u1ea1m vi A2:B6 tr\u00ean trang t\u00ednh Jan. \u0110\u1ec3 tham chi\u1ebfu \u0111\u1ebfn n\u00f3, h\u00e3y \u0111\u1eb7t ti\u1ec1n t\u1ed1 cho tham chi\u1ebfu ph\u1ea1m vi v\u1edbi t\u00ean trang t\u00ednh, theo sau l\u00e0 d\u1ea5u ch\u1ea5m than: Jan!$A$2:$B$6.<\/span><\/li>\n<\/ul>\n<p><em><span style=\"font-weight: 400\">Xin l\u01b0u \u00fd r\u1eb1ng ch\u00fang ta kh\u00f3a ph\u1ea1m vi b\u1eb1ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 ng\u0103n n\u00f3 thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c.<\/span><\/em><\/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-207.gif\" title=\"ex101_92019-nho-207\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Col_index_num l\u00e0 2 v\u00ec ch\u00fang ta mu\u1ed1n sao ch\u00e9p m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t B, l\u00e0 c\u1ed9t th\u1ee9 2 trong tr\u01b0\u1eddng Table array.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Range_lookup \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh FALSE \u0111\u1ec3 t\u00ecm ki\u1ebfm k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u0110\u1eb7t 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:\u00a0<\/span><\/p>\n<p><strong>=VLOOKUP(A2, Jan!$A$2:$B$6, 2, FALSE)<\/strong><\/p>\n<figure style=\"width: 561px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa hai trang t\u00ednh\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-another-sheet.png\" alt=\"VLOOKUP from another sheet\" width=\"561\" height=\"202\"><figcaption class=\"wp-caption-text\">C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa hai trang t\u00ednh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u1ed9t v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m VLOOKUP d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh Feb v\u00e0 Mar:<\/span><\/p>\n<p><strong>=VLOOKUP(A2, Feb!$A$2:$B$6, 2, FALSE)<\/strong><\/p>\n<p><strong>=VLOOKUP(A2, Mar!$A$2:$B$6, 2, FALSE)<\/strong><\/p>\n<figure style=\"width: 573px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch t\u00ecm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa hai trang t\u00ednh 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-between-sheets.png\" alt=\"C\u00e1ch t\u00ecm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa hai trang t\u00ednh 2\" width=\"573\" height=\"202\"><figcaption class=\"wp-caption-text\">C\u00e1ch t\u00ecm d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m VLOOKUP gi\u1eefa hai trang t\u00ednh 2<\/figcaption><\/figure>\n<p><em><span style=\"font-weight: 400\">M\u1eb9o v\u00e0 l\u01b0u \u00fd:<\/span><\/em><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu trang t\u00ednh ch\u1ee9a kho\u1ea3ng tr\u1eafng ho\u1eb7c c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i ch\u1eef c\u00e1i, t\u00ean trang t\u00ednh ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p, ch\u1eb3ng h\u1ea1n nh\u01b0 \u2018Jan Sales\u2019!$A$2:$B$6. \u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, vui l\u00f2ng xem c\u00e1ch tham chi\u1ebfu trang t\u00ednh kh\u00e1c trong Excel.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Thay v\u00ec nh\u1eadp tr\u1ef1c ti\u1ebfp tr\u00ean trang t\u00ednh v\u00e0o c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n sang trang t\u00ednh tra c\u1ee9u v\u00e0 ch\u1ecdn ph\u1ea1m vi \u1edf \u0111\u00f3. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n m\u1ed9t tham chi\u1ebfu v\u1edbi c\u00fa ph\u00e1p ch\u00ednh x\u00e1c, gi\u00fap b\u1ea1n kh\u00f4ng kh\u00f3 kh\u0103n khi ki\u1ec3m tra t\u00ean v\u00e0 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_tu_mot_cua_so_lam_viec_khac\"><\/span><b>H\u00e0m VLOOKUP t\u1eeb m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 <strong>h\u00e0m VLOOKUP<\/strong> gi\u1eefa hai c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c, bao g\u1ed3m t\u00ean t\u1ec7p trong d\u1ea5u ngo\u1eb7c vu\u00f4ng, theo sau l\u00e0 t\u00ean trang t\u00ednh v\u00e0 d\u1ea5u ch\u1ea5m than.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb A2 trong ph\u1ea1m vi A2:B6 tr\u00ean trang t\u00ednh Jan trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c Sales_reports .xlsx, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<p><strong>\u00a0=VLOOKUP(A2, [Sales_reports.xlsx]Jan!$A$2:$B$6, 2, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft chi ti\u1ebft \u0111\u1ea7y \u0111\u1ee7, vui l\u00f2ng xem<a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\"><strong> VLOOKUP t\u1eeb m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c trong Excel<\/strong><\/a>.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_tren_nhieu_trang_tinh_ket_hop_voi_ham_IFERROR\"><\/span><b>H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n c\u1ea7n tra c\u1ee9u gi\u1eefa nhi\u1ec1u h\u01a1n hai trang t\u00ednh, gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng <strong>h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi IFERROR<\/strong>. \u00dd t\u01b0\u1edfng l\u00e0 l\u1ed3ng m\u1ed9t s\u1ed1 h\u00e0m IFERROR \u0111\u1ec3 ki\u1ec3m tra t\u1eebng trang t\u00ednh: n\u1ebfu h\u00e0m VLOOKUP \u0111\u1ea7u ti\u00ean kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p tr\u00ean trang t\u00ednh \u0111\u1ea7u ti\u00ean, h\u00e3y t\u00ecm ki\u1ebfm trong trang t\u00ednh ti\u1ebfp theo.<\/span><\/p>\n<p><strong>IFERROR(VLOOKUP(\u2026), IFERROR(VLOOKUP(\u2026), \u2026, \u201cNot found\u201d))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 xem ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o, ch\u00fang ta h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng Summary m\u00e0 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u \u0111i\u1ec1n t\u00ean v\u00e0 s\u1ed1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng h\u00f3a trong trang t\u00ednh WEST v\u00e0 EAST:<\/span><\/p>\n<figure style=\"width: 516px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-sheets.png\" alt=\"Sample data to Vlookup across multiple sheets\" width=\"516\" height=\"493\"><figcaption class=\"wp-caption-text\">H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, ch\u00fang ta s\u1ebd k\u00e9o c\u00e1c m\u1ee5c . \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, ch\u00fang ta d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng tr\u00f2n A2 tr\u00ean trang t\u00ednh EAST v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t B (c\u1ed9t th\u1ee9 2 trong table_array A2:C6). N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p, h\u00e3y t\u00ecm kiems trang t\u00ednh WEST. N\u1ebfu c\u1ea3 hai h\u00e0m VLOOKUP kh\u00f4ng th\u00e0nh c\u00f4ng, h\u00e3y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cNot found\u201d.<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP(A2, East!$A$2:$C$6, 2, FALSE), IFERROR(VLOOKUP(A2, West!$A$2:$C$6, 2, FALSE), \u201cNot found\u201d))<\/strong><\/p>\n<figure style=\"width: 410px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi IFERROR\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/iferror-vlookup-multiple-sheets.png\" alt=\"Vlookup across multiple sheets with IFERROR\" width=\"410\" height=\"297\"><figcaption class=\"wp-caption-text\">VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi IFERROR<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u1ea3 l\u1ea1i s\u1ed1 l\u01b0\u1ee3ng, ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh 3:<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP(A2, East!$A$2:$C$6, 3, FALSE), IFERROR(VLOOKUP(A2, West!$A$2:$C$6, 3, FALSE), \u201cNot found\u201d))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb9o: N\u1ebfu c\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh c\u00e1c b\u1ea3ng kh\u00e1c nhau trong m\u1ed9t trang t\u00ednh cho c\u00e1c h\u00e0m VLOOKUP kh\u00e1c nhau. Trong v\u00ed d\u1ee5 n\u00e0y, c\u1ea3 hai trang t\u00ednh tra c\u1ee9u \u0111\u1ec1u c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng (A2:C6), nh\u1eefng trang t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 k\u00edch th\u01b0\u1edbc kh\u00e1c nhau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_trong_nhieu_cua_so_lam_viec\"><\/span><b>H\u00e0m VLOOKUP trong nhi\u1ec1u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 <strong>h\u00e0m VLOOKUP gi\u1eefa 2 sheet<\/strong> hay nhi\u1ec1u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c, h\u00e3y \u0111\u1eb7t t\u00ean c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c trong d\u1ea5u ngo\u1eb7c vu\u00f4ng v\u00e0 \u0111\u1eb7t n\u00f3 tr\u01b0\u1edbc t\u00ean trang t\u00ednh. V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m VLOOKUP trong hai t\u1ec7p kh\u00e1c nhau (Book1 v\u00e0 Book2) v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t:<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP(A2, [Book1.xlsx]East!$A$2:$C$6, 2, FALSE),\u00a0 IFERROR(VLOOKUP(A2, [Book2.xlsx]West!$A$2:$C$6, 2, FALSE),\u201dNot found\u201d))<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_cho_dia_chi_cot_thanh_Vlookup_nhieu_cot\"><\/span><b>L\u00e0m cho \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh Vlookup nhi\u1ec1u c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n tr\u1ea3 l\u1ea1i d\u1eef li\u1ec7u t\u1eeb m\u1ed9t s\u1ed1 c\u1ed9t, vi\u1ec7c t\u1ea1o\u00a0 col_index_num c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian. C\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec1u ch\u1ec9nh c\u1ea7n th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi tham s\u1ed1 col_index_num, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m COLUMNS tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ed9t trong m\u1ed9t m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh: COLUMNS($A$1:B$1). (V\u1ecb tr\u00ed h\u00e0ng kh\u00f4ng th\u1ef1c s\u1ef1 quan tr\u1ecdng, n\u00f3 c\u00f3 th\u1ec3 l\u00e0 b\u1ea5t k\u1ef3 h\u00e0ng n\u00e0o.)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong tham s\u1ed1 lookup_value, h\u00e3y c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu c\u1ed9t b\u1eb1ng d\u1ea5u $ ($A2), v\u00ec v\u1eady n\u00f3 v\u1eabn c\u1ed1 \u0111\u1ecbnh khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c c\u1ed9t kh\u00e1c.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t lo\u1ea1i c\u00f4ng th\u1ee9c m\u00e0 sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p t\u1eeb c\u00e1c c\u1ed9t kh\u00e1c nhau, t\u00f9y thu\u1ed9c v\u00e0o c\u1ed9t m\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o:<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP($A2, East!$A$2:$C$6, COLUMNS($A$1:B$1), FALSE), IFERROR(VLOOKUP($A2, West!$A$2:$C$6, COLUMNS($A$1:B$1), FALSE), \u201cNot found\u201d))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Khi nh\u1eadp h\u00e0m v\u00e0o c\u1ed9t B, COLUMNS($A$1:B$1) cho k\u1ebft qu\u1ea3 l\u00e0 2 y\u00eau c\u1ea7u VLOOKUP tr\u1ea3 v\u1ec1 m\u1ed5 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t th\u1ee9 2 trong b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi sao ch\u00e9p v\u00e0o c\u1ed9t C (t\u1ee9c l\u00e0 b\u1ea1n k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb B2 sang C2), B$1 s\u1ebd thay \u0111\u1ed5i th\u00e0nh C$1 v\u00ec tham chi\u1ebfu c\u1ed9t l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i. Do \u0111\u00f3, COLUMNS($A$1:C$1) \u0111\u00e1nh gi\u00e1 l\u00e0 3 VLOOKUP tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t th\u1ee9 3.<\/span><\/p>\n<figure style=\"width: 538px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"L\u00e0m cho \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh Vlookup nhi\u1ec1u c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-sheets-excel.png\" alt=\"To Vlookup from multiple columns, make col_index_num dynamic.\" width=\"538\" height=\"299\"><figcaption class=\"wp-caption-text\">L\u00e0m cho \u0111\u1ecba ch\u1ec9 c\u1ed9t th\u00e0nh Vlookup nhi\u1ec1u c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c n\u00e0y hi\u1ec7u qu\u1ea3 v\u1edbi 2 \u2013 3 trang tra c\u1ee9u. N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n, h\u00e0m IFERROR l\u1eb7p l\u1ea1i s\u1ebd tr\u1edf n\u00ean qu\u00e1 c\u1ed3ng k\u1ec1nh. V\u00ed d\u1ee5 ti\u1ebfp theo cho th\u1ea5y c\u00e1ch ti\u1ebfp c\u1eadn ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat nh\u01b0ng r\u1ea5t hi\u1ec7u qu\u1ea3.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_tren_nhieu_trang_tinh_ket_hop_voi_ham_INDIRECT\"><\/span><b>H\u00e0m VLOOKUP tr\u00ean nhi\u1ec1u trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDIRECT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 h\u00e0m VLOOKUP gi\u1eefa nhi\u1ec1u trang t\u00ednh trong Excel l\u00e0 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m VLOOKUP v\u00e0 INDIRECt. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y y\u00eau c\u1ea7u m\u1ed9t ch\u00fat chu\u1ea9n b\u1ecb, nh\u01b0ng cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c r\u00fat g\u1ecdn h\u01a1n \u0111\u1ec3 VLOOKUP b\u1ea5t k\u1ef3 b\u1ea3ng t\u00ednh n\u00e0o.<\/span><\/p>\n<p><em><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c chung cho h\u00e0m VLOOKUP gi\u1eefa 2 sheet nh\u01b0 sau:<\/span><\/em><\/p>\n<p><strong>VLOOKUP(lookup_value, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d &amp; Sheet_list &amp; \u201c\u2018!lookup_range\u201d), lookup_value)&gt;0), 0)) &amp; \u201c\u2018!table_array\u201d), col_index_num, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lookup_sheets \u2013 t\u00ean ph\u1ea1m vi bao g\u1ed3m t\u00ean trang t\u00ednh c\u1ea7n tra c\u1ee9u.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lookup_value \u2013 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lookup_range \u2013 ph\u1ea1m vi c\u1ed9t trong trang t\u00ednh tra c\u1ee9u n\u01a1i t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb tra c\u1ee9u.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Table_array \u2013 chu\u1ed7i d\u1eef li\u1ec7u trong trang t\u00ednh tra c\u1ee9u.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Col_index_num \u2013 s\u1ed1 c\u1ed9t trong b\u1ea3ng m\u00e0 t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb.<\/span><\/li>\n<\/ul>\n<p><em><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, h\u00e3y ghi nh\u1edb nh\u1eefng l\u01b0u \u00fd sau:<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c ph\u1ea3i nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter. T\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh ph\u1ea3i c\u00f3 c\u00f9ng th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec ch\u00fang ta s\u1eed d\u1ee5ng m\u1ed9t m\u1ea3ng b\u1ea3ng cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh tra c\u1ee9u, h\u00e3y ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi l\u1edbn nh\u1ea5t n\u1ebfu c\u00e1c trang t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 s\u1ed1 h\u00e0ng kh\u00e1c nhau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_cong_thuc_de_VLOOKUP_tren_cac_trang_tinh\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 VLOOKUP tr\u00ean c\u00e1c trang t\u00ednh<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 VLOOKUP nhi\u1ec1u trang t\u00ednh c\u00f9ng m\u1ed9t l\u00fac, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">VI\u1ebft ra t\u1ea5t c\u1ea3 c\u00e1c t\u00ean b\u1ea3ng tra c\u1ee9u \u1edf \u0111\u00f3 trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n v\u00e0 \u0111\u1eb7t t\u00ean cho ph\u1ea1m vi \u0111\u00f3 (Lookup_sheets trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y).<\/span><\/li>\n<\/ol>\n<figure style=\"width: 139px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Lookup sheets\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lookup-sheets-name.png\" alt=\"Lookup_sheets named range\" width=\"139\" height=\"165\"><figcaption class=\"wp-caption-text\">Lookup sheets<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 \u00a02. \u0110\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb A2 (lookup_value)\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong ph\u1ea1m vi A2:A6 (lookup_range) trong b\u1ed1n trang t\u00ednh (East, North, South v\u00e0 West)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u00e9o c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t B, l\u00e0 c\u1ed9t 2 (\u0441ol_index_num) trong ph\u1ea1m vi d\u1eef li\u1ec7u A2:C6 (table_array).\u00a0<\/span><\/li>\n<\/ul>\n<p><em><span style=\"font-weight: 400\">V\u1edbi c\u00e1c tham s\u1ed1 tr\u00ean, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/span><\/em><\/p>\n<p><strong>=VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d&amp; Lookup_sheets&amp;\u201d\u2018!$A$2:$A$6\u2033), $A2)&gt;0), 0)) &amp;\u201d\u2018!$A$2:$C$6\u201d), 2, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Xin l\u01b0u \u00fd r\u1eb1ng ch\u00fang ta c\u1ed1 \u0111\u1ecbnh c\u1ea3 hai ph\u1ea1m vi ($A$2:$A$6 and $A$2:$C$6) v\u1edbi tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 3. Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 tr\u00ean c\u00f9ng (B2 trong v\u00ed d\u1ee5 n\u00e0y) v\u00e0 nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0 \u00a0 \u00a0 4. Nh\u1ea5n \u0111\u00fap chu\u1ed9t ho\u1eb7c k\u00e9o fill handle (m\u1ed9t n\u1ed1t m\u00e0u \u0111en \u1edf g\u00f3c ph\u1ea3i \u2013 b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn) \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u1ed9t.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 l\u00e0 ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c tra c\u1ee9u s\u1ed1 l\u01b0\u1ee3ng trong 4 b\u1ea3ng t\u00ednh v\u00e0 l\u1ea5y ra m\u1eb7t h\u00e0ng t\u01b0\u01a1ng \u1ee9ng. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng c\u1ee5 th\u1ec3, l\u1ed7i #N\/A s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 trong h\u00e0ng 14:<\/span><\/p>\n<figure style=\"width: 492px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 VLOOKUP tr\u00ean c\u00e1c trang t\u00ednh\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multile-sheets-array-formula.png\" alt=\"Array formula to Vlookup across multiple sheets\" width=\"492\" height=\"544\"><figcaption class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 VLOOKUP tr\u00ean c\u00e1c trang t\u00ednh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng, ch\u1ec9 c\u1ea7n thay th\u1ebf 2 b\u1eb1ng 3 trong tham s\u1ed1 col_index_num v\u00ec s\u1ed1 l\u01b0\u1ee3ng n\u1eb1m trong c\u1ed9t th\u1ee9 3 c\u1ee7a b\u0103ng:<\/span><\/p>\n<p><strong>=VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d &amp; Lookup_sheets &amp; \u201c\u2018!$A$2:$A$6\u201d), $A2)&gt;0), 0)) &amp; \u201c\u2018!$A$2:$C$6\u201d), 3, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n thay th\u1ebf k\u00fd hi\u1ec7u l\u1ed7i #N\/A b\u1eb1ng v\u0103n b\u1ea3n, h\u00e3y \u0111\u01b0a c\u00f4ng th\u1ee9c IFNA:\u00a0<\/span><\/p>\n<p><strong>=IFNA(VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d &amp; Lookup_sheets &amp; \u201c\u2018!$A$2:$A$6\u201d), $A2)&gt;0), 0)) &amp; \u201c\u2018!$A$2:$C$6\u201d), 3, FALSE), \u201cNot found\u201d)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multile-sheets-without-errors.png\" alt=\"Display your text instead of N\/A error.\" title=\"vlookup-multile-sheets-without-errors\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"VLOOKUP_nhieu_trang_tinh_giua_cac_cua_so_lam_viec\"><\/span><b>VLOOKUP nhi\u1ec1u trang t\u00ednh gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c chung n\u00e0y (ho\u1eb7c b\u1ea5t k\u1ef3 bi\u1ebfn th\u1ec3 n\u00e0o c\u1ee7a n\u00f3) c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 Vlookup nhi\u1ec1u trang t\u00ednh trong m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c. \u0110i\u1ec1u n\u00e0y cho th\u1ea5y, h\u00e3y ch\u00e8n t\u00ean c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c b\u00ean trong INDIRECT nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><strong>=IFNA(VLOOKUP($A2, INDIRECT(\u201c\u2018[Book1.xlsx]\u201d &amp; INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018[Book1.xlsx]\u201d &amp; Lookup_sheets &amp; \u201c\u2018!$A$2:$A$6\u201d), $A2)&gt;0), 0)) &amp; \u201c\u2018!$A$2:$C$6\u201d), 2, FALSE), \u201cNot found\u201d)<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_giua_2_sheet_va_tra_ve_nhieu_cot\"><\/span><b>H\u00e0m VLOOKUP gi\u1eefa 2 sheet v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n th\u1ea5y nhi\u1ec1u d\u1eef li\u1ec7u t\u1eeb m\u1ed9t s\u1ed1 c\u1ed9t, c\u00f4ng th\u1ee9c m\u1ea3ng nhi\u1ec1u \u00f4 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 trong m\u1ed9t l\u1ea7n. \u0110\u1ec3 t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady, h\u00e3y cung c\u1ea5p m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng cho tham s\u1ed1 col_index_num.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i mu\u1ed1n tr\u1ea3 v\u1ec1 t\u00ean m\u1ee5c (c\u1ed9t B) v\u00e0 s\u1ed1 l\u01b0\u1ee3ng (c\u1ed9t C), l\u1ea7n l\u01b0\u1ee3t l\u00e0 c\u1ed9t th\u1ee9 2 v\u00e0 th\u1ee9 3 trong b\u1ea3ng. V\u00ec v\u1eady, m\u1ea3ng b\u1eaft bu\u1ed9c l\u00e0 {2,3}.<\/span><\/p>\n<p><strong>=VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d&amp; Lookup_sheets &amp;\u201d\u2018!$A$2:$C$6\u2033), $A2)&gt;0), 0)) &amp;\u201d\u2018!$A$2:$C$6\u201d), {2,3}, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 nh\u1eadp ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4, \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n l\u00e0m:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong h\u00e0ng \u0111\u1ea7u ti\u00ean, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n (B2:C2 trong v\u00ed d\u1ee5 n\u00e0y).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + Shift + Enter. Thao t\u00e1c n\u00e0y nh\u1eadp c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn, s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c nhau trong m\u1ed7i c\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c h\u00e0ng c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<figure style=\"width: 468px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"VLOOKUP gi\u1eefa c\u00e1c trang t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-return-multiple-columns.png\" alt=\"Vlookup between sheets and return multiple columns\" width=\"468\" height=\"268\"><figcaption class=\"wp-caption-text\">VLOOKUP gi\u1eefa c\u00e1c trang t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u c\u1ed9t<\/figcaption><\/figure>\n<p><b><i>C\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n, h\u00e3y chia nh\u1ecf c\u00f4ng th\u1ee9c th\u00e0nh nhi\u1ec1u h\u00e0m ri\u00eang l\u1ebb:<\/span><\/p>\n<p><strong>=VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, \u2013(COUNTIF(INDIRECT(\u201c\u2018\u201d&amp; Lookup_sheets&amp;\u201d\u2018!$A$2:$A$6\u2033), $A2)&gt;0), 0)) &amp;\u201d\u2018!$A$2:$C$6\u201d), 2, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">L\u00e0m vi\u1ec7c t\u1eeb trong ra ngo\u00e0i, \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec c\u00f4ng th\u1ee9c th\u1ef1c hi\u1ec7n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"COUNTIF_va_INDIRECT\"><\/span><b>COUNTIF v\u00e0 INDIRECT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u00f3m l\u1ea1i, INDIRECT x\u00e2y d\u1ef1ng c\u00e1c tham chi\u1ebfu cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh c\u1ea7n tra c\u1ee9u v\u00e0 COUNTIF \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb tra c\u1ee9u (A2) trong m\u1ed7i trang t\u00ednh:<\/span><\/p>\n<p><strong>\u2013(COUNTIF( INDIRECT(\u201c\u2018\u201d&amp;Lookup_sheets&amp;\u201d\u2018!$A$2:$A$6\u201d), $A2)&gt;0)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Chi ti\u1ebft h\u01a1n<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, b\u1ea1n k\u1ebft h\u1ee3p t\u00ean (Lookup_sheets) v\u00e0 tham chi\u1ebfu \u00f4 ($A$2:$A$6), th\u00eam d\u1ea5u nh\u00e1y \u0111\u01a1n v\u00e0 d\u1ea5u ch\u1ea5m than v\u00e0o \u0111\u00fang v\u1ecb tr\u00ed \u0111\u1ec3 t\u1ea1o tham chi\u1ebfu b\u00ean ngo\u00e0i v\u00e0 cung c\u1ea5p chu\u1ed7i v\u0103n b\u1ea3n k\u1ebft qu\u1ea3 cho h\u00e0m INDIRECT \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ed9ng \u0111\u1ebfn c\u00e1c trang t\u00ednh c\u1ea7n tra c\u1ee9u:<\/span><\/p>\n<p><strong>INDIRECT({\u201c\u2018East\u2019!$A$2:$A$6\u201d; \u201c\u2018South\u2019!$A$2:$A$6\u201d; \u201c\u2018North\u2019!$A$2:$A$6\u201d; \u201c\u2018West\u2019!$A$2:$A$6\u201d})<\/strong><\/p>\n<p><span style=\"font-weight: 400\">COUNTIF ki\u1ec3m tra t\u1eebng \u00f4 trong ph\u1ea1m vi A2:A6 tr\u00ean m\u1ed7i trang t\u00ednh tra c\u1ee9u so v\u1edbi gi\u00e1 tr\u1ecb trong A2 tr\u00ean trang t\u00ednh ch\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p cho m\u1ed7i trang t\u00ednh. Trong t\u1eadp d\u1eef li\u1ec7u, s\u1ed1 th\u1ee9 t\u1ef1 trong \u00f4 A2 (101) \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong trang t\u00ednh WEST, l\u00e0 th\u1ee9 4 trong ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, v\u00ec v\u1eady COUNTIF tr\u1ea3 v\u1ec1 m\u1ea3ng n\u00e0y:<\/span><\/p>\n<p><span style=\"font-weight: 400\">{0;0;0;1}<\/span><\/p>\n<p><em><span style=\"font-weight: 400\">Ti\u1ebfp theo, b\u1ea1n so s\u00e1nh t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng v\u1edbi 0:\u00a0<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u n\u00e0y t\u1ea1o m\u1ed9t m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb TRUE (l\u1edbn h\u01a1n 0) v\u00e0 FALSE (b\u1eb1ng 0), m\u00e0 b\u1ea1n g\u00e1n c\u00e1c gi\u00e1 tr\u1ecb 1 v\u00e0 0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 (-_) k\u00e9p v\u00e0 k\u1ebft qu\u1ea3 l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400\">{0; 0; 0; 1}<\/span><\/p>\n<p><span style=\"font-weight: 400\">Thao t\u00e1c n\u00e0y l\u00e0 c\u1ea3nh b\u00e1o tr\u01b0\u1edbc c\u00e1c t\u00ecnh hu\u1ed1ng x\u1ea5u khi tra c\u1ee9u trang t\u00ednh bao g\u1ed3m m\u1ed9t s\u1ed1 s\u1ef1 c\u1ed1 tra c\u1ee9u d\u1eef li\u1ec7u, trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3 COUNTIF s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 1, trong khi ch\u00fang ta ch\u1ec9 y\u00eau c\u1ea7u s\u1ed1 1 v\u00e0 0 trong m\u1ea3ng cu\u1ed1i c\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau t\u1ea5t c\u1ea3 c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta tr\u00f4ng nh\u01b0 sau:<\/span><\/p>\n<p><strong>VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;INDEX(Lookup_sheets, MATCH(1, {0;0;0;1}, 0)) &amp;\u201d\u2018!$A$2:$C$6\u201d), 2, FALSE)<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"INDEX_va_MATCH\"><\/span><b>INDEX v\u00e0 MATCH<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u1ea1i th\u1eddi \u0111i\u1ec3m n\u00e0y, k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH:<\/span><\/p>\n<p><strong>INDEX(Lookup_sheets, MATCH(1, {0;0;0;1}, 0))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m MATCH c\u00f3 h\u00ecnh d\u1ea1ng nh\u01b0 kh\u1edbp ch\u00ednh x\u00e1c (exact match) (0 trong tham s\u1ed1 cu\u1ed1i c\u00f9ng) t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb 1 trong m\u1ea3ng {0;0;0;1} v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a n\u00f3 l\u00e0 4:<\/span><\/p>\n<p><strong>INDEX(Lookup_sheets, 4)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m INDEX s\u1eed d\u1ee5ng s\u1ed1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m MATCH nh\u01b0 tham s\u1ed1 h\u00e0ng (row_num) v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 4 trong ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 lookup_sheets l\u00e0 WEST.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec v\u1eady, c\u00f4ng th\u1ee9c ti\u1ebfp t\u1ee5c t\u1ed1i gi\u1ea3n th\u00e0nh:<\/span><\/p>\n<p><strong>\u00a0VLOOKUP($A2, INDIRECT(\u201c\u2018\u201d&amp;\u201dWest\u201d&amp;\u201d\u2018!$A$2:$C$6\u201d), 2, FALSE)<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"VLOOKUP_va_INDIRECT\"><\/span><b>VLOOKUP v\u00e0 INDIRECT\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m INDIRECT x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n b\u00ean trong n\u00f3:<\/span><\/p>\n<p><strong>INDIRECT(\u201c\u2018\u201d&amp;\u201dWest\u201d&amp;\u201d\u2018!$A$2:$C$6\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">V\u00e0 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh m\u1ed9t tham chi\u1ebfu \u0111i \u0111\u1ebfn tham s\u1ed1 table_array c\u1ee7a h\u00e0m VLOOKUP:<\/span><\/p>\n<p><strong>VLOOKUP($A2, \u2018West\u2019!$A$2:$C$6, 2, FALSE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, c\u00f4ng th\u1ee9c VLOOKUP t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb A2 trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea1m vi A2:C6 tr\u00ean trang t\u00ednh WEST v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp t\u1eeb c\u1ed9t th\u1ee9 2.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_dong_tra_ve_du_lieu_tu_nhieu_trang_tinh_vao_cac_o_khac_nhau\"><\/span><b>H\u00e0m VLOOKUP \u0111\u1ed9ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Tr\u01b0\u1edbc h\u1ebft, h\u00e3y x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c t\u1eeb \u201c\u0111\u1ed9ng\u201d <strong>(\u201cdynamic\u201d)<\/strong> c\u00f3 ngh\u0129a l\u00e0 g\u00ec trong ng\u1eef c\u1ea3nh n\u00e0y v\u00e0 c\u00f4ng th\u1ee9c tr\u01b0\u1edbc nh\u01b0 th\u1ebf n\u00e0o.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u00f3 l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u \u1edf c\u00f9ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c chia th\u00e0nh nhi\u1ec1u b\u1ea3ng t\u00ednh, b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t th\u00f4ng tin t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c nhau v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau. H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y s\u1ebd minh h\u1ecda kh\u00e1i ni\u1ec7m n\u00e0y:<\/span><\/p>\n<figure style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m VLOOKUP \u0111\u1ed9ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-multiple-sheets-dynamic.png\" alt=\"VLOOKUP and return data from multiple sheets into different cells\" width=\"530\" height=\"283\"><figcaption class=\"wp-caption-text\">H\u00e0m VLOOKUP \u0111\u1ed9ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh v\u00e0o c\u00e1c \u00f4 kh\u00e1c nhau<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c tr\u01b0\u1edbc, l\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3 d\u1ef1a tr\u00ean m\u1ed9t s\u1ed1 nh\u1eadn bi\u1ebft duy nh\u1ea5t, l\u1ea7n n\u00e0y ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t s\u1ed1 trang t\u00ednh c\u00f9ng m\u1ed9t l\u00fac.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00d3 hai gi\u1ea3i ph\u00e1p kh\u00e1c nhau cho ph\u1ea7n n\u00e0y. Trong c\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c nh\u01b0 chu\u1ea9n b\u1ecb v\u00e0 t\u1ea1o t\u00ean ph\u1ea1m vi cho \u00f4 d\u1eef li\u1ec7u trong m\u1ed7i b\u1ea3ng tra c\u1ee9u. \u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta x\u00e1c \u0111\u1ecbnh c\u00e1c ph\u1ea1m vi sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">East_Sales \u2013 A2: B6 tr\u00ean trang t\u00ednh East<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">North_Sales \u2013 A2: B6 tr\u00ean trang t\u00ednh North<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">South_Sales \u2013 A2: B6 tr\u00ean trang t\u00ednh South<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">West_Sales \u2013 A2: B6 tr\u00ean trang t\u00ednh West<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ham_VLOOKUP_va_ham_IF\"><\/span><b>K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng trang t\u00ednh h\u1ee3p l\u00fd \u0111\u1ec3 tra c\u1ee9u, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n h\u00e0m IF v\u00e0o c\u00f4ng th\u1ee9c \u0111\u1ec3 ch\u1ecdn trang t\u00ednh d\u1ef1a tr\u00ean t\u1eeb kh\u00f3a trong c\u00e1c \u00f4 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u00e1c \u00f4 t\u1eeb B1 \u0111\u1ebfn D1).<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi gi\u00e1 tr\u1ecb tra c\u1ee9u trong A2, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=VLOOKUP($A2, IF(B$1=\u201deast\u201d, East_Sales, IF(B$1=\u201dnorth\u201d, North_Sales, IF(B$1=\u201dsouth\u201d, South_Sales, IF(B$1=\u201dwest\u201d, West_Sales)))), 2, FALSE)<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu B1 l\u00e0 EAST, h\u00e3y t\u00ecm trong ph\u1ea1m vi c\u00f3 t\u00ean East_Sales; n\u1ebfu B1 l\u00e0 North, h\u00e3y t\u00ecm trong ph\u1ea1m vi c\u00f3 t\u00ean North_Sales; n\u1ebfu B1 l\u00e0 South, h\u00e3y t\u00ecm trong ph\u1ea1m vi c\u00f3 t\u00ean South_Sales v\u00e0 n\u1ebfu B1 l\u00e0 West, h\u00e3y t\u00ecm trong ph\u1ea1m vi c\u00f3 t\u00ean West_Sales.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ph\u1ea1m vi \u0111\u01b0\u1ee3c IF tr\u1ea3 v\u1ec1 s\u1ebd chuy\u1ec3n \u0111\u1ebfn table_array c\u1ee7a h\u00e0m VLOOKUP, d\u1ea3i n\u00e0y k\u00e9o gi\u00e1 tr\u1ecb kh\u1edbp t\u1eeb c\u1ed9t th\u1ee9 2 tr\u00ean trang t\u00ednh t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Vi\u1ec7c s\u1eed d\u1ee5ng th\u00f4ng minh c\u00e1c tham chi\u1ebfu h\u1ed7n h\u1ee3p (mixed reference) cho gi\u00e1 tr\u1ecb tra c\u1ee9u ($A2 \u2013 c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i) v\u00e0 ph\u00e9p ki\u1ec3m tra logic \u00cc (B$1 \u2013 c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i) cho ph\u00e9p sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c m\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o \u2013 Excel \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec v\u1eady, ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o B2, sao ch\u00e9p n\u00f3 sang ph\u1ea3i v\u00e0 k\u00e9o xu\u1ed1ng nhi\u1ec1u c\u1ed9t v\u00e0 h\u00e0ng khi c\u1ea7n thi\u1ebft v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng k\u1ebft qu\u1ea3 sau:<\/span><\/p>\n<figure style=\"width: 466px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-if-multiple-sheets-1.png\" alt=\"Dynamic VLOOKUP with nested IFs\" width=\"466\" height=\"199\"><figcaption class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"INDIRECT_VLOOKUP\"><\/span>INDIRECT VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u trang t\u00ednh, nhi\u1ec1u c\u1ea5p \u0111\u1ed9 l\u1ed3ng nhau c\u00f3 th\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i v\u00e0 kh\u00f3 \u0111\u1ecdc. M\u1ed9t c\u00e1ch t\u1ed1t h\u01a1n nhi\u1ec1u l\u00e0 t\u1ea1o m\u1ed9t h\u00e0m vlookup \u0111\u1ed9ng v\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a INDIRECT<\/p>\n<p><code>=VLOOKUP($A2, INDIRECT(B$1&amp;\"_Sales\"), 2, FALSE)<\/code><\/p>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y, ch\u00fang ta n\u1ed1i tham chi\u1ebfu v\u1edbi \u00f4 ch\u1ee9a t\u00ean ph\u1ea1m vi duy nh\u1ea5t (B1) v\u00e0 ph\u1ea7n chung (_Sales). \u0110i\u1ec1u n\u00e0y t\u1ea1o ra m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 \u201cEast_Sales\u201d, m\u00e0 INDIRECT chuy\u1ec3n th\u00e0nh t\u00ean ph\u1ea1m vi m\u00e0 Excel c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c tr\u00ean b\u1ea5t k\u1ef3 s\u1ed1 l\u01b0\u1ee3ng trang t\u00ednh n\u00e0o:<\/span><\/p>\n<figure style=\"width: 344px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"INDIRECT VLOOKUP\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-indirect-dynamic.png\" alt=\"INDIRECT VLOOKUP formula to look up dynamically in multiple sheets\" width=\"344\" height=\"178\"><figcaption class=\"wp-caption-text\">INDIRECT VLOOKUP<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft tr\u00ean ch\u00fang t\u00f4i<\/span><span style=\"font-weight: 400\">\u00a0\u0111\u00e3 h\u01b0\u1edbng d\u1eabn th\u00eam m\u1ed9t <\/span><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><em><strong><span class=\"keyword _ngcontent-gas-80\" aria-hidden=\"false\">c\u00e1ch d\u00f9ng h\u00e0m vlookup.<\/span><\/strong><\/em><\/a><span style=\"font-weight: 400\">\u00a0C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 h\u00e3y theo d\u00f5i <\/span><b>H\u1ecdc Excel Online<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 c\u00f3 th\u1ec3 b\u1ed5 sung th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c, th\u00e0nh t\u1ea1o excel trong nh\u1eefng blog ti\u1ebfp theo nh\u00e9!<\/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-207.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2679,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2678","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\/2678","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=2678"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2679"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}