请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?
人气:220 ℃ 时间:2020-06-29 17:57:41
解答
LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})意思为如果A2单元格从第三个字符起取两个字符与数组中{"01","02","03"}中第某项相同,则返回另一个数组{"1班","2班","3班"}中的第某项内容假设A2单元格的内...
推荐
猜你喜欢