Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • 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?

Tks
0
AXISHK
Asked:
AXISHK
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)), "")
0
 
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.
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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