使用VLOOKUP
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE)
EXCEL 判断第一列的数值在第二列是否存在
使用VLOOKUP
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE)
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
