{"id":9648,"date":"2025-01-02T11:50:50","date_gmt":"2025-01-02T11:50:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween\/"},"modified":"2025-01-02T11:50:50","modified_gmt":"2025-01-02T11:50:50","slug":"huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m vlookup randbetween"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong\u00a0Excel c\u00f3 m\u1ed9t h\u00e0m gi\u00fap ch\u00fang ta t\u1ea1o ra 1 s\u1ed1 ng\u1eabu nhi\u00ean l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-randbetween-chon-ngau-nhien-trong-excel.html\"><strong>h\u00e0m RandBetween<\/strong><\/a>.\u00a0Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m RandBetween v\u1edbi h\u00e0m Vlookup\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra 1 b\u1ea3ng\u00a0d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean theo\u00a0\u00fd mu\u1ed1n.\u00a0Ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u qua v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u A1:C10, trong\u00a0\u0111\u00f3 d\u1eef li\u1ec7u\u00a0\u1edf c\u00e1c c\u1ed9t A, B, C s\u1ebd ph\u00e1t sinh m\u1ed9t c\u00e1ch ng\u1eabu nhi\u00ean t\u1eeb d\u00f2ng 2 t\u1edbi d\u00f2ng 9.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23761\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-du-lieu-ngau-nhien-de-bai.png\" width=\"723\" height=\"276\" title=\"bang-du-lieu-ngau-nhien-de-bai\"><\/p>\n<p>Tuy nhi\u00ean d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean n\u00e0y s\u1ebd l\u00e0 m\u1ed9t trong s\u1ed1 c\u00e1c n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh t\u1ea1i c\u1ed9t F, G t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c c\u1ed9t H\u1ecd t\u00ean, B\u1ed9 ph\u1eadn.<\/p>\n<p>Tr\u01b0\u1edbc khi\u00a0\u0111i v\u00e0o th\u1ef1c hi\u1ec7n, ch\u00fang ta c\u00f3 th\u1ec3 ngh\u0129 1 ch\u00fat: t\u1ea1i sao c\u1ea7n l\u00e0m vi\u1ec7c n\u00e0y?\u00a0\u1ee8ng d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c v\u00e0o\u00a0\u0111\u00e2u?<\/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-67767d996e752\" 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\/huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween.html#Tam_quan_trong_cua_du_lieu_ngau_nhien\" title=\"T\u1ea7m quan tr\u1ecdng c\u1ee7a d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean\">T\u1ea7m quan tr\u1ecdng c\u1ee7a d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean<\/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\/huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween.html#Cach_tao_bang_du_lieu_ngau_nhien\" title=\"C\u00e1ch t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean\">C\u00e1ch t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tam_quan_trong_cua_du_lieu_ngau_nhien\"><\/span>T\u1ea7m quan tr\u1ecdng c\u1ee7a d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hi\u1ec7n nay nhu c\u1ea7u h\u1ecfi\u00a0\u0111\u00e1p\u00a0v\u1ec1 ki\u1ebfn th\u1ee9c\u00a0excel, c\u00e1c t\u00ecnh hu\u1ed1ng trong\u00a0excel l\u00e0 r\u1ea5t nhi\u1ec1u. Nh\u01b0ng ch\u00fang t\u00f4i g\u1eb7p nhi\u1ec1u c\u00e2u h\u1ecfi m\u00e0 c\u00e1c b\u1ea1n kh\u00f4ng c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u m\u1eabu. Khi\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u, c\u00e1c b\u1ea1n\u00a0\u0111\u00f3 tr\u1ea3 l\u1eddi: \u201ckh\u00f4ng th\u1ec3\u00a0\u0111\u01b0a l\u00ean\u00a0\u0111\u01b0\u1ee3c v\u00ec t\u00ednh b\u1ea3o m\u1eadt th\u00f4ng tin\u201d.<\/p>\n<p>V\u1eady t\u1ea1i sao b\u1ea1n\u00a0\u0111\u00f3 kh\u00f4ng t\u1ea1o 1 s\u1ed1 d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean\u00a0\u0111\u1ec3 l\u00e0m m\u1eabu? Nh\u01b0 v\u1eady kh\u00f4ng\u00a0\u1ea3nh h\u01b0\u1edfng g\u00ec t\u1edbi b\u1ea3o m\u1eadt th\u00f4ng tin m\u00e0 v\u1eabn th\u1ec3 hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00fang b\u1ea3n ch\u1ea5t c\u1ee7a v\u1ea5n\u00a0\u0111\u1ec1 b\u1ea1n\u00a0\u0111ang g\u1eb7p ph\u1ea3i.<\/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\/2025\/01\/ex101_92019-nho-74.gif\" title=\"ex101_92019-nho-74\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi b\u1ea1n c\u1ea7n l\u1ea5y v\u00ed d\u1ee5 trong\u00a0Excel, ho\u1eb7c khi b\u1ea1n mu\u1ed1n t\u1ea1o c\u00e1c b\u00e0i ki\u1ec3m tra trong\u00a0Excel,\u00a0\u0111i\u1ec1u b\u1ea1n quan t\u00e2m l\u00e0 c\u00e1ch vi\u1ebft h\u00e0m, lo\u1ea1i d\u1eef li\u1ec7u ch\u1ee9 kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb trong t\u1eebng\u00a0\u00f4 d\u1eef li\u1ec7u. V\u00e0 n\u1ebfu ph\u1ea3i nh\u1eadp tay t\u1eebng\u00a0\u00f4 th\u00ec r\u1ea5t m\u1ea5t c\u00f4ng. H\u00e3y\u00a0\u0111\u1ec3\u00a0Excel l\u00e0m vi\u1ec7c\u00a0\u0111\u00f3 1 c\u00e1ch ng\u1eabu nhi\u00ean m\u00e0 v\u1eabn trong ph\u1ea1m vi ki\u1ec3m so\u00e1t c\u1ee7a ch\u00fang ta.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_bang_du_lieu_ngau_nhien\"><\/span>C\u00e1ch t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 ch\u00fang ta bi\u1ebft h\u00e0m RandBetween l\u00e0 1 h\u00e0m cho ph\u00e9p t\u1ea1o ra 1 s\u1ed1 ng\u1eabu nhi\u00ean n\u1eb1m trong 1 kho\u1ea3ng gi\u1edbi h\u1ea1n tr\u00ean (top) v\u00e0 gi\u1edbi h\u1ea1n d\u01b0\u1edbi (bottom). Nh\u01b0ng c\u00f3 m\u1ed9t v\u1ea5n\u00a0\u0111\u1ec1 l\u00e0 h\u00e0m n\u00e0y ch\u1ec9 cho ra k\u1ebft qu\u1ea3 l\u00e0 1 con s\u1ed1, kh\u00f4ng ph\u1ea3i k\u00fd t\u1ef1 text.<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m RangBetween:<\/p>\n<p style=\"padding-left: 30px\">=RANDBETWEEN(bottom,top)<\/p>\n<p>Nh\u01b0ng h\u00e3y ch\u00fa\u00a0\u00fd v\u00e0o b\u1ea3ng E1:G7, ch\u00fang ta th\u1ea5y c\u00f3 th\u00eam c\u1ed9t STT. Trong c\u1ed9t n\u00e0y\u00a0\u0111\u00e1nh s\u1ed1 c\u00e1c d\u00f2ng t\u1eeb 1\u00a0\u0111\u1ebfn 6<\/p>\n<ul>\n<li>V\u1edbi H\u1ecd t\u00ean, ch\u00fang ta c\u00f3 ng\u1eabu nhi\u00ean 6 t\u00ean. Ta c\u00f3 RandBetween(1,6)<\/li>\n<li>V\u1edbi B\u1ed9 ph\u1eadn, ch\u00fang ta c\u00f3 ng\u1eabu nhi\u00ean 3 b\u1ed9 ph\u1eadn.\u00a0Ta c\u00f3 RandBetween(1,3)<\/li>\n<\/ul>\n<p>V\u00e0 khi ch\u00fang ta coi s\u1ed1 ng\u1eabu nhi\u00ean l\u00e0 1 s\u1ed1 t\u1eeb 1\u00a0\u0111\u1ebfn 6 th\u00ec ch\u00fang ta s\u1ebd c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Vlookup\u00a0\u0111\u1ec3 tham chi\u1ebfu xem s\u1ed1\u00a0\u0111\u00f3 l\u00e0 s\u1ed1 m\u1ea5y.<\/p>\n<p>\u0110\u1ec3 t\u00ecm t\u00ean\u00a0\u1ee9ng v\u1edbi s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1\u00a0\u0111\u1ebfn 6, ta c\u00f3 h\u00e0m nh\u01b0 sau:<\/p>\n<p>=VLOOKUP(RANDBETWEEN(1,6),$E$1:$G$7,2,0)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>RANDBETWEEN(1,6) l\u00e0 1 s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1\u00a0\u0111\u1ebfn 6<\/li>\n<li>$E$1:$G$7 l\u00e0 v\u00f9ng b\u1ea3ng c\u1ea7n tra c\u1ee9u h\u1ecd t\u00ean theo s\u1ed1 ng\u1eabu nhi\u00ean<\/li>\n<li>2 l\u00e0 c\u1ed9t H\u1ecd t\u00ean trong v\u00f9ng b\u1ea3ng tham chi\u1ebfu.\u00a0\u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm<\/li>\n<li>0 l\u00e0 ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu ch\u00ednh x\u00e1c<\/li>\n<\/ul>\n<p>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o\u00a0\u00f4 A2 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3\u00a0\u0111\u01b0\u1ee3c h\u00e0m l\u1ea5y h\u1ecd t\u00ean ng\u1eabu nhi\u00ean r\u1ed3i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23763\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-lay-ho-ten-ngau-nhien.png\" width=\"764\" height=\"316\" title=\"ham-lay-ho-ten-ngau-nhien\"><\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho b\u1ed9 ph\u1eadn, ch\u00fang ta c\u00f3:<\/p>\n<p>=VLOOKUP(RANDBETWEEN(1,3),$E$1:$G$4,3,0)<\/p>\n<p>L\u01b0u\u00a0\u00fd c\u00f3 nh\u1eefng s\u1ef1 thay\u00a0\u0111\u1ed5i trong c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li>randbetween ch\u1ec9 x\u00e9t t\u1eeb 1\u00a0\u0111\u1ebfn 3 v\u00ec c\u00f3 3 b\u1ed9 ph\u1eadn<\/li>\n<li>b\u1ea3ng tham chi\u1ebfu c\u0169ng ch\u1ec9 x\u00e9t t\u1eeb E1:G4<\/li>\n<li>c\u1ed9t k\u1ebft qu\u1ea3 l\u00e0 c\u1ed9t b\u1ed9 ph\u1eadn, c\u1ed9t th\u1ee9 3 trong b\u1ea3ng E1:G4<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23764\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-lay-bo-phan-ngau-nhien.png\" width=\"762\" height=\"316\" title=\"ham-lay-bo-phan-ngau-nhien\"><\/p>\n<p>C\u1ed9t S\u1ed1 ng\u00e0y c\u00f4ng ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m RandBetween 1 c\u00e1ch b\u00ecnh th\u01b0\u1eddng v\u1edbi s\u1ed1\u00a0b\u1ea5t k\u1ef3 l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 b\u1ea3ng d\u1eef li\u1ec7u ho\u00e0n ch\u1ec9nh r\u1ed3i.<\/p>\n<p>Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh nh\u00e9.<\/p>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html\">T\u1ea1o ng\u00e0y th\u00e1ng, m\u1eadt kh\u1ea9u, chu\u1ed7i v\u0103n b\u1ea3n ng\u1eabu nhi\u00ean b\u1eb1ng h\u00e0m RAND v\u00e0 RANDBETWEEN<\/a><\/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\/2025\/01\/ex101_92019-nho-74.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9649,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9648","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\/9648","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=9648"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9648\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9649"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}