索引匹配为空白单元格返回0，希望它为“-". [英] index match returns 0 for blank cell, want it to be "-"

查看：73 发布时间：2020/11/1 0:07:23 excel formula

本文介绍了索引匹配为空白单元格返回0，希望它为“-".的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

我四处张望，尝试了一堆不同的东西，但都没有用.

I have looked all over and tried a bunch of different things and non are working.

我可以得到显示-的错误，但我也希望空白单元格返回-.

I can get the error to show - but I also want a blank cell to return -.

现在，空白单元格将返回0.

Right now blank cells are returning 0.

如果有帮助，空白单元格将显示在$C$6:$DD$50部分中.

The blank cells appear in the $C$6:$DD$50 section if that helps.

=IFERROR(INDEX('Foundation Plates'!$C$6:$DD$50,MATCH($C9,'Foundation Plates'!$B$6:$B$50,0),MATCH(D$8,'Foundation Plates'!$C$5:$DD$5,0)),"-")

=Index(...) & ""

它将0(空白值)转换为空字符串.

it would convert 0 (Blank value) to an empty string.

这篇关于索引匹配为空白单元格返回0，希望它为“-".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

索引匹配为空白单元格返回0，希望它为“-". [英] index match returns 0 for blank cell, want it to be &quot;-&quot;