VLOOKUP returns 0 (zero) when lookup cell is blank

[Maki]

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]

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

 

[T. Valko]

Try this:

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

 

[Maki]

Thank you both!

--
Maki @ Canberra.AU

Try this:

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you both!

 

[Sheeloo]

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