View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Maki Maki is offline
external usenet poster
 
Posts: 30
Default 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