Exclude Blank Dates From VLOOKUP Formula In Excel

In this post we will see how to exclude blank dates from being pulled by vlookup formula in excel, we observe that vlookup formula returns 0 date value like 00-01-1900 when the formula doesn’t find any date value and we will see how not to include 00-01-1900 values in vlookup formula.

Below is an example in which we see how the values are pulled by vlookup formula and you can see that vlookup formula has pulled 00-01-1900 as date values when it doesn’t find the dates corresponding to the value in column F and our job here is to exclude these 00-01-1900 or blank values from being pulled in vlookup formula.

Excel showing blank dates in sample data

We will create a new column and will enter below formula to get the result in which vlookup formula will not include 00-01-1900 as date values.

=TEXT(G3, “mm-dd-yyyy;;;”)

Vlookup to exclude 00-01-1900 from showing in dates

This formula has semicolons that tells excel not to show 00-01-1900 when value is not available.

Press enter after entering the formula and copy paste the formula downwards to get the date values for all the values in column F.

Excel formula to convert 00-01-1900 into blanks

Hope this helped

Share The Knowledge

Random Posts

  • Split Words In Excel If Uppercase Character Is Found

    split word in excel when upper case character is found, text to column when a capital letter is found, split text string when an uppercase character is found, separate word when an uppercase character is found.

    Share The Knowledge
  • Sort By Length In Excel

    In this article we will see how we could sort by length in excel i.e.We may have some data arranged in a […]

    Share The Knowledge
  • Return Font Name And Font Size In VBA

    return font size i excel return font name inn excel, vba to find font size, vba to find font name, get font size in excel, get font name in excel

    Share The Knowledge
  • Fill Blank Cells With Zero In Excel

    Let’s see how to fill the blank cells in a sheet with 0 in excel. We often come across a […]

    Share The Knowledge