Compare/Match data from 2 sources

This is my first post. Please let me know if this is not clear. I have data from 2 sources. I need to match the id's from both tabs and see what doesn't have a match. Thank you in advance.

You could use this formula in cell D2 of the ACH sheet:

=IF(COUNTIF(ST!A:A,A2),"matches","absent")

Copy down tothe bottom of your data. You can use a very similar formula in cell L2 of the ST sheet:

=IF(COUNTIF(ACH!A:A,A2),"matches","absent")

Again, copy down as required.

Hope this helps.

Pete