{"id":729,"date":"2022-11-15T16:36:10","date_gmt":"2022-11-15T07:36:10","guid":{"rendered":"https:\/\/chaerang.net\/?p=729"},"modified":"2022-11-21T16:38:37","modified_gmt":"2022-11-21T07:38:37","slug":"excel-%ec%88%98%ec%8b%9d-indirect-address","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=729","title":{"rendered":"Excel – \uc218\uc2dd : Indirect, Address"},"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\uc740 \uc870\uae08 \uae30\ubd84\uc774 \ubcc4\ub85c\uc778 \ud558\ub8e8\uc785\ub2c8\ub2e4…..
\uace0\uac1d\uc0ac\ub85c\ubd80\ud130 \uc624\ub298\uac00\uc9c0 \uc790\ub8cc \uc81c\ucd9c\ud574 \ub2ec\ub77c\uace0 \ud574\uc11c \uc544\uce68\ubd80\ud130 \uae09\ud558\uac8c \uc790\ub8cc\ub97c \ub9cc\ub4e4\uae30 \uc2dc\uc791\ud574\uc11c \uc810\uc2ec\ub54c\ucbe4 \ub9c8\ubb34\ub9ac \ub2e8\uacc4\uc5d0 \ub2e4\ub2ec\uc558\ub294\ub370
\uac11\uc790\uae30 \uc5f0\ub77d\uc774 \uc640\uc11c \ud544\uc694\uc5c6\ub2e4\ub124\uc694….. \uc774\uac8c \ubaac\uac00\uc694 \u3160.\u3160<\/p>\n\n\n\n

\uae09\ud558\uac8c \ud558\ub290\ub77c\uace0 \ub2e4\ub978\uc77c\ub3c4 \ubabb\ud558\uace0 \uc788\uc5c8\ub294\ub370… \uc5d0\ud600<\/p>\n\n\n\n

\uc5ec\ub2f4\uc740 \uc5ec\uae30\uae4c\uc9c0\ub9cc \ud558\uace0, \uc624\ub298\uc740 Indirect \ud568\uc218\uc640 Address \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9b4\uaed8\uc694.
\uc5b4\ub5bb\uac8c \ubcf4\uba74 \ub9ce\uc774 \uc4f8\uc77c\uc774 \uc5c6\uc744\uc9c0\ub3c4 \ubab0\ub77c\uc694.
\ud558\uc9c0\ub9cc \uc798 \uc0ac\uc6a9\ud558\uae30\ub9cc \ud55c\ub2e4\uba74 \ubb34\uc9c0 \uc88b\uc740 \uae30\ub2a5\uc744 \uac00\uc9c0\uace0 \uc788\uae30\ub3c4 \ud569\ub2c8\ub2e4.(\uc81c \uc0dd\uac01\uc785\ub2c8\ub2e4 \u314b)<\/p>\n\n\n\n

Indirect \ud568\uc218\ub294 \uc784\uc758\uc758 \uae00\uc790\ub97c \uc140\uc774\ub984\uc73c\ub85c \ubcc0\ud658\ud574 \uc8fc\ub294 \uba85\ub839\uc5b4 \uc785\ub2c8\ub2e4.
\ubb34\uc2a8 \ub73b\uc778\uc9c0 \uc870\uae08 \uc560\ub9e4\ud558\uc9c0\uc694? \u314e\u314e\u314e
\uae30\ubcf8\uc801\uc73c\ub85c \uc5d1\uc140\uc5d0\uc11c \ub2e4\ub978 \uc140\uc744 \ucc38\uc870\ud558\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

=A1<\/p>\n\n\n\n

\uadf8\ub7ec\uba74 A1\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ud615\uc2dd\uc774\uc8e0.
\uadf8\ub7f0\ub370, C1\uc140\uc5d0\ub294 A\uac00 D1\uc140\uc5d0\ub294 1\uc774 \ub4e4\uc5b4\uac00 \uc788\ub294 \uc0c1\ud0dc\uc5d0\uc11c, \ub2e4\uc74c\uacfc \uac19\uc740 \uc2dd\uc744 \uc368 \ub123\uc73c\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<\/p>\n\n\n\n

=C1&D1<\/p>\n\n\n\n

\uc815\ub2f5\uc740 “A1″\uc774\ub77c\ub294 \uae00\uc790\uac00 \ub2f9\uaca8\uc624\uac8c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.
\ub9cc\uc57d \uc800\ub807\uac8c \uc870\ud569\ud574\uc11c A1\uc140\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud560\uae4c\uc694?
\ub124 \ub9de\uc2b5\ub2c8\ub2e4. \uc774\ub7f4\ub54c \uc0ac\uc6a9\ud558\ub294 \ud568\uc218\uac00 Indirect \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

=INDIRECT(C1&D1,TRUE)<\/p>\n\n\n\n

\uc774\ub807\uac8c \uc785\ub825\uc744 \ud558\uba74 C1&D1\uc758 \uc870\ud569\uc774 A1\uc774\uae30 \ub54c\ubb38\uc5d0 A1\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uac83\uc774\uc8e0.
\uc800\uae30 \ubcf4\uc774\ub294 \ub9c8\uc9c0\ub9c9\uc758 TRUE\ub294 \ubb34\uc5c7\uc778\uac00 \ud558\uba74, A1\uc2a4\ud0c0\uc77c\uc774\ub77c\ub294 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e
\uc989 \uc6b0\ub9ac\uac00 \ubd80\ub974\ub294 \uc140\uc758 \uc774\ub984 \uc2a4\ud0c0\uc77c\uc744 True\ub85c \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.
\ubc18\ub300\ub85c False\ub294 R1C1 \uc2a4\ud0c0\uc77c\uc774\ub77c\uace0 \ud558\ub294\ub370\uc694, \ud589\ubc88\ud638-\uc5f4\ubc88\ud638 \uc2a4\ud0c0\uc77c\uc785\ub2c8\ub2e4.
\uc989 R1C1\uc740 1\ubc88\ud589\uc758 1\ubc88\uc5f4\uc774\ubbc0\ub85c A1\uc774 \ub429\ub2c8\ub2e4. \uc989, \uac01 \uc140\uc744 \ubc88\ud638\ub85c \ud638\ucd9c\ud558\uac8c \ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc704\uc758 \ub0b4\uc6a9\uc744 \uc815\ub9ac\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

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

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

\uc5b4\ub5bb\uac8c \uc774\uc6a9\ud560\uc9c0\ub294 \uc544\uc9c1 \uc798 \ubaa8\ub974\uc2dc\uaca0\uc8e0?
\uc774\uc6a9\ubc29\ubc95\uc740 Address \uba85\ub839\uc5b4\ub97c \uc124\uba85\ub4dc\ub9ac\uace0, \uc751\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

Address \ud568\uc218\ub294 Indirect\uc758 R1C1 \uc2a4\ud0c0\uc77c\uacfc \uac19\ub2e4\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.
\ub2e4\ub9cc, R\uacfc C\ub77c\ub294 \uae00\uc790\ub97c \ub123\uc9c0 \uc54a\uace0 \ud589\ubc88\ud638, \uc5f4\ubc88\ud638\ub85c \uc774\ub8e8\uc5b4\uc9c4\ub2e4\ub294 \uac83\uc774 \ucc28\uc774\uc810\uc785\ub2c8\ub2e4.
\ub2e4\uc591\ud55c \uc0ac\uc6a9\ubc95\uc774 \uc788\uc9c0\ub9cc Address\ub97c \ub9ce\uc774 \uc4f0\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ub2e8\uc21c \uc0ac\uc6a9\ubc95\ub9cc \uc54c\ub824\ub4dc\ub9b4\uaed8\uc694.
(\uc0ac\uc2e4 Address \ud568\uc218\ub294 Indirect\uba85\ub839\uc5b4\uc640 \uac19\uc774 \uc4f0\uc9c0 \uc54a\uc73c\uba74 \ud070 \uc758\ubbf8\ub294 \uc5c6\ub294\ub370, \ub2e4\ub978 \uc0ac\uc6a9\ubc95\uc744 \uc4f0\uc2e4\uac70\uba74 \uadf8\ub0e5 Indirect\uba85\ub839\uc5b4\ub9cc \uc4f0\ub294\uac83\uc774 \ub354 \ub0ab\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n

=ADDRESS(row_num, column_num)<\/p>\n\n\n\n

\uc0c1\uae30\uc640 \uac19\uc774 \uc785\ub825\ud558\uba74 \ub418\uba70, Row1, Column 1\uc744 \uc785\ub825\ud558\uba74 $A$1 \uc774\ub77c\ub294 \uac12\uc744 \ub9ac\ud134\ud569\ub2c8\ub2e4.
\uc989, \uc8fc\uc18c\uc758 \uc808\ub300\ucc38\uc870\uac00 \uc9c0\uc815\ub418\ub294 \uac83\uc774\uc9c0\uc694.
\uadf8\ub9ac\uace0 \ub9d0 \uadf8\ub300\ub85c \uc8fc\uc18c\uac00 \ub9ac\ud134\ub418\uae30 \ub54c\ubb38\uc5d0 \uc8fc\uc18c\uc5d0 \ub300\ud55c \uacb0\uacfc\uac00 \ub9ac\ud134\ub418\ub294 \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4.
\uadf8\ub798\uc11c \uc81c\ub300\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 Indirect \uba85\ub839\uacfc \ud63c\ud569\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

=INDIRECT(ADDRESS(1,1),TRUE)<\/p>\n\n\n\n

\uc774\ub807\uac8c \ub9d0\uc785\ub2c8\ub2e4.
\uc608\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

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

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

\uc790 \uc774\uc81c \uc774\uac78 \uc5b4\ub514\uc5d0 \uc4f8\uac83\uc774\ub0d0 \ud558\uba74, \ubc14\ub85c Match, Index \uba85\ub839\uc5b4\uc5d0 \uc0ac\uc6a9\ud560 \uc608\uc815\uc785\ub2c8\ub2e4.
\uad81\uae08\ud558\uc2e0\uac00\uc694? \u314e\u314e\u314e
\uc77c\ub2e8 \ub3c4\uc11c\uc6a9 \uac80\uc0c9\uc744 \uc704\ud55c \ud504\ub85c\uadf8\ub7a8\uc774\ub77c\uace0 \uac00\uc815\ud558\uace0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

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

\ubcc4\uac74 \uc544\ub2c8\uace0, \uc77c\ub2e8 \uac80\uc0c9 \uae30\uc900\uacfc \ucd9c\ub825 \ub0b4\uc6a9\uc744 \uc815\ud558\uc5ec \uacb0\uacfc\ubb3c\uc744 \ucd9c\ub825\ud558\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.
\ubcf4\uc2dc\uba74 \ucc45 \uc81c\ubaa9 “\uace0\uc591\uc774 \ud574\uacb0\uc0ac \uae5c\ub0e5 2″\uc758 \ucd9c\ud310\uc0ac\ub97c \ubb3c\uc5b4\ubcf8 \uacb0\uacfc\uc785\ub2c8\ub2e4.
(\uace0\uc591\uc774 \ud574\uacb0\uc0ac \uae5c\ub0e5\uc740 \uc6b0\ub9ac \ucc44\ub791\uc774\uac00 \uc88b\uc544\ud558\ub294 \ucc45\uc785\ub2c8\ub2e4. \u314e\u314e TMI)<\/p>\n\n\n\n

\ubcf4\ub2e4\uc2dc\ud53c Match, Index, Indirect, Address 4\uac1c\uc758 \uba85\ub839\uc5b4\ub97c \uc798 \uc0ac\uc6a9\ud558\uba74 \uc704\uc640 \uac19\uc740 \uac80\uc0c9 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc815\ub9d0 \ub2e4\uc591\ud55c \uac80\uc0c9\uc744 \ud558\uae30\uc704\ud574\uc11c\ub294 \ucd94\uac00\ub85c, \uc218\uc2dd\uc774 \ud544\uc694\ud558\uaca0\uc9c0\ub9cc \ub2e8\uc21c\ud55c \uac80\uc0c9\uc6a9\ub3c4\ub85c\ub294 \ucda9\ubd84\ud569\ub2c8\ub2e4.
\ub300\ucda9 \uac10\uc774 \uc7a1\ud788\uc2dc\ub098\uc694? \ud55c\ubc88\uc529 \ud574\ubcf4\uc2dc\uba74 \uc27d\uac8c \uc774\ud574\ud558\uc2e4 \uc218 \uc788\uc73c\uc2e4 \uac70\uc5d0\uc694.
\uc5b4\uca4c\uba74 \ub9ce\uc774 \uc0ac\uc6a9\ud560 \uc77c\uc740 \uc5c6\uaca0\uc9c0\ub9cc, \uadf8\ub798\ub3c4 \ud558\ub098\uc529 \uc54c\uc544\ub450\uba74 \ub098\uc058\uc9c0 \uc54a\uc744 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uc624\ub298\ub3c4 \uc5ec\uae30\uae4c\uc9c0 \uc4f0\uaca0\uc2b5\ub2c8\ub2e4. \uc88b\uc740 \ud558\ub8e8 \ub418\uc138\uc694 ^^<\/p>\n\n\n\n

<\/p>\n\n\n

Address<\/a>, <\/span>Excel<\/a>, <\/span>index<\/a>, <\/span>Indirect<\/a>, <\/span>match<\/a>, <\/span>\uc218\uc2dd<\/a>, <\/span>\uc5d1\uc140<\/a>, <\/span>\uc8fc\uc18c\ucc38\uc870<\/a>, <\/span>\ud568\uc218<\/a><\/div>","protected":false},"excerpt":{"rendered":"

\uc548\ub155\ud558\uc138\uc694, \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4. \uc624\ub298\uc740 \uc870\uae08 \uae30\ubd84\uc774 \ubcc4\ub85c\uc778 \ud558\ub8e8\uc785\ub2c8\ub2e4….. \uace0\uac1d\uc0ac\ub85c\ubd80\ud130 \uc624\ub298\uac00\uc9c0 \uc790\ub8cc \uc81c\ucd9c\ud574 \ub2ec\ub77c\uace0 \ud574\uc11c \uc544\uce68\ubd80\ud130 \uae09\ud558\uac8c \uc790\ub8cc\ub97c \ub9cc\ub4e4\uae30 \uc2dc\uc791\ud574\uc11c \uc810\uc2ec\ub54c\ucbe4 \ub9c8\ubb34\ub9ac \ub2e8\uacc4\uc5d0 \ub2e4\ub2ec\uc558\ub294\ub370 \uac11\uc790\uae30 \uc5f0\ub77d\uc774 \uc640\uc11c \ud544\uc694\uc5c6\ub2e4\ub124\uc694….. \uc774\uac8c \ubaac\uac00\uc694 \u3160.\u3160 \uae09\ud558\uac8c \ud558\ub290\ub77c\uace0 \ub2e4\ub978\uc77c\ub3c4 \ubabb\ud558\uace0 \uc788\uc5c8\ub294\ub370… \uc5d0\ud600 \uc5ec\ub2f4\uc740 \uc5ec\uae30\uae4c\uc9c0\ub9cc \ud558\uace0, \uc624\ub298\uc740 Indirect \ud568\uc218\uc640 Address \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ub4dc\ub9b4\uaed8\uc694.\uc5b4\ub5bb\uac8c \ubcf4\uba74 \ub9ce\uc774 \uc4f8\uc77c\uc774 \uc5c6\uc744\uc9c0\ub3c4 \ubab0\ub77c\uc694.\ud558\uc9c0\ub9cc \uc798 \uc0ac\uc6a9\ud558\uae30\ub9cc \ud55c\ub2e4\uba74 \ubb34\uc9c0 \uc88b\uc740 \uae30\ub2a5\uc744 \uac00\uc9c0\uace0 \uc788\uae30\ub3c4 \ud569\ub2c8\ub2e4.(\uc81c \uc0dd\uac01\uc785\ub2c8\ub2e4 \u314b) Indirect \ud568\uc218\ub294 \uc784\uc758\uc758 \uae00\uc790\ub97c \uc140\uc774\ub984\uc73c\ub85c \ubcc0\ud658\ud574 \uc8fc\ub294 \uba85\ub839\uc5b4 \uc785\ub2c8\ub2e4.\ubb34\uc2a8 \ub73b\uc778\uc9c0 \uc870\uae08 \uc560\ub9e4\ud558\uc9c0\uc694? \u314e\u314e\u314e\uae30\ubcf8\uc801\uc73c\ub85c \uc5d1\uc140\uc5d0\uc11c \ub2e4\ub978 \uc140\uc744 \ucc38\uc870\ud558\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. =A1 \uadf8\ub7ec\uba74 A1\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ud615\uc2dd\uc774\uc8e0.\uadf8\ub7f0\ub370, C1\uc140\uc5d0\ub294 A\uac00 D1\uc140\uc5d0\ub294 1\uc774 \ub4e4\uc5b4\uac00 \uc788\ub294 \uc0c1\ud0dc\uc5d0\uc11c, \ub2e4\uc74c\uacfc \uac19\uc740 \uc2dd\uc744 \uc368 \ub123\uc73c\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694? =C1&D1 \uc815\ub2f5\uc740 “A1″\uc774\ub77c\ub294 \uae00\uc790\uac00 \ub2f9\uaca8\uc624\uac8c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\ub9cc\uc57d \uc800\ub807\uac8c \uc870\ud569\ud574\uc11c A1\uc140\uc758 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud560\uae4c\uc694?\ub124 \ub9de\uc2b5\ub2c8\ub2e4. \uc774\ub7f4\ub54c \uc0ac\uc6a9\ud558\ub294 \ud568\uc218\uac00 Indirect \uc785\ub2c8\ub2e4. =INDIRECT(C1&D1,TRUE) \uc774\ub807\uac8c \uc785\ub825\uc744 \ud558\uba74 C1&D1\uc758 \uc870\ud569\uc774 A1\uc774\uae30 \ub54c\ubb38\uc5d0 A1\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uac83\uc774\uc8e0.\uc800\uae30 \ubcf4\uc774\ub294 \ub9c8\uc9c0\ub9c9\uc758 TRUE\ub294 \ubb34\uc5c7\uc778\uac00 \ud558\uba74, A1\uc2a4\ud0c0\uc77c\uc774\ub77c\ub294 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e\uc989 \uc6b0\ub9ac\uac00 \ubd80\ub974\ub294 \uc140\uc758 \uc774\ub984 \uc2a4\ud0c0\uc77c\uc744 True\ub85c \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.\ubc18\ub300\ub85c False\ub294 R1C1 \uc2a4\ud0c0\uc77c\uc774\ub77c\uace0 \ud558\ub294\ub370\uc694, \ud589\ubc88\ud638-\uc5f4\ubc88\ud638 \uc2a4\ud0c0\uc77c\uc785\ub2c8\ub2e4.\uc989 R1C1\uc740 1\ubc88\ud589\uc758 1\ubc88\uc5f4\uc774\ubbc0\ub85c A1\uc774 \ub429\ub2c8\ub2e4. \uc989, \uac01 \uc140\uc744 \ubc88\ud638\ub85c \ud638\ucd9c\ud558\uac8c \ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc704\uc758 \ub0b4\uc6a9\uc744 \uc815\ub9ac\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub429\ub2c8\ub2e4. \uc5b4\ub5bb\uac8c \uc774\uc6a9\ud560\uc9c0\ub294 \uc544\uc9c1 \uc798 \ubaa8\ub974\uc2dc\uaca0\uc8e0? \uc774\uc6a9\ubc29\ubc95\uc740 Address \uba85\ub839\uc5b4\ub97c \uc124\uba85\ub4dc\ub9ac\uace0, \uc751\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. Address \ud568\uc218\ub294 Indirect\uc758 R1C1 \uc2a4\ud0c0\uc77c\uacfc \uac19\ub2e4\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.\ub2e4\ub9cc, R\uacfc C\ub77c\ub294 \uae00\uc790\ub97c \ub123\uc9c0 \uc54a\uace0 \ud589\ubc88\ud638, \uc5f4\ubc88\ud638\ub85c \uc774\ub8e8\uc5b4\uc9c4\ub2e4\ub294 \uac83\uc774 \ucc28\uc774\uc810\uc785\ub2c8\ub2e4.\ub2e4\uc591\ud55c \uc0ac\uc6a9\ubc95\uc774 \uc788\uc9c0\ub9cc Address\ub97c \ub9ce\uc774 \uc4f0\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ub2e8\uc21c \uc0ac\uc6a9\ubc95\ub9cc \uc54c\ub824\ub4dc\ub9b4\uaed8\uc694.(\uc0ac\uc2e4 Address \ud568\uc218\ub294 Indirect\uba85\ub839\uc5b4\uc640 \uac19\uc774 \uc4f0\uc9c0 \uc54a\uc73c\uba74 \ud070 \uc758\ubbf8\ub294 \uc5c6\ub294\ub370, \ub2e4\ub978 \uc0ac\uc6a9\ubc95\uc744 \uc4f0\uc2e4\uac70\uba74 \uadf8\ub0e5 Indirect\uba85\ub839\uc5b4\ub9cc \uc4f0\ub294\uac83\uc774 \ub354 \ub0ab\uc2b5\ub2c8\ub2e4.) =ADDRESS(row_num, column_num) \uc0c1\uae30\uc640 \uac19\uc774 \uc785\ub825\ud558\uba74 \ub418\uba70, Row1, Column 1\uc744 \uc785\ub825\ud558\uba74 $A$1 \uc774\ub77c\ub294 \uac12\uc744 \ub9ac\ud134\ud569\ub2c8\ub2e4.\uc989, \uc8fc\uc18c\uc758 \uc808\ub300\ucc38\uc870\uac00 \uc9c0\uc815\ub418\ub294 \uac83\uc774\uc9c0\uc694.\uadf8\ub9ac\uace0 \ub9d0 \uadf8\ub300\ub85c \uc8fc\uc18c\uac00 \ub9ac\ud134\ub418\uae30 \ub54c\ubb38\uc5d0 \uc8fc\uc18c\uc5d0 \ub300\ud55c \uacb0\uacfc\uac00 \ub9ac\ud134\ub418\ub294 \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4.\uadf8\ub798\uc11c \uc81c\ub300\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 Indirect \uba85\ub839\uacfc \ud63c\ud569\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. =INDIRECT(ADDRESS(1,1),TRUE) \uc774\ub807\uac8c \ub9d0\uc785\ub2c8\ub2e4.\uc608\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc790 \uc774\uc81c \uc774\uac78 \uc5b4\ub514\uc5d0 \uc4f8\uac83\uc774\ub0d0 \ud558\uba74, \ubc14\ub85c Match, Index \uba85\ub839\uc5b4\uc5d0 \uc0ac\uc6a9\ud560 \uc608\uc815\uc785\ub2c8\ub2e4.\uad81\uae08\ud558\uc2e0\uac00\uc694? \u314e\u314e\u314e\uc77c\ub2e8 \ub3c4\uc11c\uc6a9 \uac80\uc0c9\uc744 \uc704\ud55c \ud504\ub85c\uadf8\ub7a8\uc774\ub77c\uace0 \uac00\uc815\ud558\uace0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcc4\uac74 \uc544\ub2c8\uace0, \uc77c\ub2e8 \uac80\uc0c9 \uae30\uc900\uacfc \ucd9c\ub825 \ub0b4\uc6a9\uc744 \uc815\ud558\uc5ec \uacb0\uacfc\ubb3c\uc744 \ucd9c\ub825\ud558\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.\ubcf4\uc2dc\uba74 \ucc45 \uc81c\ubaa9 “\uace0\uc591\uc774 \ud574\uacb0\uc0ac \uae5c\ub0e5 2″\uc758 \ucd9c\ud310\uc0ac\ub97c \ubb3c\uc5b4\ubcf8 \uacb0\uacfc\uc785\ub2c8\ub2e4.(\uace0\uc591\uc774 \ud574\uacb0\uc0ac \uae5c\ub0e5\uc740 \uc6b0\ub9ac \ucc44\ub791\uc774\uac00 \uc88b\uc544\ud558\ub294 \ucc45\uc785\ub2c8\ub2e4. \u314e\u314e TMI) \ubcf4\ub2e4\uc2dc\ud53c Match, Index, Indirect, Address 4\uac1c\uc758 \uba85\ub839\uc5b4\ub97c \uc798 \uc0ac\uc6a9\ud558\uba74 \uc704\uc640 \uac19\uc740 \uac80\uc0c9 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc815\ub9d0 \ub2e4\uc591\ud55c \uac80\uc0c9\uc744 \ud558\uae30\uc704\ud574\uc11c\ub294 \ucd94\uac00\ub85c, \uc218\uc2dd\uc774 \ud544\uc694\ud558\uaca0\uc9c0\ub9cc \ub2e8\uc21c\ud55c \uac80\uc0c9\uc6a9\ub3c4\ub85c\ub294 \ucda9\ubd84\ud569\ub2c8\ub2e4.\ub300\ucda9 \uac10\uc774 \uc7a1\ud788\uc2dc\ub098\uc694? \ud55c\ubc88\uc529 \ud574\ubcf4\uc2dc\uba74 \uc27d\uac8c \uc774\ud574\ud558\uc2e4 \uc218 \uc788\uc73c\uc2e4 \uac70\uc5d0\uc694.\uc5b4\uca4c\uba74 \ub9ce\uc774 \uc0ac\uc6a9\ud560 \uc77c\uc740 \uc5c6\uaca0\uc9c0\ub9cc, \uadf8\ub798\ub3c4 \ud558\ub098\uc529 \uc54c\uc544\ub450\uba74 \ub098\uc058\uc9c0 \uc54a\uc744 \uac83 \uac19\uc2b5\ub2c8\ub2e4. \uc790 \uc624\ub298\ub3c4 \uc5ec\uae30\uae4c\uc9c0 \uc4f0\uaca0\uc2b5\ub2c8\ub2e4. \uc88b\uc740 \ud558\ub8e8 \ub418\uc138\uc694 ^^<\/p>\n","protected":false},"author":1,"featured_media":731,"comment_status":"open","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":[186,142,156,185,155,147,141,187,161],"class_list":["post-729","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-address","tag-excel-2","tag-index","tag-indirect","tag-match","tag-147","tag-141","tag-187","tag-161"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/729","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=729"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/729\/revisions"}],"predecessor-version":[{"id":733,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/729\/revisions\/733"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/731"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}