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

#### jwoods1204

##### New Member
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.

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### jwoods1204

##### New Member
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:
Excel Formula:
``=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.

Last edited by a moderator:

Replies
16
Views
348
Replies
7
Views
176
Replies
1
Views
177
Replies
10
Views
151
Replies
6
Views
96

1,127,387
Messages
5,624,389
Members
416,026
Latest member
melvic69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back