{"id":19447,"date":"2023-12-05T13:25:23","date_gmt":"2023-12-05T13:25:23","guid":{"rendered":"https:\/\/masterskills.org\/blog\/nhung-dieu-ban-nen-biet-ve-ham-vlookup-va-cach-su-dung-chi-tiet.html"},"modified":"2023-12-22T04:50:00","modified_gmt":"2023-12-21T21:50:00","slug":"nhung-dieu-ban-nen-biet-ve-ham-vlookup-va-cach-su-dung-chi-tiet","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/nhung-dieu-ban-nen-biet-ve-ham-vlookup-va-cach-su-dung-chi-tiet.html","title":{"rendered":"Nh\u1eefng \u0110i\u1ec1u B\u1ea1n N\u00ean Bi\u1ebft V\u1ec1 H\u00e0m Vlookup V\u00e0 C\u00e1ch S\u1eed D\u1ee5ng Chi Ti\u1ebft"},"content":{"rendered":"
\n

H\u00e0m Vlookup<\/em><\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng lo\u1ea1i h\u00e0m c\u1ea7n thi\u1ebft v\u00e0 h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Excel. Kh\u00f4ng ch\u1ec9 h\u1ed7 tr\u1ee3 vi\u1ec7c tra c\u1ee9u d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3, lo\u1ea1i h\u00e0m n\u00e0y c\u0169ng h\u1ed7 tr\u1ee3 gi\u1ea3i quy\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c tr\u00ean Excel tr\u1edf n\u00ean nhanh ch\u00f3ng h\u01a1n. B\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi \u0111\u00e2y cung c\u1ea5p chi ti\u1ebft th\u00f4ng tin v\u1ec1 h\u00e0m Vlookup v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y. T\u00ecm hi\u1ec3u ngay c\u00f9ng <\/span><\/em>Masterskills<\/span><\/em>. <\/span><\/em><\/p>\n

H\u00e0m Vlookup h\u1ed7 tr\u1ee3 g\u00ec trong c\u00f4ng vi\u1ec7c?<\/strong><\/h2>\n

M\u1ed9t trong nh\u1eefng y\u1ebfu t\u1ed1 c\u1ea7n thi\u1ebft \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh t\u00ednh to\u00e1n tr\u00ean Excel \u0111\u00f3 l\u00e0 b\u1ea1n c\u1ea7n thu\u1ed9c n\u1eb1m l\u00f2ng nh\u1eefng lo\u1ea1i h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u1ed5 bi\u1ebfn trong h\u1ec7 th\u1ed1ng. \u0110\u00e2y l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c \u0111\u1ecbnh s\u1eb5n trong ph\u1ea7n m\u1ec1m v\u1edbi m\u1ee5c \u0111\u00edch \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t ch\u1ee9c n\u0103ng t\u00ednh to\u00e1n chuy\u00ean bi\u1ec7t, ho\u1eb7c \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh Excel hay ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean nh\u1eefng d\u1eef li\u1ec7u \u0111\u00e3 cung c\u1ea5p. <\/span><\/p>\n

Trong s\u1ed1 c\u00e1c lo\u1ea1i h\u00e0m c\u01a1 b\u1ea3n th\u00ec Vlookup ch\u00ednh l\u00e0 c\u00e1i t\u00ean n\u1ed5i b\u1eadt do t\u1ea7n su\u1ea5t xu\u1ea5t hi\u1ec7n kh\u00e1 nhi\u1ec1u khi th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh t\u00ednh to\u00e1n tr\u00ean Excel. C\u1ee5 th\u1ec3, <\/span>h\u00e0m Vlookup <\/strong>gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u ho\u1eb7c th\u00f4ng tin, s\u1ed1 li\u1ec7u c\u1ea7n t\u00ecm theo ph\u1ea1m vi c\u1ed9t, h\u00e0ng ho\u1eb7c b\u1ea3ng. <\/span>H\u00e0m Vlookup<\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch \u0111\u1ed9c l\u1eadp hay k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c \u0111\u1ec1u \u0111\u01b0\u1ee3c.<\/span><\/p>\n

\n

H\u00e0m Vlookup gi\u00fap t\u00ecm ki\u1ebfm th\u00f4ng tin, s\u1ed1 li\u1ec7u trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

<\/span><\/p>\n

    \n<\/ul>\n

    C\u00f4ng th\u1ee9c h\u00e0m Vlookup trong Excel<\/strong><\/h3>\n

    M\u1ed9t trong nh\u1eefng y\u1ebfu t\u1ed1 quan tr\u1ecdng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n <\/span>c\u00e1ch d\u00f9ng h\u00e0m Vlookup<\/strong> \u0111\u00f3 l\u00e0 b\u1ea1n c\u1ea7n thu\u1ed9c m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 c\u1ee7a lo\u1ea1i h\u00e0m n\u00e0y. Trong Excel, m\u1ed7i lo\u1ea1i h\u00e0m s\u1ebd c\u00f3 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau, h\u00e0m Vlookup c\u0169ng kh\u00f4ng ngo\u1ea1i l\u1ec7. <\/span><\/p>\n

    \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m Vlookup, b\u1ea1n ti\u1ebfn h\u00e0nh g\u00f5 \u0111\u1ea7y \u0111\u1ee7 theo c\u00fa ph\u00e1p sau: <\/span><\/p>\n

    =<\/span>VLOOKUP(Lookup_value, Table_array, Col_index_num, [Range_lookup])<\/strong><\/p>\n

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

      \n<\/ul>\n

      <\/span><\/p>\n

        \n<\/ul>\n

        <\/span><\/p>\n

        C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Vlookup trong Excel (ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

        V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m Vlookup<\/strong><\/h3>\n

        Th\u1ef1c t\u1ebf, c\u00f4ng th\u1ee9c v\u00e0 <\/span>c\u00e1ch d\u00f9ng h\u00e0m Vlookup<\/strong> kh\u00f4ng qu\u00e1 kh\u00f3. V\u00ec \u0111\u00e2y l\u00e0 h\u00e0m t\u00ednh thu\u1ed9c nh\u00f3m h\u00e0m c\u01a1 b\u1ea3n trong Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 nhi\u1ec1u trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 th\u1ed1ng k\u00ea d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh n\u00ean vi\u1ec7c h\u1ecdc thu\u1ed9c l\u00f2ng c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m \u0111\u01b0\u1ee3c khuy\u1ebfn kh\u00edch. <\/span><\/p>\n

        N\u1ebfu d\u1ea1ng c\u00f4ng th\u1ee9c kh\u00f4 khan khi\u1ebfn cho b\u1ea1n c\u1ea3m th\u1ea5y kh\u00f3 hi\u1ec3u v\u00e0 ch\u01b0a th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m Vlookup khi t\u00ecm ki\u1ebfm th\u00f4ng tin trong b\u1ea3ng Excel th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 ngay b\u00ean d\u01b0\u1edbi: <\/span><\/p>\n

          \n<\/ul>\n

          Nh\u01b0 v\u1eady, l\u00fac n\u00e0y, c\u00f4ng th\u1ee9c nh\u1eadp h\u00e0m Vlookup \u0111\u1ea7y \u0111\u1ee7 \u0111\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c \u0111i\u1ec3m To\u00e1n c\u1ee7a Hedy trong b\u1ea3ng d\u1eef li\u1ec7u s\u1ebd l\u00e0:<\/span><\/p>\n

          =<\/span>VLOOKUP(F3,$A$3:$D$8,3,FALSE)<\/strong><\/p>\n

          <\/strong><\/p>\n

          V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m Vlookup trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

          :<\/span><\/p>\n

            \n<\/ul>\n

            C\u1ea7n ch\u00fa \u00fd \u0111i\u1ec1u g\u00ec khi d\u00f9ng h\u00e0m Vlookup?<\/strong><\/h2>\n

            H\u00e0m Vlookup<\/strong> r\u1ea5t h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh th\u1ed1ng k\u00ea v\u00e0 t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Excel. Tuy nhi\u00ean, \u0111\u1ec3 t\u00ednh n\u0103ng c\u1ee7a h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch c\u00f3 hi\u1ec7u qu\u1ea3, gi\u00fap cho c\u00f4ng vi\u1ec7c \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft nhanh ch\u00f3ng, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u nh\u01b0 sau: <\/span><\/p>\n

              \n<\/ul>\n

              <\/span><\/p>\n

                \n<\/ul>\n

                <\/span><\/p>\n

                M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

                Nh\u1eefng l\u1ed7i sai th\u00f4ng th\u01b0\u1eddng v\u00e0 ph\u01b0\u01a1ng ph\u00e1p kh\u1eafc ph\u1ee5c khi d\u00f9ng h\u00e0m Vlookup? <\/strong><\/h2>\n

                Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng<\/span> h\u00e0m Vlookup<\/strong> kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi tr\u01b0\u1eddng h\u1ee3p m\u1eafc c\u00e1c l\u1ed7i sai khi\u1ebfn h\u00e0m kh\u00f4ng th\u1ec3 ho\u1ea1t \u0111\u1ed9ng. N\u1ebfu kh\u00f4ng ph\u00e1t hi\u1ec7n v\u00e0 s\u1eeda ch\u1eefa k\u1ecbp th\u1eddi c\u00f3 th\u1ec3 g\u00e2y \u1ea3nh h\u01b0\u1edfng tr\u1ef1c ti\u1ebfp \u0111\u1ebfn ti\u1ebfn \u0111\u1ed9 c\u1ee7a c\u00f4ng vi\u1ec7c. Do \u0111\u00f3, b\u1ea1n c\u1ea7n t\u00ecm hi\u1ec3u c\u00e1c l\u1ed7i sai th\u01b0\u1eddng g\u1eb7p c\u0169ng nh\u01b0 c\u00e1ch kh\u1eafc ph\u1ee5c trong khi d\u00f9ng h\u00e0m Vlookup trong Excel nh\u01b0 sau:<\/span><\/p>\n

                L\u1ed7i #NA: <\/strong>#NA: \u0110\u00e2y l\u00e0 l\u1ed7i vi\u1ec7c d\u00f2 t\u00ecm kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb.<\/span><\/p>\n

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

                  \n<\/ul>\n

                  = IFERROR (c\u00f4ng th\u1ee9c g\u1ed1c, gi\u00e1 tr\u1ecb s\u1ebd hi\u1ec3n th\u1ecb n\u1ebfu c\u00f4ng th\u1ee9c g\u1ed1c c\u00f3 l\u1ed7i).<\/strong><\/p>\n

                    \n<\/ul>\n

                    = IFERROR (VLOOKUP(B5,$G$2:$H$14,2,0)\u201dT\u00ecm gi\u00e1 tr\u1ecb l\u1ed7i\u201d)<\/strong><\/p>\n

                    L\u1ed7i #REF: <\/strong>\u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng th\u1ea5y khi d\u00f9ng <\/span>h\u00e0m Vlookup<\/strong>. L\u1ed7i n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u1ed9t d\u00f2 t\u00ecm kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u trong b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm.<\/span><\/p>\n

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

                      \n<\/ul>\n

                      L\u1ed7i #VALUE:<\/strong> X\u1ea3y ra khi c\u00f3 l\u1ed7i trong qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o h\u00e0m Vlookup. <\/span><\/p>\n

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

                        \n<\/ul>\n

                        :<\/span><\/p>\n

                          \n<\/ul>\n

                          <\/span><\/p>\n

                          L\u1ed7i #VALUE trong h\u00e0m Vlookup (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

                          Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c th\u00f4ng tin xoay quanh<\/span><\/em> v\u1ec1 <\/span><\/em>c\u00e1ch d\u00f9ng h\u00e0m Vlookup <\/em><\/strong>v\u00e0 c\u00e1c l\u01b0u \u00fd \u0111i k\u00e8m. Hy v\u1ecdng sau khi \u0111\u1ecdc xong, b\u1ea1n s\u1ebd bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c nhi\u1ec1u tips hay khi s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n d\u1eef li\u1ec7u trong ph\u1ea7n m\u1ec1m Excel. Ngo\u00e0i ra, n\u1ebfu c\u00f3 nhu c\u1ea7u mu\u1ed1n t\u00ecm ki\u1ebfm nh\u1eefng <\/span><\/em>m\u1eabu CV \u0111\u1eb9p<\/span><\/em> \u0111\u1ec3 g\u00e2y \u1ea5n t\u01b0\u1ee3ng v\u1edbi nh\u00e0 tuy\u1ec3n d\u1ee5ng, truy c\u1eadp ngay <\/span><\/em>Masterskills<\/span><\/em> \u0111\u1ec3 tham kh\u1ea3o c\u00e1ch thi\u1ebft k\u1ebf CV sao cho \u0111\u1ed9c \u0111\u00e1o ,v\u00e0 n\u00e2ng cao c\u01a1 h\u1ed9i tr\u00fang tuy\u1ec3n c\u00f4ng vi\u1ec7c mong mu\u1ed1n. Ngo\u00e0i ra, \u0111\u1eebng qu\u00ean theo d\u00f5i th\u00f4ng tin t\u1eeb Masterskills c\u1eadp nh\u1eadt nhi\u1ec1u th\u00f4ng tin v\u1ec1 c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng nh\u1eefng lo\u1ea1i h\u00e0m c\u01a1 b\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng nh\u1ea5t trong Excel. <\/span><\/em><\/span><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

                          H\u00e0m Vlookup<\/em><\/strong><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19447"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19447"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19447\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}