Search code examples
exceldateformattingstring-formattingvlookup

VLOOKUP is returning blank as 1/0/1990, rather than nothing visible

All cells are formatted for dates, when a cell is blank I would like it to return an apparently blank cell rather than 1/0/1900. Here is what I have so far however It is still returning the date instead of a blank:

= IF(ISNA(VLOOKUP($B$4,TrainingDatabase!$A$3:$S$14,3,0))=  0,"", (VLOOKUP($B$4,TrainingDatabase!$A$3:$S$14,3,0)))
Solution

  • Please try formatting as: 

    mm/dd/yyyy;;