{"id":108,"date":"2023-07-23T02:19:45","date_gmt":"2023-07-22T17:19:45","guid":{"rendered":"https:\/\/exceljump.com\/?p=108"},"modified":"2023-08-26T13:50:14","modified_gmt":"2023-08-26T04:50:14","slug":"index-match","status":"publish","type":"post","link":"https:\/\/exceljump.com\/index-match\/","title":{"rendered":"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p class=\"has-medium-font-size\">\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX\ud568\uc218\uc640 MATCH\ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION-1024x1024.png\" alt=\"INDEX MATCH \ud568\uc218\uc758 \uae30\ucd08 \uc124\uba85 \uc785\ub2c8\ub2e4. \" class=\"wp-image-112\" style=\"width:444px;height:444px\" width=\"444\" height=\"444\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION-1024x1024.png 1024w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION-300x300.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION-150x150.png 150w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION-768x768.png 768w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png 1080w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/figure><\/div>\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_67_1 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >CONTENTS<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #2250d8;color:#2250d8\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #2250d8;color:#2250d8\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/exceljump.com\/index-match\/#index-match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%84%a4%eb%aa%85\" title=\" INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85\"> INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/exceljump.com\/index-match\/#index-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%a0%95%ec%9d%98\" title=\" INDEX \ud568\uc218 \uae30\ucd08 \uc815\uc758\"> INDEX \ud568\uc218 \uae30\ucd08 \uc815\uc758<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/exceljump.com\/index-match\/#index-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\" title=\" INDEX \ud568\uc218 \uae30\ucd08 \uc608\uc81c\"> INDEX \ud568\uc218 \uae30\ucd08 \uc608\uc81c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/exceljump.com\/index-match\/#match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%a0%95%ec%9d%98\" title=\" MATCH \ud568\uc218 \uae30\ucd08 \uc815\uc758\"> MATCH \ud568\uc218 \uae30\ucd08 \uc815\uc758<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/exceljump.com\/index-match\/#match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\" title=\" MATCH \ud568\uc218 \uae30\ucd08 \uc608\uc81c\"> MATCH \ud568\uc218 \uae30\ucd08 \uc608\uc81c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/exceljump.com\/index-match\/#index-match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\" title=\"  INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc608\uc81c\">  INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc608\uc81c<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/exceljump.com\/index-match\/#index-match-%ed%95%a8%ec%88%98-%ed%99%9c%ec%9a%a9%ec%9d%98-%ec%9d%b4%ec%9c%a0\" title=\" INDEX MATCH \ud568\uc218 \ud65c\uc6a9\uc758 \uc774\uc720\"> INDEX MATCH \ud568\uc218 \ud65c\uc6a9\uc758 \uc774\uc720<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/exceljump.com\/index-match\/#index-match-%ed%95%a8%ec%88%98-%ed%99%9c%ec%9a%a9\" title=\" INDEX MATCH \ud568\uc218 \ud65c\uc6a9\"> INDEX MATCH \ud568\uc218 \ud65c\uc6a9<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/exceljump.com\/index-match\/#%ea%b2%b0%eb%a1%a0\" title=\"  \uacb0\ub860\">  \uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%84%a4%eb%aa%85\"><\/span><br><strong>INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size\">2\uac1c\uc758 \ud568\uc218\uc758 \uc870\ud569\uc73c\ub85c \ub418\uc5b4 \uc788\ub294 \ub9cc\ud07c \uac01\uac01\uc758 \ud568\uc218\ub97c \uc18c\uac1c\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%a0%95%ec%9d%98\"><\/span><br><strong>INDEX \ud568\uc218 \uae30\ucd08 \uc815\uc758<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">INDEX \ud568\uc218\ub780 \uc9c0\uc815\ud55c \ub370\uc774\ud130 \ubc94\uc704\ub0b4\uc758 \ud589, \uc5f4\uc758 \uc704\uce58\ub97c \uc785\ub825\ud558\uc5ec \uc9c0\uc815\ud55c \uac12\uc744 \ucd9c\ub825\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. <br>\ud568\uc218\uad6c\ubb38\uc744 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">=INDEX (\ub370\uc774\ud130 \ubc94\uc704, \ud589\uc704\uce58, \uc5f4\uc704\uce58)<\/mark><\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\"><\/span><br><strong>INDEX \ud568\uc218 \uae30\ucd08 <\/strong>\uc608\uc81c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">\uc544\ub798\uc758 \ub370\uc774\ud130\uc5d0\uc11c INDEX \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uc548\uc758 3\ubc88\uc9f8 \ud589, \ub370\uc774\ud130\uc758 4\ubc88\uc9f8 \uc5f4\uc5d0 \uc788\ub294 \uac12\uc744 \ucd9c\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\uc0ac\uc6a9\ub41c \ud568\uc218 \uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <br><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">G3 cell =INDEX(B3:E13,3,4)<\/mark><\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">OUTPUT 1300<\/mark><\/strong><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-1024x398.png\" alt=\"\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc9c0\uc815\ud55c \ud589, \uc5f4 \uc704\uce58\uac12\uc744 \ucd9c\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4.\" class=\"wp-image-109\" style=\"width:768px;height:299px\" width=\"768\" height=\"299\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-1024x398.png 1024w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-300x117.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-768x299.png 768w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-1536x597.png 1536w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX.png 1954w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%a0%95%ec%9d%98\"><\/span><br><strong>MATCH \ud568\uc218 \uae30\ucd08 <\/strong>\uc815\uc758<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">MATCH \ud568\uc218\ub294 VLOOKUP \ud568\uc218\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. \uadf8 \uc815\ub3c4\ub85c \ud65c\uc6a9\ub3c4\uac00 \ub192\ub2e4\uace0 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ucd08 \uc815\uc758\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\uc870\uac74 \uac12\uc744 \uc9c0\uc815\ud55c \ub370\uc774\ud130 \ubc94\uc704 \ub0b4\uc5d0\uc11c\uc758 \uc218\uc2dd\uc744 \uc774\uc6a9\ud558\uc5ec \ucc3e\uc740 \ub4a4, \uac12\uc758 \uc704\uce58\ub97c \uc22b\uc790\ub85c \ucd9c\ub825\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\"><\/span><br><strong>MATCH \ud568\uc218 \uae30\ucd08 <\/strong>\uc608\uc81c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">\uc544\ub798\uc758 \ub370\uc774\ud130\uc5d0\uc11c MATCH \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec KIM \uc758 \ud589\uc758 \uc704\uce58\ub97c \uc22b\uc790\ub85c \ucd9c\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\uc0ac\uc6a9\ub41c \ud568\uc218 \uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <br><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">G6 cell =MATCH(B5,B3:B13,0)<\/mark><\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">OUTPUT 3<\/mark><\/strong><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH-1024x398.png\" alt=\"MATCH \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \uc870\uac74\uac12\uc5d0 \ub9cc\uc871\ud558\ub294 \uc704\uce58 \uac12\uc744 \uc22b\uc790\ub85c \ucd9c\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4. \" class=\"wp-image-110\" style=\"width:768px;height:299px\" width=\"768\" height=\"299\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH-1024x398.png 1024w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH-300x117.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH-768x299.png 768w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH-1536x597.png 1536w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/MATCH.png 1954w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-match-%ed%95%a8%ec%88%98-%ea%b8%b0%ec%b4%88-%ec%98%88%ec%a0%9c\"><\/span><br><br><strong>INDEX MATCH \ud568\uc218 \uae30\ucd08 <\/strong>\uc608\uc81c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size\">\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294, \uc704\uc5d0\uc11c \uc124\uba85\ud55c \uac83\uacfc \uac19\uc774 INDEX\uc640 MATCH\ud568\uc218\uc758 \uae30\ucd08\ub97c \uc6b0\uc120\uc801\uc73c\ub85c \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc, \uadf8\uac83\ub9cc\uc73c\ub85c 100%\ub85c \ud65c\uc6a9\ud558\ub294 \uac83\uc740 \ubd88\uac00\ub2a5 \ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\ud568\uc218\uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <br><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">=INDEX(\ub370\uc774\ud130 \ubc94\uc704, MATCH(\ud589 \uc870\uac74\uac12, \ubc94\uc704, 0), MATCH(\uc5f4 \uc870\uac74\uac12, \ubc94\uc704, 0)<\/mark><\/strong><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-match-%ed%95%a8%ec%88%98-%ed%99%9c%ec%9a%a9%ec%9d%98-%ec%9d%b4%ec%9c%a0\"><\/span><br><strong>INDEX MATCH \ud568\uc218 \ud65c\uc6a9\uc758 \uc774\uc720<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">\uc5d1\uc140 INDEX MATCH\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uc774\uc720\ub294 2\uac00\uc9c0\ub85c \uc774\uc57c\uae30 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul>\n<li class=\"has-medium-font-size\">\uccab \ubc88\uc9f8 \uc774\uc720\ub294 \uc5d1\uc140 \ucc3e\uae30 \ud568\uc218 \uae30\ub2a5\uc744 100% \ud65c\uc6a9\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0, \uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/li>\n\n\n\n<li class=\"has-medium-font-size\">\ub450 \ubc88\uc9f8 \uc774\uc720\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\uc758 \ud615\ud0dc\ub97c \ud589\uacfc \uc5f4\uc758 \ubcc0\uacbd\uc73c\ub85c \uc0c8\ub85c\uc6b4 \ud615\ud0dc\uc758 \ub370\uc774\ud130\ub97c \ub9cc\ub4e4 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0,\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"index-match-%ed%95%a8%ec%88%98-%ed%99%9c%ec%9a%a9\"><\/span><br><strong>INDEX MATCH \ud568\uc218 <\/strong>\ud65c\uc6a9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"has-medium-font-size\">\ud568\uc218\uc758 \uc2e4\uc81c \ud65c\uc6a9\uc744 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc138\ub85c\ub85c \uc815\ub9ac\ub41c \ud56d\ubaa9\ubcc4 \ub370\uc774\ud130\uc758 \ud615\uc2dd\uc744 \uac00\ub85c\uc640 \uc138\ub85c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc740 \ud56d\ubaa9\ub4e4\uc744 \uad6c\ubd84\ud558\uc5ec \ubcc0\uacbd\ud558\uc600\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\uc0ac\uc6a9\ub41c \ud568\uc218\uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <br><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">H7 =INDEX($B$3:$E$13,MATCH(H$6,$D$3:$D$13,0),MATCH($G7,$B$2:$E$2,0))<\/mark><\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\">\uc0ac\uc6a9\ub41c \ud568\uc218\uc758 \uc62c\ubc14\ub978 \ud65c\uc6a9\uc744 \uc704\ud558\uc5ec <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\"><a href=\"https:\/\/exceljump.com\/absolute-reference-fixed-cell\/\" target=\"_blank\" rel=\"noreferrer noopener\">\uc808\ub300\ucc38\uc870<\/a><\/mark><\/strong> \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. <br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-1024x417.png\" alt=\"INDEX MATCH \ud568\uc218\uc640 \uc808\ub300\ucc38\uc870\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130 \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\ud558\uc600\uc2b5\ub2c8\ub2e4.\" class=\"wp-image-111\" style=\"width:768px;height:313px\" width=\"768\" height=\"313\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-1024x417.png 1024w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-300x122.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-768x313.png 768w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-1536x626.png 1536w, https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH.png 1866w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><span class=\"ez-toc-section\" id=\"%ea%b2%b0%eb%a1%a0\"><\/span><br><br>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\"><a href=\"https:\/\/exceljump.com\/vlookup-%eb%8b%a4%ec%a4%91%ec%a1%b0%ea%b1%b4\/\" target=\"_blank\" rel=\"noreferrer noopener\">VLOOKUP \ud568\uc218<\/a><\/mark><\/strong>\uc758 \ud55c\uacc4\uc778 \uc5ec\ub7ec \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uc5ec\ub7ec \uacb0\uacfc\ub97c \ub3d9\uc2dc\uc5d0 \ucd9c\ub825\ud558\ub294 \uc810\uc744 \ud574\uacb0 \ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc740 INDEX MATCH\ud568\uc218\uc758 \uc0ac\uc6a9\uc785\ub2c8\ub2e4. \ub610\ud55c \uc5d1\uc140 \ud568\uc218 \uc911 \ub370\uc774\ud130\uc758 \ubcc0\uacbd\uc744 \uc790\uc720\ub86d\uac8c \ud560 \uc218 \uc788\ub294 \uc218\uc2dd\uc740 <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\"><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576\" target=\"_blank\" rel=\"noreferrer noopener\">PIVOT<\/a><\/mark><\/strong> \uae30\ub2a5\uc744 \uc81c\uc678\ud558\uace0 INDEX MATCH\ud568\uc218\uac00 \uae30\ub2a5\uc801\uc73c\ub85c \ub9cc\uc871\ub3c4\uac00 \ub192\ub2e4\uace0 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">\ub9c8\uc9c0\ub9c9\uc73c\ub85c <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\"><a href=\"https:\/\/exceljump.com\/%ec%97%91%ec%85%80-offset\/\" target=\"_blank\" rel=\"noreferrer noopener\">OFFSET \uae30\ub2a5<\/a><\/mark><\/strong>\uc744 \ud65c\uc6a9\ud558\uc5ec \ub3d9\uc801 \ubc94\uc704\uae4c\uc9c0 \ud65c\uc6a9\ud55c\ub2e4\uba74 \ucd5c\uace0\uc758 \uc5d1\uc140 \ucc3e\uae30 \ud568\uc218\ub97c \ub9cc\ub4dc\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX\ud568\uc218\uc640 MATCH\ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4. INDEX MATCH &#8230;<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":112,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[104,65,105,108,109,110,106,107],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceljump.com\/index-match\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceljump.com\/index-match\/\" \/>\n<meta property=\"og:site_name\" content=\"EXCEL JUMPER\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T17:19:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-26T04:50:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keckec\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keckec\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceljump.com\/index-match\/\",\"url\":\"https:\/\/exceljump.com\/index-match\/\",\"name\":\"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)\",\"isPartOf\":{\"@id\":\"https:\/\/exceljump.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceljump.com\/index-match\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceljump.com\/index-match\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png\",\"datePublished\":\"2023-07-22T17:19:45+00:00\",\"dateModified\":\"2023-08-26T04:50:14+00:00\",\"author\":{\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d\"},\"description\":\"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceljump.com\/index-match\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceljump.com\/index-match\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/exceljump.com\/index-match\/#primaryimage\",\"url\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png\",\"contentUrl\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png\",\"width\":1080,\"height\":1080,\"caption\":\"\uc5d1\uc140 index match \ud568\uc218\uc758 \uae30\ucd08 \uc815\uc758\uc640 \uc2e4\uc804 \uc608\uc81c\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceljump.com\/index-match\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceljump.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceljump.com\/#website\",\"url\":\"https:\/\/exceljump.com\/\",\"name\":\"EXCEL JUMPER\",\"description\":\"excel formulas, excel functions, excel shortcut keys\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceljump.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d\",\"name\":\"Keckec\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g\",\"caption\":\"Keckec\"},\"sameAs\":[\"https:\/\/exceljump.com\"],\"url\":\"https:\/\/exceljump.com\/author\/keckec\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)","description":"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceljump.com\/index-match\/","og_locale":"en_US","og_type":"article","og_title":"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)","og_description":"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.","og_url":"https:\/\/exceljump.com\/index-match\/","og_site_name":"EXCEL JUMPER","article_published_time":"2023-07-22T17:19:45+00:00","article_modified_time":"2023-08-26T04:50:14+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png","type":"image\/png"}],"author":"Keckec","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Keckec","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceljump.com\/index-match\/","url":"https:\/\/exceljump.com\/index-match\/","name":"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)","isPartOf":{"@id":"https:\/\/exceljump.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceljump.com\/index-match\/#primaryimage"},"image":{"@id":"https:\/\/exceljump.com\/index-match\/#primaryimage"},"thumbnailUrl":"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png","datePublished":"2023-07-22T17:19:45+00:00","dateModified":"2023-08-26T04:50:14+00:00","author":{"@id":"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d"},"description":"\uc5d1\uc140 INDEX MATCH \ud568\uc218\ub294 \ucd5c\uace0 \uc218\uc900\uc758 LOOKUP \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud568\uc218 \uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0, VLOOKUP \ud568\uc218\uc758 \ub300\ud45c\uc801\uc778 \ub300\uccb4 \ud568\uc218\ub85c \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c INDEX \ud568\uc218\uc640 MATCH \ud568\uc218\ub85c \uc870\ud569\ub41c \ud568\uc218\uc785\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/exceljump.com\/index-match\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceljump.com\/index-match\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exceljump.com\/index-match\/#primaryimage","url":"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png","contentUrl":"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png","width":1080,"height":1080,"caption":"\uc5d1\uc140 index match \ud568\uc218\uc758 \uae30\ucd08 \uc815\uc758\uc640 \uc2e4\uc804 \uc608\uc81c\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4."},{"@type":"BreadcrumbList","@id":"https:\/\/exceljump.com\/index-match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceljump.com\/"},{"@type":"ListItem","position":2,"name":"INDEX MATCH \ud568\uc218 \uae30\ucd08 \uc124\uba85 \ubc0f \ud65c\uc6a9\ubc95 (VLOOKUP \uc5ec\ub7ec\uc870\uac74)"}]},{"@type":"WebSite","@id":"https:\/\/exceljump.com\/#website","url":"https:\/\/exceljump.com\/","name":"EXCEL JUMPER","description":"excel formulas, excel functions, excel shortcut keys","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceljump.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d","name":"Keckec","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exceljump.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g","caption":"Keckec"},"sameAs":["https:\/\/exceljump.com"],"url":"https:\/\/exceljump.com\/author\/keckec\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/exceljump.com\/wp-content\/uploads\/2023\/07\/INDEX-MATCH-DATA-CONVERSION.png","gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/108"}],"collection":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":3,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":296,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/108\/revisions\/296"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/media\/112"}],"wp:attachment":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}