VLOOKUP returns 0 (zero) when lookup cell is blank

Maki · Oct 11, 2008

When the cell that VLOOKUP looked-up is blank, it displays 0 (zero).
How can I prevent this and make it to not show anything? i.e. blank?

Sheeloo · Oct 11, 2008

=IF(VLOOKUP(parameters here),VLOOKUP(parameters here),"")

T. Valko · Oct 11, 2008

Try this:

=IF(VLOOKUP(.....)="","",VLOOKUP(.....))

Maki · Oct 11, 2008

Thank you both!

--
Maki @ Canberra.AU

T. Valko said:
Try this:

=IF(VLOOKUP(.....)="","",VLOOKUP(.....))

T. Valko · Oct 11, 2008

You're welcome!

--
Biff
Microsoft Excel MVP

Maki said:
Thank you both!

Sheeloo · Oct 11, 2008

Thanks for your feedback. Pl. mark the post as answered.

Formatting 0 values to show blank cells	4	Mar 12, 2010
Vlookup blanks = zeros	6	Mar 17, 2007
Blank	3	Apr 6, 2010
show all/pivot - 2 questions	1	Jan 30, 2008
VLOOKUP returns 0 (zero) when lookup cell is blank	5	Mar 31, 2010
Blank Cell	5	Apr 6, 2010
Vlookup on blank cells formatted with dates	3	Jul 18, 2007
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast	3	Jan 26, 2010

Ask a Question