How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete, Computer Engineer
Category: Programming
Satisfied Customers: 17900
Experience:  Over 16 years of experience in computer programming.
Type Your Programming Question Here...
Pete is online now
A new question is answered every 9 seconds

I have two separate CSV files of customers (let's call them

Customer Question

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 is in both Master List and Update List, then update the Group for that entry to "Member"
2) If a customer 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
Submitted: 2 years ago.
Category: Programming
Expert:  Pete replied 2 years ago.
Hi there,
please attach the files so I may carry out the work for you, or let me know if you would prefer me to connect remotely to your computer and carry out the work.