基于Excel实现改进型纵向查找功能

Implementation of Improved Vertical Lookup Function Based on Excel

在日常Excel表统计数据工作中,人们经常用到VLOOKUP函数查找目标数据项,但是VLOOKUP函数只能返回查找目标列的第一个结果。提出了一种使用VBA宏语言编写改进型纵向查找功能的方法,能够快速找到全部满足条件的数据项且内容不重复,为工作中数据的匹配及校核提供了支撑。

In daily work of Excel table statistics,people often use the VLOOKUP function to find the target data item,but the VLOOKUP function can only return the first result of the lookup target column.This paper proposes a method of using VBA macro language to write an improved vertical lookup function,which can quickly find all the data items that meet the conditions and the content is not repeated,the method provides support for the matching and verification of data in the work.