id: 1b3392b3d2764040ba688e1d98381208
parent_id: 
item_type: 1
item_id: bea6542a5ca04a6ca4095b7add1c390b
item_updated_time: 1764345484309
title_diff: "[{\"diffs\":[[1,\"只会Vlookup函数Out了！Excel所有查找公式全在这儿（共16大类）\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":38}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>只会Vlookup函数Out了！Excel所有查找公式全在这儿（共16大类）</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"19363\\\"></a>\\\r\\\n<h1>只会Vlookup函数Out了！Excel所有查找公式全在这儿（共16大类）</h1>\\\r\\\n\\\r\\\n<div><span style=\\\"margin:0px;\\\"><div style=\\\"padding:8px 0px;margin:8px auto;max-width:700px;\\\"> <div style=\\\"margin:0;padding:0;background-color:#fff\\\"><div style=\\\"margin:0;padding:0\\\"><div style=\\\"margin:0;padding:0\\\"><h2 style=\\\"font-weight:400;margin:0;padding:0;font-size:22px;line-height:1.4;margin-bottom:14px\\\"> 只会Vlookup函数Out了！Excel所有查找公式全在这儿（共16大类） </h2><div style=\\\"margin:0;padding:0;margin-bottom:22px;line-height:20px;font-size:0;word-wrap:break-word;word-break:break-all\\\"><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);margin-right:0;color:rgba(0,0,0,0.3)\\\">原创：</span><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);color:rgba(0,0,0,0.3)\\\"> 兰色幻想-赵志东 </span><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);position:relative\\\"><a style=\\\"margin:0;padding:0;color:#576b95;text-decoration:none;-webkit-tap-highlight-color:rgba(0,0,0,0)\\\"> Excel精英培训 </a></span><em style=\\\"padding:0;font-style:normal;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);color:rgba(0,0,0,0.3)\\\"></em></div><div style=\\\"margin:0;padding:0;overflow:hidden;color:#333;font-size:17px;word-wrap:break-word;-webkit-hyphens:auto;-ms-hyphens:auto;hyphens:auto;text-align:justify;position:relative;z-index:0\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(136,136,136)\\\">前言：</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(136,136,136)\\\">最近收到很多同学关于查找公式的提问，兰色就把原来整理一篇查找公式再次分享出来，没有收藏的这次别错过了。</span><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">找对比，你会首先想到</span><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">Vlookup</strong><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">函数。但在Excel中只会Vlookup函数是远远不够的。今天兰色对查找公式进行一次全面的整理。（</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(136,136,136);box-sizing:border-box !important;word-wrap:break-word !important\\\">注：一题多解的只选取最优公式</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">）</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">1、普通查找</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">查找李晓峰的应发工资</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=VLOOKUP(H2,B:F,5,0)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/0b501ff327a04bb0bb2f4f53b3d154b2\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">2、反向查找</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">查找吴刚的员工编号<br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=INDEX(A:A,MATCH(H2,B:B,0))</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/0d3ee1c322084785bda6106f7dd552b3\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">3、交叉查找</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">查找3月办公费的金额<br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=VLOOKUP(H2,A:F,MATCH(I2,1:1,0),0)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/30b9b06a1f1046d7ae8369429b2a010a\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">4、多条件查找</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">查找上海产品B的销量</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=LOOKUP(1,0/((A2:A7=E2)*(B2:B7=F2)),C2:C7)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/ee552be0aec04747bee6fed44dc7499c\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">5、区间查找</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">根据销量从右表中查找提成比率。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=LOOKUP(A2,$D$2:$E$5)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/185ae2f171c84faa83b65583a3031be1\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">6、双区间查找</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">根据销量和比率完成情况，从表中查找返利。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=INDEX(B3:F7,MATCH(D11,A3:A7),MATCH(E11,B2:F2))</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/2b1e8fdc95244618863b7aa96ea63ed4\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;line-height:1.6;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">7、线型插值</span></strong><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">如下图所示，A列是数量，B列是数量对应的系数值。现要求出数字8所对应的系数值。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;line-height:24px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">=</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(192,0,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">TREND</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(84,141,212);box-sizing:border-box !important;word-wrap:break-word !important\\\">OFFSET</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">(B1,</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">MATCH(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">D3,A2:A6,1</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">)</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">,,2,1),</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(84,141,212);box-sizing:border-box !important;word-wrap:break-word !important\\\">OFFSET</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">(A1,</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">MATCH(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">D3,A2:A6,1</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">)</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">,,2,1),</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;color:rgb(149,55,52);box-sizing:border-box !important;word-wrap:break-word !important\\\">D3</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">)</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/de69ebbb6f7c46858d18b0499d3afe63\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;line-height:1.6;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">8、查找最后一个符合条件记录</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\">如下图所示，要求查找A产品的最后一次进价。</p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=LOOKUP(1,0/(B2:B9=A13),C2:C9)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/b79c5753e65349a39eba5d6746410cd7\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">9、模糊查找</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\">如下图所示，要求根据提供的城市从上表中查找该市名的第2列的值。</p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=VLOOKUP(&quot;*&quot;&amp;A7&amp;&quot;*&quot;,A1:B4,2,0)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/cdb9b58fadfc43e0839ea24bbd655db9\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:1.6;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">10、匹配查找</span></strong><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">如下图所示，要求根据地址从上表中查找所在城市的提成。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=lookup(9^9.find(A$3:A$6,A10),B$3:B$6)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/e21e144f14724f23aad51495da8890c8\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:1.6;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">11、最后一个非空值查找</span></strong><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">如下图所示，要求查找最后一次还款日期</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">=LOOKUP(1,0/(B2:B13&lt;&gt;&quot;&quot;),$A2:$A13)</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/caef02fd0f884db8a74be5893764f17c\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;font-size:16px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">12、多工作表查找</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">【例10】从各部门中查找员工的基本工资，在哪一个表中不一定。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;box-sizing:border-box !important;word-wrap:break-word !important\\\">方法1</strong><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;line-height:25.6px;white-space:pre-wrap;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">=IFERROR(<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(84,141,212);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP(A2,服务!A:G,7,0),</span>IFERROR(<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(149,55,52);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP(A2,人事!A:G,7,0),</span>IFERROR(<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,176,80);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP(A2,综合!A:G,7,0),</span>IFERROR(<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(95,73,122);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP(A2,财务!A:G,7,0),</span>IFERROR(<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(192,0,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP(A2,销售!A:G,7,0)</span>,&quot;无此人信息&quot;)))))</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;line-height:25.6px;white-space:pre-wrap;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">方法2：</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;line-height:25.6px;white-space:pre-wrap;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">=VLOOKUP(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(49,133,155);box-sizing:border-box !important;word-wrap:break-word !important\\\">A2</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">,INDIRECT(LOOKUP(1,0/COUNTIF(INDIRECT(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(217,150,148);box-sizing:border-box !important;word-wrap:break-word !important\\\">{&quot;销售&quot;;&quot;服务&quot;;&quot;人事&quot;;&quot;综合&quot;;&quot;财务&quot;}</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">&amp;&quot;!</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(255,192,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">a:a</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">&quot;),</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(49,133,155);box-sizing:border-box !important;word-wrap:break-word !important\\\">A2</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">),</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(217,150,148);box-sizing:border-box !important;word-wrap:break-word !important\\\">{&quot;销售&quot;;&quot;服务&quot;;&quot;人事&quot;;&quot;综合&quot;;&quot;财务&quot;}</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">)&amp;&quot;!</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(0,176,80);box-sizing:border-box !important;word-wrap:break-word !important\\\">a:g</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">&quot;),</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(0,32,96);box-sizing:border-box !important;word-wrap:break-word !important\\\">7</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">,0)</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;line-height:25.6px;white-space:pre-wrap;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/2bdc5244d0554e98b02f4307edd174b8\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;line-height:25.6px;white-space:pre-wrap;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/958fe64901c0419b8e24504788b7bdbb\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">13、一对多查找</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">【例】根据产品查找相对应的所有供应商</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;box-sizing:border-box !important;word-wrap:break-word !important\\\">A2 =</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">B2</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;box-sizing:border-box !important;word-wrap:break-word !important\\\">&amp;</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;color:rgb(0,176,240);box-sizing:border-box !important;word-wrap:break-word !important\\\">COUNTIF(B<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(227,108,9);box-sizing:border-box !important;word-wrap:break-word !important\\\">$</span>1:B2,B2)</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;white-space:pre-wrap;color:rgb(0,176,240);font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">B11<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(62,62,62);line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">=</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(0,112,192);box-sizing:border-box !important;word-wrap:break-word !important\\\">IFERROR</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(62,62,62);line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(192,0,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">VLOOKUP</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(62,62,62);line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(118,146,60);box-sizing:border-box !important;word-wrap:break-word !important\\\">$A11&amp;COLUMN(A1)</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(62,62,62);line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">,$A:$C,3,0),&quot;&quot;)</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/4735926aa84447d2aedb870274ed5b12\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;background-color:rgb(238,237,235);border-width:1px;border-style:solid;border-color:rgb(238,237,235);background-size:22px;background-position:center center;background-repeat:no-repeat;line-height:25.6px;white-space:pre-wrap;box-sizing:border-box !important;word-wrap:break-word !important;height:347px !important;visibility:visible !important;width:605px !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">14、查找销量最大的城市</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">查找销量最大的城市（<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(136,136,136);box-sizing:border-box !important;word-wrap:break-word !important\\\">数组公式按ctrl+shift+enter三键输入</span>）</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">{=INDEX(A:A,MAX((MAX(B3:B7)=B3:B7)*ROW(B3:B7)))}</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/5f009ddee96149b4bf7d7a4ce4bdb52f\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">15、最接近值查找</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;line-height:1.6;box-sizing:border-box !important;word-wrap:break-word !important\\\">根据D4的价格，在B列查找最接近的价格，并返回相对应的日期</span><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">（</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(136,136,136);box-sizing:border-box !important;word-wrap:break-word !important\\\">数组公式按ctrl+shift+enter三键输入</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">）</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">{=LOOKUP(1,0/(MIN(ABS(B3:B7-D4))=ABS(B3:B7-D4))*ROW(B3:B7),A3:A7)}</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;color:rgb(64,118,0);box-sizing:border-box !important;word-wrap:break-word !important\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/3c4a80c3776f41919aa1af15a0f74b56\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">15、跨多文件查找</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">跨多个文件查找，估计你搜遍网络也找不到，这也是兰色首次编写跨多文件查找公式。其实原理和跨多表查找一样，也是借助lookup等函数实现。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">文件夹中有N个仓库产品表格，需要在“查询”文件完成查询</span><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/71de40a957c0450880b1a98fcde8dcc8\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">仓库表样式</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/61a604d7646543979c11596c5f9e74c8\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;background-color:rgb(238,237,235);border-width:1px;border-style:solid;border-color:rgb(238,237,235);background-size:22px;background-position:center center;background-repeat:no-repeat;box-sizing:border-box !important;word-wrap:break-word !important;height:436px !important;visibility:visible !important;width:544px !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">在查询表中设置公式，根据产品名称从指定的文件中sheet1工作表查询<strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">入库单价</strong></span><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><div style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><div style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;margin-right:auto;margin-left:auto;width:451.188px;background-color:rgb(229,244,250);box-sizing:border-box !important;word-wrap:break-word !important\\\"><div style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/1be433ebdf634da08fd439640bd84356\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important;height:33.825px !important;visibility:visible !important;width:451px !important\\\" width=\\\"451.188px\\\"/></div><div style=\\\"margin:0;max-width:100% !important;-webkit-box-sizing:border-box !important;padding:20px 10px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:22.4px;white-space:pre-wrap;font-size:14px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;text-indent:32px;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">=VLOOKUP(A2,INDIRECT(LOOKUP(1,0/COUNTIF(INDIRECT(</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;color:rgb(0,82,255);box-sizing:border-box !important;word-wrap:break-word !important\\\">&quot;[&quot;&amp;{&quot;仓库1&quot;;&quot;仓库2&quot;;&quot;仓库3&quot;}&amp;&quot;.xlsx]sheet1!a:a&quot;</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\">),A2),&quot;[&quot;&amp;{&quot;仓库1&quot;;&quot;仓库2&quot;;&quot;仓库3&quot;}&amp;&quot;.xlsx]sheet1&quot;)&amp;&quot;!a:b&quot;),2,0)</span>。</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;box-sizing:border-box !important;word-wrap:break-word !important\\\"></span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p></div></div></div><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/d8724c5f967546ca980f8a6863e98ddb\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:14px;color:rgb(136,136,136);box-sizing:border-box !important;word-wrap:break-word !important\\\">vlookup函数的多文件查找，同样可以用<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\">iferror+vlookup</span>的模式，公式虽然长，但容易理解且公式不容易出错。另外，如果excel文件有几十个或更多，就需要使用宏表函数用<span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,0,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">Files</span>获取所有excel文件名称，然后应用到公式中，具体的公式兰色就不再写了。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;color:rgb(0,122,170);box-sizing:border-box !important;word-wrap:break-word !important\\\">兰色说</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;font-size:15px;box-sizing:border-box !important;word-wrap:break-word !important\\\">：能想到的查找公式差不多都列出来了，其中有不少公式需要有一定基础才能看懂。如果看不明白先学会套用以后再慢慢理解。</span><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:14px;color:rgb(255,76,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">长按</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:14px;box-sizing:border-box !important;word-wrap:break-word !important\\\">下面微信公众号二维码图片，点上面”</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:14px;color:rgb(255,76,0);box-sizing:border-box !important;word-wrap:break-word !important\\\">识别图中二维码</span><span style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;line-height:25.6px;font-size:14px;box-sizing:border-box !important;word-wrap:break-word !important\\\">“然后再点关注，每天可以收到一篇兰色最新写的excel教程。</span><br style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;clear:both;margin-bottom:10px;min-height:1em;font-family:-apple-system-font,BlinkMacSystemFont,&quot;Helvetica Neue&quot;,&quot;PingFang SC&quot;,&quot;Hiragino Sans GB&quot;,&quot;Microsoft YaHei UI&quot;,&quot;Microsoft YaHei&quot;,Arial,sans-serif;letter-spacing:0.544px;white-space:normal;line-height:25.6px;text-align:center;background-color:rgb(255,255,255);box-sizing:border-box !important;word-wrap:break-word !important\\\"><img src=\\\":/26c2f1c5774c4d0f8da033667c6a3453\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;-webkit-box-sizing:border-box !important;height:auto !important;box-sizing:border-box !important;word-wrap:break-word !important;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p></div></div><ul style=\\\"margin:0;padding:0\\\"></ul><div style=\\\"margin:0;padding:0;padding-top:15px\\\"><div style=\\\"margin:0;padding:0\\\"><span style=\\\"margin:0;padding:0;visibility:hidden\\\"><span style=\\\"margin:0;padding:0\\\"><span style=\\\"margin:0;padding:0\\\"> 在看</span><span style=\\\"margin:0;padding:0\\\"></span></span></span></div></div></div></div></div></span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":96980}]"
metadata_diff: {"new":{"id":"bea6542a5ca04a6ca4095b7add1c390b","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345851808,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:20:20.380Z
created_time: 2025-11-28T16:20:20.380Z
type_: 13