{"id":4476,"date":"2026-04-02T15:24:12","date_gmt":"2026-04-02T06:24:12","guid":{"rendered":"https:\/\/www.isa-school.net\/blog\/?p=4476"},"modified":"2026-04-02T19:46:57","modified_gmt":"2026-04-02T10:46:57","slug":"office-excel63","status":"publish","type":"post","link":"https:\/\/www.isa-school.net\/blog\/office-excel63\/","title":{"rendered":"VLOOKUP\u95a2\u6570\u3067\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3092\u3059\u308b\u65b9\u6cd5\u3068\u306f\uff1f\u57fa\u672c\u69cb\u6587\u3068\u5fdc\u7528\u65b9\u6cd5\u3092\u89e3\u8aac"},"content":{"rendered":"\n<p>\u300c<a href=\"\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA<\/a>\u300d\u30e9\u30a4\u30bf\u30fc\u30c1\u30fc\u30e0\u3067\u3059\u3002<\/p>\n\n\n\n<p>Excel\u3067\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3063\u305f\u3068\u304d\u3001\u7279\u5b9a\u306e\u5024\u3068\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u3092\u6b63\u78ba\u306b\u62bd\u51fa\u3057\u305f\u3044\u3068\u611f\u3058\u305f\u3053\u3068\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002\u305d\u306e\u3088\u3046\u306a\u5834\u9762\u3067\u6d3b\u8e8d\u3059\u308b\u306e\u304c\u3001VLOOKUP\u95a2\u6570\u3067\u3059\u3002\u306a\u304b\u3067\u3082\u691c\u7d22\u306e\u578b\u3067\u300c\u5b8c\u5168\u4e00\u81f4\u300d\u3092\u6307\u5b9a\u3059\u308c\u3070\u3001\u90e8\u5206\u4e00\u81f4\u3092\u6392\u9664\u3057\u305f\u7d50\u679c\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u3001VLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3092\u3059\u308b\u65b9\u6cd5\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002<span class=\"marker2\">\u8fd1\u4f3c\u4e00\u81f4\u3068\u306e\u9055\u3044\u3084\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3092\u4f7f\u3063\u305f\u5fdc\u7528\u65b9\u6cd5<\/span>\u3082\u7d39\u4ecb\u3059\u308b\u306e\u3067\u3001\u305c\u3072\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/mf\/\">\u30d1\u30bd\u30b3\u30f3\u8b1b\u5ea7\u306e\u8cc7\u6599\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u3068\u306f\uff1f<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306f\u3001\u30b7\u30fc\u30c8\u4e0a\u306e\u6307\u5b9a\u3057\u305f\u5024\u3092\u3082\u3068\u306b\u8868\u306e\u306a\u304b\u304b\u3089\u5bfe\u5fdc\u3059\u308b\u30c7\u30fc\u30bf\u3092\u7e26\u65b9\u5411\u306b\u691c\u7d22\u3057\u3001\u8a72\u5f53\u3059\u308b\u5024\u3092\u53d6\u5f97\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u5546\u54c1\u30b3\u30fc\u30c9\u304b\u3089\u5546\u54c1\u540d\u3068\u4fa1\u683c\u3092\u8868\u793a\u3057\u305f\u308a\u3001\u5f93\u696d\u54e1ID\u304b\u3089\u90e8\u7f72\u540d\u3084\u5f79\u8077\u3092\u53c2\u7167\u3057\u305f\u308a\u3068\u3001\u30de\u30b9\u30bf\u30fc\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u6271\u3046\u30b7\u30fc\u30f3\u3067\u5e83\u304f\u5229\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8868\u3092\u76ee\u8996\u3067\u78ba\u8a8d\u3059\u308b\u5fc5\u8981\u304c\u306a\u304f\u306a\u308a\u3001<span class=\"marker2\">\u696d\u52d9\u306e\u52b9\u7387\u5316\u3084\u30d2\u30e5\u30fc\u30de\u30f3\u30a8\u30e9\u30fc\u306e\u9632\u6b62<\/span>\u306b\u3064\u306a\u304c\u308a\u307e\u3059\u3002Excel\u306e\u57fa\u672c\u30b9\u30ad\u30eb\u3068\u3057\u3066\u5f79\u7acb\u3064\u305f\u3081\u3001\u4f7f\u3044\u65b9\u3092\u899a\u3048\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u4f53\u9a13\u6388\u696d\u53d7\u3051\u3066\u307f\u308b<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n\n<section class=\"ftrail_cta\">\n<p class=\"ttl\">\u30d1\u30bd\u30b3\u30f3\u30b9\u30af\u30fc\u30ebISA<\/p>\n<p class=\"lead\">Office\u30fbIT\u30fb\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u7b49\u306e<br class=\"u-sp\">\u30d1\u30bd\u30b3\u30f3\u30b9\u30ad\u30eb\u30a2\u30c3\u30d7\u3092\u5fb9\u5e95\u30b5\u30dd\u30fc\u30c8\uff01<br>\u6771\u4eac\u3001\u6a2a\u6d5c\u3001\u57fc\u7389\u3001\u5343\u8449\u306e<br class=\"u-sp\">\u6700\u5bc4\u99c55\u5206\u4ee5\u5185!\u30aa\u30f3\u30e9\u30a4\u30f3\u6388\u696d\u3082<\/p>\n<p class=\"btn\"><a href=\"\/entry\/ftrial\/\">\u7121\u6599\u4f53\u9a13\u30ec\u30c3\u30b9\u30f3\u306b\u7533\u3057\u8fbc\u3080<\/a><\/p>\n<ul class=\"pr_area3\">\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2910\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2909\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon2-1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2908\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon3-1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<\/ul>\n<\/section>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u306e\u57fa\u672c\u69cb\u6587<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306e\u57fa\u672c\u69cb\u6587\u306f\u30014\u3064\u306e\u5f15\u6570\u3067\u69cb\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u306e\u610f\u5473\u3092\u6b63\u3057\u304f\u7406\u89e3\u3057\u3001\u6b63\u78ba\u306b\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1.\u691c\u7d22\u5024<\/strong><\/h3>\n\n\n\n<p>\u691c\u7d22\u5024\u306f\u3001\u8868\u304b\u3089\u691c\u7d22\u3092\u884c\u3044\u305f\u3044\u57fa\u6e96\u306e\u5024\u3067\u3059\u3002\u5177\u4f53\u7684\u306a\u6570\u5024\u30fb\u30bb\u30eb\u30fb\u6587\u5b57\u5217\u306a\u3069\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u304c\u3001\u3053\u308c\u3089\u304c\u691c\u7d22\u7bc4\u56f2\u306e\u6700\u3082\u5de6\u5074\u306e\u5217\u306b\u5b58\u5728\u3057\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u691c\u7d22\u5024\u306f\u8907\u6570\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3001\u3053\u306e\u5834\u5408\u306f\u300cA2&amp;B2\u300d\u306e\u3088\u3046\u306b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.\u7bc4\u56f2<\/strong><\/h3>\n\n\n\n<p>\u7bc4\u56f2\u306b\u306f\u3001\u30b7\u30fc\u30c8\u4e0a\u306b\u304a\u3051\u308b\u691c\u7d22\u5bfe\u8c61\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7bc4\u56f2\u306f\u540c\u30b7\u30fc\u30c8\u5185\u3067\u3082\u5225\u30b7\u30fc\u30c8\u4e0a\u3067\u3082\u304b\u307e\u3044\u307e\u305b\u3093\u3002\u6570\u5f0f\u3092\u30b3\u30d4\u30fc\u3057\u3066\u307b\u304b\u306e\u30bb\u30eb\u306b\u3082\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u3001<span class=\"marker2\">\u7bc4\u56f2\u3092\u7d76\u5bfe\u53c2\u7167\u306b\u8a2d\u5b9a<\/span>\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u53c2\u7167\u305a\u308c\u306b\u3088\u308b\u30a8\u30e9\u30fc\u3092\u9632\u3052\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3.\u5217\u756a\u53f7<\/strong><\/h3>\n\n\n\n<p>\u5217\u756a\u53f7\u306f\u3001\u53d6\u5f97\u3057\u305f\u3044\u30c7\u30fc\u30bf\u304c\u3042\u308b\u5217\u756a\u53f7\u3092\u6307\u3057\u307e\u3059\u3002<span class=\"marker2\">\u5fc5\u305a\u6574\u6570\u3067\u5165\u529b<\/span>\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u6700\u5927\u3067256\u307e\u3067\u306e\u5024\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\nhttps:\/\/www.isa-school.net\/blog\/office-excel01\/\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4.\u691c\u7d22\u306e\u578b<\/strong><\/h3>\n\n\n\n<p>\u691c\u7d22\u306e\u578b\u306f\u3001VLOOKUP\u95a2\u6570\u3067\u300c\u5b8c\u5168\u4e00\u81f4\u300d\u304b\u300c\u8fd1\u4f3c\u4e00\u81f4\u300d\u304b\u3092\u6307\u5b9a\u3059\u308b\u5f15\u6570\u3067\u3059\u3002\u5b8c\u5168\u4e00\u81f4\u3092\u8868\u3059\u300cFALSE\u300d\u30fb\u300c0\u300d\u307e\u305f\u306f\u8fd1\u4f3c\u4e00\u81f4\u3092\u8868\u3059\u300cTRUE\u300d\u30fb\u300c1\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u3053\u3061\u3089\u306e\u5f15\u6570\u306f\u7701\u7565\u3082\u53ef\u80fd\u3067\u3001<span class=\"marker2\">\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u8fd1\u4f3c\u4e00\u81f4<\/span>\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u4f53\u9a13\u6388\u696d\u53d7\u3051\u3066\u307f\u308b<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n<div class=\"post_cta excel_cta\">\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; padding-bottom: 0;\"><strong><span style=\"font-size: 16px; font-weigth: bold;\">\uff3c\u30001\u5206\u3067\u7533\u3057\u8fbc\u307f\u5b8c\u4e86 \uff0f<\/span><\/strong><\/p>\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0;\"><strong><span class=\"color-button02-big\"><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">Excel\u8b1b\u5ea7\u306e\u4f53\u9a13\u6388\u696d\u3092<br class=\"u-sp\" \/>\u7533\u3057\u8fbc\u3080<\/a><\/span><\/strong><\/p>\n\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><strong>\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3068\u8fd1\u4f3c\u4e00\u81f4\u691c\u7d22\u306e\u9055\u3044<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306e\u691c\u7d22\u65b9\u6cd5\u306b\u306f\u3001\u300c\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u300d\u3068\u300c\u8fd1\u4f3c\u4e00\u81f4\u691c\u7d22\u300d\u306e2\u7a2e\u985e\u306e\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002\u540c\u3058\u691c\u7d22\u5024\u3092\u5165\u529b\u3057\u3066\u3082\u305d\u308c\u305e\u308c\u8fd4\u3055\u308c\u308b\u5024\u304c\u7570\u306a\u308b\u305f\u3081\u3001\u4e21\u8005\u306e\u9055\u3044\u3092\u7406\u89e3\u3057\u305f\u4e0a\u3067\u30b7\u30fc\u30f3\u306b\u3042\u308f\u305b\u3066\u4f7f\u3044\u5206\u3051\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u306e\u5b8c\u5168\u4e00\u81f4\uff1aFALSE<\/strong><\/h3>\n\n\n\n<p>\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u306f\u3001\u691c\u7d22\u5024\u3068\u5b8c\u5168\u306b\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u691c\u7d22\u65b9\u6cd5\u3067\u3059\u3002\u691c\u7d22\u306e\u578b\u306b\u300cFALSE\u300d\u307e\u305f\u306f\u300c0\u300d\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u3067\u3001<span class=\"marker2\">\u5024\u304c\u5b8c\u5168\u306b\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3092\u8fd4\u3059<\/span>\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5b8c\u5168\u4e00\u81f4\u306f\u610f\u56f3\u3057\u306a\u3044\u8fd1\u4f3c\u5024\u3092\u53d6\u5f97\u3059\u308b\u30ea\u30b9\u30af\u304c\u306a\u304f\u3001\u5b8c\u5168\u4e00\u81f4\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u3044\u3068\u304d\u306b\u4fbf\u5229\u3067\u3059\u3002\u305f\u3060\u3057\u3001\u691c\u7d22\u5024\u30681\u6587\u5b57\u3067\u3082\u7570\u306a\u308b\u5834\u5408\u306f\u4e00\u81f4\u3068\u5224\u5b9a\u3055\u308c\u306a\u3044\u305f\u3081\u3001<span class=\"marker2\">\u8868\u8a18\u3086\u308c\u3084\u5168\u89d2\u30fb\u534a\u89d2\u306e\u9055\u3044\u306b\u306f\u6ce8\u610f<\/span>\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\nhttps:\/\/www.isa-school.net\/blog\/office-excel60\/\n\n\n\n<h3 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u306e\u8fd1\u4f3c\u4e00\u81f4\uff1aTRUE<\/strong><\/h3>\n\n\n\n<p>\u8fd1\u4f3c\u4e00\u81f4\u691c\u7d22\u306f\u3001\u691c\u7d22\u5024\u4ee5\u4e0b\u3067\u6700\u3082\u8fd1\u3044\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002\u691c\u7d22\u306e\u578b\u306b\u300cTRUE\u300d\u307e\u305f\u306f\u300c1\u300d\u3092\u6307\u5b9a\u3059\u308b\u304b\u3001\u691c\u7d22\u306e\u578b\u3092\u7701\u7565\u3059\u308b\u3068\u8fd1\u4f3c\u4e00\u81f4\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8fd1\u4f3c\u4e00\u81f4\u691c\u7d22\u306f\u3001\u6210\u7e3e\u30c7\u30fc\u30bf\u306e\u8a55\u4fa1\u5206\u3051\u30fb\u88fd\u54c1\u306e\u4fa1\u683c\u304b\u3089\u4fa1\u683c\u5e2f\u306e\u632f\u308a\u5206\u3051\u306a\u3069\u3001\u6570\u5024\u306e\u7bc4\u56f2\u306b\u5fdc\u3058\u3066\u7d50\u679c\u3092\u8fd4\u3057\u305f\u3044\u30b7\u30fc\u30f3\u306b\u9069\u3057\u305f\u691c\u7d22\u65b9\u6cd5\u3067\u3059\u3002\u305f\u3060\u3057\u3001\u6b63\u3057\u3044\u5024\u3092\u8fd4\u3059\u305f\u3081\u306b\u306f\u691c\u7d22\u7bc4\u56f2\u306e\u5de6\u7aef\u5217\u306f\u6607\u9806\u306b\u4e26\u3093\u3067\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u4e26\u3073\u9806\u304c\u4e0d\u9069\u5207\u3060\u3068\u8aa4\u3063\u305f\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u4f53\u9a13\u6388\u696d\u3067\u81ea\u5206\u306b\u3042\u3063\u305f\u30ec\u30d9\u30eb\u3092\u76f8\u8ac7\u3057\u3066\u307f\u308b<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n\n<section class=\"ftrail_cta\">\n<p class=\"ttl\">\u30d1\u30bd\u30b3\u30f3\u30b9\u30af\u30fc\u30ebISA<\/p>\n<p class=\"lead\">Office\u30fbIT\u30fb\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u7b49\u306e<br class=\"u-sp\">\u30d1\u30bd\u30b3\u30f3\u30b9\u30ad\u30eb\u30a2\u30c3\u30d7\u3092\u5fb9\u5e95\u30b5\u30dd\u30fc\u30c8\uff01<br>\u6771\u4eac\u3001\u6a2a\u6d5c\u3001\u57fc\u7389\u3001\u5343\u8449\u306e<br class=\"u-sp\">\u6700\u5bc4\u99c55\u5206\u4ee5\u5185!\u30aa\u30f3\u30e9\u30a4\u30f3\u6388\u696d\u3082<\/p>\n<p class=\"btn\"><a href=\"\/entry\/ftrial\/\">\u7121\u6599\u4f53\u9a13\u30ec\u30c3\u30b9\u30f3\u306b\u7533\u3057\u8fbc\u3080<\/a><\/p>\n<ul class=\"pr_area3\">\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2910\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2909\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon2-1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2908\" src=\"https:\/\/www.isa-school.net\/blog\/wp-content\/uploads\/2024\/07\/icon3-1.png\" alt=\"\" width=\"300\" height=\"300\"><\/li>\n<\/ul>\n<\/section>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u306e\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u304c\u5411\u3044\u3066\u3044\u308b\u30b7\u30fc\u30f3<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306e\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u306f\u3001\u691c\u7d22\u5024\u306b\u5bfe\u3057\u3066\u6b63\u78ba\u306a\u7d50\u679c\u3092\u8fd4\u3057\u305f\u3044\u30b7\u30fc\u30f3\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\u3001\u5f93\u696d\u54e1ID\u304b\u3089\u5f93\u696d\u54e1\u540d\u3068\u6240\u5c5e\u90e8\u7f72\u3092\u691c\u7d22\u3057\u305f\u3044\u3068\u304d\u3084\u3001JAN\u30b3\u30fc\u30c9\u304b\u3089\u5546\u54c1\u540d\u3068\u5728\u5eab\u6570\u3092\u691c\u7d22\u3057\u305f\u3044\u3068\u304d\u306a\u3069\u3001\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u4ee5\u5916\u304c\u4e0d\u8981\u306a\u3068\u304d\u306b\u4fbf\u5229\u3067\u3059\u3002\u691c\u7d22\u7bc4\u56f2\u306b\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u5024\u304c\u306a\u304b\u3063\u305f\u5834\u5408\u306f\u30a8\u30e9\u30fc\u304c\u8fd4\u3055\u308c\u308b\u305f\u3081\u3001<span class=\"marker2\">\u90e8\u5206\u4e00\u81f4\u306b\u3088\u308b\u691c\u7d22\u30df\u30b9\u3092\u9632\u6b62<\/span>\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/digital-pamphlet\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u8cc7\u6599\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\uff08\u7121\u6599\uff09<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n\r\n<div class=\"post_cta pc_cta\">\r\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; padding-bottom: 0;\"><strong><span style=\"font-size: 16px; font-weigth: bold;\">\uff3c\u3000\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4\u306e\u8a73\u3057\u3044\u60c5\u5831\u3092\u53d7\u3051\u53d6\u308b \uff0f<\/span><\/strong><\/p>\r\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; font-weigth: bold;\"><strong><span class=\"color-button02-big\"><a href=\"\/digital-pamphlet\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4\u306b\u95a2\u3059\u308b\u8cc7\u6599\u3092<br class=\"u-sp\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a><\/span><\/strong><\/p>\r\n<\/div>\r\n\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u3092\u5fdc\u7528\u3059\u308b\u65b9\u6cd5<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306f\u3001\u307b\u304b\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u5e45\u5e83\u3044\u696d\u52d9\u3067\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>IF\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5<\/strong><\/h3>\n\n\n\n<p>IF\u95a2\u6570\u306f\u6761\u4ef6\u5206\u5c90\u3092\u884c\u3046Excel\u95a2\u6570\u3067\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u304c\u771f\uff08TRUE\uff09\u306e\u5834\u5408\u306fA\u306e\u5024\u3001\u507d\uff08FALSE\uff09\u306e\u5834\u5408\u306fB\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002IF\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u6761\u4ef6\u306b\u5fdc\u3058\u3066\u691c\u7d22\u7d50\u679c\u3092\u5207\u308a\u66ff\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\u3001\u691c\u7d22\u5024\u306b\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u5165\u529b\u3057\u3001\u691c\u7d22\u7d50\u679c\u306e\u5546\u54c1\u4fa1\u683c\u304c1,000\u5186\u4ee5\u4e0a\u306e\u5834\u5408\u306f\u300c\u25ef\u300d\u30011,000\u5186\u672a\u6e80\u306e\u5834\u5408\u306f\u305d\u306e\u4fa1\u683c\u3092\u8868\u793a\u3059\u308b\u3068\u3044\u3063\u305f\u691c\u7d22\u304c\u53ef\u80fd\u3067\u3059\u3002IF\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3067\u304d\u308b\u3060\u3051\u3067\u306a\u304f\u3001\u305d\u306e\u7d50\u679c\u3092\u3055\u3089\u306b\u6761\u4ef6\u5206\u5c90\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5<\/strong><\/h3>\n\n\n\n<p>IFERROR\u95a2\u6570\u306f\u3001Excel\u95a2\u6570\u306e\u6570\u5f0f\u3067\u30a8\u30e9\u30fc\u306e\u7d50\u679c\u304c\u8fd4\u3063\u3066\u304d\u305f\u969b\u306b\u3001\u30a8\u30e9\u30fc\u8868\u793a\u306e\u4ee3\u308f\u308a\u306b\u4efb\u610f\u306e\u8868\u793a\u3092\u8a2d\u5b9a\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001VLOOKUP\u95a2\u6570\u306e\u691c\u7d22\u7d50\u679c\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306b\u3001\u4ee3\u66ff\u306e\u5024\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u3067\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3057\u3066\u691c\u7d22\u5024\u304c\u5b58\u5728\u3057\u306a\u304b\u3063\u305f\u5834\u5408\u3001\u901a\u5e38\u306f\u300c#N\/A\u300d\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002IFERROR\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u3053\u306e\u3088\u3046\u306a\u3068\u304d\u306b\u300c\u30c7\u30fc\u30bf\u306a\u3057\u300d\u3084\u300c-\u300d\u306a\u3069\u306e<span class=\"marker2\">\u4efb\u610f\u306e\u6587\u5b57\u3092\u8868\u793a\u3067\u304d\u305f\u308a\u3001\u5024\u306e\u30bb\u30eb\u3092\u7a7a\u767d\u306b\u7f6e\u304d\u63db\u3048\u305f\u308a\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd<\/span>\u3067\u3059\u3002\u8868\u5168\u4f53\u306e\u898b\u305f\u76ee\u3092\u6574\u3048\u305f\u3044\u3068\u304d\u3084\u3001\u30a8\u30e9\u30fc\u8868\u793a\u3092\u907f\u3051\u305f\u3044\u3068\u304d\u306b\u5229\u7528\u3059\u308b\u3068\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\nhttps:\/\/www.isa-school.net\/blog\/office-excel45\/\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u5225\u306e\u30b7\u30fc\u30c8\u304b\u3089\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u5024\u3092\u898b\u3064\u3051\u308b\u65b9\u6cd5<\/strong><\/h3>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306f\u30011\u3064\u306e\u30b7\u30fc\u30c8\u5185\u3067\u306e\u691c\u7d22\u3060\u3051\u3067\u306a\u304f\u3001\u5225\u306e\u30b7\u30fc\u30c8\u306b\u3042\u308b\u30c7\u30fc\u30bf\u304b\u3089\u3082\u5024\u3092\u691c\u7d22\u3067\u304d\u307e\u3059\u3002\u691c\u7d22\u7bc4\u56f2\u304c\u30b7\u30fc\u30c8\u3092\u307e\u305f\u3050\u5834\u5408\u306f\u3001\u691c\u7d22\u7bc4\u56f2\u306b\u300c\u30b7\u30fc\u30c8\u540d!\u30bb\u30eb\u7bc4\u56f2\u300d\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u6570\u306e\u30b7\u30fc\u30c8\u3092\u307e\u305f\u3044\u3060\u53c2\u7167\u304c\u884c\u3048\u307e\u3059\u3002\u3053\u3061\u3089\u306e\u691c\u7d22\u65b9\u6cd5\u306f\u3001\u30de\u30b9\u30bf\u306e\u30b7\u30fc\u30c8\u3068\u4f5c\u696d\u7528\u306e\u30b7\u30fc\u30c8\u304c\u5225\u3005\u306b\u5206\u304b\u308c\u3066\u3044\u308b\u5834\u5408\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u4f53\u9a13\u6388\u696d\u53d7\u3051\u3066\u307f\u308b<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n<div class=\"post_cta excel_cta\">\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; padding-bottom: 0;\"><strong><span style=\"font-size: 16px; font-weigth: bold;\">\uff3c\u30001\u5206\u3067\u7533\u3057\u8fbc\u307f\u5b8c\u4e86 \uff0f<\/span><\/strong><\/p>\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0;\"><strong><span class=\"color-button02-big\"><a href=\"https:\/\/www.isa-school.net\/entry\/ftrial\/\">Excel\u8b1b\u5ea7\u306e\u4f53\u9a13\u6388\u696d\u3092<br class=\"u-sp\" \/>\u7533\u3057\u8fbc\u3080<\/a><\/span><\/strong><\/p>\n\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u306e\u5bfe\u51e6\u6cd5<\/strong><\/h2>\n\n\n\n<p>VLOOKUP\u95a2\u6570\u306e\u691c\u7d22\u7d50\u679c\u3067\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u3044\u304f\u3064\u304b\u306e\u539f\u56e0\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002\u6700\u3082\u591a\u3044\u30a8\u30e9\u30fc\u539f\u56e0\u306f\u691c\u7d22\u5024\u304c\u691c\u7d22\u7bc4\u56f2\u306b\u5b58\u5728\u3057\u306a\u3044\u30b1\u30fc\u30b9\u3067\u3001\u3053\u306e\u5834\u5408\u306f\u300c#N\/A\u300d\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u3061\u3089\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u306f\u3001\u691c\u7d22\u5024\u306e\u5165\u529b\u30df\u30b9\u3084\u5168\u89d2\u30fb\u534a\u89d2\u306e\u9055\u3044\u3001\u4f59\u5206\u306a\u30b9\u30da\u30fc\u30b9\u304c\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u304b\u306a\u3069\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u691c\u7d22\u7bc4\u56f2\u3068\u5217\u756a\u53f7\u306e\u6307\u5b9a\u306e\u9593\u306b\u305a\u308c\u304c\u3042\u308b\u5834\u5408\u306f\u300c#REF!\u300d\u30a8\u30e9\u30fc\u304c\u3001\u5165\u529b\u3057\u305f\u6570\u5f0f\u304b\u53c2\u7167\u5148\u306e\u30bb\u30eb\u306b\u8aa4\u308a\u304c\u3042\u308b\u5834\u5408\u306f\u300c#VALUE!\u300d\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u5834\u5408\u3082\u5165\u529b\u3057\u305f\u6570\u5f0f\u306b\u554f\u984c\u304c\u306a\u3044\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\nhttps:\/\/www.isa-school.net\/blog\/office-excel33\/\n\n\n\n<h2 class=\"wp-block-heading\"><strong>VLOOKUP\u95a2\u6570\u3068\u4f3c\u305f\u95a2\u6570\u3068\u306e\u9055\u3044<\/strong><\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u3092\u884c\u3046\u305f\u3081\u306eExcel\u95a2\u6570\u306f\u3001VLOOKUP\u95a2\u6570\u306e\u307b\u304b\u306b\u3082\u3044\u304f\u3064\u304b\u5b58\u5728\u3057\u307e\u3059\u3002\u3053\u3053\u304b\u3089\u306f\u3001\u4f7f\u7528\u7528\u9014\u306e\u4f3c\u3066\u3044\u308b<span class=\"marker2\">HLOOKUP\u95a2\u6570<\/span>\u3068<span class=\"marker2\">XLOOKUP\u95a2\u6570<\/span>\u306b\u3064\u3044\u3066\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u3089\u4ee5\u5916\u306b\u3082\u3001\u7528\u9014\u304c\u4f3c\u3066\u3044\u308b\u691c\u7d22\u95a2\u6570\u304c\u3044\u304f\u3064\u304b\u5b58\u5728\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u306e\u7279\u5fb4\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>HLOOKUP\u95a2\u6570\u3068\u306e\u9055\u3044<\/strong><\/h3>\n\n\n\n<p>HLOOKUP\u95a2\u6570\u306f\u3001\u6a2a\u65b9\u5411\u306b\u4e26\u3093\u3060\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3059\u308b\u95a2\u6570\u3067\u3059\u3002VLOOKUP\u304c\u7e26\u65b9\u5411\u306e\u5217\u3092\u57fa\u6e96\u306b\u691c\u7d22\u3059\u308b\u306e\u306b\u5bfe\u3057\u3001HLOOKUP\u95a2\u6570\u306f\u6a2a\u65b9\u5411\u306e\u884c\u3092\u57fa\u6e96\u306b\u691c\u7d22\u3092\u884c\u3048\u307e\u3059\u3002\u691c\u7d22\u3057\u305f\u3044\u5024\u306e\u7bc4\u56f2\u304c\u6a2a\u5217\u306b\u4e26\u3093\u3067\u3044\u308b\u5834\u5408\u306f\u3001\u3053\u3061\u3089\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-icon-box jin-icon-checkcircle jin-iconbox\"><div class=\"jin-iconbox-icons\"><i class=\"jic jin-ifont-checkcircle jin-icons\"><\/i><\/div><div class=\"jin-iconbox-main\">\n<p>\uff1cHLOOKUP\u95a2\u6570\u306e\u57fa\u672c\u69cb\u6587\uff1e=HLOOKUP\uff08\u691c\u7d22\u5024, \u7bc4\u56f2, \u884c\u756a\u53f7, \u691c\u7d22\u306e\u578b\uff09<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>XLOOKUP\u95a2\u6570\u3068\u306e\u9055\u3044<\/strong><\/h3>\n\n\n\n<p>XLOOKUP\u95a2\u6570\u306f\u3001VLOOKUP\u95a2\u6570\u3068HLOOKUP\u95a2\u6570\u306e\u5f31\u70b9\u3092\u88dc\u3063\u305f\u3001\u65b0\u3057\u3044Excel\u95a2\u6570\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u95a2\u6570\u306b\u306f\u691c\u7d22\u65b9\u5411\u306e\u5236\u9650\u304c\u306a\u304f\u3001\u691c\u7d22\u5024\u306e\u5de6\u5074\u30fb\u53f3\u5074\u3069\u3061\u3089\u306e\u30c7\u30fc\u30bf\u3082\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u5217\u756a\u53f7\u3082\u6307\u5b9a\u4e0d\u8981\u3067\u3001\u691c\u7d22\u7bc4\u56f2\u3068\u8fd4\u5374\u7bc4\u56f2\u3092\u5165\u529b\u3059\u308c\u3070\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002\u3088\u308a\u67d4\u8edf\u306b\u30c7\u30fc\u30bf\u691c\u7d22\u3092\u884c\u3044\u305f\u3044\u5834\u5408\u3084\u3001\u30b7\u30fc\u30c8\u306e\u69cb\u9020\u5909\u66f4\u3092\u884c\u3046\u969b\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-icon-box jin-icon-checkcircle jin-iconbox\"><div class=\"jin-iconbox-icons\"><i class=\"jic jin-ifont-checkcircle jin-icons\"><\/i><\/div><div class=\"jin-iconbox-main\">\n<p>\uff1cXLOOKUP\u95a2\u6570\u306e\u57fa\u672c\u69cb\u6587\uff1e=XLOOKUP\uff08\u691c\u7d22\u5024, \u691c\u7d22\u7bc4\u56f2, \u623b\u308a\u7bc4\u56f2,\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408,\u4e00\u81f4\u30e2\u30fc\u30c9,\u691c\u7d22\u30e2\u30fc\u30c9\uff09<\/p>\n\n\n\n<p>\u203b\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408,\u4e00\u81f4\u30e2\u30fc\u30c9,\u691c\u7d22\u30e2\u30fc\u30c9\u306f\u7701\u7565\u53ef\u80fd<\/p>\n<\/div><\/div>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/mf\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u8cc7\u6599\u3092\u53d6\u308a\u5bc4\u305b\u308b\uff08\u7121\u6599\uff09<\/a><\/p>\n\n\n\n<div class=\"wp-block-jin-gb-block-blank-space blank-space\" style=\"height:10px\"><\/div>\n\n\n\r\n<div class=\"post_cta pc_cta\">\r\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; padding-bottom: 0;\"><strong><span style=\"font-size: 16px; font-weigth: bold;\">\uff3c\u3000\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4\u306e\u8a73\u3057\u3044\u60c5\u5831\u3092\u53d7\u3051\u53d6\u308b \uff0f<\/span><\/strong><\/p>\r\n<p class=\"has-text-align-center\" style=\"text-align: center; margin-bottom: 0; font-weigth: bold;\"><strong><span class=\"color-button02-big\"><a href=\"\/digital-pamphlet\/\">\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4\u306b\u95a2\u3059\u308b\u8cc7\u6599\u3092<br class=\"u-sp\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a><\/span><\/strong><\/p>\r\n<\/div>\r\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u307e\u3068\u3081<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-jin-gb-block-box-with-headline kaisetsu-box5\"><div class=\"kaisetsu-box5-title\">\u307e\u3068\u3081<\/div>\n<p>VLOOKUP\u95a2\u6570\u3067\u6b63\u78ba\u306a\u691c\u7d22\u7d50\u679c\u3092\u5f97\u305f\u3044\u5834\u5408\u306f\u3001\u691c\u7d22\u306e\u578b\u306b\u300cFALSE\u300d\u307e\u305f\u306f\u300c0\u300d\u3092\u5165\u529b\u3057\u3066\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3092\u884c\u3044\u307e\u3057\u3087\u3046\u3002\u307e\u305f\u3001IF\u95a2\u6570\u3084IFERROR\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u306b\u3088\u308b\u30a8\u30e9\u30fc\u8868\u793a\u3092\u9632\u3050\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p>ISA\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4\u3067\u306f\u3001\u793e\u4f1a\u4eba\u3084\u6c42\u8077\u8005\u306e\u30d1\u30bd\u30b3\u30f3\u30b9\u30ad\u30eb\u3092\u9ad8\u3081\u308b\u8b1b\u5ea7\u3092\u5e45\u5e83\u304f\u958b\u8b1b\u3057\u3066\u3044\u307e\u3059\u3002VLOOKUP\u95a2\u6570\u3092\u306f\u3058\u3081\u3068\u3057\u305fExcel\u95a2\u6570\u3092\u5c02\u9580\u7684\u306b\u5b66\u7fd2\u3057\u305f\u3044\u4eba\u306f\u3001\u300cExcel\u8b1b\u5ea7\u300d\u3084\u300c\u4ed5\u4e8b\u3067\u4f7f\u3048\u308bExcel\u30d3\u30b8\u30cd\u30b9\u6d3b\u7528\u300d\u306a\u3069\u306e\u8b1b\u5ea7\u3092\u53d7\u8b1b\u3057\u3066\u307f\u3066\u306f\u3044\u304b\u304c\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<\/div>\n\n\n\n<p><a href=\"https:\/\/www.isa-school.net\/entry\/mf\/\">\u30d1\u30bd\u30b3\u30f3\u8b1b\u5ea7\u306e\u8cc7\u6599\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u300c\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u300d\u30e9\u30a4\u30bf\u30fc\u30c1\u30fc\u30e0\u3067\u3059\u3002 Excel\u3067\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3063\u305f\u3068\u304d\u3001\u7279\u5b9a\u306e\u5024\u3068\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u3092\u6b63\u78ba\u306b\u62bd\u51fa\u3057\u305f\u3044\u3068\u611f\u3058\u305f\u3053\u3068\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002\u305d\u306e\u3088\u3046\u306a\u5834\u9762\u3067\u6d3b\u8e8d\u3059\u308b\u306e\u304c\u3001VLOOKUP\u95a2\u6570\u3067\u3059\u3002\u306a\u304b\u3067\u3082\u691c\u7d22<\/p>\n","protected":false},"author":3,"featured_media":4478,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jin_ogp_image_url":"","_jin_last_featured_id":0,"footnotes":""},"categories":[8,3],"tags":[],"class_list":["post-4476","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-office"],"views":930,"_links":{"self":[{"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/posts\/4476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/comments?post=4476"}],"version-history":[{"count":3,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/posts\/4476\/revisions"}],"predecessor-version":[{"id":4537,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/posts\/4476\/revisions\/4537"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/media\/4478"}],"wp:attachment":[{"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/media?parent=4476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/categories?post=4476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isa-school.net\/blog\/wp-json\/wp\/v2\/tags?post=4476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}