View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default Vlookup blanks = zeros

Hello
=IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3
06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0.
If the cell is blank I want the answer to be blank not a zero. Can someone
help me thanks