Excel 2007 : Comparing and matching data on two different spreadsheets

Hi,

I am trying to complete a mailing list, and want to match data from two spreadsheets.

Sheet1 contains a list of all my contacts, and Sheet2 contains a list of some of these contacts, the ones I do not want to include in my mailing. I basically want to remove all the contacts on Sheet2 from Sheet1, how do I do this?

Grateful for any help.

Thankfully I managed to get some help yesterday.

Both spreadsheets include a column each with unique IDs for each contact, which makes it easier to compare them.

I insterted a new column in Spreadsheet1 (the one with all contacts), next to the Contact ID column and used =VLOOKUP.

Lookup_value: First cell in the ContactID column of Spreadsheet1, "A1"
Table_array: Whole ContactID column of Spreadsheet2 (the one with the contacts I wanted to remove from Spreadsheet1), "[Spreadsheet2.xls]Sheet1'!$A$2:$A$147"
Col_index_num: 1
Range_lookup: FALSE

Code: =VLOOKUP(A2,[Spreadsheet2]Sheet1!$A$1:$A$106,1,FALSE)

This way I matched all the IDs from Spreadsheet2 with the ones in Spreadsheet1 and could then remove them from my mailing list.

Hopefully this will help someone else with the same issue like me!