{"id":681,"date":"2022-11-08T14:30:04","date_gmt":"2022-11-08T05:30:04","guid":{"rendered":"https:\/\/chaerang.net\/?p=681"},"modified":"2022-11-08T14:32:05","modified_gmt":"2022-11-08T05:32:05","slug":"excel-%ec%88%98%ec%8b%9d-data-%ec%b0%be%ea%b8%b0-vlookup-hlookup","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=681","title":{"rendered":"Excel \uc218\uc2dd – Data \ucc3e\uae30 : Vlookup, Hlookup"},"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\ub5bb\uac8c \ud558\ub2e4\ubcf4\ub2c8 \uae00\uc744 \ubabb\uc62c\ub9b0\uc9c0\uac00 \ud55c\ub2ec\uc774 \ub2e4 \ub418\uc5c8\ub124\uc694.. \uac11\uc790\uae30 \uc77c\uc774 \ubab0\ub824\ub4e4\uc5b4\uc11c \ucd9c\uc7a5 \uac00\uace0, \uc790\ub8cc \ubaa8\uc73c\uace0, \ub370\uc774\ud130 \ubf51\uace0 \uc815\uc2e0\uc774 \uc5c6\uc774 \ud55c\ub2ec\uc744 \ubcf4\ub0c8\ub124\uc694.
\uc6d0\ub798\ub294 \ubcf5\uadc0\ud558\uba74 \ud648\ud398\uc774\uc9c0\ubd80\ud130 \uc62c\ub9ac\ub824\uace0 \ud588\ub294\ub370, \uc544\uc9c1\ub3c4 \uc77c\uc774 \ub05d\ub098\uc9c0 \uc54a\uc558\uc5b4\uc694 \u3160.\u3160 \ub0b4\uc77c \ub610 \uace0\uac1d\uc0ac\uc5d0\uc11c \uc190\ub2d8\uc774 \uc628\ub370\uc11c \uc790\ub8cc \ub9cc\ub4e4\uace0 \uc788\uc74c…<\/p>\n\n\n\n

\uadf8\ub798\uc11c \uc624\ub298\uc740 \uc26c\uc6b4\uac70 \ud558\ub098\ub9cc \uc62c\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4(\uc77c\ud558\uae30 \uc2eb\uc73c\uba74 \uba87\uac1c \ub354 \uc62c\ub9b4\uc218\ub3c4 \uc788\uc5b4\uc694… \ub561\ub561\uc774\ub294 \ubc14\uc060\ub54c \uccd0\uc57c \ubcf4\ub78c\uc774 \uc788\uc73c\ub2c8\uae4c\uc694 \u314e\u314e\u314e)<\/p>\n\n\n\n

\uc544! \uadf8\ub9ac\uace0, \uce74\ud14c\uace0\ub9ac\uac00 \ucde8\ubbf8\uc778 \uc810\uc740… \uc8fc\uc5c5\ubb34\uac00 \uc544\ub2c8\ub77c \uadf8\ub0e5 \uc7ac\ubc0c\uc5b4\uc11c \ud558\ub294\uac70\ub77c \ucde8\ubbf8\ub85c \uad6c\ubd84\ud588\uc5b4\uc694 \u314b\u314b\u314b \uae30\ubd84\ub098\ube60 \ud558\uc9c4 \ub9c8\uc2dc\uacf5.<\/p>\n\n\n\n

\uc6d0\ub798\ub294 \ub9ce\uc774 \uc54c\ub824\uc9c0\uc9c0 \uc54a\uc740 \ud301\uc744 \uc54c\ub824\ub4dc\ub9b4\ub824\uace0 \ud588\ub294\ub370, \uadf8 \ud301\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc744 \ub54c\uc758 \uae30\ubcf8\uc801\uc778 \ub0b4\uc6a9\uc744 \uba3c\uc800 \uc124\uba85\ub4dc\ub824\uc57c \ud560 \uac83 \uac19\uc544\uc11c.. \uc77c\ub2e8 \uae30\ubcf8\uc801\uc73c\ub85c \ud68c\uc0ac\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc4f0\ub294 \uba85\ub839\uc5b4 \uc911 \ud558\ub098\uc778 Vlookup\uacfc Hlookup\uc744 \ub4e4\uace0 \uc654\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 \uc784\uc758\uc758 \ub370\uc774\ud130\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

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

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

\uc6b0\uc120 Vlookup\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.
Vlookup \ub370\uc774\ud130\uac00 \ud589\uc73c\ub85c \ub098\uc5f4\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \ucc3e\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.
\uba85\ub839\uc5b4\uc758 \uc218\uc2dd\uc740 =Vlookup(lookup_Value,table_array,col_index_num,[range_lookup])\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.
\uc124\uba85\uc744 \ub4dc\ub9ac\uba74,
– lookup_value : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790
– table_array : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc120\ud0dd \uc601\uc5ed
– col_index_num : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \uc5f4\uc758 \ubc88\ud638
– range_lookup : \ub370\uc774\ud130\uc758 \uc815\ud655\ub3c4??
\uc815\ub3c4\ub85c \uc774\ud574\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\ubb34\uc2a8 \ub9d0\uc778\uc9c0 \ud5f7\uac08\ub9ac\uc2dc\uc8e0? \u314e\u314e\u314e\u314e \uc608\ub97c \ub4e4\uc5b4 \uc124\uba85 \ub4dc\ub9b4\uaed8\uc694<\/p>\n\n\n\n

\uacf5\uae09\ubd80\ud488 A-Part\uc758 \uc785\uace0\ub41c \uc218\ub7c9\uc740 \uba87\uac1c \uc778\uac00\uc694? \ub77c\ub294 \uc9c8\ubb38\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud558\uba74 \uc704\uc5d0\uc11c \uc124\uba85\ud55c \ub0b4\uc6a9\uc73c\ub85c \uc218\uc2dd \uc804\uac1c\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

=VLOOKUP(“A-Part”,B1:F7,3,FALSE)<\/p>\n\n\n\n

\uc774\ud574\ub418\uc2dc\ub098\uc694?
\uc77c\ub2e8 lookup_value\ub294 “A-Part”\uc785\ub2c8\ub2e4. \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790\ub77c\uace0 \uc4f4 \uc774\uc720 \uc544\uc2dc\uaca0\uc8e0?
tabel_array \ub294 B1:F7\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc740 lookup_value\uac00 \ubc18\ub4dc\uc2dc \uccab\ubc88\uc9f8 \uc5f4\uc5d0 \uc788\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. A1\ubd80\ud130 \ucc3e\uc73c\uba74 \ub2f9\uc5f0\ud788 A\uc5f4\uc5d0\ub294 lookup_value\uac00 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\uac00 \uc5c6\uc74c(#N\/A)\uac00 \ud45c\uc2dc\ub420 \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4. \ubc18\ub4dc\uc2dc \uccab\ubc88\uc9f8 \uc5f4\uc5d0 lookup_value\uac00 \uc874\uc7ac\ud574\uc57c \ud569\ub2c8\ub2e4.
col_index_num\uc740 3\uc785\ub2c8\ub2e4. table_array\uc5d0\uc11c 1\uc5f4\uc740 \uacf5\uae09\ubd80\ud488\uc774\uba70, 2\uc5f4\uc740 \ub2e8\uac00, 3\uc5f4\uc740 \uc218\ub7c9, 4\uc5f4\uc740 \uacf5\uae09\uae08\uc561\uc774 \ub418\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\ub294 \uc218\ub7c9\uc744 \ucc3e\uc73c\ub77c\uace0 \ud588\uc73c\ub2c8 \uc218\ub7c9\uc744 \ub098\ud0c0\ub0b4\ub294 3\uc5f4\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc57c \ud558\ub294 \uac83\uc774\uc9c0\uc694. \uadf8\ub798\uc11c 3\uc785\ub2c8\ub2e4.
\ub9c8\uc9c0\ub9c9\uc73c\ub85c range_lookup\uc740 \uc815\ud655\ud558\uac8c \uc77c\uce58\ud558\ub290\ub0d0(False \ub610\ub294 0), \ub300\ucda9 \ube44\uc2b7\ud558\ub0d0(True \ub610\ub294 1)\ub97c \uad6c\ubd84\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc0ac\uc2e4\uc0c1false \ub9d0\uace0\ub294 \uc4f8\uc77c\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. True\ub85c \ud558\uba74 \ube44\uc2b7\ud55c \uac12\uc744 \ucc3e\uc544\uc624\uac70\ub098 \uc815\ud655\ud55c \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc62c \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uae30 \uc27d\uc9c0\ub9cc, \uc0ac\uc2e4\uc740 \uc5c9\ub6b1\ud55c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uacbd\uc6b0\uac00 \ub354 \ub9ce\uc2b5\ub2c8\ub2e4. \ube44\uc2b7\ud55c\uc758 \uc758\ubbf8\uac00 \uc560\ub9e4\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uad00\ub828\ub418\uc5b4 \uc774 \ub0b4\uc6a9\uc740 \ud655\uc778\ud560 \uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ucc38 \uc27d\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e \uc695\uba39\uc744\uc9c0 \ubab0\ub77c\ub3c4…
\uc77c\ub2e8 vlookup\uc740 \ud68c\uc0ac\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4 \uc911\uc5d0 \ud558\ub098\uc785\ub2c8\ub2e4. \uc65c\ub0d0\uad6c\uc694? \ud68c\uc0ac\ub2e4\ub140\ubcf4\uba74 \uc544\uc138\uc694 \u314b\u314b\u314b\u314b\u314b
\uc218\ub9ce\uc740 \ub370\uc774\ud130 \uc911\uc5d0 \ud544\uc694\ud55c\uac78 \ucc3e\uc544\ub0b4\ub294 \uba85\ub839\uc5b4\uc774\uae30 \ub54c\ubb38\uc774\uc8e0 \u314e\u314e\u314e\u314e<\/p>\n\n\n\n

\uc790 \ub2e4\uc74c\uc73c\ub85c Hlookup\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9b4\uaed8\uc694. \uae38\uac8c \uc124\uba85\ub4dc\ub9ac\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e \ub0b4\uc6a9\uc740 Vlookup\uac00 \ub3d9\uc77c\ud569\ub2c8\ub2e4. \ub2e4\ub9cc, \ud589\uacfc \uc5f4\uc774 \ubc18\ub300\ub85c \ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0 Hlookup\uc744 \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4. \uc989 \uc704\uc758 \ud14c\uc774\ube14\uc774 \uc544\ub798\uc640 \uac19\uc774 \ubc14\ub00c\uac8c \ub418\uba74 \uc0ac\uc6a9\ud55c\ub2e4\ub294 \ub9d0\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

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

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

\ubcf4\uc774\uc2dc\uc8e0? Vlookup\uacfc \ud589\uacfc \uc5f4\uc774 \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 Hlookup \uba85\ub839\uc5b4\ub97c \uc4f0\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uba85\ub839\uc5b4\uc758 \uc218\uc2dd\uc740 =Hlookup(lookup_Value,table_array,row_index_num,[range_lookup])\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.
\uc124\uba85\uc744 \ub4dc\ub9ac\uba74,
– lookup_value : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790
– table_array : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc120\ud0dd \uc601\uc5ed
– row_index_num : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \ud589\uc758 \ubc88\ud638
– range_lookup : \ub370\uc774\ud130\uc758 \uc815\ud655\ub3c4??
\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc544\uae4c Vlookup\uacfc \ub3d9\uc77c\ud55c \ubb38\uc81c\ub97c \ud47c\ub2e4\uace0 \uc0dd\uac01\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

=HLOOKUP(“A-Part”,A2:G6,3,TRUE)<\/p>\n\n\n\n

Vlookup\uacfc \uac70\uc758 \ub611\uac19\uc8e0? \ub530\ub85c \uc124\uba85\uc740 \uc548\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. Vlookup\uc5d0 \ube44\ud558\uba74 \uc0ac\uc6a9\ube48\ub3c4\uac00 \uc870\uae08 \ub0ae\uc740 \ud3b8\uc785\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74, \ub300\ubd80\ubd84\uc758 \ud68c\uc0ac\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud589\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \ub54c\ubb38\uc774\uc8e0. \uadf8 \uc774\uc720\ub294 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uc606\uc73c\ub85c\ub294 \ub9c8\uc6b0\uc2a4 \ud720\uc774 \uc798 \uc548 \uba39\uc73c\ub2c8\uae4c\uc694 ^^ \uc2ec\ud50c\ud558\uc8e0? <\/p>\n\n\n\n

\uc5b4\uca0b\ub4e0 \uac00\uc7a5 \ub2e8\uc21c\ud55c \uc790\ub8cc\ucc3e\uae30 \uba85\ub839\uc5b4\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub610 \uc2dc\uac04\uc774 \ub418\uba74 \ub2e4\uc74c\uae00 \uc4f0\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub2e4\uc2dc \uc62c\ub54c\uae4c\uc9c0 \uc798 \uc9c0\ub0b4\uc138\uc694 \u3160.\u315c<\/p>\n\n\n\n

<\/p>\n\n\n

data<\/a>, <\/span>Excel<\/a>, <\/span>Hlookup<\/a>, <\/span>Vlookup<\/a>, <\/span>\ub370\uc774\ud130\ucc3e\uae30<\/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\ub5bb\uac8c \ud558\ub2e4\ubcf4\ub2c8 \uae00\uc744 \ubabb\uc62c\ub9b0\uc9c0\uac00 \ud55c\ub2ec\uc774 \ub2e4 \ub418\uc5c8\ub124\uc694.. \uac11\uc790\uae30 \uc77c\uc774 \ubab0\ub824\ub4e4\uc5b4\uc11c \ucd9c\uc7a5 \uac00\uace0, \uc790\ub8cc \ubaa8\uc73c\uace0, \ub370\uc774\ud130 \ubf51\uace0 \uc815\uc2e0\uc774 \uc5c6\uc774 \ud55c\ub2ec\uc744 \ubcf4\ub0c8\ub124\uc694.\uc6d0\ub798\ub294 \ubcf5\uadc0\ud558\uba74 \ud648\ud398\uc774\uc9c0\ubd80\ud130 \uc62c\ub9ac\ub824\uace0 \ud588\ub294\ub370, \uc544\uc9c1\ub3c4 \uc77c\uc774 \ub05d\ub098\uc9c0 \uc54a\uc558\uc5b4\uc694 \u3160.\u3160 \ub0b4\uc77c \ub610 \uace0\uac1d\uc0ac\uc5d0\uc11c \uc190\ub2d8\uc774 \uc628\ub370\uc11c \uc790\ub8cc \ub9cc\ub4e4\uace0 \uc788\uc74c… \uadf8\ub798\uc11c \uc624\ub298\uc740 \uc26c\uc6b4\uac70 \ud558\ub098\ub9cc \uc62c\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4(\uc77c\ud558\uae30 \uc2eb\uc73c\uba74 \uba87\uac1c \ub354 \uc62c\ub9b4\uc218\ub3c4 \uc788\uc5b4\uc694… \ub561\ub561\uc774\ub294 \ubc14\uc060\ub54c \uccd0\uc57c \ubcf4\ub78c\uc774 \uc788\uc73c\ub2c8\uae4c\uc694 \u314e\u314e\u314e) \uc544! \uadf8\ub9ac\uace0, \uce74\ud14c\uace0\ub9ac\uac00 \ucde8\ubbf8\uc778 \uc810\uc740… \uc8fc\uc5c5\ubb34\uac00 \uc544\ub2c8\ub77c \uadf8\ub0e5 \uc7ac\ubc0c\uc5b4\uc11c \ud558\ub294\uac70\ub77c \ucde8\ubbf8\ub85c \uad6c\ubd84\ud588\uc5b4\uc694 \u314b\u314b\u314b \uae30\ubd84\ub098\ube60 \ud558\uc9c4 \ub9c8\uc2dc\uacf5. \uc6d0\ub798\ub294 \ub9ce\uc774 \uc54c\ub824\uc9c0\uc9c0 \uc54a\uc740 \ud301\uc744 \uc54c\ub824\ub4dc\ub9b4\ub824\uace0 \ud588\ub294\ub370, \uadf8 \ud301\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc744 \ub54c\uc758 \uae30\ubcf8\uc801\uc778 \ub0b4\uc6a9\uc744 \uba3c\uc800 \uc124\uba85\ub4dc\ub824\uc57c \ud560 \uac83 \uac19\uc544\uc11c.. \uc77c\ub2e8 \uae30\ubcf8\uc801\uc73c\ub85c \ud68c\uc0ac\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc4f0\ub294 \uba85\ub839\uc5b4 \uc911 \ud558\ub098\uc778 Vlookup\uacfc Hlookup\uc744 \ub4e4\uace0 \uc654\uc2b5\ub2c8\ub2e4. \uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 \uc784\uc758\uc758 \ub370\uc774\ud130\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \uc6b0\uc120 Vlookup\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.Vlookup \ub370\uc774\ud130\uac00 \ud589\uc73c\ub85c \ub098\uc5f4\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \ucc3e\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.\uba85\ub839\uc5b4\uc758 \uc218\uc2dd\uc740 =Vlookup(lookup_Value,table_array,col_index_num,[range_lookup])\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\uc124\uba85\uc744 \ub4dc\ub9ac\uba74, – lookup_value : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790 – table_array : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc120\ud0dd \uc601\uc5ed – col_index_num : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \uc5f4\uc758 \ubc88\ud638 – range_lookup : \ub370\uc774\ud130\uc758 \uc815\ud655\ub3c4?? \uc815\ub3c4\ub85c \uc774\ud574\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \ubb34\uc2a8 \ub9d0\uc778\uc9c0 \ud5f7\uac08\ub9ac\uc2dc\uc8e0? \u314e\u314e\u314e\u314e \uc608\ub97c \ub4e4\uc5b4 \uc124\uba85 \ub4dc\ub9b4\uaed8\uc694 \uacf5\uae09\ubd80\ud488 A-Part\uc758 \uc785\uace0\ub41c \uc218\ub7c9\uc740 \uba87\uac1c \uc778\uac00\uc694? \ub77c\ub294 \uc9c8\ubb38\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud558\uba74 \uc704\uc5d0\uc11c \uc124\uba85\ud55c \ub0b4\uc6a9\uc73c\ub85c \uc218\uc2dd \uc804\uac1c\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. =VLOOKUP(“A-Part”,B1:F7,3,FALSE) \uc774\ud574\ub418\uc2dc\ub098\uc694?\uc77c\ub2e8 lookup_value\ub294 “A-Part”\uc785\ub2c8\ub2e4. \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790\ub77c\uace0 \uc4f4 \uc774\uc720 \uc544\uc2dc\uaca0\uc8e0?tabel_array \ub294 B1:F7\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc740 lookup_value\uac00 \ubc18\ub4dc\uc2dc \uccab\ubc88\uc9f8 \uc5f4\uc5d0 \uc788\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. A1\ubd80\ud130 \ucc3e\uc73c\uba74 \ub2f9\uc5f0\ud788 A\uc5f4\uc5d0\ub294 lookup_value\uac00 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\uac00 \uc5c6\uc74c(#N\/A)\uac00 \ud45c\uc2dc\ub420 \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4. \ubc18\ub4dc\uc2dc \uccab\ubc88\uc9f8 \uc5f4\uc5d0 lookup_value\uac00 \uc874\uc7ac\ud574\uc57c \ud569\ub2c8\ub2e4.col_index_num\uc740 3\uc785\ub2c8\ub2e4. table_array\uc5d0\uc11c 1\uc5f4\uc740 \uacf5\uae09\ubd80\ud488\uc774\uba70, 2\uc5f4\uc740 \ub2e8\uac00, 3\uc5f4\uc740 \uc218\ub7c9, 4\uc5f4\uc740 \uacf5\uae09\uae08\uc561\uc774 \ub418\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\ub294 \uc218\ub7c9\uc744 \ucc3e\uc73c\ub77c\uace0 \ud588\uc73c\ub2c8 \uc218\ub7c9\uc744 \ub098\ud0c0\ub0b4\ub294 3\uc5f4\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc57c \ud558\ub294 \uac83\uc774\uc9c0\uc694. \uadf8\ub798\uc11c 3\uc785\ub2c8\ub2e4.\ub9c8\uc9c0\ub9c9\uc73c\ub85c range_lookup\uc740 \uc815\ud655\ud558\uac8c \uc77c\uce58\ud558\ub290\ub0d0(False \ub610\ub294 0), \ub300\ucda9 \ube44\uc2b7\ud558\ub0d0(True \ub610\ub294 1)\ub97c \uad6c\ubd84\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc0ac\uc2e4\uc0c1false \ub9d0\uace0\ub294 \uc4f8\uc77c\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. True\ub85c \ud558\uba74 \ube44\uc2b7\ud55c \uac12\uc744 \ucc3e\uc544\uc624\uac70\ub098 \uc815\ud655\ud55c \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc62c \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uae30 \uc27d\uc9c0\ub9cc, \uc0ac\uc2e4\uc740 \uc5c9\ub6b1\ud55c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uacbd\uc6b0\uac00 \ub354 \ub9ce\uc2b5\ub2c8\ub2e4. \ube44\uc2b7\ud55c\uc758 \uc758\ubbf8\uac00 \uc560\ub9e4\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uad00\ub828\ub418\uc5b4 \uc774 \ub0b4\uc6a9\uc740 \ud655\uc778\ud560 \uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \ucc38 \uc27d\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e \uc695\uba39\uc744\uc9c0 \ubab0\ub77c\ub3c4… \uc77c\ub2e8 vlookup\uc740 \ud68c\uc0ac\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4 \uc911\uc5d0 \ud558\ub098\uc785\ub2c8\ub2e4. \uc65c\ub0d0\uad6c\uc694? \ud68c\uc0ac\ub2e4\ub140\ubcf4\uba74 \uc544\uc138\uc694 \u314b\u314b\u314b\u314b\u314b\uc218\ub9ce\uc740 \ub370\uc774\ud130 \uc911\uc5d0 \ud544\uc694\ud55c\uac78 \ucc3e\uc544\ub0b4\ub294 \uba85\ub839\uc5b4\uc774\uae30 \ub54c\ubb38\uc774\uc8e0 \u314e\u314e\u314e\u314e \uc790 \ub2e4\uc74c\uc73c\ub85c Hlookup\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9b4\uaed8\uc694. \uae38\uac8c \uc124\uba85\ub4dc\ub9ac\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e \ub0b4\uc6a9\uc740 Vlookup\uac00 \ub3d9\uc77c\ud569\ub2c8\ub2e4. \ub2e4\ub9cc, \ud589\uacfc \uc5f4\uc774 \ubc18\ub300\ub85c \ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0 Hlookup\uc744 \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4. \uc989 \uc704\uc758 \ud14c\uc774\ube14\uc774 \uc544\ub798\uc640 \uac19\uc774 \ubc14\ub00c\uac8c \ub418\uba74 \uc0ac\uc6a9\ud55c\ub2e4\ub294 \ub9d0\uc785\ub2c8\ub2e4. \ubcf4\uc774\uc2dc\uc8e0? Vlookup\uacfc \ud589\uacfc \uc5f4\uc774 \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 Hlookup \uba85\ub839\uc5b4\ub97c \uc4f0\uac8c \ub429\ub2c8\ub2e4. \uba85\ub839\uc5b4\uc758 \uc218\uc2dd\uc740 =Hlookup(lookup_Value,table_array,row_index_num,[range_lookup])\uc73c\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\uc124\uba85\uc744 \ub4dc\ub9ac\uba74, – lookup_value : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uad6c\ubd84\ud558\ub294 \ubb38\uc790 – table_array : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc120\ud0dd \uc601\uc5ed – row_index_num : \ucc3e\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 \ud589\uc758 \ubc88\ud638 – range_lookup : \ub370\uc774\ud130\uc758 \uc815\ud655\ub3c4??\uc785\ub2c8\ub2e4. \uc544\uae4c Vlookup\uacfc \ub3d9\uc77c\ud55c \ubb38\uc81c\ub97c \ud47c\ub2e4\uace0 \uc0dd\uac01\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud558\uac8c \ub429\ub2c8\ub2e4. =HLOOKUP(“A-Part”,A2:G6,3,TRUE) Vlookup\uacfc \uac70\uc758 \ub611\uac19\uc8e0? \ub530\ub85c \uc124\uba85\uc740 \uc548\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. Vlookup\uc5d0 \ube44\ud558\uba74 \uc0ac\uc6a9\ube48\ub3c4\uac00 \uc870\uae08 \ub0ae\uc740 \ud3b8\uc785\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74, \ub300\ubd80\ubd84\uc758 \ud68c\uc0ac\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud589\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \ub54c\ubb38\uc774\uc8e0. \uadf8 \uc774\uc720\ub294 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uc606\uc73c\ub85c\ub294 \ub9c8\uc6b0\uc2a4 \ud720\uc774 \uc798 \uc548 \uba39\uc73c\ub2c8\uae4c\uc694 ^^ \uc2ec\ud50c\ud558\uc8e0? \uc5b4\uca0b\ub4e0 \uac00\uc7a5 \ub2e8\uc21c\ud55c \uc790\ub8cc\ucc3e\uae30 \uba85\ub839\uc5b4\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ub610 \uc2dc\uac04\uc774 \ub418\uba74 \ub2e4\uc74c\uae00 \uc4f0\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc2dc \uc62c\ub54c\uae4c\uc9c0 \uc798 \uc9c0\ub0b4\uc138\uc694 \u3160.\u315c<\/p>\n","protected":false},"author":1,"featured_media":683,"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":[143,142,145,144,146,141],"class_list":["post-681","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-data","tag-excel-2","tag-hlookup","tag-vlookup-2","tag-146","tag-141"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/681","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=681"}],"version-history":[{"count":2,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/681\/revisions"}],"predecessor-version":[{"id":687,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/681\/revisions\/687"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/683"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}