• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

vlookup in Excel

=IFERROR(VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE), "")

The link above can prevent N/A from display if vlookup can match a record. However, if it match a record with blank field, the retrieved column will be shown as 0. Is it possible to let it show blank instead of 0?

2 Solutions
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=IFERROR(if(VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE)=0,"",VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE)), "")
Patrick MatthewsCommented:
If your VLOOKUP is normally returning text, and not numeric or date values, there is a simpler way:

=IFERROR(VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE)&"", "")

Open in new window

The &"" appends a zero-length string to the result, thus preventing the blank from being interpreted as a numeric zero.
Wayne Taylor (webtubbs)Commented:
That's a cool trick, Patrick! I hadn't seen that before.
Patrick MatthewsCommented:
AXISHKAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now