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

Question

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 1

Please try formatting as:

mm/dd/yyyy;;

Solution 2

Please delete =0 from your formula

Or use:

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

Edit#4: The question is how to replace blanks not N/A so the answer should be:

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