IF AND Statements NOT WORKING...why?

[chloec]

Hi Can you please tell me why this IF/AND statement is not working?


=IF(AND(EXACT(E1,E2)="FALSE",VLOOKUP(A2,Tannery,2,FALSE)="YES"),A2,CONCATENATE(A2," - DNU"))


What I am trying to compute is: Evaluate if E1 and E2 are exact and Evaluate if they are on my tannery helper list. If they DO NOT MATCH and they ARE ON the Tannery List, then use the value in A2. Otherwise, just take the value of A2 and Concatenate "- DNU".


Problem:

For some reason, the formula EXACT(E1,E2)="FALSE" - always engages the Concatenate option. When I add that criteria into the formula is when things go downhill.


Can you please advise what it is I'm doing wrong!? Thank you!

 

[NARAYANK991]

Hi Chloe ,


The EXACT function returns TRUE if the two parameters match exactly , otherwise it returns FALSE. Comparing with a string value "FALSE" is not correct.


Use NOT(EXACT(E1,E2)) instead of EXACT(E1,E2)="FALSE"


You can check this out by entering the following formula in any unused cell : =TRUE="TRUE" ; you should get a FALSE displayed. =TRUE=TRUE will display TRUE.


Narayan

 

[chloec]

Fantastic. This worked like a charm, Narayan! Thanks again!