{"id":691,"date":"2022-11-10T14:28:35","date_gmt":"2022-11-10T05:28:35","guid":{"rendered":"https:\/\/chaerang.net\/?p=691"},"modified":"2022-11-10T14:32:49","modified_gmt":"2022-11-10T05:32:49","slug":"excel-%ec%88%98%ec%8b%9d-vlookup-lookup-%eb%a7%88%ec%a7%80%eb%a7%89-%ea%b0%92-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=691","title":{"rendered":"Excel – \uc218\uc2dd : Vlookup, Lookup \ub9c8\uc9c0\ub9c9 \uac12 \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

\uc5b4\uc81c\ubcf4\ub2e8 \uc870\uae08 \uc2dc\uac04\uc801 \uc5ec\uc720\uac00 \uc788\ub124\uc694 \u314e\u314e\u314e. \uc5b4\uc81c \uace0\uac1d\uc0ac \uc190\ub2d8\uc774 \uc654\ub2e4\uac00 \uac14\uc9c0\ub9cc, \ud2b9\ubcc4\ud55c \uc774\uc288\uc0ac\ud56d\uc740 \uc5c6\uc5c8\ub124\uc694. \ucc38 \ub2e4\ud589\uc785\ub2c8\ub2e4 \u314e\u314e\u314e.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \uc5d1\uc140\uc5d0 \ub300\ud55c \ud301\uc744 \ud558\ub098 \ub354 \ub4dc\ub9b4\uaec0\ub370\uc694.
Vlookup\ud568\uc218\uc758 \ub2e8\uc810\uc774 \ubb34\uc5c7\uc778\uc9c0 \uc54c\uace0 \uacc4\uc2e0\uac00\uc694? \uc544\uc2dc\ub294 \ubd84\ub4e4\uc740 \ub2e4 \uc544\uc2e4\ud150\ub370\uc694… \uadf8\uac83\uc740 \ubc14\ub85c \uc704\uc5d0\uc11c\ubd80\ud130 \ub0b4\uc6a9\uc744 \uac80\uc0c9\ud558\uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 2\uac1c \uc774\uc0c1\uc778 \uacbd\uc6b0 \ub9e8\uba3c\uc800 \ub098\uc624\ub294 \ub2f5\ub9cc\uc744 \ub9ac\ud134\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.
\uc544\ub798\uc640 \uac19\uc774 \ub098\uc624\uac8c \ub418\uaca0\uc8e0<\/p>\n\n\n\n

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

\ubcf4\uc2dc\uba74 aaa\ub77c\ub294 \ubd80\ud488\uc774 3\ubc88 \ubc18\ubcf5\ud574\uc11c \ub098\uc624\uc9c0\ub9cc, Vlookup \uba85\ub839\uc5b4\ub97c \uc4f8\uacbd\uc6b0 \ub9e8 \uc704\uc5d0 aaa\uc5d0 \ub300\ud55c \ub370\uc774\ud130\ub97c \ub9ac\ud134\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8 \uc624\ub298 \ud558\uace0\uc790 \ud558\ub294 \uac83\uc740 \ub9e8\uc704\uac00 \uc544\ub2cc \ub9e8 \uc544\ub798 \ub370\uc774\ud130\ub97c \ub9ac\ud134\ud558\ub294 \ubc29\ubc95\uc744 \uc368\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4.
\ubb3c\ub860 \uc774 \uacbd\uc6b0\uc5d0\ub294 Vlookup \uba85\ub839\uc5b4\uac00 \uc544\ub2cc Lookup \uba85\ub839\uc5b4\ub97c \uc368\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

Lookup \uba85\ub839\uc758 \ubc30\uce58\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
Lookup(lookup_value, lookup_vector, [result_vector]) \ub610\ub294 Lookup(lookup_value, array)
\uc774 \ub450\uac00\uc9c0 \ubc29\uc2dd\uc785\ub2c8\ub2e4.
\uadf8\ub7f0\ub370 \uc774\uc911 \uac00\uc7a5 \uc774\ud574\uac00 \uc548\ub420 \ubd80\ubd84\uc740 vector\uc774\ub77c\ub294 \ubb38\uad6c\uc774\uaca0\uc8e0?
\uc774\uacfc\ub098 \uacf5\ub300\ub97c \ub098\uc624\uc2e0 \ubd84\ub4e4\uc740 \ubca1\ud130\ub77c\ub294 \ub9d0\uc744 \ud55c\ubc88\uc529\uc740 \ub2e4 \ub4e4\uc5b4\ubcf4\uc168\uc744 \uac81\ub2c8\ub2e4. \uc27d\uac8c \ub9d0\ud574 \uc808\ub300\uce58\uc758 \uac12 \uc815\ub3c4\ub85c \uc774\ud574\ud558\uc2dc\uba74 \ub420\ud150\ub370\uc694, \uc74c \uc774\uac83\ub3c4 \uc5b4\ub835\ub0ad….
\uc870\uae08 \uc124\uba85\ud558\uae30 \uc560\ub9e4\ud55c \uac1c\ub150\uc774\ub77c\uc11c \uc124\uba85\uc774 \uc880 \uc5b4\ub835\uae34 \ud558\ub124\uc694.
\uc77c\ub2e8 \ub2e4\ub974\uac8c \ub9d0\uc500\ub4dc\ub9b4\uaed8\uc694. \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 \uc788\uc744 \uacbd\uc6b0 \ub9e8\uc704\uc5d0\uaebc \ud558\ub098 \ub9d0\uace0\ub294 \ub2e4 \ubb34\uc2dc\ud55c\ub2e4\uc785\ub2c8\ub2e4.
\uc774\uac83\ub3c4 \uc5b4\ub835\uc8e0 ^^;;; \ub2e4\ub974\uac8c \ub9d0\ud558\uba74 \ubb38\uc790\ub97c \uadf8\ub300\ub85c \ubcf4\uc9c0 \uc54a\uace0 \ub3c5\ud2b9\ud55c \uc21c\uc704\uc640 \uae00\uc790\ub85c \ubd84\uc11d\ud558\uc5ec \ubcc4\ub3c4\uc758 \uc5b8\uc5b4\ub85c \uad6c\ubd84\ud55c\ub2e4\uc785\ub2c8\ub2e4.
\uc22b\uc790\ub294 \uc27d\uac8c \uc778\uc2dd\ud558\uc9c0\ub9cc \ubb38\uc790\ub294 \ubcc4\ub3c4\ub85c \ubd84\uc11d\ud574 \ubc84\ub9b0\ub2e4\ub294 \uac70\uc8e0.<\/p>\n\n\n\n

\uc5b4\ub835\uc8e0? \ub124 \uc555\ub2c8\ub2e4. \u314e\u314e\u314e\u314e \uadf8\ub798\uc11c \uc608\ub97c \ub4e4\uc5b4 \ub4dc\ub9b4\uaed8\uc694.<\/p>\n\n\n\n

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

\uc790 Lookup \uba85\ub839\uc5b4\ub97c \uc368\ubd24\uc2b5\ub2c8\ub2e4. \uadf8\ub0e5 \ubcf4\uba74 Vlookup\uacfc \ub3d9\uc77c\ud558\uc8e0? \ubb34\uc5c7\uc774 \ubb38\uc81c\uc778\uc9c0 \uc804\ud600 \ubaa8\ub974\uc2dc\uaca0\uc8e0? ^^
\uadf8\ub7fc \ub9e8\uc704\uc758 \ub370\uc774\ud130\uc758 aaa\ub97c \uc0ad\uc81c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

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

\ubcf4\uc774\uc2dc\uc8e0? Vlookup \uba85\ub839\uc5b4\ub294 \ubc14\ub85c \ub2e4\uc74c\uc758 aaa \uac12\uc744 \ucc3e\uc544\uc11c \ub9ac\ud134\ud558\uc9c0\ub9cc, Lookup \uba85\ub839\uc5b4\ub294 \ub2f5\uc774 \uc5c6\ub2e4\uace0 \ub098\uc640 \ubc84\ub9bd\ub2c8\ub2e4. \uc989 \ubb38\uc790\ub97c \ubca1\ud130\ud654 \uc2dc\ud0a4\uba74\uc11c \ud574\ub2f9 \ub0b4\uc6a9\uc744 \ucc3e\uc9c0 \ubabb\ud558\ub294 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 aaa\ub97c \uc22b\uc790\ub85c \ubcc0\ud658\ud558\uace0 \ucc3e\ub294 \ubd80\ud488\ub3c4 \uc22b\uc790\ub85c \ubcc0\ud658\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

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

\uc790 aaa\ub97c \uc22b\uc790\ub85c\ub9cc \ubcc0\ud658\ud588\uc744 \ubfd0\uc778\ub370 Lookup \ud568\uc218\uac00 \uc791\ub3d9\ud558\uc8e0? \uc22b\uc790\ub294 \uc774\ubbf8 \ubca1\ud130\ud654 \ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubb38\uc790\uc758 \ubca1\ud130\ud654\ub97c \ud558\ub354\ub77c\ub3c4 \uadf8\ub300\ub85c\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.
\uc774\uac83\uc774 \ubca1\ud130\uc785\ub2c8\ub2e4. \uc774\ub798\ub3c4 \ubaa8\ub974\uc2e0\ub2e4\uba74 \uadf8\ub0e5 \ud3ec\uae30\ud574\uc57c\uc8e0 \ubaa8 \u314b\u314b\u314b.<\/p>\n\n\n\n

\uc27d\uac8c \ub9d0\ud574 Lookup \uba85\ub839\uc5b4\ub97c \uc4f0\ub824\uba74 \uc22b\uc790\ub85c \uce58\ud658\ud574\uc57c \ub41c\ub2e4\ub77c\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uc790\uafb8 \uc774\uc0c1\ud55c\ub370\ub85c \uac00\ub294\ub370\uc694.. \uc624\ub298\uc740 \ubaa9\ud45c\ub294 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\ub294 \uac83\uc785\ub2c8\ub2e4.
\uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

=LOOKUP(2, 1\/(lookup_array=lookup_value),output_array)<\/p>\n\n\n\n

\uc774\uac83\ub3c4 \uc5b4\ub824\uc6b0\uc2dc\uc8e0?
\uc5d1\uc140\uc744 \ub204\uac00 \ub9cc\ub4e4\uc5c8\ub294\uc9c0 \ubab0\ub77c\ub3c4 \ucc38 \uc5b4\ub835\uac8c \ub9cc\ub4e4\uc5b4\ub1a8\uc2b5\ub2c8\ub2e4.
\ub9e8 \uc55e\uc758 2\ub294 \ubca1\ud130 2 \uc774\ud558\uc758 \uc22b\uc790\ub97c \ucc3e\uc73c\ub77c\ub294 \ub73b\uc774\ub77c\uace0 \ubcf4\uba74 \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc544\uc2e4 \ubd80\ubd84\uc740 2 \uc774\ud558\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4. \uc989, \uc790\uc5f0\uc218\ub85c \uce58\uba74 1\uc774\ub098 2\uc785\ub2c8\ub2e4.
\uc5ec\uae30\uc11c \uc65c 0\uc774\ub098 \uc74c\uc218\uac00 \uc5c6\ub0d0\uace0 \ubb3c\uc73c\uc2e0\ub2e4\uba74… \ubaa8 \ub2e4\uc74c \uad6c\uc808\uc5d0\uc11c \ub2f5\uc744 \ucc3e\uc544\uc57c\uc8e0.
“1\/” \ubcf4\uc774\uc2dc\uc8e0? 1\ub85c \ub098\ub204\uc5c8\uc744\ub54c 0\uc774 \ub098\uc624\ub294 \uc22b\uc790\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc544\uc2dc\uc8e0?
lookup_array=lookup_value\ub97c \uc4f0\uc2dc\uba74 \ub9ac\ud134\ub418\ub294 \uac83\uc774 true \ub610\ub294 false\uc774\uba70 \ubca1\ud130\ud654 \ud558\uba74 1 \ub610\ub294 0\uc785\ub2c8\ub2e4.
\uc989, 1 \uc544\ub2c8\uba74 #DIV\/0 \ub77c\ub294 \ub9d0\uc774\uc8e0. \uadf8\ub7ec\ub2c8 \uc74c\uc218\ub098 0\uc740 \uc808\ub300 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\ub2c8 \uc2e0\uacbd\uc4f0\uc9c0 \uc54a\uc73c\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc55e\uc758 \uc218\ub97c 3\uc774\ub098 4\ub85c \ubc14\uafb8\uc5b4\ub3c4 1, 2, 3, 4\uc758 \uc22b\uc790\ub97c \ucc3e\uae30\uc5d0 \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4. \uc989 1\ubcf4\ub2e4 \ud070 \uc544\ubb34\uc22b\uc790\ub098 \ub123\uc73c\uc154\ub3c4 \ub41c\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc6d0\ud65c\ud55c \uc124\uba85\uc744 \uc704\ud574 \uc2e4\ud589\ud55c \uacb0\uacfc\ub97c \ubcfc\uaed8\uc694.<\/p>\n\n\n\n

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

\uc790 \ubcf4\uc2dc\uba74, Lookup\uc758 \uba85\ub839\uc5b4\ub294 \ub9e8 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\uc544\uc628 \uac83\uc774 \ubcf4\uc774\uc2dc\ub098\uc694?
\uba85\ub839\uc5b4\ub97c \uadf8\ub300\ub85c \ud480\uc774\ud574\uc11c \ub098\ud0c0\ub0b4\uba74 \ub2e4\uc74c\uacfc \uac19\uc544 \uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n

=LOOKUP(2,{1,#DIV\/0,#DIV\/0,#DIV\/0,1,#DIV\/0,#DIV\/0,1},{3000,4000,3500,8000,3200,5000,7000,3800})<\/p>\n\n\n\n

\uc774\ub807\uac8c \ud574\uc11d\ud558\uac8c \ub429\ub2c8\ub2e4. \uadf8\uc911 \uac00\uc7a5 \ud2b9\uc774\ud55c \uc810\uc740 \uc911\uac04\uc758 1, #DIV\/0 ….. 1 \uc758 \ub370\uc774\ud130\ub97c \uc55e\uc5d0\uc11c\ubd80\ud130 \ucc3e\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub4a4\uc5d0\uc11c\ubd80\ud130 \ucc3e\uc544\uc11c \uc62c\ub77c\uac04\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.
\uc774 \ud2b9\uc774\uc810\uc73c\ub85c \uc778\ud558\uc5ec \ub9e8 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ubd88\ub7ec\uc62c \uc218 \uc788\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc880 \ud2b9\uc774\ud558\uc8e0? \uc5b4\ub824\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uadf8\ub798\uc11c \uadf8\ub0e5 \uc27d\uac8c \uac00\uc7a5 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74<\/p>\n\n\n\n

=LOOKUP(2, 1\/(\uac80\uc0c9\ubc94\uc704=\uac80\uc0c9\uac12),\ucd9c\ub825\ubc94\uc704)<\/p>\n\n\n\n

\uc774\ub807\uac8c \uba85\ub839\uc5b4\ub97c \uc368\uc57c \ud55c\ub2e4\uace0 \uc774\ud574\ud558\uc2dc\uba74 \ub418\uaca0\uc2b5\ub2c8\ub2e4.
\uc704\uc5d0 \uc124\uba85\ub4dc\ub9b0 \uac83\uc740 \uc800\ucc98\ub7fc \ud2b9\uc774\ud558\uc2e0 \ubd84\ub4e4\uc774 \uc65c \uc800\ub807\uac8c \ub418\ub294 \uac70\uc9c0? 3\uc774\ub098 4\ub97c \uc4f0\uba74 \ub2e4\ub978 \ub370\uc774\ud130\uac00 \ub098\uc624\ub098? \uc774\ub7f0 \uad81\uae08\uc99d\uc744 \uac00\uc9c0\uc2e4\uae4c\ubd10 \uc124\uba85\ub4dc\ub9b0 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uadf8\ub0e5 \ud558\ub098\uc758 \ud301\uc744 \uac00\uc9c0\uace0 \uac04\ub2e4\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub418\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uc624\ub298\ub3c4 \uc5ec\uae30\uae4c\uc9c0 \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc7ac\ubbf8\uc788\uc73c\uc168\uae30\ub97c \ubc14\ub798\uc694 ^^<\/p>\n\n\n\n

\uadf8\ub7fc \uc774\ub9cc \ubb3c\ub7ec\ub0a9\ub2c8\ub2f9.<\/p>\n\n\n\n

<\/p>\n\n\n

Excel<\/a>, <\/span>lookup<\/a>, <\/span>Vlookup<\/a>, <\/span>\ub9c8\uc790\ubbf9 \uac12<\/a>, <\/span>\ub9c8\uc9c0\ub9c9 \uac12 \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. \uc5b4\uc81c\ubcf4\ub2e8 \uc870\uae08 \uc2dc\uac04\uc801 \uc5ec\uc720\uac00 \uc788\ub124\uc694 \u314e\u314e\u314e. \uc5b4\uc81c \uace0\uac1d\uc0ac \uc190\ub2d8\uc774 \uc654\ub2e4\uac00 \uac14\uc9c0\ub9cc, \ud2b9\ubcc4\ud55c \uc774\uc288\uc0ac\ud56d\uc740 \uc5c6\uc5c8\ub124\uc694. \ucc38 \ub2e4\ud589\uc785\ub2c8\ub2e4 \u314e\u314e\u314e. \uc624\ub298\ub3c4 \uc5d1\uc140\uc5d0 \ub300\ud55c \ud301\uc744 \ud558\ub098 \ub354 \ub4dc\ub9b4\uaec0\ub370\uc694.Vlookup\ud568\uc218\uc758 \ub2e8\uc810\uc774 \ubb34\uc5c7\uc778\uc9c0 \uc54c\uace0 \uacc4\uc2e0\uac00\uc694? \uc544\uc2dc\ub294 \ubd84\ub4e4\uc740 \ub2e4 \uc544\uc2e4\ud150\ub370\uc694… \uadf8\uac83\uc740 \ubc14\ub85c \uc704\uc5d0\uc11c\ubd80\ud130 \ub0b4\uc6a9\uc744 \uac80\uc0c9\ud558\uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 2\uac1c \uc774\uc0c1\uc778 \uacbd\uc6b0 \ub9e8\uba3c\uc800 \ub098\uc624\ub294 \ub2f5\ub9cc\uc744 \ub9ac\ud134\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.\uc544\ub798\uc640 \uac19\uc774 \ub098\uc624\uac8c \ub418\uaca0\uc8e0 \ubcf4\uc2dc\uba74 aaa\ub77c\ub294 \ubd80\ud488\uc774 3\ubc88 \ubc18\ubcf5\ud574\uc11c \ub098\uc624\uc9c0\ub9cc, Vlookup \uba85\ub839\uc5b4\ub97c \uc4f8\uacbd\uc6b0 \ub9e8 \uc704\uc5d0 aaa\uc5d0 \ub300\ud55c \ub370\uc774\ud130\ub97c \ub9ac\ud134\ud558\uac8c \ub429\ub2c8\ub2e4. \uc77c\ub2e8 \uc624\ub298 \ud558\uace0\uc790 \ud558\ub294 \uac83\uc740 \ub9e8\uc704\uac00 \uc544\ub2cc \ub9e8 \uc544\ub798 \ub370\uc774\ud130\ub97c \ub9ac\ud134\ud558\ub294 \ubc29\ubc95\uc744 \uc368\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4.\ubb3c\ub860 \uc774 \uacbd\uc6b0\uc5d0\ub294 Vlookup \uba85\ub839\uc5b4\uac00 \uc544\ub2cc Lookup \uba85\ub839\uc5b4\ub97c \uc368\uc57c \ud569\ub2c8\ub2e4. Lookup \uba85\ub839\uc758 \ubc30\uce58\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.Lookup(lookup_value, lookup_vector, [result_vector]) \ub610\ub294 Lookup(lookup_value, array) \uc774 \ub450\uac00\uc9c0 \ubc29\uc2dd\uc785\ub2c8\ub2e4.\uadf8\ub7f0\ub370 \uc774\uc911 \uac00\uc7a5 \uc774\ud574\uac00 \uc548\ub420 \ubd80\ubd84\uc740 vector\uc774\ub77c\ub294 \ubb38\uad6c\uc774\uaca0\uc8e0?\uc774\uacfc\ub098 \uacf5\ub300\ub97c \ub098\uc624\uc2e0 \ubd84\ub4e4\uc740 \ubca1\ud130\ub77c\ub294 \ub9d0\uc744 \ud55c\ubc88\uc529\uc740 \ub2e4 \ub4e4\uc5b4\ubcf4\uc168\uc744 \uac81\ub2c8\ub2e4. \uc27d\uac8c \ub9d0\ud574 \uc808\ub300\uce58\uc758 \uac12 \uc815\ub3c4\ub85c \uc774\ud574\ud558\uc2dc\uba74 \ub420\ud150\ub370\uc694, \uc74c \uc774\uac83\ub3c4 \uc5b4\ub835\ub0ad….\uc870\uae08 \uc124\uba85\ud558\uae30 \uc560\ub9e4\ud55c \uac1c\ub150\uc774\ub77c\uc11c \uc124\uba85\uc774 \uc880 \uc5b4\ub835\uae34 \ud558\ub124\uc694.\uc77c\ub2e8 \ub2e4\ub974\uac8c \ub9d0\uc500\ub4dc\ub9b4\uaed8\uc694. \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uac00 \uc788\uc744 \uacbd\uc6b0 \ub9e8\uc704\uc5d0\uaebc \ud558\ub098 \ub9d0\uace0\ub294 \ub2e4 \ubb34\uc2dc\ud55c\ub2e4\uc785\ub2c8\ub2e4.\uc774\uac83\ub3c4 \uc5b4\ub835\uc8e0 ^^;;; \ub2e4\ub974\uac8c \ub9d0\ud558\uba74 \ubb38\uc790\ub97c \uadf8\ub300\ub85c \ubcf4\uc9c0 \uc54a\uace0 \ub3c5\ud2b9\ud55c \uc21c\uc704\uc640 \uae00\uc790\ub85c \ubd84\uc11d\ud558\uc5ec \ubcc4\ub3c4\uc758 \uc5b8\uc5b4\ub85c \uad6c\ubd84\ud55c\ub2e4\uc785\ub2c8\ub2e4.\uc22b\uc790\ub294 \uc27d\uac8c \uc778\uc2dd\ud558\uc9c0\ub9cc \ubb38\uc790\ub294 \ubcc4\ub3c4\ub85c \ubd84\uc11d\ud574 \ubc84\ub9b0\ub2e4\ub294 \uac70\uc8e0. \uc5b4\ub835\uc8e0? \ub124 \uc555\ub2c8\ub2e4. \u314e\u314e\u314e\u314e \uadf8\ub798\uc11c \uc608\ub97c \ub4e4\uc5b4 \ub4dc\ub9b4\uaed8\uc694. \uc790 Lookup \uba85\ub839\uc5b4\ub97c \uc368\ubd24\uc2b5\ub2c8\ub2e4. \uadf8\ub0e5 \ubcf4\uba74 Vlookup\uacfc \ub3d9\uc77c\ud558\uc8e0? \ubb34\uc5c7\uc774 \ubb38\uc81c\uc778\uc9c0 \uc804\ud600 \ubaa8\ub974\uc2dc\uaca0\uc8e0? ^^\uadf8\ub7fc \ub9e8\uc704\uc758 \ub370\uc774\ud130\uc758 aaa\ub97c \uc0ad\uc81c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ubcf4\uc774\uc2dc\uc8e0? Vlookup \uba85\ub839\uc5b4\ub294 \ubc14\ub85c \ub2e4\uc74c\uc758 aaa \uac12\uc744 \ucc3e\uc544\uc11c \ub9ac\ud134\ud558\uc9c0\ub9cc, Lookup \uba85\ub839\uc5b4\ub294 \ub2f5\uc774 \uc5c6\ub2e4\uace0 \ub098\uc640 \ubc84\ub9bd\ub2c8\ub2e4. \uc989 \ubb38\uc790\ub97c \ubca1\ud130\ud654 \uc2dc\ud0a4\uba74\uc11c \ud574\ub2f9 \ub0b4\uc6a9\uc744 \ucc3e\uc9c0 \ubabb\ud558\ub294 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 aaa\ub97c \uc22b\uc790\ub85c \ubcc0\ud658\ud558\uace0 \ucc3e\ub294 \ubd80\ud488\ub3c4 \uc22b\uc790\ub85c \ubcc0\ud658\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc790 aaa\ub97c \uc22b\uc790\ub85c\ub9cc \ubcc0\ud658\ud588\uc744 \ubfd0\uc778\ub370 Lookup \ud568\uc218\uac00 \uc791\ub3d9\ud558\uc8e0? \uc22b\uc790\ub294 \uc774\ubbf8 \ubca1\ud130\ud654 \ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubb38\uc790\uc758 \ubca1\ud130\ud654\ub97c \ud558\ub354\ub77c\ub3c4 \uadf8\ub300\ub85c\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.\uc774\uac83\uc774 \ubca1\ud130\uc785\ub2c8\ub2e4. \uc774\ub798\ub3c4 \ubaa8\ub974\uc2e0\ub2e4\uba74 \uadf8\ub0e5 \ud3ec\uae30\ud574\uc57c\uc8e0 \ubaa8 \u314b\u314b\u314b. \uc27d\uac8c \ub9d0\ud574 Lookup \uba85\ub839\uc5b4\ub97c \uc4f0\ub824\uba74 \uc22b\uc790\ub85c \uce58\ud658\ud574\uc57c \ub41c\ub2e4\ub77c\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \uc790 \uc790\uafb8 \uc774\uc0c1\ud55c\ub370\ub85c \uac00\ub294\ub370\uc694.. \uc624\ub298\uc740 \ubaa9\ud45c\ub294 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\ub294 \uac83\uc785\ub2c8\ub2e4.\uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. =LOOKUP(2, 1\/(lookup_array=lookup_value),output_array) \uc774\uac83\ub3c4 \uc5b4\ub824\uc6b0\uc2dc\uc8e0? \uc5d1\uc140\uc744 \ub204\uac00 \ub9cc\ub4e4\uc5c8\ub294\uc9c0 \ubab0\ub77c\ub3c4 \ucc38 \uc5b4\ub835\uac8c \ub9cc\ub4e4\uc5b4\ub1a8\uc2b5\ub2c8\ub2e4.\ub9e8 \uc55e\uc758 2\ub294 \ubca1\ud130 2 \uc774\ud558\uc758 \uc22b\uc790\ub97c \ucc3e\uc73c\ub77c\ub294 \ub73b\uc774\ub77c\uace0 \ubcf4\uba74 \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc544\uc2e4 \ubd80\ubd84\uc740 2 \uc774\ud558\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4. \uc989, \uc790\uc5f0\uc218\ub85c \uce58\uba74 1\uc774\ub098 2\uc785\ub2c8\ub2e4.\uc5ec\uae30\uc11c \uc65c 0\uc774\ub098 \uc74c\uc218\uac00 \uc5c6\ub0d0\uace0 \ubb3c\uc73c\uc2e0\ub2e4\uba74… \ubaa8 \ub2e4\uc74c \uad6c\uc808\uc5d0\uc11c \ub2f5\uc744 \ucc3e\uc544\uc57c\uc8e0. “1\/” \ubcf4\uc774\uc2dc\uc8e0? 1\ub85c \ub098\ub204\uc5c8\uc744\ub54c 0\uc774 \ub098\uc624\ub294 \uc22b\uc790\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc544\uc2dc\uc8e0? lookup_array=lookup_value\ub97c \uc4f0\uc2dc\uba74 \ub9ac\ud134\ub418\ub294 \uac83\uc774 true \ub610\ub294 false\uc774\uba70 \ubca1\ud130\ud654 \ud558\uba74 1 \ub610\ub294 0\uc785\ub2c8\ub2e4.\uc989, 1 \uc544\ub2c8\uba74 #DIV\/0 \ub77c\ub294 \ub9d0\uc774\uc8e0. \uadf8\ub7ec\ub2c8 \uc74c\uc218\ub098 0\uc740 \uc808\ub300 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\ub2c8 \uc2e0\uacbd\uc4f0\uc9c0 \uc54a\uc73c\uc2dc\uba74 \ub429\ub2c8\ub2e4. \uc55e\uc758 \uc218\ub97c 3\uc774\ub098 4\ub85c \ubc14\uafb8\uc5b4\ub3c4 1, 2, 3, 4\uc758 \uc22b\uc790\ub97c \ucc3e\uae30\uc5d0 \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4. \uc989 1\ubcf4\ub2e4 \ud070 \uc544\ubb34\uc22b\uc790\ub098 \ub123\uc73c\uc154\ub3c4 \ub41c\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4. \uc6d0\ud65c\ud55c \uc124\uba85\uc744 \uc704\ud574 \uc2e4\ud589\ud55c \uacb0\uacfc\ub97c \ubcfc\uaed8\uc694. \uc790 \ubcf4\uc2dc\uba74, Lookup\uc758 \uba85\ub839\uc5b4\ub294 \ub9e8 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\uc544\uc628 \uac83\uc774 \ubcf4\uc774\uc2dc\ub098\uc694?\uba85\ub839\uc5b4\ub97c \uadf8\ub300\ub85c \ud480\uc774\ud574\uc11c \ub098\ud0c0\ub0b4\uba74 \ub2e4\uc74c\uacfc \uac19\uc544 \uc9d1\ub2c8\ub2e4. =LOOKUP(2,{1,#DIV\/0,#DIV\/0,#DIV\/0,1,#DIV\/0,#DIV\/0,1},{3000,4000,3500,8000,3200,5000,7000,3800}) \uc774\ub807\uac8c \ud574\uc11d\ud558\uac8c \ub429\ub2c8\ub2e4. \uadf8\uc911 \uac00\uc7a5 \ud2b9\uc774\ud55c \uc810\uc740 \uc911\uac04\uc758 1, #DIV\/0 ….. 1 \uc758 \ub370\uc774\ud130\ub97c \uc55e\uc5d0\uc11c\ubd80\ud130 \ucc3e\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub4a4\uc5d0\uc11c\ubd80\ud130 \ucc3e\uc544\uc11c \uc62c\ub77c\uac04\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.\uc774 \ud2b9\uc774\uc810\uc73c\ub85c \uc778\ud558\uc5ec \ub9e8 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ubd88\ub7ec\uc62c \uc218 \uc788\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4. \uc880 \ud2b9\uc774\ud558\uc8e0? \uc5b4\ub824\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uadf8\ub0e5 \uc27d\uac8c \uac00\uc7a5 \ub9c8\uc9c0\ub9c9 \uac12\uc744 \ucc3e\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 =LOOKUP(2, 1\/(\uac80\uc0c9\ubc94\uc704=\uac80\uc0c9\uac12),\ucd9c\ub825\ubc94\uc704) \uc774\ub807\uac8c \uba85\ub839\uc5b4\ub97c \uc368\uc57c \ud55c\ub2e4\uace0 \uc774\ud574\ud558\uc2dc\uba74 \ub418\uaca0\uc2b5\ub2c8\ub2e4.\uc704\uc5d0 \uc124\uba85\ub4dc\ub9b0 \uac83\uc740 \uc800\ucc98\ub7fc \ud2b9\uc774\ud558\uc2e0 \ubd84\ub4e4\uc774 \uc65c \uc800\ub807\uac8c \ub418\ub294 \uac70\uc9c0? 3\uc774\ub098 4\ub97c \uc4f0\uba74 \ub2e4\ub978 \ub370\uc774\ud130\uac00 \ub098\uc624\ub098? \uc774\ub7f0 \uad81\uae08\uc99d\uc744 \uac00\uc9c0\uc2e4\uae4c\ubd10 \uc124\uba85\ub4dc\ub9b0 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub0e5 \ud558\ub098\uc758 \ud301\uc744 \uac00\uc9c0\uace0 \uac04\ub2e4\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub418\uaca0\uc2b5\ub2c8\ub2e4. \uc790 \uc624\ub298\ub3c4 \uc5ec\uae30\uae4c\uc9c0 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc7ac\ubbf8\uc788\uc73c\uc168\uae30\ub97c \ubc14\ub798\uc694 ^^ \uadf8\ub7fc \uc774\ub9cc \ubb3c\ub7ec\ub0a9\ub2c8\ub2f9.<\/p>\n","protected":false},"author":1,"featured_media":696,"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,151,144,152,153,147,141],"class_list":["post-691","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-excel-2","tag-lookup","tag-vlookup-2","tag-152","tag-153","tag-147","tag-141"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/691","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=691"}],"version-history":[{"count":2,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/691\/revisions"}],"predecessor-version":[{"id":698,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/691\/revisions\/698"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/696"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}