comparing two mailing lists

[rtwhbw123]

Board,
I tried to search function, but it keep telling me there wasn't any results so I am posting here for help.

I have two sheets, each has a list of mailing addresses (first name - column A, last night - column B, address - column C, city - column D, state - column E, and zip - column F).

I would like to compare list 1 to list 2 to see what entries (rows) are not in list 1, but are in list 2.

Any advice, I have tried MATCH and VLOOKUP, but I don't get any results showing the entries from list 2 are in list 1, even though I know many are.

Here is the formula - =VLOOKUP(C2, sdp_list,1,FALSE)

sdp_list refers to the list of mailing addresses in sheet 1 (column C:F)

Not sure why vlookup is not working.
Thanks
RTW

 

[rtwhbw123]

Dang it! There was a blank space at the end of one of the address lists, ie - "123 Main Street ". Removed that and VLOOKUP did it's work!
Check to make sure there are no blank spaces in your cells that could through off the formulas.