VLOOKUP is returning blank as 1/0/1990, rather than nothing visible
date, excel, formatting, string-formatting, vlookup
Solution
Please try formatting as:
mm/dd/yyyy;;
Problem
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))) ```