IF Function

[alexb77]

Hey guys,

Need a bit of help putting together an IF Function.

I have multiple entries which I want to cross reference for differences. For the time being, I want to compare 2 entries for difference or to see whether they match.

There needs to be 2 parts to this IF formula which I'm having trouble putting together. A2 and A3 will be comparing the entry number, therefore if A2 and A3 match, it needs to be marked as MATCH, whereas if they are A2 doesn't match A3 then it needs to be marked as FALSE.

However, there needs to be a second part to say that if A2 and A3 match then it will compare B2 and B3 to see if there is a MATCH or be marked as FALSE. Whereas, if A2 and A3 do not match at all then regardless of B2 and B3 matching then it will be marked as FALSE.

I have gotten to the following however, it does not take the above principle into consideration.

=IF(AND(B2="",B3=""),"MATCH", IF(A2<>A3,FALSE,IF(AND(OR(B2="",B3="",B2=B3),B2&B3<>""),"MATCH",FALSE)))

Any help would go a long way.

 

[Eric W]

Welcome to the forum.

Maybe:

=IF(A2=A3,IF(OR(COUNTA(B2:B3)<2,B2=B3),"MATCH"))

or

=IF(A2=A3,IF(OR(B2="",B3="",B2=B3),"MATCH"))

 

[Joe4]

So, you only want to return "MATCH" in A2 and A3 match, and B2 and B3 match? Is that correct?

If so, then just use:

=IF(AND(A2=A3,B2=B3),"MATCH",FALSE)

 

[alexb77]

Hey guys,

Thanks for the help.

I have just tried those out and got it to work.