Thread: VLOOKUP returns 0 (zero) when lookup cell is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
  
Posts: 364
Default 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
Reply With QuoteReply With Quote