{"id":12065,"date":"2017-05-19T10:55:16","date_gmt":"2017-05-19T01:55:16","guid":{"rendered":"https:\/\/promonista.com\/?p=12065"},"modified":"2026-02-09T16:06:49","modified_gmt":"2026-02-09T07:06:49","slug":"excel_functions_101","status":"publish","type":"post","link":"https:\/\/www.willgate.co.jp\/promonista\/excel_functions_101\/","title":{"rendered":"VLOOKUP\u95a2\u6570\u306f\u4f7f\u3046\u306a\uff01\u8ab0\u3082\u6559\u3048\u3066\u304f\u308c\u306a\u3044Excel\u95a2\u6570\u306e\u4fbf\u5229\u306a\u4f7f\u3044\u65b9\uff08\u7b2c1\u56de\uff09"},"content":{"rendered":"<p>\u4eca\u56de\u306f\u3044\u3064\u3082\u306e\u8a18\u4e8b\u3068\u306f\u6bdb\u8272\u3092\u5909\u3048\u3066\u3001\u666e\u6bb5\u306e\u696d\u52d9\u306b\u4f7f\u3048\u305d\u3046\u306a\u30c6\u30af\u30cb\u30c3\u30af\u7cfb\u306e\u3082\u306e\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u984c\u3057\u3066\u300c\u8ab0\u3082\u6559\u3048\u3066\u304f\u308c\u306a\u3044Excel\u95a2\u6570\u306e\u4fbf\u5229\u306a\u4f7f\u3044\u65b9\uff08\u7b2c1\u56de\uff09\u300d<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u306fExcel\u306e\u95a2\u6570\u306b\u591a\u5c11\u306f\u6163\u308c\u3066\u3044\u308b\u4eba\u304c\u6b21\u306e\u30ef\u30f3\u30b9\u30c6\u30c3\u30d7\u3092\u8e0f\u307f\u51fa\u305b\u308b\u3088\u3046\u306b\u306a\u308b\u3053\u3068\u3092\u76ee\u7684\u3068\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u305d\u306e\u70ba\u3001\u4e00\u3064\u3072\u3068\u3064\u306e\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306a\u3069\u306e\u8a71\u306f\u7701\u304b\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3059\u3002<br \/>\n\u4e88\u3081\u3054\u4e86\u627f\u304f\u3060\u3055\u3044\u307e\u305b\u3002<\/p>\n<div class=\"a-single a-15\"><div class=\"cta_blog\">\r\n<a href=\"https:\/\/www.willgate.co.jp\/promonista\/download\/web_marketing_kpi\/\" class=\"cta_blog_inner\" target=\"_blnak\">\r\n        <div class=\"cta_blog_img\">\r\n            <img decoding=\"async\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2023\/12\/c3cbf2209596fe160b074b2768b4d82e.jpg\">\r\n        <\/div>\r\n        <div class=\"cta_blog_body\">\r\n            <div class=\"cta_blog_ttl\">\u306a\u305cKPI\u8a2d\u8a08\u304c\u5927\u5207\u306a\u306e\u304b\uff1f<\/div>\r\n            <p>Web\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u306e\u6210\u679c\u3092\u6700\u5927\u5316\u3057\u3001\u7af6\u4e89\u306e\u6fc0\u3057\u3044\u5e02\u5834\u74b0\u5883\u3067\u6210\u529f\u3092\u53ce\u3081\u308b\u305f\u3081\u306e\u30ab\u30ae\u3068\u3057\u3066\u3001SEO\u652f\u63f4\u4f1a\u793e\u306e\u30a6\u30a3\u30eb\u30b2\u30fc\u30c8\u304c\u793e\u5185\u3067\u5229\u7528\u3057\u3066\u3044\u308b\u300e\u76ee\u6a19\u9054\u6210\u306e\u305f\u3081\u306eKPI\u306e\u8003\u3048\u65b9\u30fb\u7acb\u3066\u65b9\r\n\u300f\u3092\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\r\n            <div class=\"cta_body_btn\"><span>\u7121\u6599\u3067\u4eca\u3059\u3050\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><\/div>\r\n        <\/div>\r\n    <\/a>\r\n<\/div><\/div>\n<p><span data-sheets-root=\"1\"><div class=\"a-single a-25\"><div style=\"border: 3px solid #64aee3; padding: 20px 10px 10px 10px; margin-bottom: 15px;\">\r\n    <div class=\"kiji_bottom_links\">\r\n        <p style=\"text-align: center;\">\r\n            <strong>\uff3c\u300cSEO\u5bfe\u7b56\u300d\u30671\u4f4d\u3092\u53d6\u3063\u305f\u5f0a\u793e\u306eSEO\u00d7AI\u6d3b\u7528\u30ce\u30a6\u30cf\u30a6\u3092\u7121\u6599\u914d\u5e03\uff01\uff0f<\/strong>\r\n        <\/p>\r\n        <p style=\"box-shadow: rgba(0, 0, 0, 0.2) 5px 5px 5px; text-align: center;\">\r\n            <a class=\"gofollow\" data-track=\"MjUsMCw2MA==\" id=\"cta-click-dl-a\" href=\"https:\/\/www.willgate.co.jp\/promonista\/download\/seo_guide\/\">\r\n                \u4eca\u3059\u3050\u8cc7\u6599\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\uff08\u7121\u6599\uff09\u300b\r\n            <\/a>\r\n        <\/p>\r\n    <\/div>\r\n<\/div><\/div><\/span><\/p>\n\n<div class=\"a-single a-20\"><div style=\"margin: 30px 0 50px;\">\r\n<p style=\"text-align: center;\"><span style=\"font-size: 120%;    background: linear-gradient(transparent 50%, #ffff66 0%);    line-height: 1.3em;\">\u300c\u81ea\u5206\u3067SEO\u306e\u7591\u554f\u3092\u8abf\u3079\u308b\u306e\u306f\u5927\u5909\u300d<br>\u3068\u3044\u3046\u65b9\u306f\u30a6\u30a3\u30eb\u30b2\u30fc\u30c8\u306b\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\r\n<div style=\"text-align: center;margin: 30px 0;\"><a href=\"https:\/\/www.willgate.co.jp\/promonista\/service_list\/seoconsulting\/contact.html?utm_source=organic&amp;utm_medium=article&amp;utm_campaign=promo_maincontents_inquirybanner&amp;inflow=seo-article\"><img decoding=\"async\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2024\/03\/SEO_inquiry_banner300.png\" style=\"text-align: center;\"><\/a><\/div>\r\n<p>\u300c\u81ea\u793e\u30b5\u30a4\u30c8\u306b\u306f\u3069\u3093\u306aSEO\u6539\u5584\u3092\u3059\u308c\u3070\u826f\u3044\u306e\u304b\uff1f\u300d\u300c\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u5909\u52d5\u3067\u5f71\u97ff\u3092\u53d7\u3051\u305f\u30b5\u30a4\u30c8\u3092\u5f37\u5316\u3059\u308b\u306b\u306f\u3069\u3046\u3057\u305f\u3089\u826f\u3044\u306e\u304b\uff1f\u300d\u306a\u3069\u3001\u307e\u3060\u5177\u4f53\u7684\u306b\u30b5\u30fc\u30d3\u30b9\u5c0e\u5165\u3092\u691c\u8a0e\u3057\u3066\u3044\u306a\u3044\u65b9\u3082\u304a\u6c17\u8efd\u306b\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\r\n<div style=\"text-align: center;font-size: 125%;font-weight: 600;\"><a href=\"https:\/\/www.willgate.co.jp\/promonista\/service_list\/seoconsulting\/contact.html?utm_source=organic&amp;utm_medium=article&amp;utm_campaign=promo_maincontents_inquirybanner&amp;inflow=seo-article\">\uff1e\uff1e \u3054\u76f8\u8ac7\u306f\u3053\u3061\u3089\u304b\u3089<\/a><\/div>\r\n<\/div><\/div>\n<h2>VLOOKUP\u95a2\u6570\u306f\u4f7f\u3046\u306a<\/h2>\n<p>\u3059\u3044\u307e\u305b\u3093\u3002\u3044\u304d\u306a\u308aVLOOKUP\u95a2\u6570\u3092\u5168\u5426\u5b9a\u3057\u307e\u3057\u305f\u3002<br \/>\nVLOOKUP\u95a2\u6570\u306f\u3068\u3066\u3082\u4fbf\u5229\u3067\u4f7f\u3044\u3084\u3059\u3044\u95a2\u6570\u306a\u306e\u3067\u3059\u304c\u3001\u3044\u304b\u3093\u305b\u3093\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u4f7f\u3044\u306b\u304f\u3044\u306e\u3067\u500b\u4eba\u7684\u306b\u306f\u3042\u307e\u308a\u304a\u3059\u3059\u3081\u3057\u306a\u3044\u95a2\u6570\u3067\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3069\u3046\u3044\u3046\u3053\u3068\u304b\u3001\u7c21\u5358\u306b\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u3042\u306a\u305f\u306f\u65e5\u3005\u5546\u54c1\u306e\u5024\u6bb5\u3092\u8abf\u67fb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<br \/>\n\u53d6\u308a\u6271\u3063\u3066\u3044\u308b\u5546\u54c1\u306e\u5024\u6bb5\u306e\u4e00\u89a7\u306f\u3001\u7ba1\u7406\u90e8\u9580\u304c\u65e5\u3005\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306b\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12075\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook1.jpg\" alt=\"\" width=\"396\" height=\"272\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook1.jpg 396w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook1-100x70.jpg 100w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook1-218x150.jpg 218w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/p>\n<p>\u305d\u3057\u3066\u3001VLOOKUP\u95a2\u6570\u3092\u4f7f\u3048\u3070\u4e0b\u56f3\u306e\u3088\u3046\u306bID\u90e8\u5206\u3067\u5024\u6bb5\u3084\u5546\u54c1\u540d\u3092\u5f15\u3063\u5f35\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12076\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook2.jpg\" alt=\"\" width=\"1060\" height=\"267\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook2.jpg 1060w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook2-640x161.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook2-768x193.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook2-1024x258.jpg 1024w\" sizes=\"auto, (max-width: 1060px) 100vw, 1060px\" \/><\/p>\n<p>\u3068\u3066\u3082\u4fbf\u5229\u3067\u3059\u306d\u3002<br \/>\n\u3057\u304b\u3057VLOOKUP\u95a2\u6570\u306b\u306f2\u3064\u306e\u843d\u3068\u3057\u7a74\u304c\u5b58\u5728\u3057\u307e\u3059\u3002<br \/>\n\u307e\u305a\u4e00\u3064\u306f\u3001\u691c\u7d22\u5f15\u6570\u3068\u3059\u308bID\u90e8\u5206\u304c\u5f15\u3063\u3071\u3063\u3066\u304d\u305f\u3044\u30c7\u30fc\u30bf\u3088\u308a\u5de6\u5074\u306b\u3042\u308b\u5834\u5408\u3057\u304b\u4f7f\u3048\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<br \/>\n\u3064\u307e\u308a\u4e0b\u8a18\u306e\u3088\u3046\u306bID\u90e8\u5206\u304c\u5024\u6bb5\u3088\u308a\u53f3\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\u306b\u306f\u4f7f\u3048\u307e\u305b\u3093\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12077\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook3.jpg\" alt=\"\" width=\"739\" height=\"262\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook3.jpg 739w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook3-640x227.jpg 640w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/p>\n<p>\u4eca\u56de\u306e\u4f8b\u3067\u306f\u3042\u307e\u308a\u305d\u3046\u3044\u3063\u305f\u3053\u3068\u306f\u7121\u3044\u3067\u3057\u3087\u3046\u304c\u3001\u4f8b\u3048\u3070\u5024\u6bb5\u304b\u3089\u5546\u54c1\u540d\u3092\u5f15\u3063\u3071\u308a\u305f\u304f\u306a\u3063\u305f\u5834\u5408\u3067\u306fVLOOKUP\u304c\u4f7f\u3048\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u307e\u305f\u3001\u3069\u3053\u304b\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u9806\u3092\u5165\u308c\u66ff\u3048\u305f\u3044\u3068\u3044\u3063\u305f\u30cb\u30fc\u30ba\u3082\u3042\u308b\u3067\u3057\u3087\u3046\u3002<br \/>\n\u305d\u3046\u3057\u305f\u3068\u304d\u306b\u8aad\u307f\u8fbc\u307f\u30c6\u30fc\u30d6\u30eb\u3092\u65b0\u305f\u306b\u4f5c\u308a\u76f4\u3055\u306a\u3044\u3068\u3044\u3051\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<p>\u305d\u3057\u3066\u3082\u3046\u4e00\u3064\u306f\u3001\u9014\u4e2d\u3067\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u3092\u5897\u3084\u3059\u5fc5\u8981\u304c\u3042\u3063\u305f\u5834\u5408\u306b\u3001\u95a2\u6570\u304c\u58ca\u308c\u3066\u3057\u307e\u3046\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<br \/>\n\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306b\u7523\u5730\u306e\u60c5\u5831\u3082\u5165\u529b\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u3001\u8aad\u307f\u8fbc\u307f\u5074\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u610f\u56f3\u3057\u306a\u3044\u30c7\u30fc\u30bf\u3092\u53d6\u3063\u3066\u304d\u3066\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12079\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook4.jpg\" alt=\"\" width=\"1178\" height=\"266\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook4.jpg 1178w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook4-640x145.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook4-768x173.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook4-1024x231.jpg 1024w\" sizes=\"auto, (max-width: 1178px) 100vw, 1178px\" \/><\/p>\n<p>\u3053\u308c\u306f\u3001VLOOKUP\u95a2\u6570\u306e3\u3064\u76ee\u306e\u5f15\u6570\u3067\u3001\u7bc4\u56f2\u306e3\u5217\u76ee\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u3063\u3066\u304f\u308b\u3068\u76f4\u63a5\u6307\u5b9a\u3057\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u3053\u3068\u306b\u8d77\u56e0\u3057\u307e\u3059\u3002<br \/>\n\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u3067\u306f3\u5217\u76ee\u306f\u300c\u5024\u6bb5\u300d\u3067\u306a\u304f\u300c\u7523\u5730\u300d\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u305f\u3081\u306b\u3053\u306e\u3088\u3046\u306a\u554f\u984c\u304c\u8d77\u3053\u3063\u305f\u306e\u3067\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12081\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook5.jpg\" alt=\"\" width=\"654\" height=\"317\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook5.jpg 654w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/vlook5-640x310.jpg 640w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/p>\n<div class='code-block code-block-default code-block-15'>\n<strong><a href=\"https:\/\/tact-seo.com\/?utm_source=promonista&amp;utm_medium=tact-article-middle&amp;utm_campaign=tact-article-middle&amp;rid=promonista\" id=\"tact-article-middle\">\u25a0SEO\u8ab2\u984c\u3092\u81ea\u52d5\u62bd\u51fa\u3059\u308b \u4e0a\u4f4d\u8868\u793a\u652f\u63f4SEO\u30c4\u30fc\u30eb<\/a><\/strong><a href=\"https:\/\/tact-seo.com\/?utm_source=promonista&amp;utm_medium=tact-article-middle&amp;utm_campaign=tact-article-middle&amp;rid=promonista\" id=\"tact-article-middle\"><img decoding=\"async\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2021\/12\/image5.png\" \/><\/a><\/div>\n\n<h2>\u8907\u6570\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3059\u308b<\/h2>\n<p>\u3053\u306e\u3088\u3046\u306bVLOOKUP\u95a2\u6570\u3092\u5358\u4e00\u3067\u4f7f\u3063\u3066\u3044\u308b\u3068\u3001\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u306e\u5909\u66f4\u306b\u67d4\u8edf\u306b\u5bfe\u5fdc\u3067\u304d\u307e\u305b\u3093\u3002<br \/>\n\u65e5\u3005\u8907\u6570\u306e\u4eba\u304c\u4f7f\u3046\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u30d5\u30a1\u30a4\u30eb\u306b\u3059\u308b\u306b\u306f\u3001\u90fd\u5ea6\u306e\u4fee\u6b63\u304c\u5fc5\u8981\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u3042\u307e\u308a\u5411\u3044\u3066\u3044\u306a\u3044\u306e\u3067\u3059\u3002<br \/>\n\u3067\u304d\u308b\u3060\u3051\u666e\u904d\u7684\u306b\u4f7f\u3044\u7d9a\u3051\u308b\u306b\u306f\u3001\u8907\u6570\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u306e\u3088\u3046\u306aVLOOKUP\u95a2\u6570\u3092\u7f6e\u304d\u63db\u3048\u308b\u5834\u5408\u306b\u306f\u3001\u6b21\u306e\u95a2\u6570\u305f\u3061\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li>INDEX\u95a2\u6570<\/li>\n<li>MATCH\u95a2\u6570<\/li>\n<li>COLMUN\u95a2\u6570<\/li>\n<\/ul>\n<p>\u5148\u306b\u6b63\u89e3\u3092\u898b\u305b\u308b\u3068\u3001\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12084\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index1.jpg\" alt=\"\" width=\"1301\" height=\"254\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index1.jpg 1301w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index1-640x125.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index1-768x150.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index1-1024x200.jpg 1024w\" sizes=\"auto, (max-width: 1301px) 100vw, 1301px\" \/><\/p>\n<p><span style=\"color: #ff0000;\">=INDEX(\u30c6\u30fc\u30d6\u30eb1,MATCH([@\u767a\u6ce8ID],\u30c6\u30fc\u30d6\u30eb1[ID],0),COLUMN(\u30c6\u30fc\u30d6\u30eb1[\u5024\u6bb5])-COLUMN(\u30c6\u30fc\u30d6\u30eb1)+1)<\/span><\/p>\n<p>\u3053\u306e\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u5927\u5207\u306a\u90e8\u5206\u306f<br \/>\n\u300cCOLUMN(\u30c6\u30fc\u30d6\u30eb1[\u5024\u6bb5])-COLUMN(\u30c6\u30fc\u30d6\u30eb1)+1\u300d<br \/>\n\u3053\u306e\u90e8\u5206\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u90e8\u5206\u3092\u6570\u5b57\u3067\u8a18\u8ff0\u3057\u3066\u3057\u307e\u3046\u3068\u3001VLOOKUP\u95a2\u6570\u306e2\u3064\u76ee\u306e\u843d\u3068\u3057\u7a74\u3068\u540c\u3058\u3053\u3068\u304c\u8d77\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<br \/>\n\u307e\u305f\u3001\u306a\u305cINDEX\u95a2\u6570\u306e\u7b2c\u4e09\u5f15\u6570\u306b\u8a2d\u7f6e\u3057\u305fCOLUMN\u95a2\u6570\u3092\u5f15\u3044\u305f\u308a1\u3092\u8db3\u3057\u305f\u308a\u3057\u3066\u3044\u308b\u306e\u304b\u3068\u3044\u3046\u3068\u3001\u3053\u308c\u306fCOLUMN\u95a2\u6570\u304c\u5217\u756a\u53f7\u3092\u7d76\u5bfe\u53c2\u7167\u3057\u3066\u3057\u307e\u3046\u304b\u3089\u3067\u3059\u3002<br \/>\n\u3082\u3057\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306e\u5834\u6240\u304c\u305a\u308c\u305f\u5834\u5408\u3001\u30c7\u30fc\u30bf\u8aad\u307f\u8fbc\u307f\u304c\u3067\u304d\u306a\u304f\u306a\u3063\u305f\u308a\u3001\u610f\u56f3\u3057\u306a\u3044\u30c7\u30fc\u30bf\u3092\u53d6\u3063\u3066\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12087\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2.jpg\" alt=\"\" width=\"1126\" height=\"759\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2.jpg 1126w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2-640x431.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2-768x518.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2-1024x690.jpg 1024w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index2-623x420.jpg 623w\" sizes=\"auto, (max-width: 1126px) 100vw, 1126px\" \/><\/p>\n<p>\u305d\u306e\u70ba\u3001\u76ee\u7684\u306e\u5217\u6570\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u306e\u59cb\u70b9\u5217\u6570\u3092\u5f15\u3044\u3066\u3092\u8db3\u3059\u3053\u3068\u306b\u3088\u308a\u3001\u6307\u5b9a\u3057\u305f\u53c2\u7167\u7bc4\u56f2\u306b\u5bfe\u3057\u3066\u76f8\u5bfe\u7684\u306a\u5217\u756a\u53f7\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3042\u308c\u3070\u3001\u30de\u30b9\u30bf\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306e\u5897\u6e1b\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u81ea\u4f53\u306e\u79fb\u52d5\u306b\u5bfe\u5fdc\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3059\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12091\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1.jpg\" alt=\"\" width=\"1126\" height=\"465\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1.jpg 1126w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1-640x264.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1-768x317.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1-1024x423.jpg 1024w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index3-1-1017x420.jpg 1017w\" sizes=\"auto, (max-width: 1126px) 100vw, 1126px\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12093\" src=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4.jpg\" alt=\"\" width=\"1296\" height=\"582\" srcset=\"https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4.jpg 1296w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4-640x287.jpg 640w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4-768x345.jpg 768w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4-1024x460.jpg 1024w, https:\/\/www.willgate.co.jp\/promonista\/wp-content\/uploads\/2017\/05\/index4-935x420.jpg 935w\" sizes=\"auto, (max-width: 1296px) 100vw, 1296px\" \/><\/p>\n<p><span data-sheets-root=\"1\"><div class=\"a-single a-25\"><div style=\"border: 3px solid #64aee3; padding: 20px 10px 10px 10px; margin-bottom: 15px;\">\r\n    <div class=\"kiji_bottom_links\">\r\n        <p style=\"text-align: center;\">\r\n            <strong>\uff3c\u300cSEO\u5bfe\u7b56\u300d\u30671\u4f4d\u3092\u53d6\u3063\u305f\u5f0a\u793e\u306eSEO\u00d7AI\u6d3b\u7528\u30ce\u30a6\u30cf\u30a6\u3092\u7121\u6599\u914d\u5e03\uff01\uff0f<\/strong>\r\n        <\/p>\r\n        <p style=\"box-shadow: rgba(0, 0, 0, 0.2) 5px 5px 5px; text-align: center;\">\r\n            <a class=\"gofollow\" data-track=\"MjUsMCw2MA==\" id=\"cta-click-dl-a\" href=\"https:\/\/www.willgate.co.jp\/promonista\/download\/seo_guide\/\">\r\n                \u4eca\u3059\u3050\u8cc7\u6599\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\uff08\u7121\u6599\uff09\u300b\r\n            <\/a>\r\n        <\/p>\r\n    <\/div>\r\n<\/div><\/div><\/span><\/p>\n<h2>\u307e\u3068\u3081\u3068\u6b21\u56de\u4e88\u544a<\/h2>\n<p>\u4e00\u6642\u7684\u306a\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3067\u3042\u308c\u3070\u3001\u3053\u306e\u3088\u3046\u306a\u9762\u5012\u304f\u3055\u3044\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u3059\u308b\u5fc5\u8981\u306f\u5168\u304f\u3042\u308a\u307e\u305b\u3093\u3002<br \/>\n\u7d20\u76f4\u306bVLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u305f\u307b\u3046\u304c\u5727\u5012\u7684\u306b\u65e9\u3044\u3067\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u6bce\u65e5\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u96c6\u8a08\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u3001\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u306e\u5f62\u5f0f\u304c\u3042\u308b\u7a0b\u5ea6\u5909\u66f4\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u306a\u3089\u3001\u3053\u306e\u3088\u3046\u306b\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u5de5\u592b\u3059\u308b\u3053\u3068\u3067\u4e88\u671f\u305b\u306c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u30a8\u30e9\u30fc\u3092\u6700\u5c0f\u9650\u306b\u7559\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u7b2c1\u56de\u3068\u3044\u3046\u3053\u3068\u3067\u3001INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3068\u3044\u3046\u300c\u305d\u308c\u6559\u3048\u3066\u3082\u3089\u3063\u305f\u3053\u3068\u3042\u308b\u3088\u300d\u3068\u8a00\u308f\u308c\u305d\u3046\u306a\u3082\u306e\u3092\u984c\u6750\u306b\u3057\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002<br \/>\n\u7b2c2\u56de\u306e\u63b2\u8f09\u3067\u66f8\u3053\u3046\u3068\u601d\u3063\u3066\u3044\u308b\u300c\u914d\u5217\u6570\u5f0f\u300d\u306e\u5e03\u77f3\u306e\u305f\u3081\u3068\u3044\u3046\u8a00\u3044\u8a33\u3092\u304a\u8a31\u3057\u4e0b\u3055\u3044\u3002<\/p>\n<p>\u6b21\u56de\u306f\u691c\u7d22\u5f15\u6570\u304c255\u6587\u5b57\u3088\u308a\u5927\u304d\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u5834\u5408\u306e\u30c7\u30fc\u30bf\u306e\u5f15\u7528\u306b\u3064\u3044\u3066\u3001\u4eca\u56de\u306eINDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u306e\u5fdc\u7528\u4e8b\u4f8b\u3092\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u307e\u305f\u3001\u300c\u30a8\u30af\u30bb\u30eb\u3067\u3053\u3093\u306a\u5834\u5408\u306b\u56f0\u3063\u3066\u3044\u308b\u300d\u3068\u3044\u3046\u3088\u3046\u306a\u3053\u3068\u304c\u3042\u308c\u3070\u3001\u306f\u3066\u30d6\u306e\u30b3\u30e1\u30f3\u30c8\u306b\u8a18\u8f09\u3044\u305f\u3060\u3051\u308c\u3070\u4eca\u5f8c\u306e\u8a18\u4e8b\u306e\u30cd\u30bf\u306b\u306a\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u3067\u3059\u3002<\/p>\n<div class='code-block code-block-default code-block-16'>\n<a href=\"https:\/\/tact-seo.com\/?utm_source=promonista&amp;utm_medium=tact-article-bottom&amp;utm_campaign=tact-article-bottom&amp;rid=promonista\" id=\"tact-article-bottom\"><strong>\u300cTACT SEO\u300d<\/strong><\/a>\u306f\u3001\u30ad\u30fc\u30ef\u30fc\u30c9\u8abf\u67fb\u3084\u65e5\u3005\u306e\u9806\u4f4d\u8a08\u6e2c\u3001\u30b5\u30a4\u30c8\u5185\u306eSEO\u8ab2\u984c\u306e\u767a\u898b\u306a\u3069SEO\u5bfe\u7b56\u3092\u884c\u3046\u305f\u3081\u306b\u5fc5\u8981\u306a\u6a5f\u80fd\u304c\u4e00\u3064\u306b\u306a\u3063\u305f\u30c4\u30fc\u30eb\u3067\u3059\u3002\n\u81ea\u793e\u30b5\u30a4\u30c8\u304c\u4e0a\u4f4d\u8868\u793a\u3067\u304d\u3066\u3044\u306a\u3044\u8981\u56e0\u3092\u7db2\u7f85\u7684\u306b\u5206\u6790\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\n\u5165\u529b\u6642\u9593\u306f30\u79d2\uff01\u7121\u6599\u7248\u3092\u305c\u3072\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002\n<br>\n<br>\nSEO\u306b\u95a2\u3057\u3066\u3001\u4f55\u304b\u3089\u7740\u624b\u3059\u3079\u304d\u304b\u308f\u304b\u3089\u306a\u3044\u3001\u306a\u304b\u306a\u304b\u6210\u679c\u304c\u3067\u306a\u3044\u306a\u3069\u306e\u304a\u60a9\u307f\u304c\u3054\u3056\u3044\u307e\u3057\u305f\u3089\n<strong><a href=\"https:\/\/willgate.co.jp\/promonista\/service_list\/seoconsulting\/?utm_source=organic&amp;utm_medium=article&amp;utm_campaign=seo-article-bottom&amp;inflow=seo-article\" id=\"seo-article-bottom\">SEO\u7121\u6599\u76f8\u8ac7<\/a><\/strong>\u3082\u53d7\u3051\u4ed8\u3051\u3066\u304a\u308a\u307e\u3059\u306e\u3067\u3001\u304a\u6c17\u8efd\u306b\u304a\u554f\u5408\u305b\u304f\u3060\u3055\u3044\u3002<\/div>\n\n<pre>\u25bc\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3093\u3060\u3042\u306a\u305f\u306b\u304a\u3059\u3059\u3081!\r\n\r\n<a href=\"https:\/\/www.willgate.co.jp\/promonista\/content-map\/\">\u30b3\u30f3\u30c6\u30f3\u30c4\u30de\u30c3\u30d7\u306e\u4f5c\u6210\u65b9\u6cd5\u3068\u4f7f\u3048\u308b\u30c4\u30fc\u30eb\u307e\u3068\u3081\u3010\u30b3\u30f3\u30c6\u30f3\u30c4\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u57fa\u790e\u7de8\u3011<\/a>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u56de\u306f\u3044\u3064\u3082\u306e\u8a18\u4e8b\u3068\u306f\u6bdb\u8272\u3092\u5909\u3048\u3066\u3001\u666e\u6bb5\u306e\u696d\u52d9\u306b\u4f7f\u3048\u305d\u3046\u306a\u30c6\u30af\u30cb\u30c3\u30af\u7cfb\u306e\u3082\u306e\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002 \u984c\u3057\u3066\u300c\u8ab0\u3082\u6559\u3048\u3066\u304f\u308c\u306a\u3044Excel\u95a2\u6570\u306e\u4fbf\u5229\u306a\u4f7f\u3044\u65b9\uff08\u7b2c1\u56de\uff09\u300d \u3053\u306e\u8a18\u4e8b\u306fExcel\u306e\u95a2\u6570\u306b\u591a\u5c11\u306f\u6163\u308c\u3066\u3044\u308b\u4eba\u304c\u6b21\u306e\u30ef\u30f3\u30b9&#8230;<\/p>\n","protected":false},"author":86,"featured_media":12106,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-12065","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-etcweb"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/posts\/12065","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/users\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/comments?post=12065"}],"version-history":[{"count":41,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/posts\/12065\/revisions"}],"predecessor-version":[{"id":33174,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/posts\/12065\/revisions\/33174"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/media\/12106"}],"wp:attachment":[{"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/media?parent=12065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/categories?post=12065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.willgate.co.jp\/promonista\/wp-json\/wp\/v2\/tags?post=12065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}