{"id":2562,"date":"2024-12-02T08:05:29","date_gmt":"2024-12-02T08:05:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet\/"},"modified":"2024-12-02T08:05:29","modified_gmt":"2024-12-02T08:05:29","slug":"vi-du-ve-ham-vlookup-huong-dan-chi-tiet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet\/","title":{"rendered":"V\u00cd D\u1ee4 V\u1ec0 H\u00c0M VLOOKUP: H\u01af\u1edaNG D\u1eaaN CHI TI\u1ebeT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Microsoft Excel. H\u01b0\u1edbng d\u1eabn n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u1ed7 tr\u1ee3 m\u1ecdi c\u1ea5p \u0111\u1ed9 ng\u01b0\u1eddi d\u00f9ng Excel v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP, th\u00f4ng qua 4 <a href=\"http:\/\/blog.ezworkapp.com\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html\"><strong>V\u00ed d\u1ee5 h\u00e0m Vlookup<\/strong><\/a> d\u01b0\u1edbi \u0111\u00e2y.\u00a0<\/span><\/em><\/p>\n<figure id=\"attachment_34793\" aria-describedby=\"caption-attachment-34793\" style=\"width: 857px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34793 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-16.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-1\" width=\"857\" height=\"435\"><figcaption id=\"caption-attachment-34793\" class=\"wp-caption-text\">H\u00ecnh 1. V\u00ed d\u1ee5 h\u00e0m VLOOKUP: VLOOKUP v\u1edbi 2 b\u1ea3ng tra c\u1ee9u<\/figcaption><\/figure>\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-674d6a485f413\" 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\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html#Cu_phap_cua_ham_VLOOKUP\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP\u00a0\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP\u00a0<\/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\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html#Cac_ung_dung_cua_ham_VLOOKUP\" title=\"C\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m VLOOKUP\u00a0\">C\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m VLOOKUP\u00a0<\/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\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html#Vi_du_ham_Vlookup_Tinh_diem\" title=\"V\u00ed d\u1ee5 h\u00e0m Vlookup: T\u00ednh \u0111i\u1ec3m\">V\u00ed d\u1ee5 h\u00e0m Vlookup: T\u00ednh \u0111i\u1ec3m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html#Hop_nhat_hai_bang_tinh_thanh_mot\" title=\"H\u1ee3p nh\u1ea5t hai b\u1ea3ng t\u00ednh th\u00e0nh m\u1ed9t\">H\u1ee3p nh\u1ea5t hai b\u1ea3ng t\u00ednh th\u00e0nh m\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/vi-du-ve-ham-vlookup-huong-dan-chi-tiet.html#VLOOKUP_voi_hai_bang_tra_cuu\" title=\"VLOOKUP v\u1edbi hai b\u1ea3ng tra c\u1ee9u\">VLOOKUP v\u1edbi hai b\u1ea3ng tra c\u1ee9u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_VLOOKUP\"><\/span><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VLOOKUP\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>H\u00e0m Vlookup<\/strong><\/a> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<br \/>\n=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m VLOOKUP l\u00e0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">lookup_value \u2013 gi\u00e1 tr\u1ecb m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm v\u00e0 t\u00ecm th\u1ea5y trong table_array\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">table_array \u2013 ph\u1ea1m vi \u00f4 trong b\u1ea3ng ngu\u1ed3n ch\u1ee9a\u00a0 d\u1eef li\u1ec7u ch\u00fang ta mu\u1ed1n l\u1ea5y\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">col_index_num \u2013 s\u1ed1 c\u1ed9t trong table_array t\u01b0\u01a1ng \u1ee9ng v\u1edbi th\u00f4ng tin ch\u00fang ta mu\u1ed1n l\u1ea5y, li\u00ean quan \u0111\u1ebfn lookup_value\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">[range_lookup] \u2013 t\u00f9y ch\u1ecdn;\u00a0 gi\u00e1 tr\u1ecb l\u00e0 TRUE ho\u1eb7c FALSE\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n\u1ebfu TRUE ho\u1eb7c b\u1ecb b\u1ecf qua, h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c ho\u1eb7c g\u1ea7n \u0111\u00fang\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n\u1ebfu FALSE, h\u00e0m VLOOKUP s\u1ebd ch\u1ec9 t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, ch\u00fang ta ch\u1ec9 c\u1ea7n nh\u1edb b\u1ed1n tham s\u1ed1 c\u1ea7n thi\u1ebft:\u00a0<\/span><\/p>\n<p><b>WHAT, WHERE, Column Number, Closet Match<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">lookup_value \u2013 tham s\u1ed1 <\/span><b>WHAT<\/b><span style=\"font-weight: 400\">, \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">table_array \u2013 tham s\u1ed1 <\/span><b>WHERE<\/b><span style=\"font-weight: 400\">, \u0111\u00e2y l\u00e0 n\u01a1i ch\u00fang ta mu\u1ed1n t\u00ecm, n\u01a1i lookup_value c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">col_index_num \u2013 <\/span><b>COLUMN NUMBER<\/b><span style=\"font-weight: 400\">, \u0111\u00e2y l\u00e0 s\u1ed1 c\u1ed9t\u00a0 d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta mu\u1ed1n tr\u00edch xu\u1ea5t, b\u1eaft \u0111\u1ea7u \u0111\u1ebfm t\u1eeb c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a table_array\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;text-align: left\"><span style=\"font-weight: 400\">[range_lookup] \u2013 <\/span><b>CLOSEST MATCH<\/b><span style=\"font-weight: 400\">;\u00a0 n\u1ebfu TRUE, ch\u00fang ta mu\u1ed1n t\u00ecm kh\u1edbp g\u1ea7n nh\u1ea5t ho\u1eb7c ch\u00ednh x\u00e1c, n\u1ebfu FALSE, ch\u00fang ta ch\u1ec9 mu\u1ed1n t\u00ecm kh\u1edbp ch\u00ednh x\u00e1c<br \/>\n<\/span><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-trong-excel-va-cac-vi-du-minh-hoa.html\"><strong>C\u00e1c h\u00e0m trong Excel <\/strong><\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online \u0111\u00e3 c\u1eadp nh\u1eadt \u0111\u1ea7y \u0111\u1ee7 c\u00fa ph\u00e1p v\u00e0 ho\u00e0n c\u1ea3nh s\u1eed d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cac_ung_dung_cua_ham_VLOOKUP\"><\/span><b>C\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m VLOOKUP\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong b\u00e0i n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng h\u1eefu \u00edch c\u1ee7a h\u00e0m VLOOKUP nh\u01b0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tra c\u1ee9u nhanh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u00ednh \u0111i\u1ec3m\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">G\u1ed9p hai b\u1ea3ng th\u00e0nh m\u1ed9t h\u00e0m VLOOKUP c\u00f3 hai b\u1ea3ng\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Tra c\u1ee9u nhanh ng\u00e0y sinh nh\u1eadt nh\u00e2n vi\u00ean<\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-198.gif\" title=\"ex101_92019-nho-198\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_34794\" aria-describedby=\"caption-attachment-34794\" style=\"width: 835px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34794 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-15.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-2\" width=\"835\" height=\"395\"><figcaption id=\"caption-attachment-34794\" class=\"wp-caption-text\">H\u00ecnh 2. V\u00ed d\u1ee5 h\u00e0m VLOOKUP: Tra c\u1ee9u ng\u00e0y sinh c\u1ee7a nh\u00e2n vi\u00ean<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch nh\u00e2n vi\u00ean v\u00e0 ng\u00e0y sinh c\u1ee7a h\u1ecd, c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 tra c\u1ee9u ng\u00e0y sinh v\u1edbi ID nh\u00e2n vi\u00ean l\u00e0 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1. Ch\u1ecdn \u00f4 F3\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2. Nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400\">=VLOOKUP(F2,B3:C13,2,FALSE)<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: Nh\u1ea5n ENTER\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 th\u1ea3o lu\u1eadn \u1edf tr\u00ean, h\u00e0m VLOOKUP c\u00f3 b\u1ed1n tham s\u1ed1. \u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta mu\u1ed1n t\u00ecm F2 (What) trong B3:C13 (Where) v\u00e0 l\u1ea5y 2 (Column Number) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng FALSE (Exact Match). S\u1ed1 c\u1ed9t l\u00e0 2 v\u00ec ng\u00e0y sinh n\u1eb1m trong c\u1ed9t th\u1ee9 hai c\u1ee7a m\u1ea3ng b\u1ea3ng B3:C13.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 l\u00e0, ch\u00fang ta \u0111\u00e3 t\u00ecm th\u1ea5y m\u1ed9t k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c cho ID nh\u00e2n vi\u00ean 19473 d\u1ecdc theo c\u1ed9t B v\u00e0 chuy\u1ec3n sang c\u1ed9t th\u1ee9 hai b\u00ean ph\u1ea3i, l\u1ea5y ng\u00e0y sinh l\u00e0 \u201c4\/7\/1993\u201d.<\/span><\/p>\n<figure id=\"attachment_34795\" aria-describedby=\"caption-attachment-34795\" style=\"width: 828px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34795 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-15.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-3\" width=\"828\" height=\"423\"><figcaption id=\"caption-attachment-34795\" class=\"wp-caption-text\">H\u00ecnh 3. V\u00ed d\u1ee5 h\u00e0m VLOOKUP \u0111\u1ec3 l\u1ea5y ng\u00e0y sinh c\u1ee7a nh\u00e2n vi\u00ean<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u1ec9 trong v\u00e0i gi\u00e2y, ch\u00fang ta c\u00f3 th\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c ng\u00e0y sinh c\u1ee7a m\u1ed9t nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c cung c\u1ea5p ID nh\u00e2n vi\u00ean b\u1eb1ng h\u00e0m VLOOKUP. C\u00e1c ph\u01b0\u01a1ng ph\u00e1p thay th\u1ebf s\u1ebd l\u00e0 xem qua danh s\u00e1ch l\u1ea7n l\u01b0\u1ee3t ho\u1eb7c l\u1ecdc danh s\u00e1ch \u0111\u1ec3 hi\u1ec3n th\u1ecb ID nh\u00e2n vi\u00ean 19473, c\u1ea3 hai \u0111\u1ec1u ti\u00eau t\u1ed1n th\u1eddi gian qu\u00fd b\u00e1u v\u00e0 d\u1ec5 x\u1ea3y ra l\u1ed7i.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_ham_Vlookup_Tinh_diem\"><\/span><b>V\u00ed d\u1ee5 h\u00e0m Vlookup: T\u00ednh \u0111i\u1ec3m<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_34796\" aria-describedby=\"caption-attachment-34796\" style=\"width: 825px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34796 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-15.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-4\" width=\"825\" height=\"402\"><figcaption id=\"caption-attachment-34796\" class=\"wp-caption-text\">H\u00ecnh 4. V\u00ed d\u1ee5 h\u00e0m Vlookup: T\u00ednh \u0111i\u1ec3m b\u1eb1ng h\u00e0m VLOOKUP<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed ch\u00fang ta \u0111\u01b0\u1ee3c cung c\u1ea5p m\u1ed9t b\u1ea3ng v\u1edbi hai c\u1ed9t: <\/span><span style=\"font-weight: 400\">Cut-off Score <\/span><span style=\"font-weight: 400\">(c\u1ed9t B) v\u00e0 Grade (c\u1ed9t C). Ch\u00fang ta mu\u1ed1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh \u0111i\u1ec3m t\u01b0\u01a1ng \u0111\u01b0\u01a1ng cho m\u1ed9t s\u1ed1 \u0111i\u1ec3m nh\u1ea5t \u0111\u1ecbnh. Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y v\u1edbi h\u00e0m VLOOKUP v\u00e0 s\u1eed d\u1ee5ng kh\u1edbp g\u1ea7n \u0111\u00fang.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1. Ch\u1ecdn \u00f4 F3\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2. Nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400\">=VLOOKUP(F2,B3:C7,2,TRUE)<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: Nh\u1ea5n ENTER<\/span><\/p>\n<figure id=\"attachment_34797\" aria-describedby=\"caption-attachment-34797\" style=\"width: 828px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34797 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-15.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-5\" width=\"828\" height=\"430\"><figcaption id=\"caption-attachment-34797\" class=\"wp-caption-text\">H\u00ecnh 5. S\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi \u0111\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c \u0111\u1ec3 t\u00ednh \u0111i\u1ec3m<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c VLOOKUP c\u1ee7a ch\u00fang ta t\u00ecm ki\u1ebfm \u0111i\u1ec3m s\u1ed1 95 d\u1ecdc theo c\u1ed9t B. Khi t\u00ecm th\u1ea5y \u0111i\u1ec3m s\u1ed1, c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd chuy\u1ec3n sang c\u1ed9t th\u1ee9 hai b\u00ean ph\u1ea3i v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c \u0111i\u1ec3m \u201cA\u201d. Cu\u1ed1i c\u00f9ng, ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh c\u1ea5p t\u01b0\u01a1ng \u0111\u01b0\u01a1ng cho 95 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng kh\u1edbp g\u1ea7n \u0111\u00fang ho\u1eb7c g\u1ea7n \u0111\u00fang nh\u1ea5t s\u1ebd cho ph\u00e9p ch\u00fang ta l\u1ea5y \u0111i\u1ec3m cho c\u00e1c \u0111i\u1ec3m kh\u00f4ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong b\u1ea3ng B3:C8. H\u00e3y th\u1eed nh\u1eadp 93 v\u00e0o \u00f4 F2.<\/span><\/p>\n<figure id=\"attachment_34798\" aria-describedby=\"caption-attachment-34798\" style=\"width: 827px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34798 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-6\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-14.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-6\" width=\"827\" height=\"431\"><figcaption id=\"caption-attachment-34798\" class=\"wp-caption-text\">H\u00ecnh 6. S\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang \u0111\u1ec3 t\u00ednh \u0111i\u1ec3m<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Khi c\u00f4ng th\u1ee9c kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u trong b\u1ea3ng, n\u00f3 s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t nh\u01b0ng nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb tra c\u1ee9u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta \u0111\u01b0\u1ee3c coi l\u00e0 \u0111i\u1ec3m 85 v\u00e0 tr\u1ea3 v\u1ec1 \u0111i\u1ec3m t\u01b0\u01a1ng \u0111\u01b0\u01a1ng l\u00e0 B. N\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng kh\u1edbp ch\u00ednh x\u00e1c thay th\u1ebf, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i. Xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_34799\" aria-describedby=\"caption-attachment-34799\" style=\"width: 841px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34799 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-7\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-13.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-7\" width=\"841\" height=\"422\"><figcaption id=\"caption-attachment-34799\" class=\"wp-caption-text\">H\u00ecnh 7. H\u00e0m VLOOKUP v\u1edbi kh\u1edbp ch\u00ednh x\u00e1c tr\u1ea3 v\u1ec1 l\u1ed7i khi kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Hop_nhat_hai_bang_tinh_thanh_mot\"><\/span><b>H\u1ee3p nh\u1ea5t hai b\u1ea3ng t\u00ednh th\u00e0nh m\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_34800\" aria-describedby=\"caption-attachment-34800\" style=\"width: 845px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34800 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-8\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-12.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-8\" width=\"845\" height=\"345\"><figcaption id=\"caption-attachment-34800\" class=\"wp-caption-text\">H\u00ecnh 8. V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c VLOOKUP: H\u1ee3p nh\u1ea5t hai b\u1ea3ng th\u00e0nh m\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y ch\u00fang ta c\u00f3 hai b\u1ea3ng v\u1edbi hai c\u1ed9t m\u1ed7i b\u1ea3ng. B\u1ea3ng 1 ch\u1ee9a \u201cName\u201d v\u00e0 \u201cGroup\u201d trong khi B\u1ea3ng 2 ch\u1ee9a \u201cName\u201d v\u00e0 \u201cColor\u201d. Ch\u00fang ta mu\u1ed1n h\u1ee3p nh\u1ea5t hai b\u1ea3ng v\u00e0 t\u1ea1o ra m\u1ed9t b\u1ea3ng c\u00f3 ba c\u1ed9t: Name, Group v\u00e0 Color. Ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng h\u1ee3p nh\u1ea5t hai c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1. Th\u00eam c\u1ed9t th\u1ee9 ba trong B\u1ea3ng 1 c\u00f3 t\u00ean \u201cColor\u201d<\/span><\/p>\n<figure id=\"attachment_34801\" aria-describedby=\"caption-attachment-34801\" style=\"width: 851px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34801 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-11.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-9\" width=\"851\" height=\"351\"><figcaption id=\"caption-attachment-34801\" class=\"wp-caption-text\">H\u00ecnh 9. Th\u00eam m\u1ed9t c\u1ed9t \u0111\u1ec3 h\u1ee3p nh\u1ea5t hai b\u1ea3ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2. Nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o D3: <\/span><span style=\"font-weight: 400\">=VLOOKUP(B3,$F$3:$G$7,2,FALSE)<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: Nh\u1ea5n ENTER\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 4: Sao ch\u00e9p c\u00f4ng th\u1ee9c trong \u00f4 D3 sang \u00f4 D4:D7 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o d\u1ea5u \u201c+ \u201d \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 D3 v\u00e0 k\u00e9o n\u00f3 xu\u1ed1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f4 la k\u00fd hi\u1ec7u \u201c$\u201d trong c\u00f4ng th\u1ee9c s\u1eeda c\u00e1c \u00f4 \u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng sao ch\u00e9p v\u00e0 d\u00e1n c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c.<\/span><\/p>\n<figure id=\"attachment_34802\" aria-describedby=\"caption-attachment-34802\" style=\"width: 858px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34802 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-10\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-10.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-10\" width=\"858\" height=\"378\"><figcaption id=\"caption-attachment-34802\" class=\"wp-caption-text\">H\u00ecnh 10. V\u00ed d\u1ee5 h\u00e0m VLOOKUP \u0111\u1ec3 h\u1ee3p nh\u1ea5t hai b\u1ea3ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta \u0111\u00e3 h\u1ee3p nh\u1ea5t th\u00e0nh c\u00f4ng hai b\u1ea3ng th\u00e0nh m\u1ed9t, nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf trong B2:D7.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_voi_hai_bang_tra_cuu\"><\/span><b>VLOOKUP v\u1edbi hai b\u1ea3ng tra c\u1ee9u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_34803\" aria-describedby=\"caption-attachment-34803\" style=\"width: 854px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34803 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-11\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h11-9.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-11\" width=\"854\" height=\"412\"><figcaption id=\"caption-attachment-34803\" class=\"wp-caption-text\">H\u00ecnh 11. V\u00ed d\u1ee5 h\u00e0m Vlookup: VLOOKUP v\u1edbi 2 b\u1ea3ng tra c\u1ee9u<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 hai b\u1ea3ng m\u1ed7i b\u1ea3ng c\u00f3 hai c\u1ed9t, Movie (c\u1ed9t B) v\u00e0 Ticket Price (c\u1ed9t C). B\u1ea3ng 1 d\u00e0nh cho v\u00e9 \u201cPremier\u201d, trong khi B\u1ea3ng 2 d\u00e0nh cho \u201cDeluxe\u201d. Trong \u00f4 F3 v\u00e0 F4, ch\u00fang ta nh\u1eadp ti\u00eau ch\u00ed cho Type v\u00e0 Movie. Ch\u00fang ta mu\u1ed1n tra c\u1ee9u b\u1ed9 phim trong b\u1ea3ng th\u00edch h\u1ee3p v\u00e0 l\u1ea5y gi\u00e1 v\u00e9. Gi\u00e1 tr\u1ecb cho Type s\u1ebd x\u00e1c \u0111\u1ecbnh b\u1ea3ng n\u00e0o ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng trong tra c\u1ee9u.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c b\u1eb1ng h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1. Ch\u1ecdn \u00f4 F5\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2. Nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400\">=VLOOKUP(F4,IF(F3=B2,B4:C6,B10:C12),2,FALSE)<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: Nh\u1ea5n ENTER<\/span><\/p>\n<figure id=\"attachment_34804\" aria-describedby=\"caption-attachment-34804\" style=\"width: 859px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34804 size-full\" title=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-12\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h12-7.png\" alt=\"Vi-du-ham-vlookup-huong-dan-chi-tiet-12\" width=\"859\" height=\"441\"><figcaption id=\"caption-attachment-34804\" class=\"wp-caption-text\">H\u00ecnh 12. V\u00ed d\u1ee5 h\u00e0m VLOOKUP v\u00e0 IF v\u1edbi 2 b\u1ea3ng tra c\u1ee9u<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta t\u00ecm ki\u1ebfm \u201cA Star is Born\u201d trong b\u1ea3ng cho \u201cPremier\u201d, B4:B6 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 v\u00e9 t\u01b0\u01a1ng \u1ee9ng l\u00e0 $14. Ch\u00eca kh\u00f3a \u1edf \u0111\u00e2y l\u00e0 b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c h\u00e0m VLOOKUP v\u00e0 IF. IF \u0111\u00e1nh gi\u00e1 type v\u00e0 tr\u1ea3 v\u1ec1 B4:B6 d\u01b0\u1edbi d\u1ea1ng table_array n\u1ebfu F3 b\u1eb1ng B2 ho\u1eb7c \u201cPremier\u201d;\u00a0 n\u1ebfu kh\u00f4ng, n\u00f3 tr\u1ea3 v\u1ec1 B10:C12.\u00a0\u00a0<\/span><\/p>\n<p><em><span style=\"font-weight: 400\">B\u1ed1n <strong>v\u00ed d\u1ee5 h\u00e0m Vlookup<\/strong> ch\u00fang ta v\u1eeba h\u1ecdc ch\u1ec9 l\u00e0 m\u1ed9t v\u00e0i \u1ee9ng d\u1ee5ng c\u1ee7a <strong>h\u00e0m VLOOKUP<\/strong>. Tr\u00ean th\u1ef1c t\u1ebf th\u00ec h\u00e0m n\u00e0y c\u00f3 ti\u1ec1m n\u0103ng c\u1ea3i thi\u1ec7n n\u0103ng su\u1ea5t v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u khi \u0111\u01b0\u1ee3c v\u1eadn d\u1ee5ng th\u00e0nh th\u1ea1o.\u00a0<\/span><\/em><\/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-198.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2563,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2562","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\/2562","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=2562"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2562\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2563"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}