{"id":24330,"date":"2021-05-10T17:02:13","date_gmt":"2021-05-10T10:02:13","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24330"},"modified":"2021-08-11T15:35:09","modified_gmt":"2021-08-11T08:35:09","slug":"ham-if-ket-hop-vlookup","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-if-ket-hop-vlookup\/","title":{"rendered":"H\u00e0m If k\u1ebft h\u1ee3p Vlookup s\u1eed d\u1ee5ng th\u1ebf n\u00e0o? V\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"

H\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n. Trong \u0111\u00f3 h\u00e0m Vlookup s\u1eed d\u1ee5ng \u0111\u1ec3 tra c\u1ee9u k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 theo h\u00e0ng d\u1ecdc c\u00f2n h\u00e0m If l\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/strong>, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n

H\u00e0m If trong Excel<\/strong><\/h2>\n

H\u00e0m If trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c cho tr\u01b0\u1edbc trong chu\u1ed7i. N\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n, h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE, n\u1ebfu kh\u00f4ng h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m If Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=IF(logical_test, [value_if_true], [value_if_false])<\/strong><\/p><\/blockquote>\n

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

H\u00e0m Vlookup trong Excel<\/strong><\/h2>\n

H\u00e0m Vlookup trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb theo c\u1ed9t. C\u00fa ph\u00e1p h\u00e0m c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=Vlookup(lookup_value, table_array, col_index_num, [range_lookup]<\/strong><\/p><\/blockquote>\n

L\u01b0u \u00fd, h\u00e0m Vlookup tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm.<\/p>\n

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

C\u00fa ph\u00e1p h\u00e0m If k\u1ebft h\u1ee3p Vlookup\u00a0<\/strong><\/h2>\n

H\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong> tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 True \/ False, Yes \/ No, \u2026 .<\/p>\n

Tr\u01b0\u1eddng h\u1ee3p ph\u1ed5 bi\u1ebfn nh\u1ea5t s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/strong> l\u00e0 \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m Vlookup tr\u1ea3 v\u1ec1 v\u1edbi gi\u00e1 tr\u1ecb m\u1eabu v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 Yes \/ No ho\u1eb7c True \/ False.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=If(Vlookup(lookuo_value, table_array, col, index_num, [range_lookup])<\/strong><\/p><\/blockquote>\n

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

\u2013 Lookup value:<\/strong>\u00a0Gi\u00e1 tr\u1ecb n\u00e0y \u0111\u1ec1 c\u1eadp \u0111\u1ebfn gi\u00e1 tr\u1ecb \u00f4 ho\u1eb7c v\u0103n b\u1ea3n m\u00e0 ch\u00fang ta \u0111ang t\u00ecm ki\u1ebfm.<\/p>\n

\u2013 Table_ array:<\/strong>\u00a0x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.<\/p>\n

\u2013 Col_index_number:<\/strong>\u00a0s\u1ed1 c\u1ed9t m\u00e0 ch\u00fang ta mu\u1ed1n tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb.<\/p>\n

\u2013 Range_lookup:<\/strong>\u00a0tham s\u1ed1 n\u00e0y l\u00e0 True ho\u1eb7c False, nh\u1eadn k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c ho\u1eb7c d\u1eef li\u1ec7u t\u01b0\u01a1ng t\u1ef1.<\/p>\n

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

V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong><\/h2>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong>, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

V\u00ed d\u1ee5 1<\/strong><\/h3>\n

Gi\u1ea3 s\u1eed cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong c\u1ed9t A v\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c m\u1eb7t h\u00e0ng n\u00e0y \u1edf trong c\u1ed9t B, v\u00e0 b\u1ea1n \u0111ang c\u1ea7n ki\u1ec3m tra s\u1ed1 l\u01b0\u1ee3ng m\u1ed9t m\u1eb7t h\u00e0ng trong \u00f4 E1 \u0111\u1ec3 th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi d\u00f9ng r\u1eb1ng m\u1eb7t h\u00e0ng \u0111\u00f3 c\u00f2n hay \u0111\u00e3 b\u00e1n h\u1ebft.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Vlookup c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

=VLOOKUP(E1,$A$2:$B$10,2,FALSE)<\/strong><\/p>\n

Ti\u1ebfp theo s\u1eed d\u1ee5ng l\u1ec7nh If so s\u00e1nh k\u1ebft qu\u1ea3 h\u00e0m Vlookup tr\u1ea3 v\u1ec1 v\u1edbi 0 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u201cNo\u201d n\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y b\u1eb1ng 9 ho\u1eb7c \u201cYes\u201d n\u1ebfu kh\u00f4ng ph\u1ea3i:<\/p>\n

=IF(VLOOKUP(E1,$A$2:$B$10,2,FALSE)=0,\u201dNo\u201d,\u201dYes\u201d)<\/strong><\/p>\n

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

Thay v\u00ec s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 l\u00e0 Yes\/ No, ch\u00fang ta c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 TRUE \/ FALSE ho\u1eb7c Stock \/ Sold (c\u00f2n h\u00e0ng \/ h\u1ebft h\u00e0ng) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=IF(VLOOKUP(E1,$A$2:$B$10,2)=0,\u201dSold out\u201d,\u201dIn stock\u201d)<\/strong><\/p>\n

V\u00ed d\u1ee5 2<\/strong><\/h3>\n

Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 \u0111\u1ea7u ra h\u00e0m Vlookup v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 kh\u00e1c. Cho v\u00ed d\u1ee5 ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 so s\u00e1nh gi\u00e1 tr\u1ecb h\u00e0m Vlookup tr\u1ea3 v\u1ec1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb trong \u00f4 G2 kh\u00f4ng.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=IF(VLOOKUP(E1,$A$2:$B$10,2)>=G2,\u201dYes!\u201d,\u201dNo\u201d)<\/strong><\/p>\n

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

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup<\/strong><\/h2>\n
    \n
  1. \u0110\u1ec3 h\u00e0m Vlookup ho\u1ea1t \u0111\u1ed9ng, gi\u00e1 tr\u1ecb \u201clookup\u201d lu\u00f4n ph\u1ea3i n\u1eb1m trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c Vlookup.<\/li>\n
  2. Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong> \u0111\u1ec3 s\u1eeda c\u00e1c l\u1ed7i.<\/li>\n<\/ol>\n

    Tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 h\u00e0m If k\u1ebft h\u1ee3p Vlookup trong Excel<\/strong>, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel<\/a> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y nh\u00e9.<\/p>\n

    Xem th\u00eam:\u00a0<\/strong><\/span><\/p>\n