Home

Return a blank value

%3CLINGO-SUB%20id%3D%22lingo-sub-1129082%22%20slang%3D%22en-US%22%3EReturn%20a%20blank%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129082%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20pull%20a%20bunch%20of%20dates%20from%20one%20sheet%20to%20another%2C%20but%20sometimes%2C%20there%20is%20no%20date%20to%20be%20entered%20so%20I%20would%20like%20that%20cell%20to%20be%20blank.%20Every%20time%20I%20do%20the%20formula%2C%20it%20comes%20back%20with%20a%20date%20of%201%2F0%2F1900.%20I%20need%20this%20to%20be%20a%20blank%20cell.%20Can%20anyone%20help%20with%20this%3F%20Here%20is%20the%20formula%20I'm%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFNA(VLOOKUP(CONCATENATE(%24A3%2C%22Dealer%20Website%20Provider%22)%2CKey!%24A%3AL%2C9%2CFALSE)%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1129082%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129106%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20a%20blank%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531924%22%20target%3D%22_blank%22%3E%40TylerGamblin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFNA(%20IF(VLOOKUP(...)%26gt%3B1%2CVLOOKUP(...)%2C%22%22)%20%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eor%20apply%20custom%20number%20format%20to%20the%20results%20to%20make%20zeros%20invisible.%3C%2FP%3E%3C%2FLINGO-BODY%3E
TylerGamblin
Occasional Visitor

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),"")

1 Reply
Highlighted

@TylerGamblin 

That's like

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

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

Related Conversations