find data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Find data.

Find data.

resolvedResolved · High Priority · Version 2010

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

Tue 16 Aug 2016: Automatically marked as resolved.

 

Training courses

 

Recommend training98.8 %
recommend us
More live stats...

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel articles

Please browse our web site to find out more about
training excel vba and other training courses.

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.07 secs.