{"id":6780,"date":"2024-12-21T16:09:13","date_gmt":"2024-12-21T16:09:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap\/"},"modified":"2024-12-21T16:09:13","modified_gmt":"2024-12-21T16:09:13","slug":"ham-vlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-vlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap\/","title":{"rendered":"H\u00e0m vlookup trong Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng n\u00e2ng cao th\u01b0\u1eddng g\u1eb7p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m VLOOKUP n\u00e0y, Blog H\u1ecdc Excel Online\u00a0s\u1ebd c\u1ed1 g\u1eafng d\u00f9ng t\u1eeb ng\u1eef \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 gi\u1ea3i th\u00edch nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n nh\u1eb1m gi\u00fap qu\u00e1 tr\u00ecnh h\u1ecdc cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u tr\u1edf n\u00ean d\u1ec5 d\u00e0ng nh\u1ea5t c\u00f3 th\u1ec3. Ch\u00fang ta c\u0169ng s\u1ebd kh\u00e1m ph\u00e1 v\u00e0i c\u00f4ng th\u1ee9c m\u1eabu cho th\u1ea5y c\u00e1ch d\u00f9ng th\u00f4ng d\u1ee5ng nh\u1ea5t c\u1ee7a h\u00e0m VLOOKUP trong Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766e82818199\" 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-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#HAM_VLOOKUP_TRONG_EXCEL_%E2%80%93_BAN_MIEU_TA_DON_GIAN_VA_CAU_TRUC\" title=\"H\u00c0M VLOOKUP TRONG EXCEL \u2013 B\u1ea2N MI\u00caU T\u1ea2 \u0110\u01a0N GI\u1ea2N V\u00c0 C\u1ea4U TR\u00daC\">H\u00c0M VLOOKUP TRONG EXCEL \u2013 B\u1ea2N MI\u00caU T\u1ea2 \u0110\u01a0N GI\u1ea2N V\u00c0 C\u1ea4U TR\u00daC<\/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-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#CU_PHAP_HAM_VLOOKUP_TRONG_EXCEL\" title=\"C\u00da PH\u00c1P H\u00c0M VLOOKUP TRONG EXCEL\">C\u00da PH\u00c1P H\u00c0M VLOOKUP TRONG EXCEL<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VI_DU_HAM_VLOOKUP_TRONG_EXCEL\" title=\"V\u00cd D\u1ee4 H\u00c0M VLOOKUP TRONG EXCEL\">V\u00cd D\u1ee4 H\u00c0M VLOOKUP TRONG EXCEL<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#CACH_DUNG_HAM_VLOOKUP_TRONG_EXCEL_TU_MOT_BANG_TINH_KHAC\" title=\"C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP TRONG EXCEL T\u1eea M\u1ed8T B\u1ea2NG T\u00cdNH KH\u00c1C\">C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP TRONG EXCEL T\u1eea M\u1ed8T B\u1ea2NG T\u00cdNH KH\u00c1C<\/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-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#CACH_DUNG_HAM_VLOOKUP_TU_MOT_SO_LAM_VIEC_KHAC\" title=\"C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP T\u1eea M\u1ed8T S\u1ed4 L\u00c0M VI\u1ec6C KH\u00c1C\">C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP T\u1eea M\u1ed8T S\u1ed4 L\u00c0M VI\u1ec6C KH\u00c1C<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#CACH_SU_DUNG_TEN_CHO_DAI_O_HAY_BANG_TRONG_CONG_THUC_VLOOKUP\" title=\"C\u00c1CH S\u1eec D\u1ee4NG T\u00caN CHO D\u1ea2I \u00d4 HAY B\u1ea2NG TRONG C\u00d4NG TH\u1ee8C VLOOKUP\">C\u00c1CH S\u1eec D\u1ee4NG T\u00caN CHO D\u1ea2I \u00d4 HAY B\u1ea2NG TRONG C\u00d4NG TH\u1ee8C VLOOKUP<\/a><\/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-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VIEC_SU_DUNG_KY_TU_DAI_DIEN_TRONG_CONG_THUC_VLOOKUP\" title=\"VI\u1ec6C S\u1eec D\u1ee4NG K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N TRONG C\u00d4NG TH\u1ee8C VLOOKUP\">VI\u1ec6C S\u1eec D\u1ee4NG K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N TRONG C\u00d4NG TH\u1ee8C VLOOKUP<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VI_DU_1_TIM_KIEM_CHUOI_KY_TU_BAT_DAU_HAY_KET_THUC_BANG_CAC_KY_TU_NHAT_DINH\" title=\"V\u00cd D\u1ee4 1. T\u00ccM KI\u1ebeM CHU\u1ed6I K\u00dd T\u1ef0 B\u1eaeT \u0110\u1ea6U HAY K\u1ebeT TH\u00daC B\u1eb0NG C\u00c1C K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH\">V\u00cd D\u1ee4 1. T\u00ccM KI\u1ebeM CHU\u1ed6I K\u00dd T\u1ef0 B\u1eaeT \u0110\u1ea6U HAY K\u1ebeT TH\u00daC B\u1eb0NG C\u00c1C K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VI_DU_2_CONG_THUC_VLOOKUP_CO_KY_TU_DAI_DIEN_DUA_TREN_GIA_TRI_O\" title=\"V\u00cd D\u1ee4 2. C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N D\u1ef0A TR\u00caN GI\u00c1 TR\u1eca \u00d4\">V\u00cd D\u1ee4 2. C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N D\u1ef0A TR\u00caN GI\u00c1 TR\u1eca \u00d4<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VIEC_SU_DUNG_CONG_THUC_VLOOKUP_CO_GIA_TRI_TIM_KIEM_CHINH_XAC_VA_GIA_TRI_TIM_KIEM_TUONG_DOI\" title=\"VI\u1ec6C S\u1eec D\u1ee4NG C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C V\u00c0 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM T\u01af\u01a0NG \u0110\u1ed0I\">VI\u1ec6C S\u1eec D\u1ee4NG C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C V\u00c0 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM T\u01af\u01a0NG \u0110\u1ed0I<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VI_DU_1_CACH_SU_DUNG_HAM_VLOOKUP_CO_GIA_TRI_TIM_KIEM_CHINH_XAC_TRONG_EXCEL\" title=\"V\u00cd D\u1ee4 1. C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C TRONG EXCEL\">V\u00cd D\u1ee4 1. C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C TRONG EXCEL<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#VI_DU_2_SU_DUNG_HAM_VLOOKUP_CO_GIA_TRI_CAN_TIM_TUONG_DOI_TRONG_EXCEL\" title=\"V\u00cd D\u1ee4 2. S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca C\u1ea6N T\u00ccM T\u01af\u01a0NG \u0110\u1ed0I TRONG EXCEL\">V\u00cd D\u1ee4 2. S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca C\u1ea6N T\u00ccM T\u01af\u01a0NG \u0110\u1ed0I TRONG EXCEL<\/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\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html#HAM_VLOOKUP_TRONG_EXCEL_%E2%80%93_NHUNG_DIEU_CAN_NHO\" title=\"H\u00c0M VLOOKUP TRONG EXCEL \u2013 NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda!\">H\u00c0M VLOOKUP TRONG EXCEL \u2013 NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda!<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_VLOOKUP_TRONG_EXCEL_%E2%80%93_BAN_MIEU_TA_DON_GIAN_VA_CAU_TRUC\"><\/span>H\u00c0M VLOOKUP TRONG EXCEL \u2013 B\u1ea2N MI\u00caU T\u1ea2 \u0110\u01a0N GI\u1ea2N V\u00c0 C\u1ea4U TR\u00daC<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1eady h\u00e0m VLOOKUP l\u00e0 g\u00ec? \u0110\u1ec3 b\u1eaft \u0111\u1ea7u, n\u00f3 l\u00e0 m\u1ed9t h\u00e0m trong Excel. \ud83d\ude42 N\u00f3 d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec? N\u00f3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n \u0111\u1ecbnh r\u00f5 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf m\u1ed9t c\u1ed9t kh\u00e1c. N\u00f3i m\u1ed9t c\u00e1ch k\u1ef9 thu\u1eadt h\u01a1n, h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean trong trong d\u1ea3i \u00f4 x\u00e1c \u0111\u1ecbnh, r\u1ed3i tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong c\u00f9ng m\u1ed9t h\u00e0ng t\u1eeb m\u1ed9t \u00f4 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">\u1ede c\u00e1ch d\u00f9ng th\u00f4ng d\u1ee5ng nh\u1ea5t, h\u00e0m VLOOKUP trong Excel t\u00ecm ki\u1ebfm th\u00f4ng qua danh s\u00e1ch d\u1eef li\u1ec7u \u00a0b\u1ea1n t\u1ea1o ra d\u1ef1a tr\u00ean k\u00fd hi\u1ec7u nh\u1eadn d\u1ea1ng \u0111\u1eb7c bi\u1ec7t r\u1ed3i tr\u1ea3 v\u1ec1 cho b\u1ea1n m\u1ed9t m\u1ea9u th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng v\u1edbi k\u00fd hi\u1ec7u nh\u1eadn d\u1ea1ng \u0111\u1eb7c bi\u1ec7t \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">K\u00fd t\u1ef1 \u201cV\u201d trong h\u00e0m VLOOKUP l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb \u201cvertical\u201d (\u201cth\u1eb3ng \u0111\u1ee9ng\u201d). K\u00fd t\u1ef1 \u0111\u00f3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t h\u00e0m VLOOKUP v\u00e0 h\u00e0m HLOOKUP \u2013 \u0111\u00e2y l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u1eeb h\u00e0ng tr\u00ean c\u00f9ng c\u1ee7a m\u1ea3ng (H l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb \u201chorizontal\u201d (\u201cn\u1eb1m ngang\u201d)).<\/p>\n<p style=\"text-align: justify\">H\u00e0m VLOOKUP c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 phi\u00ean b\u1ea3n, g\u1ed3m Excel 2013, Excel 2010, Excel 2007, Excel 2007, Excel XP v\u00e0 Excel 2000.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CU_PHAP_HAM_VLOOKUP_TRONG_EXCEL\"><\/span>C\u00da PH\u00c1P H\u00c0M VLOOKUP TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m VLOOKUP trong Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/em><\/strong><\/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-608.gif\" title=\"ex101_92019-nho-608\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a n\u1eafm r\u00f5 c\u00e1c \u00fd ngh\u0129a c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Vlookup v\u00e0 c\u00e1ch th\u1ee9c ch\u00fang ho\u1ea1t \u0111\u1ed9ng th\u00ec h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y tr\u01b0\u1edbc<strong><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 trong Excel<\/a> v\u00e0 c\u00e1c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft qua c\u00e1c v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u\u00a0<\/strong>tr\u01b0\u1edbc khi \u0111\u1ecdc ph\u1ea7n n\u1ed9i dung ph\u00eda \u0111\u01b0\u1edbi b\u1ea1n nh\u00e9! N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecdc \u0111\u1ec3 hi\u1ec3u b\u1ea3n ch\u1ea5t v\u00e0 \u1ee9ng d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c ch\u1ee9 kh\u00f4ng ph\u1ea3i \u201cc\u01b0\u1ee1i ng\u1ef1a xem hoa\u201d<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: C\u00e1c\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_HAM_VLOOKUP_TRONG_EXCEL\"><\/span>V\u00cd D\u1ee4 H\u00c0M VLOOKUP TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u00f4i hy v\u1ecdng r\u1eb1ng b\u1ea1n \u0111\u00e3 quen d\u1ea7n v\u1edbi h\u00e0m VLOOKUP. B\u00e2y gi\u1edd, h\u00e3y kh\u00e1m ph\u00e1 v\u00e0i v\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c VLOOKUP cho d\u1eef li\u1ec7u th\u1ef1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DUNG_HAM_VLOOKUP_TRONG_EXCEL_TU_MOT_BANG_TINH_KHAC\"><\/span>C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP TRONG EXCEL T\u1eea M\u1ed8T B\u1ea2NG T\u00cdNH KH\u00c1C<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong th\u1ef1c ti\u1ec5n, c\u00f4ng th\u1ee9c VLOOKUP r\u1ea5t hi\u1ebfm khi \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh. Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n s\u1ebd ph\u1ea3i t\u00ecm ki\u1ebfm v\u00e0 k\u00e9o d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng v\u1ec1 t\u1eeb b\u1ea3ng t\u00ednh kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 d\u00f9ng h\u00e0m VLOOKUP t\u1eeb b\u1ea3ng t\u00ednh Excel kh\u00e1c, b\u1ea1n n\u00ean nh\u1eadp t\u00ean b\u1ea3ng t\u00ednh v\u00e0 m\u1ed9t d\u1ea5u c\u1ea3m th\u00e1n trong c\u00e2u l\u1ec7nh table_array tr\u01b0\u1edbc d\u1ea3i \u00f4, v\u00ed d\u1ee5 =VLOOKUP(40, Sheet2!A2:B15, 2). C\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 ra r\u1eb1ng d\u1ea3i \u00f4 t\u00ecm ki\u1ebfm A2:B15 n\u1eb1m \u1edf Sheet2.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1eadp t\u00ean b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. Ch\u1ec9 c\u1ea7n b\u1eaft \u0111\u1ea7u g\u00f5 c\u00f4ng th\u1ee9c v\u00e0 khi g\u00f5 \u0111\u1ebfn c\u00e2u l\u1ec7nh table_array, h\u00e3y \u0111\u1ed5i sang b\u1ea3ng t\u00ednh c\u1ea7n t\u00ecm v\u00e0 d\u00f9ng chu\u1ed9t \u0111\u1ec3 ch\u1ecdn d\u1ea3i \u00f4.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y t\u00ecm ki\u1ebfm chu\u1ed7i k\u00fd t\u1ef1 \u201cProduct 1\u201d (\u201cS\u1ea3n ph\u1ea9m 1\u201d) trong c\u1ed9t A (c\u1ed9t \u0111\u1ea7u ti\u00ean trong d\u1ea3i \u00f4 c\u1ea7n t\u00ecm A2:B9) \u1edf b\u1ea3ng t\u00ednh Gi\u00e1 ti\u1ec1n:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cProduct 1\u201d, Prices!$A$2:$B$9, 2, FALSE)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5644 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/22-4.png\" width=\"436\" height=\"247\" title=\"22-4\"><\/p>\n<p style=\"text-align: justify\">Xin h\u00e3y ch\u00fa \u00fd r\u1eb1ng b\u1ea1n ph\u1ea3i \u0111\u1eb7t gi\u00e1 tr\u1ecb chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n t\u00ecm trong d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c\u201d) nh\u01b0 c\u00e1ch b\u1ea1n th\u01b0\u1eddng l\u00e0m trong c\u00e1c c\u00f4ng th\u1ee9c Excel.<\/p>\n<p style=\"text-align: justify\">M\u1eb9o. Lu\u00f4n lu\u00f4n d\u00f9ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i (c\u00f3 $) trong th\u00f4ng s\u1ed1 table_array c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP l\u00e0 m\u1ed9t \u00fd t\u01b0\u1edfng tuy\u1ec7t v\u1eddi. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, d\u1ea3i \u00f4 c\u1ea7n t\u00ecm s\u1ebd kh\u00f4ng thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c sang \u00f4 kh\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DUNG_HAM_VLOOKUP_TU_MOT_SO_LAM_VIEC_KHAC\"><\/span>C\u00c1CH D\u00d9NG H\u00c0M VLOOKUP T\u1eea M\u1ed8T S\u1ed4 L\u00c0M VI\u1ec6C KH\u00c1C<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 d\u00f9ng h\u00e0m VLOOKUP gi\u1eefa hai s\u1ed5 l\u00e0m vi\u1ec7c Excel kh\u00e1c nhau, b\u1ea1n n\u00ean \u0111\u1eb7t t\u00ean s\u1ed5 l\u00e0m vi\u1ec7c trong d\u1ea5u ngo\u1eb7c vu\u00f4ng tr\u01b0\u1edbc t\u00ean b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u201c40\u201d trong Sheet2 c\u1ee7a s\u1ed5 l\u00e0m vi\u1ec7c Numbers.xlsx:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(40, [Numbers.xlsx]Sheet2!A2:B15, 2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00e2y l\u00e0 c\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c VLOOKUP trong Excel tham chi\u1ebfu \u0111\u1ebfn s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c:<\/p>\n<p style=\"text-align: justify\">M\u1edf c\u1ea3 hai s\u1ed5 l\u00e0m vi\u1ec7c. B\u01b0\u1edbc n\u00e0y kh\u00f4ng b\u1eaft bu\u1ed9c, nh\u01b0ng n\u00f3 s\u1ebd gi\u00fap vi\u1ec7c l\u1eadp c\u00f4ng th\u1ee9c d\u1ec5 d\u00e0ng h\u01a1n b\u1edfi v\u00ec b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i g\u00f5 t\u00ean s\u1ed5 l\u00e0m vi\u1ec7c m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. B\u00ean c\u1ea1nh \u0111\u00f3, \u0111i\u1ec1u \u0111\u00f3 c\u0169ng s\u1ebd b\u1ea3o v\u1ec7 c\u00f4ng th\u1ee9c \u00a0c\u1ee7a b\u1ea1n kh\u1ecfi l\u1ed7i v\u00f4 t\u00ecnh in sai.<\/p>\n<p style=\"text-align: justify\">B\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c VLOOKUP, r\u1ed3i \u0111\u1ed1i v\u1edbi c\u00e2u l\u1ec7nh table_array, th\u00ec h\u00e3y \u0111\u1ed5i sang s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c r\u1ed3i ch\u1ecdn d\u1ea3i \u00f4 c\u1ea7n t\u00ecm ki\u1ebfm \u1edf \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">\u1ede c\u00f4ng th\u1ee9c b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, s\u1ed5 l\u00e0m vi\u1ec7c c\u1ea7n t\u00ecm l\u00e0 PriceList.xlsx v\u00e0 b\u1ea3ng tinh c\u1ea7n t\u00ecm l\u00e0 Prices.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5645 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/23-2.png\" width=\"432\" height=\"245\" title=\"23-2\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t khi b\u1ea1n \u0111\u00f3ng s\u1ed5 l\u00e0m vi\u1ec7c c\u00f3 b\u1ea3ng c\u1ea7n t\u00ecm th\u00ec c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n s\u1ebd v\u1eabn ch\u1ea1y, nh\u01b0ng n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 \u0111\u01b0\u1eddng d\u1eabn t\u1edbi s\u1ed5 l\u00e0m vi\u1ec7c c\u1ea7n t\u00ecm, nh\u01b0 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5646 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-1.png\" width=\"598\" height=\"236\" title=\"24-1\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd<\/strong>. N\u1ebfu ho\u1eb7c t\u00ean s\u1ed5 l\u00e0m vi\u1ec7c ho\u1eb7c t\u00ean b\u1ea3ng t\u00ednh c\u00f3 kho\u1ea3ng tr\u1ed1ng, th\u00ec b\u1ea1n n\u00ean \u0111\u1eb7t ch\u00fang trong d\u1ea5u =<strong><em>VLOOKUP(40, \u2018[Numbers.xlsx]Sheet2\u2019!A2:B15,2)<\/em><\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u1eebng b\u1ecf l\u1ee1: T\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2003\">t\u1ef1 h\u1ecdc Excel 2003<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_SU_DUNG_TEN_CHO_DAI_O_HAY_BANG_TRONG_CONG_THUC_VLOOKUP\"><\/span>C\u00c1CH S\u1eec D\u1ee4NG T\u00caN CHO D\u1ea2I \u00d4 HAY B\u1ea2NG TRONG C\u00d4NG TH\u1ee8C VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, n\u1ebfu ph\u1ea3i s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t d\u1ea3i \u00f4 c\u1ea7n t\u00ecm \u00a0trong v\u00e0i c\u00f4ng th\u1ee9c VLOOKUP, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o t\u00ean cho m\u1ed9t d\u1ea3i \u00f4 r\u1ed3i nh\u1eadp tr\u1ef1c ti\u1ebfp t\u00ean c\u1ee7a d\u1ea3i \u00f4 v\u00e0o c\u00f4ng th\u1ee9c thay v\u00ec ph\u1ea3i nh\u1eadp v\u00f9ng c\u1ea7n t\u00ecm (c\u00e2u l\u1ec7nh table_array).<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o t\u00ean cho d\u1ea3i \u00f4, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn d\u1ea3i \u00f4 \u0111\u00f3 v\u00e0 g\u00f5 b\u1ea5t k\u1ef3 t\u00ean n\u00e0o v\u00e0o Name box (H\u1ed9p t\u00ean) \u2013 \u1edf b\u00ean tr\u00e1i thanh C\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5647 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/25-1.png\" width=\"376\" height=\"251\" title=\"25-1\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c VLOOKUP d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm gi\u00e1 c\u1ee7a S\u1ea3n ph\u1ea9m 1:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cProduct 1\u201d, Products, 2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">H\u1ea7u h\u1ebft t\u00ean d\u1ea3i \u00f4 trong Excel \u0111\u1ec1u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho to\u00e0n b\u1ed9 s\u1ed5 l\u00e0m vi\u1ec7c, n\u00ean b\u1ea1n kh\u00f4ng c\u1ea7n \u0111\u1ecbnh r\u00f5 t\u00ean c\u1ee7a b\u1ea3ng t\u00ednh trong c\u00e2u l\u1ec7nh table_array, d\u00f9 cho d\u1ea3i \u00f4 b\u1ea1n c\u1ea7n t\u00ecm n\u1eb1m \u1edf b\u1ea3ng t\u00ednh kh\u00e1c. N\u1ebfu n\u00f3 n\u1eb1m \u1edf s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c, th\u00ec b\u1ea1n ph\u1ea3i \u0111\u1eb7t t\u00ean s\u1ed5 l\u00e0m vi\u1ec7c ph\u00eda tr\u01b0\u1edbc t\u00ean d\u1ea3i \u00f4, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cProduct 1\u201d, PriceList.xlsx!Products,2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u1eefng c\u00f4ng th\u1ee9c nh\u01b0 th\u1ebf n\u00e0y n\u00e0y d\u1ec5 hi\u1ec3u h\u01a1n r\u1ea5t nhi\u1ec1u, \u0111\u00fang kh\u00f4ng? B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c s\u1eed d\u1ee5ng t\u00ean cho d\u1ea3i \u00f4 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ef1 thay th\u1ebf tuy\u1ec7t v\u1eddi cho tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i. B\u1edfi v\u00ec t\u00ean d\u1ea3i \u00f4 kh\u00f4ng \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 ch\u1eafc r\u1eb1ng b\u1ea1n s\u1ebd lu\u00f4n t\u00ecm \u0111\u00fang d\u1ea3i \u00f4.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 \u0111\u1ed5i d\u1ea3i \u00f4 th\u00e0nh b\u1ea3ng Excel c\u00f3 \u0111\u1ea7y \u0111\u1ee7 t\u00ednh n\u0103ng (<em>Insert tab &gt; Table<\/em>), th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng chu\u1ed9t ch\u1ecdn d\u1ea3i \u00f4, v\u00e0 Microsoft Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam t\u00ean c\u00e1c c\u1ed9t (hay t\u00ean b\u1ea3ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n \u0111\u00e3 ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng) v\u00e0o c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5649 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/26-1.png\" width=\"574\" height=\"237\" title=\"26-1\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 c\u00f3 th\u1ec3 tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cProduct 1\u201d, Table46[[Product]:[Price]],2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">hay th\u1eadm ch\u00ed l\u00e0 c\u00f3 d\u1ea1ng nh\u01b0 th\u1ebf n\u00e0y: <strong><em>=VLOOKUP(\u201cProduct 1\u201d, Table46,2)<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VIEC_SU_DUNG_KY_TU_DAI_DIEN_TRONG_CONG_THUC_VLOOKUP\"><\/span>VI\u1ec6C S\u1eec D\u1ee4NG K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N TRONG C\u00d4NG TH\u1ee8C VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u0169ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho h\u00e0m VLOOKUP trong Excel:<\/p>\n<p style=\"text-align: justify\">D\u1ea5u ch\u1ea5m h\u1ecfi (?) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t c\u1ee9 k\u00fd t\u1ef1 ri\u00eang l\u1ebb n\u00e0o, v\u00e0<\/p>\n<p style=\"text-align: justify\">D\u1ea5u sao (*) \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 d\u00e3y k\u00fd t\u1ef1 n\u00e0o.<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong c\u00f4ng th\u1ee9c VLOOKUP c\u00f3 th\u1ec3 r\u1ea5t h\u1eefu \u00edch trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n kh\u00f4ng nh\u1edb ch\u00ednh x\u00e1c chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n mu\u1ed1n t\u00ecm m\u1ed9t t\u1eeb n\u00e0o \u0111\u00f3. T\u1eeb \u0111\u00f3 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a n\u1ed9i dung \u00f4. H\u00e3y ch\u00fa \u00fd r\u1eb1ng h\u00e0m VLOOKUP t\u00ecm ki\u1ebfm to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4, nh\u01b0 th\u1ec3 b\u1ea1n \u0111\u00e3 ch\u1ecdn \u201cMatch the entire content\u201d (\u201cKh\u1edbp to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4\u201d) trong t\u01b0\u01a1ng t\u00e1c T\u00ecm ki\u1ebfm chu\u1ea9n c\u1ee7a Excel.<\/p>\n<p style=\"text-align: justify\">Khi c\u1ed9t c\u1ea7n t\u00ecm c\u00f3 kho\u1ea3ng tr\u1ed1ng th\u1ee5t \u0111\u1ea7u d\u00f2ng hay cu\u1ed1i d\u00f2ng. N\u1ebfu g\u1eb7p tr\u01b0\u1eddng h\u1ee3p n\u00e0y, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 v\u1eaft \u00f3c c\u1ed1 t\u00ecm ra l\u00fd do t\u1ea1i sao c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng c\u1ee7a b\u1ea1n l\u1ea1i kh\u00f4ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_1_TIM_KIEM_CHUOI_KY_TU_BAT_DAU_HAY_KET_THUC_BANG_CAC_KY_TU_NHAT_DINH\"><\/span>V\u00cd D\u1ee4 1. T\u00ccM KI\u1ebeM CHU\u1ed6I K\u00dd T\u1ef0 B\u1eaeT \u0110\u1ea6U HAY K\u1ebeT TH\u00daC B\u1eb0NG C\u00c1C K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n t\u00ecm m\u1ed9t kh\u00e1ch h\u00e0ng nh\u1ea5t \u0111\u1ecbnh trong c\u01a1 s\u1edf d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n kh\u00f4ng th\u1ec3 nh\u1edb t\u00ean c\u1ee7a anh \u1ea5y, nh\u01b0ng b\u1ea1n bi\u1ebft r\u1eb1ng n\u00f3 b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cack\u201d. V\u1eady th\u00ec, h\u00e0m VLOOKUP d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n r\u1ea5t nhi\u1ec1u \u0111\u1ea5y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cack*\u201d,$A$2:$C$11,1,FALSE)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5650 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/27-1.png\" width=\"529\" height=\"287\" title=\"27-1\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t khi b\u1ea1n ch\u1eafc m\u00ecnh \u0111\u00e3 t\u00ecm \u0111\u00fang t\u00ean r\u1ed3i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c VLOOKUP t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 t\u00ecm s\u1ed1 ti\u1ec1n ng\u01b0\u1eddi kh\u00e1ch h\u00e0ng \u1ea5y \u0111\u00e3 tr\u1ea3. B\u1ea1n ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i th\u00f4ng s\u1ed1 th\u1ee9 ba trong c\u00f4ng th\u1ee9c th\u00e0nh s\u1ed1 th\u1ee9 c\u1ed9t m\u00e0 b\u1ea1n c\u1ea7n t\u00ecm, \u0111\u00f3 l\u00e0 c\u1ed9t C (3) trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201cack*\u201d,$A$2:$C$11,3,FALSE)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00e2y l\u00e0 th\u00eam v\u00e0i v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m VLOOKUP c\u00f3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201c*man\u201d,$A$2:$C$11,1,FALSE)<\/em><\/strong> \u2013 t\u00ecm t\u00ean k\u1ebft th\u00fac b\u1eb1ng \u201cman\u201d.<\/p>\n<p style=\"text-align: justify\"><em><strong>=VLOOKUP(\u201cad*son\u201d,$A$2:$C$11,1,FALSE)<\/strong> <\/em>\u2013 t\u00ecm t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cad\u201d v\u00e0 k\u1ebft th\u00fac b\u1eb1ng \u201cson\u201d.<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201c?????\u201d,$A$2:$C$11,1,FALSE)<\/em><\/strong> \u2013 t\u00ecm h\u1ecd c\u00f3 n\u0103m k\u00fd t\u1ef1.<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd. \u0110\u1ec3 c\u00f4ng th\u1ee9c VLOOKUP c\u00f3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ch\u1ea1y ch\u00ednh x\u00e1c, b\u1ea1n ph\u1ea3i lu\u00f4n th\u00eam FALSE nh\u01b0 m\u1ed9t th\u00f4ng s\u1ed1 cu\u1ed1i c\u00f9ng. N\u1ebfu d\u1ea3i \u00f4 c\u1ea7n t\u00ecm c\u1ee7a b\u1ea1n c\u00f3 h\u01a1n m\u1ed9t m\u1ee5c nh\u1eadp kh\u1edbp v\u1edbi ti\u00eau chu\u1ea9n \u0111\u1ea1i di\u1ec7n, th\u00ec gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_2_CONG_THUC_VLOOKUP_CO_KY_TU_DAI_DIEN_DUA_TREN_GIA_TRI_O\"><\/span>V\u00cd D\u1ee4 2. C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 K\u00dd T\u1ef0 \u0110\u1ea0I DI\u1ec6N D\u1ef0A TR\u00caN GI\u00c1 TR\u1eca \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y th\u1ea3o lu\u1eadn th\u00eam v\u1ec1 m\u1ed9t v\u00ed d\u1ee5 ph\u1ee9c t\u1ea1p h\u01a1n \u2013 \u0111\u00f3 l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u1edf m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3. Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u00e3 b\u1ea3n quy\u1ec1n \u1ecf c\u1ed9t A v\u00e0 t\u00ean b\u1ea3n quy\u1ec1n \u1edf c\u1ed9t B. B\u1ea1n c\u0169ng c\u00f3 m\u1ed9t ph\u1ea7n (v\u00e0i k\u00fd t\u1ef1) c\u1ee7a m\u1ed9t m\u00e3 b\u1ea3n quy\u1ec1n n\u00e0o \u0111\u00f3 \u1edf c\u1ed9t C1 v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm T\u00ean B\u1ea3n quy\u1ec1n t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=VLOOKUP(\u201c*\u201d&amp;C1&amp;\u201d*\u201d, $A$2:$B$12, 2, FALSE)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u1edf \u00f4 C1 th\u00f4ng qua m\u1ed9t d\u1ea3i \u00f4 x\u00e1c \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t B. Xin h\u00e3y ch\u00fa \u00fd r\u1eb1ng ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u v\u00e0 (&amp;) tr\u01b0\u1edbc v\u00e0 sau m\u1ed9t tham chi\u1ebfu \u00f4 trong th\u00f4ng s\u1ed1 \u0111\u1ea7u ti\u00ean nh\u1eb1m n\u1ed1i chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, h\u00e0m VLOOKUP c\u1ee7a t\u00f4i tr\u1ea3 v\u1ec1 \u201cJeremy Hill\u201d b\u1edfi v\u00ec m\u00e3 b\u1ea3n quy\u1ec1n c\u1ee7a anh \u1ea5y c\u00f3 m\u1ed9t nh\u00f3m k\u00fd t\u1ef1 n\u1eb1m trong \u00f4 C1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5651 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/28-1.png\" width=\"521\" height=\"307\" title=\"28-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed3ng th\u1eddi, xin h\u00e3y ch\u00fa \u00fd c\u00e2u l\u1ec7nh table_array trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean. N\u00f3 c\u00f3 t\u00ean b\u1ea3ng (\u201cB\u1ea3ng 7\u201d) thay v\u00ec d\u1ea3i \u00f4, \u0111i\u1ec1u n\u00e0y ch\u00fang ta \u0111\u00e3 b\u00e0n \u1edf v\u00ed d\u1ee5 tr\u00ean.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VIEC_SU_DUNG_CONG_THUC_VLOOKUP_CO_GIA_TRI_TIM_KIEM_CHINH_XAC_VA_GIA_TRI_TIM_KIEM_TUONG_DOI\"><\/span>VI\u1ec6C S\u1eec D\u1ee4NG C\u00d4NG TH\u1ee8C VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C V\u00c0 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM T\u01af\u01a0NG \u0110\u1ed0I<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, h\u00e3y xem x\u00e9t k\u1ef9 c\u00e2u l\u1ec7nh cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n nh\u1eadp v\u00e0o h\u00e0m VLOOKUP trong Excel \u2013 range_lookup. V\u00ec \u0111\u00e3 \u0111\u01b0\u1ee3c n\u00f3i \u0111\u1ebfn \u1edf \u0111\u1ea7u b\u00e0i h\u01b0\u1edbng d\u1eabn, c\u00e2u l\u1ec7nh n\u00e0y c\u1ef1c k\u1ef3 quan tr\u1ecdng b\u1edfi v\u00ec b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 kh\u00e1c nhau t\u00f9y v\u00e0o b\u1ea1n nh\u1eadp TRUE hay FALSE.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, h\u00e3y xem \u201cgi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c\u201d v\u00e0 \u201cgi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i\u201d trong Microsoft Excel th\u1eadt s\u1ef1 c\u00f3 ngh\u0129a g\u00ec.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu range_lookup \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t l\u00e0 FALSE, th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u00ecm ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb, v\u00ed d\u1ee5, c\u00f4ng th\u1ee9c s\u1ebd t\u00ecm ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u00f3 l\u00e0m th\u00f4ng s\u1ed1 th\u1ee9 nh\u1ea5t (lookup_value).<\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f3 hai hay nhi\u1ec1u h\u01a1n hai gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a table_array kh\u1edbp v\u1edbi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm, th\u00ec k\u1ebft qu\u1ea3 t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c, th\u00ec l\u1ed7i #N\/A s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =VLOOKUP(4, A2:B15,2,FALSE), nh\u01b0ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb 4 t\u1eeb \u00f4 A2 \u0111\u1ebfn c\u1ed9t A15, th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu range_lookup \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t th\u00e0nh TRUE hay \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf, th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u00ecm s\u1ef1 ph\u00f9 h\u1ee3p t\u01b0\u01a1ng \u0111\u1ed1i. N\u00f3i ch\u00ednh x\u00e1c h\u01a1n, c\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a b\u1ea1n s\u1ebd t\u00ecm ki\u1ebfm s\u1ef1 ph\u00f9 h\u1ee3p tuy\u1ec7t \u0111\u1ed1i \u0111\u1ea7u ti\u00ean v\u00e0 n\u1ebfu s\u1ef1 ph\u00f9 h\u1ee3p tuy\u1ec7t \u0111\u1ed1i kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 s\u1ef1 ph\u00f9 h\u1ee3p t\u01b0\u01a1ng \u0111\u1ed1i. G\u00eda tr\u1ecb t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ti\u1ebfp theo, ch\u1ec9 nh\u1ecf h\u01a1n lookup_value.<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd quan tr\u1ecdng! N\u1ebfu b\u1ea1n nh\u1eadp TRUE hay lo\u1ea1i b\u1ecf c\u00e2u l\u1ec7nh range_lookup, th\u00ec c\u00e1c gi\u00e1 tr\u1ecb \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1ea3i \u00f4 c\u1ea7n t\u00ecm ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, \u0111\u00f3 l\u00e0 t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t. N\u1ebfu kh\u00f4ng th\u00ec, h\u00e0m VLOOKUP trong Excel c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft th\u00eam t\u1ea7m quan tr\u1ecdng c\u1ee7a vi\u1ec7c \u0111\u1ecbnh r\u00f5 TRUE v\u00e0 FALSE, h\u00e3y th\u1eed th\u00eam v\u00e0i c\u00f4ng th\u1ee9c VLOOKUP v\u00e0 xem k\u1ebft qu\u1ea3 ch\u00fang tr\u1ea3 v\u1ec1 nh\u00e9.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_1_CACH_SU_DUNG_HAM_VLOOKUP_CO_GIA_TRI_TIM_KIEM_CHINH_XAC_TRONG_EXCEL\"><\/span>V\u00cd D\u1ee4 1. C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca T\u00ccM KI\u1ebeM CH\u00cdNH X\u00c1C TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 b\u1ea1n c\u00f2n nh\u1edb, \u0111\u1ec3 t\u00ecm ki\u1ebfm s\u1ef1 ph\u00f9 h\u1ee3p tuy\u1ec7t \u0111\u1ed1i, b\u1ea1n ph\u1ea3i \u0111\u1eb7t FALSE l\u00e0m c\u00e2u l\u1ec7nh cu\u1ed1i c\u00f9ng trong c\u00f4ng th\u1ee9c VLOOKUP trong Excel.<\/p>\n<p style=\"text-align: justify\">H\u00e3y ch\u1ecdn b\u1ea3ng \u201cAnimal speed\u201d \u0111\u1ec3 l\u00e0m v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean v\u00e0 t\u00ecm ra lo\u00e0i v\u1eadt n\u00e0o c\u00f3 th\u1ec3 ch\u1ea1y 80,5 km m\u1ed9t gi\u1edd. T\u00f4i tin ch\u1eafc b\u1ea1n s\u1ebd ch\u1eb3ng g\u1eb7p kh\u00f3 kh\u0103n g\u00ec v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=VLOOKUP(50, $A$2:$B$15, 2, FALSE).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5652 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/29-1.png\" width=\"494\" height=\"367\" title=\"29-1\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u01b0u \u00fd r\u1eb1ng, d\u1ea3i \u00f4 c\u1ea7n t\u00ecm c\u1ee7a ch\u00fang ta (c\u1ed9t A) ch\u1ee9a hai gi\u00e1 tr\u1ecb 50 l\u1ea7n l\u01b0\u1ee3t trong c\u1ed9t A5 v\u00e0 A6; v\u00e0 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong c\u1ed9t A5. T\u1ea1i sao l\u1ea1i nh\u01b0 th\u1ebf? B\u1edfi v\u00ec h\u00e0m VLOOKUP c\u00f3 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm tuy\u1ec7t \u0111\u1ed1i s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y \u0111\u1ea7u ti\u00ean \u2013 gi\u00e1 tr\u1ecb kh\u1edbp v\u1edbi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\">L\u1edbp h\u1ecdc Excel<\/a> t\u1ea1i H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"VI_DU_2_SU_DUNG_HAM_VLOOKUP_CO_GIA_TRI_CAN_TIM_TUONG_DOI_TRONG_EXCEL\"><\/span>V\u00cd D\u1ee4 2. S\u1eec D\u1ee4NG H\u00c0M VLOOKUP C\u00d3 GI\u00c1 TR\u1eca C\u1ea6N T\u00ccM T\u01af\u01a0NG \u0110\u1ed0I TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c VLOOKUP c\u00f3 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i, \u0111\u00f3 l\u00e0 c\u00f3 range_lookup \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t th\u00e0nh TRUE hay \u0111\u01b0\u1ee3c b\u1ecf \u0111i, th\u00ec \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n l\u00e0m \u0111\u00f3 l\u00e0 l\u1ecdc c\u1ed9t \u0111\u1ea7u ti\u00ean trong d\u1ea3i \u00f4 c\u1ea7n t\u00ecm theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng b\u1edfi v\u00ec c\u00f4ng th\u1ee9c VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ti\u1ebfp theo cho gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm m\u00e0 b\u1ea1n \u0111\u00e3 \u0111\u1ecbnh r\u00f5 r\u1ed3i s\u1ebd ng\u1eebng t\u00ecm ki\u1ebfm. N\u1ebfu b\u1ea1n kh\u00f4ng l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, th\u00ec cu\u1ed1i c\u00f9ng b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t k\u1ebft qu\u1ea3 l\u1ea1 hay l\u1ed7i #N\/A.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5653 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/30-1.png\" width=\"517\" height=\"323\" title=\"30-1\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong hai c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=VLOOKUP(69, $A$2:$B$15, 2, TRUE)<\/p>\n<p style=\"text-align: justify\">=VLOOKUP(69,$A$2:$B$15,2)<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, t\u00f4i \u0111ang c\u1ed1 t\u00ecm lo\u00e0i v\u1eadt c\u00f3 t\u1ed1c \u0111\u1ed9 ch\u1ea1y g\u1ea7n 111 km m\u1ed9t gi\u1edd nh\u1ea5t. V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 m\u00e0 c\u00f4ng th\u1ee9c VLOOKUP tr\u1ea3 v\u1ec1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5654 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/31-1.png\" width=\"480\" height=\"366\" title=\"31-1\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cAntelope\u201d (\u201cLinh d\u01b0\u01a1ng\u201d) \u2013 n\u00f3 c\u00f3 t\u1ed1c \u0111\u1ed9 ch\u1ea1y 98 km tr\u00ean gi\u1edd, trong khi \u0111\u00f3, ch\u00fang ta c\u0169ng c\u00f3 b\u00e1o ch\u1ea1y v\u1edbi t\u1ed1c \u0111\u1ed9 113 km tr\u00ean gi\u1edd, v\u00e0 70 th\u00ec g\u1ea7n v\u1edbi 69 h\u01a1n 61 , \u0111\u00fang kh\u00f4ng n\u00e0o? V\u1eady, t\u1ea1i sao l\u1ea1i nh\u01b0 th\u1ebf? B\u1edfi v\u00ec h\u00e0m VLOOKUP c\u00f3 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ti\u1ebfp theo, v\u00e0 gi\u00e1 tr\u1ecb n\u00e0y nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify\">Hy v\u1ecdng r\u1eb1ng, nh\u1eefng v\u00ed d\u1ee5 n\u00e0y \u0111\u00e3 gi\u00fap vi\u1ec7c s\u1eed d\u1ee5ng Excel d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 h\u00e0m n\u00e0y kh\u00f4ng c\u00f2n xa l\u1ea1 v\u1edbi b\u1ea1n n\u1eefa \ud83d\ude42 B\u00e2y gi\u1edd, s\u1ebd r\u1ea5t tuy\u1ec7t \u0111\u1ec3 t\u1ed5ng k\u1ebft nh\u1eefng \u0111i\u1ec1u quan tr\u1ecdng m\u00e0 b\u1ea1n \u0111\u00e3 h\u1ecdc nh\u1eb1m gi\u00fap b\u1ea1n nh\u1edb c\u00e1c \u0111i\u1ec3m m\u1ea5u ch\u1ed1t t\u1ed1t h\u01a1n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_VLOOKUP_TRONG_EXCEL_%E2%80%93_NHUNG_DIEU_CAN_NHO\"><\/span>H\u00c0M VLOOKUP TRONG EXCEL \u2013 NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m VLOOKUP trong Excel kh\u00f4ng th\u1ec3 t\u00ecm \u1edf b\u00ean tr\u00e1i. N\u00f3 lu\u00f4n lu\u00f4n t\u00ecm gi\u00e1 tr\u1ecb n\u1eb1m trong c\u1ed9t c\u1eadn tr\u00e1i c\u1ee7a d\u1ea3i \u00f4 c\u1ea7n t\u00ecm (table_array).<\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c VLOOKUP, t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb \u0111\u1ec1u kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, c\u00f3 ngh\u0129a l\u00e0 k\u00fd t\u1ef1 vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng \u0111\u1ec1u \u0111\u01b0\u1ee3c x\u1eed l\u00fd nh\u01b0 nhau.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1ea3i \u00f4 c\u1ea7n t\u00ecm, th\u00ec h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00e2u l\u1ec7nh th\u1ee9 ba (col_index_num) nh\u1ecf h\u01a1n 1, th\u00ec c\u00f4ng th\u1ee9c VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!. Trong tr\u01b0\u1eddng h\u1ee3p, n\u00f3 l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t trong d\u1ea3i \u00f4 c\u1ea7n t\u00ecm (table_array), th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #REF!.<\/p>\n<p style=\"text-align: justify\">H\u00e3y s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i trong c\u00e2u l\u1ec7nh table_array c\u1ee7a c\u00f4ng th\u1ee9c VLOOKUP \u0111\u1ec3 c\u00f3 \u0111\u00fang d\u1ea3i \u00f4 c\u1ea7n t\u00ecm khi x\u1eed l\u00fd c\u00f4ng th\u1ee9c. H\u00e3y c\u00e2n nh\u1eafc vi\u1ec7c s\u1eed d\u1ee5ng t\u00ean cho d\u1ea3i \u00f4 hay cho b\u1ea3ng trong Excel nh\u01b0 m\u1ed9t ph\u01b0\u01a1ng \u00e1n thay th\u1ebf.<\/p>\n<p style=\"text-align: justify\">Khi t\u00ecm ki\u1ebfm s\u1ef1 ph\u00f9 h\u1ee3p t\u01b0\u01a1ng \u0111\u1ed1i (range_lookup \u0111\u01b0\u1ee3c c\u1ea3i \u0111\u1eb7t th\u00e0nh TRUE hay lo\u1ea1i b\u1ecf), h\u00e3y lu\u00f4n l\u1ecdc d\u1eef li\u1ec7u \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong d\u1ea3i \u00f4 c\u1ea7n t\u00ecm theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, h\u00e3y nh\u1edb t\u1ea7m quan tr\u1ecdng c\u1ee7a th\u00f4ng s\u1ed1 cu\u1ed1i c\u00f9ng. S\u1eed d\u1ee5ng TRUE hay FALSE khi th\u00edch h\u1ee3p v\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i \u0111au \u0111\u1ea7u n\u1eefa.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/p>\n<p><strong>Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-vlookup-nang-cao-long-vlookup-voi-nhieu-tieu-chi-tra-cuu-hai-chieu.html\">h\u00e0m vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a> \u2013 c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 minh h\u1ecda<\/strong><\/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-608.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6781,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6780","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6780","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=6780"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6780\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6781"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}