blanks instead of "0" in vlookup

  • Thread starter Thread starter Patty via OfficeKB.com
  • Start date Start date
P

Patty via OfficeKB.com

This is a vlookup:

I am looking up a cell that happens to be blank, but the result of the
vlookup is "0." How do I change the O to a blank?
 
Hi Patty,

Just out of curiosity - what is the point in searching for a blank cell to
return a blank cell?

Regards,
KL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
Formatting 0 values to show blank cells 4
VLOOKUP returns 0 (zero) when lookup cell is blank 5
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Multiple VLOOKUPS 4
Vlookup with corresponding two data (blank and non blnk) 1
Excel Vlookup Help 0

Back
Top