天气预报15天查询> 其他> excel表格查找函数怎么用的

excel表格查找函数怎么用的

更新时间: 2020-07-09 00:00:00     

excel表格查找函数操作步骤如下:

在桌面右击新建excel文档;选中菜单中公式,在下拉框中找到VLOOKUP函数并点击;在公式中选择需要查询字段的单元格;选择存储数据的位置;选择精确或匹配;完成公式的编写,即可查找函数。

关键词: excel 表格 查找 函数 怎么

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-1887338/ | 耗时:0.3440 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1887338 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1887338 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1887338 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1081381,1081019,1068564,1058853,1069221,1066804,1079890,1089630,1062488,1080058,1078318,1063841,1071759,1044426,1084445,1132309,1060573,1083181,1050647,1064977,1086510,1072747,1087133,1070824,1123207,1066924,992026,1086232,1053584,1082203) ORDER BY field (ArticleID,1081381,1081019,1068564,1058853,1069221,1066804,1079890,1089630,1062488,1080058,1078318,1063841,1071759,1044426,1084445,1132309,1060573,1083181,1050647,1064977,1086510,1072747,1087133,1070824,1123207,1066924,992026,1086232,1053584,1082203)