{"id":9676,"date":"2025-01-02T12:15:05","date_gmt":"2025-01-02T12:15:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-viet-ham-if-ket-hop-ham-vlookup\/"},"modified":"2025-01-02T12:15:05","modified_gmt":"2025-01-02T12:15:05","slug":"huong-dan-cach-viet-ham-if-ket-hop-ham-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-viet-ham-if-ket-hop-ham-vlookup\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m VLOOKUP"},"content":{"rendered":"
\n

H\u00e0m\u00a0IF v\u00e0 h\u00e0m VLOOKUP l\u00e0 hai h\u00e0m ph\u1ed5 bi\u1ebfn trong\u00a0Excel m\u00e0 h\u1ea7u nh\u01b0 ch\u00fang ta\u00a0\u0111\u1ec1u bi\u1ebft. V\u1eady b\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y trong c\u00f9ng 1 c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 kh\u00f4ng? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u c\u00e1ch\u00a0vi\u1ebft h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m VLOOKUP trong\u00a0Excel nh\u00e9:<\/p>\n

X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m khi \u0111\u01a1n gi\u00e1 c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i theo th\u00e1ng<\/h2>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

<\/p>\n

Trong b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y ch\u00fang ta th\u1ea5y th\u1eddi gian ph\u00e1t sinh g\u1ed3m 2 th\u00e1ng 4 v\u00e0 5.\u00a0V\u00e0 trong th\u00e1ng 4, c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 1\u00a0\u0111\u01a1n gi\u00e1. Sang th\u00e1ng 5\u00a0\u0111\u01a1n gi\u00e1\u00a0\u0111\u00f3 thay\u00a0\u0111\u1ed5i theo b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 5. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00fang\u00a0\u0111\u01a1n gi\u00e1 theo t\u1eebng th\u1eddi\u00a0\u0111i\u1ec3m ph\u00e1t sinh?<\/p>\n

C\u00e1ch l\u00e0m l\u00e0 ch\u00fang ta ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c th\u00e1ng c\u1ee7a t\u1eebng l\u1ea7n ph\u00e1t sinh, r\u1ed3i d\u1ef1a v\u00e0o\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 bi\u1ec7n lu\u1eadn xem l\u1ea7n ph\u00e1t sinh\u00a0\u0111\u00f3 l\u00e0 th\u00e1ng m\u1ea5y.<\/p>\n

B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh th\u00e1ng v\u1edbi h\u00e0m MONTH<\/strong><\/p>\n

H\u00e0m MONTH l\u00e0 h\u00e0m gi\u00fap x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 th\u00e1ng trong 1\u00a0\u00f4 ch\u1ee9a d\u1eef li\u1ec7u th\u1eddi gian.<\/p>\n

Khi x\u00e9t MONTH(A2) ta thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 b\u1eb1ng 4, MONTH(A5) cho k\u1ebft qu\u1ea3 b\u1eb1ng 5<\/p>\n

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

B\u01b0\u1edbc 2: Bi\u1ec7n lu\u1eadn b\u1eb1ng h\u00e0m\u00a0IF<\/strong><\/p>\n

K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m MONTH ch\u00ednh l\u00e0\u00a0c\u0103n c\u1ee9 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh b\u1ea3ng tham chi\u1ebfu\u00a0c\u1ee7a h\u00e0m VLOOKUP.\u00a0N\u1ebfu k\u1ebft qu\u1ea3 b\u1eb1ng 4 th\u00ec tham chi\u1ebfu trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 4, k\u1ebft qu\u1ea3 b\u1eb1ng 5 th\u00ec tham chi\u1ebfu trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 th\u00e1ng 5.<\/p>\n

V\u1eady n\u00ean ta c\u00f3 th\u1ec3 vi\u1ebft:<\/p>\n

D2=IF(MONTH(A2)=4,s\u1eed d\u1ee5ng vlookup tham chi\u1ebfu t\u1edbi b\u1ea3ng th\u00e1ng 4, s\u1eed d\u1ee5ng tham chi\u1ebfu t\u1edbi b\u1ea3ng th\u00e1ng 5)<\/p>\n

\u1ede\u00a0\u0111\u00e2y ch\u1ec9 c\u00f3 th\u00e1ng 4 ho\u1eb7c th\u00e1ng 5, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 bi\u1ec7n lu\u1eadn theo h\u01b0\u1edbng kh\u00f4ng ph\u1ea3i th\u00e1ng 4 th\u00ec l\u00e0 th\u00e1ng 5.<\/p>\n

B\u01b0\u1edbc 3: Tham chi\u1ebfu b\u1eb1ng h\u00e0m VLOOKUP<\/strong><\/p>\n

V\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng b\u1ea3ng th\u00e1ng 4\u00a0\u0111\u1ec3 tham chi\u1ebfu, ta c\u00f3 h\u00e0m vlookup nh\u01b0 sau:<\/p>\n

=VLOOKUP(B2,G3:H7,2,0)<\/p>\n

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