来自欧阳晋的问题
请问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
请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?
请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?
LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})意思为如果A2单元格从第三个字符起取两个字符与数组中{"01","02","03"}中第某项相同,则返回另一个数组{"1班","2班","3班"}中的第某项内容假设A2单元格的内...