{"id":4455,"date":"2020-03-03T00:00:00","date_gmt":"2020-03-03T00:00:00","guid":{"rendered":"http:\/\/applestore.vn\/thu-thuat-excel-cach-su-dung-ham-vlookup-cho-nguoi-moi-bat-dau-n60831\/"},"modified":"2021-11-23T10:03:22","modified_gmt":"2021-11-23T03:03:22","slug":"ham-vlookup-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-vlookup-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m VLOOKUP trong Excel \u0111\u01a1n gi\u1ea3n – C\u00f3 v\u00ed d\u1ee5"},"content":{"rendered":"

H\u00e0m Vlookup trong Excel<\/strong> l\u00e0 m\u1ed9t h\u00e0m \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng trong Excel gi\u00fap b\u1ea1n t\u00ecm v\u00e0 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. Tuy nhi\u00ean th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel<\/strong>, h\u00e3y c\u00f9ng Ben Computer t\u00ecm hi\u1ec3u ngay t\u1ea1i \u0111\u00e2y nh\u00e9.<\/p>\n

1. VLOOKUP l\u00e0 h\u00e0m g\u00ec?<\/strong><\/h2>\n
H\u00e0m Vlookup<\/strong> l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3 cho b\u1ea1n trong m\u1ed9t \u00f4 b\u1ea5t k\u00ec m\u00e0 b\u1ea1n l\u1ef1a ch\u1ecdn.<\/div>\n

H\u00e0m VLOOKUP trong Excel<\/strong> c\u00f3 th\u1ec3 d\u00f9ng cho h\u1ea7u h\u1ebft t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a excel t\u1eeb c\u0169 \u0111\u1ebfn m\u1edbi v\u00ec \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n c\u1ee7a excel.<\/p>\n

2. C\u00f4ng th\u1ee9c VLOOKUP trong Excel<\/strong><\/h2>\n
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/strong><\/div>\n

Gi\u1ea3i th\u00edch c\u1ea5u tr\u00fac h\u00e0m:<\/strong><\/p>\n

    \n
  • H\u00e0m VLOOKUP<\/strong> c\u00f3 4 tham s\u1ed1, 3 tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, tham s\u1ed1 cu\u1ed1i c\u00f9ng \u0111\u00f3ng ngo\u1eb7c vu\u00f4ng l\u00e0 tham s\u1ed1 t\u00f9y ch\u1ecdn.<\/li>\n
  • = VLOOKUP<\/strong> (nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm<\/em>, n\u01a1i b\u1ea1n mu\u1ed1n t\u00ecm n\u00f3<\/em>, s\u1ed1 c\u1ed9t trong d\u1ea3i \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u1ec3 tr\u1ea3 v\u1ec1<\/em>, tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p g\u1ea7n \u0111\u00fang ho\u1eb7c ch\u00ednh x\u00e1c \u2013 \u0111\u01b0\u1ee3c ch\u1ec9 b\u00e1o l\u00e0 1\/TRUE<\/em>, ho\u1eb7c 0\/FALSE<\/em>).<\/li>\n<\/ul>\n

    \u0110\u1ec3 hi\u1ec3u c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m vloopup trong excel ta c\u00f9ng \u0111i tham kh\u1ea3o v\u00ed d\u1ee5 sau:<\/p>\n

    \"<\/p>\n

    Trong v\u00ed d\u1ee5 tr\u00ean, nhi\u1ec7m v\u1ee5 c\u1ee7a ch\u00fang ta l\u00e0 t\u00ecm \u0111\u01a1n gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m c\u00f3 m\u00e3 s\u1ea3n ph\u1ea9m l\u00e0\u00a0SP004<\/strong>,\u00a0<\/em>c\u00f4ng th\u1ee9c VLOOKUP \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u00f4\u00a0F2\u00a0<\/em>l\u00e0:<\/p>\n

    =VLOOKUP(“SP004”,A2:C7,3,FALSE)<\/strong><\/div>\n

    \"H\u00e0m<\/p>\n

    Ta c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i h\u00e0m b\u1eb1ng l\u1eddi nh\u01b0 sau: \u201cT\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb c\u1ee7a m\u00e3 SP004 trong v\u00f9ng \u00f4 t\u1eeb A2 \u0111\u1ebfn C7 t\u1ea1i c\u1ed9t 3, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb n\u00e0o ph\u00f9 h\u1ee3p th\u00ec l\u00e0 FALSE\u201d<\/p>\n

    Nh\u01b0 v\u1eady ta c\u00f3 th\u1ec3 gi\u1ea3i th\u00edch c\u00e1c th\u00f4ng s\u1ed1 nh\u01b0 sau:<\/p>\n

      \n
    • lookup_value<\/strong> : l\u00e0 gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 thu\u1ed9c ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c ki\u1ec3u chu\u1ed7i, ki\u1ec3u tham chi\u1ebfu ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ra b\u1edfi m\u1ed9t h\u00e0m kh\u00e1c.
      \nTrong v\u00ed d\u1ee5 tr\u00ean, \u201cSP004<\/strong>\u201d l\u00e0\u00a0lookup_value<\/strong>.<\/em><\/li>\n
    • Table_array<\/strong>: l\u00e0 v\u00f9ng d\u1eef li\u1ec7u t\u00ecm ki\u1ebfm g\u1ed3m \u00edt nh\u1ea5t 2 c\u1ed9t. H\u00e0m Vlookup m\u1eb7c \u0111\u1ecbnh t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb y\u00eau c\u1ea7u trong c\u1ed9t \u0111\u1ea7u ti\u00ean.
      \nTrong v\u00ed d\u1ee5 k\u1ec3 tr\u00ean, Vlookup s\u1ebd t\u00ecm ki\u1ebfm chu\u1ed7i m\u00e3 \u201cSP004\u201d trong c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t A.<\/em><\/li>\n
    • Col_index_num<\/strong>: L\u00e0 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong b\u1ea3ng table_array. T\u1ee9c c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi \u0111\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm.
      \nTrong v\u00ed d\u1ee5 tr\u00ean \u0111\u1ed1i t\u01b0\u1ee3ng SP004 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n t\u00ecm l\u00e0 300 thu\u1ed9c c\u1ed9t 3.<\/em><\/li>\n
    • Ranger_lookup<\/strong>: tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c, nh\u1eadn gi\u00e1 tr\u1ecb TRUE ho\u1eb7c 1 (t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang) ho\u1eb7c FALSE ho\u1eb7c 0 (t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c) .
      \nFALSE: tham s\u1ed1 range_look up khi nh\u1eadn gi\u00e1 tr\u1ecb FALSE s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c d\u1eef li\u1ec7u cho \u0111\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm.
      \nTrong v\u00ed d\u1ee5 k\u1ec3 tr\u00ean tham s\u1ed1 range_looking s\u1ebd t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c gi\u00e1 \u0111\u1ed1i t\u01b0\u1ee3ng \u201cSP004P<\/strong>\u201d trong c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t A, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 cho b\u1ea1n k\u1ebft qu\u1ea3 l\u1ed7i #N\/A.
      \n<\/em>TRUE: Tham s\u1ed1 range_lookup khi nh\u1eadn gi\u00e1 tr\u1ecb TRUE s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm v\u1edbi gi\u00e1 tr\u1ecb ho\u1eb7c g\u1ea7n \u0111\u00fang l\u1edbn nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0ng nh\u1ecf h\u01a1n Vlookup value. \u0110i\u1ec1u ki\u1ec7n khi d\u00f9ng TRUE c\u1ee7a h\u00e0m n\u00e0y \u0111\u00f3 l\u00e0 c\u00e1c c\u1ed9t t\u00ecm ki\u1ebfm ph\u1ea3i \u0111\u01b0\u1ee3c x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n<\/ul>\n

      \"c\u00f4ng<\/p>\n

      III. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel<\/strong><\/h2>\n

      H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u00f3 t\u1ea7n su\u1ea5t s\u1eed d\u1ee5ng r\u1ea5t l\u1edbn trong c\u00e1c t\u00e1c v\u1ee5 Excel v\u0103n ph\u00f2ng. H\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm t\u00ean s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u1ee3ng, \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m\u2026 d\u1ef1a v\u00e0o m\u00e3 s\u1ea3n ph\u1ea9m, m\u00e3 v\u1ea1ch. Ho\u1eb7c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm h\u1ecd t\u00ean nh\u00e2n vi\u00ean, x\u1ebfp lo\u1ea1i, t\u00ednh ph\u1ee5 c\u1ea5p,\u2026 theo ch\u1ee9c v\u1ee5, thang \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1.<\/p>\n

      D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP trong Excel m\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o!<\/p>\n

      1. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP c\u01a1 b\u1ea3n<\/strong><\/h3>\n

      Trong n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 x\u1ebfp lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m s\u1ed1. Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m trung b\u00ecnh c\u1ee7a 10 h\u1ecdc sinh v\u1edbi Quy \u0111\u1ecbnh x\u1ebfp lo\u1ea1i nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

      \"c\u00e1ch<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 X\u1ebfp lo\u1ea1i, b\u1ea1n nh\u1eadp l\u1ec7nh =VLOOKUP($C3,$A$15:$B$18,2,1).<\/p>\n

      \"c\u00e1ch<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter b\u1ea1n s\u1ebd th\u1ea5y \u1edf \u00f4 X\u1ebfp lo\u1ea1i \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 Gi\u1ecfi.<\/p>\n

      \"c\u00e1ch<\/p>\n

      B\u01b0\u1edbc 3: <\/strong>Click chu\u1ed9t v\u00e0o \u00f4 D4, xu\u1ea5t hi\u1ec7n \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i. Nh\u1ea5p chu\u1ed9t v\u00e0o r\u1ed3i k\u00e9o d\u1ecdc t\u1eeb \u0111\u00f3 \u0111\u1ebfn D12 \u0111\u1ec3 copy c\u00f4ng th\u1ee9c x\u1ebfp lo\u1ea1i cho c\u00e1c h\u1ecdc sinh c\u00f2n l\u1ea1i l\u00e0 Xong. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c b\u1ea3ng nh\u01b0 h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y!<\/p>\n

      \"k\u1ebft<\/p>\n

      2. C\u00e1ch d\u00f9ng h\u00e0m VLOOKUP gi\u1eefa 2 sheet<\/strong><\/h3>\n

      H\u00e0m VLOOKUP kh\u00f4ng ch\u1ec9 c\u00f3 th\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u tr\u00ean c\u00f9ng 1 sheet m\u00e0 c\u00f2n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gi\u1eefa 2 hay nhi\u1ec1u sheet kh\u00e1c nhau. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m VLOOKUP gi\u1eefa 2 sheet nh\u01b0 th\u1ebf n\u00e0o th\u00ec h\u00e3y theo d\u00f5i ngay v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y!<\/p>\n

      V\u00ed d\u1ee5:<\/strong> S\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ednh ti\u1ec1n l\u01b0\u01a1ng cho nh\u00e2n vi\u00ean theo ch\u1ee9c v\u1ee5. Trong \u0111\u00f3, danh s\u00e1ch nh\u00e2n vi\u00ean \u1edf sheet 1, m\u00e3 ch\u1ee9c v\u1ee5 v\u00e0 ti\u1ec1n l\u01b0\u01a1ng \u1edf sheet 2. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n

        \n
      • Sheet 1 l\u00e0 Danh s\u00e1ch nh\u00e2n vi\u00ean<\/li>\n
      • Sheet 2 l\u00e0 M\u00e3 ch\u1ee9c v\u1ee5 v\u00e0 ti\u1ec1n l\u01b0\u01a1ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi ch\u1ee9c v\u1ee5<\/li>\n<\/ul>\n

        \"c\u00e1ch<\/p>\n

        Sheet 1 l\u00e0 Danh s\u00e1ch nh\u00e2n vi\u00ean<\/em><\/p>\n

        \"s\u1eed<\/p>\n

        Sheet 2 l\u00e0 M\u00e3 ch\u1ee9c v\u1ee5 v\u00e0 ti\u1ec1n l\u01b0\u01a1ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi ch\u1ee9c v\u1ee5<\/em><\/p>\n

        \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP t\u00ednh \u0111\u01b0\u1ee3c ti\u1ec1n l\u01b0\u01a1ng theo ch\u1ee9c v\u1ee5 c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean, b\u1ea1n th\u1ef1c hi\u1ec7n l\u1ea7n l\u01b0\u1ee3t c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> T\u1ea1i Sheet 1, b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP nh\u01b0 sau: =VLOOKUP(Sheet1!D3)<\/strong><\/p>\n

        \"d\u00f9ng<\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Sang Sheet 2, b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP nh\u01b0 sau: =VLOOKUP(Sheet1!D3,Sheet2!$A$3:$B$7,2)<\/strong><\/p>\n

        \"h\u00e0m<\/p>\n

        B\u01b0\u1edbc 3:<\/strong> Copy h\u00e0m VLOOKUP v\u1eeba g\u00f5 \u1edf Sheet 2 sang \u00f4 E3 r\u1ed3i nh\u1ea5n Enter. B\u1ea1n s\u1ebd th\u1ea5y \u00f4 L\u01b0\u01a1ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 5000. \u0110\u1ed1i chi\u1ebfu v\u1edbi B\u1ea2NG L\u01af\u01a0NG \u1edf sheet 2 th\u00ec \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/p>\n

        \"D\u00f9ng<\/p>\n

        B\u01b0\u1edbc 4:<\/strong> B\u1ea1n click chu\u1ed9t v\u00e0o \u00f4 E3, khi th\u1ea5y c\u00f3 h\u00ecnh vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i ph\u00eda d\u01b0\u1edbi, b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o icon \u0111\u00f3 r\u1ed3i k\u00e9o chu\u1ed9t \u0111\u1ebfn \u00f4 E8. K\u1ebft qu\u1ea3 l\u01b0\u01a1ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi ch\u1ee9c v\u1ee5 c\u1ee7a t\u1eebng ng\u01b0\u1eddi s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt \u0111\u1ea7y \u0111\u1ee7 nh\u01b0 h\u00ecnh.<\/p>\n

        \"H\u00e0m<\/p>\n

        3. C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m VLOOKUP c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h3>\n

        \u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m VLOOKUP c\u00f3 \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1ch t\u1ea1o b\u1ea3ng ph\u1ee5 ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng. M\u1ed7i m\u1ed9t c\u00e1ch l\u00e0m s\u1ebd c\u00f3 nh\u1eefng \u01b0u \u0111i\u1ec3m, h\u1ea1n ch\u1ebf kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c th\u00f4ng tin chi ti\u1ebft v\u1ec1 2 c\u00e1ch l\u00e0m n\u00e0y \u0111\u1ec3 b\u1ea1n tham kh\u1ea3o v\u00e0 l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng \u00e1n ph\u00f9 h\u1ee3p nh\u1ea5t.<\/p>\n

        S\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5<\/strong><\/h4>\n

        V\u00ed d\u1ee5:<\/strong> Cho b\u1ea3ng s\u1ea3n ph\u1ea9m \u0111i k\u00e8m t\u00ean h\u00e3ng v\u00e0 m\u1ee9c gi\u00e1. Y\u00eau c\u1ea7u t\u00ecm m\u1ee9c gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m theo h\u00e3ng.<\/p>\n

        \"c\u00e1ch<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 A2, nh\u1eadp c\u00f4ng th\u1ee9c =B2&C2 r\u1ed3i nh\u1ea5n Enter, ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb \u1edf A2 l\u00e0 t\u00ean s\u1ea3n ph\u1ea9m + h\u00e3ng.<\/p>\n

        \"H\u00e0m<\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c d\u00f2ng d\u01b0\u1edbi \u0111\u1ec3 c\u00f3 b\u1ea3ng c\u1ed9t ph\u1ee5 \u0111\u1ea7y \u0111\u1ee7.<\/p>\n

        \"S\u1eed<\/p>\n

        B\u01b0\u1edbc 3:<\/strong> \u0110\u1ec3 t\u00ecm m\u1ee9c gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m theo h\u00e3ng, ta s\u1ebd t\u1ea1o 1 b\u1ea3ng truy v\u1ea5n \u1edf ph\u00eda d\u01b0\u1edbi. T\u1ea1i \u0111\u00e2y, ta s\u1ebd nh\u1eadp T\u00ean s\u1ea3n ph\u1ea9m, H\u00e3ng, t\u1ea1i ph\u1ea7n M\u1ee9c gi\u00e1 s\u1ebd l\u00e0 n\u01a1i \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP.<\/p>\n

        \"H\u01b0\u1edbng<\/p>\n

        B\u01b0\u1edbc 4:<\/strong> T\u1ea1i \u00f4 M\u1ee9c gi\u00e1, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =VLOOKUP(C12&C13, A2:D10,4,0)<\/p>\n

        \"C\u00e1ch<\/p>\n

        B\u01b0\u1edbc 5:<\/strong> \u1ea4n Enter, ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y!<\/p>\n

        \"H\u00e0m<\/p>\n

        S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong><\/h4>\n

        N\u1ebfu s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i l\u00e0m c\u1ed9t ph\u1ee5 n\u1eefa. Thay v\u00e0o \u0111\u00f3, b\u1ea1n s\u1ebd nh\u1eadp tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 M\u1ee9c gi\u00e1 l\u00e0 =VLOOKUP(B12&B13,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,0)<\/strong>. \u1ea4n Enter b\u1ea1n s\u1ebd thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh d\u01b0\u1edbi!<\/p>\n

        \"S\u1eed<\/p>\n

        IV. C\u00e1ch s\u1eeda h\u00e0m VLOOKUP l\u1ed7i N\/A<\/strong><\/h2>\n

        Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #N\/A. V\u1eady nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i h\u00e0m VLOOKUP #N\/A nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng theo d\u00f5i ngay h\u01b0\u1edbng d\u1eabn chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!<\/p>\n

        C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i h\u00e0m VLOOKUP #N\/A trong Excel. V\u1edbi m\u1ed7i nguy\u00ean nh\u00e2n, ta s\u1ebd c\u00f3 c\u00e1ch s\u1eeda l\u1ed7i t\u01b0\u01a1ng \u1ee9ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i theo t\u1eebng nguy\u00ean nh\u00e2n hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n

        1. Kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u trong v\u00f9ng t\u00ecm ki\u1ebfm<\/strong><\/span><\/p>\n

        Khi nh\u1eadp h\u00e0m VLOOKUP v\u00e0o b\u1ea3ng t\u00ednh, b\u1ea1n th\u1ea5y xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A!. H\u00e3y ki\u1ec3m tra xem c\u00f3 ph\u1ea3i v\u00f9ng t\u00ecm ki\u1ebfm b\u1ea1n nh\u1eadp v\u00e0o kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng hay kh\u00f4ng. N\u1ebfu kh\u00f4ng c\u00f3 th\u00ec b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i cho \u0111\u00fang.<\/p>\n

        \"c\u00e1ch<\/p>\n

        V\u00ed d\u1ee5 minh h\u1ecda: D\u00f9ng h\u00e0m VLOOKUP t\u00ecm s\u1ea3n ph\u1ea9m Xo\u00e0i nh\u01b0ng b\u1ea3ng d\u1eef li\u1ec7u l\u1ea1i kh\u00f4ng c\u00f3 Xo\u00e0i n\u00ean xu\u1ea5t hi\u1ec7n l\u1ed7i #NA nh\u01b0 h\u00ecnh.<\/em><\/p>\n

        2. Copy c\u00f4ng th\u1ee9c h\u00e0m nh\u01b0ng kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng t\u00ecm ki\u1ebfm<\/strong><\/span><\/p>\n

        N\u1ebfu b\u1ea1n copy c\u00f4ng th\u1ee9c h\u00e0m VLOOKUP m\u00e0 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng t\u00ecm ki\u1ebfm Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ea5y c\u00f4ng th\u1ee9c t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean xu\u1ed1ng c\u00e1c \u00f4 ti\u1ebfp theo. V\u00f9ng t\u00ecm ki\u1ebfm c\u0169ng v\u00ec th\u1ebf m\u00e0 thay \u0111\u1ed5i theo. K\u1ebft qu\u1ea3 l\u00e0 h\u1ec7 th\u1ed1ng b\u00e1o l\u1ed7i #N\/A. C\u00e1ch kh\u1eafc ph\u1ee5c l\u00e0 ph\u1ea3i c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c.<\/p>\n

        Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n h\u00e0m Vlookup trong Excel<\/strong> \u0111i k\u00e8m v\u00ed d\u1ee5, ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n

        \u0110\u1eebng qu\u00ean like, follows v\u00e0 ch\u1ecdn Xem tr\u01b0\u1edbc page Bencomputer<\/strong><\/em> \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng th\u00f4ng tin m\u1edbi, th\u1ee7 thu\u1eadt h\u1eefu \u00edch v\u00e0 review ch\u1ea5t l\u01b0\u1ee3ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

        H\u00e0m Vlookup trong Excel l\u00e0 m\u1ed9t h\u00e0m \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng trong Excel gi\u00fap b\u1ea1n t\u00ecm v\u00e0 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng. Tuy nhi\u00ean th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup trong Excel, h\u00e3y c\u00f9ng […]<\/p>\n","protected":false},"author":39,"featured_media":4456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-4455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/4455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=4455"}],"version-history":[{"count":7,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/4455\/revisions"}],"predecessor-version":[{"id":44364,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/4455\/revisions\/44364"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/4456"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=4455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=4455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=4455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}