execl =VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 21:52:58
![execl =VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000](/uploads/image/z/9287179-43-9.jpg?t=execl+%3DVLOOKUP%28%24B7%2C%E8%82%A1%E4%BB%BD%E5%85%AC%E5%8F%B8%21%24C%24184%3A%24H%24220%2C6%2C0%29%2F10000)
execl =VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000
execl =VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000
execl =VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000
=VLOOKUP($B7,股份公司!$C$184:$H$220,6,0)/10000
函数F(X)=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
1.Lookup_value判断的条件(查询数值的条件,可以为数据、引用、文件字符串).如$B7
2.table_array,跟踪数据的区域,如股份公司!$C$184:$H$220
3.col_index_num返回第几列的数据,如“6”区域股份公司!$C$184:$H$220,第六列数据
4.range_lookup是否精确匹配
4..件EL为需要在第一列查找的数值,(true/0为模糊匹配,false/1为精确匹配)