If I give you the formula here would you be able to adapt it to your data, or would you like to send me your file so I can set it up on it directly
Ok I will try.
Is your list in columns A and B starting from row 2?
Are they not on the same sheet? If not, paste them on the same sheet as follows.
The long list in column A, and the short list inn column B and let me know when you're done
Ok, copy the following formula and paste it in cell C2
Then select cells C2:C3701 and press Ctrl + D to fill it down
That should do it. Column C will now have the balance 3000 emails
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
I see you are on a Mac.
In that case just select cell C2 copy it. Then select cells C3:C3701 and paste it there
Ok please upload the file at www.wikisend.com (no need to sign up). You will then get a page that has the File ID and Download Link. Copy either the File ID or the Download Link and come back here and paste it in your reply.
Great! Thanks so much for the accept.
Please feel free to get back to me if you have any follow up questions