{"id":3360,"date":"2021-02-03T15:19:39","date_gmt":"2021-02-03T06:19:39","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=3360"},"modified":"2025-09-15T18:11:54","modified_gmt":"2025-09-15T09:11:54","slug":"%ec%97%91%ec%85%80%ec%97%90%ec%84%9c-%eb%8b%a4%eb%a5%b8-%ed%8c%8c%ec%9d%bc-%ec%b0%b8%ec%a1%b0%ed%95%b4%ec%84%9c-vlookup-index-%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2021\/02\/03\/%ec%97%91%ec%85%80%ec%97%90%ec%84%9c-%eb%8b%a4%eb%a5%b8-%ed%8c%8c%ec%9d%bc-%ec%b0%b8%ec%a1%b0%ed%95%b4%ec%84%9c-vlookup-index-%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95\/","title":{"rendered":"\uc5d1\uc140: \ub2e4\ub978 \ud30c\uc77c \ucc38\uc870\ud574\uc11c VLOOKUP\/INDEX \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"
\n
\"\ud1b5\ud569\"<\/figure>\n<\/div>\n\n\n
<\/div>\n\n\n\n

<\/path><\/svg><\/span>\ubc29\ubc95<\/span><\/h4>\n\n\n\n
'[\ud30c\uc77c\uacbd\ub85c\/\ud30c\uc77c\uba85.xlsx]\uc2dc\ud2b8\uba85'!\ucc38\uc870\ubc94\uc704\n\n'\uc791\uc740 \ub530\uc634\ud45c \uc548\uc5d0 \uacbd\ub85c\uc640 \uc2dc\ud2b8\uba85\uae4c\uc9c0 \ud45c\uc2dc' + ! + \ucc38\uc870\ubc94\uc704\n \n\uc6081) '[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569'!$L:$L\n\uc6082) 'C:\\Users\\Tips\\EXCEL\\[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569'!$L:$L<\/pre>\n\n\n\n
<\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/path><\/svg><\/span>\uc0d8\ud50c\ub9c1\ud06c<\/span><\/h4>\n\n\n\n\n\uc5d1\uc140 \uc0d8\ud50c<\/a>\n\n\n\n\n
<\/div>\n\n\n\n
<\/path><\/svg><\/span>\uc124\uba85<\/span><\/h4>\n\n\n\n
\uc5d1\uc140 \ub808\uc2a8 \uc911\uc5d0 \ubd84\uc0b0\ub41c \ub370\uc774\ud130 \ud1b5\ud569\uc5d0 \ub300\ud55c \ubb38\uc758\uac00 \uaf64 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
\uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c\ub294 IMPORTRANGE, QUERY \ub85c \uac04\ub2e8\ud558\uac8c \uac00\ub2a5\ud558\uace0, \uc5d1\uc140\uc5d0\uc11c\ub294 \uacbd\ub85c \ucc38\uc870\ub85c \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n
\ud30c\uc6cc\ucffc\ub9ac\ub85c \ud558\ub294 \ubc29\ubc95\ub3c4 \uc788\uc9c0\ub9cc, \uc77c\ubc18\uc801\uc73c\ub85c \uc218\uc2dd\uc774 \ub2e4\uc591\ud558\uac8c \ud3ec\ud568\ub41c \uc2dc\ud2b8\ub294 \ud45c\ub85c \uc804\ud658\ud558\uba74 \ub370\uc774\ud130\uac00 \uc5d0\ub7ec\uac00 \ub098\uae30 \ub54c\ubb38\uc5d0, \uacbd\ub85c \ucc38\uc870\ub85c \ud558\ub294 \uac83\uc774 \ub0ab\ub2e4\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n
\n\n\n\n
\ub2e4\uc74c\uacfc \uac19\uc774 \ud574\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
'[\ud30c\uc77c\uacbd\ub85c\/\ud30c\uc77c\uba85.xlsx]\uc2dc\ud2b8\uba85'!\ucc38\uc870\ubc94\uc704\n\n'\uc791\uc740 \ub530\uc634\ud45c \uc548\uc5d0 \uacbd\ub85c\uc640 \uc2dc\ud2b8\uba85\uae4c\uc9c0 \ud45c\uc2dc' + ! + \ucc38\uc870\ubc94\uc704\n \n\uc6081) '[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569'!$L:$L\n\uc6082) 'C:\\Users\\user\\Tips\\EXCEL\\[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569'!$L:$L\n\uc6083) 'C:\\Users\\user\\Tips\\EXCEL\\[01\uc6d4.xlsx]'!\uacc4\uc815\uacfc\ubaa9 (\uacc4\uc815\uacfc\ubaa9\uc774\ub77c\ub294 \ubc94\uc704\uac00 \uc788\uc744 \uacbd\uc6b0)<\/pre>\n\n\n\n
\ucc38\uc870\ud560 \ud30c\uc77c\uc744 \ubaa8\ub450 \uc5f4\uc5b4 \ub193\uc740 \uc0c1\ud0dc\uc5d0\uc11c\ub294 \uc808\ub300\uacbd\ub85c\uac00 \ubcf4\uc774\uc9c0 \uc54a\uc9c0\ub9cc, \uc800\uc7a5\ud558\uace0 \ud30c\uc77c\uc744 \ub2eb\uc73c\uba74 \ucd94\ud6c4\uc5d0 \uc808\ub300 \uacbd\ub85c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n
\ud30c\uc77c\uc744 \ub2e4\ub978 \ud3f4\ub354\ub85c \uc774\ub3d9\uc2dc\ud0a4\ub294 \uacbd\uc6b0 \uc5d1\uc140\uc5d0\uc11c \uc5f0\uacb0 \uc624\ub958\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 > \uc5f0\uacb0 \ud3b8\uc9d1\uc5d0\uc11c \uc6d0\ubcf8 \ubcc0\uacbd\uc73c\ub85c \ud30c\uc77c\uc744 \uc5f0\uacb0\ud574\uc8fc\uba74 \ub2e4\uc2dc \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/p>\n\n\n
\n
\"\uc5f0\uacb0\ud3b8\uc9d1\"<\/figure>\n<\/div>\n\n\n
\n\n\n\n
\uc774\uc81c \ubc94\uc704\ub97c \uac00\uc838\uc654\uc73c\ub2c8, \ud574\ub2f9 \ubc94\uc704\uc5d0\uc11c VLOOKUP\/INDEX \ub97c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
\ucc38\uc870\ud558\ub294 \ud30c\uc77c\uc5d0 \uc774\ub984\uc774 \uc9c0\uc815\ub41c \ubc94\uc704\uac00 \uc788\ub2e4\uba74 \ud574\ub2f9 \ubc94\uc704\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5b4\uc11c \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
VLOOKUP(\ud0a4, \ubc94\uc704, \uc21c\ubc88, FALSE) \nINDEX(\ubc94\uc704, \ud589, \uc5f4)\n\n\uc608) INDEX('C:\\Users\\Tips\\EXCEL\\[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569'!$L:$L,$C3,1)\n\uc608) VLOOKUP(A1, 'C:\\Users\\user\\Tips\\EXCEL\\[01\uc6d4.xlsx]'!\uacc4\uc815\uacfc\ubaa9, 2, FALSE)<\/pre>\n\n\n\n

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

