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

jwoods1204

New Member
Joined
Jan 27, 2021
Messages
2
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
The worksheet Total Funds Check has a compare IF statement in column H based on the formula results in columns D & F

1611766867262.png


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.
 

Some videos you may like

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
Joined
Jan 27, 2021
Messages
2
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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:
Solution

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top