使用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 判断第一列的数值在第二列是否存在
最新推荐文章于 2023-07-05 22:55:59 发布