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),””)
=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