天气预报 > 科技 > vlookup函数老是出错
vlookup函数老是出错
更新时间: 2021-01-05 22:53:18  

1、有时从系统中导出的excel数据表或者从网上下载的,有空格。这里使用trim函数去掉型号前后的空格。输入公式=VLOOKUP(TRIM(A9),$A$3:$B$6,2,0)。

2、数据表是否存在合并单元格导致的出错,这时把合并的单元格还原。

关键词: vlookup 函数 老是 出错

vlookup函数老是出错相关经验

天气预报

最新推荐

页面:/news/view-1506679/ | 耗时:0.4098 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1506679 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1506679 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1506679 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3322385,770782,605876,2749976,1506679,3221494,1127288,1690122,2476082,1207632,847620,1411619,2424754,3498733,1211893,2838800) ORDER BY field (ArticleID,3322385,770782,605876,2749976,1506679,3221494,1127288,1690122,2476082,1207632,847620,1411619,2424754,3498733,1211893,2838800)