=IF(D173="","",VLOOKUP(MID(D173,1,4)*1,$L$8:$M$75,2,0))这是什么意
sum(if(mid(a1:h1,1,1)="Y",--mid(a1:h1,2,4),0))这是一个求和函数.
=IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B
=IF(ISERROR(VLOOKUP(B2,$D$1:$E$3960,2,0)),"",VLOOKUP(B2,$D$1
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP(
=IF(H8="",0,VLOOKUP(H8,'TABLE & LIST'!L:M,2,FALSE)) 以上公式的意思.
=IF($B5="m",VLOOKUP($C5,make,8,FALSE),IF($B5="a",VLOOKUP($C5
=IF(ISERROR(VLOOKUP(B6,L:L,1,0)),"",1) 帮我解释下这个公式?通谷易懂最好^
=IF(ISNA(VLOOKUP(K8,'1月'!D:E,2,0)),"",VLOOKUP(K8,'1月'!D:E,2,
=IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1
=IF(ISNA(VLOOKUP(A2,Sheet2!B:B,1,0)),"",VLOOKUP(A2,Sheet2!B:
=IF(A4="",0,IF(MONTH(TODAY())>1,VLOOKUP(A4,月1,4,FALSE),
=IF(ISERROR(VLOOKUP(A2,A$1:A1,1,0)),"",