作业帮 > 综合 > 作业

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

来源：学生作业帮 编辑：搜搜考试网作业帮 分类：综合作业 时间：2024/05/28 21:39:13
请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})怎么翻译?
请问excel中LOOKUP(MID(A2,3,2),{
LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})
意思为如果A2单元格从第三个字符起取两个字符与数组中{"01","02","03"}中第某项相同,则返回另一个数组{"1班","2班","3班"}中的第某项内容
假设A2单元格的内容为 220345 则 MID(A2,3,2) 返回 "03"
而"03"是{"01","02","03"}中的第三项,所以公式返回{"1班","2班","3班"}中的第三项即"3班"
这个公式可以简写成
LOOKUP(--MID(A2,3,2),{1,2,3},{"1班","2班","3班"})
或
=--MID(A2,3,2)&"班"
请问excel中LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"} excel 函数问题：=-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9}, excel =-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&12 =MID(A2,2,FIND("+",A2)-2)*1000+MID(A2,FIND("+",A2)+1,3) LOOKUP函数求助=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%"," 谁能帮我解释一下这个函数 =INT(MID(A2,3,2))&"班" VB中mid(s,1,2)=mid(s,3, =LOOKUP(9^9,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&5^19) excel中find函数 和Mid函数的问题.MID（A3,FIND（" ",A3,1)+1,3) EXCEL公式 =LOOKUP(2,0/(1:1""),1: =LOOKUP(1,0/(MID(A1,ROW(1:999),1)="\"),ROW(1:999)) 3q3q^^ 求教Excel函数ABS(LOOKUP(9E+307,--LEFT(MID(B4,FIND("+",B4)+1,99),