{"id":11487,"date":"2023-01-23T10:00:50","date_gmt":"2023-01-23T01:00:50","guid":{"rendered":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487"},"modified":"2026-08-06T18:17:17","modified_gmt":"2026-08-06T09:17:17","slug":"%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%ef%bc%88excel%ef%bc%89%e3%81%a0%e3%81%91%e3%81%a7%e5%ae%9b%e5%90%8d%e3%83%a9%e3%83%99%e3%83%ab%e3%82%92%e5%8d%b0%e5%88%b7%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u4f5c\u6210\u3068\u5370\u5237\u3092\u30b9\u30e0\u30fc\u30ba\u306b\u884c\u3048\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u4f5c\u6210\u3068\u5370\u5237\u3092\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002VLOOKUP\u95a2\u6570\u306b\u3064\u3044\u3066\u3082\u89e3\u8aac\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u4f5c\u6210\u3068\u5370\u5237\u304c\u3067\u304d\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u306f\u8868\u8a08\u7b97\u306e\u30a4\u30e1\u30fc\u30b8\u304c\u5f37\u3044\u3068\u3044\u3048\u307e\u3059\u304c\u3001\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u4f5c\u6210\u3068\u5370\u5237\u3082\u3067\u304d\u308b\u30bd\u30d5\u30c8\u3067\u3059\u3002\u4ee5\u524d\u306f\u30e9\u30d9\u30eb\u5370\u5237\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u30012013Ver\u4ee5\u964d\u306f\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3057\u304b\u3057\u3001VLOOKUP\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u3001Excel\u3060\u3051\u3067\u7c21\u5358\u306b\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\u3068\u5370\u5237\u304c\u3067\u304d\u307e\u3059\u3002VLOOKUP\u95a2\u6570\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3067\u8a73\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VLOOKUP\u95a2\u6570\u306e\u5b9a\u7fa9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3068\u306f\u3001\u8868\u3092\u7e26\u65b9\u5411\u306b\u691c\u7d22\u3057\u3001\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u5fdc\u3059\u308b\u5024\u3092\u62bd\u51fa\u3059\u308bExcel\u95a2\u6570\u3067\u3059\u3002VLOOKUP\u306f\u300cVertical\u300d\uff08\u5782\u76f4\uff09\u306eV \u3068\u300cLOOKUP\u300d\uff08\u63a2\u3059\uff09\u3092\u610f\u5473\u3057\u307e\u3059\u3002VLOOKUP\u95a2\u6570\u306e\u6570\u5f0f\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u8868\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>VLOOKUP\u95a2\u6570\uff1dVLOOKUP(\u691c\u7d22\u5024,\u7bc4\u56f2,\u5217\u756a\u53f7,\u691c\u7d22\u306e\u578b)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u691c\u7d22\u5024\u3084\u7bc4\u56f2\u306a\u3069\u306e\u6982\u8981\u306b\u3064\u3044\u3066\u306f\u3001\u5f8c\u7a0b\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VLOOKUP\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u30e1\u30ea\u30c3\u30c8\u3068\u4e8b\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u30e1\u30ea\u30c3\u30c8\u306f\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u591a\u304f\u76ee\u8996\u3067\u63a2\u3057\u306b\u304f\u3044\u5834\u5408\u306b\u3082\u3001\u7c21\u5358\u306b\u6761\u4ef6\u306b\u5408\u3046\u5024\u3092\u62bd\u51fa\u3067\u304d\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b\u3048\u3070\u3001\u9867\u5ba2\u306e\u6c0f\u540d\u304b\u3089\u4f4f\u6240\u3092\u62bd\u51fa\u3057\u305f\u308a\u3001\u5546\u54c1\u4fa1\u683c\u3084\u5728\u5eab\u6570\u306a\u3069\u306e\u691c\u7d22\u3092\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u30c7\u30fc\u30bf\u306e\u5165\u529b\u6f0f\u308c\u306e\u30c1\u30a7\u30c3\u30af\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\u30111. \u5b9b\u5148\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u306b\u306f\u3001\u6700\u521d\u306b\u5b9b\u5148\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u306e\u6a2a\u8ef8\u306b\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u300c\u4f4f\u6240\u300d\u300c\u6c0f\u540d\u300d\u300c\u4f1a\u793e\u540d\u300d\u306a\u3069\u306e\u9805\u76ee\u3092\u3001\u30bb\u30eb\u3054\u3068\u306b\u5165\u529b\u3057\u307e\u3059\u3002\u300c\u6c0f\u540d\u300d\u306f\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u3001\u300c\u59d3\u300d\u300c\u540d\u300d\u306b\u5206\u3051\u3066\u3082\u3088\u3044\u3067\u3057\u3087\u3046\u3002\u300c\u69d8\u300d\u300c\u5fa1\u4e2d\u300d\u306a\u3069\u5b9b\u540d\u306e\u656c\u79f0\u3092\u4f7f\u3044\u5206\u3051\u308b\u5834\u5408\u306f\u3001\u9805\u76ee\u306b\u300c\u5b9b\u540d\u306e\u656c\u79f0\u300d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9805\u76ee\u3092\u4f5c\u6210\u3057\u7d42\u3048\u305f\u3089\u3001\u7e26\u8ef8\u306e\u30bb\u30eb\u3078\u5177\u4f53\u7684\u306a\u5185\u5bb9\u3092\u5165\u308c\u3066\u304f\u3060\u3055\u3044\u3002\u5b9b\u5148\u30ea\u30b9\u30c8\u306b\u306f\u3001\u5b9b\u540d\u30e9\u30d9\u30eb\u306b\u5fc5\u8981\u306e\u306a\u3044\u60c5\u5831\u3092\u8a18\u8f09\u3057\u3066\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u95a2\u9023\uff1a<a href=\"https:\/\/dm.bpsinc.jp\/blog\/?p=11188\">DM\u306e\u30ea\u30b9\u30c8\u3068\u306f\uff1f\u91cd\u8981\u6027\u3068\u3068\u3082\u306b\u5177\u4f53\u7684\u306a\u53d6\u5f97\u65b9\u6cd5\u3092\u89e3\u8aac<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\u30112. \u547c\u3073\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u306e\u8868\u793a\u30b9\u30da\u30fc\u30b9\u3092\u4f5c\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3067\u30c7\u30fc\u30bf\u3092\u547c\u3073\u51fa\u3059\u306b\u306f\u3001\u30c7\u30fc\u30bf\u3054\u3068\u306b\u7570\u306a\u308b\u30ca\u30f3\u30d0\u30fc\u3068\u8868\u793a\u3059\u308b\u30b9\u30da\u30fc\u30b9\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u3054\u3068\u306b\u30ca\u30f3\u30d0\u30fc\u3092\u632f\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3092\u5229\u7528\u3057\u3066\u3001\u30c7\u30fc\u30bf\u3092\u547c\u3073\u51fa\u3059\u306b\u306f\u3001\u30c7\u30fc\u30bf\u3054\u3068\u306b\u30ca\u30f3\u30d0\u30fc\u3092\u632f\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u6a2a\u8ef8\u306e\u4e00\u756a\u5de6\u4e0a\u5074\u306b\u300c\u30ca\u30f3\u30d0\u30fc\uff08No\uff09\u300d\u306e\u9805\u76ee\u3092\u4f5c\u308a\u3001\u30c7\u30fc\u30bf\u3054\u3068\u306b\u305d\u308c\u305e\u308c\u7570\u306a\u308b\u30ca\u30f3\u30d0\u30fc\u3092\u632f\u3063\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002\u30c7\u30fc\u30bf\u3054\u3068\u306b\u30ca\u30f3\u30d0\u30fc\u3092\u632f\u308b\u3068\u3001\u30ca\u30f3\u30d0\u30fc\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u3067\u8a72\u5f53\u3059\u308b\u30c7\u30fc\u30bf\u304c\u547c\u3073\u51fa\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b9b\u5148\u30ea\u30b9\u30c8\u306b\u8868\u793a\u30b9\u30da\u30fc\u30b9\u3092\u4f5c\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u3054\u3068\u306b\u30ca\u30f3\u30d0\u30fc\u3092\u632f\u308a\u7d42\u3048\u305f\u3089\u3001\u547c\u3073\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306e\u30b9\u30da\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u8868\u793a\u30b9\u30da\u30fc\u30b9\u306f\u3001\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u4e0a\u90e8\u304b\u4e0b\u90e8\u306b\u30b9\u30da\u30fc\u30b9\u3092\u4f5c\u308b\u3068\u898b\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002\u300cNo\u300d\u306e\u4ed6\u306b\u547c\u3073\u51fa\u3057\u305f\u3044\u30c7\u30fc\u30bf\uff08\u300c\u540d\u524d\u300d\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u300c\u4f4f\u6240\u300d\u306a\u3069\uff09\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u7e26\u8ef8\u306b\u9805\u76ee\u3092\u4f5c\u308a\u3001\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u6a2a\u8ef8\u306e\u5e45\u306f\u5e83\u3081\u306b\u53d6\u308a\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\u30113. VLOOKUP\u95a2\u6570\u3092\u8a2d\u5b9a\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u304c\u6b63\u3057\u304f\u8a2d\u5b9a\u3067\u304d\u308b\u3068\u3001\u9805\u76ee\u306b\u30ca\u30f3\u30d0\u30fc\u3092\u5165\u308c\u308b\u3060\u3051\u3067\u3001\u5b9b\u5148\u30ea\u30b9\u30c8\u306b\u3042\u308b\u60c5\u5831\u304c\u81ea\u52d5\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001VLOOKUP\u95a2\u6570\u306e\u8a2d\u5b9a\u65b9\u6cd5\u3068\u3001\u95a2\u6570\u306e\u5f15\u6570\u306b\u5165\u529b\u3059\u308b\u9805\u76ee\u3054\u3068\u306b\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u9805\u76ee\u3054\u3068\u306bVLOOKUP\u95a2\u6570\u3092\u8a2d\u5b9a\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u306f\u3001\u9805\u76ee\u3054\u3068\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u300c\u540d\u524d\u300d\u3092\u4f8b\u306b\u8a2d\u5b9a\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u547c\u3073\u51fa\u3057\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u30b9\u30da\u30fc\u30b9\u306e\u300c\u540d\u524d\u300d\u306e\u53f3\u5074\u30bb\u30eb\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u79fb\u52d5\u3059\u308b\u3002<\/li>\n\n\n\n<li>\u30ad\u30fc\u30dc\u30fc\u30c9\u300cShift\uff0bF3\u300d\u3067\u3001\u300c\u95a2\u6570\u306e\u633f\u5165\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u547c\u3073\u51fa\u3059\u3002<\/li>\n\n\n\n<li>\u691c\u7d22\u7a93\u306b\u300cVLOOKUP\u300d\u3068\u5165\u529b\u3001\u307e\u305f\u306f\u95a2\u6570\u540d\u306b\u300cVLOOKUP\u300d\u304c\u3042\u308c\u3070\u9078\u629e\u3092\u3057\u3066OK\u3092\u62bc\u3059\u3002<\/li>\n\n\n\n<li>\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u3067\u306f\u3001\u300c\u691c\u7d22\u5024\u300d\u300c\u7bc4\u56f2\u300d\u300c\u5217\u756a\u53f7\u300d\u300c\u691c\u7d22\u65b9\u6cd5\u300d\u306e\u9805\u76ee\u3092\u5165\u529b\u3059\u308b\u3002<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u9805\u76ee\u3054\u3068\u306e\u6982\u8981\u3068\u5165\u529b\u5185\u5bb9\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3067\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u95a2\u6570\u306e\u5f15\u6570\u306b\u5165\u529b\u3059\u308b\u9805\u76ee\u3068\u306f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u306b\u3042\u308b4\u3064\u306e\u9805\u76ee\u306b\u306f\u3069\u306e\u3088\u3046\u306a\u610f\u5473\u304c\u3042\u308b\u306e\u3067\u3057\u3087\u3046\u304b\u3002\u9805\u76ee\u3054\u3068\u306b\u3001\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u691c\u7d22\u5024<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u691c\u7d22\u5024\u306f\u3001\u691c\u7d22\u3067\u5bfe\u8c61\u306b\u306a\u308b\u5024\u3067\u3059\u3002\u5b9b\u5148\u30ea\u30b9\u30c8\u3067\u306f\u3001\u30ca\u30f3\u30d0\u30fc\u304b\u3089\u9805\u76ee\u3054\u3068\u306e\u30c7\u30fc\u30bf\u3092\u547c\u3073\u51fa\u3057\u307e\u3059\u3002\u300cB2\u300d\u300cC3\u300d\u306a\u3069\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u7bc4\u56f2<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u56f2\u306f\u3001\u691c\u7d22\u5024\u3092\u63a2\u3059\u305f\u3081\u306b\u6307\u5b9a\u3059\u308b\u30bb\u30eb\u3067\u5fc5\u305a\u691c\u7d22\u5024\u3082\u542b\u3081\u307e\u3059\u3002\u300cB10:G19\u300d\u306e\u3088\u3046\u306b\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5217\u756a\u53f7<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u5217\u756a\u53f7\u3067\u306f\u3001\u8868\u793a\u3057\u305f\u3044\u9805\u76ee\u304c\u3069\u306e\u5217\u306b\u3042\u308b\u306e\u304b\u3092\u6307\u5b9a\u3057\u307e\u3059\u30024\u5217\u76ee\u306b\u3042\u308b\u9805\u76ee\u3092\u6307\u5b9a\u3057\u305f\u3044\u5834\u5408\u306f\u300c4\u300d\u3068\u6253\u3061\u8fbc\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u691c\u7d22\u65b9\u6cd5<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9b\u540d\u30e9\u30d9\u30eb\u4f5c\u6210\u3067\u306f\u3001\u300cFALSE\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u300cFALSE\u300d\u306f\u5b8c\u5168\u4e00\u81f4\u3092\u610f\u5473\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VLOOKUP\u95a2\u6570\u306e\u8868\u793a\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u305f\u3089\u3001\u30c7\u30fc\u30bf\u304c\u6b63\u3057\u304f\u8868\u793a\u3055\u308c\u308b\u304b\u3001\u5fc5\u305a\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300c\u540d\u524d\u300d\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u300c\u4f4f\u6240\u300d\u306a\u3069\u3001\u5fc5\u8981\u306a\u9805\u76ee\u3092\u5168\u3066\u78ba\u8a8d\u3057\u3066\u304a\u3051\u3070\u3001\u8a2d\u5b9a\u9593\u9055\u3048\u306b\u3088\u308b\u5370\u5237\u30df\u30b9\u3092\u9632\u3052\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"dm-service-box\">\n<div class=\"dm-box-title\">\u9762\u5012\u306a\u4f5c\u696d\u3001\u5b89\u304f\u4e38\u6295\u3052\u3057\u307e\u305b\u3093\u304b\uff1f<\/div>\n<div class=\"dm-box-body\">\n<div class=\"dm-box-text-col\" style=\"flex: 1; width: 100%;\">\n<h4 class=\"dm-box-heading\">\u696d\u754c\u6700\u5b89\u7d1a\uff01DM\u767a\u9001\u4ee3\u884c\u30b5\u30fc\u30d3\u30b9<\/h4>\n<figure><img decoding=\"async\" style=\"width: 100%; height: auto; display: block; border: 1px solid #ddd;\" src=\"https:\/\/dm.bpsinc.jp\/blog\/wp-content\/uploads\/2021\/07\/4774116_m_optimized-e1627282600221.jpg\" alt=\"DM\u5236\u4f5c\u98a8\u666f\"><\/figure><div class=\"dm-box-mid-image\" style=\"margin-bottom: 20px;\"><\/div>\n<div class=\"dm-box-highlight\">\u5b8c\u74a7\u306a\u30de\u30ca\u30fc\u3068\u5b9b\u540d\u30c1\u30a7\u30c3\u30af\u3092\u81ea\u793e\u3067\u3084\u308b\u306e\u306f\u3001\u6642\u9593\u3082\u624b\u9593\u3082\u304b\u304b\u308a\u307e\u3059\u3002<br>\n\u5b9b\u540d\u30ea\u30b9\u30c8\u306e\u3054\u7528\u610f\u304c\u3042\u308c\u3070\u3001\u767a\u9001\u3059\u308b\u3060\u3051\u3067\u3082\u5f0a\u793e\u3092\u901a\u3057\u305f\u65b9\u304c\u304a\u5f97\uff01<\/div>\n<p class=\"dm-box-description\"><a href=\"https:\/\/dm.bpsinc.jp\/\" target=\"_blank\" rel=\"noopener\"><strong>\u683c\u5b89DM\u767a\u9001\u4ee3\u884c\u300cDM\u8a3a\u65ad\u300d<\/strong><\/a>\u306a\u3089\u3001\u30c7\u30b6\u30a4\u30f3\uff5e\u5370\u5237\uff5e\u5c01\u5165\uff5e\u767a\u9001\u307e\u3067\u30ef\u30f3\u30b9\u30c8\u30c3\u30d7\u3067\u4e38\u6295\u3052OK\uff01\u5f53\u65e5\u767a\u9001\u306a\u3069\u306e\u7279\u6025\u5bfe\u5fdc\u306b\u3082100%\u793e\u5185\u5bfe\u5fdc\u3067\u67d4\u8edf\u306b\u304a\u5fdc\u3048\u3057\u307e\u3059\u3002<\/p>\n<p><strong>\u2714 \u6700\u5b89\u4fdd\u969c<\/strong><br>\n<strong>\u2714 \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u5168\u5bfe\u5fdc<\/strong><br>\n<strong>\u2714 \u8868\u793a\u3059\u3079\u3066\u30b3\u30df\u30b3\u30df\u4fa1\u683c<\/strong><\/p>\n<\/div>\n<\/div>\n<div class=\"dm-box-footer\">\n<p class=\"dm-box-subtext\">\uff3c \u8cc7\u6599\u8acb\u6c42\u3082\u304a\u6c17\u8efd\u306b \uff0f<\/p>\n<div class=\"dm-cta-container\"><a class=\"dm-cta-button\" href=\"https:\/\/dm.bpsinc.jp\/inquiry\/\"><br>\n<span class=\"dm-cta-icon\">\ud83d\udcc4\ud83d\udd0d<\/span><br>\n<span class=\"dm-cta-text\">\u6700\u5b89\u4fdd\u969c\uff01DM\u8a3a\u65ad\u306e\u898b\u7a4d\u308a\u3092\u53d6\u308b<\/span><br>\n<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\u30114.\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3078\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP\u95a2\u6570\u3067\u547c\u3073\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u306e\u5370\u5237\u30a4\u30e1\u30fc\u30b8\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3078\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u3087\u3046\u3002\u5370\u5237\u30a4\u30e1\u30fc\u30b8\u304c\u5fc5\u8981\u306a\u3044\u5834\u5408\u306f\u3001\u305d\u306e\u307e\u307e\u5370\u5237\u30da\u30fc\u30b8\u3067\u5bfe\u5fdc\u3057\u3066\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u9577\u65b9\u5f62\uff08\u6a2a\u9577\uff09\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u633f\u5165\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u7a7a\u304d\u30b9\u30da\u30fc\u30b9\u306b\u3001\u9577\u65b9\u5f62\uff08\u6a2a\u9577\uff09\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306f\u3001Excel\u306e\u300c\u633f\u5165\u300d\u30bf\u30d6\u304b\u3089\u3001\u300c\u56f3\u5f62\u300d\u306e\u300c\u9577\u65b9\u5f62\uff08\u6a2a\u9577\uff09\u300d\u3092\u9078\u629e\u3057\u3066\u3001\u30b5\u30a4\u30ba\u3092\u8abf\u7bc0\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u8a2d\u5b9a\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9b\u5148\u30ea\u30b9\u30c8\u306b\u633f\u5165\u3057\u305f\u6a2a\u9577\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306e\u4e2d\u306b\u3001\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u306e\u30b9\u30da\u30fc\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u305f\u3081\u3001\u3055\u3089\u306b\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u90f5\u4fbf\u756a\u53f7\u7528\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u3066\u3001\u90f5\u4fbf\u756a\u53f7\u306e\u9805\u76ee\u304c\u3042\u308b\u5217\u884c\uff08\u6570\u5f0f\uff09\u3092\u300c=B\u3007\u300d\u306e\u3088\u3046\u306b\u5165\u529b\u3059\u308b\u3068\u3001\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ed6\u306e\u9805\u76ee\u3082\u8a2d\u5b9a\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u4f4f\u6240\u300d\u3084\u300c\u540d\u524d\u300d\u3082\u3001\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u3068\u540c\u3058\u3088\u3046\u306b\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u633f\u5165\u3057\u3066\u5217\u884c\u3092\u5165\u529b\u3057\u307e\u3057\u3087\u3046\u3002\u30ca\u30f3\u30d0\u30fc\u3092\u5909\u66f4\u3059\u308b\u3068\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u5185\u306e\u300c\u90f5\u4fbf\u756a\u53f7\u300d\u3084\u300c\u6c0f\u540d\u300d\u3082\u5909\u66f4\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010Excel\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\u30115.\u30c7\u30fc\u30bf\u3092\u30e9\u30d9\u30eb\u306b\u5370\u5237\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u3067\u307e\u3068\u3081\u305f\u30c7\u30fc\u30bf\u3092\u3001\u5b9b\u540d\u30e9\u30d9\u30eb\u306b\u5370\u5237\u3059\u308b\u306b\u306f\u3069\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308c\u3070\u3088\u3044\u306e\u3067\u3057\u3087\u3046\u304b\u3002\u4ee5\u4e0b\u3067\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5370\u5237\u753b\u9762\u3092\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u30b5\u30a4\u30ba\u3078\u5909\u66f4\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5370\u5237\u753b\u9762\u3092\u5b9b\u540d\u30e9\u30d9\u30eb\u30b7\u30fc\u30c8\u306e\u30b5\u30a4\u30ba\u3078\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u306f\u3001\u5b9b\u5148\u30ea\u30b9\u30c8\u306eExcel\u306bsheet2\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002sheet2\u306e\u30b5\u30a4\u30ba\u3092\u3001\u30da\u30fc\u30b8\u30ec\u30a4\u30a2\u30a6\u30c8\u304b\u3089\u5b9b\u540d\u30e9\u30d9\u30eb\u30b7\u30fc\u30c8\u306e\u30b5\u30a4\u30ba\u306b\u5909\u66f4\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092sheet2\u3078\u30b3\u30d4\u307a\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">sheet1\u306b\u3042\u308b\u5370\u5237\u30a4\u30e1\u30fc\u30b8\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306f\u3001\u300cCtrl\uff0bA\u300d\u3067\u9078\u629e\u3092\u3057\u3066\u5168\u4f53\u3092\u30b3\u30d4\u30fc&amp;\u30da\u30fc\u30b9\u30c8\u3057\u307e\u3059\u3002\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6570\u5f0f\u306f\u30b3\u30d4\u30fc&amp;\u30da\u30fc\u30b9\u30c8\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u624b\u5165\u529b\u304c\u5fc5\u8981\u3067\u3059\u3002\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3054\u3068\u306b\u300c\uff1dsheet1!B\u3007\u300d\u306e\u3088\u3046\u306b\u5165\u529b\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u304c\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30e9\u30d9\u30eb\u5370\u5237\u3057\u305f\u3044\u30c7\u30fc\u30bf\u306f\u3001\u5168\u3066\u3053\u306e\u4f5c\u696d\u3092\u884c\u3063\u3066\u304f\u3060\u3055\u3044\u3002\u5370\u5237\u7bc4\u56f2\u304c\u7570\u306a\u308b\u5834\u5408\u306f\u8abf\u7bc0\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5370\u5237\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5370\u5237\u3057\u305f\u3044\u30c7\u30fc\u30bf\u306e\u8a2d\u5b9a\u3084\u7bc4\u56f2\u306e\u8abf\u7bc0\u304c\u3067\u304d\u305f\u3089\u3001\u5370\u5237\u753b\u9762\u304b\u3089\u5370\u5237\u306e\u8a73\u7d30\u3092\u8a2d\u5b9a\u3057\u3066\u3001\u5370\u5237\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30df\u30b9\u30d7\u30ea\u30f3\u30c8\u3092\u9632\u3050\u305f\u3081\u306b\u3001\u6700\u521d\u306e\u5370\u5237\u306f\u666e\u901a\u306e\u7d19\u3067\u884c\u3044\u3001\u5370\u5237\u4f4d\u7f6e\u3084\u5185\u5bb9\u306e\u78ba\u8a8d\u3092\u884c\u3046\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5c11\u306a\u3044\u30c7\u30fc\u30bf\u306fWord\u306e\u5229\u7528\u304c\u304a\u3059\u3059\u3081<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u306b\u306f\u3001Excel\u3067\u306f\u306a\u304fWord\u3092\u4f7f\u3046\u65b9\u6cd5\u3082\u3042\u308a\u307e\u3059\u3002\u5c11\u306a\u3044\u30c7\u30fc\u30bf\u3092\u914d\u7f6e\u3057\u3066\u5370\u5237\u3059\u308b\u5834\u5408\u306f\u3001Word\u3067\u300c\u5dee\u3057\u8fbc\u307f\u5370\u5237\u300d\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u3000Word\u306e\u300c\u5dee\u3057\u8fbc\u3080\u6587\u66f8\u300d\u306b\u3042\u308b\u300c\u5b9b\u540d\u306e\u9078\u629e\u300d\u304b\u3089\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\u3084\u9078\u629e\u3092\u884c\u3044\u3001\u30e9\u30d9\u30eb\u30b7\u30fc\u30c8\u306b\u5370\u5237\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u95a2\u9023\uff1a<a href=\"https:\/\/dm.bpsinc.jp\/blog\/?p=11439\">Excel\u30fbWord\u3067\u7c21\u5358\u306b\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\uff01\u5370\u5237\u4ee3\u3092\u6291\u3048\u305f\u3044\u5834\u5408\u306f\uff1f<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u306f\u3001\u5b9b\u5148\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\u3068\u5370\u5237\u304c\u3067\u304d\u308b\u30bd\u30d5\u30c8\u3067\u3059\u3002VLOOKUP\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u3001Excel\u3060\u3051\u3067\u7c21\u5358\u306b\u5b9b\u540d\u5370\u5237\u304c\u3067\u304d\u308b\u4ed6\u306b\u3001\u76ee\u8996\u3067\u63a2\u3057\u306b\u304f\u3044\u30c7\u30fc\u30bf\u306e\u547c\u3073\u51fa\u3057\u3084\u3001\u30c7\u30fc\u30bf\u306e\u5165\u529b\u6f0f\u308c\u306e\u30c1\u30a7\u30c3\u30af\u3082\u53ef\u80fd\u3067\u3059\u3002\u30c7\u30fc\u30bf\u304c\u591a\u3044\u5834\u5408\u306f\u3001Excel\u3067\u306e\u5b9b\u540d\u5370\u5237\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c<a href=\"https:\/\/atenasupport.bpsinc.jp\/\">\u5b9b\u540d.\u30b5\u30dd\u30fc\u30c8<\/a>\u300d\u306b\u306f\u3001\u5c01\u7b52\u30c7\u30b6\u30a4\u30f3\u304b\u3089\u767a\u9001\u4ee3\u884c\u307e\u3067\u5168\u3066\u304a\u4efb\u305b\u306e\u30d7\u30e9\u30f3\u3084\u3001\u624b\u66f8\u304d\u306e\u30e9\u30d9\u30eb\u4f5c\u6210\u306a\u3069\u3001\u8c4a\u5bcc\u306a\u30d7\u30e9\u30f3\u304c\u3042\u308a\u307e\u3059\u3002\u30d1\u30bd\u30b3\u30f3\u4f5c\u696d\u304c\u82e6\u624b\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u306e\u4f5c\u6210\u304c\u96e3\u3057\u3044\u4eba\u306b\u306f\u3001\u300c\u5b9b\u540d.\u30b5\u30dd\u30fc\u30c8\u300d\u306e\u5229\u7528\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u304a\u6c17\u8efd\u306b\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"dm-cta-container\"><a class=\"dm-cta-button-blue\" href=\"https:\/\/atenasupport.bpsinc.jp\/\"><br>\n<span class=\"dm-cta-icon\">\ud83d\udcc4<\/span><br>\n<span class=\"dm-cta-text\">\u4f5c\u696d\u4e38\u6295\u3052OK\uff01\u5b9b\u540d\u30b5\u30dd\u30fc\u30c8\u3092\u898b\u308b<\/span><br>\n<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9&#8230;<\/p>\n","protected":false},"author":17,"featured_media":11400,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[397],"tags":[],"class_list":["post-11487","post","type-post","status-publish","format-standard","has-post-thumbnail","category-397","article cf"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"YamashitaHaruki\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/dm.bpsinc.jp\/blog\/?p=11487\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0 - DM \u8a3a\u65ad | \u4f01\u753b\u30fb\u5370\u5237\u304b\u3089\u767a\u9001\u307e\u3067\u305c\u30fc\u3093\u3076\u307e\u3068\u3081\u3066\u697d\u3005\u767a\u6ce8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0\" \/>\n\t\t<meta property=\"og:description\" content=\"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/dm.bpsinc.jp\/blog\/?p=11487\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-01-23T01:00:50+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-08-06T09:17:17+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#blogposting\",\"name\":\"\\u30a8\\u30af\\u30bb\\u30eb\\uff08Excel\\uff09\\u3060\\u3051\\u3067\\u5b9b\\u540d\\u30e9\\u30d9\\u30eb\\u3092\\u5370\\u5237\\u3059\\u308b\\u65b9\\u6cd5\\uff5cVLOOKUP\\u95a2\\u6570\\u3082\\u89e3\\u8aac - DM\\u30fb\\u306f\\u304c\\u304d\\u767a\\u9001\\u4ee3\\u884c | \\u6599\\u91d1\\u6700\\u5b89\\u4fdd\\u8a3c\\u306eDM\\u8a3a\\u65ad\\u30d6\\u30ed\\u30b0\",\"headline\":\"\\u30a8\\u30af\\u30bb\\u30eb\\uff08Excel\\uff09\\u3060\\u3051\\u3067\\u5b9b\\u540d\\u30e9\\u30d9\\u30eb\\u3092\\u5370\\u5237\\u3059\\u308b\\u65b9\\u6cd5\\uff5cVLOOKUP\\u95a2\\u6570\\u3082\\u89e3\\u8aac\",\"author\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?author=17#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/atena.png\",\"width\":1915,\"height\":1005},\"datePublished\":\"2023-01-23T10:00:50+09:00\",\"dateModified\":\"2026-08-06T18:17:17+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#webpage\"},\"articleSection\":\"\\u5b9b\\u540d\\u4f5c\\u6210\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?cat=397#listItem\",\"name\":\"\\u5b9b\\u540d\\u4f5c\\u6210\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?cat=397#listItem\",\"position\":2,\"name\":\"\\u5b9b\\u540d\\u4f5c\\u6210\",\"item\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?cat=397\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#listItem\",\"name\":\"\\u30a8\\u30af\\u30bb\\u30eb\\uff08Excel\\uff09\\u3060\\u3051\\u3067\\u5b9b\\u540d\\u30e9\\u30d9\\u30eb\\u3092\\u5370\\u5237\\u3059\\u308b\\u65b9\\u6cd5\\uff5cVLOOKUP\\u95a2\\u6570\\u3082\\u89e3\\u8aac\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#listItem\",\"position\":3,\"name\":\"\\u30a8\\u30af\\u30bb\\u30eb\\uff08Excel\\uff09\\u3060\\u3051\\u3067\\u5b9b\\u540d\\u30e9\\u30d9\\u30eb\\u3092\\u5370\\u5237\\u3059\\u308b\\u65b9\\u6cd5\\uff5cVLOOKUP\\u95a2\\u6570\\u3082\\u89e3\\u8aac\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?cat=397#listItem\",\"name\":\"\\u5b9b\\u540d\\u4f5c\\u6210\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/#organization\",\"name\":\"DM\\u30fb\\u306f\\u304c\\u304d\\u767a\\u9001\\u4ee3\\u884c | \\u6599\\u91d1\\u6700\\u5b89\\u4fdd\\u8a3c\\u306eDM\\u8a3a\\u65ad\\u30d6\\u30ed\\u30b0\",\"description\":\"DM \\u8a3a\\u65ad | \\u4f01\\u753b\\u30fb\\u5370\\u5237\\u304b\\u3089\\u767a\\u9001\\u307e\\u3067\\u305c\\u30fc\\u3093\\u3076\\u307e\\u3068\\u3081\\u3066\\u697d\\u3005\\u767a\\u6ce8\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?author=17#author\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?author=17\",\"name\":\"YamashitaHaruki\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0d0ee2b75562ec5ec81270bc4a41c21469437473292e13a140ed271dc6a8ad4b?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"YamashitaHaruki\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#webpage\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487\",\"name\":\"\\u30a8\\u30af\\u30bb\\u30eb\\uff08Excel\\uff09\\u3060\\u3051\\u3067\\u5b9b\\u540d\\u30e9\\u30d9\\u30eb\\u3092\\u5370\\u5237\\u3059\\u308b\\u65b9\\u6cd5\\uff5cVLOOKUP\\u95a2\\u6570\\u3082\\u89e3\\u8aac - DM\\u30fb\\u306f\\u304c\\u304d\\u767a\\u9001\\u4ee3\\u884c | \\u6599\\u91d1\\u6700\\u5b89\\u4fdd\\u8a3c\\u306eDM\\u8a3a\\u65ad\\u30d6\\u30ed\\u30b0\",\"description\":\"\\u5927\\u91cf\\u306e\\u9867\\u5ba2\\u30ea\\u30b9\\u30c8\\u304b\\u3089\\u30011\\u4ef6\\u305a\\u3064\\u5b9b\\u540d\\u3092\\u624b\\u66f8\\u304d\\u3059\\u308b\\u306e\\u306f\\u624b\\u9593\\u304c\\u304b\\u304b\\u308a\\u82e6\\u52b4\\u3057\\u307e\\u3059\\u3002 \\u3057\\u304b\\u3057Excel\\u3092\\u4f7f\\u3048\\u3070\\u3001\\u5b9b\\u540d\\u30e9\\u30d9\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?author=17#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?author=17#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/atena.png\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487\\\/#mainImage\",\"width\":1915,\"height\":1005},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/?p=11487#mainImage\"},\"datePublished\":\"2023-01-23T10:00:50+09:00\",\"dateModified\":\"2026-08-06T18:17:17+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/\",\"name\":\"DM\\u30fb\\u306f\\u304c\\u304d\\u767a\\u9001\\u4ee3\\u884c | \\u6599\\u91d1\\u6700\\u5b89\\u4fdd\\u8a3c\\u306eDM\\u8a3a\\u65ad\\u30d6\\u30ed\\u30b0\",\"description\":\"DM \\u8a3a\\u65ad | \\u4f01\\u753b\\u30fb\\u5370\\u5237\\u304b\\u3089\\u767a\\u9001\\u307e\\u3067\\u305c\\u30fc\\u3093\\u3076\\u307e\\u3068\\u3081\\u3066\\u697d\\u3005\\u767a\\u6ce8\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/dm.bpsinc.jp\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","description":"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9","canonical_url":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#blogposting","name":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","headline":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac","author":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?author=17#author"},"publisher":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/dm.bpsinc.jp\/blog\/wp-content\/uploads\/2022\/08\/atena.png","width":1915,"height":1005},"datePublished":"2023-01-23T10:00:50+09:00","dateModified":"2026-08-06T18:17:17+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#webpage"},"isPartOf":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#webpage"},"articleSection":"\u5b9b\u540d\u4f5c\u6210"},{"@type":"BreadcrumbList","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog#listItem","position":1,"name":"Home","item":"https:\/\/dm.bpsinc.jp\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog\/?cat=397#listItem","name":"\u5b9b\u540d\u4f5c\u6210"}},{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog\/?cat=397#listItem","position":2,"name":"\u5b9b\u540d\u4f5c\u6210","item":"https:\/\/dm.bpsinc.jp\/blog\/?cat=397","nextItem":{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#listItem","name":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac"},"previousItem":{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#listItem","position":3,"name":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac","previousItem":{"@type":"ListItem","@id":"https:\/\/dm.bpsinc.jp\/blog\/?cat=397#listItem","name":"\u5b9b\u540d\u4f5c\u6210"}}]},{"@type":"Organization","@id":"https:\/\/dm.bpsinc.jp\/blog\/#organization","name":"DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","description":"DM \u8a3a\u65ad | \u4f01\u753b\u30fb\u5370\u5237\u304b\u3089\u767a\u9001\u307e\u3067\u305c\u30fc\u3093\u3076\u307e\u3068\u3081\u3066\u697d\u3005\u767a\u6ce8","url":"https:\/\/dm.bpsinc.jp\/blog\/"},{"@type":"Person","@id":"https:\/\/dm.bpsinc.jp\/blog\/?author=17#author","url":"https:\/\/dm.bpsinc.jp\/blog\/?author=17","name":"YamashitaHaruki","image":{"@type":"ImageObject","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/0d0ee2b75562ec5ec81270bc4a41c21469437473292e13a140ed271dc6a8ad4b?s=96&d=mm&r=g","width":96,"height":96,"caption":"YamashitaHaruki"}},{"@type":"WebPage","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#webpage","url":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487","name":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","description":"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9","inLanguage":"ja","isPartOf":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#breadcrumblist"},"author":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?author=17#author"},"creator":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?author=17#author"},"image":{"@type":"ImageObject","url":"https:\/\/dm.bpsinc.jp\/blog\/wp-content\/uploads\/2022\/08\/atena.png","@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487\/#mainImage","width":1915,"height":1005},"primaryImageOfPage":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487#mainImage"},"datePublished":"2023-01-23T10:00:50+09:00","dateModified":"2026-08-06T18:17:17+09:00"},{"@type":"WebSite","@id":"https:\/\/dm.bpsinc.jp\/blog\/#website","url":"https:\/\/dm.bpsinc.jp\/blog\/","name":"DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","description":"DM \u8a3a\u65ad | \u4f01\u753b\u30fb\u5370\u5237\u304b\u3089\u767a\u9001\u307e\u3067\u305c\u30fc\u3093\u3076\u307e\u3068\u3081\u3066\u697d\u3005\u767a\u6ce8","inLanguage":"ja","publisher":{"@id":"https:\/\/dm.bpsinc.jp\/blog\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0 - DM \u8a3a\u65ad | \u4f01\u753b\u30fb\u5370\u5237\u304b\u3089\u767a\u9001\u307e\u3067\u305c\u30fc\u3093\u3076\u307e\u3068\u3081\u3066\u697d\u3005\u767a\u6ce8","og:type":"article","og:title":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","og:description":"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9","og:url":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487","article:published_time":"2023-01-23T01:00:50+00:00","article:modified_time":"2026-08-06T09:17:17+00:00","twitter:card":"summary_large_image","twitter:title":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac - DM\u30fb\u306f\u304c\u304d\u767a\u9001\u4ee3\u884c | \u6599\u91d1\u6700\u5b89\u4fdd\u8a3c\u306eDM\u8a3a\u65ad\u30d6\u30ed\u30b0","twitter:description":"\u5927\u91cf\u306e\u9867\u5ba2\u30ea\u30b9\u30c8\u304b\u3089\u30011\u4ef6\u305a\u3064\u5b9b\u540d\u3092\u624b\u66f8\u304d\u3059\u308b\u306e\u306f\u624b\u9593\u304c\u304b\u304b\u308a\u82e6\u52b4\u3057\u307e\u3059\u3002 \u3057\u304b\u3057Excel\u3092\u4f7f\u3048\u3070\u3001\u5b9b\u540d\u30e9\u30d9"},"aioseo_meta_data":{"post_id":"11487","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-22 06:58:07","updated":"2026-08-06 09:39:35"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/dm.bpsinc.jp\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/dm.bpsinc.jp\/blog\/?cat=397\" title=\"\u5b9b\u540d\u4f5c\u6210\">\u5b9b\u540d\u4f5c\u6210<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/dm.bpsinc.jp\/blog"},{"label":"\u5b9b\u540d\u4f5c\u6210","link":"https:\/\/dm.bpsinc.jp\/blog\/?cat=397"},{"label":"\u30a8\u30af\u30bb\u30eb\uff08Excel\uff09\u3060\u3051\u3067\u5b9b\u540d\u30e9\u30d9\u30eb\u3092\u5370\u5237\u3059\u308b\u65b9\u6cd5\uff5cVLOOKUP\u95a2\u6570\u3082\u89e3\u8aac","link":"https:\/\/dm.bpsinc.jp\/blog\/?p=11487"}],"_links":{"self":[{"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11487"}],"version-history":[{"count":10,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11487\/revisions"}],"predecessor-version":[{"id":12372,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11487\/revisions\/12372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=\/wp\/v2\/media\/11400"}],"wp:attachment":[{"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dm.bpsinc.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}