Tricks

Trick One: 

In Excel, Compare two columns to identify matches: 

=IF(ISERROR(MATCH(A1,$D$1:$D$4,0)),"No Match",A1)

First instance of A1 = first cell in the first column you're looking at

,$D$1:$D$4 = Change to the range of the 2nd column you're looking at

Second instance of A1 = Value you want shown in the audit column

in the example below, the Match Found column is populated with the formula above:

ID	Type	Match found?	ID list
735254790	D	735254790	735254790
155674768	D	No Match	467528922
454555653	D	No Match	602117840
980909522	D	980909522	980909522