请问excel中LOOKUP(MID(A2,3,2),{"0-查字典问答网
分类选择

来自欧阳晋的问题

  请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?

  请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?

1回答
2020-05-30 00:10
我要回答
请先登录
孙开锋

  LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})意思为如果A2单元格从第三个字符起取两个字符与数组中{"01","02","03"}中第某项相同,则返回另一个数组{"1班","2班","3班"}中的第某项内容假设A2单元格的内...

2020-05-30 00:15:28

最新问答

推荐文章

猜你喜欢

附近的人在看

推荐阅读

拓展阅读

  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  •