Thread: VLOOKUP returns 0 (zero) when lookup cell is blank
View Single Post
  #1   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
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