Hoping someone can help, I'm pretty sure there must be an easy way to do this!
I've got 2 sheets with a crossover in data I need to consolidate:
sheet 1 has 2000 contacts, email and order ID's
sheet 2 has 5000 contacts (original 2000 contained within the 5k) and email (no order ID's)
I want to get the order ID's into sheet 2 and email is obviously the common thread between them. I can try sorting them and manually doing it but that'd be pretty time-consuming, I'm presuming there's a better way?
I've got 2 sheets with a crossover in data I need to consolidate:
sheet 1 has 2000 contacts, email and order ID's
sheet 2 has 5000 contacts (original 2000 contained within the 5k) and email (no order ID's)
I want to get the order ID's into sheet 2 and email is obviously the common thread between them. I can try sorting them and manually doing it but that'd be pretty time-consuming, I'm presuming there's a better way?