{"id":7041,"date":"2024-12-21T16:48:16","date_gmt":"2024-12-21T16:48:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-mot-danh-sach-tuy-chon-trong-excel\/"},"modified":"2024-12-21T16:48:16","modified_gmt":"2024-12-21T16:48:16","slug":"tao-mot-danh-sach-tuy-chon-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-mot-danh-sach-tuy-chon-trong-excel\/","title":{"rendered":"T\u1ea1o m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel"},"content":{"rendered":"
\n

L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra m\u1ed9t t\u00f9y ch\u1ecdn \u0111\u01a1n gi\u1ea3n trong Excel<\/strong><\/h3>\n

T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u01a1n gi\u1ea3n trong Excel r\u1ea5t d\u1ec5 d\u00e0ng.\u00a0T\u1ea5t c\u1ea3 b\u1ea1n c\u1ea7n l\u00e0 m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean v\u00e0 c\u00f4ng th\u1ee9c INDIRECT.\u00a0C\u00e1ch n\u00e0y \u00e1p d\u1ee5ng v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2007, 2010 v\u00e0 2013.<\/p>\n

1. Nh\u1eadp c\u00e1c m\u1ee5c cho danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

Tr\u01b0\u1edbc h\u1ebft, g\u00f5 c\u00e1c m\u1ee5c m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn, m\u1ed7i danh s\u00e1ch trong m\u1ed9t c\u1ed9t ri\u00eang bi\u1ec7t.\u00a0V\u00ed d\u1ee5, t\u00f4i \u0111ang t\u1ea1o ra m\u1ed9t t\u00f9y ch\u1ecdn c\u1ee7a c\u00e1c nh\u00e0 xu\u1ea5t kh\u1ea9u tr\u00e1i c\u00e2y v\u00e0 c\u1ed9t A c\u1ee7a b\u1ea3ng ngu\u1ed3n (Fruit<\/em>) bao g\u1ed3m c\u00e1c m\u1ee5c c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean v\u00e0 3 c\u1ed9t kh\u00e1c li\u1ec7t k\u00ea c\u00e1c m\u1ee5c cho c\u00e1c tr\u00ecnh \u0111\u01a1n t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c.<\/p>\n

\"Type<\/p>\n

2. T\u1ea1o v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/p>\n

B\u00e2y gi\u1edd b\u1ea1n c\u1ea7n t\u1ea1o t\u00ean cho danh s\u00e1ch ch\u00ednh c\u1ee7a b\u1ea1n v\u00e0 cho m\u1ed7i danh s\u00e1ch ph\u1ee5 thu\u1ed9c.\u00a0B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch th\u00eam t\u00ean m\u1edbi v\u00e0o\u00a0c\u1eeda s\u1ed5\u00a0Name Manager<\/em>\u00a0(Formulas<\/em>\u00a0tab >\u00a0Name Manager > New)<\/em>\u00a0ho\u1eb7c nh\u1eadp t\u00ean tr\u1ef1c ti\u1ebfp v\u00e0o\u00a0Name Box<\/em>.<\/p>\n

\"Creating<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>L\u01b0u \u00fd r\u1eb1ng n\u1ebfu h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n l\u00e0 lo\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh \u1edf tr\u00ean, b\u1ea1n s\u1ebd kh\u00f4ng \u0111\u01b0a v\u00e0o v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ghi nh\u1edb:<\/strong><\/p>\n

    \n
  1. C\u00e1c m\u1ee5c xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean ti\u00eau \u0111\u1ec1 ch\u1ec9 g\u1ed3m m\u1ed9t t\u1eeb, v\u00ed d\u1ee5 nh\u01b0\u00a0Apricot,\u00a0Mango,\u00a0Oranges<\/em>.<\/li>\n
  2. T\u00ean c\u1ee7a c\u00e1c danh s\u00e1ch ph\u1ee5 thu\u1ed9c ph\u1ea3i ch\u00ednh x\u00e1c v\u1edbi m\u1ee5c \u0111\u01b0\u1ee3c nh\u1eadp trong danh s\u00e1ch ch\u00ednh.\u00a0V\u00ed d\u1ee5, danh s\u00e1ch ph\u1ee5 thu\u1ed9c \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u201cMango<\/em>\u201d khi danh s\u00e1ch t\u00f9y ch\u1ecdn c\u0169ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean \u0111\u1ea7u ti\u00ean l\u00e0 Mango<\/em>.<\/li>\n<\/ol>\n

    Khi ho\u00e0n t\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0Ctrl + F3\u00a0\u0111\u1ec3 m\u1edf\u00a0c\u1eeda s\u1ed5\u00a0Name Manager <\/em>v\u00e0 ki\u1ec3m tra xem t\u1ea5t c\u1ea3 c\u00e1c danh s\u00e1ch t\u00ean v\u00e0 tham chi\u1ebfu c\u00f3 ch\u00ednh x\u00e1c hay kh\u00f4ng.<\/p>\n

    \"Verifying3. \u0110\u1eb7t danh s\u00e1ch t\u00f9y ch\u1ecdn (ch\u00ednh) \u0111\u1ea7u ti\u00ean.<\/p>\n

      \n
    1. Trong m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c ho\u1eb7c c\u00f9ng b\u1ea3ng t\u00ednh, h\u00e3y ch\u1ecdn m\u1ed9t \u00f4 ho\u1eb7c nhi\u1ec1u \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n danh s\u00e1ch t\u00f9y ch\u1ecdn ch\u00ednh c\u1ee7a m\u00ecnh xu\u1ea5t hi\u1ec7n.<\/li>\n
    2. Chuy\u1ec3n \u0111\u1ebfn\u00a0tab\u00a0Data\u00a0<\/em>, nh\u1ea5p v\u00e0o\u00a0Data Validation <\/strong>v\u00e0 thi\u1ebft l\u1eadp m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn d\u1ef1a tr\u00ean ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0List\u00a0<\/em>d\u01b0\u1edbi\u00a0Allow\u00a0<\/strong>v\u00e0 nh\u1eadp t\u00ean trong\u00a0h\u1ed9p\u00a0Source<\/strong>.<\/li>\n<\/ol>\n

      \"Select<\/p>\n

      K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t tr\u00ecnh \u0111\u01a1n t\u00f9y ch\u1ecdn trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n

      \"The4. T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c.<\/p>\n

      Ch\u1ecdn c\u00e1c \u00f4 cho danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c c\u1ee7a b\u1ea1n v\u00e0 \u00e1p d\u1ee5ng Data Validation nh\u01b0 \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 trong b\u01b0\u1edbc tr\u01b0\u1edbc.\u00a0Nh\u01b0ng l\u1ea7n n\u00e0y, thay v\u00ec nh\u1eadp t\u00ean c\u1ee7a d\u1ea3i \u00f4, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o tr\u01b0\u1eddng\u00a0Ngu\u1ed3n<\/em>\u00a0:<\/p>\n

      =INDIRECT(A2)<\/strong><\/p>\n

      Trong \u0111\u00f3 A2 l\u00e0 \u00f4 v\u1edbi danh s\u00e1ch (ch\u00ednh) t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n.<\/p>\n

      \"Set<\/p>\n

      N\u1ebfu \u00f4 A2 \u0111ang tr\u1ed1ng, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o l\u1ed7i \u201cThe Source currently evaluates to an error. Do you want to continue?<\/em>\u201c<\/p>\n

      Nh\u1ea5p\u00a0Yes<\/em>, v\u00e0 ngay khi b\u1ea1n ch\u1ecdn m\u1ed9t m\u1ee5c t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c m\u1ee5c t\u01b0\u01a1ng \u1ee9ng v\u1edbi n\u00f3 trong danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c th\u1ee9 hai.<\/p>\n

      Th\u00eam danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c th\u1ee9 ba (t\u00f9y ch\u1ecdn)<\/p>\n

      N\u1ebfu c\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9\u00a0ba\u00a0t\u00f9y thu\u1ed9c v\u00e0o l\u1ef1a ch\u1ecdn trong\u00a0danh s\u00e1ch th\u1ea3 th\u1ee9 hai\u00a0ho\u1eb7c tr\u00ean c\u00e1c l\u1ef1a ch\u1ecdn trong hai danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean.<\/p>\n

      Thi\u1ebft l\u1eadp danh s\u00e1ch ph\u1ee5 thu\u1ed9c th\u1ee9 ba d\u1ef1a v\u00e0o danh s\u00e1ch th\u1ee9 hai.<\/p>\n

      B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n danh s\u00e1ch t\u00f9y ch\u1ecdn lo\u1ea1i n\u00e0y theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1 nh\u01b0 ch\u00fang ta v\u1eeba t\u1ea1o tr\u00ecnh \u0111\u01a1n t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c th\u1ee9 hai.\u00a0Ch\u1ec9 c\u1ea7n nh\u1edb hai \u0111i\u1ec1u quan tr\u1ecdng \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean, \u0111i\u1ec1u n\u00e0y r\u1ea5t c\u1ea7n thi\u1ebft cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n

      V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c v\u00f9ng trong c\u1ed9t C t\u00f9y thu\u1ed9c v\u00e0o qu\u1ed1c gia n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn trong c\u1ed9t B, b\u1ea1n t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c v\u00f9ng cho m\u1ed7i qu\u1ed1c gia v\u00e0 \u0111\u1eb7t t\u00ean theo t\u00ean c\u1ee7a qu\u1ed1c gia, ph\u1ea3i ch\u00ednh x\u00e1c v\u1edbi t\u00ean qu\u1ed1c gia \u0111\u00f3 xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai.\u00a0V\u00ed d\u1ee5, danh s\u00e1ch c\u00e1c khu v\u1ef1c Indian\u00a0th\u00ec c\u0169ng ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 \u201cIndian\u201d, ho\u1eb7c Chines \u2013 \u201cChines\u201d, v.v.<\/p>\n

      Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 cho\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 ba\u00a0(trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u00f4 C2) v\u00e0 \u00e1p d\u1ee5ng Data Validation v\u1edbi c\u00f4ng th\u1ee9c sau (B2 l\u00e0 \u00f4 c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai c\u00f3 ch\u1ee9a danh s\u00e1ch c\u00e1c qu\u1ed1c gia):<\/p>\n

      =INDIRECT(B2)<\/strong><\/p>\n

      \"The5. Th\u00eam danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c th\u1ee9 ba (t\u00f9y ch\u1ecdn)<\/p>\n

      N\u1ebfu c\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9\u00a0ba\u00a0t\u00f9y thu\u1ed9c v\u00e0o l\u1ef1a ch\u1ecdn trong\u00a0danh s\u00e1ch th\u1ea3 th\u1ee9 hai\u00a0ho\u1eb7c tr\u00ean c\u00e1c l\u1ef1a ch\u1ecdn trong hai danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean.<\/p>\n

      Thi\u1ebft l\u1eadp danh s\u00e1ch ph\u1ee5 thu\u1ed9c th\u1ee9 ba d\u1ef1a v\u00e0o danh s\u00e1ch th\u1ee9 hai.<\/p>\n

      B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n danh s\u00e1ch t\u00f9y ch\u1ecdn lo\u1ea1i n\u00e0y theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1 nh\u01b0 ch\u00fang ta v\u1eeba t\u1ea1o tr\u00ecnh \u0111\u01a1n t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c th\u1ee9 hai.\u00a0Ch\u1ec9 c\u1ea7n nh\u1edb hai \u0111i\u1ec1u quan tr\u1ecdng \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean, \u0111i\u1ec1u n\u00e0y r\u1ea5t c\u1ea7n thi\u1ebft cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n

      V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c v\u00f9ng trong c\u1ed9t C t\u00f9y thu\u1ed9c v\u00e0o qu\u1ed1c gia n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn trong c\u1ed9t B, b\u1ea1n t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c v\u00f9ng cho m\u1ed7i qu\u1ed1c gia v\u00e0 \u0111\u1eb7t t\u00ean theo t\u00ean c\u1ee7a qu\u1ed1c gia, ph\u1ea3i ch\u00ednh x\u00e1c v\u1edbi t\u00ean qu\u1ed1c gia \u0111\u00f3 xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai.\u00a0V\u00ed d\u1ee5, danh s\u00e1ch c\u00e1c khu v\u1ef1c Indian\u00a0th\u00ec c\u0169ng ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 \u201cIndian\u201d, ho\u1eb7c Chines \u2013 \u201cChines\u201d, v.v.<\/p>\n

      Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 cho\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 ba\u00a0(trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u00f4 C2) v\u00e0 \u00e1p d\u1ee5ng Data Validation v\u1edbi c\u00f4ng th\u1ee9c sau (B2 l\u00e0 \u00f4 c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai c\u00f3 ch\u1ee9a danh s\u00e1ch c\u00e1c qu\u1ed1c gia):<\/p>\n

      =INDIRECT(B2)<\/strong>
      \n\"Creating<\/p>\n

      B\u00e2y gi\u1edd, m\u1ed7i khi b\u1ea1n ch\u1ecdn\u00a0India\u00a0<\/em>\u00a0theo danh s\u00e1ch c\u00e1c qu\u1ed1c gia \u1edf c\u1ed9t B, b\u1ea1n s\u1ebd c\u00f3 c\u00e1c l\u1ef1a ch\u1ecdn sau trong danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 ba:<\/p>\n

      \"A<\/p>\n

      Ch\u00fa \u00fd.\u00a0<\/strong>Danh s\u00e1ch c\u00e1c khu v\u1ef1c \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb l\u00e0 duy nh\u1ea5t cho m\u1ed7i qu\u1ed1c gia nh\u01b0ng n\u00f3 kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o l\u1ef1a ch\u1ecdn trong danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean.<\/p>\n

      T\u1ea1o m\u1ed9t danh s\u00e1ch th\u1ee9 ba ph\u1ee5 thu\u1ed9c v\u00e0o hai danh s\u00e1ch \u0111\u1ea7u ti\u00ean<\/strong><\/p>\n

      N\u1ebfu b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn t\u1ea7ng ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e1c l\u1ef1a ch\u1ecdn trong danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 nh\u1ea5t v\u00e0 th\u1ee9 hai, h\u00e3y ti\u1ebfp t\u1ee5c theo c\u00e1ch n\u00e0y:<\/p>\n

      1. T\u1ea1o th\u00eam c\u00e1c d\u00e3y v\u00e0 \u0111\u1eb7t t\u00ean ch\u00fang cho b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p t\u1eeb trong hai danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n.\u00a0V\u00ed d\u1ee5: b\u1ea1n c\u00f3\u00a0Mango, Oranges, v..v<\/em>trong\u00a0danh s\u00e1ch th\u1ee9 nh\u1ea5t v\u00e0 India,, Braxin, v.v \u2026<\/em>\u00a0\u1edf danh s\u00e1ch th\u1ee9 hai.\u00a0Sau \u0111\u00f3, b\u1ea1n t\u1ea1o c\u00e1c v\u00f9ng c\u00f3 t\u00ean\u00a0MangoIndia<\/em>\u00a0,\u00a0MangoBrazil<\/em>\u00a0,\u00a0OrangesIndia<\/em>\u00a0,\u00a0OrangesBrazil<\/em>\u00a0, v.v .. Nh\u1eefng t\u00ean n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ee9a d\u1ea5u g\u1ea1ch d\u01b0\u1edbi ho\u1eb7c b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o kh\u00e1c.<\/p>\n

      \"Create2. \u00c1p d\u1ee5ng Data Validation b\u1eb1ng c\u00f4ng th\u1ee9c INDIRECT \/ SUBSTITUTE\u00a0 k\u1ebft n\u1ed1i t\u00ean c\u1ee7a c\u00e1c m\u1ee5c nh\u1eadp trong hai c\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng kh\u1ecfi t\u00ean.\u00a0V\u00ed d\u1ee5: trong \u00f4 C2, c\u00f4ng th\u1ee9c x\u00e1c nh\u1eadn d\u1eef li\u1ec7u s\u1ebd l\u00e0:<\/p>\n

      =INDIRECT(SUBSTITUTE(A2&B2,\u201d \u201c,\u201d\u201d))<\/strong><\/p>\n

      Trong \u0111\u00f3 A2 v\u00e0 B2 ch\u1ee9a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 nh\u1ea5t v\u00e0 th\u1ee9 hai.<\/p>\n

      K\u1ebft qu\u1ea3 l\u00e0,\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 c\u1ee7a b\u1ea1n\u00a0s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c v\u00f9ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi\u00a0Fruit\u00a0 <\/em>v\u00e0\u00a0Country<\/em>\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean.<\/p>\n

      \"A<\/p>\n

      \u0110\u00e2y l\u00e0 c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t \u0111\u1ec3 t\u1ea1o h\u1ed9p t\u00f9y ch\u1ecdn d\u1ea1ng cascading trong Excel.\u00a0Tuy nhi\u00ean, ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u00f3 m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf.<\/p>\n

      H\u1ea1n ch\u1ebf c\u1ee7a ph\u01b0\u01a1ng ph\u00e1p n\u00e0y:<\/strong><\/p>\n

        \n
      1. C\u00e1c m\u1ee5c trong danh s\u00e1ch t\u00f9y ch\u1ecdn ch\u00ednh ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp m\u1ed9t t\u1eeb.<\/li>\n
      2. N\u00f3 c\u0169ng kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng n\u1ebfu c\u00e1c m\u1ee5c trong danh s\u00e1ch t\u00f9y ch\u1ecdn ch\u00ednh ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u1ea5u g\u1ea1ch ngang (-), k\u00fd hi\u1ec7u (&).<\/li>\n
      3. C\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c t\u1ea1o ra theo c\u00e1ch n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng, ngh\u0129a l\u00e0 b\u1ea1n s\u1ebd ph\u1ea3i thay \u0111\u1ed5i tham chi\u1ebfu c\u00e1c d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean m\u1ed7i khi b\u1ea1n th\u00eam ho\u1eb7c xo\u00e1 c\u00e1c m\u1ee5c trong danh s\u00e1ch ngu\u1ed3n.<\/li>\n<\/ol>\n

        L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn v\u1edbi c\u00e1c m\u1ee5c nh\u1eadp nhi\u1ec1u t\u1eeb<\/strong><\/p>\n

        C\u00e1c c\u00f4ng th\u1ee9c INDIRECT\u00a0 nh\u01b0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng trong v\u00ed d\u1ee5 \u1edf tr\u00ean ch\u1ec9 c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c m\u1ee5c ch\u1ec9 c\u00f3 t\u1eeb.\u00a0V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c = INDIRECT (A2) tham chi\u1ebfu \u0111\u1ebfn \u00f4 A2 v\u00e0 hi\u1ec3n th\u1ecb ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean \u0111\u00fang v\u1edbi t\u00ean nh\u01b0 trong \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu.\u00a0Tuy nhi\u00ean, Excel kh\u00f4ng cho ph\u00e9p c\u00f3 c\u00e1c d\u1ea5u c\u00e1ch trong t\u00ean, \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng khi t\u00ean c\u00f3 nhi\u1ec1u t\u1eeb.<\/p>\n

        Gi\u1ea3i ph\u00e1p l\u00e0 s\u1eed d\u1ee5ng h\u00e0m INDIRECT\u00a0k\u1ebft h\u1ee3p v\u1edbi SUBSTITUTE nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m khi t\u1ea1o\u00a0danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 3.<\/p>\n

        Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3\u00a0Water melon<\/em>\u00a0trong s\u1ed1 c\u00e1c s\u1ea3n ph\u1ea9m.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd li\u1ec7t k\u00ea danh s\u00e1ch c\u00e1c nh\u00e0 xu\u1ea5t kh\u1ea9u d\u01b0a h\u1ea5u vi\u1ebft l\u1ec1n kh\u00f4ng kho\u1ea3ng tr\u1eafng \u2013\u00a0Watermelon<\/em>.<\/p>\n

        Sau \u0111\u00f3, \u1edf danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai, h\u00e3y \u00e1p d\u1ee5ng Data Validation b\u1eb1ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng kh\u1ecfi t\u00ean trong \u00f4 A2:<\/p>\n

        =INDIRECT(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/strong><\/p>\n

        \"Creating<\/p>\n

        C\u00e1ch ng\u0103n nh\u1eefng thay \u0111\u1ed5i trong danh s\u00e1ch t\u00f9y ch\u1ecdn ch\u00ednh<\/strong><\/p>\n

        H\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng tr\u01b0\u1eddng h\u1ee3p sau \u0111\u00e2y.\u00a0Ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn, sau \u0111\u00f3 h\u1ecd thay \u0111\u1ed5i \u00fd \u0111\u1ecbnh, quay l\u1ea1i danh s\u00e1ch \u0111\u1ea7u ti\u00ean v\u00e0 ch\u1ecdn m\u1ed9t m\u1ee5c kh\u00e1c.\u00a0K\u1ebft qu\u1ea3 l\u00e0, l\u1ef1a ch\u1ecdn \u0111\u1ea7u ti\u00ean v\u00e0 th\u1ee9 hai kh\u00f4ng kh\u1edbp.\u00a0\u0110\u1ec3 ng\u0103n \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, b\u1ea1n c\u1ea7n ch\u1eb7n b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o trong danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean ngay khi l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u01b0a ra trong danh s\u00e1ch th\u1ee9 hai.<\/p>\n

        \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, khi t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 ki\u1ec3m tra xem li\u1ec7u b\u1ea5t k\u1ef3 m\u1ee5c n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn trong danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai kh\u00f4ng:<\/p>\n

        =IF(B2=\u201d\u201d, Fruit, INDIRECT(\u201cFakeList\u201d))<\/strong><\/p>\n

        Trong \u0111\u00f3 B2 ch\u1ee9a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai, \u201cFruit<\/em>\u201d l\u00e0 t\u00ean c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean v\u00e0 \u201cFakeList<\/em>\u201d l\u00e0 b\u1ea5t k\u1ef3 t\u00ean gi\u1ea3 n\u00e0o kh\u00f4ng t\u1ed3n t\u1ea1i.<\/p>\n

        \"Preventing<\/p>\n

        T\u1ea1o c\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn d\u1ea1ng \u0111\u1ed9ng trong Excel<\/strong><\/p>\n

        L\u1ee3i th\u1ebf c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c d\u1ea1ng \u0111\u1ed9ng c\u1ee7a Excel l\u00e0 b\u1ea1n \u0111\u01b0\u1ee3c t\u1ef1 do ch\u1ec9nh s\u1eeda danh s\u00e1ch ngu\u1ed3n v\u00e0 c\u00e1c h\u1ed9p t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt tr\u1ef1c ti\u1ebfp.\u00a0T\u1ea5t nhi\u00ean, vi\u1ec7c t\u1ea1o ra c\u00e1c tr\u00ecnh \u0111\u01a1n t\u00f9y ch\u1ecdn \u0111\u1ed9ng \u0111\u00f2i h\u1ecfi nhi\u1ec1u th\u1eddi gian h\u01a1n v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n, nh\u01b0ng t\u00f4i tin r\u1eb1ng \u0111\u00f3 l\u00e0 m\u1ed9t s\u1ef1 \u0111\u1ea7u t\u01b0 x\u1ee9ng \u0111\u00e1ng b\u1edfi v\u00ec n\u00f3 t\u1ea1o ra nhi\u1ec1u \u0111i\u1ec1u h\u1eefu \u00edch v\u00e0 th\u00fa v\u1ecb.<\/p>\n

        B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ed9ng s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m OFFSET, INDIRECT v\u00e0 COUNTA ho\u1eb7c INDEX \/ MATCH c\u00f3 \u0111\u1ed9 linh ho\u1ea1t cao h\u01a1n.\u00a0C\u00e1ch sau \u0111\u00e2y l\u00e0 c\u00e1ch \u01b0a th\u00edch c\u1ee7a t\u00f4i b\u1edfi v\u00ec n\u00f3 c\u00f3 nhi\u1ec1u \u01b0u \u0111i\u1ec3m, quan tr\u1ecdng nh\u1ea5t trong s\u1ed1 \u0111\u00f3 l\u00e0:<\/p>\n

          \n
        1. B\u1ea1n ch\u1ec9 ph\u1ea3i t\u1ea1o ba d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, cho d\u00f9 c\u00f3 bao nhi\u00eau m\u1ee5c trong danh s\u00e1ch ch\u00ednh v\u00e0 ph\u1ee5 thu\u1ed9c.<\/li>\n
        2. Danh s\u00e1ch c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 ch\u1ee9a nhi\u1ec1u t\u1eeb v\u00e0 b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t n\u00e0o.<\/li>\n
        3. S\u1ed1 m\u1ee5c c\u00f3 th\u1ec3 thay \u0111\u1ed5i theo t\u1eebng c\u1ed9t.<\/li>\n
        4. Th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp c\u00e1c m\u1ee5c kh\u00f4ng quan tr\u1ecdng.<\/li>\n
        5. Cu\u1ed1i c\u00f9ng, r\u1ea5t d\u1ec5 d\u00e0ng \u0111\u1ec3 duy tr\u00ec v\u00e0 s\u1eeda \u0111\u1ed5i c\u00e1c danh s\u00e1ch ngu\u1ed3n.<\/li>\n<\/ol>\n

          Ch\u00fang ta h\u00e3y b\u1eaft \u0111\u1ea7u th\u1ef1c h\u00e0nh.<\/p>\n

          1. T\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u ngu\u1ed3n c\u1ee7a b\u1ea1n trong m\u1ed9t b\u1ea3ng.<\/p>\n

          \u0110i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 vi\u1ebft ra t\u1ea5t c\u1ea3 c\u00e1c l\u1ef1a ch\u1ecdn cho danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n trong m\u1ed9t b\u1ea3ng t\u00ednh.\u00a0L\u1ea7n n\u00e0y, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng b\u1ea3ng Excel \u0111\u1ec3 l\u01b0u tr\u1eef d\u1eef li\u1ec7u ngu\u1ed3n.<\/p>\n

          C\u00e1c v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng v\u1edbi Excel 2007, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n c\u1ee7a Excel 2013, 2010 v\u00e0 2007.<\/p>\n

          Khi b\u1ea1n \u0111\u00e3 nh\u1eadp d\u1eef li\u1ec7u, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c v\u00e0 nh\u1ea5p v\u00e0o\u00a0tab\u00a0\u00a0Insert >\u00a0Table.<\/em>\u00a0.\u00a0Sau \u0111\u00f3, chuy\u1ec3n sang\u00a0tab\u00a0Design <\/em>v\u00e0 nh\u1eadp t\u00ean c\u1ee7a b\u1ea3ng c\u1ee7a b\u1ea1n v\u00e0o\u00a0h\u1ed9p\u00a0Table\u00a0<\/em>.<\/p>\n

          C\u00e1ch thu\u1eadn ti\u1ec7n v\u00e0 tr\u1ef1c quan nh\u1ea5t l\u00e0 l\u01b0u tr\u1eef c\u00e1c m\u1ee5c cho menu t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean d\u01b0\u1edbi d\u1ea1ng c\u00e1c ti\u00eau \u0111\u1ec1 b\u1ea3ng v\u00e0 c\u00e1c m\u1ee5c cho danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c nh\u01b0 d\u1eef li\u1ec7u b\u1ea3ng.\u00a0\u1ea2nh d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda c\u1ea5u tr\u00fac b\u1ea3ng, \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0\u00a0exporters_tbl<\/em>\u00a0\u2013 fruit\u00a0l\u00e0 ti\u00eau \u0111\u1ec1 b\u1ea3ng v\u00e0 m\u1ed9t danh s\u00e1ch c\u00e1c n\u01b0\u1edbc xu\u1ea5t kh\u1ea9u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o d\u01b0\u1edbi t\u00ean lo\u1ea1i tr\u00e1i c\u00e2y t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

          \"Organize2. T\u1ea1o t\u00ean.<\/p>\n

          B\u00e2y gi\u1edd, d\u1eef li\u1ec7u ngu\u1ed3n c\u1ee7a b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng, ti\u1ebfp theo l\u00e0 thi\u1ebft l\u1eadp c\u00e1c t\u00ean tham chi\u1ebfu s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ecm ki\u1ebfm danh s\u00e1ch ch\u00ednh x\u00e1c t\u1eeb b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n

          2.1.\u00a0Th\u00eam t\u00ean cho h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng (danh s\u00e1ch t\u00f9y ch\u1ecdn ch\u00ednh)<\/p>\n

          \u0110\u1ec3 t\u1ea1o t\u00ean tham chi\u1ebfu \u0111\u1ebfn ti\u00eau \u0111\u1ec1 b\u1ea3ng, h\u00e3y ch\u1ecdn n\u00f3 v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0ormulas\u00a0>\u00a0Name Manager\u00a0>\u00a0New\u00a0 <\/em>ho\u1eb7c nh\u1ea5n\u00a0Ctrl + F3\u00a0.<\/p>\n

          Microsoft Excel s\u1ebd s\u1eed d\u1ee5ng h\u1ec7 th\u1ed1ng tham chi\u1ebfu b\u1ea3ng \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 t\u1ea1o t\u00ean d\u1ea1ng table_name[#Headers]\u00a0<\/em>.<\/p>\n

          \"Create<\/p>\n

          Nh\u1eadp v\u00e0o m\u1ed9t t\u00ean c\u00f3 \u00fd ngh\u0129a v\u00e0 d\u1ec5 nh\u1edb, v\u00ed d\u1ee5 nh\u01b0\u00a0fruit_list<\/em>\u00a0, v\u00e0 nh\u1ea5n\u00a0OK<\/em>\u00a0.<\/p>\n

          2.2.\u00a0T\u1ea1o m\u1ed9t t\u00ean cho \u00f4 c\u00f3 ch\u1ee9a danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean.<\/p>\n

          T\u00f4i bi\u1ebft r\u1eb1ng b\u1ea1n ch\u01b0a c\u00f3 b\u1ea5t k\u1ef3 danh s\u00e1ch t\u00f9y ch\u1ecdn n\u00e0o. Nh\u01b0ng b\u1ea1n ph\u1ea3i ch\u1ecdn c\u00e1c \u00d4 \u0111\u1ec3 l\u01b0u tr\u1eef danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean v\u00e0 t\u1ea1o t\u00ean cho ch\u00fang v\u00ec b\u1ea1n s\u1ebd c\u1ea7n \u0111\u1ebfn t\u00ean n\u00e0y trong t\u00ean tham chi\u1ebfu th\u1ee9 ba.<\/p>\n

          V\u00ed d\u1ee5, h\u1ed9p t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean c\u1ee7a t\u00f4i n\u1eb1m trong \u00f4 B1 tr\u00ean B\u1ea3ng 2, v\u00ec v\u1eady t\u00f4i t\u1ea1o t\u00ean cho n\u00f3, m\u1ed9t t\u00ean \u0111\u01a1n gi\u1ea3n v\u00ed d\u1ee5 nh\u01b0\u00a0fruit<\/em>:<\/p>\n

          \"Create<\/p>\n

          M\u1eb9o.\u00a0<\/strong>S\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 th\u00edch h\u1ee3p \u0111\u1ec3\u00a0sao ch\u00e9p c\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn<\/strong>\u00a0tr\u00ean b\u1ea3ng t\u00ednh.<\/p>\n

          H\u00e3y \u0111\u1ecdc nh\u1eefng \u0111i\u1ec1u d\u01b0\u1edbi \u0111\u00e2y th\u1eadt c\u1ea9n th\u1eadn, b\u1edfi v\u00ec \u0111\u00e2y l\u00e0 m\u1ed9t m\u1eb9o r\u1ea5t h\u1eefu \u00edch m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n b\u1ecf l\u1ee1.<\/p>\n

          N\u1ebfu b\u1ea1n d\u1ef1 \u0111\u1ecbnh sao ch\u00e9p danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p khi t\u1ea1o t\u00ean cho c\u00e1c \u00f4 v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n.<\/p>\n

          \u0110\u1ec3 sao ch\u00e9p ch\u00ednh x\u00e1c c\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ebfn c\u00e1c\u00a0c\u1ed9t<\/strong>\u00a0kh\u00e1c\u00a0(v\u00ed d\u1ee5: \u1edf b\u00ean ph\u1ea3i trong b\u1ea3ng t\u00ednh), s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 $) v\u00e0 c\u00e1c d\u00f2ng tuy\u1ec7t \u0111\u1ed1i (v\u1edbi $) v\u00ed d\u1ee5 = Sheet2! B$1.<\/p>\n

          K\u1ebft qu\u1ea3 l\u00e0, danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c c\u1ee7a B1 s\u1ebd xu\u1ea5t hi\u1ec7n trong \u00f4 B2;\u00a0Danh s\u00e1ch t\u00f9y ch\u1ecdn ph\u1ee5 thu\u1ed9c c\u1ee7a C1 s\u1ebd hi\u1ec3n th\u1ecb trong C2, v.v.<\/p>\n

          \"Coping<\/p>\n

          V\u00e0 n\u1ebfu b\u1ea1n d\u1ef1 \u0111\u1ecbnh sao ch\u00e9p c\u00e1c danh s\u00e1ch t\u00f9y ch\u1ecdn cho c\u00e1c\u00a0h\u00e0ng<\/strong>\u00a0kh\u00e1c\u00a0(v\u00ed d\u1ee5: xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t), th\u00ec s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu c\u1ed9t tuy\u1ec7t \u0111\u1ed1i (v\u1edbi $) v\u00e0 v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng (kh\u00f4ng $) v\u00ed d\u1ee5 = Sheet2! $ B1.<\/p>\n

          \"Coping<\/p>\n

          2.3.\u00a0T\u1ea1o t\u00ean <\/strong>cho c\u00e1c m\u1ee5c trong danh s\u00e1ch <\/strong>ph\u1ee5 thu\u1ed9c.<\/strong><\/p>\n

          Thay v\u00ec thi\u1ebft l\u1eadp t\u00ean duy nh\u1ea5t cho m\u1ed7i danh s\u00e1ch ph\u1ee5 thu\u1ed9c nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m trong\u00a0v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta s\u1ebd t\u1ea1o ra m\u1ed9t\u00a0t\u00ean d\u1ea1ng c\u00f4ng th\u1ee9c<\/strong>\u00a0m\u00e0\u00a0\u00a0kh\u00f4ng g\u00e1n cho b\u1ea5t k\u1ef3 \u00f4 ho\u1eb7c nhi\u1ec1u \u00f4 c\u1ee5 th\u1ec3 n\u00e0o.\u00a0N\u00f3\u00a0s\u1ebd l\u1ea5y danh s\u00e1ch c\u00e1c m\u1ee5c c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 hai d\u1ef1a v\u00e0o l\u1ef1a ch\u1ecdn c\u1ee7a danh s\u00e1ch t\u00f9y ch\u1ecdn th\u1ee9 nh\u1ea5t.\u00a0L\u1ee3i \u00edch ch\u00ednh c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c l\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i t\u1ea1o t\u00ean m\u1edbi khi b\u1ea1n th\u00eam c\u00e1c m\u1ee5c m\u1edbi v\u00e0o danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean \u2013 m\u1ed9t c\u00f4ng th\u1ee9c t\u1ea1o ra s\u1ebd \u0111\u1eb7t t\u00ean cho t\u1ea5t c\u1ea3.<\/p>\n

          B\u1ea1n t\u1ea1o m\u1ed9t t\u00ean Excel m\u1edbi theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng (\u00a0Formulas\u00a0>\u00a0Name Manager\u00a0>\u00a0New<\/em>) b\u1eb1ng c\u00f4ng th\u1ee9c sau:<\/p>\n

          =INDEX(exporters_tbl,,MATCH(fruit,fruit_list,0))<\/strong><\/p>\n

          Tron \u0111\u00f3:<\/p>\n