""这是表示空,EXCEL里空跟空格是两回事,比如""," "," "这三个分别是空,空格（1个空格）,空格（2个空格）；
=IF(ISNA(VLOOKUP(D33,原材料目录编码!$A$4:$D$301,3,0)),"",VLOOKUP(D33,原材料目录编码!$A$4:$D$301,3,0))
VLOOKUP(D33,原材料目录编码!$A$4:$D$301,3,0)这个是不能省略的,整个才是完整的公式.
帮小弟看看这个公式:=IF(ISNA(VLOOKUP(D33,原材料目录编码!$A$4:$D$301,3,0)),"",
1个回答
相关问题
-
=IF(ISNA(VLOOKUP(B2,Sheet2!$A$1:$E$10000,4,FALSE))=TRUE,"",V
-
=IF(D6="","",VLOOKUP(D6,$W$6:$X$15,2,0))
-
请问 IF(C11="Y",VLOOKUP(D11,数据!AB6:数据!AD72,3),0.17)
-
=IFERROR(IF(VLOOKUP(CONCATENATE(LEFT(A109,9),9906),库存账统计!$D$
-
=VLOOKUP(MID(D17,2,2),参数表!A:C,3,0)
-
=IF(C4=0,"",D4/B4)这个公式是什么意思?通俗点的解释
-
下面公式中,为什么d3会被忽略了,=IF(D3159,D3-125,IF(D3171,D3-133,IF(D3
-
数学公式推导If a=4 b=1 c=6 d=4 Then E=3If a=4 b=1 c=3 d=7 Then E=5
-
=VLOOKUP(A1,D:E,2,
-
帮忙看看这个公式错在哪了?=IF((OFFSET(G4,-A4-1,)="","",IF(AND((OFFSET(G4,