[已解决]关于双条件 查询反值 公式 缺少条件会出现#N/A 错误 怎么弄成空值

745382567jmh

{=INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,0)) }

最佳答案

月排行榜 / 总排行榜

youfang

2014-5-30 07:28

1. =IFERROR(INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,0)),"")

复制代码

跳转到最佳答案楼层

youfang

1. =IFERROR(INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,0)),"")

复制代码

tgydslr

外套一层判断就好
2007的话

1. =IFERROR(INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,)),"")

复制代码

EXCEL2003的话

1. =IF(ISERROR(INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,))),"",INDEX(单价!C$2:C$50,MATCH(A7&B7,单价!A$2:A$50&单价!B$2:B$50,)))

复制代码