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.