On 26 Jan, 00:36, reganbrown
wrote:
I have two Excel spreadsheets that I wish to merge. One list has about 2600
names, the other about 800. The matching key is "user ID" How do I find the
matches between the two spreadsheets and how do I find the exceptions? The
fields are basic, first name, last name, used ID, and email address. Any
sugestions would be very helpful and save me from having to merge them
together and go line by line to figure it out.

Thanks

Your best solution would be to use the VLOOKUP function. For an
explanation of how it works, try this link:-

http://teachr.blogspot.com/2006/07/v...ermediate.html

Basically the VLOOKUP function will allow you to lookup values in one
list against another. If there's any other help you need please let me
know.

Regards,
Matt Richardson
http://teachr.blogspot.com