=IF(B3="","∨",IF(ISNA(VLOOKUP(B3,$G$3:$G$221,1,FALSE)),"×","
来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/07/17 05:56:53
=IF(B3="","∨",IF(ISNA(VLOOKUP(B3,$G$3:$G$221,1,FALSE)),"×","∨")) 我想知道这公式的意思
如果b3的值没出现在g列,就返回×,否则返回∨,可以简化为=IF(ISNA(VLOOKUP(B3,$G$3:$G$221,1,FALSE)),"×","∨"),VLOOKUP(B3,$G$3:$G$221,1,FALSE)意思是在$G$3:$G$221里找b3,若能找到就返回b3的值,但找不到会返回错误值!#N/A,而ISNA(VISNA(VLOOKUP(B3,$G$3:$G$221,1,FALSE))的意思是isna来判断VLOOKUP(B3,$G$3:$G$221,1,FALSE)的结果是否是错误值#N/A,若是,ISNA(VLOOKUP(B3,$G$3:$G$221,1,FALSE))结果为真(即条件成立)
公式“=IF(ISERROR(VLOOKUP(B8,数据表!B3:AE629,3,FALSE)),"",VLOOKUP(
=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP(
=IF(ISNA(VLOOKUP(B2,Sheet2!$A$1:$E$10000,4,FALSE))=TRUE,"",V
excel匹配函数 =IF(ISNA(VLOOKUP(A2,Sheet1!A$1:AZ$9999,19,FALSE)),
=IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B
=IF(ISNA(VLOOKUP($B$1,'5月1日'!$F$2:$J$50,5,FALSE)),"0",VLOOKU
=IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1
=IF(B3
=IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天
求问 =if($b7="","",vlookup($b7,ind!b:g,4,false))
IF(ISNA(VLOOKUP...