{"id":2643,"date":"2020-06-29T18:31:01","date_gmt":"2020-06-29T09:31:01","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=2643"},"modified":"2025-09-15T18:08:57","modified_gmt":"2025-09-15T09:08:57","slug":"vlookup-%ec%a0%81%ec%9a%a9%ed%95%a0-%eb%95%8c-n-a-%eb%82%98%ec%98%a4%ec%a7%80-%ec%95%8a%eb%8f%84%eb%a1%9d-%ec%b2%98%eb%a6%ac%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/29\/vlookup-%ec%a0%81%ec%9a%a9%ed%95%a0-%eb%95%8c-n-a-%eb%82%98%ec%98%a4%ec%a7%80-%ec%95%8a%eb%8f%84%eb%a1%9d-%ec%b2%98%eb%a6%ac%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95\/","title":{"rendered":"Vlookup \uc0ac\uc6a9\ud560 \ub54c, #N\/A \ub098\uc624\uc9c0 \uc54a\ub3c4\ub85d \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"\n<p>Vlookup \ud568\uc218\ub294 \uc2e4\ubb34\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc4f0\uc774\ub294 \uc720\uc6a9\ud55c \ud568\uc218\uc774\uc8e0. <\/p>\n\n\n\n<p>\uadf8\ub7f0\ub370 \ud589\uc774 \ucd94\uac00\ub420 \uac83\uc744 \uc0dd\uac01\ud574\uc11c<strong> Vlookup\uc744 \uc140\uc5d0 \ubbf8\ub9ac \ubd99\uc5ec \ub123\uc5b4\ub450\uba74<\/strong>, \ube48\uce78\uc744 \ucc38\uc870\ud558\uae30 \ub54c\ubb38\uc5d0 <strong>#N\/A \ub77c\uace0 \uc624\ub958\ub97c \ud45c\uc2dc<\/strong>\ud558\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=vlookup(A15,$A$7:$B$10,2,false)<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"916\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1024x916.png\" alt=\"Vlookup \uc801\uc6a9\ud560 \ub54c, #N\/A \ub098\uc624\uc9c0 \uc54a\ub3c4\ub85d \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\" class=\"wp-image-2684\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1024x916.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-300x268.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-768x687.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image.png 1157w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc5b4\ub5bb\uac8c \ud574\uc57c \ucc38\uc870\ud558\ub294 \uc140\uc774 \ube48\uce78\uc77c \ub54c, \ube48\uce78\uc73c\ub85c \ud45c\uc2dc\ud560 \uc218 \uc788\uc744\uae4c\uc694? <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h4 class=\"gb-headline gb-headline-e61c14a0\">\uc624\ub298\uc740 \ucc38\uc870\ud558\ub294 \uc140\uc774 \ube48\uce78\uc77c \ub54c #N\/A\uac00 \ub098\uc624\uc9c0 \uc54a\uac8c \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">\ub2f5\uc740, Vlookup\uc744 \ub3d9\uc791\ud558\uc9c0 \uc54a\ub3c4\ub85d IF \ub97c \uc0ac\uc6a9\ud574\uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4. <\/h5>\n\n\n\n<p>\ub9cc\uc57d \ud655\uc778\ud558\ub294 \uac12\uc774 \ube44\uc5b4\uc788\uc9c0 \uc54a\uc73c\uba74(D8&lt;&gt;&#8221;&#8221;) Vlookup\uc744 \uc2e4\ud589\ud558\uace0, \ube44\uc5b4\uc788\uc73c\uba74 \ube48 \uac12(&#8220;&#8221;)\uc744 \uc368\uc8fc\ub294 \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.  <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=if(D8&lt;&gt;\"\",vlookup(D8,$A$7:$B$10,2,false),\"\")<\/pre>\n\n\n\n<p>\ud568\uc218\ub97c \uc801\uc6a9\ud558\uba74, \uc544\ub798\uc640 \uac19\uc774 #N\/A\ub97c \ud45c\uc2dc\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"739\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-2.png\" alt=\"\" class=\"wp-image-2716\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-2.png 750w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-2-300x296.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h6 class=\"gb-headline gb-headline-b8090d4e\">\uc0d8\ud50c\uc744 \ud655\uc778\ud574\ubcf4\uc138\uc694. PC\ub97c \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/h6>\n\n\n\n<div class=\"gb-button-wrapper gb-button-wrapper-fbb71642\">\n\n<a class=\"gb-button gb-button-bba5be98 button\" href=\"https:\/\/vo.la\/Q4MA\"><span class=\"button-text\">\uc0d8\ud50c \ubcf4\uae30<\/span><\/a>\n\n<\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\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><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vlookup \ud568\uc218\ub294 \uc2e4\ubb34\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc4f0\uc774\ub294 \uc720\uc6a9\ud55c \ud568\uc218\uc774\uc8e0. \uadf8\ub7f0\ub370 \ud589\uc774 \ucd94\uac00\ub420 \uac83\uc744 \uc0dd\uac01\ud574\uc11c Vlookup\uc744 \uc140\uc5d0 \ubbf8\ub9ac \ubd99\uc5ec \ub123\uc5b4\ub450\uba74, \ube48\uce78\uc744 \ucc38\uc870\ud558\uae30 \ub54c\ubb38\uc5d0 #N\/A \ub77c\uace0 \uc624\ub958\ub97c \ud45c\uc2dc\ud558\uac8c \ub429\ub2c8\ub2e4. =vlookup(A15,$A$7:$B$10,2,false) \uc5b4\ub5bb\uac8c \ud574\uc57c \ucc38\uc870\ud558\ub294 \uc140\uc774 \ube48\uce78\uc77c \ub54c, \ube48\uce78\uc73c\ub85c \ud45c\uc2dc\ud560 \uc218 \uc788\uc744\uae4c\uc694? \ub2f5\uc740, Vlookup\uc744 \ub3d9\uc791\ud558\uc9c0 \uc54a\ub3c4\ub85d IF \ub97c \uc0ac\uc6a9\ud574\uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4. \ub9cc\uc57d \ud655\uc778\ud558\ub294 \uac12\uc774 \ube44\uc5b4\uc788\uc9c0 \uc54a\uc73c\uba74(D8&lt;&gt;&#8221;&#8221;) Vlookup\uc744 \uc2e4\ud589\ud558\uace0, \ube44\uc5b4\uc788\uc73c\uba74 \ube48 \uac12(&#8220;&#8221;)\uc744&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2684,"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":[10,9,7,8,11,12],"class_list":["post-2643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","tag-if","tag-n-a","tag-spreadsheet","tag-vlookup","tag-11","tag-12"],"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\/2643","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=2643"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2643\/revisions"}],"predecessor-version":[{"id":17198,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2643\/revisions\/17198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/2684"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=2643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=2643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=2643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}