I have two lists that are pretty much the same (Look at 1st tab on each sheet for COMPLETE list) but were compiled and worked at different times. I need to merge the two lists, preserving all data fields so there is only ONE entry for each Agent. About half already have e-mails, the other half (about 950, if it is much more than that, let me know and I will pay extra at rate of $10 per extra hundred over 1000 lookups) need the e-mail address for the named individual within the named Agency. Please organize into a single, comprehensive list. THANKS!