I have two separate CSV files of customers (let's call them Master List.csv and Update List.csv). There are two columns in Master List that I need to update, Email and Group.
Here's what I need to do in Excel:
1) If a customer's email is in both Master List and Update List, then update the Group for that entry to "Member"
2) If a customer's email is in only Update List but NOT Master List, add their email address to Master List and set the Group to Member for the entry