{"id":6045,"date":"2025-12-08T18:24:45","date_gmt":"2025-12-08T11:24:45","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-ket-hop-ham-index-va-match-trong-excel-voi-vi-du-de-hieu\/"},"modified":"2025-12-08T18:24:45","modified_gmt":"2025-12-08T11:24:45","slug":"cach-ket-hop-ham-index-va-match-trong-excel-voi-vi-du-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-ket-hop-ham-index-va-match-trong-excel-voi-vi-du-de-hieu\/","title":{"rendered":"C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel v\u1edbi v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel gi\u00fap d\u00f2 t\u00ecm d\u1eef li\u1ec7u linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. MATCH gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ea7n tra c\u1ee9u, c\u00f2n INDEX tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. Nh\u1edd \u0111\u00f3, vi\u1ec7c truy xu\u1ea5t th\u00f4ng tin tr\u1edf n\u00ean nhanh v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n \u00e1p d\u1ee5ng d\u1ec5 hi\u1ec3u v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

\"C\u00e1chC\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel<\/em><\/p>\n

\n

1. H\u00e0m INDEX v\u00e0 MATCH trong Excel<\/h2>\n<\/div>\n

Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u c\u00e1ch k\u1ebft h\u1ee3p, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a hai h\u00e0m n\u00e0y \u0111\u1ec3 \u1ee9ng d\u1ee5ng ch\u00ednh x\u00e1c trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

\n

1.1. C\u00f4ng th\u1ee9c h\u00e0m MATCH<\/h3>\n<\/div>\n

H\u00e0m MATCH d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u, tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

C\u00fa ph\u00e1p: <\/strong>=MATCH(lookup_value; lookup_array; match_type)<\/p>\n

Trong \u0111\u00f3:<\/strong><\/p>\n

    \n
  • Lookup_value:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n
  • Lookup_array:<\/strong> V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu.<\/li>\n
  • Match_type:<\/strong> T\u00f9y ch\u1ecdn ki\u1ec3u t\u00ecm ki\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh.<\/li>\n<\/ul>\n

    \"C\u00f4ngC\u00fa ph\u00e1p h\u00e0m MATCH trong Excel<\/em><\/p>\n

    \n

    1.2. C\u00f4ng th\u1ee9c h\u00e0m INDEX<\/h3>\n<\/div>\n

    H\u00e0m INDEX d\u00f9ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u1ecb tr\u00ed h\u00e0ng v\u00e0 c\u1ed9t trong m\u1ed9t b\u1ea3ng ho\u1eb7c ph\u1ea1m vi b\u1ea5t k\u1ef3.<\/p>\n

    C\u00fa ph\u00e1p:<\/strong> =INDEX(array; row_num; column_num)<\/p>\n

    Trong \u0111\u00f3:<\/strong><\/p>\n

      \n
    • array: <\/strong>V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n truy xu\u1ea5t.<\/li>\n
    • row_num: <\/strong>S\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ea7n l\u1ea5y gi\u00e1 tr\u1ecb.<\/li>\n
    • column_num:<\/strong> S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n

      \"C\u00f4ngC\u00fa ph\u00e1p h\u00e0m INDEX trong Excel<\/em><\/p>\n

      Xem th\u00eam: <\/strong>H\u00e0m INDEX trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/div>\n
      \n

      2. K\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH khi n\u00e0o?<\/h2>\n<\/div>\n

      K\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n tra c\u1ee9u d\u1eef li\u1ec7u trong b\u1ea3ng c\u00f3 nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t, ho\u1eb7c khi c\u1ea5u tr\u00fac b\u1ea3ng th\u01b0\u1eddng xuy\u00ean thay \u0111\u1ed5i. Hai h\u00e0m n\u00e0y cho ph\u00e9p t\u00ecm ki\u1ebfm theo c\u1ea3 chi\u1ec1u ngang l\u1eabn chi\u1ec1u d\u1ecdc, mang l\u1ea1i s\u1ef1 linh ho\u1ea1t cao trong x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n

      B\u1ed9 \u0111\u00f4i h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn v\u00e0 nh\u1eefng y\u00eau c\u1ea7u tra c\u1ee9u theo nhi\u1ec1u ti\u00eau ch\u00ed. Nh\u1edd \u0111\u00f3, c\u00f4ng th\u1ee9c v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ef1 \u1ed5n \u0111\u1ecbnh v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, ngay c\u1ea3 khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/p>\n

      \"K\u1ebftK\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH khi n\u00e0o?<\/em><\/p>\n

      \n

      3. C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH<\/h2>\n<\/div>\n

      D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH th\u01b0\u1eddng g\u1eb7p k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft:<\/p>\n

      \n

      3.1. K\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

      V\u00ed d\u1ee5:<\/strong> B\u1ea1n d\u00f9ng h\u00e0m INDEX v\u00e0 h\u00e0m MATCH \u0111\u1ec3 t\u00ednh \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t. Trong c\u00f4ng th\u1ee9c b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng $ (F4) \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb ph\u1ea1m vi. Gi\u1ea3 s\u1eed theo \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t trong b\u1ea3ng 2 (B16:E19) th\u00ec b\u1ea1n c\u1ea7n \u0111i\u1ec1n \u0111\u01a1n gi\u00e1 v\u00e0o b\u1ea3ng 1 (B4:D13).<\/p>\n

      \"K\u1ebftD\u00f9ng h\u00e0m INDEX v\u00e0 h\u00e0m MATCH \u0111\u1ec3 t\u00ednh \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t<\/em><\/p>\n

      K\u1ebft h\u1ee3p 2 h\u00e0m INDEX h\u00e0m MATCH \u0111\u1ec3 d\u00f2 t\u00ecm ki\u1ebfm qu\u1ea3 gi\u00e1 tr\u1ecb cho \u00f4 D5 nh\u01b0 sau:<\/p>\n

      B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed h\u00e0ng (Row) c\u1ee7a s\u1ea3n ph\u1ea9m<\/strong><\/p>\n

      S\u1eed d\u1ee5ng h\u00e0m MATCH \u0111\u1ec3 t\u00ecm xem t\u00ean s\u1ea3n ph\u1ea9m (B5) n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y trong danh s\u00e1ch s\u1ea3n ph\u1ea9m c\u1ee7a B\u1ea3ng 2 (B16:B19).<\/p>\n

      C\u00f4ng th\u1ee9c:<\/strong> =MATCH(B5,$B$16:$B$19,0)<\/p>\n

      Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

        \n
      • B5:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm (v\u00ed d\u1ee5: “Case”).<\/li>\n
      • $B$16:$B$19:<\/strong> Ph\u1ea1m vi t\u00ecm ki\u1ebfm (c\u1ed1 \u0111\u1ecbnh b\u1eb1ng $).<\/li>\n
      • 0: <\/strong>Y\u00eau c\u1ea7u t\u00ecm ki\u1ebfm kh\u1edbp ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n

        K\u1ebft qu\u1ea3 gi\u1ea3 \u0111\u1ecbnh:<\/strong> Gi\u1ea3 s\u1eed k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 4, ngh\u0129a l\u00e0 “Case” n\u1eb1m \u1edf h\u00e0ng th\u1ee9 4 trong ph\u1ea1m vi t\u00ecm ki\u1ebfm B16:B19.<\/p>\n

        \"D\u00f9ngD\u00f9ng h\u00e0m MATCH \u0111\u1ec3 t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m<\/em><\/p>\n

        B\u01b0\u1edbc 2: X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ed9t (Column) c\u1ee7a h\u00e3ng s\u1ea3n xu\u1ea5t<\/strong><\/p>\n

        S\u1eed d\u1ee5ng h\u00e0m MATCH th\u1ee9 hai \u0111\u1ec3 t\u00ecm xem h\u00e3ng s\u1ea3n xu\u1ea5t ($C5$) n\u1eb1m \u1edf c\u1ed9t th\u1ee9 m\u1ea5y trong h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a B\u1ea3ng 2 (B16:E16).<\/p>\n

        C\u00f4ng th\u1ee9c: <\/strong>=MATCH(C5,$B$16:$E$16,0)<\/p>\n

        Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

          \n
        • C5:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm (v\u00ed d\u1ee5: “Dell”).<\/li>\n
        • $B$16:$E$16: <\/strong>Ph\u1ea1m vi t\u00ecm ki\u1ebfm (c\u1ed1 \u0111\u1ecbnh b\u1eb1ng $).<\/li>\n<\/ul>\n

          K\u1ebft qu\u1ea3 gi\u1ea3 \u0111\u1ecbnh:<\/strong> Gi\u1ea3 s\u1eed k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2, ngh\u0129a l\u00e0 “Dell” n\u1eb1m \u1edf c\u1ed9t th\u1ee9 2 trong ph\u1ea1m vi t\u00ecm ki\u1ebfm B16:E16.<\/p>\n

          \"X\u00e1cD\u00f9ng h\u00e0m MATCH t\u00ecm H\u00e3ng s\u1ea3n xu\u1ea5t<\/em><\/p>\n

          B\u01b0\u1edbc 3: K\u1ebft h\u1ee3p INDEX v\u00e0 MATCH \u0111\u1ec3 l\u1ea5y \u0111\u01a1n gi\u00e1<\/strong><\/p>\n

          S\u1eed d\u1ee5ng h\u00e0m INDEX v\u1edbi to\u00e0n b\u1ed9 d\u1eef li\u1ec7u B\u1ea3ng 2 ($B16:E19$) v\u00e0 s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 c\u1ee7a hai h\u00e0m MATCH tr\u00ean l\u00e0m \u0111\u1ed1i s\u1ed1 v\u1ecb tr\u00ed h\u00e0ng v\u00e0 v\u1ecb tr\u00ed c\u1ed9t.<\/p>\n

          C\u00f4ng th\u1ee9c chung (nh\u1eadp v\u00e0o \u00f4 D5):<\/strong><\/p>\n

          =INDEX($B$16:$E$19,MATCH(B5,$B$16:$B$19,),MATCH(C5,$B$16:$E$16,0))<\/p>\n

          Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

            \n
          • $B$16:$E$19: <\/strong>\u0110\u00e2y l\u00e0 m\u1ea3ng k\u1ebft qu\u1ea3 ch\u00ednh (to\u00e0n b\u1ed9 B\u1ea3ng 2), n\u01a1i h\u00e0m INDEX s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb. Ph\u1ea1m vi n\u00e0y ph\u1ea3i \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh tuy\u1ec7t \u0111\u1ed1i b\u1eb1ng d\u1ea5u $.<\/li>\n
          • H\u00e0m MATCH th\u1ee9 nh\u1ea5t (H\u00e0ng)<\/strong> cung c\u1ea5p s\u1ed1 h\u00e0ng (v\u00ed d\u1ee5: 4).<\/li>\n
          • H\u00e0m MATCH th\u1ee9 hai (C\u1ed9t)<\/strong> cung c\u1ea5p s\u1ed1 c\u1ed9t (v\u00ed d\u1ee5: 2).<\/li>\n<\/ul>\n

            K\u1ebft qu\u1ea3 gi\u1ea3 \u0111\u1ecbnh:<\/strong> H\u00e0m s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb n\u1eb1m \u1edf h\u00e0ng th\u1ee9 4 v\u00e0 c\u1ed9t th\u1ee9 2 trong m\u1ea3ng $B16:E19$. Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb n\u00e0y l\u00e0 4 (\u0110\u01a1n gi\u00e1).<\/p>\n

            \"K\u1ebftK\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 h\u00e0m MATCH \u0111\u1ec3 l\u1ea5y \u0110\u01a1n gi\u00e1<\/em><\/p>\n

            B\u01b0\u1edbc 4: Sao ch\u00e9p C\u00f4ng th\u1ee9c<\/strong><\/p>\n

            Sau khi c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang t\u1ea1i \u00f4 $D5$, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o (copy) c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t \u0111\u01a1n gi\u00e1 ($D6$ \u0111\u1ebfn $D13$). Nh\u1edd vi\u1ec7c s\u1eed d\u1ee5ng d\u1ea5u $ (F4) \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh ph\u1ea1m vi B\u1ea3ng 2, c\u00f4ng th\u1ee9c s\u1ebd ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c cho m\u1ecdi s\u1ea3n ph\u1ea9m trong B\u1ea3ng 1.<\/p>\n

            \"SaoCopy c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i<\/em><\/p>\n

            \n

            3.2. K\u1ebft h\u1ee3p h\u00e0m INDEX MATCH v\u00e0 VLOOKUP<\/h3>\n<\/div>\n

            Khi c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ed3ng th\u1eddi INDEX, MATCH v\u00e0 VLOOKUP, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n

            =VLOOKUP(INDEX(v\u00f9ng_tham_chi\u1ebfu; h\u00e0ng; c\u1ed9t); table_array; col_index_num; [range_lookup])<\/p>\n

            Gi\u1ea3i th\u00edch c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

              \n
            • INDEX(v\u00f9ng_tham_chi\u1ebfu; h\u00e0ng; c\u1ed9t):<\/strong> Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0m ti\u00eau ch\u00ed t\u00ecm ki\u1ebfm.<\/li>\n
            • Table_array:<\/strong> Ph\u1ea1m vi d\u1eef li\u1ec7u ch\u1ee9a th\u00f4ng tin c\u1ea7n truy xu\u1ea5t.<\/li>\n
            • Col_index_num: <\/strong>Th\u1ee9 t\u1ef1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y k\u1ebft qu\u1ea3.<\/li>\n
            • [Range_lookup]:<\/strong> X\u00e1c \u0111\u1ecbnh ki\u1ec3u d\u00f2 t\u00ecm. Gi\u00e1 tr\u1ecb 0 d\u00f9ng cho t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c, gi\u00e1 tr\u1ecb 1 \u1ee9ng v\u1edbi t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang.<\/li>\n<\/ul>\n

              V\u00ed d\u1ee5 minh h\u1ecda:<\/strong><\/p>\n

              Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ee9c \u0111i\u1ec3m \u01b0u ti\u00ean theo v\u00f9ng c\u1ee7a t\u1eebng h\u1ecdc sinh d\u1ef1a tr\u00ean khu v\u1ef1c sinh s\u1ed1ng.<\/p>\n

              \"V\u00edK\u1ebft h\u1ee3p h\u00e0m INDEX MATCH v\u00e0 VLOOKUP \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ee9c \u0111i\u1ec3m \u01b0u ti\u00ean<\/em><\/p>\n

              C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/strong><\/p>\n

              =VLOOKUP(INDEX(A2:F9;1;6); $I$2:$J$9; 2; 0)<\/p>\n

              Gi\u1ea3i th\u00edch c\u00e1c th\u00e0nh ph\u1ea7n:<\/strong><\/p>\n

                \n
              • INDEX(A2:F9;1;6): <\/strong>L\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i d\u00f2ng 1, c\u1ed9t 6 trong ph\u1ea1m vi A2:F9 \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u ki\u1ec7n tra c\u1ee9u.<\/li>\n
              • $I$2:$J$9: <\/strong>L\u00e0 v\u00f9ng d\u1eef li\u1ec7u t\u1eeb I2 \u0111\u1ebfn J9, n\u01a1i ch\u1ee9a th\u00f4ng tin c\u1ea7n \u0111\u1ed1i chi\u1ebfu.<\/li>\n
              • 2: <\/strong>Ch\u1ec9 \u0111\u1ecbnh c\u1ed9t th\u1ee9 hai trong b\u1ea3ng d\u00f2 ch\u1ee9a k\u1ebft qu\u1ea3 \u0111i\u1ec3m v\u00f9ng.<\/li>\n
              • 0: <\/strong>Y\u00eau c\u1ea7u VLOOKUP t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c (d\u00f2 t\u00ecm \u0111\u00fang gi\u00e1 tr\u1ecb).<\/li>\n<\/ul>\n

                \"K\u1ebftK\u1ebft qu\u1ea3 m\u1ee9c \u0111i\u1ec3m \u01b0u ti\u00ean theo t\u1eebng v\u00f9ng c\u1ee7a h\u1ecdc sinh<\/em><\/p>\n

                \n

                4. K\u1ebft h\u1ee3p h\u00e0m INDEX MATCH v\u00e0 h\u00e0m IF<\/h2>\n<\/div>\n

                \u0110\u1ec3 k\u1ebft h\u1ee3p h\u00e0m INDEX, MATCH v\u00e0 IF, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t nh\u01b0 sau:<\/p>\n

                =IF(INDEX(m\u1ea3ng_d\u1eef_li\u1ec7u; MATCH(kh\u00f3a_t\u00ecm_ki\u1ebfm; d\u1ea3i_\u00f4; lo\u1ea1i_t\u00ecm_ki\u1ebfm); s\u1ed1_c\u1ed9t) + \u0111i\u1ec1u_ki\u1ec7n; gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang; gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/p>\n

                Gi\u1ea3i th\u00edch c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

                  \n
                • M\u1ea3ng_d\u1eef_li\u1ec7u:<\/strong> V\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c m\u1ed9t d\u00e3y \u00f4 c\u1ed1 \u0111\u1ecbnh m\u00e0 h\u00e0m INDEX s\u1ebd l\u1ea5y k\u1ebft qu\u1ea3.<\/li>\n
                • Kh\u00f3a_t\u00ecm_ki\u1ebfm: <\/strong>Gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 tra c\u1ee9u v\u1ecb tr\u00ed trong d\u1eef li\u1ec7u.<\/li>\n
                • D\u1ea3i_\u00f4: <\/strong>Ph\u1ea1m vi ch\u1ee9a danh s\u00e1ch gi\u00e1 tr\u1ecb tham chi\u1ebfu, th\u01b0\u1eddng ch\u1ec9 g\u1ed3m m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t c\u1ed9t.<\/li>\n
                • Lo\u1ea1i_t\u00ecm_ki\u1ebfm: <\/strong>X\u00e1c \u0111\u1ecbnh c\u00e1ch MATCH t\u00ecm ki\u1ebfm:<\/li>\n
                • 0: <\/strong>T\u00ecm kh\u1edbp ch\u00ednh x\u00e1c.<\/li>\n
                • 1: <\/strong>T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang (gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t nh\u01b0ng v\u1eabn \u2264 kh\u00f3a t\u00ecm ki\u1ebfm).<\/li>\n
                • -1: <\/strong>T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t nh\u01b0ng v\u1eabn \u2265 kh\u00f3a t\u00ecm ki\u1ebfm).<\/li>\n
                • S\u1ed1_c\u1ed9t: <\/strong>Th\u1ec3 hi\u1ec7n v\u1ecb tr\u00ed c\u1ed9t trong m\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n
                • Gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang: <\/strong>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF th\u1ecfa m\u00e3n.<\/li>\n
                • Gi\u00e1_tr\u1ecb_n\u1ebfu_sai:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00fang.<\/li>\n<\/ul>\n

                  \"C\u00f4ngC\u00fa ph\u00e1p K\u1ebft h\u1ee3p h\u00e0m INDEX MATCH v\u00e0 h\u00e0m IF<\/em><\/p>\n

                  V\u00ed d\u1ee5 minh h\u1ecda:<\/strong><\/p>\n

                  Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra xem m\u1eb7t h\u00e0ng Bim Bim c\u00f3 \u0111\u1ea1t ch\u1ec9 ti\u00eau KPI hay kh\u00f4ng. \u0110i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra l\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n ph\u1ea3i v\u01b0\u1ee3t m\u1ee9c 10 s\u1ea3n ph\u1ea9m m\u1edbi \u0111\u01b0\u1ee3c xem l\u00e0 ho\u00e0n th\u00e0nh KPI.<\/p>\n

                  \"D\u00f9ngB\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 ki\u1ec3m tra c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 \u0111\u1ea1t ch\u1ec9 ti\u00eau KPI hay kh\u00f4ng<\/em><\/p>\n

                  C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/strong><\/p>\n

                  =IF(INDEX(A2:F5,MATCH(“Bim Bim”,A2:A5,0),3)>10,”\u0110\u1ea1t”,”Kh\u00f4ng \u0111\u1ea1t”)<\/p>\n

                  Gi\u1ea3i th\u00edch c\u00e1ch ho\u1ea1t \u0111\u1ed9ng:<\/strong><\/p>\n

                    \n
                  • MATCH<\/strong> t\u00ecm v\u1ecb tr\u00ed c\u1ee7a d\u00f2ng ch\u1ee9a s\u1ea3n ph\u1ea9m b\u00e1nh quy trong danh s\u00e1ch A2:A5.<\/li>\n
                  • INDEX <\/strong>d\u1ef1a v\u00e0o d\u00f2ng t\u00ecm \u0111\u01b0\u1ee3c \u0111\u1ec3 l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng \u0111\u00e3 b\u00e1n t\u1ea1i c\u1ed9t th\u1ee9 3 trong v\u00f9ng A2:F5.<\/li>\n
                  • H\u00e0m IF <\/strong>so s\u00e1nh s\u1ed1 l\u01b0\u1ee3ng \u0111\u00f3 v\u1edbi ng\u01b0\u1ee1ng 10:\n
                      \n
                    • N\u1ebfu l\u1edbn h\u01a1n 10 \u2192 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “\u0110\u1ea1t”.<\/li>\n
                    • N\u1ebfu kh\u00f4ng \u0111\u1ea1t m\u1ee9c n\u00e0y \u2192 tr\u1ea3 v\u1ec1 “Kh\u00f4ng \u0111\u1ea1t”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                      \"K\u1ebftK\u1ebft qu\u1ea3 ki\u1ec3m tra m\u1eb7t h\u00e0ng \u0111\u1ea1t KPI<\/em><\/p>\n

                      \n

                      5. L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH<\/h2>\n<\/div>\n

                      Khi \u00e1p d\u1ee5ng h\u00e0m INDEX v\u00e0 MATCH trong c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c, ng\u01b0\u1eddi d\u00f9ng d\u1ec5 g\u1eb7p m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn sau:<\/p>\n

                      \n

                      5.1. L\u1ed7i #REF<\/h3>\n<\/div>\n

                      Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n

                      L\u1ed7i n\u00e0y x\u1ea3y ra khi ph\u1ea1m vi m\u00e0 h\u00e0m INDEX tr\u1ea3 v\u1ec1 kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t v\u1edbi v\u00f9ng tra c\u1ee9u c\u1ee7a MATCH. M\u1ed9t tr\u01b0\u1eddng h\u1ee3p kh\u00e1c l\u00e0 MATCH kh\u00f4ng t\u00ecm th\u1ea5y v\u1ecb tr\u00ed ph\u00f9 h\u1ee3p, khi\u1ebfn INDEX kh\u00f4ng th\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7.<\/p>\n

                      C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

                        \n
                      • Ki\u1ec3m tra l\u1ea1i v\u00f9ng tham chi\u1ebfu c\u1ee7a INDEX, b\u1ea3o \u0111\u1ea3m r\u1eb1ng ph\u1ea1m vi n\u00e0y n\u1eb1m trong gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u h\u1ee3p l\u1ec7.<\/li>\n
                      • So\u00e1t l\u1ea1i d\u1ea3i \u00f4 MATCH \u0111ang d\u00f2 t\u00ecm \u0111\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm th\u1ef1c s\u1ef1 t\u1ed3n t\u1ea1i.<\/li>\n
                      • \u0110\u1ea3m b\u1ea3o hai h\u00e0m tham chi\u1ebfu c\u00f9ng c\u1ea5u tr\u00fac d\u1eef li\u1ec7u (s\u1ed1 h\u00e0ng\/c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed3ng).<\/li>\n<\/ul>\n

                        \"L\u1ed7iL\u1ed7i #REF khi k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH<\/em><\/p>\n

                        \n

                        5.2. L\u1ed7i #N\/A<\/h3>\n<\/div>\n

                        Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n

                        L\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb c\u1ea7n tra c\u1ee9u kh\u00f4ng c\u00f3 trong d\u1ea3i d\u1eef li\u1ec7u. L\u1ed7i n\u00e0y t\u01b0\u01a1ng t\u1ef1 nh\u01b0 khi s\u1eed d\u1ee5ng VLOOKUP v\u00e0 kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb kh\u1edbp ch\u00ednh x\u00e1c.<\/p>\n

                        C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

                          \n
                        • Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o xem c\u00f3 l\u1ed7i ch\u00ednh t\u1ea3, th\u1eeba d\u1ea5u c\u00e1ch ho\u1eb7c sai \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng.<\/li>\n
                        • \u0110\u1ea3m b\u1ea3o d\u1ea3i \u00f4 tra c\u1ee9u ch\u1ee9a \u0111\u00fang gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<\/ul>\n

                          \"L\u1ed7iL\u1ed7i #N\/A khi k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH<\/em><\/p>\n

                          V\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng hi\u1ec3u c\u00e1ch k\u1ebft h\u1ee3p hai h\u00e0m INDEX v\u00e0 MATCH trong Excel c\u0169ng nh\u01b0 \u00e1p d\u1ee5ng linh ho\u1ea1t trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng x\u1eed l\u00fd d\u1eef li\u1ec7u. H\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 h\u1ecdc th\u00eam nhi\u1ec1u b\u00ed quy\u1ebft Excel h\u1eefu d\u1ee5ng m\u1ed7i ng\u00e0y.<\/p>\n

                          N\u1ebfu b\u1ea1n \u0111ang t\u00ecm thi\u1ebft b\u1ecb h\u1ed7 tr\u1ee3 h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c, c\u00e1c m\u1eabu \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng c\u1ea5u h\u00ecnh m\u1ea1nh, hi\u1ec3n th\u1ecb s\u1eafc n\u00e9t \u0111ang gi\u1ea3m gi\u00e1 t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn s\u1ebd l\u00e0 l\u1ef1a ch\u1ecdn \u0111\u00e1ng c\u00e2n nh\u1eafc.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                          \u00a0 C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel gi\u00fap d\u00f2 t\u00ecm d\u1eef li\u1ec7u linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. MATCH gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ea7n tra c\u1ee9u, c\u00f2n INDEX tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. Nh\u1edd \u0111\u00f3, vi\u1ec7c truy xu\u1ea5t th\u00f4ng tin tr\u1edf n\u00ean nhanh v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u b\u1ea3ng t\u00ednh […]<\/p>\n","protected":false},"author":1,"featured_media":6046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-6045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/12\/19615.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/6045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=6045"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/6045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/6046"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=6045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=6045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=6045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}