Thread: VLOOKUP returns 0 (zero) when lookup cell is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default VLOOKUP returns 0 (zero) when lookup cell is blank
You should test for blanks:

=IF(VLOOKUP(3,A1:B3,2,FALSE)="","",VLOOKUP(3,A1:B3 ,2,FALSE))

--
Gary''s Student - gsnu201001


"C.T." wrote:

I have two columns of data that I vlookup to. They both contain text,
numbers and some blank cells. Column 1 returns blanks correctly but column 2
returns 0.

Is it a formatting issue?

Any help is appreciated.
Reply With QuoteReply With Quote