Synchronizing data sets or one of these records is not like the other, a fancy word for Match

[Lucreziazule]

Hello,</SPAN>
I’m trying to synchronize two sets of records on two separate tabs. The data has been imported from two different locations to two different tabs within one workbook to verify the records match. After all the clean up and restructuring so the columns are in the same order and sorted by unique ID..yada yada, I need to make sure they match. Not just the same amount of records but that the records match all the way through from Column A to Column P.
</SPAN>
I’ve tried the formula Match: =MATCH(A3,RPRT!$A$3:$A$400,0). This worked to match the unique Cient ID’s but now that I have to move further across the record, I’m having trouble adding the requirement of checking the unique CLIENT ID to make sure it is checking the right record begin with. I tried to write the formula plainly so I can see what I need or get some ideas. Here goes:
</SPAN>
"If client ID matches, move on to the next cell, match, if not return zero”</SPAN>

Here is an example of what I have in each tab and I need to make sure they match. SO I would need some kind of indicator that the zip code and the Number of contacts do not match. This is a small portion of the record, I will have do this monthly with over 300 records. </SPAN>
Tab RPRT: </SPAN>

Client ID</SPAN>	Case worker</SPAN>	Client Zip</SPAN>	Num of Contacts</SPAN>	Gender</SPAN>
03-13-LP-3333</SPAN>	Lou Peabody</SPAN>	92113</SPAN>	7</SPAN>	F</SPAN>

<TBODY>
</TBODY>

Tab MCL: </SPAN>

Client ID</SPAN>	Case worker</SPAN>	Client Zip</SPAN>	Num of Contacts</SPAN>	Gender</SPAN>
03-13-LP-3333</SPAN>	Lou Peabody</SPAN>	92114</SPAN>	8</SPAN>	F</SPAN>

<TBODY>
</TBODY>

Please let me know if I left any info out or if I can provide more information.
</SPAN>
Thanks in advance, </SPAN>

 

[LxQ]

Do you want a visual display or something you can sort? For example, 92114 doesn't match 92113, so do you want it to turn a different color, or do you want something in a different column so you can sort?

Visual display --write a formula in conditional formatting
Something in a different column --you can add something like this:
if Zip code is in column C:
=C3=Vlookup(A3,RPRT!$A$3:$C$400,3,)

This will either return a "TRUE" or a "FALSE"