Combining/Comparing Excel Files

[richkoi]

I exported my item codes from Quickbooks into Excel. I am trying to find out which items that I do not have codes for.

I have two tables in Excel:

1) Imported Excel Item Code Table from Quickbooks
2) List of ALL items with approprate codes

How can I find out which codes from the SECOND table need to be added into Quickbooks? I don't want to import the second table straight into Quickbooks because then I would have hundreds of duplicates. How can I merge/remove duplicates from two Excel files?

Thanks,

Rich

[steve0]

With a database that would be a breeze.. but..
it is a spreadsheet so things get a little more tricky..

Check out the function VLOOKUP in Excel...

It may take a few cups of coffee.. but it should work.

[richkoi]

Thanks steve0, I'll mess around with that...haven't used VLOOKUP since my first and only Excel class.

Rich