Try running a vlookup on one of the worksheets. Vlookup Column 1 of addresses and see if you get an error when you copy it down. I would first sort both in alphabetical order. This should give you an answer.