{"id":70539,"date":"2026-02-02T01:57:20","date_gmt":"2026-02-01T17:57:20","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/70539.html"},"modified":"2026-02-02T01:57:20","modified_gmt":"2026-02-01T17:57:20","slug":"excel-vlookup%e5%87%bd%e6%95%b0%e5%ae%8c%e5%85%a8%e6%8c%87%e5%8d%97%ef%bc%9a%e4%bb%8e%e5%85%a5%e9%97%a8%e5%88%b0%e7%b2%be%e9%80%9a%ef%bc%8c%e5%85%ab%e5%a4%a7%e5%ae%9e%e6%88%98%e5%9c%ba%e6%99%af","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/70539.html","title":{"rendered":"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790"},"content":{"rendered":"<p id=\"main-toc\">\u76ee\u5f55<\/p>\n<p id=\"%E4%B8%80%E3%80%81%E5%9F%BA%E7%A1%80%E5%85%A5%E9%97%A8%EF%BC%9AVLOOKUP%E5%87%BD%E6%95%B0%E5%9F%BA%E7%A1%80%E8%AF%AD%E6%B3%95-toc\" style=\"margin-left:40px\">\u4e00\u3001\u57fa\u7840\u5165\u95e8&#xff1a;VLOOKUP\u51fd\u6570\u57fa\u7840\u8bed\u6cd5<\/p>\n<p id=\"%E5%87%BD%E6%95%B0%E8%AF%AD%E6%B3%95%E8%AF%A6%E8%A7%A3-toc\" style=\"margin-left:80px\">\u51fd\u6570\u8bed\u6cd5\u8be6\u89e3<\/p>\n<p id=\"%E5%BF%AB%E6%8D%B7%E6%8A%80%E5%B7%A7%EF%BC%9A%E7%BB%9D%E5%AF%B9%E5%BC%95%E7%94%A8%E4%B8%8EF4%E9%94%AE-toc\" style=\"margin-left:80px\">\u5feb\u6377\u6280\u5de7&#xff1a;\u7edd\u5bf9\u5f15\u7528\u4e0eF4\u952e<\/p>\n<p id=\"%E4%BA%8C%E3%80%81%E6%A1%88%E4%BE%8B1%EF%BC%9A%E7%B2%BE%E7%A1%AE%E5%8C%B9%E9%85%8D%E6%9F%A5%E6%89%BE%20-%20%E6%A0%B9%E6%8D%AE%E5%AD%A6%E5%8F%B7%E8%A1%A5%E5%85%A8%E4%BF%A1%E6%81%AF-toc\" style=\"margin-left:40px\">\u4e8c\u3001\u6848\u4f8b1&#xff1a;\u7cbe\u786e\u5339\u914d\u67e5\u627e &#8211; \u6839\u636e\u5b66\u53f7\u8865\u5168\u4fe1\u606f<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E6%95%B0%E6%8D%AE%E7%A4%BA%E4%BE%8B-toc\" style=\"margin-left:80px\">\u6570\u636e\u793a\u4f8b<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E6%A0%B8%E5%BF%83%E8%A6%81%E7%82%B9-toc\" style=\"margin-left:80px\">\u6838\u5fc3\u8981\u70b9<\/p>\n<p id=\"%E4%B8%89%E3%80%81%E6%A1%88%E4%BE%8B2%EF%BC%9A%E5%B7%A5%E8%B5%84%E8%AE%A1%E7%AE%97%20-%20VLOOKUP%E4%B8%8E%E6%95%B0%E5%AD%A6%E8%BF%90%E7%AE%97%E7%BB%93%E5%90%88-toc\" style=\"margin-left:40px\">\u4e09\u3001\u6848\u4f8b2&#xff1a;\u5de5\u8d44\u8ba1\u7b97 &#8211; VLOOKUP\u4e0e\u6570\u5b66\u8fd0\u7b97\u7ed3\u5408<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E5%85%AC%E5%BC%8F%E8%A7%A3%E6%9E%90-toc\" style=\"margin-left:80px\">\u516c\u5f0f\u89e3\u6790<\/p>\n<p id=\"%E5%9B%9B%E3%80%81%E6%A1%88%E4%BE%8B3%EF%BC%9A%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%20-%20%E4%B8%9A%E7%BB%A9%E6%8F%90%E6%88%90%E8%AE%A1%E7%AE%97-toc\" style=\"margin-left:40px\">\u56db\u3001\u6848\u4f8b3&#xff1a;\u8fd1\u4f3c\u5339\u914d &#8211; \u4e1a\u7ee9\u63d0\u6210\u8ba1\u7b97<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E6%95%B0%E6%8D%AE%E5%87%86%E5%A4%87-toc\" style=\"margin-left:80px\">\u6570\u636e\u51c6\u5907<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%E8%A6%81%E7%82%B9-toc\" style=\"margin-left:80px\">\u8fd1\u4f3c\u5339\u914d\u8981\u70b9<\/p>\n<p id=\"%E5%AE%9E%E9%99%85%E8%AE%A1%E7%AE%97%E7%A4%BA%E4%BE%8B-toc\" style=\"margin-left:80px\">\u5b9e\u9645\u8ba1\u7b97\u793a\u4f8b<\/p>\n<p id=\"%E4%BA%94%E3%80%81%E6%A1%88%E4%BE%8B4%EF%BC%9A%E9%80%9A%E9%85%8D%E7%AC%A6%E5%BA%94%E7%94%A8%20-%20%E6%A8%A1%E7%B3%8A%E6%9F%A5%E6%89%BE-toc\" style=\"margin-left:40px\">\u4e94\u3001\u6848\u4f8b4&#xff1a;\u901a\u914d\u7b26\u5e94\u7528 &#8211; \u6a21\u7cca\u67e5\u627e<\/p>\n<p id=\"%E9%80%9A%E9%85%8D%E7%AC%A6%E4%BB%8B%E7%BB%8D-toc\" style=\"margin-left:80px\">\u901a\u914d\u7b26\u4ecb\u7ecd<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E5%BA%94%E7%94%A8%E5%9C%BA%E6%99%AF-toc\" style=\"margin-left:80px\">\u5e94\u7528\u573a\u666f<\/p>\n<p id=\"%E5%85%AD%E3%80%81%E6%A1%88%E4%BE%8B5%EF%BC%9A%E9%80%86%E5%90%91%E6%9F%A5%E6%89%BE%20-%20IF(%7B1%2C0%7D)%E7%BB%8F%E5%85%B8%E7%BB%93%E6%9E%84-toc\" style=\"margin-left:40px\">\u516d\u3001\u6848\u4f8b5&#xff1a;\u9006\u5411\u67e5\u627e &#8211; IF({1,0})\u7ecf\u5178\u7ed3\u6784<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E5%8E%9F%E7%90%86%E8%A7%A3%E6%9E%90-toc\" style=\"margin-left:80px\">\u539f\u7406\u89e3\u6790<\/p>\n<p id=\"%E8%BF%9B%E9%98%B6%E5%BA%94%E7%94%A8%EF%BC%9A%E5%A4%9A%E6%9D%A1%E4%BB%B6%E6%9F%A5%E6%89%BE-toc\" style=\"margin-left:80px\">\u8fdb\u9636\u5e94\u7528&#xff1a;\u591a\u6761\u4ef6\u67e5\u627e<\/p>\n<p id=\"%E4%B8%83%E3%80%81%E6%A1%88%E4%BE%8B6%EF%BC%9A%E4%B8%80%E5%AF%B9%E5%A4%9A%E6%9F%A5%E8%AF%A2%20-%20%E7%AA%81%E7%A0%B4VLOOKUP%E9%99%90%E5%88%B6-toc\" style=\"margin-left:40px\">\u4e03\u3001\u6848\u4f8b6&#xff1a;\u4e00\u5bf9\u591a\u67e5\u8be2 &#8211; \u7a81\u7834VLOOKUP\u9650\u5236<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%EF%BC%9A%E8%BE%85%E5%8A%A9%E5%88%97%E6%B3%95-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848&#xff1a;\u8f85\u52a9\u5217\u6cd5<\/p>\n<p id=\"1.%20%E5%88%9B%E5%BB%BA%E8%BE%85%E5%8A%A9%E5%88%97-toc\" style=\"margin-left:120px\">1. \u521b\u5efa\u8f85\u52a9\u5217<\/p>\n<p id=\"2.%20%E6%9F%A5%E8%AF%A2%E5%85%AC%E5%BC%8F-toc\" style=\"margin-left:120px\">2. \u67e5\u8be2\u516c\u5f0f<\/p>\n<p id=\"3.%20%E5%90%91%E4%B8%8B%E5%A1%AB%E5%85%85-toc\" style=\"margin-left:120px\">3. \u5411\u4e0b\u586b\u5145<\/p>\n<p id=\"%E5%85%AB%E3%80%81%E6%A1%88%E4%BE%8B7%EF%BC%9A%E5%A4%9A%E5%80%BC%E6%9F%A5%E8%AF%A2%E4%B8%8E%E6%95%B0%E7%BB%84%E5%BA%94%E7%94%A8-toc\" style=\"margin-left:40px\">\u516b\u3001\u6848\u4f8b7&#xff1a;\u591a\u503c\u67e5\u8be2\u4e0e\u6570\u7ec4\u5e94\u7528<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42<\/p>\n<p id=\"N()%E5%92%8CT()%E5%87%BD%E6%95%B0-toc\" style=\"margin-left:80px\">N()\u548cT()\u51fd\u6570<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"%E4%B9%9D%E3%80%81%E6%A1%88%E4%BE%8B8%EF%BC%9A%E6%9F%A5%E8%AF%A2%E8%BF%94%E5%9B%9E%E5%A4%9A%E5%88%97%E4%BF%A1%E6%81%AF%EF%BC%88%E7%AC%AC%E4%B8%89%E5%8F%82%E6%95%B0%E5%BA%94%E7%94%A8%EF%BC%89-toc\" style=\"margin-left:40px\">\u4e5d\u3001\u6848\u4f8b8&#xff1a;\u67e5\u8be2\u8fd4\u56de\u591a\u5217\u4fe1\u606f&#xff08;\u7b2c\u4e09\u53c2\u6570\u5e94\u7528&#xff09;<\/p>\n<p id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82%EF%BC%9A%E6%B1%82%E6%89%80%E9%80%89%E5%A7%93%E5%90%8D%E5%9C%A8%E6%89%80%E6%9C%89%E5%B9%B4%E4%BB%BD%E7%9A%84%E6%80%BB%E9%94%80%E9%87%8F-toc\" style=\"margin-left:80px\">\u573a\u666f\u9700\u6c42&#xff1a;\u6c42\u6240\u9009\u59d3\u540d\u5728\u6240\u6709\u5e74\u4efd\u7684\u603b\u9500\u91cf<\/p>\n<p id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%EF%BC%9A-toc\" style=\"margin-left:80px\">\u89e3\u51b3\u65b9\u6848&#xff1a;<\/p>\n<p id=\"%E8%BF%94%E5%9B%9E%E5%A4%9A%E5%88%97%E4%BF%A1%E6%81%AF-toc\" style=\"margin-left:80px\">\u8fd4\u56de\u591a\u5217\u4fe1\u606f<\/p>\n<p id=\"%E4%B9%9D%E3%80%81VLOOKUP%E5%B8%B8%E8%A7%81%E9%94%99%E8%AF%AF%E4%B8%8E%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:40px\">\u4e5d\u3001VLOOKUP\u5e38\u89c1\u9519\u8bef\u4e0e\u89e3\u51b3\u65b9\u6848<\/p>\n<p id=\"1.%20%23N%2FA%E9%94%99%E8%AF%AF%EF%BC%9A%E6%89%BE%E4%B8%8D%E5%88%B0%E6%9F%A5%E6%89%BE%E5%80%BC-toc\" style=\"margin-left:80px\">1. #N\/A\u9519\u8bef&#xff1a;\u627e\u4e0d\u5230\u67e5\u627e\u503c<\/p>\n<p id=\"2.%20%23REF!%E9%94%99%E8%AF%AF%EF%BC%9A%E8%BF%94%E5%9B%9E%E5%88%97%E6%95%B0%E8%B6%85%E5%87%BA%E8%8C%83%E5%9B%B4-toc\" style=\"margin-left:80px\">2. #REF!\u9519\u8bef&#xff1a;\u8fd4\u56de\u5217\u6570\u8d85\u51fa\u8303\u56f4<\/p>\n<p id=\"3.%20%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF-toc\" style=\"margin-left:80px\">3. \u8fd1\u4f3c\u5339\u914d\u7ed3\u679c\u9519\u8bef<\/p>\n<p id=\"4.%20%E6%9F%A5%E6%89%BE%E5%80%BC%E7%B1%BB%E5%9E%8B%E4%B8%8D%E5%8C%B9%E9%85%8D-toc\" style=\"margin-left:80px\">4. \u67e5\u627e\u503c\u7c7b\u578b\u4e0d\u5339\u914d<\/p>\n<p id=\"%E5%8D%81%E3%80%81VLOOKUP%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E6%8A%80%E5%B7%A7-toc\" style=\"margin-left:40px\">\u5341\u3001VLOOKUP\u6027\u80fd\u4f18\u5316\u6280\u5de7<\/p>\n<p id=\"1.%20%E9%99%90%E5%88%B6%E6%9F%A5%E6%89%BE%E8%8C%83%E5%9B%B4-toc\" style=\"margin-left:80px\">1. \u9650\u5236\u67e5\u627e\u8303\u56f4<\/p>\n<p id=\"2.%20%E4%BD%BF%E7%94%A8%E8%A1%A8%E6%A0%BC%E5%BC%95%E7%94%A8%EF%BC%88Excel%202007%2B%EF%BC%89-toc\" style=\"margin-left:80px\">2. \u4f7f\u7528\u8868\u683c\u5f15\u7528&#xff08;Excel 2007&#043;&#xff09;<\/p>\n<p id=\"3.%20%E6%8E%92%E5%BA%8F%E4%BC%98%E5%8C%96-toc\" style=\"margin-left:80px\">3. \u6392\u5e8f\u4f18\u5316<\/p>\n<p id=\"%E5%8D%81%E4%B8%80%E3%80%81VLOOKUP%E6%9B%BF%E4%BB%A3%E6%96%B9%E6%A1%88-toc\" style=\"margin-left:40px\">\u5341\u4e00\u3001VLOOKUP\u66ff\u4ee3\u65b9\u6848<\/p>\n<p id=\"1.%20INDEX%2BMATCH%E7%BB%84%E5%90%88-toc\" style=\"margin-left:80px\">1. INDEX&#043;MATCH\u7ec4\u5408<\/p>\n<p id=\"2.%20XLOOKUP%EF%BC%88Office%20365%EF%BC%89-toc\" style=\"margin-left:80px\">2. XLOOKUP&#xff08;Office 365&#xff09;<\/p>\n<p id=\"3.%20FILTER%E5%87%BD%E6%95%B0%EF%BC%88Office%20365%EF%BC%89-toc\" style=\"margin-left:80px\">3. FILTER\u51fd\u6570&#xff08;Office 365&#xff09;<\/p>\n<p id=\"%E5%8D%81%E4%BA%8C%E3%80%81%E5%AE%9E%E6%88%98%E7%BB%BC%E5%90%88%E5%BA%94%E7%94%A8-toc\" style=\"margin-left:40px\">\u5341\u4e8c\u3001\u5b9e\u6218\u7efc\u5408\u5e94\u7528<\/p>\n<p id=\"%E5%88%9B%E5%BB%BA%E5%8A%A8%E6%80%81%E6%9F%A5%E8%AF%A2%E7%B3%BB%E7%BB%9F-toc\" style=\"margin-left:80px\">\u521b\u5efa\u52a8\u6001\u67e5\u8be2\u7cfb\u7edf<\/p>\n<p id=\"%E6%9E%84%E5%BB%BA%E5%A4%9A%E7%BA%A7%E8%81%94%E5%8A%A8%E6%9F%A5%E8%AF%A2-toc\" style=\"margin-left:80px\">\u6784\u5efa\u591a\u7ea7\u8054\u52a8\u67e5\u8be2<\/p>\n<p id=\"%E5%8D%81%E4%B8%89%E3%80%81%E6%80%BB%E7%BB%93%E4%B8%8E%E6%9C%80%E4%BD%B3%E5%AE%9E%E8%B7%B5-toc\" style=\"margin-left:40px\">\u5341\u4e09\u3001\u603b\u7ed3\u4e0e\u6700\u4f73\u5b9e\u8df5<\/p>\n<p id=\"VLOOKUP%E4%BD%BF%E7%94%A8%E5%86%B3%E7%AD%96%E6%A0%91-toc\" style=\"margin-left:80px\">VLOOKUP\u4f7f\u7528\u51b3\u7b56\u6811<\/p>\n<p id=\"%E8%AE%B0%E5%BF%86%E8%A6%81%E7%82%B9-toc\" style=\"margin-left:80px\">\u8bb0\u5fc6\u8981\u70b9<\/p>\n<p id=\"%E5%AD%A6%E4%B9%A0%E8%B7%AF%E5%BE%84%E5%BB%BA%E8%AE%AE-toc\" style=\"margin-left:80px\">\u5b66\u4e60\u8def\u5f84\u5efa\u8bae<\/p>\n<hr \/>\n<p>\u5982\u679c\u4f60\u53ea\u80fd\u5b66\u4e60\u4e00\u4e2aExcel\u51fd\u6570&#xff0c;\u90a3\u4e00\u5b9a\u662fVLOOKUP\u3002\u4f5c\u4e3aExcel\u4e2d\u6700\u5f3a\u5927\u3001\u6700\u5b9e\u7528\u7684\u67e5\u627e\u51fd\u6570&#xff0c;VLOOKUP\u662f\u6570\u636e\u5904\u7406\u4e0e\u5206\u6790\u7684\u6838\u5fc3\u6280\u80fd\u3002\u672c\u6587\u5c06\u5e26\u4f60\u4ece\u96f6\u5f00\u59cb&#xff0c;\u901a\u8fc7\u516b\u5927\u5b9e\u6218\u6848\u4f8b&#xff0c;\u5168\u9762\u638c\u63e1VLOOKUP\u51fd\u6570\u7684\u7cbe\u9ad3\u3002<\/p>\n<h3 id=\"%E4%B8%80%E3%80%81%E5%9F%BA%E7%A1%80%E5%85%A5%E9%97%A8%EF%BC%9AVLOOKUP%E5%87%BD%E6%95%B0%E5%9F%BA%E7%A1%80%E8%AF%AD%E6%B3%95\">\u4e00\u3001\u57fa\u7840\u5165\u95e8&#xff1a;VLOOKUP\u51fd\u6570\u57fa\u7840\u8bed\u6cd5<\/h3>\n<h4 id=\"%E5%87%BD%E6%95%B0%E8%AF%AD%E6%B3%95%E8%AF%A6%E8%A7%A3\">\u51fd\u6570\u8bed\u6cd5\u8be6\u89e3<\/h4>\n<p>VLOOKUP(\u67e5\u627e\u503c, \u67e5\u627e\u533a\u57df, \u8fd4\u56de\u5217\u6570, [\u5339\u914d\u7c7b\u578b])<\/p>\n<ul>\n<li>\n<p>\u67e5\u627e\u503c&#xff1a;\u8981\u67e5\u627e\u7684\u5185\u5bb9&#xff0c;\u53ef\u4ee5\u662f\u6570\u503c\u3001\u6587\u672c\u6216\u5355\u5143\u683c\u5f15\u7528<\/p>\n<\/li>\n<li>\n<p>\u67e5\u627e\u533a\u57df&#xff1a;\u5305\u542b\u67e5\u627e\u503c\u548c\u8fd4\u56de\u503c\u7684\u8868\u683c\u533a\u57df&#xff0c;\u67e5\u627e\u503c\u5fc5\u987b\u5728\u533a\u57df\u7684\u7b2c\u4e00\u5217<\/p>\n<\/li>\n<li>\n<p>\u8fd4\u56de\u5217\u6570&#xff1a;\u4ece\u67e5\u627e\u533a\u57df\u7b2c\u4e00\u5217\u5f00\u59cb&#xff0c;\u5411\u53f3\u6570\u5230\u8981\u8fd4\u56de\u7684\u5217\u7684\u5e8f\u53f7<\/p>\n<\/li>\n<li>\n<p>\u5339\u914d\u7c7b\u578b&#xff1a;<\/p>\n<ul>\n<li>\n<p>FALSE\u00a0\u6216\u00a00&#xff1a;\u7cbe\u786e\u5339\u914d<\/p>\n<\/li>\n<li>\n<p>TRUE\u00a0\u6216\u00a01&#xff1a;\u8fd1\u4f3c\u5339\u914d&#xff08;\u8981\u6c42\u67e5\u627e\u533a\u57df\u7b2c\u4e00\u5217\u5fc5\u987b\u6309\u5347\u5e8f\u6392\u5217&#xff09;<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4 id=\"%E5%BF%AB%E6%8D%B7%E6%8A%80%E5%B7%A7%EF%BC%9A%E7%BB%9D%E5%AF%B9%E5%BC%95%E7%94%A8%E4%B8%8EF4%E9%94%AE\">\u5feb\u6377\u6280\u5de7&#xff1a;\u7edd\u5bf9\u5f15\u7528\u4e0eF4\u952e<\/h4>\n<p>\/\/ \u9009\u4e2d\u5f15\u7528\u533a\u57df\u540e<span style=\"color:#fe2c24\">\u9a6c\u4e0a<\/span>\u6309F4\u952e \u76f8\u5bf9\u5f15\u7528&#xff1a;A2:C15 \u2192 $A$2:$C$15 \u518d\u6b21\u6309F4&#xff1a;A$2:C$15 \u518d\u6b21\u6309F4&#xff1a;$A2:$C15 \u518d\u6b21\u6309F4&#xff1a;A2:C15&#xff08;\u6062\u590d\u76f8\u5bf9\u5f15\u7528&#xff09;<\/p>\n<h3 id=\"%E4%BA%8C%E3%80%81%E6%A1%88%E4%BE%8B1%EF%BC%9A%E7%B2%BE%E7%A1%AE%E5%8C%B9%E9%85%8D%E6%9F%A5%E6%89%BE%20-%20%E6%A0%B9%E6%8D%AE%E5%AD%A6%E5%8F%B7%E8%A1%A5%E5%85%A8%E4%BF%A1%E6%81%AF\">\u4e8c\u3001\u6848\u4f8b1&#xff1a;\u7cbe\u786e\u5339\u914d\u67e5\u627e &#8211; \u6839\u636e\u5b66\u53f7\u8865\u5168\u4fe1\u606f<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u901a\u8fc7\u5b66\u53f7\u5feb\u901f\u67e5\u627e\u5e76\u8865\u5168\u5b66\u751f\u7684\u59d3\u540d\u548c\u90e8\u95e8\u4fe1\u606f\u3002<\/p>\n<h4 id=\"%E6%95%B0%E6%8D%AE%E7%A4%BA%E4%BE%8B\">\u6570\u636e\u793a\u4f8b<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"512\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175717-697f93fd7f586.png\" width=\"846\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>\/\/ \u67e5\u627e\u59d3\u540d &#061;VLOOKUP($E3, $A$2:$C$15, 2, 0)<\/p>\n<p>\/\/ \u67e5\u627e\u90e8\u95e8 &#061;VLOOKUP($E3, $A$2:$C$15, 3, 0)<\/p>\n<h4 id=\"%E6%A0%B8%E5%BF%83%E8%A6%81%E7%82%B9\">\u6838\u5fc3\u8981\u70b9<\/h4>\n<li>\n<p>$E3&#xff1a;\u67e5\u627e\u503c\u4f7f\u7528\u6df7\u5408\u5f15\u7528&#xff0c;\u884c\u76f8\u5bf9\u3001\u5217\u7edd\u5bf9<\/p>\n<\/li>\n<li>\n<p>$A$2:$C$15&#xff1a;\u67e5\u627e\u533a\u57df\u4f7f\u7528\u7edd\u5bf9\u5f15\u7528&#xff0c;\u590d\u5236\u516c\u5f0f\u65f6\u4e0d\u4f1a\u6539\u53d8<\/p>\n<\/li>\n<li>\n<p>2\u548c3&#xff1a;\u8fd4\u56de\u67e5\u627e\u533a\u57df\u4e2d\u7684\u7b2c2\u5217&#xff08;\u59d3\u540d&#xff09;\u548c\u7b2c3\u5217&#xff08;\u90e8\u95e8&#xff09;<\/p>\n<\/li>\n<li>\n<p>0&#xff1a;\u4f7f\u7528\u7cbe\u786e\u5339\u914d&#xff0c;\u786e\u4fdd\u53ea\u8fd4\u56de\u5b8c\u5168\u5339\u914d\u7684\u7ed3\u679c<\/p>\n<\/li>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6839\u636e\u5b66\u53f7\u8865\u5168\u59d3\u540d\u548c\u90e8\u95e8&#xff08;Vlookup\u51fd\u6570&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E4%B8%89%E3%80%81%E6%A1%88%E4%BE%8B2%EF%BC%9A%E5%B7%A5%E8%B5%84%E8%AE%A1%E7%AE%97%20-%20VLOOKUP%E4%B8%8E%E6%95%B0%E5%AD%A6%E8%BF%90%E7%AE%97%E7%BB%93%E5%90%88\">\u4e09\u3001\u6848\u4f8b2&#xff1a;\u5de5\u8d44\u8ba1\u7b97 &#8211; VLOOKUP\u4e0e\u6570\u5b66\u8fd0\u7b97\u7ed3\u5408<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u6839\u636e\u5458\u5de5\u90e8\u95e8\u67e5\u627e\u5bf9\u5e94\u7684\u6d25\u8d34&#xff0c;\u8ba1\u7b97\u6700\u7ec8\u5de5\u8d44&#xff08;\u57fa\u7840\u5de5\u8d44&#043;\u6d25\u8d34&#xff09;\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"494\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175717-697f93fdab928.png\" width=\"904\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>&#061;VLOOKUP(C3, H$3:I$6, 2, 0) &#043; D3<\/p>\n<h4 id=\"%E5%85%AC%E5%BC%8F%E8%A7%A3%E6%9E%90\">\u516c\u5f0f\u89e3\u6790<\/h4>\n<ul>\n<li>\n<p>C3&#xff1a;\u90e8\u95e8&#xff08;\u67e5\u627e\u503c&#xff09;<\/p>\n<\/li>\n<li>\n<p>H$3:I$6&#xff1a;\u6d25\u8d34\u5bf9\u7167\u8868&#xff08;\u90e8\u95e8\u5728H\u5217&#xff0c;\u6d25\u8d34\u5728I\u5217&#xff09;<\/p>\n<\/li>\n<li>\n<p>D3&#xff1a;\u57fa\u7840\u5de5\u8d44<\/p>\n<\/li>\n<li>\n<p>\u7ed3\u679c&#xff1a;\u57fa\u7840\u5de5\u8d44 &#043; \u5bf9\u5e94\u90e8\u95e8\u7684\u6d25\u8d34<\/p>\n<\/li>\n<\/ul>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u8ba1\u7b97\u6bcf\u4e2a\u4eba\u7684\u5de5\u8d44&#xff1a;\u57fa\u7840\u5de5\u8d44&#043;\u6d25\u8d34&#xff08;Vlookup\u51fd\u6570&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E5%9B%9B%E3%80%81%E6%A1%88%E4%BE%8B3%EF%BC%9A%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%20-%20%E4%B8%9A%E7%BB%A9%E6%8F%90%E6%88%90%E8%AE%A1%E7%AE%97\">\u56db\u3001\u6848\u4f8b3&#xff1a;\u8fd1\u4f3c\u5339\u914d &#8211; \u4e1a\u7ee9\u63d0\u6210\u8ba1\u7b97<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u6839\u636e\u4e1a\u7ee9\u91d1\u989d\u81ea\u52a8\u5339\u914d\u63d0\u6210\u6bd4\u4f8b&#xff0c;\u8ba1\u7b97\u63d0\u6210\u91d1\u989d\u3002<\/p>\n<h4 id=\"%E6%95%B0%E6%8D%AE%E5%87%86%E5%A4%87\">\u6570\u636e\u51c6\u5907<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"496\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175717-697f93fdcecfc.png\" width=\"1093\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>\/\/ \u6807\u51c6\u516c\u5f0f &#061;VLOOKUP(B3, $I$5:$J$8, 2, 1) * B3<\/p>\n<p>\/\/ \u7b80\u5316\u516c\u5f0f&#xff08;\u4f7f\u7528\u6570\u7ec4\u5e38\u91cf&#xff09; &#061;VLOOKUP(B3%%, {0,0;1,0.05;10,0.1;20,0.12}, 2, 1) * B3<\/p>\n<h4 id=\"%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%E8%A6%81%E7%82%B9\">\u8fd1\u4f3c\u5339\u914d\u8981\u70b9<\/h4>\n<li>\n<p>\u67e5\u627e\u533a\u57df\u5fc5\u987b\u5347\u5e8f\u6392\u5217&#xff1a;\u8fd9\u662f\u8fd1\u4f3c\u5339\u914d\u7684\u524d\u63d0\u6761\u4ef6<\/p>\n<\/li>\n<li>\n<p>\u5339\u914d\u903b\u8f91&#xff1a;\u67e5\u627e\u5c0f\u4e8e\u6216\u7b49\u4e8e\u67e5\u627e\u503c\u7684\u6700\u5927\u503c<\/p>\n<\/li>\n<li>\n<p>B3%%&#xff1a;\u5c06B3\u9664\u4ee510000&#xff0c;\u7b80\u5316\u6570\u503c\u8303\u56f4<\/p>\n<\/li>\n<h4 id=\"%E5%AE%9E%E9%99%85%E8%AE%A1%E7%AE%97%E7%A4%BA%E4%BE%8B\">\u5b9e\u9645\u8ba1\u7b97\u793a\u4f8b<\/h4>\n<p>\u4e1a\u7ee9142000 \u2192 \u67e5\u627e\u2264142000\u7684\u6700\u5927\u63d0\u6210\u6bb5\u662f100000 \u2192 \u63d0\u6210\u6bd4\u4f8b0.1 \u63d0\u6210\u91d1\u989d &#061; 142000 \u00d7 0.1 &#061; 14200<\/p>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u8ba1\u7b97\u63d0\u6210\u91d1\u989d&#xff08;EXCEL\u6700\u6709\u7528\u51fd\u6570Vlookup\u51fd\u6570&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E4%BA%94%E3%80%81%E6%A1%88%E4%BE%8B4%EF%BC%9A%E9%80%9A%E9%85%8D%E7%AC%A6%E5%BA%94%E7%94%A8%20-%20%E6%A8%A1%E7%B3%8A%E6%9F%A5%E6%89%BE\">\u4e94\u3001\u6848\u4f8b4&#xff1a;\u901a\u914d\u7b26\u5e94\u7528 &#8211; \u6a21\u7cca\u67e5\u627e<\/h3>\n<h4 id=\"%E9%80%9A%E9%85%8D%E7%AC%A6%E4%BB%8B%E7%BB%8D\">\u901a\u914d\u7b26\u4ecb\u7ecd<\/h4>\n<p>\u00a0\u00a0\u00a0*&#xff1a;\u5339\u914d\u4efb\u610f\u591a\u4e2a\u5b57\u7b26<\/p>\n<p>\u00a0\u00a0\u00a0?&#xff1a;\u5339\u914d\u5355\u4e2a\u5b57\u7b26<\/p>\n<p>\u00a0\u00a0\u00a0~&#xff1a;\u8f6c\u4e49\u5b57\u7b26&#xff0c;\u67e5\u627e\u901a\u914d\u7b26\u672c\u8eab<\/p>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u5728\u4ea7\u54c1\u63cf\u8ff0\u4e2d\u67e5\u627e\u5305\u542b\u7279\u5b9a\u54c1\u724c\u540d\u7684\u8bb0\u5f55&#xff0c;\u63d0\u53d6\u9996\u6b21\u9500\u552e\u65e5\u671f\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"515\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175718-697f93fe1143f.png\" width=\"1346\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>\/\/ \u67e5\u627e\u54c1\u724c\u9996\u6b21\u9500\u552e\u65e5\u671f &#061;VLOOKUP(&#034;*&#034; &amp; G4 &amp; &#034;*&#034;, A:D, 4, FALSE)<\/p>\n<p>\/\/ \u67e5\u627e\u7279\u5b9a\u4f4d\u6570\u8bc4\u4ef7\u7684\u9996\u6b21\u51fa\u73b0 &#061;VLOOKUP(K4, C$2:C$19 &amp; &#034;&#034;, 1, FALSE)<\/p>\n<p>\/\/ \u67e5\u627e\u7b2c\u4e00\u4e2a\u65e0\u62a5\u4ef7&#xff08;\u5305\u542b?&#xff09;\u7684\u65e5\u671f &#061;VLOOKUP(&#034;~?*&#034;, B:D, 3, FALSE)<\/p>\n<h4 id=\"%E5%BA%94%E7%94%A8%E5%9C%BA%E6%99%AF\">\u5e94\u7528\u573a\u666f<\/h4>\n<li>\n<p>\u54c1\u724c\u7b5b\u9009&#xff1a;\u5728\u590d\u6742\u7684\u4ea7\u54c1\u540d\u79f0\u4e2d\u63d0\u53d6\u54c1\u724c\u4fe1\u606f<\/p>\n<\/li>\n<li>\n<p>\u6a21\u5f0f\u5339\u914d&#xff1a;\u67e5\u627e\u7279\u5b9a\u6a21\u5f0f\u7684\u6587\u672c<\/p>\n<\/li>\n<li>\n<p>\u5f02\u5e38\u68c0\u6d4b&#xff1a;\u67e5\u627e\u5305\u542b\u7279\u6b8a\u5b57\u7b26\u7684\u8bb0\u5f55<\/p>\n<\/li>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6c42\u4e0b\u9762\u54c1\u724c\u7b2c\u4e00\u6b21\u9500\u552e\u65e5\u671f&#xff08;Vlookup\u4e0e\u901a\u914d\u7b26&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E5%85%AD%E3%80%81%E6%A1%88%E4%BE%8B5%EF%BC%9A%E9%80%86%E5%90%91%E6%9F%A5%E6%89%BE%20-%20IF(%7B1%2C0%7D)%E7%BB%8F%E5%85%B8%E7%BB%93%E6%9E%84\">\u516d\u3001\u6848\u4f8b5&#xff1a;\u9006\u5411\u67e5\u627e &#8211; IF({1,0})\u7ecf\u5178\u7ed3\u6784<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>VLOOKUP\u9ed8\u8ba4\u53ea\u80fd\u4ece\u5de6\u5411\u53f3\u67e5\u627e&#xff0c;\u901a\u8fc7IF({1,0})\u7ed3\u6784\u5b9e\u73b0\u9006\u5411\u67e5\u627e&#xff08;\u4ece\u53f3\u5411\u5de6&#xff09;\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"590\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175718-697f93fe4b5e3.png\" width=\"1359\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>\/\/ \u9006\u5411\u67e5\u627e&#xff1a;\u901a\u8fc7\u8bc4\u4ef7\u6570\u67e5\u627e\u54c1\u724c\u914d\u7f6e &#061;VLOOKUP(G4, IF({1,0}, $C$2:$C$29 &amp; &#034;&#034;, $A$2:$A$29), 2, FALSE)<\/p>\n<h4 id=\"%E5%8E%9F%E7%90%86%E8%A7%A3%E6%9E%90\">\u539f\u7406\u89e3\u6790<\/h4>\n<p>IF({1,0}, \u533a\u57df2, \u533a\u57df1)\u00a0\u521b\u5efa\u4e00\u4e2a\u865a\u62df\u6570\u7ec4&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u5f53\u6761\u4ef6\u4e3a1&#xff08;TRUE&#xff09;\u65f6&#xff0c;\u8fd4\u56de\u533a\u57df2<\/p>\n<\/li>\n<li>\n<p>\u5f53\u6761\u4ef6\u4e3a0&#xff08;FALSE&#xff09;\u65f6&#xff0c;\u8fd4\u56de\u533a\u57df1<\/p>\n<\/li>\n<\/ul>\n<p>\u8fd9\u6837\u5c31\u5c06\u539f\u672c\u5728\u53f3\u8fb9\u7684\u67e5\u627e\u503c&#xff08;\u8bc4\u4ef7\u6570&#xff09;\u79fb\u5230\u4e86\u865a\u62df\u6570\u7ec4\u7684\u7b2c\u4e00\u5217&#xff0c;\u5b9e\u73b0\u9006\u5411\u67e5\u627e\u3002<\/p>\n<h4 id=\"%E8%BF%9B%E9%98%B6%E5%BA%94%E7%94%A8%EF%BC%9A%E5%A4%9A%E6%9D%A1%E4%BB%B6%E6%9F%A5%E6%89%BE\">\u8fdb\u9636\u5e94\u7528&#xff1a;\u591a\u6761\u4ef6\u67e5\u627e<\/h4>\n<p>\/\/ \u67e5\u627e\u6bcf\u5929\u7684\u7b2c\u4e00\u5355\u9500\u552e\u4fe1\u606f \u9500\u552e\u91d1\u989d&#xff1a;&#061;TRIM(MID(SUBSTITUTE(VLOOKUP(&#034;*&#034;&amp;$F13,$B$2:$B$29&amp;&#034;|&#034;&amp;$A$2:$A$29&amp;&#034;|&#034;&amp;$D$2:$D$29,1,FALSE),&#034;|&#034;,REPT(&#034; &#034;,99)),1,99)) \u9500\u552e\u4ea7\u54c1&#xff1a;&#061;TRIM(MID(SUBSTITUTE(VLOOKUP(&#034;*&#034;&amp;$F13,$B$2:$B$29&amp;&#034;|&#034;&amp;$A$2:$A$29&amp;&#034;|&#034;&amp;$D$2:$D$29,1,FALSE),&#034;|&#034;,REPT(&#034; &#034;,99)),99,99))<\/p>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6c42\u5404\u4e2a\u4f4d\u6570\u7684\u8bc4\u4ef7\u6570\u7b2c\u4e00\u6b21\u7684\u9500\u552e\u4ea7\u54c1&#xff08;Vlookup\u9006\u5411\u67e5\u627e&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E4%B8%83%E3%80%81%E6%A1%88%E4%BE%8B6%EF%BC%9A%E4%B8%80%E5%AF%B9%E5%A4%9A%E6%9F%A5%E8%AF%A2%20-%20%E7%AA%81%E7%A0%B4VLOOKUP%E9%99%90%E5%88%B6\">\u4e03\u3001\u6848\u4f8b6&#xff1a;\u4e00\u5bf9\u591a\u67e5\u8be2 &#8211; \u7a81\u7834VLOOKUP\u9650\u5236<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u67e5\u627e\u6307\u5b9a\u4eba\u5458\u7684\u6240\u6709\u5206\u6570\u8bb0\u5f55&#xff08;VLOOKUP\u9ed8\u8ba4\u53ea\u8fd4\u56de\u7b2c\u4e00\u4e2a\u5339\u914d\u9879&#xff09;\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"367\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175718-697f93fe8dc5e.png\" width=\"997\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%EF%BC%9A%E8%BE%85%E5%8A%A9%E5%88%97%E6%B3%95\">\u89e3\u51b3\u65b9\u6848&#xff1a;\u8f85\u52a9\u5217\u6cd5<\/h4>\n<h5 id=\"1.%20%E5%88%9B%E5%BB%BA%E8%BE%85%E5%8A%A9%E5%88%97\">1. \u521b\u5efa\u8f85\u52a9\u5217<\/h5>\n<p>\/\/ \u8f85\u52a9\u5217\u516c\u5f0f &#061;B2 &amp; COUNTIF($B$2:B2, $J$1)<\/p>\n<ul>\n<li>\n<p>\u539f\u7406&#xff1a;\u4e3a\u6bcf\u4e2a\u59d3\u540d\u6dfb\u52a0\u5e8f\u53f7&#xff0c;\u4f7f\u5176\u552f\u4e00<\/p>\n<\/li>\n<li>\n<p>\u793a\u4f8b&#xff1a;&#034;\u845b\u7545&#034; \u2192 &#034;\u845b\u75450&#034;\u3001&#034;\u845b\u75451&#034;\u3001&#034;\u845b\u75452&#034;&#8230;<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.%20%E6%9F%A5%E8%AF%A2%E5%85%AC%E5%BC%8F\">2. \u67e5\u8be2\u516c\u5f0f<\/h5>\n<p>\/\/ \u67e5\u8be2\u5206\u6570 &#061;IFERROR(VLOOKUP($J$1 &amp; ROW(1:1), $A:$D, 3, 0), &#034;&#034;)<\/p>\n<p>\/\/ \u67e5\u8be2\u65e5\u671f &#061;IFERROR(VLOOKUP($J$1 &amp; ROW(1:1), $A:$D, 4, 0), &#034;&#034;)<\/p>\n<h5 id=\"3.%20%E5%90%91%E4%B8%8B%E5%A1%AB%E5%85%85\">3. \u5411\u4e0b\u586b\u5145<\/h5>\n<p>\u5c06\u516c\u5f0f\u5411\u4e0b\u62d6\u52a8&#xff0c;ROW(1:1)\u4f1a\u81ea\u52a8\u53d8\u4e3aROW(2:2)\u3001ROW(3:3)&#8230;&#xff0c;\u4ece\u800c\u67e5\u8be2\u7b2c1\u30012\u30013&#8230;\u6761\u8bb0\u5f55\u3002<\/p>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6c42\u6307\u5b9a\u4eba\u5458\u7684\u6240\u6709\u5206\u6570&#xff08;VLOOKUP\u7a81\u7834\u4e00\u5bf9\u4e00\u7684\u67e5\u8be2&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E5%85%AB%E3%80%81%E6%A1%88%E4%BE%8B7%EF%BC%9A%E5%A4%9A%E5%80%BC%E6%9F%A5%E8%AF%A2%E4%B8%8E%E6%95%B0%E7%BB%84%E5%BA%94%E7%94%A8\">\u516b\u3001\u6848\u4f8b7&#xff1a;\u591a\u503c\u67e5\u8be2\u4e0e\u6570\u7ec4\u5e94\u7528<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82\">\u573a\u666f\u9700\u6c42<\/h4>\n<p>\u540c\u65f6\u67e5\u627e\u591a\u4e2a\u4eba\u6216\u5e8f\u53f7\u5bf9\u5e94\u7684\u5206\u6570&#xff0c;\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"418\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175718-697f93fea94ad.png\" width=\"864\" \/><\/p>\n<h4 id=\"N()%E5%92%8CT()%E5%87%BD%E6%95%B0\">N()\u548cT()\u51fd\u6570<\/h4>\n<p>\u00a0 \u00a0 N(\u533a\u57df)&#xff1a;\u5c06\u533a\u57df\u5185\u5bb9\u8f6c\u6362\u4e3a\u6570\u503c&#xff0c;\u975e\u6570\u503c\u8f6c\u4e3a0<\/p>\n<p>\u00a0 \u00a0 T(\u533a\u57df)&#xff1a;\u5c06\u533a\u57df\u5185\u5bb9\u8f6c\u6362\u4e3a\u6587\u672c&#xff0c;\u975e\u6587\u672c\u8f6c\u4e3a\u7a7a<\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u89e3\u51b3\u65b9\u6848<\/h4>\n<p>\/\/ \u6c42\u591a\u4e2a\u4eba\u7684\u5e73\u5747\u5206 &#061;AVERAGEA(VLOOKUP(T(IF({1}, F2:F4)), B:C, 2, ))<\/p>\n<p>\/\/ \u6c42\u591a\u4e2a\u5e8f\u53f7\u7684\u603b\u5206&#xff08;\u4e24\u79cd\u65b9\u6cd5&#xff09; \u65b9\u6cd51&#xff1a;&#061;SUM(VLOOKUP(N(IF({1}, F7:F10)), A:C, 3, )) \u65b9\u6cd52&#xff1a;&#061;SUM(VLOOKUP(N(IF(1, {2,5,8,9})), A:C, 3, ))<\/p>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6c42\u4e0b\u9762\u4e09\u4e2a\u4eba\u7684\u5e73\u5747\u5206&#xff08;VLOOKUP\u7b2c\u4e00\u53c2\u6570\u7684\u6570\u7ec4\u5e94\u7528&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E4%B9%9D%E3%80%81%E6%A1%88%E4%BE%8B8%EF%BC%9A%E6%9F%A5%E8%AF%A2%E8%BF%94%E5%9B%9E%E5%A4%9A%E5%88%97%E4%BF%A1%E6%81%AF%EF%BC%88%E7%AC%AC%E4%B8%89%E5%8F%82%E6%95%B0%E5%BA%94%E7%94%A8%EF%BC%89\">\u4e5d\u3001\u6848\u4f8b8&#xff1a;\u67e5\u8be2\u8fd4\u56de\u591a\u5217\u4fe1\u606f&#xff08;\u7b2c\u4e09\u53c2\u6570\u5e94\u7528&#xff09;<\/h3>\n<h4 id=\"%E5%9C%BA%E6%99%AF%E9%9C%80%E6%B1%82%EF%BC%9A%E6%B1%82%E6%89%80%E9%80%89%E5%A7%93%E5%90%8D%E5%9C%A8%E6%89%80%E6%9C%89%E5%B9%B4%E4%BB%BD%E7%9A%84%E6%80%BB%E9%94%80%E9%87%8F\">\u573a\u666f\u9700\u6c42&#xff1a;\u6c42\u6240\u9009\u59d3\u540d\u5728\u6240\u6709\u5e74\u4efd\u7684\u603b\u9500\u91cf<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"472\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175718-697f93fec99e0.png\" width=\"1425\" \/><\/p>\n<h4 id=\"%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%EF%BC%9A\">\u89e3\u51b3\u65b9\u6848&#xff1a;<\/h4>\n<h4 id=\"%E8%BF%94%E5%9B%9E%E5%A4%9A%E5%88%97%E4%BF%A1%E6%81%AF\">\u8fd4\u56de\u591a\u5217\u4fe1\u606f<\/h4>\n<p>\/\/ \u6c42\u548c\u6240\u9009\u59d3\u540d\u5728\u6240\u6709\u5e74\u4efd\u7684\u603b\u9500\u91cf &#061;SUM(VLOOKUP(M3, A:K, COLUMN(B:K), 0))<\/p>\n<p>COLUMN(B:K)\u6280\u5de7&#xff1a;\u751f\u6210\u6570\u7ec4{2,3,4,5,6,7,8,9,10,11}&#xff0c;\u4e00\u6b21\u6027\u8fd4\u56de\u591a\u5217\u6570\u636e\u3002<\/p>\n<p>\u89c6\u9891\u6f14\u793a&#xff1a;<\/p>\n<p>\u6c42\u6240\u9009\u59d3\u540d\u6240\u6709\u5e74\u4efd\u7684\u603b\u9500\u91cf&#xff08;Vlookup\u67e5\u8be2\u8fd4\u56de\u591a\u5217\u4fe1\u606f&#xff09;<\/p>\n<\/p>\n<h3 id=\"%E4%B9%9D%E3%80%81VLOOKUP%E5%B8%B8%E8%A7%81%E9%94%99%E8%AF%AF%E4%B8%8E%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88\">\u4e5d\u3001VLOOKUP\u5e38\u89c1\u9519\u8bef\u4e0e\u89e3\u51b3\u65b9\u6848<\/h3>\n<h4 id=\"1.%20%23N%2FA%E9%94%99%E8%AF%AF%EF%BC%9A%E6%89%BE%E4%B8%8D%E5%88%B0%E6%9F%A5%E6%89%BE%E5%80%BC\">1. #N\/A\u9519\u8bef&#xff1a;\u627e\u4e0d\u5230\u67e5\u627e\u503c<\/h4>\n<p>\u539f\u56e0&#xff1a;\u67e5\u627e\u503c\u5728\u67e5\u627e\u533a\u57df\u4e2d\u4e0d\u5b58\u5728 \u89e3\u51b3&#xff1a;<\/p>\n<p>&#061;IFERROR(VLOOKUP(&#8230;), &#034;\u672a\u627e\u5230&#034;)<\/p>\n<h4 id=\"2.%20%23REF!%E9%94%99%E8%AF%AF%EF%BC%9A%E8%BF%94%E5%9B%9E%E5%88%97%E6%95%B0%E8%B6%85%E5%87%BA%E8%8C%83%E5%9B%B4\">2. #REF!\u9519\u8bef&#xff1a;\u8fd4\u56de\u5217\u6570\u8d85\u51fa\u8303\u56f4<\/h4>\n<p>\u539f\u56e0&#xff1a;\u8fd4\u56de\u5217\u6570\u5927\u4e8e\u67e5\u627e\u533a\u57df\u7684\u5217\u6570 \u89e3\u51b3&#xff1a;\u68c0\u67e5\u8fd4\u56de\u5217\u6570\u662f\u5426\u6b63\u786e<\/p>\n<h4 id=\"3.%20%E8%BF%91%E4%BC%BC%E5%8C%B9%E9%85%8D%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF\">3. \u8fd1\u4f3c\u5339\u914d\u7ed3\u679c\u9519\u8bef<\/h4>\n<p>\u539f\u56e0&#xff1a;\u67e5\u627e\u533a\u57df\u672a\u6309\u5347\u5e8f\u6392\u5217 \u89e3\u51b3&#xff1a;\u5bf9\u67e5\u627e\u533a\u57df\u7b2c\u4e00\u5217\u8fdb\u884c\u5347\u5e8f\u6392\u5e8f<\/p>\n<h4 id=\"4.%20%E6%9F%A5%E6%89%BE%E5%80%BC%E7%B1%BB%E5%9E%8B%E4%B8%8D%E5%8C%B9%E9%85%8D\">4. \u67e5\u627e\u503c\u7c7b\u578b\u4e0d\u5339\u914d<\/h4>\n<p>\u539f\u56e0&#xff1a;\u6587\u672c\u578b\u6570\u5b57\u4e0e\u6570\u503c\u578b\u6570\u5b57\u4e0d\u5339\u914d \u89e3\u51b3&#xff1a;\u7edf\u4e00\u6570\u636e\u7c7b\u578b<\/p>\n<p>\/\/ \u6587\u672c\u8f6c\u6570\u503c &#061;VLOOKUP(&#8211;A2, &#8230;)<\/p>\n<p>\/\/ \u6570\u503c\u8f6c\u6587\u672c &#061;VLOOKUP(TEXT(A2, &#034;0&#034;), &#8230;)<\/p>\n<h3 id=\"%E5%8D%81%E3%80%81VLOOKUP%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E6%8A%80%E5%B7%A7\">\u5341\u3001VLOOKUP\u6027\u80fd\u4f18\u5316\u6280\u5de7<\/h3>\n<h4 id=\"1.%20%E9%99%90%E5%88%B6%E6%9F%A5%E6%89%BE%E8%8C%83%E5%9B%B4\">1. \u9650\u5236\u67e5\u627e\u8303\u56f4<\/h4>\n<p>\/\/ \u4e0d\u597d&#xff1a;\u67e5\u627e\u6574\u4e2a\u5217 &#061;VLOOKUP(A2, D:E, 2, 0)<\/p>\n<p>\/\/ \u597d&#xff1a;\u9650\u5236\u5177\u4f53\u8303\u56f4 &#061;VLOOKUP(A2, D2:E1000, 2, 0)<\/p>\n<h4 id=\"2.%20%E4%BD%BF%E7%94%A8%E8%A1%A8%E6%A0%BC%E5%BC%95%E7%94%A8%EF%BC%88Excel%202007%2B%EF%BC%89\">2. \u4f7f\u7528\u8868\u683c\u5f15\u7528&#xff08;Excel 2007&#043;&#xff09;<\/h4>\n<p>&#061;VLOOKUP([&#064;\u5b66\u53f7], \u88681, 2, 0)<\/p>\n<h4 id=\"3.%20%E6%8E%92%E5%BA%8F%E4%BC%98%E5%8C%96\">3. \u6392\u5e8f\u4f18\u5316<\/h4>\n<p>\u5bf9\u67e5\u627e\u533a\u57df\u7b2c\u4e00\u5217\u5efa\u7acb\u7d22\u5f15&#xff0c;\u63d0\u9ad8\u67e5\u627e\u901f\u5ea6\u3002<\/p>\n<h3 id=\"%E5%8D%81%E4%B8%80%E3%80%81VLOOKUP%E6%9B%BF%E4%BB%A3%E6%96%B9%E6%A1%88\">\u5341\u4e00\u3001VLOOKUP\u66ff\u4ee3\u65b9\u6848<\/h3>\n<p>\u867d\u7136VLOOKUP\u529f\u80fd\u5f3a\u5927&#xff0c;\u4f46\u5728\u67d0\u4e9b\u573a\u666f\u4e0b&#xff0c;\u5176\u4ed6\u51fd\u6570\u53ef\u80fd\u66f4\u5408\u9002&#xff1a;<\/p>\n<h4 id=\"1.%20INDEX%2BMATCH%E7%BB%84%E5%90%88\">1. INDEX&#043;MATCH\u7ec4\u5408<\/h4>\n<p>\/\/ \u66f4\u7075\u6d3b\u7684\u67e5\u627e\u7ec4\u5408 &#061;INDEX(C:C, MATCH(A2, B:B, 0))<\/p>\n<p>\u4f18\u52bf&#xff1a;\u4e0d\u53d7&#034;\u67e5\u627e\u503c\u5fc5\u987b\u5728\u7b2c\u4e00\u5217&#034;\u7684\u9650\u5236<\/p>\n<h4 id=\"2.%20XLOOKUP%EF%BC%88Office%20365%EF%BC%89\">2. XLOOKUP&#xff08;Office 365&#xff09;<\/h4>\n<p>\/\/ \u66f4\u5f3a\u5927\u7684\u65b0\u4e00\u4ee3\u67e5\u627e\u51fd\u6570 &#061;XLOOKUP(A2, B:B, C:C, &#034;\u672a\u627e\u5230&#034;, 0, 1)<\/p>\n<p>\u4f18\u52bf&#xff1a;\u65e0\u9700\u6307\u5b9a\u8fd4\u56de\u5217\u6570&#xff0c;\u652f\u6301\u9006\u5411\u67e5\u627e<\/p>\n<h4 id=\"3.%20FILTER%E5%87%BD%E6%95%B0%EF%BC%88Office%20365%EF%BC%89\">3. FILTER\u51fd\u6570&#xff08;Office 365&#xff09;<\/h4>\n<p>\/\/ \u7b5b\u9009\u51fa\u6240\u6709\u5339\u914d\u9879 &#061;FILTER(C:C, B:B&#061;A2)<\/p>\n<p>\u4f18\u52bf&#xff1a;\u76f4\u63a5\u8fd4\u56de\u6240\u6709\u5339\u914d\u7ed3\u679c&#xff0c;\u65e0\u9700\u8f85\u52a9\u5217<\/p>\n<h3 id=\"%E5%8D%81%E4%BA%8C%E3%80%81%E5%AE%9E%E6%88%98%E7%BB%BC%E5%90%88%E5%BA%94%E7%94%A8\">\u5341\u4e8c\u3001\u5b9e\u6218\u7efc\u5408\u5e94\u7528<\/h3>\n<h4 id=\"%E5%88%9B%E5%BB%BA%E5%8A%A8%E6%80%81%E6%9F%A5%E8%AF%A2%E7%B3%BB%E7%BB%9F\">\u521b\u5efa\u52a8\u6001\u67e5\u8be2\u7cfb\u7edf<\/h4>\n<p>\/\/ \u4e3b\u67e5\u8be2\u516c\u5f0f &#061;IFERROR( \u00a0 \u00a0 VLOOKUP( \u00a0 \u00a0 \u00a0 \u00a0 $A$2, \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ \u67e5\u8be2\u6761\u4ef6 \u00a0 \u00a0 \u00a0 \u00a0 IF($B$2&#061;&#034;\u5168\u90e8&#034;, $D$2:$F$100, FILTER($D$2:$F$100, $E$2:$E$100&#061;$B$2)), \/\/ \u52a8\u6001\u533a\u57df \u00a0 \u00a0 \u00a0 \u00a0 CHOOSE($C$2, 2, 3, 1), \u00a0 \u00a0\/\/ \u52a8\u6001\u8fd4\u56de\u5217 \u00a0 \u00a0 \u00a0 \u00a0 0 \u00a0 \u00a0 ), \u00a0 \u00a0 &#034;\u65e0\u5339\u914d\u7ed3\u679c&#034; )<\/p>\n<h4 id=\"%E6%9E%84%E5%BB%BA%E5%A4%9A%E7%BA%A7%E8%81%94%E5%8A%A8%E6%9F%A5%E8%AF%A2\">\u6784\u5efa\u591a\u7ea7\u8054\u52a8\u67e5\u8be2<\/h4>\n<p>\/\/ \u4e00\u7ea7\u67e5\u8be2&#xff1a;\u6839\u636e\u7701\u4efd\u67e5\u57ce\u5e02 \u7701\u4efd\u67e5\u8be2&#xff1a;&#061;VLOOKUP(A2, \u7701\u4efd\u8868, 2, 0)<\/p>\n<p>\/\/ \u4e8c\u7ea7\u67e5\u8be2&#xff1a;\u6839\u636e\u57ce\u5e02\u67e5\u533a\u53bf \u57ce\u5e02\u67e5\u8be2&#xff1a;&#061;VLOOKUP(B2, FILTER(\u533a\u53bf\u8868, \u533a\u53bf\u8868[\u57ce\u5e02]&#061;B2), 2, 0)<\/p>\n<h3 id=\"%E5%8D%81%E4%B8%89%E3%80%81%E6%80%BB%E7%BB%93%E4%B8%8E%E6%9C%80%E4%BD%B3%E5%AE%9E%E8%B7%B5\">\u5341\u4e09\u3001\u603b\u7ed3\u4e0e\u6700\u4f73\u5b9e\u8df5<\/h3>\n<h4 id=\"VLOOKUP%E4%BD%BF%E7%94%A8%E5%86%B3%E7%AD%96%E6%A0%91\">VLOOKUP\u4f7f\u7528\u51b3\u7b56\u6811<\/h4>\n<p>\u5f00\u59cb\u67e5\u8be2 \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u251c\u2500 \u9700\u8981\u7cbe\u786e\u5339\u914d&#xff1f; \u2192 \u662f \u2192 \u4f7f\u7528VLOOKUP(&#8230;, 0) \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u00a0 \u2514\u2500 \u67e5\u627e\u503c\u5728\u5de6\u4fa7&#xff1f; \u2192 \u5426 \u2192 \u4f7f\u7528IF({1,0})\u6216INDEX&#043;MATCH \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u251c\u2500 \u9700\u8981\u8fd1\u4f3c\u5339\u914d&#xff1f; \u2192 \u662f \u2192 \u786e\u4fdd\u533a\u57df\u5347\u5e8f \u2192 \u4f7f\u7528VLOOKUP(&#8230;, 1) \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u251c\u2500 \u9700\u8981\u8fd4\u56de\u591a\u4e2a\u7ed3\u679c&#xff1f; \u2192 \u662f \u2192 \u4f7f\u7528\u8f85\u52a9\u5217\u6cd5\u6216FILTER\u51fd\u6570 \u00a0 \u00a0 \u2502 \u00a0 \u00a0 \u2514\u2500 \u9700\u8981\u591a\u6761\u4ef6\u67e5\u627e&#xff1f; \u2192 \u662f \u2192 \u4f7f\u7528\u8fde\u63a5\u952e\u6216INDEX&#043;MATCH\u7ec4\u5408<\/p>\n<h4 id=\"%E8%AE%B0%E5%BF%86%E8%A6%81%E7%82%B9\">\u8bb0\u5fc6\u8981\u70b9<\/h4>\n<p>VLOOKUP\u56db\u53c2\u6570&#xff0c;\u67e5\u627e\u533a\u57df\u8981\u8bb0\u7262&#xff1b; \u7cbe\u786e\u5339\u914d\u75280&#xff0c;\u8fd1\u4f3c\u5339\u914d1\u4e0d\u80fd\u5c11&#xff1b; \u67e5\u627e\u503c\u5728\u7b2c\u4e00\u5217&#xff0c;\u8fd4\u56de\u5217\u6570\u5411\u53f3\u627e&#xff1b; \u7edd\u5bf9\u5f15\u7528F4\u952e&#xff0c;\u9519\u8bef\u5904\u7406\u8981\u5468\u5230&#xff1b; \u9006\u5411\u67e5\u627eIF\u5e2e\u5fd9&#xff0c;\u4e00\u5bf9\u591a\u7528\u8f85\u52a9\u5217\u5999&#xff1b; \u6570\u7ec4\u516c\u5f0f\u5a01\u529b\u5927&#xff0c;\u591a\u503c\u67e5\u8be2\u6548\u7387\u9ad8\u3002<\/p>\n<h4 id=\"%E5%AD%A6%E4%B9%A0%E8%B7%AF%E5%BE%84%E5%BB%BA%E8%AE%AE\">\u5b66\u4e60\u8def\u5f84\u5efa\u8bae<\/h4>\n<li>\n<p>\u521d\u5b66\u8005&#xff1a;\u638c\u63e1\u6848\u4f8b1-3&#xff0c;\u6ee1\u8db380%\u65e5\u5e38\u9700\u6c42<\/p>\n<\/li>\n<li>\n<p>\u8fdb\u9636\u8005&#xff1a;\u5b66\u4e60\u6848\u4f8b4-5&#xff0c;\u5904\u7406\u590d\u6742\u67e5\u8be2\u573a\u666f<\/p>\n<\/li>\n<li>\n<p>\u9ad8\u624b&#xff1a;\u7cbe\u901a\u6848\u4f8b6-8&#xff0c;\u5b9e\u73b0\u9ad8\u7ea7\u6570\u636e\u5904\u7406<\/p>\n<\/li>\n<p>\u901a\u8fc7\u672c\u6587\u7684\u516b\u5927\u5b9e\u6218\u6848\u4f8b&#xff0c;\u4f60\u5df2\u7ecf\u4eceVLOOKUP\u7684\u65b0\u624b\u6210\u957f\u4e3a\u80fd\u591f\u5e94\u5bf9\u5404\u79cd\u590d\u6742\u573a\u666f\u7684\u4e13\u5bb6\u3002\u8bb0\u4f4f&#xff0c;\u5b9e\u8df5\u662f\u6700\u597d\u7684\u8001\u5e08&#xff0c;\u5c06\u8fd9\u4e9b\u6280\u5de7\u5e94\u7528\u5230\u5b9e\u9645\u5de5\u4f5c\u4e2d&#xff0c;\u4f60\u4f1a\u53d1\u73b0\u81ea\u5df1\u5904\u7406\u6570\u636e\u7684\u6548\u7387\u5c06\u5927\u5e45\u63d0\u5347&#xff01;<\/p>\n<hr \/>\n<p id=\"articleContentId\">\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f &amp; \u8ba1\u7b97\u673a\u7f51\u7edc\u6280\u672f&#xff1a;\u53cc\u4e13\u4e1a\u8bfe\u7a0b\u4f53\u7cfb\u5b8c\u5168\u5bfc\u822a\u6307\u5357<\/p>\n<p>\u672c\u7ae0\u76ee\u5f55&#xff08;\u00a0\u7b2c\u4e03\u7ae0 Excel\u67e5\u627e\u4e0e\u5f15\u7528\u51fd\u6570[\u9ad8\u624b\u5fc5\u4fee\u51fd\u6570]&#xff09;<\/p>\n<p><span>1\u3001Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357&#xff1a;\u4ece\u5165\u95e8\u5230\u7cbe\u901a&#xff0c;\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790<\/span><\/p>\n<p><span>2\u3001Excel\u591a\u6761\u4ef6\u67e5\u8be2\u5b9e\u6218&#xff1a;VLOOKUP\u4e0eSUMIFS\u7684\u5f3a\u5f3a\u8054\u5408<\/span><\/p>\n<p><span>3\u3001Excel HLOOKUP\u51fd\u6570\u6df1\u5ea6\u89e3\u6790&#xff1a;\u6c34\u5e73\u67e5\u8be2\u4e0e\u4ea4\u53c9\u5339\u914d\u7684\u5b8c\u7f8e\u7ed3\u5408<\/span><\/p>\n<p><span>4\u3001Excel MATCH\u51fd\u6570\u5168\u89e3\u6790&#xff1a;\u7cbe\u786e\u5b9a\u4f4d\u3001\u8fd1\u4f3c\u5339\u914d\u4e0e\u4ea4\u53c9\u67e5\u8be2\u5b9e\u6218<\/span><\/p>\n<p><span>5\u3001Excel MATCH\u51fd\u6570\u8fdb\u9636&#xff1a;\u901a\u914d\u7b26\u5e94\u7528\u4e0e\u6570\u7ec4\u6280\u5de7\u5b9e\u6218\u89e3\u6790<\/span><\/p>\n<p><span>6\u3001Excel INDEX\u51fd\u6570\u5b8c\u5168\u6307\u5357&#xff1a;\u6570\u7ec4\u4e0e\u5f15\u7528\u4e24\u79cd\u5f62\u5f0f\u7684\u5b9e\u6218\u5e94\u7528<\/span><\/p>\n<p><span>7\u3001Excel LOOKUP\u51fd\u6570\u6df1\u5ea6\u89e3\u6790&#xff1a;\u5411\u91cf\u4e0e\u6570\u7ec4\u4e24\u79cd\u5f62\u5f0f\u7684\u5b9e\u6218\u5e94\u7528<\/span><\/p>\n<p><span>8\u3001Excel CHOOSE\u51fd\u6570\u5168\u653b\u7565&#xff1a;\u4ece\u57fa\u7840\u9009\u62e9\u5230\u9ad8\u7ea7\u6570\u636e\u91cd\u7ec4\u7684\u5168\u80fd\u5de5\u5177<\/span><\/p>\n<p><span>9\u3001Excel INDIRECT\u51fd\u6570\u6df1\u5ea6\u89e3\u6790&#xff1a;\u52a8\u6001\u5f15\u7528\u7684\u7ec8\u6781\u6b66\u5668<\/span><\/p>\n<p><span>10\u3001Excel OFFSET\u51fd\u6570\u5b8c\u5168\u6307\u5357&#xff1a;\u52a8\u6001\u5f15\u7528\u4e0e\u9ad8\u7ea7\u5e94\u7528\u7684\u7ec8\u6781\u5de5\u5177<\/span><\/p>\n<p><span>11\u3001Excel ADDRESS\u51fd\u6570\u6df1\u5ea6\u89e3\u6790&#xff1a;\u52a8\u6001\u6784\u5efa\u5355\u5143\u683c\u5730\u5740\u7684\u827a\u672f<\/span><\/p>\n<p><span>12\u3001Excel\u4fe1\u606f\u51fd\u6570\u5168\u89e3\u6790&#xff1a;ROWS\u3001COLUMNS\u3001AREAS\u3001FORMULATEXT\u5b9e\u6218\u6307\u5357<\/span><\/p>\n<p><span>13\u3001Excel GETPIVOTDATA\u51fd\u6570\u6df1\u5ea6\u6307\u5357&#xff1a;\u591a\u5e74\u5ea6\u6570\u636e\u900f\u89c6\u8868\u667a\u80fd\u6c47\u603b\u5b9e\u6218<\/span><\/p>\n<p><span>14\u3001Excel HYPERLINK\u51fd\u6570\u7ec8\u6781\u6307\u5357&#xff1a;\u667a\u80fd\u8d85\u94fe\u63a5\u4e0e\u52a8\u6001\u5bfc\u822a\u7cfb\u7edf<\/span><\/p>\n<p>\u672c\u7cfb\u5217\u76ee\u5f55\u5bfc\u822a<\/p>\n<p id=\"articleContentId\">Excel\u51fd\u6570\u4ece\u5165\u95e8\u5230\u7cbe\u901a\u5b8c\u5168\u5bfc\u822a\u76ee\u5f55&#xff08;\u7b2c\u4e00\u5230\u7b2c\u4e5d\u7ae0&#xff09;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee\u5f55<br \/>\n\u4e00\u3001\u57fa\u7840\u5165\u95e8&#xff1a;VLOOKUP\u51fd\u6570\u57fa\u7840\u8bed\u6cd5<br \/>\n\u51fd\u6570\u8bed\u6cd5\u8be6\u89e3<br \/>\n\u5feb\u6377\u6280\u5de7&#xff1a;\u7edd\u5bf9\u5f15\u7528\u4e0eF4\u952e<br \/>\n\u4e8c\u3001\u6848\u4f8b1&#xff1a;\u7cbe\u786e\u5339\u914d\u67e5\u627e &#8211; \u6839\u636e\u5b66\u53f7\u8865\u5168\u4fe1\u606f<br \/>\n\u573a\u666f\u9700\u6c42<br \/>\n\u6570\u636e\u793a\u4f8b<br \/>\n\u89e3\u51b3\u65b9\u6848<br \/>\n\u6838\u5fc3\u8981\u70b9<br \/>\n\u4e09\u3001\u6848\u4f8b2&#xff1a;\u5de5\u8d44\u8ba1\u7b97 &#8211; VLOOKUP\u4e0e\u6570\u5b66\u8fd0\u7b97\u7ed3\u5408<br \/>\n\u573a\u666f\u9700\u6c42<br \/>\n\u89e3\u51b3\u65b9\u6848<br \/>\n\u516c\u5f0f\u89e3\u6790<br \/>\n\u56db\u3001\u6848\u4f8b3&#xff1a;\u8fd1\u4f3c\u5339\u914d &#8211; \u4e1a\u7ee9\u63d0\u6210\u8ba1\u7b97<br \/>\n\u573a\u666f\u9700\u6c42<br \/>\n\u6570\u636e\u51c6\u5907<br \/>\n\u89e3\u51b3\u65b9\u6848<br \/>\n\u8fd1\u4f3c\u5339\u914d\u8981\u70b9<br \/>\n\u5b9e\u9645\u8ba1\u7b97\u793a\u4f8b<br \/>\n\u4e94\u3001\u6848\u4f8b4<\/p>\n","protected":false},"author":2,"featured_media":70531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[7396,7402,7397,7398,7399,7400,7401],"topic":[],"class_list":{"0":"post-70539","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-server","8":"tag-excel","10":"tag-vlookup","11":"tag-7398","12":"tag-7399","13":"tag-7400","14":"tag-7401"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/70539.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u76ee\u5f55 \u4e00\u3001\u57fa\u7840\u5165\u95e8&#xff1a;VLOOKUP\u51fd\u6570\u57fa\u7840\u8bed\u6cd5 \u51fd\u6570\u8bed\u6cd5\u8be6\u89e3 \u5feb\u6377\u6280\u5de7&#xff1a;\u7edd\u5bf9\u5f15\u7528\u4e0eF4\u952e \u4e8c\u3001\u6848\u4f8b1&#xff1a;\u7cbe\u786e\u5339\u914d\u67e5\u627e - \u6839\u636e\u5b66\u53f7\u8865\u5168\u4fe1\u606f \u573a\u666f\u9700\u6c42 \u6570\u636e\u793a\u4f8b \u89e3\u51b3\u65b9\u6848 \u6838\u5fc3\u8981\u70b9 \u4e09\u3001\u6848\u4f8b2&#xff1a;\u5de5\u8d44\u8ba1\u7b97 - VLOOKUP\u4e0e\u6570\u5b66\u8fd0\u7b97\u7ed3\u5408 \u573a\u666f\u9700\u6c42 \u89e3\u51b3\u65b9\u6848 \u516c\u5f0f\u89e3\u6790 \u56db\u3001\u6848\u4f8b3&#xff1a;\u8fd1\u4f3c\u5339\u914d - \u4e1a\u7ee9\u63d0\u6210\u8ba1\u7b97 \u573a\u666f\u9700\u6c42 \u6570\u636e\u51c6\u5907 \u89e3\u51b3\u65b9\u6848 \u8fd1\u4f3c\u5339\u914d\u8981\u70b9 \u5b9e\u9645\u8ba1\u7b97\u793a\u4f8b \u4e94\u3001\u6848\u4f8b4\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/70539.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-01T17:57:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175717-697f93fd7f586.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/70539.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/70539.html\",\"name\":\"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-02-01T17:57:20+00:00\",\"dateModified\":\"2026-02-01T17:57:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/70539.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/70539.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/70539.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/70539.html","og_locale":"zh_CN","og_type":"article","og_title":"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u76ee\u5f55 \u4e00\u3001\u57fa\u7840\u5165\u95e8&#xff1a;VLOOKUP\u51fd\u6570\u57fa\u7840\u8bed\u6cd5 \u51fd\u6570\u8bed\u6cd5\u8be6\u89e3 \u5feb\u6377\u6280\u5de7&#xff1a;\u7edd\u5bf9\u5f15\u7528\u4e0eF4\u952e \u4e8c\u3001\u6848\u4f8b1&#xff1a;\u7cbe\u786e\u5339\u914d\u67e5\u627e - \u6839\u636e\u5b66\u53f7\u8865\u5168\u4fe1\u606f \u573a\u666f\u9700\u6c42 \u6570\u636e\u793a\u4f8b \u89e3\u51b3\u65b9\u6848 \u6838\u5fc3\u8981\u70b9 \u4e09\u3001\u6848\u4f8b2&#xff1a;\u5de5\u8d44\u8ba1\u7b97 - VLOOKUP\u4e0e\u6570\u5b66\u8fd0\u7b97\u7ed3\u5408 \u573a\u666f\u9700\u6c42 \u89e3\u51b3\u65b9\u6848 \u516c\u5f0f\u89e3\u6790 \u56db\u3001\u6848\u4f8b3&#xff1a;\u8fd1\u4f3c\u5339\u914d - \u4e1a\u7ee9\u63d0\u6210\u8ba1\u7b97 \u573a\u666f\u9700\u6c42 \u6570\u636e\u51c6\u5907 \u89e3\u51b3\u65b9\u6848 \u8fd1\u4f3c\u5339\u914d\u8981\u70b9 \u5b9e\u9645\u8ba1\u7b97\u793a\u4f8b \u4e94\u3001\u6848\u4f8b4","og_url":"https:\/\/www.wsisp.com\/helps\/70539.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-02-01T17:57:20+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260201175717-697f93fd7f586.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/70539.html","url":"https:\/\/www.wsisp.com\/helps\/70539.html","name":"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-02-01T17:57:20+00:00","dateModified":"2026-02-01T17:57:20+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/70539.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/70539.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/70539.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Excel VLOOKUP\u51fd\u6570\u5b8c\u5168\u6307\u5357\uff1a\u4ece\u5165\u95e8\u5230\u7cbe\u901a\uff0c\u516b\u5927\u5b9e\u6218\u573a\u666f\u5168\u89e3\u6790"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/70539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=70539"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/70539\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/70531"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=70539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=70539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=70539"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=70539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}