Home/ Questions/Q 907
Next
Answered
computing
  • 0
Asked: 2021-10-19T07:55:42+00:00 In:

Solved VLOOKUP Returns 00/01/1900 Instead Of Blank

  • 0

Hi all,

I have a formula which was originally showing #N/A as well as 0/01/1900.

I am using Excel 2016

I was able to get rid of the #N/A but I cannot get rid of the 0/01/1900 any suggestions would be awesome

The formula I am using is as follows

=IFERROR(VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,FALSE),””)

Share

    1 Answer

    1. Best Answer
      Try this:

      =IF(ISNA(VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)),””,IF(VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)=0,””,VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)))

      Excel didn’t like it if the VLOOKUP returned #N/A within the OR. The #N/A error took precedence over the OR.

      Just a tip:

      If you had used the Formula Evaluator feature you would have seen that.

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

      message edited by DerbyDad03

      • 1