Return a blank value

[TylerGamblin]

I am trying to pull a bunch of dates from one sheet to another, but sometimes, there is no date to be entered so I would like that cell to be blank. Every time I do the formula, it comes back with a date of 1/0/1900. I need this to be a blank cell. Can anyone help with this? Here is the formula I'm using.

=IFNA(VLOOKUP(CONCATENATE($A3,"Dealer Website Provider"),Key!$A:L,9,FALSE),"")

[#2]

@TylerGamblin 

That's like

=IFNA( IF(VLOOKUP(...)>1,VLOOKUP(...),"") ,"")

or apply custom number format to the results to make zeros invisible.