I'm a reporter in a state capital city who receives a daily email from the local jail of everyone who has been arrested that is quite long and in an Excel format. I also have a list of every lawmaker and statewide elected official. I want to compare the two lists on a daily basis to make sure our lawmakers aren't having too much fun. So my question is what function or formula would I need to compare the jailhouse list with the lawmaker list to see if there is a match in names? Once I have the function, I intend on writing a macros to make this a seamless exercise every day. Thanks for any help.