Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Finding data not in the second list

  Asked By: Cesar    Date: Jan 09    Category: MS Office    Views: 664
  

I have got tow lists of data with account numbers in. Does anyone
have any
suggestions of how I can use VBA code to cross-match both lists and
then produce a third
list of account numbers in the first list but not in the second list?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Timothy Patterson     Answered On: Jan 09

I'm a bit blonde today but I don't think you need VBA to do this.... Maybe
others can jump in please?

 
Answer #2    Answered By: Jezza Brown     Answered On: Jan 09

Why not just do a vlookup on each list  against the other? For example, if one
list begins in A1 on Sheet1, and the other list begins in A1 on Sheet2, you
could enter this formula in B1 on Sheet1:

=VLOOKUP(A1,Sheet2!A:A,1,FALSE)

and this formula in B1 on Sheet2:

=VLOOKUP(A1,Sheet1!A:A,1,FALSE)

On both sheets, copy the formula down for as many rows as you have data. The
formulas which return #N/A are the records not found on the other list. You can
sort by column B to put all the #N/A together.

 
Didn't find what you were looking for? Find more on Finding data not in the second list Or get search suggestion and latest updates.




Tagged: