Forum Discussion
IF formula not returning matching text - how to correct?
Hey everyone - hitting a very odd problem with the IF formula. I'm trying to reconcile a new data source with an old data source so that I can remove everything in the old data source. The two different data sources use different language to reflect vendor status, but mean the same thing. I'm using two different equations to reconcile the language and then identify any changes. I'm currently using the "IF Formula" to convert the language: Using the equation =IF(D2="ACTIVE," "True," "False"), which works fine. But then I go and use the IF Formula again to compare the reconciled column with the vendor status to check changes =IF(B2=E2,"No Change", "Status Change") and the IF statement always returns a status change. As far as I can tell, it seems that the output in the Reconciliation is not considered the exact same text that appears in the vendor report. I have found a few work abouts, but I cannot figure out why it doesn't read the text correctly. Can anyone give me insight? Example below
| New Report Vendor Name | New Report Vendor Status | Old Report Vendor Name | Old Report Vendor Status | Reconciliation IF(Dx="ACTIVE", "True," "False") | Status Change? IF(Bx=Ex,"No Change", "Status Change") |
| Jon Doe LLC | True | Jon Doe Inc | ACTIVE | True | Status Change |
| FakeCorpV2 | False | FakeCorpOG | NonActive | False | Status Change |
| Salesby | False | ShopIt | ACTIVE | True | Status Change |
3 Replies
That worked! Do you have an understanding why the IF statement does not work?
Thank you!
Your formula returned "True" and "False" as text values; those are not the same as the TRUE and FALSE returned by the formula that I proposed. Column B must contain TRUE and FALSE.
