Comparing 2 Excel spreadsheets to find missing records in one

[calvr1ch]

Hi

I have 2 spreadsheets with the same sort of items on. However book a has about 152 extra lines. is there a formula i can use to find out what is missing off book b? I have cut the files down as the file size was too large. There are approx 23000 lines of items. I need to match the NSN (Nato Numbers) and then the Description.

Thanks

Book A.xlsxBook B.xlsx

[alansidman]

In Book A in a column on Row 2, type

=VLOOKUP(B2,'[Book B.xlsx]Sheet1'!$B$2:$B$624,1,FALSE)

And copy down. Any value returned of #NA will indicate a missing NSN

Alan

[calvr1ch]

Hi Alan

Thanks for that its worked perfectly it has found 175 lines. Another question i have is:

I have inputted prices into Book b column G is there any way i can put the same price into book A column J related to the stock number or will it all have to be done manually?

Kind regards.

Richard

[alansidman]

Put this in row 2 of Book A column J and copy it down.

=VLOOKUP(B2,'[Book B.xlsx]Sheet1'!$B$2:$G$624,6,FALSE)

[calvr1ch]

Again a big thanks Alan

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.