问题描述
我使用以下公式:
=IFERROR(INDEX('Cleaned Post'!W:W,MATCH(Combined!$C2,'Cleaned Post'!$C:$C,0))," ")
这个公式工作得很好,除了空白单元格,它返回0".我希望空白单元格返回为空白.
This formula is working beautifully, except that for blank cells, it's returning "0". I would like blank cells to be return as blank.
具体来说,这就是我所拥有的
Specifically, this is what I have
第 1 页(标题为 Cleaned Post)
Sheet 1 (entitled Cleaned Post)
Name Email Age Gender Task #1
Andrew [email protected] 18 1 80
Jason [email protected] 20 1 95
Judy [email protected] 18 2 __
Jack [email protected] 24 1 65
表 2(标题为合并)- 我得到了什么
Sheet 2 (entitled Combined) - What I'm getting
Email Task#1
[email protected] 80
[email protected] 95
[email protected] 0
[email protected] 65
表 2(标题为合并)- 我想要的
Sheet 2 (entitled Combined) - What I want
Email Task#1
[email protected] 80
[email protected] 95
[email protected] __
[email protected] 65
我需要做什么来调整这个公式?
What do I need to do to adjust this formula?
推荐答案
你的公式返回什么样的值?如果它们是文本值,则将空字符串"连接到您的 INDEX/MATCH
公式就足够了,如下所示:
What sort of values is your formula returning? If they are text values it's sufficient to concatenate a "null string" to your INDEX/MATCH
formula like this:
=IFERROR(INDEX('Cleaned Post'!W:W,MATCH(Combined!$C2,'Cleaned Post'!$C:$C,0))&"","")
这也适用于数字,只是它会将它们转换为文本,因此如果您不想要,可以尝试此版本:
That also works for numbers except it will convert them to text so if you don't want that you can try this version:
=IFERROR(IF(INDEX('Cleaned Post'!W:W,MATCH(Combined!$C2,'Cleaned Post'!$C:$C,0))="","",INDEX('Cleaned Post'!W:W,MATCH(Combined!$C2,'Cleaned Post'!$C:$C,0))),"")
这篇关于IFERROR、INDEX、MATCH 返回零而不是空白的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!