VLOOKUP函数的初级用法  

Primary usage of VLOOKUP function

作　　者：黄嘉[1] Huang Jia(Hunan Railway Professional Technology College,Zhuzhou,Hunan 412001,China)

机构地区：[1]湖南铁道职业技术学院,湖南株洲412001

出　　处：《计算机时代》2022年第10期121-122,126,共3页Computer Era

摘　　要：Excel应用中,VLOOKUP函数是查找数据神器。在EXCEL数据表里查找数据时,如果数据表的面积非常大,可以通过VLOOKUP函数来快速查找数据。VLOOKUP函数是EXCEL软件中特别重要的一个函数。我们从理解VLOOKUP函数入手,结合实例给出具体应用及操作步骤。用好VLOOKUP函数可以大幅提高查找数据的工作效率。VLOOKUP function is a tool for looking up data in Excel applications. When the area of the data table is very large,you can quickly look up data with it. In this paper, starting from understanding the VLOOKUP function, combined with examples,its specific application and operation steps are given, so as to improve the efficiency of data search.

关 键 词：查找数据 VLOOKUP函数 参数填写 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论]