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?

Tks
AXISHKAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
=IFERROR(if(VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE)=0,"",VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE)), "")
0
 
Patrick MatthewsConnect With a Mentor Commented:
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.
0
 
Wayne Taylor (webtubbs)Commented:
That's a cool trick, Patrick! I hadn't seen that before.
0
 
Patrick MatthewsCommented:
:)
0
 
AXISHKAuthor Commented:
Tks
0
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.

All Courses

From novice to tech pro — start learning today.