Thread: VLOOKUP worksheet function returns zero for empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hershmab Hershmab is offline
external usenet poster
  
Posts: 35
Default VLOOKUP worksheet function returns zero for empty cells
I am using VLOOKUP to get address information from one "master" worksheet to
another. Some of the master cells are empty (not blank); the value returned
by VLOOKUP in such cases is zero, not blank.

How can I prevent that without calling the function twice in each formula?
Reply With QuoteReply With Quote