VLOOKUP returns 0 (zero) when lookup cell is blank
 

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?
--
Maki @ Canberra.AU

VLOOKUP returns 0 (zero) when lookup cell is blank
 

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


"Maki" wrote:

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?
--
Maki @ Canberra.AU

VLOOKUP returns 0 (zero) when lookup cell is blank
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
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?
--
Maki @ Canberra.AU

VLOOKUP returns 0 (zero) when lookup cell is blank
 

Thank you both!

--
Maki @ Canberra.AU


"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
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?
--
Maki @ Canberra.AU

VLOOKUP returns 0 (zero) when lookup cell is blank
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
Thank you both!

--
Maki @ Canberra.AU


"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
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?
--
Maki @ Canberra.AU

VLOOKUP returns 0 (zero) when lookup cell is blank
 

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

"T. Valko" wrote:

You're welcome!

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
Thank you both!

--
Maki @ Canberra.AU


"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
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?
--
Maki @ Canberra.AU