I have two lists of data - one is email addresses and ID numbers from our old database system, the other is email addresses with ID numbers from our new database system. The lists are not exactly the same and have enough differences to make this a pain to do manually. I basically want to find any matching email addresses between the two lists and return the corresponding old and new ID numbers for that person. Any suggestions? Thank you.
Bookmarks