Inconsistent Results on IFERROR/VLOOKUP IF Compare results from formula in two different columns

[jwoods1204]

The worksheet Total Funds Check has a compare IF statement in column H based on the formula results in columns D & F

The items highlighted in Yellow are the errors. Columns D & F values appear the same in these columns.

The IF Compare formula: =IF(AND(B8="Yes",D8<>F8),"DIFF","")
Column D formula: =IF(B8="Yes",IFERROR(VLOOKUP(A8,'Project List Export'!$A$2:$N$415,9,FALSE),""),"")
Column F formula: =IF(C8="YES",IFERROR(VLOOKUP(A8,'Charge Fund Export'!$A$2:$F$302,4,FALSE),""),"")

Columns D & F are formatted as Date 03/14/12 as is the value on the Lookup tables

I expected to have a value of "" in each D & F columns and expected that the yellow highlighted cells would not be "DIFF". The error occurs only when column B has "Yes".

I must be doing something wrong but have cleared the values and used the number format on the dates and checked everything I can think of. Help.

 

[jwoods1204]

Solved my own problem by testing for "" first in column F. Sorry for not including that formula - I thought I could attach my sheet. First time with Mr. Excel

Column H formula fixed:

=IF(AND(D2<>"",F2<>""),IF(AND(OR(B2="Yes",C2="Yes"),D2<>F2),"DIFF",""),"")

Sorry for the bother - do not know why the compare of two null cells formatted for date did not work.