{"height":"190","description":"\u300cVLOOKUP\u95a2\u6570\u3092\u5165\u308c\u305f\u3051\u3069\u3001\u307e\u3060\u5546\u54c1ID\u3092\u5165\u529b\u3057\u3066\u3044\u306a\u3044\u884c\u304c\u5168\u90e8\u300e#N/A\u300f\u306b\u306a\u3063\u3061\u3083\u3063\u305f\u2026\u300d\u300c\u5b58\u5728\u3057\u306a\u3044\u30b3\u30fc\u30c9\u3092\u5165\u308c\u305f\u3089\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3002\u3053\u308c\u3092\u300e\u8a72\u5f53\u306a\u3057\u300f\u3063\u3066\u8868\u793a\u3067\u304d\u306a\u3044\u304b\u306a\uff1f\u300d VLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\u5fc5\u305a\u76f4\u9762\u3059\u308b\u306e\u304c\u3001\u3053\u306e\u300c#N/A\uff08\u30ce\u30fc\u30fb\u30a2\u30b5\u30a4\u30f3\uff09\u300d\u30a8\u30e9\u30fc\u3067\u3059\u3002\u3053\u308c\u306f\u300c\u30c7\u30fc\u30bf\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u3088\uff01\u300d\u3068\u3044\u3046\u30a8\u30af\u30bb\u30eb\u304b\u3089\u306e\u60b2\u9cf4\u306a\u306e\u3067\u3059\u304c\u3001\u305d\u306e\u307e\u307e\u5370\u5237\u3059\u308b\u308f\u3051\u306b\u306f\u3044\u304d\u307e\u305b\u3093\u3002 \u305d\u3093\u306a\u6642\u306b\u4f7f\u3046\u306e\u304c\u3001\u30a8\u30e9\u30fc\u51e6\u7406\u5c02\u9580\u306e\u300cIFERROR\uff08\u30a4\u30d5\u30a8\u30e9\u30fc\uff09\u300d\u95a2\u6570\u3067\u3059\u3002\u300c\u3082\u3057\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3089\u3001\u4ee3\u308f\u308a\u306b\u25ef\u25ef\u3092\u8868\u793a\u3057\u3066\u306d\u300d\u3068\u6307\u793a\u3059\u308b\u3053\u3068\u3067\u3001\u30a8\u30e9\u30fc\u8868\u793a\u3092\u304d\u308c\u3044\u306b\u96a0\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u76ee\u6b21 \u3010\u73fe\u72b6\u3011\u306a\u305c\u300c#N\u2026","blog_url":"https://infolab.hatenablog.com/","provider_url":"https://hatena.blog","author_name":"info_lab_room","version":"1.0","published":"2026-02-03 23:33:22","url":"https://infolab.hatenablog.com/entry/2026/02/03/233322","image_url":"https://m.media-amazon.com/images/I/51OQDSshpjL._SL500_.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finfolab.hatenablog.com%2Fentry%2F2026%2F02%2F03%2F233322\" title=\"\u3010Excel\u4e8b\u52d9\u8077\u8b1b\u5ea7 #09\u3011\u300c#N/A\u300d\u30a8\u30e9\u30fc\u3092\u8868\u793a\u3055\u305b\u306a\u3044\uff01IFERROR\u95a2\u6570\u3067VLOOKUP\u3092\u7f8e\u3057\u304f\u4ed5\u4e0a\u3052\u308b\u6280\uff5c\u898b\u7a4d\u66f8\u3084\u8acb\u6c42\u66f8\u4f5c\u6210\u306e\u5fc5\u9808\u30c6\u30af\u30cb\u30c3\u30af - \u307f\u3061\u304f\u3055\u5de5\u623f\u306e\u3057\u3089\u3079\u3082\u306e\u30ce\u30fc\u30c8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"\u3010Excel\u4e8b\u52d9\u8077\u8b1b\u5ea7 #09\u3011\u300c#N/A\u300d\u30a8\u30e9\u30fc\u3092\u8868\u793a\u3055\u305b\u306a\u3044\uff01IFERROR\u95a2\u6570\u3067VLOOKUP\u3092\u7f8e\u3057\u304f\u4ed5\u4e0a\u3052\u308b\u6280\uff5c\u898b\u7a4d\u66f8\u3084\u8acb\u6c42\u66f8\u4f5c\u6210\u306e\u5fc5\u9808\u30c6\u30af\u30cb\u30c3\u30af","categories":["Excel"],"blog_title":"\u307f\u3061\u304f\u3055\u5de5\u623f\u306e\u3057\u3089\u3079\u3082\u306e\u30ce\u30fc\u30c8","author_url":"https://blog.hatena.ne.jp/info_lab_room/","type":"rich","provider_name":"Hatena Blog","width":"100%"}