Home/ Questions/Q 14734
Next
Answered
computing
  • 4
Asked: 2021-12-15T13:46:16+00:00 In:

Solved Using Vlookup To Return a Blank Instead Of 00/01/1900

  • 4

I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this is ok when there is a date value in the cell that I am returning but when the returning cell is blank it is returning a default date of 00/01/1900 how can I get to show a blank instead of 00/01/1900

Share

    1 Answer

    1. Best Answer
      First, a posting tip:

      Try tossing in some punctuation and capitalization every now and then. When you post one long “sentence” with no periods it makes your post very hard to read.

      If you are sure that the cell is blank, then you can force a blank to be returned with this formula:

      =IF(VLOOKUP(A2,$D$6:$E$7,2,0)=””,””,VLOOKUP(A2,$D$6:$E$7,2,0))

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0