Susan has attended:
Excel Advanced course
Find data.
Hi,
I have an issue with excel and hoping there's a quick solution.
I have listed about 6000 email address's on an excel spreadsheet to use to send out a series of group emails.
Our outlook has failed for most of these and as a result only 278 emails were sent out.
I have these 278 emails on a seperate spreasheet.
Is there a way of searching for these 278 email address's on the seperate spreadsheet of 6000, to avoid me sending a duplicate email.
Please advise as I urgently need to send it out.
Many thanks,
Susan.
RE: find data.
Hi Susan,
Thank you for your question. What I would suggest is to create a vlookup formula on the sheet with the 6000 addresses, starting in the same row as the first address. In the vlookup, you use the first address in the sheet with 6000 as your lookup value. The table array will be the list of 278 addresses. The column index number is 1 because your table array only consists of one column. Range lookup is false, as you want to find exact matches.
When you copy the vlookup down the column, the 278 email addresses will show up as results inbetween the #N/A results. Now you can use a filter to hide all #N/A results, and you will be left with the 278 emails which failed to send.
I hope this is helpful.
Kind regards
Marius Barnard
Excel Trainer
