Please fix my IF statement

[hawilder]

Hello - I am I have 4 columns of data - 2 sets of first names and 2 sets of last names that I combined from 2 different files. I want to insert an IF statement that tells me of all the first and last names that do not match:

ie:

<table width="256" border="0" cellpadding="0" cellspacing="0"><col width="64" span="4"><tr height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">HOLLY</td> <td style="width: 48pt;" width="64">TEFFT</td> <td style="width: 48pt;" width="64">HOLLY</td> <td style="width: 48pt;" width="64">WILDER</td> </tr></table><table width="64" border="0" cellpadding="0" cellspacing="0"><col width="64"><tr height="20"> <td style="height: 15pt; width: 48pt;" width="64" align="center" height="20">FALSE</td> </tr></table>
=IF(A1=C1,IF(B1=D1,"YES"),"NO")

I am getting "false" after the second or third row down...??


I am comparing thousands of names so it would be helpful If I can get this right if you know of a better way... THANKS!!

 

[hallingh]

Try

=IF(AND(A1=C1, B1=D1), "True", "False")

 

[hawilder]

Hallelujah hallingh Thank you!!!!!

 

[Dave Patton]

a little more efficient and concise

=AND(A1=C1, B1=D1)

 

[hawilder]

Nice!! thank you.