{"id":699,"date":"2022-11-11T16:18:35","date_gmt":"2022-11-11T07:18:35","guid":{"rendered":"https:\/\/chaerang.net\/?p=699"},"modified":"2022-11-11T16:19:19","modified_gmt":"2022-11-11T07:19:19","slug":"excel-%ec%88%98%ec%8b%9d-vlookup-match-index-%eb%8b%a4%ec%a4%91%ec%a1%b0%ea%b1%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=699","title":{"rendered":"Excel – \uc218\uc2dd : Vlookup, Match, Index, \ub2e4\uc911\uc870\uac74 \ub370\uc774\ud130 \ucc3e\uae30"},"content":{"rendered":"\n

\uc548\ub155\ud558\uc138\uc694 \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \uc2dc\uac04\uc744 \uc7a0\uc2dc \ub0b4\uc11c \uae00 \uc4f0\ub7ec \uc654\uc2b5\ub2c8\ub2e4 ^^. \uacc4\uc18d\ud574\uc11c \uc5d1\uc140 \uad00\ub828 \uae00\uc744 \uc4f0\uac8c \ub418\ub124\uc694 ^^. \uac04\ub2e8\ud558\uac8c \uae00\uc4f0\uae30\uc5d4 \uc5d1\uc140\uc774 \ucc38 \uc88b\uc544\uc694.
\uc624\ub298\ub3c4 \ub370\uc774\ud130 \uac80\uc0c9\uc5d0 \ub300\ud55c \ud301\uc744 \ud558\ub098 \ub354 \ub4dc\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

Vlookup \uba85\ub839\uc5b4\ub97c \uc4f0\ub2e4\ubcf4\uba74, \uac00\ub054 \uc5ec\ub7ec\uac00\uc9c0 \uc870\uac74\uc744 \ub123\uc740 \uac80\uc0c9\uc744 \ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\uc5ec\ub7ec\uac00\uc9c0 \uc870\uac74\uc744 \ub123\uc740 \ud569\uacc4\ub098 \ud3c9\uade0\uc758 \uacbd\uc6b0 DSUM\uc774\ub098, DAVERAGE \uba85\ub839\uc73c\ub97c \uc4f0\uba74 \ub418\uc9c0\ub9cc, \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc11c \uac00\uc838\uc624\ub294 \uac83\uc740 \ubcc4\ub3c4\uc758 \uc598\uae30\uc8e0.
\uadf8\ub798\uc11c \ub2e4\uc911 \uc870\uac74 \uac80\uc0c9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \uc0d8\ud50c \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \uc124\uba85 \ub4dc\ub9b4\uaed8\uc694.
\ub370\uc774\ud130\ub294 \ub79c\ub364\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4.
\uac00\uaca9\ucc28\uac00 \uc2ec\ud558\ub2e4\uad6c\uc694? \ub124 \ub79c\ub364\uc73c\ub85c \uadf8\ub0e5 3\ub9cc\uc6d0 \ubbf8\ub9cc\uc758 \ub2e8\uac00\ub97c \uc9d1\uc5b4 \ub123\uc5c8\uc2b5\ub2c8\ub2e4. ^^
\uc544 \ub79c\ub364 \ub370\uc774\ud130 \uc0dd\uc131\ud558\ub294 \uac83\ub3c4 \ub098\uc911\uc5d0 \ud55c\ubc88 \ub2e4\ub904\ubd10\uc57c\uaca0\ub124\uc694 ^^<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

\uc790 \uc774\ubc88\uc5d0\ub294 \ubb38\uc81c\ub97c \ub0b4\uc57c \ub418\uaca0\uc8e0? \uac00\uc7a5 \ub9ce\uc740 \ubd80\ud488\uba85\uc774 \uc74c…. HHHH \uc778\uac83 \uac19\ub124\uc694. \uadf8\ub7fc HHHH \ubd80\ud488 \uc911 2022\ub144 11\uc6d4 11\uc77c\uc5d0 \ub4e4\uc5b4\uc628 \uc790\uc7ac\uc758 \ub2e8\uac00\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2\uac00\uc9c0 \uc870\uac74\uc774 \ub4e4\uc5b4\uac04 \ubb38\uc81c\ub85c \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 Vlookup\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucc3e\uc73c\ub824\uace0 \ud55c\ub2e4\uba74, \ubcf4\uc774\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \ubc14\ub85c \uc218\ud589\uc740 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.
\ub124 \ud558\ub098\uc758 \uc5f4\uc744 \ucd94\uac00\ud558\uc5ec \uac80\uc0c9\uc744 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4.
Vlookup \uba85\ub839\uc5b4\uc758 \uae30\ubcf8\uc740 \ucc3e\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \uc5f4\uc774 \ub9e8 \uc55e\uc5d0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\uc989, \ub2e8\uac00\uc758 \ub370\uc774\ud130\ub97c \ucc3e\uc73c\uc2dc\ub824\uba74 A\uc5f4\uc758 \uc55e\uacfc \ub4a4\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc5f4\uc744 \ucd94\uac00\ud558\uc168\uc73c\uba74, \uc9c8\uc758 \uc5d0 \ub300\ud55c \uc11c\uce58 \ub370\uc774\ud130\ub97c \ub9cc\ub4dc\uc154\uc57c \uaca0\uc8e0?
\uc800\ub294 A\uc5f4 \ub4a4\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud558\uace0, B\uc5f4\uc5d0 \ub2e4\uc74c\uc758 \uc218\uc2dd\uc744 \ubc18\uc601\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=A2 & F2<\/p>\n\n\n\n

\uadf8\ub9ac\uace0 \ubcf5\uc0ac\ud574\uc11c \ub2e4 \ucc44\uc6e0\uc5b4\uc694
\uadf8\ub9ac\uace0 \uc544\ub798\uc640 \uac19\uc774 Vlookup \uba85\ub839\uc5b4\ub85c \ub370\uc774\ud130\ub97c \ucc3e\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=VLOOKUP(L4&L5,B2:C23,2,FALSE)<\/p>\n\n\n\n

\uacb0\uacfc \ud654\uba74\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

\uacb0\uacfc\ub294 \ubcf4\uc2dc\ub2e4 \uc2dc\ud53c \uc798 \ub098\uc654\uc2b5\ub2c8\ub2e4.
\ub2e4\ub9cc, B\uc5f4\uc5d0 \uc2e0\uaddc \uc5f4\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud558\uac8c \ub370\uc774\ud130\ub9cc \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc774\ub807\uac8c \uc791\uc5c5\ud574\ub3c4 \uc544\ubb34\ub7f0 \ubb38\uc81c\uac00 \uc5c6\uaca0\uc9c0\ub9cc, \uc5ec\ub7ec\uc0ac\ub78c\uc774 \ubd10\uc57c\ud558\ub294 \ub370\uc774\ud130\ub098 \uc5f4\uc744 \ucd94\uac00\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc5d0\uc11c\ub77c\uba74 \uc774\ub807\uac8c \uc791\uc5c5\ud560 \uc218 \uc5c6\uac8c \ub429\ub2c8\ub2e4.
\uc774\ub7f4\ub54c \uc0ac\uc6a9\ud558\ub294 \uc218\uc2dd\uc774 Match\uc640 Index\uc744 \ubcf5\ud569\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

Index \uc218\uc2dd\uc740 \ubc30\uc5f4\uc5d0\uc11c \uc6d0\ud558\ub294 \uc88c\ud45c\ub97c \ubc18\uc601\ud558\uc5ec \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uc218\uc2dd\uc785\ub2c8\ub2e4.
\uc218\uc2dd\uc758 \uc0ac\uc6a9\ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=INDEX(array, row_num, [column_num])<\/p>\n\n\n\n

\uc5ec\ub7ec\ubc88 \uc124\uba85 \ub4dc\ub838\uc9c0\ub9cc, array\ub294 \uc6d0\ud558\ub294 \ubc94\uc704\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 row_num\uc740 \ud589\uc758 \ubc88\ud638\uc774\uba70, column_num\uc740 \uc5f4\uc758 \ubc88\ud638\uc785\ub2c8\ub2e4.
\uc989, \uc6d0\ud558\ub294 \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud589 \ubc88\ud638, \uc5f4 \ubc88\ud638\uc5d0 \ud574\ub2f9\ub418\ub294 \ub370\uc774\ud130\ub97c \ucd9c\ub825\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.
\uc704\uc5d0 \ud45c\uc5d0\uc11c \uc608\ub97c \ub4e4\uc5b4 \ub4dc\ub9b4\uaed8\uc694.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

=INDEX(A2:G23,3,1)<\/p>\n\n\n\n

\ubc94\uc704 A2:23\uc5d0\uc11c 3\ubc88\uc9f8 \ud589\uc758 \uccab\ubc88\uc9f8 \uc5f4\uc740 JJJJ\uac12\uc774 \ub429\ub2c8\ub2e4. \uc218\ud559\uc801\uc778 \ud45c\ub97c \ubcf4\ub294 \uac83\uacfc \ub3d9\uc77c\ud55c \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\ubc88\uc5d0\ub294 Match \uc218\uc2dd\uc5d0 \ub300\ud574 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. Match\ub294 \uc694\uccad\ud558\ub294 \ub370\uc774\ud130\uac00 \uba87\ubc88\uc9f8\uc5d0 \uc788\ub294\uc9c0 \ucc3e\uc544\ub0b4\ub294 \uc218\uc2dd\uc785\ub2c8\ub2e4.
\uc218\uc2dd\uc758 \uc0ac\uc6a9\ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=MATCH(lookup_value, lookup_array, [match type])<\/p>\n\n\n\n

\uccab\ubc88\uc7ac\ub294 lookup_value\uc785\ub2c8\ub2e4. \ucc3e\ub294 \uac12\uc774\uc8e0. \ub450\ubc88\uc9f8\ub294 lookup_array\uc785\ub2c8\ub2e4. \ucc3e\ub294 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ubc94\uc704 \uc785\ub2c8\ub2e4. \ub2e8, \uc774 \ubc94\uc704\ub294 \ud589\uc774\uba74 1\uac1c\uc758 \ud589\uc5d0\uc11c \uc9c4\ud589\ub418\uc5b4\uc57c \ud558\uba70, \uc5f4\ub85c \ucc3e\uc744 \uac83\uc774\uba74 1\uac1c\uc758 \uc5f4\uc5d0\uc11c \uc9c4\ud589\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc5ec\ub7ec\uac1c\uc758 \uc5f4\uacfc \ud589\uc744 \ub3d9\uc2dc\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c match type\uc778\ub370\uc694, \uc774\uac83\uc740 \uc22b\uc790\ub97c \uac80\uc0c9\ud560 \ub54c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. match type\ub294 0, -1, 1\uc774\uba70, 0\uc740 \uc77c\uce58\ud558\ub294 \uac12, -1\uc740 \uc791\uc740 \uac12, 1\uc740 \ud070 \uac12\uc744 \ucc3e\ub294 \uc5ed\ud65c\uc744 \ud569\ub2c8\ub2e4.
\ubb38\uc790\ub97c \ucc3e\uc744 \uacbd\uc6b0\uc5d0\ub294 \ubc18\ub4dc\uc2dc 0\uc73c\ub85c \uac80\uc0c9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\uac83\ub3c4 \uc608\ub97c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

=MATCH(“BBBB”,A2:A23,0)<\/p>\n\n\n\n

\uc790 A2\uc5d0\uc11c A23 \ubc94\uc704 \uc548\uc5d0\uc11c “BBBB”\ub77c\ub294 \ubd80\ud488\uc774 \uba87\ubc88\uc9f8 \uc788\ub0d0\ub294 \uc9c8\ubb38\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c\ubd80\ud130 4\ubc88\uc7ac\uc5d0 \uc788\uc8e0. \uc774\uac83\ub3c4 Vlookup\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc704\uc5d0\uc11c\ubd80\ud130 \uac80\uc0c9\ud558\ubbc0\ub85c, \uc5ec\ub7ec\uac1c\uac00 \uc788\uc744 \uacbd\uc6b0 \ub9e8 \uc704\uc758 \uc704\uce58 \uac12\uc744 \ub9ac\ud134\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc5ec\uae30\uae4c\uc9c0 \ub4e3\uace0 \ub098\uc11c Match\uc640 Index\ub97c \uc5b4\ub5bb\uac8c \uc368\uc57c\ud560\uc9c0 \uac10\uc774 \uc7a1\ud788\uc2dc\ub294 \ubd84\ub4e4\ub3c4 \uacc4\uc2e4 \uac81\ub2c8\ub2e4. \uc77c\ub2e8\uc740 \ub2e4\uc911 \uc870\uac74 \uac80\uc0c9 \uc774\uc804\uc5d0 Vlookup \uba85\ub839\uc5b4\uc640 \ub3d9\uc77c\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 \ud654\uba74\uc744 \uba3c\uc800 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.
\uac04\ub2e8\ud558\uac8c \uc9c8\ubb38 \ub0b4\uc6a9\uc740 CCCC \ubd80\ud488\uc758 \ub2e8\uac00\ub85c \ucc3e\uc544 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

\uc790 \uacb0\ub860\ubd80\ud130 \ub9d0\uc500\ub4dc\ub9ac\uba74, \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 \ucd9c\ub825\ub41c \uac83\uc774 \ubcf4\uc774\uc2dc\uc8e0? \ub9de\uc2b5\ub2c8\ub2e4. Vlookup \uba85\ub839\uc5b4\ub294 \uc774\ub807\uac8c Match\uc640 \uc778\ub371\uc2a4 \uba85\ub839\uc5b4\ub97c \uc11e\uc5b4\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 \uc218\uc2dd\uc785\ub2c8\ub2e4.
\uadf8\ub798\uc11c \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ub098\uc624\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

Vlookup \uba85\ub839\uc5b4\ub294 \ub2e4\uc2dc \uc124\uba85 \ub4dc\ub9ac\uc9c0 \uc54a\uaca0\uc2b5\ub2c8\ub2e4.
Match\uc640 Index\ub97c \uc0ac\uc6a9\ud55c \uc218\uc2dd\uc744 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.
\uba3c\uc800 Index \uba85\ub839\uc5b4\ub97c \ubd84\uc11d\ud558\uba74 \ubc11\uc5d0\ucc98\ub7fc A1:G23 \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud589\ubc88\ud638 \uc5f4\ubc88\ud638\ub97c \uc785\ub825\ud558\ub3c4\ub85d \ud558\ub294 \uac83\uc785\ub2c8\ub2e4.
INDEX(A1:G23,\ud589\ubc88\ud638,\uc5f4\ubc88\ud638)<\/p>\n\n\n\n

\ud589\ubc88\ud638\ub294 MATCH(K4,A1:A23,0)\uc785\ub2c8\ub2e4. \uc989 \ucc3e\ub294 \ub370\uc774\ud130\ub294 K4 \uc989 “CCCC”\ub77c\ub294 \ubd80\ud488\uba85\uc774\uc8e0, \ubc94\uc704\ub294 A\uc5f4\uc774\uad6c\uc694. match type\ub294 \ub2f9\uc5f0\ud788 \uc77c\uce58(0)\uc785\ub2c8\ub2e4. \uadf8\ub7ec\uba74 CCCC\uac00 \uc788\ub294 7\uc774\ub77c\ub294 \uac12\uc774 \ub9ac\ud134\ub418\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub9c8\uc9c0\ub9c9 \uc5f4 \ubc88\ud638\ub294 \ub2e8\uac00\uac00 \uc788\ub294 2\uc5f4\uc744 \uc9c1\uc811 \uc785\ub825\ud558\uc154\ub3c4 \ub418\uace0, MATCH(“\ub2e8\uac00”,A1:G1,0)\uc73c\ub85c \ucc3e\uc73c\uc154\ub3c4 \ub429\ub2c8\ub2e4. 1\ubc88\ud589\uc5d0\uc11c “\ub2e8\uac00”\uc640 \uc77c\uce58\ud558\ub294 \uc5f4 \uc704\uce58\ub97c \ucc3e\uc73c\ub2c8, \ub2f9\uc5f0\ud788 2\ub77c\ub294 \uac12\uc774 \ub9ac\ud134\ub418\uaca0\uc8e0.<\/p>\n\n\n\n

\uadf8\ub798\uc11c \uc778\ub371\uc2a4\uc5d0\uc11c 11,2\uc758 \ub370\uc774\ud130\uc778 24,200\uc758 \uac12\uc774 \ucd9c\ub825\ub418\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uc774\uc81c Match, Index \uba85\ub839\uc5b4\uc5d0 \ub300\ud574\uc11c \uac10\uc744 \uc7a1\uc73c\uc168\uc9c0\uc694?
\uadf8\ub7fc \uc774\ubc88 \uae00\uc758 \uc8fc\uc694 \ud575\uc2ec\uc778 \ub2e4\uc911\uc870\uac74 \uac80\uc0c9\uc744 \uc9c4\ud589\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

\uc218\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=INDEX(array, MATCH(lookup_value1&lookup_value2,lookup_array1&lookup_array2,0),column_num)
=INDEX(\ub370\uc774\ud130 \ubc94\uc704, MATCH(\uc870\uac741&\uc870\uac742, \uc870\uac741\uc758\ubc94\uc704&\uc870\uac742\uc758\ubc94\uc704,0),\uc5f4\ubc88\ud638)<\/p>\n\n\n\n

\uc6d0\ub798\ub294 \uc5d1\uc140\uc5d0\uc11c \uc8fc\ub294 \uc870\uac74\uc744 \uc785\ub825\ud558\ub294\ub370 \uc774\ud574\ud558\uae30 \ud798\ub4dc\uc2e4\uae4c\ubd10 \ud55c\uae00\ub85c\ub3c4 \ub0b4\uc6a9\uc744 \uc368 \ub4dc\ub838\uc2b5\ub2c8\ub2e4.
\uc6b0\uc120 Index \uba85\ub839\uc5b4 \uc0ac\uc6a9\uc740 \uc704\uc758 1\uac00\uc9c0 \uc870\uac74\uc73c\ub85c \uac80\uc0c9\ud558\ub358 \uac83\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub300\uc0b0 Match\uba85\ub839\uc5b4\ub294 \uc870\uae08 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc6b0\uc120 \ucc3e\ub294 \ub370\uc774\ud130\uac00 \uc870\uac741 & \uc870\uac742\ub85c \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \uc870\uac74\ub4e4 \uc0ac\uc774\uc5d0 &\uac00 \ub4e4\uc5b4\uac00\ub294 \uac81\ub2c8\ub2e4.
\ub610\ud55c \ucc3e\ub294 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ubc94\uc704 \ub610\ud55c \ubc94\uc7041 & \ubc94\uc7042\ub85c \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \ub2f9\uc5f0\ud788 \uc21c\uc11c\ub294 \ubc14\ub00c\uba74 \uc548\ub418\uaca0\uc2b5\ub2c8\ub2e4. \uadf8\uc678\uc5d0 match type\uc740 \ub3d9\uc77c\ud558\uac8c 0(\uc77c\uce58)\uc73c\ub85c \uc801\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.
\uc5ec\uae30\uc11c \uc544\uc154\uc57c \ud560 \uc810\uc740 2\uac00\uc9c0 \uc870\uac74\uc774 \uc544\ub2c8\ub77c \uc870\uac74\uc774 \ucd94\uac00\ub418\ub294 \uacbd\uc6b0\uc5d0\ub3c4 \uc704\uc640 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \uc870\uac741&\uc870\uac742&\uc870\uac743&……\uc73c\ub85c \ud558\uace0, \ubc94\uc7041&\ubc94\uc7042&\ubc94\uc7043&….\uc73c\ub85c \ud558\uc154\ub3c4 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4\ub294 \uac81\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\ub807\uac8c \uc0ac\uc6a9\ud558\uba74 \uc5f4\uc744 \ucd94\uac00\ud558\uc9c0 \uc54a\uace0\ub3c4 \ub2e4\uc911 \uc870\uac74\uc758 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, \uc774 \uacbd\uc6b0\ub294 \ucd5c\uc2e0 \uc5d1\uc140\uc5d0\uc11c \uc801\uc6a9\ub418\ub294 \uc218\uc2dd\uc774\ub77c\ub294 \uc810\uc785\ub2c8\ub2e4. \uc800\uc758 \uacbd\uc6b0 Office 2022\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc5b4 \ub370\uc774\ud130\uac00 \uc798 \ub098\uc624\ub294 \uac83\uc785\ub2c8\ub2e4.
\uadf8\ub807\ub2e4\uace0 \uc774\uc804 \ubc84\uc83c\uc5d0\uc11c\ub294 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub290\ub0d0 \ud558\uba74 \uadf8\ub807\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, \uc2dd\uc744 \uc785\ub825\ud558\uace0 ctrl+shift+enter\ub97c \ub20c\ub7ec\uc57c\ub9cc \uc801\uc6a9\ub41c\ub2e4\ub294 \uc810\ub9cc \ub2e4\ub985\ub2c8\ub2e4.<\/p>\n\n\n\n

ctrl+shift+enter\uc744 \ub204\ub974\uba74 \uc218\uc2dd\uc758 \uc591 \uc606\uc5d0 “{ }”\uac00 \ucd94\uac00\ub41c \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

\uc608\uc804\uc5d0\ub294 \uc800\ub807\uac8c \ud558\uc9c0\uc54a\uc73c\uba74 \ub370\uc774\ud130\uac00 \ucd9c\ub825\ub418\uc9c0 \uc54a\uc558\uc73c\ub098, \ucd5c\uc2e0\ubc84\uc83c\uc5d0\uc11c\ub294 \uc77c\ubc18 \uc218\uc2dd\ucc98\ub7fc \uc785\ub825\ud574\ub3c4 \ub3d9\uc791\uc744 \ud558\ub3c4\ub85d \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4.
\ucc38\uace0\ub85c \ub9d0\uc500\ub4dc\ub9ac\uba74, ctrl+shift+enter\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ud30c\uc77c\uc758 \uc6a9\ub7c9\uc774 \ucee4\uc9c0\uba70, \uc5ec\ub7ec\uac1c\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c8 \uc218 \uc788\ub2e4\ub294 \uc810 \uc720\uc758\ud558\uc5ec \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\uc544 \ubb3c\ub860 \ucd5c\uc2e0 \ubc84\uc83c\uc758 \uacbd\uc6b0 \ub2e4\uc911\uc870\uac74 \uc218\uc2dd\uc774 \ud3ec\ud568\ub418\ub294 \uac83\ub9cc\uc73c\ub85c\ub3c4 \uc6a9\ub7c9\uc774 \ucee4\uc9d1\ub2c8\ub2e4. \u314e\u314e\u314e.<\/p>\n\n\n\n

\uc790 \uc774\ub807\uac8c \uc624\ub298\uc740 \ub2e4\uc911\uc870\uac74\uc758 \ub370\uc774\ud130 \uac80\uc0c9\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc88b\uc740 \ud301\uc774 \ub418\uc5c8\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \uc88b\uc740 \ud558\ub8e8 \ub418\uc138\uc694 ^^<\/p>\n\n\n

Excel<\/a>, <\/span>index<\/a>, <\/span>match<\/a>, <\/span>match index<\/a>, <\/span>Vlookup<\/a>, <\/span>\ub2e4\uc911\uc870\uac74<\/a>, <\/span>\ub2e4\uc911\uc870\uac74 \ub370\uc774\ud130<\/a>, <\/span>\ub2e4\uc911\uc870\uac74 \ub370\uc774\ud130 \ucc3e\uae30<\/a>, <\/span>\ub370\uc774\ud130 \ucc3e\uae30<\/a>, <\/span>\uc218\uc2dd<\/a>, <\/span>\uc5d1\uc140<\/a><\/div>","protected":false},"excerpt":{"rendered":"

\uc548\ub155\ud558\uc138\uc694 \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4. \uc624\ub298\ub3c4 \uc2dc\uac04\uc744 \uc7a0\uc2dc \ub0b4\uc11c \uae00 \uc4f0\ub7ec \uc654\uc2b5\ub2c8\ub2e4 ^^. \uacc4\uc18d\ud574\uc11c \uc5d1\uc140 \uad00\ub828 \uae00\uc744 \uc4f0\uac8c \ub418\ub124\uc694 ^^. \uac04\ub2e8\ud558\uac8c \uae00\uc4f0\uae30\uc5d4 \uc5d1\uc140\uc774 \ucc38 \uc88b\uc544\uc694.\uc624\ub298\ub3c4 \ub370\uc774\ud130 \uac80\uc0c9\uc5d0 \ub300\ud55c \ud301\uc744 \ud558\ub098 \ub354 \ub4dc\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4. Vlookup \uba85\ub839\uc5b4\ub97c \uc4f0\ub2e4\ubcf4\uba74, \uac00\ub054 \uc5ec\ub7ec\uac00\uc9c0 \uc870\uac74\uc744 \ub123\uc740 \uac80\uc0c9\uc744 \ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.\uc5ec\ub7ec\uac00\uc9c0 \uc870\uac74\uc744 \ub123\uc740 \ud569\uacc4\ub098 \ud3c9\uade0\uc758 \uacbd\uc6b0 DSUM\uc774\ub098, DAVERAGE \uba85\ub839\uc73c\ub97c \uc4f0\uba74 \ub418\uc9c0\ub9cc, \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc11c \uac00\uc838\uc624\ub294 \uac83\uc740 \ubcc4\ub3c4\uc758 \uc598\uae30\uc8e0.\uadf8\ub798\uc11c \ub2e4\uc911 \uc870\uac74 \uac80\uc0c9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc624\ub298\ub3c4 \uc0d8\ud50c \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \uc124\uba85 \ub4dc\ub9b4\uaed8\uc694.\ub370\uc774\ud130\ub294 \ub79c\ub364\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uaca9\ucc28\uac00 \uc2ec\ud558\ub2e4\uad6c\uc694? \ub124 \ub79c\ub364\uc73c\ub85c \uadf8\ub0e5 3\ub9cc\uc6d0 \ubbf8\ub9cc\uc758 \ub2e8\uac00\ub97c \uc9d1\uc5b4 \ub123\uc5c8\uc2b5\ub2c8\ub2e4. ^^\uc544 \ub79c\ub364 \ub370\uc774\ud130 \uc0dd\uc131\ud558\ub294 \uac83\ub3c4 \ub098\uc911\uc5d0 \ud55c\ubc88 \ub2e4\ub904\ubd10\uc57c\uaca0\ub124\uc694 ^^ \uc790 \uc774\ubc88\uc5d0\ub294 \ubb38\uc81c\ub97c \ub0b4\uc57c \ub418\uaca0\uc8e0? \uac00\uc7a5 \ub9ce\uc740 \ubd80\ud488\uba85\uc774 \uc74c…. HHHH \uc778\uac83 \uac19\ub124\uc694. \uadf8\ub7fc HHHH \ubd80\ud488 \uc911 2022\ub144 11\uc6d4 11\uc77c\uc5d0 \ub4e4\uc5b4\uc628 \uc790\uc7ac\uc758 \ub2e8\uac00\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2\uac00\uc9c0 \uc870\uac74\uc774 \ub4e4\uc5b4\uac04 \ubb38\uc81c\ub85c \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc790 Vlookup\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucc3e\uc73c\ub824\uace0 \ud55c\ub2e4\uba74, \ubcf4\uc774\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \ubc14\ub85c \uc218\ud589\uc740 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.\ub124 \ud558\ub098\uc758 \uc5f4\uc744 \ucd94\uac00\ud558\uc5ec \uac80\uc0c9\uc744 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4. Vlookup \uba85\ub839\uc5b4\uc758 \uae30\ubcf8\uc740 \ucc3e\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \uc5f4\uc774 \ub9e8 \uc55e\uc5d0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.\uc989, \ub2e8\uac00\uc758 \ub370\uc774\ud130\ub97c \ucc3e\uc73c\uc2dc\ub824\uba74 A\uc5f4\uc758 \uc55e\uacfc \ub4a4\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4. \uc5f4\uc744 \ucd94\uac00\ud558\uc168\uc73c\uba74, \uc9c8\uc758 \uc5d0 \ub300\ud55c \uc11c\uce58 \ub370\uc774\ud130\ub97c \ub9cc\ub4dc\uc154\uc57c \uaca0\uc8e0?\uc800\ub294 A\uc5f4 \ub4a4\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud558\uace0, B\uc5f4\uc5d0 \ub2e4\uc74c\uc758 \uc218\uc2dd\uc744 \ubc18\uc601\ud558\uc600\uc2b5\ub2c8\ub2e4. =A2 & F2 \uadf8\ub9ac\uace0 \ubcf5\uc0ac\ud574\uc11c \ub2e4 \ucc44\uc6e0\uc5b4\uc694\uadf8\ub9ac\uace0 \uc544\ub798\uc640 \uac19\uc774 Vlookup \uba85\ub839\uc5b4\ub85c \ub370\uc774\ud130\ub97c \ucc3e\uc558\uc2b5\ub2c8\ub2e4. =VLOOKUP(L4&L5,B2:C23,2,FALSE) \uacb0\uacfc \ud654\uba74\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\ub294 \ubcf4\uc2dc\ub2e4 \uc2dc\ud53c \uc798 \ub098\uc654\uc2b5\ub2c8\ub2e4.\ub2e4\ub9cc, B\uc5f4\uc5d0 \uc2e0\uaddc \uc5f4\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud558\uac8c \ub370\uc774\ud130\ub9cc \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc774\ub807\uac8c \uc791\uc5c5\ud574\ub3c4 \uc544\ubb34\ub7f0 \ubb38\uc81c\uac00 \uc5c6\uaca0\uc9c0\ub9cc, \uc5ec\ub7ec\uc0ac\ub78c\uc774 \ubd10\uc57c\ud558\ub294 \ub370\uc774\ud130\ub098 \uc5f4\uc744 \ucd94\uac00\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc5d0\uc11c\ub77c\uba74 \uc774\ub807\uac8c \uc791\uc5c5\ud560 \uc218 \uc5c6\uac8c \ub429\ub2c8\ub2e4.\uc774\ub7f4\ub54c \uc0ac\uc6a9\ud558\ub294 \uc218\uc2dd\uc774 Match\uc640 Index\uc744 \ubcf5\ud569\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. Index \uc218\uc2dd\uc740 \ubc30\uc5f4\uc5d0\uc11c \uc6d0\ud558\ub294 \uc88c\ud45c\ub97c \ubc18\uc601\ud558\uc5ec \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uc218\uc2dd\uc785\ub2c8\ub2e4.\uc218\uc2dd\uc758 \uc0ac\uc6a9\ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. =INDEX(array, row_num, [column_num]) \uc5ec\ub7ec\ubc88 \uc124\uba85 \ub4dc\ub838\uc9c0\ub9cc, array\ub294 \uc6d0\ud558\ub294 \ubc94\uc704\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 row_num\uc740 \ud589\uc758 \ubc88\ud638\uc774\uba70, column_num\uc740 \uc5f4\uc758 \ubc88\ud638\uc785\ub2c8\ub2e4.\uc989, \uc6d0\ud558\ub294 \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud589 \ubc88\ud638, \uc5f4 \ubc88\ud638\uc5d0 \ud574\ub2f9\ub418\ub294 \ub370\uc774\ud130\ub97c \ucd9c\ub825\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.\uc704\uc5d0 \ud45c\uc5d0\uc11c \uc608\ub97c \ub4e4\uc5b4 \ub4dc\ub9b4\uaed8\uc694. =INDEX(A2:G23,3,1) \ubc94\uc704 A2:23\uc5d0\uc11c 3\ubc88\uc9f8 \ud589\uc758 \uccab\ubc88\uc9f8 \uc5f4\uc740 JJJJ\uac12\uc774 \ub429\ub2c8\ub2e4. \uc218\ud559\uc801\uc778 \ud45c\ub97c \ubcf4\ub294 \uac83\uacfc \ub3d9\uc77c\ud55c \uac83\uc785\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 Match \uc218\uc2dd\uc5d0 \ub300\ud574 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. Match\ub294 \uc694\uccad\ud558\ub294 \ub370\uc774\ud130\uac00 \uba87\ubc88\uc9f8\uc5d0 \uc788\ub294\uc9c0 \ucc3e\uc544\ub0b4\ub294 \uc218\uc2dd\uc785\ub2c8\ub2e4.\uc218\uc2dd\uc758 \uc0ac\uc6a9\ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. =MATCH(lookup_value, lookup_array, [match type]) \uccab\ubc88\uc7ac\ub294 lookup_value\uc785\ub2c8\ub2e4. \ucc3e\ub294 \uac12\uc774\uc8e0. \ub450\ubc88\uc9f8\ub294 lookup_array\uc785\ub2c8\ub2e4. \ucc3e\ub294 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ubc94\uc704 \uc785\ub2c8\ub2e4. \ub2e8, \uc774 \ubc94\uc704\ub294 \ud589\uc774\uba74 1\uac1c\uc758 \ud589\uc5d0\uc11c \uc9c4\ud589\ub418\uc5b4\uc57c \ud558\uba70, \uc5f4\ub85c \ucc3e\uc744 \uac83\uc774\uba74 1\uac1c\uc758 \uc5f4\uc5d0\uc11c \uc9c4\ud589\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc5ec\ub7ec\uac1c\uc758 \uc5f4\uacfc \ud589\uc744 \ub3d9\uc2dc\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c match type\uc778\ub370\uc694, \uc774\uac83\uc740 \uc22b\uc790\ub97c \uac80\uc0c9\ud560 \ub54c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. match type\ub294 0, -1, 1\uc774\uba70, 0\uc740 \uc77c\uce58\ud558\ub294 \uac12, -1\uc740 \uc791\uc740 \uac12, 1\uc740 \ud070 \uac12\uc744 \ucc3e\ub294 \uc5ed\ud65c\uc744 \ud569\ub2c8\ub2e4.\ubb38\uc790\ub97c \ucc3e\uc744 \uacbd\uc6b0\uc5d0\ub294 \ubc18\ub4dc\uc2dc 0\uc73c\ub85c \uac80\uc0c9\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\uac83\ub3c4 \uc608\ub97c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. =MATCH(“BBBB”,A2:A23,0) \uc790 A2\uc5d0\uc11c A23 \ubc94\uc704 \uc548\uc5d0\uc11c “BBBB”\ub77c\ub294 \ubd80\ud488\uc774 \uba87\ubc88\uc9f8 \uc788\ub0d0\ub294 \uc9c8\ubb38\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c\ubd80\ud130 4\ubc88\uc7ac\uc5d0 \uc788\uc8e0. \uc774\uac83\ub3c4 Vlookup\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc704\uc5d0\uc11c\ubd80\ud130 \uac80\uc0c9\ud558\ubbc0\ub85c, \uc5ec\ub7ec\uac1c\uac00 \uc788\uc744 \uacbd\uc6b0 \ub9e8 \uc704\uc758 \uc704\uce58 \uac12\uc744 \ub9ac\ud134\ud569\ub2c8\ub2e4. \uc5ec\uae30\uae4c\uc9c0 \ub4e3\uace0 \ub098\uc11c Match\uc640 Index\ub97c \uc5b4\ub5bb\uac8c \uc368\uc57c\ud560\uc9c0 \uac10\uc774 \uc7a1\ud788\uc2dc\ub294 \ubd84\ub4e4\ub3c4 \uacc4\uc2e4 \uac81\ub2c8\ub2e4. \uc77c\ub2e8\uc740 \ub2e4\uc911 \uc870\uac74 \uac80\uc0c9 \uc774\uc804\uc5d0 Vlookup \uba85\ub839\uc5b4\uc640 \ub3d9\uc77c\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 \ud654\uba74\uc744 \uba3c\uc800 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.\uac04\ub2e8\ud558\uac8c \uc9c8\ubb38 \ub0b4\uc6a9\uc740 CCCC \ubd80\ud488\uc758 \ub2e8\uac00\ub85c \ucc3e\uc544 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc790 \uacb0\ub860\ubd80\ud130 \ub9d0\uc500\ub4dc\ub9ac\uba74, \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 \ucd9c\ub825\ub41c \uac83\uc774 \ubcf4\uc774\uc2dc\uc8e0? \ub9de\uc2b5\ub2c8\ub2e4. Vlookup \uba85\ub839\uc5b4\ub294 \uc774\ub807\uac8c Match\uc640 \uc778\ub371\uc2a4 \uba85\ub839\uc5b4\ub97c \uc11e\uc5b4\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 \uc218\uc2dd\uc785\ub2c8\ub2e4.\uadf8\ub798\uc11c \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ub098\uc624\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4. Vlookup \uba85\ub839\uc5b4\ub294 \ub2e4\uc2dc \uc124\uba85 \ub4dc\ub9ac\uc9c0 \uc54a\uaca0\uc2b5\ub2c8\ub2e4.Match\uc640 Index\ub97c \uc0ac\uc6a9\ud55c \uc218\uc2dd\uc744 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uba3c\uc800 Index \uba85\ub839\uc5b4\ub97c \ubd84\uc11d\ud558\uba74 \ubc11\uc5d0\ucc98\ub7fc A1:G23 \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud589\ubc88\ud638 \uc5f4\ubc88\ud638\ub97c \uc785\ub825\ud558\ub3c4\ub85d \ud558\ub294 \uac83\uc785\ub2c8\ub2e4.INDEX(A1:G23,\ud589\ubc88\ud638,\uc5f4\ubc88\ud638) \ud589\ubc88\ud638\ub294 MATCH(K4,A1:A23,0)\uc785\ub2c8\ub2e4. \uc989 \ucc3e\ub294 \ub370\uc774\ud130\ub294 K4 \uc989 “CCCC”\ub77c\ub294 \ubd80\ud488\uba85\uc774\uc8e0, \ubc94\uc704\ub294 A\uc5f4\uc774\uad6c\uc694. match type\ub294 \ub2f9\uc5f0\ud788 \uc77c\uce58(0)\uc785\ub2c8\ub2e4. \uadf8\ub7ec\uba74 CCCC\uac00 \uc788\ub294 7\uc774\ub77c\ub294 \uac12\uc774 \ub9ac\ud134\ub418\uaca0\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \uc5f4 \ubc88\ud638\ub294 \ub2e8\uac00\uac00 \uc788\ub294 2\uc5f4\uc744 \uc9c1\uc811 \uc785\ub825\ud558\uc154\ub3c4 \ub418\uace0, MATCH(“\ub2e8\uac00”,A1:G1,0)\uc73c\ub85c \ucc3e\uc73c\uc154\ub3c4 \ub429\ub2c8\ub2e4. 1\ubc88\ud589\uc5d0\uc11c “\ub2e8\uac00”\uc640 \uc77c\uce58\ud558\ub294 \uc5f4 \uc704\uce58\ub97c \ucc3e\uc73c\ub2c8, \ub2f9\uc5f0\ud788 2\ub77c\ub294 \uac12\uc774 \ub9ac\ud134\ub418\uaca0\uc8e0. \uadf8\ub798\uc11c \uc778\ub371\uc2a4\uc5d0\uc11c 11,2\uc758 \ub370\uc774\ud130\uc778 24,200\uc758 \uac12\uc774 \ucd9c\ub825\ub418\uac8c \ub429\ub2c8\ub2e4. \uc790 \uc774\uc81c Match, Index \uba85\ub839\uc5b4\uc5d0 \ub300\ud574\uc11c \uac10\uc744 \uc7a1\uc73c\uc168\uc9c0\uc694?\uadf8\ub7fc \uc774\ubc88 \uae00\uc758 \uc8fc\uc694 \ud575\uc2ec\uc778 \ub2e4\uc911\uc870\uac74 \uac80\uc0c9\uc744 \uc9c4\ud589\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc218\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. =INDEX(array, MATCH(lookup_value1&lookup_value2,lookup_array1&lookup_array2,0),column_num)=INDEX(\ub370\uc774\ud130 \ubc94\uc704, MATCH(\uc870\uac741&\uc870\uac742, \uc870\uac741\uc758\ubc94\uc704&\uc870\uac742\uc758\ubc94\uc704,0),\uc5f4\ubc88\ud638) \uc6d0\ub798\ub294 \uc5d1\uc140\uc5d0\uc11c \uc8fc\ub294 \uc870\uac74\uc744 \uc785\ub825\ud558\ub294\ub370 \uc774\ud574\ud558\uae30 \ud798\ub4dc\uc2e4\uae4c\ubd10 \ud55c\uae00\ub85c\ub3c4 \ub0b4\uc6a9\uc744 \uc368 \ub4dc\ub838\uc2b5\ub2c8\ub2e4.\uc6b0\uc120 Index \uba85\ub839\uc5b4 \uc0ac\uc6a9\uc740 \uc704\uc758 1\uac00\uc9c0 \uc870\uac74\uc73c\ub85c \uac80\uc0c9\ud558\ub358 \uac83\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. \ub300\uc0b0 Match\uba85\ub839\uc5b4\ub294 \uc870\uae08 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc6b0\uc120 \ucc3e\ub294 \ub370\uc774\ud130\uac00 \uc870\uac741 & \uc870\uac742\ub85c \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \uc870\uac74\ub4e4 \uc0ac\uc774\uc5d0 &\uac00 \ub4e4\uc5b4\uac00\ub294 \uac81\ub2c8\ub2e4.\ub610\ud55c \ucc3e\ub294 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ubc94\uc704 \ub610\ud55c \ubc94\uc7041 & \ubc94\uc7042\ub85c \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \ub2f9\uc5f0\ud788 \uc21c\uc11c\ub294 \ubc14\ub00c\uba74 \uc548\ub418\uaca0\uc2b5\ub2c8\ub2e4. \uadf8\uc678\uc5d0 match type\uc740 \ub3d9\uc77c\ud558\uac8c 0(\uc77c\uce58)\uc73c\ub85c \uc801\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc544\uc154\uc57c \ud560 \uc810\uc740 2\uac00\uc9c0 \uc870\uac74\uc774 \uc544\ub2c8\ub77c \uc870\uac74\uc774 \ucd94\uac00\ub418\ub294 \uacbd\uc6b0\uc5d0\ub3c4 \uc704\uc640 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \uc870\uac741&\uc870\uac742&\uc870\uac743&……\uc73c\ub85c \ud558\uace0, \ubc94\uc7041&\ubc94\uc7042&\ubc94\uc7043&….\uc73c\ub85c \ud558\uc154\ub3c4 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4\ub294 \uac81\ub2c8\ub2e4. \uc774\ub807\uac8c \uc0ac\uc6a9\ud558\uba74 \uc5f4\uc744 \ucd94\uac00\ud558\uc9c0 \uc54a\uace0\ub3c4 \ub2e4\uc911 \uc870\uac74\uc758 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, \uc774 \uacbd\uc6b0\ub294 \ucd5c\uc2e0 \uc5d1\uc140\uc5d0\uc11c \uc801\uc6a9\ub418\ub294 \uc218\uc2dd\uc774\ub77c\ub294 \uc810\uc785\ub2c8\ub2e4. \uc800\uc758 \uacbd\uc6b0 Office 2022\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc5b4 \ub370\uc774\ud130\uac00 \uc798 \ub098\uc624\ub294 \uac83\uc785\ub2c8\ub2e4.\uadf8\ub807\ub2e4\uace0 \uc774\uc804 \ubc84\uc83c\uc5d0\uc11c\ub294 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub290\ub0d0 \ud558\uba74 \uadf8\ub807\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, \uc2dd\uc744 \uc785\ub825\ud558\uace0 ctrl+shift+enter\ub97c \ub20c\ub7ec\uc57c\ub9cc \uc801\uc6a9\ub41c\ub2e4\ub294 \uc810\ub9cc \ub2e4\ub985\ub2c8\ub2e4. ctrl+shift+enter\uc744 \ub204\ub974\uba74 \uc218\uc2dd\uc758 \uc591 \uc606\uc5d0 “{ }”\uac00 \ucd94\uac00\ub41c \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\uc804\uc5d0\ub294 \uc800\ub807\uac8c \ud558\uc9c0\uc54a\uc73c\uba74 \ub370\uc774\ud130\uac00 \ucd9c\ub825\ub418\uc9c0 \uc54a\uc558\uc73c\ub098, \ucd5c\uc2e0\ubc84\uc83c\uc5d0\uc11c\ub294 \uc77c\ubc18 \uc218\uc2dd\ucc98\ub7fc \uc785\ub825\ud574\ub3c4 \ub3d9\uc791\uc744 \ud558\ub3c4\ub85d \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4.\ucc38\uace0\ub85c \ub9d0\uc500\ub4dc\ub9ac\uba74, ctrl+shift+enter\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ud30c\uc77c\uc758 \uc6a9\ub7c9\uc774 \ucee4\uc9c0\uba70, \uc5ec\ub7ec\uac1c\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c8 \uc218 \uc788\ub2e4\ub294 \uc810 \uc720\uc758\ud558\uc5ec \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.\uc544 \ubb3c\ub860 \ucd5c\uc2e0 \ubc84\uc83c\uc758 \uacbd\uc6b0 \ub2e4\uc911\uc870\uac74 \uc218\uc2dd\uc774 \ud3ec\ud568\ub418\ub294 \uac83\ub9cc\uc73c\ub85c\ub3c4 \uc6a9\ub7c9\uc774 \ucee4\uc9d1\ub2c8\ub2e4. \u314e\u314e\u314e. \uc790 \uc774\ub807\uac8c \uc624\ub298\uc740 \ub2e4\uc911\uc870\uac74\uc758 \ub370\uc774\ud130 \uac80\uc0c9\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc88b\uc740 \ud301\uc774 \ub418\uc5c8\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. \uc624\ub298\ub3c4 \uc88b\uc740 \ud558\ub8e8 \ub418\uc138\uc694 ^^<\/p>\n","protected":false},"author":1,"featured_media":706,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[27],"tags":[142,156,155,160,144,157,158,159,154,147,141],"class_list":["post-699","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-excel-2","tag-index","tag-match","tag-match-index","tag-vlookup-2","tag-157","tag-158","tag-159","tag-154","tag-147","tag-141"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=699"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/699\/revisions"}],"predecessor-version":[{"id":708,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/699\/revisions\/708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/706"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}