<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n
\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n
<\/p>\n\n\n\n
\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"
‘[\ud30c\uc77c\uacbd\ub85c\/\ud30c\uc77c\uba85.xlsx]\uc2dc\ud2b8\uba85’!\ucc38\uc870\ubc94\uc704 ‘\uc791\uc740 \ub530\uc634\ud45c \uc548\uc5d0 \uacbd\ub85c\uc640 \uc2dc\ud2b8\uba85\uae4c\uc9c0 \ud45c\uc2dc’ + ! + \ucc38\uc870\ubc94\uc704 \uc6081) ‘[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569’!$L:$L \uc6082) ‘C:\\Users\\Tips\\EXCEL\\[01\uc6d4.xlsx]3\uc0ac\ud1b5\ud569’!$L:$L \uc5d1\uc140 \ub808\uc2a8 \uc911\uc5d0 \ubd84\uc0b0\ub41c \ub370\uc774\ud130 \ud1b5\ud569\uc5d0 \ub300\ud55c \ubb38\uc758\uac00 \uaf64 \uc788\uc2b5\ub2c8\ub2e4. \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c\ub294 IMPORTRANGE, QUERY \ub85c \uac04\ub2e8\ud558\uac8c \uac00\ub2a5\ud558\uace0, \uc5d1\uc140\uc5d0\uc11c\ub294 \uacbd\ub85c \ucc38\uc870\ub85c \uac00\ub2a5\ud569\ub2c8\ub2e4. \ud30c\uc6cc\ucffc\ub9ac\ub85c \ud558\ub294 \ubc29\ubc95\ub3c4 \uc788\uc9c0\ub9cc, \uc77c\ubc18\uc801\uc73c\ub85c \uc218\uc2dd\uc774 \ub2e4\uc591\ud558\uac8c \ud3ec\ud568\ub41c \uc2dc\ud2b8\ub294 \ud45c\ub85c \uc804\ud658\ud558\uba74 \ub370\uc774\ud130\uac00 \uc5d0\ub7ec\uac00 \ub098\uae30 \ub54c\ubb38\uc5d0, \uacbd\ub85c \ucc38\uc870\ub85c \ud558\ub294 \uac83\uc774…<\/p>\n","protected":false},"author":1,"featured_media":3363,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5],"tags":[63,8,81,82,80],"class_list":["post-3360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","tag-index","tag-vlookup","tag-81","tag-82","tag-80"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=3360"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3360\/revisions"}],"predecessor-version":[{"id":17202,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3360\/revisions\/17202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/3363"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=3360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=3360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=3360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}