Matching a value to a list of values

**s.w** · 12-12-2007, 10:34 AM

Hi guys,
I have got 2 lists of data and am trying to find the items on the second list that dont match those on the first list. Each of the items on both of the lists has a unique ID number, so basically I want to try and find the ID numbers on the second list that are not on the first list. Is there an easy/quick way to do this?

**NBVC** · 12-12-2007, 10:41 AM

So if the ID's in the first list are in say column A and ID's in the second list are in column X....

then in a column near column X enter formula: =IF(Countif(A:A,X1),"","No Match Found") where X1 is the first ID to match... copy formula down.