I have a formula =VLOOKUP(C6,A1:C8,3,FALSE) which returns 1/9/1900 if the cell is blank. Which I think is because it returns a 0 value and the cell is formatted for a date. So I tried =IFERROR(VLOOKUP(C6,A1:C8,3,FALSE),"") hoping this would return a blank instead. No such luck. Please help.
Thanks, Curt
Bookmarks