题目

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

提问时间：2021-03-27

答案

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