{"id":103415,"date":"2024-10-30T16:08:44","date_gmt":"2024-10-30T09:08:44","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=103415"},"modified":"2024-10-30T16:08:47","modified_gmt":"2024-10-30T09:08:47","slug":"ham-match-trong-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/ham-match-trong-excel\/","title":{"rendered":"H\u00e0m MATCH trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u1ea5t"},"content":{"rendered":"\n<p>Trong Excel, h\u00e0m MATCH \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t d\u1ea3i \u00f4. N\u1ebfu b\u1ea1n t\u1eebng c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n khi c\u1ea7n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t m\u1ee5c c\u1ee5 th\u1ec3 trong b\u1ea3ng d\u1eef li\u1ec7u, th\u00ec h\u00e0m MATCH ch\u00ednh l\u00e0 gi\u1ea3i ph\u00e1p h\u1eefu hi\u1ec7u cho b\u1ea1n. V\u1edbi t\u00ednh n\u0103ng linh ho\u1ea1t v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng, h\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng kh\u00e1m ph\u00e1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH, k\u00e8m theo nh\u1eefng v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u1ea5t \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. H\u00e3y c\u00f9ng b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong Excel n\u00e0y v\u1edbi <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News <\/a>nh\u00e9!<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ung-dung-vba-excel\/\">VBA Excel l\u00e0 g\u00ec? VBA c\u01a1 b\u1ea3n v\u00e0 \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/trong-excel-la-loi-gi-cach-sua-loi-nhanh\/\">#### trong Excel l\u00e0 l\u1ed7i g\u00ec? C\u00e1ch s\u1eeda l\u1ed7i nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-ve-cac-dang-bieu-do-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft<\/a><\/li>\n<\/ul>\n\n\n\n<h2><strong>H\u00e0m MATCH trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><\/h2>\n\n\n\n<p>H\u00e0m MATCH trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong m\u1ed9t ph\u1ea1m vi \u00f4. N\u00f3i c\u00e1ch kh\u00e1c, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3 trong danh s\u00e1ch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-1024x640.jpg\" alt=\"H\u00e0m MATCH t\u00ecm m\u1ed9t m\u1ee5c \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong ph\u1ea1m vi c\u1ee7a \u00f4, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ee5c \u0111\u00f3 trong ph\u1ea1m vi n\u00e0y\" class=\"wp-image-103417\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">H\u00e0m MATCH t\u00ecm m\u1ed9t m\u1ee5c \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong ph\u1ea1m vi c\u1ee7a \u00f4, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ee5c \u0111\u00f3 trong ph\u1ea1m vi n\u00e0y<\/figcaption><\/figure>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean s\u1ea3n ph\u1ea9m \u1edf c\u1ed9t A v\u00e0 mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a s\u1ea3n ph\u1ea9m &#8220;\u0110i\u1ec7n tho\u1ea1i&#8221;. H\u00e0m MATCH s\u1ebd gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c \u00f4 ch\u1ee9a t\u1eeb &#8220;\u0110i\u1ec7n tho\u1ea1i&#8221; \u0111\u00f3 n\u1eb1m \u1edf h\u00e0ng th\u1ee9 m\u1ea5y.<\/p>\n\n\n\n<h2><strong>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MATCH trong Excel<\/strong><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MATCH:<strong>=MATCH(lookup_value,lookup_array,[MATCH_type])<\/strong><\/p>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong>&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>lookup_value: <\/strong>Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><strong>lookup_array: <\/strong>Ph\u1ea1m vi \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb.<\/li>\n\n\n\n<li><strong>MATCH_type: <\/strong>Lo\u1ea1i t\u00ecm ki\u1ebfm (t\u00f9y ch\u1ecdn): (0 cho t\u00ecm ch\u00ednh x\u00e1c, 1 cho t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t g\u1ea7n nh\u1ea5t v\u00e0 -1 cho t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t g\u1ea7n nh\u1ea5t).<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>=MATCH(&#8220;John&#8221;, A1:A10, 0)<\/p>\n\n\n\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb &#8220;John&#8221; trong ph\u1ea1m vi t\u1eeb A1\u0111\u1ebfn A10 v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed ch\u00ednh x\u00e1c c\u1ee7a n\u00f3.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-1024x640.jpg\" alt=\"MATCH:=MATCH(lookup_value,lookup_array,[MATCH_type])\" class=\"wp-image-103418\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">MATCH:=MATCH(lookup_value,lookup_array,[MATCH_type])<\/figcaption><\/figure>\n\n\n\n<h2><strong>C\u00e1c lo\u1ea1i h\u00e0m MATCH th\u01b0\u1eddng g\u1eb7p trong Excel<\/strong><\/h2>\n\n\n\n<p>H\u00e0m MATCH c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ba lo\u1ea1i kh\u1edbp ph\u1ed5 bi\u1ebfn m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng trong Excel:<\/p>\n\n\n\n<h3><strong>Kh\u1edbp \u0111\u00fang<\/strong><\/h3>\n\n\n\n<p>H\u00e0m MATCH v\u1edbi t\u00f9y ch\u1ecdn <strong>match_type<\/strong> l\u00e0 <strong>0 <\/strong>s\u1ebd t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c trong d\u1ea3i \u00f4. \u0110\u00e2y l\u00e0 c\u00e1ch t\u00ecm ki\u1ebfm ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n mu\u1ed1n t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 v\u00e0 ch\u1ec9 quan t\u00e2m \u0111\u1ebfn v\u1ecb tr\u00ed ch\u00ednh x\u00e1c c\u1ee7a n\u00f3.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-1024x640.jpg\" alt=\"Kh\u1edbp \u0111\u00fang c\u00f3 t\u00f9y ch\u1ecdn match_type l\u00e0 0\" class=\"wp-image-103419\" width=\"1027\" height=\"642\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-3.jpg 1440w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" title=\"\"><figcaption class=\"wp-element-caption\">Kh\u1edbp \u0111\u00fang c\u00f3 t\u00f9y ch\u1ecdn match_type l\u00e0 0<\/figcaption><\/figure>\n\n\n\n<h3><strong>Kh\u1edbp g\u1ea7n \u0111\u00fang<\/strong><\/h3>\n\n\n\n<p>Khi b\u1ea1n s\u1eed d\u1ee5ng <strong>match_type<\/strong> l\u00e0 <strong>1<\/strong>, h\u00e0m MATCH s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t m\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng lookup_value (gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm). \u0110i\u1ec1u n\u00e0y h\u1eefu \u00edch trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp, ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea3ng \u0111i\u1ec3m ho\u1eb7c danh s\u00e1ch gi\u00e1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-1024x640.jpg\" alt=\"Kh\u1edbp g\u1ea7n \u0111\u00fang s\u1eed d\u1ee5ng match_type l\u00e0 1\" class=\"wp-image-103420\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Kh\u1edbp g\u1ea7n \u0111\u00fang s\u1eed d\u1ee5ng match_type l\u00e0 1<\/figcaption><\/figure>\n\n\n\n<h3><strong>Kh\u1edbp v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/strong><\/h3>\n\n\n\n<p>H\u00e0m MATCH c\u0169ng h\u1ed7 tr\u1ee3 vi\u1ec7c t\u00ecm ki\u1ebfm b\u1eb1ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 * (\u0111\u1ea1i di\u1ec7n cho nhi\u1ec1u k\u00fd t\u1ef1) ho\u1eb7c ? (\u0111\u1ea1i di\u1ec7n cho m\u1ed9t k\u00fd t\u1ef1). \u0110i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n t\u00ecm ki\u1ebfm linh ho\u1ea1t h\u01a1n trong c\u00e1c t\u00ecnh hu\u1ed1ng khi kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ho\u1eb7c t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1 nhau. Lo\u1ea1i h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n khi <strong>match_type<\/strong> \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh <strong>0<\/strong>.<\/p>\n\n\n\n<p><em>6<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-1024x640.jpg\" alt=\"Kh\u1edbp v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n khi match_type \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh 0\" class=\"wp-image-103421\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Kh\u1edbp v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n khi match_type \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh 0<\/figcaption><\/figure>\n\n\n\n<h2><strong>C\u00e1ch \u00e1p d\u1ee5ng h\u00e0m MATCH trong Excel<\/strong><\/h2>\n\n\n\n<p>MATCH l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel, gi\u00fap ch\u00fang ta t\u00ecm ki\u1ebfm nhanh ch\u00f3ng v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t d\u00e3y d\u1eef li\u1ec7u. \u0110\u1ec3 t\u0103ng t\u00ednh linh ho\u1ea1t, h\u00e0m cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<ul>\n<li><strong>D\u1ea5u h\u1ecfi ch\u1ea5m (?)<\/strong>: \u0110\u1ea1i di\u1ec7n cho b\u1ea5t k\u1ef3 m\u1ed9t k\u00fd t\u1ef1 n\u00e0o.<\/li>\n<\/ul>\n\n\n\n<p>V\u00ed d\u1ee5: ?ar s\u1ebd t\u00ecm th\u1ea5y c\u00e1c t\u1eeb nh\u01b0 &#8220;car&#8221;, &#8220;bar&#8221;, &#8220;far&#8221;.<\/p>\n\n\n\n<ul>\n<li><strong>D\u1ea5u sao (*)<\/strong>: \u0110\u1ea1i di\u1ec7n cho b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 n\u00e0o (bao g\u1ed3m c\u1ea3 chu\u1ed7i r\u1ed7ng).<\/li>\n<\/ul>\n\n\n\n<p>V\u00ed d\u1ee5: Car* s\u1ebd t\u00ecm th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c t\u1eeb b\u1eaft \u0111\u1ea7u b\u1eb1ng &#8220;Car&#8221; nh\u01b0 &#8220;Car&#8221;, &#8220;Carol&#8221;, &#8220;Caravan&#8221;.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean trong c\u1ed9t A v\u00e0 mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng &#8220;Car&#8221;.&nbsp;<\/p>\n\n\n\n<p>C\u00f4ng th\u1ee9c: <strong>=MATCH(A3&amp;&#8221;*&#8221;,A2:A6,0)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>A3: <\/strong>\u00d4 ch\u1ee9a gi\u00e1 tr\u1ecb &#8220;Car&#8221;.<\/li>\n\n\n\n<li><strong>&#8220;*&#8221;: <\/strong>K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a chu\u1ed7i.<\/li>\n\n\n\n<li><strong>A2:A6: <\/strong>Ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><strong>0: <\/strong>T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m MATCH trong Excel\" class=\"wp-image-103422\" width=\"1022\" height=\"639\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-6.jpg 1440w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m MATCH trong Excel<\/figcaption><\/figure>\n\n\n\n<p>C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2, t\u1ee9c l\u00e0 t\u00ean &#8220;Carol&#8221; n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 2 trong danh s\u00e1ch.<\/p>\n\n\n\n<p>N\u1ebfu s\u1eed d\u1ee5ng h\u00e0m v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (?) s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 1 &#8211; v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a t\u00ean \u201cPeter\u201d: =MATCH(&#8220;pe?er&#8221;,A2:A6,0)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m MATCH trong Excel\" class=\"wp-image-103423\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m MATCH trong Excel<\/figcaption><\/figure>\n\n\n\n<h2><strong>C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH d\u00f2 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h2>\n\n\n\n<p>Trong Excel:<\/p>\n\n\n\n<p><strong>H\u00e0m INDEX<\/strong>: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong m\u1ed9t m\u1ea3ng.<\/p>\n\n\n\n<ul>\n<li>C\u00f4ng th\u1ee9c: <strong>=INDEX(array;row_num;column_num)<\/strong><\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>array: <\/strong>v\u00f9ng \u00f4 ho\u1eb7c m\u1ed9t h\u00e0ng s\u1ed1 m\u1ea3ng n\u00e0o \u0111\u00f3;<\/li>\n\n\n\n<li><strong>row_num: <\/strong>ch\u1ecdn h\u00e0ng trong m\u1ea3ng t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb;<\/li>\n\n\n\n<li><strong>column: <\/strong>ch\u1ecdn c\u1ed9t trong m\u1ea3ng t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n\n\n\n<p>K\u1ebft h\u1ee3p hai h\u00e0m INDEX v\u00e0 MATCH cho ph\u00e9p b\u1ea1n t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed (\u0111i\u1ec1u ki\u1ec7n).<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5: T\u00ednh \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t<\/strong><\/p>\n\n\n\n<p><strong>B\u01b0\u1edbc 1: <\/strong>\u0110\u1ec3 t\u00ecm ch\u00ednh x\u00e1c h\u00e0ng ch\u1ee9a s\u1ea3n ph\u1ea9m \u0110\u0129a CD trong kho\u1ea3ng B15:B18 c\u1ee7a b\u1ea3ng 2, ta s\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n\n\n\n<p>&nbsp;<strong>=MATCH(B8$B$15:$B$18,0)<\/strong>. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2, ch\u1ec9 r\u00f5 h\u00e0ng th\u1ee9 2 trong b\u1ea3ng l\u00e0 n\u01a1i ch\u1ee9a th\u00f4ng tin c\u1ea7n t\u00ecm.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-1024x640.jpg\" alt=\"=MATCH(B8$B$15:$B$18,0)\" class=\"wp-image-103424\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">=MATCH(B8$B$15:$B$18,0)<\/figcaption><\/figure>\n\n\n\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Ti\u1ebfp t\u1ee5c, \u00e1p d\u1ee5ng h\u00e0m MATCH v\u1edbi c\u00f4ng th\u1ee9c:<br><strong>=MATCH(C4,$B$15:$E$15,0)<\/strong>, ta nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a h\u00e3ng s\u1ea3n xu\u1ea5t Samsung n\u1eb1m \u1edf c\u1ed9t th\u1ee9 2 trong kho\u1ea3ng B15:E15 c\u1ee7a b\u1ea3ng 2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-1024x640.jpg\" alt=\"=MATCH(C4,$B$15:$E$15,0)\" class=\"wp-image-103425\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">=MATCH(C4,$B$15:$E$15,0)<\/figcaption><\/figure>\n\n\n\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Ti\u1ebfp \u0111\u1ebfn, \u0111\u1ec3 t\u00ecm ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ea3n ph\u1ea9m \u0110\u1ea1i CD v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t Samsung trong b\u1ea3ng 2, ta s\u1eed d\u1ee5ng h\u00e0m INDEX k\u1ebft h\u1ee3p v\u1edbi hai h\u00e0m MATCH \u0111\u00e3 t\u00ednh \u1edf tr\u00ean. C\u00f4ng th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 l\u00e0:<\/p>\n\n\n\n<p><strong>=INDEX($B$15:$E$18,MATCH(B8,$B$15:$B$18,0),MATCH(C4,$B$15:$E$15,0))<\/strong><\/p>\n\n\n\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi h\u00e0ng 16 (h\u00e0ng \u0110\u0129a CD) v\u00e0 c\u1ed9t 2 (Samsung) trong b\u1ea3ng 2 l\u00e0 30.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-1024x640.jpg\" alt=\"T\u00ednh \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH\" class=\"wp-image-103426\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ednh \u0111\u01a1n gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 h\u00e3ng s\u1ea3n xu\u1ea5t b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH<\/figcaption><\/figure>\n\n\n\n<p><strong>T\u00f3m l\u1ea1i, m\u1ecdi ng\u01b0\u1eddi n\u00ean \u1ebft h\u1ee3p h\u00e0m INDEX v\u00e0 MATCH trong Excel khi:<\/strong><\/p>\n\n\n\n<ul>\n<li>Thay v\u00ec b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi c\u1ea5u tr\u00fac c\u1ed1 \u0111\u1ecbnh c\u1ee7a h\u00e0m VLOOKUP hay HLOOKUP, c\u1eb7p h\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n t\u1ef1 do t\u00ecm ki\u1ebfm th\u00f4ng tin theo nhi\u1ec1u ti\u00eau ch\u00ed kh\u00e1c nhau, c\u1ea3 theo chi\u1ec1u ngang v\u00e0 chi\u1ec1u d\u1ecdc.&nbsp;<\/li>\n\n\n\n<li>C\u1ee5 th\u1ec3, h\u00e0m MATCH s\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c v\u1ecb tr\u00ed c\u1ee7a d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n t\u00ecm trong b\u1ea3ng, d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u1eb7t ra. Sau \u0111\u00f3, h\u00e0m INDEX s\u1ebd s\u1eed d\u1ee5ng th\u00f4ng tin v\u1ecb tr\u00ed n\u00e0y \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. S\u1ef1 k\u1ebft h\u1ee3p n\u00e0y t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c t\u00ecm ki\u1ebfm v\u00f4 c\u00f9ng linh ho\u1ea1t, c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u1ecdi thay \u0111\u1ed5i trong c\u1ea5u tr\u00fac d\u1eef li\u1ec7u<\/li>\n<\/ul>\n\n\n\n<h2><strong>S\u1eed d\u1ee5ng h\u00e0m MATCH khi c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/strong><\/h2>\n\n\n\n<p>H\u00e0m MATCH trong Excel th\u01b0\u1eddng kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng khi so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c so s\u00e1nh ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p MATCH v\u1edbi h\u00e0m EXACT.<\/p>\n\n\n\n<p><strong>H\u00e0m EXACT<\/strong>: So s\u00e1nh hai chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu ch\u00fang ho\u00e0n to\u00e0n gi\u1ed1ng nhau (c\u1ea3 v\u1ec1 n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng), ng\u01b0\u1ee3c l\u1ea1i l\u00e0 FALSE.<\/p>\n\n\n\n<p><strong>C\u00e1ch th\u1ee9c:<\/strong><\/p>\n\n\n\n<ul>\n<li>S\u1eed d\u1ee5ng h\u00e0m EXACT \u0111\u1ec3 t\u1ea1o m\u1ed9t m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb TRUE\/FALSE t\u01b0\u01a1ng \u1ee9ng v\u1edbi vi\u1ec7c c\u00e1c gi\u00e1 tr\u1ecb trong v\u00f9ng t\u00ecm ki\u1ebfm c\u00f3 kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm hay kh\u00f4ng.<\/li>\n\n\n\n<li>Sau \u0111\u00f3, s\u1eed d\u1ee5ng h\u00e0m MATCH \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb TRUE \u0111\u1ea7u ti\u00ean trong m\u1ea3ng v\u1eeba t\u1ea1o.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c: =MATCH(TRUE; EXACT (v\u00f9ng t\u00ecm ki\u1ebfm;gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm);0)<\/strong><\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed c\u1ee7a t\u1eeb &#8220;B\u00e0n ph\u00edm&#8221; (vi\u1ebft hoa \u0111\u00fang) trong v\u00f9ng B4:B12, c\u00f4ng th\u1ee9c s\u1ebd l\u00e0: <strong>=MATCH(TRUE,EXACT(B4:B12,D3),0)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-1024x640.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi h\u00e0m EXACT khi c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng\" class=\"wp-image-103427\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-11.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng h\u00e0m MATCH v\u1edbi h\u00e0m EXACT khi c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/figcaption><\/figure>\n\n\n\n<h2><strong>V\u00ed d\u1ee5 chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH trong Excel<\/strong><\/h2>\n\n\n\n<p>Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MATCH trong Excel cho 3 tr\u01b0\u1eddng h\u1ee3p hay g\u1eb7p nh\u1ea5t:<\/p>\n\n\n\n<p><strong>1. Tr\u01b0\u1eddng h\u1ee3p 1: T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u1edbi ki\u1ec3u 1 ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng<\/strong><\/p>\n\n\n\n<p>Khi \u0111\u1eb7t lo\u1ea1i so kh\u1edbp l\u00e0 1, h\u00e0m MATCH s\u1ebd th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang trong m\u1ed9t d\u00e3y d\u1eef li\u1ec7u \u0111\u00e3 s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n. C\u1ee5 th\u1ec3, n\u00f3 s\u1ebd t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t m\u00e0 v\u1eabn nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c trong \u00f4 E3 l\u00e0: =MATCH(E2,B3:B11,1) v\u00e0 k\u1ebft qu\u1ea3 kh\u1edbp g\u1ea7n \u0111\u00fang l\u00e0 7.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-1024x640.jpg\" alt=\"T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u1edbi ki\u1ec3u 1\" class=\"wp-image-103428\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang v\u1edbi ki\u1ec3u 1<\/figcaption><\/figure>\n\n\n\n<p><strong>2. Tr\u01b0\u1eddng h\u1ee3p 2: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c v\u1edbi ki\u1ec3u 0<\/strong><\/p>\n\n\n\n<p>H\u00e0m MATCH th\u1ef1c hi\u1ec7n kh\u1edbp ch\u00ednh x\u00e1c khi lo\u1ea1i so kh\u1edbp \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh 0. Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c trong E3 l\u00e0: =MATCH(E2,B3:B10,0) v\u00e0 k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c l\u00e0 4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-1024x640.jpg\" alt=\"T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c v\u1edbi ki\u1ec3u 0\" class=\"wp-image-103429\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-13.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c v\u1edbi ki\u1ec3u 0<\/figcaption><\/figure>\n\n\n\n<p><strong>3. Tr\u01b0\u1eddng h\u1ee3p 3: T\u00ecm ki\u1ebfm nh\u1ecf h\u01a1n v\u1edbi ki\u1ec3u -1<\/strong><\/p>\n\n\n\n<p>H\u00e3y t\u00ecm s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a \u00f4 c\u00f3 s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m nh\u1ecf nh\u1ea5t l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb 35. L\u00fac n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c =MATCH(35,C2:C6,-1) v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-1024x640.jpg\" alt=\"T\u00ecm ki\u1ebfm nh\u1ecf h\u01a1n v\u1edbi ki\u1ec3u -1\" class=\"wp-image-103430\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/ham-match-14.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm ki\u1ebfm nh\u1ecf h\u01a1n v\u1edbi ki\u1ec3u -1<\/figcaption><\/figure>\n\n\n\n<h2><strong>T\u1ed5ng k\u1ebft<\/strong><\/h2>\n\n\n\n<p>V\u1edbi h\u00e0m MATCH, vi\u1ec7c t\u00ecm ki\u1ebfm v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft. H\u00e3y xem \u0111\u00e2y l\u00e0 b\u01b0\u1edbc kh\u1edfi \u0111\u1ea7u \u0111\u1ec3 b\u1ea1n kh\u00e1m ph\u00e1 s\u00e2u h\u01a1n v\u1ec1 nh\u1eefng kh\u1ea3 n\u0103ng tuy\u1ec7t v\u1eddi m\u00e0 Excel mang l\u1ea1i. \u0110\u1eebng ng\u1ea7n ng\u1ea1i chia s\u1ebb nh\u1eefng kinh nghi\u1ec7m c\u1ee7a b\u1ea1n v\u1edbi c\u1ed9ng \u0111\u1ed3ng Phong V\u0169 Tech News nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong Excel, h\u00e0m MATCH \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t d\u1ea3i \u00f4. N\u1ebfu b\u1ea1n t\u1eebng c\u1ea3m th\u1ea5y kh\u00f3 kh\u0103n khi c\u1ea7n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t m\u1ee5c c\u1ee5 th\u1ec3 trong b\u1ea3ng d\u1eef li\u1ec7u, th\u00ec h\u00e0m MATCH ch\u00ednh l\u00e0 gi\u1ea3i ph\u00e1p h\u1eefu hi\u1ec7u [&hellip;]<\/p>\n","protected":false},"author":34,"featured_media":103432,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103415"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=103415"}],"version-history":[{"count":1,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103415\/revisions"}],"predecessor-version":[{"id":103431,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/103415\/revisions\/103431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/103432"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=103415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=103415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=103415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}