View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
slrog123 slrog123 is offline
external usenet poster
 
Posts: 5
Default Vlookup returns bad date

Hi! I am using a Vlookup to return a date, if the date exists.
Problem = if a date does not exist, I get a return value of 1/0/00
I want it to return an empty cell. How?
You guys are great! Thanks for being here